"Number of passed names did not match number of header fields in the file" Error while using read_excel in Pandas

Question

Getting this exception while using read_excel function in pandas.

I am trying to fetch columns based on the column labels in the header. And getting this error. Can anyone tell me where I am going wrong.

Here's the function:

pd.read_excel(myexcel.xlsx, sheet_name = 'sheet1', names = ['company name', 'service provided'], header = 1)

Getting the following error when I run it:

"Number of passed names did not match number of header fields in the file"

Header is 0 indexed, pass in header = 0 and drop the names kwarg. — GhandiFloss
– GhandiFloss, Commented Sep 1, 2020 at 8:26
The 'names' parameter is used for setting the column names other than that is existing in excel (or setting the column names when excel does not have header row). For this to be successfully, the number of items passed against 'names' should be equal to the number of columns the read_excel reads. This can be corrected either by using 'usecols' parameter which selects only 2 (in your case) columns or by making sure the number of items in the names parameter is equal to the columns with data in the sheet 'sheet1'. — Pramod B R
– Pramod B R, Commented Feb 8 at 4:26

Shilpa Shinde · Accepted Answer · 2021-07-01 05:14:23Z

1

pd.read_excel(myexcel.xlsx, sheet_name = 'sheet1', usecols = ['company name', 'service provided'], header = 1)

answered Jul 1, 2021 at 5:14

Shilpa Shinde

1,0049 silver badges10 bronze badges

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

1 Comment