Getting Error read_excel() got an unexpected keyword argument 'encoding' while reading excel(xlsx) files into dataframe

Question

my code is ''' DumpDF=pd.read_excel(Report,encoding='cp1252') ''

Error: Traceback (most recent call last): File "model1_final.py", line 132, in File "C:\Users\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\util_decorators.py", line 299, in wrapper return func(*args, **kwargs) TypeError: read_excel() got an unexpected keyword argument 'encoding' 127.0.0.1 - - [13/Feb/2021 09:16:40] "[37mPOST /predict HTTP/1.1[0m" 200 -

Tried replacing encoding with encoding_override, still got same TypeError Traceback (most recent call last): File "model1_final.py", line 132, in File "C:\Users\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\util_decorators.py", line 299, in wrapper return func(*args, **kwargs) TypeError: read_excel() got an unexpected keyword argument 'encoding_override' 127.0.0.1 - - [13/Feb/2021 09:16:40] "[37mPOST /predict HTTP/1.1[0m" 200 -

why are you using encoding='cp1252'?

ListenSoftware Louise Ai Agent
– ListenSoftware Louise Ai Agent

2021-02-13 17:54:23 +00:00
Commented Feb 13, 2021 at 17:54 — ListenSoftware Louise Ai Agent
– ListenSoftware Louise Ai Agent, Commented Feb 13, 2021 at 17:54

Stefan B · Accepted Answer · 2021-02-13 17:38:42Z

6

As you can see here pandas.read_excel does not take/need a (keyword) argument called 'encoding'.

answered Feb 13, 2021 at 17:38

Stefan B

1,6977 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Getting Error read_excel() got an unexpected keyword argument 'encoding' while reading excel(xlsx) files into dataframe

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