how to remove header from excel file using python

Question

experts, i want to remove a very first row from excel file using python. I am sharing a a screen print of my source excel file

i want out put as

I am using below python code to remove first row from excel but when i am reading it as data frame and printing that i am observing that data in data frame is being read as shown in below screen print

and the code which i am using is

import pandas as pd
import os
def remove_header():
 file_name = "AV Clients.xlsx"
 os.chmod(file_name, 0o777)
 df = pd.read_excel(file_name) #Read Excel file as a DataFrame
 #df = df.drop([0])
 print(df)
 #df.to_excel("AV_Clients1.xlsx", index=False)

remove_header()

Please suggest how i can remove a very first row from excel file whose screen print i have shared at top. Thanks in advance Kawaljeet

See skiprows pandas.pydata.org/pandas-docs/stable/reference/api/… — ALollz
– ALollz, Commented Apr 29, 2020 at 18:39

Saurabh Kansal · Accepted Answer · 2020-04-29 18:43:55Z

3

Just add skiprows argument while reading excel.

import pandas as pd
import os
def remove_header():
    file_name = "AV Clients.xlsx"
    os.chmod(file_name, 0o777)
    df = pd.read_excel(file_name, skiprows = 1) #Read Excel file as a DataFrame
    print(df)
    df.to_excel("AV_Clients1.xlsx", index=False)

remove_header()

answered Apr 29, 2020 at 18:43

Saurabh Kansal

7027 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to remove header from excel file using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related