Pyinstaller 打包 Pandas 出错处理_python pyinstaller 打包name 'pandas' is not defined-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_41957336/article/details/103955490

使用Pyinstaller打包含Pandas的Python程序时遇到错误，提示涉及sqlalchemy。尝试升级Pandas和sqlalchemy未解决问题，但删除特定路径下sql开头的文件后成功打包。可能是最初安装Pandas时存在异常，遗留文件导致问题，删除后问题解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

用pandas写了个小程序，可以正常运行，之后使用 Pyinstaller 打包时候，报错。

错误提示如下，网上搜了一大圈也没发现有人出现类似的问题：

PS C:\01_Work\11_Python\test_QT\UniRecorder> pyinstaller .\ui\test_pypandas.py  
188 INFO: PyInstaller: 3.5
189 INFO: Python: 3.7.0
190 INFO: Platform: Windows-10-10.0.18362-SP0
192 INFO: wrote C:\01_Work\11_Python\test_QT\UniRecorder\test_pypandas.spec
230 INFO: UPX is not available.
240 INFO: Extending PYTHONPATH with paths
['C:\\01_Work\\11_Python\\test_QT\\UniRecorder\\ui',
 'C:\\01_Work\\11_Python\\test_QT\\UniRecorder']
270 INFO: checking Analysis
271 INFO: Building Analysis because Analysis-00.toc is non existent
271 INFO: Initializing module dependency graph...
279 INFO: Initializing module graph hooks...
293 INFO: Analyzing base_library.zip ...
7660 INFO: running Analysis Analysis-00.toc
7667 INFO: Adding Microsoft.Windows.Common-Controls to dependent assemblies of final executable
  required by c:\users\xinme\appdata\local\programs\python\python37-32\python.exe
16990 INFO: Caching module hooks...
17016 INFO: Analyzing C:\01_Work\11_Python\test_QT\UniRecorder\ui\test_pypandas.py
17223 INFO: Processing pre-find module path hook   distutils
22040 INFO: Processing pre-find module path hook   site
22073 INFO: site: retargeting to fake-dir 'c:\\users\\xinme\\appdata\\local\\programs\\python\\python37-32\\lib\\site-packages\\PyInstaller\\fake-modules'
26620 INFO: Processing pre-safe import module hook   setuptools.extern.six.moves
41255 INFO: Processing pre-safe import module hook   six.moves
66638 INFO: Loading module hooks...
66639 INFO: Loading module hook "hook-distutils.py"...
66643 INFO: Loading module hook "hook-encodings.py"...
66828 INFO: Loading module hook "hook-lib2to3.py"...
66843 INFO: Loading module hook "hook-lxml.etree.py"...
66845 INFO: Loading module hook "hook-matplotlib.backends.py"...
68977 INFO:   Matplotlib backend "GTK3Agg": ignored
    cairo backend requires that pycairo>=1.11.0 or cairocffiis installed
69787 INFO:   Matplotlib backend "GTK3Cairo": ignored
    cairo backend requires that pycairo>=1.11.0 or cairocffiis installed
70895 INFO:   Matplotlib backend "MacOSX": ignored
    cannot import name '_macosx' from 'matplotlib.backends' (c:\users\xinme\appdata\local\programs\python\python37-32\lib\site-packages\matplotlib\backends\__init__.py)
71759 INFO:   Matplotlib backend "nbAgg": ignored
    No module named 'IPython'
72758 INFO:   Matplotlib backend "Qt4Agg": added
73596 INFO:   Matplotlib backend "Qt4Cairo": ignored
    cairo backend requires that pycairo>=1.11.0 or cairocffiis installed
74521 INFO:   Matplotlib backend "Qt5Agg": added
75719 INFO:   Matplotlib backend "Qt5Cairo": ignored
    cairo backend requires that pycairo>=1.11.0 or cairocffiis installed
77316 INFO:   Matplotlib backend "TkAgg": added
78552 INFO:   Matplotlib backend "TkCairo": ignored
    cairo backend requires that pycairo>=1.11.0 or cairocffiis installed
80399 INFO:   Matplotlib backend "WebAgg": ignored
    Traceback (