#author("2022-02-13T21:28:13+08:00","default:Admin","Admin") #author("2022-06-06T13:08:14+08:00","default:Admin","Admin") [[Python]] &color(red){※This article is based on Python 3.7.3}; #contents * 一般的环境 [#t7127066] 发生下面的错误 #codeprettify{{ Traceback (most recent call last): File "jd.py", line 50, in <module> df.to_excel('D:\python\news.xlsx') File "C:\Users\th\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\core\generic.py", line 2127, in to_excel engine=engine) File "C:\Users\th\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\formats\excel.py", line 656, in write writer = ExcelWriter(_stringify_path(writer), engine=engine) File "C:\Users\th\AppData\Local\Programs\Python\Python37\lib\site-packages\pandas\io\excel.py", line 1204, in __init__ from openpyxl.workbook import Workbook ModuleNotFoundError: No module named 'openpyxl' }} 看到“ModuleNotFoundError”的错误,缺少什么就像下面一样安装什么。 #codeprettify{{ pip install openpyxl }} ** ModuleNotFoundError: No module named 'zlib' [#y5ab3afe] #codeprettify{{ Traceback (most recent call last): File "<frozen zipimport>", line 520, in _get_decompress_func ModuleNotFoundError: No module named 'zlib' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "<frozen zipimport>", line 568, in _get_data File "<frozen zipimport>", line 523, in _get_decompress_func zipimport.ZipImportError: can't decompress data; zlib not available During handling of the above exception, another exception occurred: Traceback (most recent call last): File "get-pip.py", line 23704, in <module> main() File "get-pip.py", line 198, in main bootstrap(tmpdir=tmpdir) File "get-pip.py", line 82, in bootstrap from pip._internal.cli.main import main as pip_entry_point File "<frozen zipimport>", line 241, in load_module File "<frozen zipimport>", line 709, in _get_module_code File "<frozen zipimport>", line 570, in _get_data zipimport.ZipImportError: can't decompress data; zlib not available }} sudo apt-get install zlib1g-dev * PyCharm [#g2f82b3d] File => Settings => Project:项目名称 => Python Interpreter => 点击齿轮图标 在“Virtualenv Environment”里面选中“Existing Environment”填入Python.exe的路径后回到“ Python Interpreter”页面 点击 + 加号,填写需要安装的安装包,安装即可 &ref(python_pycharm1.png); #hr(); コメント: #comment_kcaptcha