python如何读取数据时出现错误_从.xls fi读取数据时发生Python错误

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