Error in read a .xlsx file using the pandas Library in Python?

Question

I have problem in reading excel file from location.

Error

File "c:\users\dominic\appdata\local\programs\python\python37-32\lib\site-packages\xlrd\__init__.py", line 1187
    print "EXTERNSHEET(b7-):"
                            ^
SyntaxError: invalid syntax

Syntax

import pandas as pd

df = pd.read_excel('DumpData 2.xlsx', sheet_name=None)

Kindly help to resolve the problem above

The print statement is replaced with the print function in Python3, this looks to be causing the issue. — Keelan Pool
– Keelan Pool, Commented Mar 13, 2020 at 5:26

Vijesh · Accepted Answer · 2020-03-13 06:07:06Z

2

You can try below syntax for python-3:

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx', sheet_name='your Excel sheet name')
print (df)

Also, you can try to upgrade the XLRD for python-3

python3 -m pip install --upgrade xlrd

I have Python 3 and Pandas 0.23.4 and it's working fine. Just check your pandas version using print(pd.__version__) and try to upgrade it.

If it doesn't work try to reinstall the pandas & XLRD module using pip

edited Mar 13, 2020 at 6:07

answered Mar 13, 2020 at 5:25

Vijesh

8153 gold badges10 silver badges24 bronze badges

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

5 Comments

dominic tanui Over a year ago

i have upgraded the ``` XLRD``` but still not working

Vijesh Over a year ago

Could you tell me you pandas version: you can get it using, print(pd.__version__) - @dominictanui

dominic tanui Over a year ago

the pandas version is 0.25.3

dominic tanui Over a year ago

I have reinstall all, but invain

Skippy le Grand Gourou Over a year ago

Upgrading XLRD fixed the error, only for it to be replaced by another error : XLRDError: Excel xlsx file; not supported… Which can be fixed by specifying another engine.

Collectives™ on Stack Overflow

Error in read a .xlsx file using the pandas Library in Python?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related