VS Code中numpy c-extensions导入失败报错修复方案咨询

问题概述 #

• 触发场景：运行本地Form_validate.py脚本，执行首行import pandas as pd语句时直接抛出导入错误
• 核心报错提示：Importing the numpy c-extensions failed，底层原始错误为DLL load failed: The specified module could not be found
• 当前运行环境：使用的解释器路径为C:\ProgramData\Anaconda3\python.exe，对应Python 3.7版本，已安装numpy版本为1.18.1
• 完整报错日志：

from . import _distributor_init
Traceback (most recent call last):
File ".\Form_validate.py", line 1, in <module>
import pandas as pd
File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\__init__.py", line 17, in <module>
"Unable to import required dependencies:\n" + "\n".join(missing_dependencies)
ImportError: Unable to import required dependencies:
numpy:



IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE!



Importing the numpy c-extensions failed.
- Try uninstalling and reinstalling numpy.
- If you have already done that, then:
1. Check that you expected to use Python3.7 from "C:\ProgramData\Anaconda3\python.exe",
and that you have no directories in your PATH or PYTHONPATH that can
interfere with the Python and numpy version "1.18.1" you're trying to use.
2. If (1) looks fine, you can submit feedback to the numpy project official channel. Please include details on:
- how you installed Python
- how you installed numpy
- your operating system
- whether or not you have multiple versions of Python installed
- if you built from source, your compiler versions and ideally a build log



- If you're working with a numpy git repository, try `git clean -xdf`
(removes all files not under version control) and rebuild numpy.



Note: this error has many possible causes, so please don't comment on
an existing issue about this - open a new one instead.



Original error was: DLL load failed: The specified module could not be found.

修复步骤（按优先级操作，每步做完测试一次，正常就不用往下走） #

• 先核对VS Code选中的解释器是否正确
  按Ctrl+Shift+P调出命令面板，搜索Python: Select Interpreter，确认选中的解释器路径就是C:\ProgramData\Anaconda3\python.exe，不要误选系统独立安装的Python、应用商店版Python、其他虚拟环境的Python解释器。
• 补全Anaconda必要环境变量（90%的同类型报错都是这个原因）
  右键「此电脑」-选择「属性」-打开「高级系统设置」-点击「环境变量」，在系统变量的Path条目里新增以下3个路径（如果Anaconda装在其他盘符就把盘符改成对应安装位置）：

  C:\ProgramData\Anaconda3
  C:\ProgramData\Anaconda3\Scripts
  C:\ProgramData\Anaconda3\Library\bin
  

  所有设置窗口点确定保存后，完全退出VS Code再重新打开，重新运行脚本测试。
• 重装损坏的依赖包
  如果补完环境变量还是报错，就是本地numpy/pandas安装文件损坏，打开开始菜单里的「Anaconda Prompt」，依次执行以下命令重装Python3.7兼容的稳定版本，避免装过高版本出现兼容问题：

  pip uninstall numpy pandas -y
  pip install numpy==1.18.5 pandas==1.2.4
  

  安装完成后回到VS Code，按Ctrl+Shift+P调出命令面板，执行Developer: Reload Window重载窗口后再测试。
• 排查环境冲突
  • 回到系统环境变量的Path列表，删掉其他版本Python、其他Anaconda/Miniconda安装目录的相关路径，避免多版本依赖互相干扰。
  • 检查当前Form_validate.py所在的文件夹里，有没有自己命名为numpy.py、pandas.py的文件，或者同名文件夹，有的话改成其他名字，否则Python导入时会优先读取本地同名文件，触发导入错误。

内容的提问来源于stack exchange，提问作者AlPuRh