将excel文件列导入python脚本

Question

现在，我有一个脚本，旨在发送Whatsapp消息。它获取电话号码names = ['phone number 1', 'phone number 2', 'phone number 3']，并使用该号码在Whatsapp中查找联系人

我希望能够用excel文档填写“名称”字段

我使用的是python 3.8.3，并且已经安装了pandas

我试图创建一个小的测试脚本来测试一切，但没有成功

import pandas as pd

df = pd.read_excel('contactsList.xlsx')

print(df)

“contactList.xlsx”与我尝试运行的脚本位于同一文件夹中

Traceback (most recent call last): File "/Users/zafarb/PycharmProjects/CelebrateMercy/csvHelps.py", line 3, in df = pd.read_excel('contactsList.xlsx') File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/util/_decorators.py", line 296, in wrapper return func(*args, **kwargs) File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 304, in read_excel io = ExcelFile(io, engine=engine) File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 867, in init self._reader = self._enginesengine File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/io/excel/_xlrd.py", line 21, in init import_optional_dependency("xlrd", extra=err_msg) File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/compat/_optional.py", line 110, 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.

这是我得到的错误

Answer 1

xlrd是一个用于从Excel文件（无论是.xls还是.xlsx文件）中读取数据和格式化信息的库

它需要安装在您首选的终端运行中

pip安装xlrd

Answer 2

查看错误，您缺少依赖项

Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

运行pip install xlrd