裂开了,为啥我的pandas报错了啊

Traceback (most recent call last):
File "E:\pythonProject\755.py", line 2, in
df = pd.read_excel('didi1',index_col=0) # 即指定第一列为行索引
File "H:\lib\site-packages\pandas\util_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "H:\lib\site-packages\pandas\io\excel_base.py", line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "H:\lib\site-packages\pandas\io\excel_base.py", line 1191, in init
ext = inspect_excel_format(
File "H:\lib\site-packages\pandas\io\excel_base.py", line 1070, in inspect_excel_format
with get_handle(
File "H:\lib\site-packages\pandas\io\common.py", line 710, in get_handle
handle = open(handle, ioargs.mode)
FileNotFoundError: [Errno 2] No such file or directory: 'didi1'

Process finished with exit code 1

解决办法,1.升级pandas,2.pip安装openpyxl,3.然后在read_excel()添加参数,engine='openpyxl‘读取表格

读入的excel没有后缀名么?
报错是说找不到要读入的文件

img

检查一下对应文件是否存在
有帮助望采纳

代码没找到这个文件,是不是路径有问题

在pd.read_excel()中"didi1"加上后缀试试