时间戳

首页 > 解决方案 > 如何修复这些错误消息，以便我可以在 pandas 中读取这些 excel 文件？

python - 如何修复这些错误消息，以便我可以在 pandas 中读取这些 excel 文件？

问题描述

我正在尝试读取一些 excel 文件，但它们似乎有格式错误。当我尝试读取文件并且不知道如何修复这些错误消息时，我无法理解这些错误消息。请帮忙。

我尝试阅读我刚刚创建的新 Excel 文档并且没有任何问题。 

df = pd.read_excel('2013-ID19.xls', index_col=0)
print(df.head())


File "exportDataToPandas.py", line 7, in <module>
    pd.read_excel('2013-ID19.xls', index_col=0)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/pandas/util/_decorators.py", line 178, in wrapper
    return func(*args, **kwargs)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/pandas/util/_decorators.py", line 178, in wrapper
    return func(*args, **kwargs)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/pandas/io/excel.py", line 307, in read_excel
    io = ExcelFile(io, engine=engine)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/pandas/io/excel.py", line 394, in __init__
    self.book = xlrd.open_workbook(self._io)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/xlrd/__init__.py", line 157, in open_workbook
    ragged_rows=ragged_rows,
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/xlrd/book.py", line 92, in open_workbook_xls
    biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/xlrd/book.py", line 1278, in getbof
    bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos+8])
  File "/Users/cj/anaconda3/lib/python3.7/site-packages/xlrd/book.py", line 1272, in bof_error
    raise XLRDError('Unsupported format, or corrupt file: ' + msg)
xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'<table><'

标签： pythonpandas

解决方案

您可能以错误的格式保存了文件。打开xls文件并另存为.csv。原始文件中的某些内容已损坏。

推荐阅读