错误：不支持的格式，或损坏的文件：需要BOF记录

Question

import xlrd
book = xlrd.open_workbook("file.xlsx")
print "The number of worksheets is", book.nsheets
print "Worksheet name(s):", book.sheet_names()
print

sh = book.sheet_by_index(0)

print sh.name, sh.nrows, sh.ncols
print

print "Cell D30 is", sh.cell_value(rowx=29, colx=3)
print

for rx in range(5):
    print sh.row(rx)
    print

raise XLRDError('Unsupported format, or corrupt file: ' + msg)
xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found    '\xff\xfeT\x00i\x00m\x00'

Answer 1

如果使用read_excel()读取.csv，将得到错误

XLRDERROR：不支持的格式，或损坏的文件：应为BOF记录；

要读取.csv，需要使用read_csv()，如下所示

df1= pd.read_csv("filename.csv")