Python导入pandas报错ValueError：源代码字符串不能包含空字节

报错信息 #

Traceback (most recent call last):
  File "c:\Users\Adrian\Desktop\alkemy\src\py_functions\transform_univ_jfk.py", line 4, in <module>
    import pandas as pd
  File "C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\__init__.py", line 141, in <module>
    from pandas.io.api import (
  File "C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\io\api.py", line 6, in <module>
    from pandas.io.excel import (
  File "C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\io\excel\__init__.py", line 1, in <module>
    from pandas.io.excel._base import (
  File "C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\io\excel\_base.py", line 75, in <module>
    from pandas.io.parsers import TextParser
  File "C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas\io\parsers\__init__.py", line 1, in <module>
    from pandas.io.parsers.readers import (
ValueError: source code string cannot contain null bytes

解决步骤 #

• 检查本地脚本文件：打开报错里的transform_univ_jfk.py，用Notepad++或VS Code查看是否存在乱码、空字节或异常字符。将文件保存为UTF-8无BOM格式后重新运行。
• 彻底重装pandas：
  1. 打开命令提示符，执行卸载命令：pip uninstall -y pandas
  2. 手动删除残留的pandas文件夹：路径为C:\Users\Adrian\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pandas
  3. 重新安装pandas：pip install pandas
• 排查环境异常：
  1. 新建一个极简测试脚本test.py，仅写入import pandas as pd并运行。如果正常，说明原脚本文件有问题；如果仍报错，说明Python环境或系统文件被篡改。
  2. 对系统进行病毒扫描，排除恶意软件篡改文件的可能。
  3. 尝试更换Python版本（比如3.9或3.11），重新安装后再测试pandas导入。

内容的提问来源于stack exchange，提问作者Adrián Piñero