解决“ImportError: Missing optional dependency ‘pytables‘. Use pip or conda to install pytables.”问题

我用的是python3.8,我在论坛里看到有人提到python3.8.2版本pip里没有pytables。

所以是下载tables解决的:

pip install tables

我测试过使用conda下载pytables也可以:

conda install pytables

踩坑经历:

这里我说一个我踩过的坑,我遇到过安装成功tables但执行代码依旧会提示找不到这个模块,网上也有很多解决方案,但我提醒一下,一定一定要先排除掉安装tables的虚拟环境与执行代码的虚拟环境是否一致!!!

pycharm中的pandas报错分析并解决:Traceback (most recent call last): File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\compat\_optional.py", line 135, in import_optional_dependency module = importlib.import_module(name) File "D:\BaiduNetdiskDownload\Python软件包\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 984, in _find_and_load_unlocked ModuleNotFoundError: No module named 'openpyxl' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "D:\DOCUMENTS\python-fxxk-spider\pythonProject\main.py", line 3, in <module> data = pa.read_excel("D:\DOCUMENTS\python-fxxk-spider\pythonProject\祖彪规划.xlsx") File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_base.py", line 495, in read_excel io = ExcelFile( File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_base.py", line 1567, in __init__ self._reader = self._engines[engine]( File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_openpyxl.py", line 552, in __init__ import_optional_dependency("openpyxl") File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\compat\_optional.py", line 138, in import_optional_dependency raise ImportError(msg) ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl.
最新发布
03-18
在pycharm中执行pandas读取excel报错:Traceback (most recent call last): File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\compat\_optional.py", line 135, in import_optional_dependency module = importlib.import_module(name) File "D:\BaiduNetdiskDownload\Python软件包\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 1030, in _gcd_import File "<frozen importlib._bootstrap>", line 1007, in _find_and_load File "<frozen importlib._bootstrap>", line 984, in _find_and_load_unlocked ModuleNotFoundError: No module named 'openpyxl' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "D:\DOCUMENTS\python-fxxk-spider\pythonProject\main.py", line 3, in <module> data = pa.read_excel("D:\DOCUMENTS\python-fxxk-spider\pythonProject\祖彪规划.xlsx") File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_base.py", line 495, in read_excel io = ExcelFile( File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_base.py", line 1567, in __init__ self._reader = self._engines[engine]( File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\io\excel\_openpyxl.py", line 552, in __init__ import_optional_dependency("openpyxl") File "D:\BaiduNetdiskDownload\Python软件包\lib\site-packages\pandas\compat\_optional.py", line 138, in import_optional_dependency raise ImportError(msg) ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl.
03-18
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值