在运行导入pandas时会出现如下报错信息:
C:\Users\asus\AppData\Roaming\Python\Python37\site-packages\pandas\compat\_optional.py:138: UserWarning: Pandas requires version '3.0.0' or newer of 'openpyxl' (version '2.6.1' currently installed). warnings.warn(msg, UserWarning)
这是因为安装的pandas版本太高的缘故,需要升级openpyxl,
此时执行如下命令即可:pip install -i http://mirrors.aliyun.com/pypi/simple openpyxl==3.0.0 --trusted-host mirrors.aliyun.com