我这是按照课程上照抄去执行，代码没有问题，但我这个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
缺少可选依赖项“xlrd”。安装xlrd>=1.0.0 for Excel支持使用pip或conda安装xlrd。
pip install xlrd
丢失了xlrd模块儿。这个有单独的模块儿使用的，但是安装pandas，应该自带安装相应的xlrd插件包的，你是不是没安装好
pd.read_excel时去按alt+enter把方法弹出来去选就好了，不知道为什么要这样，问题已解决。