How to read a excel file without taking its first row as header ? Pandas, Python

Question

The excel

  A      B      C   
1 apple  tometo grape
2 beer   wine   juice

Reading by pandas, the first row will be the columns of DataFrame.

  apple  tometo grape
0 beer   wine   juice

How can I read the excel like this:

  0      1      2
0 apple  tometo grape
1 beer   wine   juice

score 2 · Accepted Answer · edited Jan 18 '20 at 04:51

2

The file can be read using the file name as string or an open file object:

pd.read_excel('test.xlsx', index_col=0)

if you want to read particular sheet.

pd.read_excel(open('test.xlsx', 'rb'),sheet_name='Sheet3')

Index and header can be specified via the index_col and header arguments

pd.read_excel('test.xlsx', index_col=None, header=None)

edited Jan 18 '20 at 04:51

Nick

123,192
20
49
81

answered Jan 18 '20 at 03:53

Jay Kakadiya

473
1
5
12

Hey Jay, ```pd.read_excel('test.xlsx', index_col=None, header=None)``` solved my question, thanks! – Steve Hsu Jan 18 '20 at 04:05

Emrah Diril · Answer 2 · 2020-01-18T04:01:49.737

1

First answer on google when you search for "pandas read excel file skip header": Pandas doc for method read_excel which has a skiprows argument to achieve what you like

Since your excel file has no header row, you should use header=None

edited Jan 18 '20 at 04:01

answered Jan 18 '20 at 03:28

Emrah Diril

1,552
1
18
25

Hey Emrah, thanks for helping. I've tried it already, ```skiprows``` just omit row, what I want is having a new row as the label of each col. – Steve Hsu Jan 18 '20 at 03:36
Sorry I misunderstood what you were asking, I updated my answer – Emrah Diril Jan 18 '20 at 04:02

How to read a excel file without taking its first row as header ? Pandas, Python

2 Answers2