<p>现在,我有一个脚本,旨在发送Whatsapp消息。它获取电话号码<code>names = ['phone number 1', 'phone number 2', 'phone number 3']</code>,并使用该号码在Whatsapp中查找联系人</p>
<p>我希望能够用excel文档填写“名称”字段</p>
<p>我使用的是python 3.8.3,并且已经安装了pandas</p>
<p>我试图创建一个小的测试脚本来测试一切,但没有成功</p>
<pre><code>import pandas as pd
df = pd.read_excel('contactsList.xlsx')
print(df)
</code></pre>
<p>“contactList.xlsx”与我尝试运行的脚本位于同一文件夹中</p>
<blockquote>
<p>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 <strong>init</strong>
self._reader = self._enginesengine
File "/Users/zafarb/PycharmProjects/CelebrateMercy/venv/lib/python3.8/site-packages/pandas/io/excel/_xlrd.py", line 21, in <strong>init</strong>
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.</p>
</blockquote>
<p>这是我得到的错误</p>
<p>查看错误,您缺少依赖项</p>
<p><code>Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.</code></p>
<p>运行<code>pip install xlrd</code></p>