为什么pd.Read_excel在jupyter停止工作并显示此错误信息?



我设置了一些jupyter笔记本来读取excel文件。直到昨天,当它们开始传递显示的错误信息时,它们一直工作正常。我试过将xls文件重命名为xlsx,并显式地将引擎命名为openpyxl,但都不起作用。出了什么问题?

import pandas as pd
import numpy as np
xls = pd.ExcelFile(('https://www5.cao.go.jp/keizai3/watcher-e/di.xls')
Traceback (most recent call last):
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/IPython/core/interactiveshell.py", line 3418, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "<ipython-input-7-aeef5030e4b9>", line 4, in <module>
xls = pd.read_excel('https://www5.cao.go.jp/keizai3/watcher-e/di.xls')
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/pandas/util/_decorators.py", line 299, in wrapper
return func(*args, **kwargs)
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 336, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 1043, in __init__
import_optional_dependency(
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/pandas/compat/_optional.py", line 106, in import_optional_dependency
module = importlib.import_module(name)
File "/Users/paul/opt/anaconda3/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
File "<frozen importlib._bootstrap>", line 991, in _find_and_load
File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 779, in exec_module
File "<frozen importlib._bootstrap_external>", line 916, in get_code
File "<frozen importlib._bootstrap_external>", line 846, in source_to_code
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/Users/paul/opt/anaconda3/lib/python3.8/site-packages/xlrd/__init__.py", line 1187
print "EXTERNSHEET(b7-):"
^
SyntaxError: invalid syntax

我想我已经解决了这个问题,在阅读了这里的回应之后。对我来说,冲突似乎与pdfminer有关。我把它卸载了,我想excel函数现在又可以工作了。

打印"EXTERNSHEET (b7 -):"熊猫

最新更新