pandas读取XLS文件出错

Question

我这是按照课程上照抄去执行，代码没有问题，但我这个python执行就出错，课程链接：https://edu.csdn.net/learn/28220?spm=1002.2001.3001.4140
代码：
import pandas as pd

data = pd.read_excel("titanic3.xls", sheet_name="titanic3")
print(data.head())

报错：

"C:\Program Files\Python38\python.exe" C:/Users/Administrator/PycharmProjects/pandastitan/fileopen.py
Traceback (most recent call last):
File "C:/Users/Administrator/PycharmProjects/pandastitan/fileopen.py", line 3, in
data = pd.read_excel("titanic3.xls", sheet_name="titanic3")
File "C:\Program Files\Python38\lib\site-packages\pandas\util_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "C:\Program Files\Python38\lib\site-packages\pandas\io\excel_base.py", line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "C:\Program Files\Python38\lib\site-packages\pandas\io\excel_base.py", line 1233, in init
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File "C:\Program Files\Python38\lib\site-packages\pandas\io\excel_xlrd.py", line 24, in init
import_optional_dependency("xlrd", extra=err_msg)
File "C:\Program Files\Python38\lib\site-packages\pandas\compat_optional.py", line 118, in import_optional_dependency
raise ImportError(msg) from None
ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

Process finished with exit code 1

Answer 1

缺少可选依赖项“xlrd”。安装xlrd>=1.0.0 for Excel支持使用pip或conda安装xlrd。

pip install xlrd