|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
本帖最后由 yywwf2003 于 2021-1-18 10:12 编辑
如图,网上按别人的代码对着输入的,别人的行,为什么到自己就出错了,说第六行出错了,跪求大佬帮解答一下,非常感谢!!!
- import os
- import pandas as pd
- files = os.listdir("练习文件夹")
- new_list = []
- for i in files:
- new_list.append(pd.read_excel("练习文件夹\" + i))
- res = pd.concat(new_list)
- res.to_excel("结果文件.xlsx",index=False)
复制代码
E:\pythonProject\venv\Scripts\python.exe E:/pythonProject/test.py
Traceback (most recent call last):
File "E:/pythonProject/test.py", line 6, in <module>
new_list.append(pd.read_excel("练习文件夹\\" + i))
File "E:\pythonProject\venv\lib\site-packages\pandas\util\_decorators.py", line 299, in wrapper
return func(*args, **kwargs)
File "E:\pythonProject\venv\lib\site-packages\pandas\io\excel\_base.py", line 336, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "E:\pythonProject\venv\lib\site-packages\pandas\io\excel\_base.py", line 1074, in __init__
import_optional_dependency(
File "E:\pythonProject\venv\lib\site-packages\pandas\compat\_optional.py", line 115, in import_optional_dependency
version = _get_version(module)
File "E:\pythonProject\venv\lib\site-packages\pandas\compat\_optional.py", line 56, in _get_version
raise ImportError(f"Can't determine version for {module.__name__}")
ImportError: Can't determine version for openpyxl
Process finished with exit code 1
File "E:\pythonProject\venv\lib\site-packages\pandas\compat\_optional.py", line 56, in _get_version
raise ImportError(f"Can't determine version for {module.__name__}")
ImportError: Can't determine version for openpyxl
你打开【_optional.py】看一下【56行】源代码导入了什么!
|
|