Python错误集锦：pandas读取excel提示ImportError: Missing optional dependency ‘xlrd’.

最新推荐文章于 2025-01-11 11:46:06 发布

原创

最新推荐文章于 2025-01-11 11:46:06 发布 · 4.4w 阅读

50 ·

CC 4.0 BY-SA版权

文章标签：

#python

该文章已生成可运行项目，

原文链接：http://www.juzicode.com/archives/3125

错误提示：

用pandas read_excel()方法读取xls或xlsx文件时，提示：ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

import numpy as np
import pandas as pd

df = pd.read_excel('pd-test.xls')
print('df=\n',df)

命令行运行py文件提示：

Traceback (most recent call last):
  File "pd-test.py", line 4, in <module>
    df = pd.read_excel('pd-test.xls')
  File "D:\Python\Python38\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
    return func(*args, **kwargs)
  File "D:\Python\Python38\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
    io = ExcelFile(io, engine=engine)
  File "D:\Python\Python38\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__
    self._reader = self._engines[engine](self._io)

本文章已经生成可运行项目