import pandas as pd
pd.set_option('display.unicode.east_asian_width', True)
df = pd.read_excel('一月.xlsx')
print(df.head())
D:\Python\系统\python.exe D:/Python/python-practice/Pandas操作/xlsx.py
Traceback (most recent call last):
File "D:/Python/python-practice/Pandas操作/xlsx.py", line 3, in <module>
df = pd.read_excel('一月.xlsx')
File "D:\Python\系统\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
return func(*args, **kwargs)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
io = ExcelFile(io, engine=engine)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__
self._reader = self._engines[engine](self._io)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_xlrd.py", line 22, in __init__
super().__init__(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 353, in __init__
self.book = self.load_workbook(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_xlrd.py", line 37, in load_workbook
return open_workbook(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported
Process finished with exit code 1
import pandas as pd
pd.set_option('display.unicode.east_asian_width', True)
df = pd.read_excel('一月.xlsx')
print(df.head())
D:\Python\系统\python.exe D:/Python/python-practice/Pandas操作/xlsx.py
Traceback (most recent call last):
File "D:/Python/python-practice/Pandas操作/xlsx.py", line 3, in <module>
df = pd.read_excel('一月.xlsx')
File "D:\Python\系统\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
return func(*args, **kwargs)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
io = ExcelFile(io, engine=engine)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__
self._reader = self._engines[engine](self._io)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_xlrd.py", line 22, in __init__
super().__init__(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_base.py", line 353, in __init__
self.book = self.load_workbook(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\pandas\io\excel\_xlrd.py", line 37, in load_workbook
return open_workbook(filepath_or_buffer)
File "D:\Python\系统\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
好像是不支持这个格式