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, Mar 13 '20 at 05:26
i'd suggest you open the file in excel and scroll to line 1187 (since that is what is being referenced in the error message) and see if u can decipher why the error is so. alternatively, try reading the data directly via xlrd and see if it gives the same error. it is possible that one of the sheets (sheet_name=None implies u r reading in all the sheets) has an issue, or something is there that messes up the structure. — sammywemmy, Mar 13 '20 at 06:27

Vijesh · Answer 1 · 2020-03-13T06:07:06.333

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 '20 at 06:07

answered Mar 13 '20 at 05:25

Vijesh

795
3
9
23

i have upgraded the ``` XLRD``` but still not working – dominic tanui Mar 13 '20 at 05:48
Could you tell me you pandas version: you can get it using, `print(pd.__version__)` - @dominictanui – Vijesh Mar 13 '20 at 06:01
the pandas version is 0.25.3 – dominic tanui Mar 13 '20 at 06:08
I have reinstall all, but invain – dominic tanui Mar 13 '20 at 06:29
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](https://stackoverflow.com/a/65266497/812102). – Skippy le Grand Gourou Feb 08 '21 at 13:28

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

1 Answers1