Pandas Excel to DF throwing the unexpected keyword argument 'index' Error

Question

Importing Excel into a Pandas DataFrame without the Index giving me this error

TypeError: read_excel() got an unexpected keyword argument 'index'

As far as I can see, I am not doing any thing wrong here

import pandas as pd
df = pd.read_excel('Prod_User.xlsx', sheet_name='PROD', index=False)
print(df)

but getting the error! What might I be doing wrong here?

index parameter is not a valid argument for the read_excel() function, see pandas.pydata.org/docs/reference/api/pandas.read_excel.html — Sauron
– Sauron, Commented Sep 27, 2023 at 14:31
@wander95 I believe that's the Python default error; it can be interpreted as "the called function is not of correct type" — Quang Hoang
– Quang Hoang, Commented Sep 27, 2023 at 14:37

Diego Borba · Accepted Answer · 2023-09-28 14:36:29Z

3

The read_excel function in Pandas does not take an argument Index. You can specify the index column using the index_col argument. This can be used to specify the row labels. The default value for this argument is none so from your example I don't think you need to use it. If you have an index column that you are trying to omit from the excel sheet you could use the "usecols" argument to specify what columns you would like to read. Please see Documenation for more info!

Hope this helps!

edited Sep 28, 2023 at 14:36

Diego Borba

2,4356 gold badges15 silver badges29 bronze badges

answered Sep 27, 2023 at 14:34

ofrench

412 bronze badges

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

Collectives™ on Stack Overflow

Pandas Excel to DF throwing the unexpected keyword argument 'index' Error

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