Python Error when reading data from .xls file

Question

I need to read a few xls files into Python.The sample data file can be found through Link:data.file. I tried:

import pandas as pd
pd.read_excel('data.xls',sheet=1)

But it gives an error message:

ERROR *** codepage 21010 -> encoding 'unknown_codepage_21010' -> LookupError: unknown encoding: unknown_codepage_21010 Traceback (most recent call last):

File "", line 1, in pd.read_excel('data.xls',sheet=1)

File "C:\Anaconda3\lib\site-packages\pandas\io\excel.py", line 113, in read_excel return ExcelFile(io, engine=engine).parse(sheetname=sheetname, **kwds)

File "C:\Anaconda3\lib\site-packages\pandas\io\excel.py", line 150, in init self.book = xlrd.open_workbook(io)

File "C:\Anaconda3\lib\site-packages\xlrd__init__.py", line 435, in open_workbook ragged_rows=ragged_rows,

File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 116, in open_workbook_xls bk.parse_globals()

File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 1170, in parse_globals self.handle_codepage(data)

File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 794, in handle_codepage self.derive_encoding()

File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 775, in derive_encoding _unused = unicode(b'trial', self.encoding)

File "C:\Anaconda3\lib\site-packages\xlrd\timemachine.py", line 30, in unicode = lambda b, enc: b.decode(enc)

LookupError: unknown encoding: unknown_codepage_21010

Anyone could help with this problem?

PS: I know if I open the file in windows excel, and resave it, the code could work, but I am looking for a solution without manual adjustment.

Its not only pandasc issue. others have same problem

Marcin
– Marcin

2015-03-26 03:18:50 +00:00
Commented Mar 26, 2015 at 3:18 — Marcin
– Marcin, Commented Mar 26, 2015 at 3:18

Amrita Sawant · Accepted Answer · 2015-03-26 06:29:55Z

2

using the ExcelFile class, I was successfully able to read the file into python. let me know if this helps!

    import xlrd
    import pandas as pd

    xls = pd.ExcelFile(’C:\data.xls’)
    xls.parse(’Index Constituents Data’, index_col=None, na_values=[’NA’])

answered Mar 26, 2015 at 6:29

Amrita Sawant

11k4 gold badges25 silver badges26 bronze badges

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

1 Comment

SVK Over a year ago

Looks like you haven't used xlrd in the code here however you imported it.

SVK · Accepted Answer · 2019-11-15 21:23:26Z

2

The below worked for me.

import xlrd


my_xls = xlrd.open_workbook('//myshareddrive/something/test.xls',encoding_override="gb2312")

answered Nov 15, 2019 at 21:23

SVK

1,03413 silver badges25 bronze badges

1 Comment

user1633272 Over a year ago

Do you know how to convert my_xls into DataFrame?

Collectives™ on Stack Overflow

Python Error when reading data from .xls file

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related