|
小白求助,各位大佬,使用pandas进行数据分析的时候出现了这个问题,不知道是哪方面的原因,求解答!!
import pandas as pd
df = pd.read_excel('F:\订单.xlsx')
print(df)
输出:[size=13.0667px]F:\py中文\pythonProject\venv\Scripts\python.exe F:/py中文/pythonProject/001.pyTraceback (most recent call last): File "F:/py中文/pythonProject/001.py", line 3, in <module> df = pd.read_excel('F:\订单.xlsx') File "F:\py中文\pythonProject\venv\lib\site-packages\pandas\util\_decorators.py", line 311, in wrapper return func(*args, **kwargs) File "F:\py中文\pythonProject\venv\lib\site-packages\pandas\io\excel\_base.py", line 364, in read_excel io = ExcelFile(io, storage_opti**=storage_opti**, engine=engine) File "F:\py中文\pythonProject\venv\lib\site-packages\pandas\io\excel\_base.py", line 1233, in __init__ self._reader = self._engines[engine](self._io, storage_opti**=storage_opti**) File "F:\py中文\pythonProject\venv\lib\site-packages\pandas\io\excel\_openpyxl.py", line 521, in __init__ import_optional_dependency("openpyxl") File "F:\py中文\pythonProject\venv\lib\site-packages\pandas\compat\_optional.py", line 118, in import_optional_dependency raise ImportError(msg) from NoneImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl.进程已结束,退出代码1
|
|