[PYTHON] ImportError: Fehlende optionale Abhängigkeit 'xlrd'. Installieren Sie xlrd> = 1.0.0 für die Excel-Unterstützung. Verwenden Sie pip oder conda, um xlrd zu installieren.

--Umgebung --macOS Catalina Version 10.15.7 - Python 3.8.5 - pandas 1.1.3

Ereignis: Ich wurde wütend, als ich versuchte, Pandas zu verbinden

Traceback (most recent call last):
  File "/Users/ponsuke/tryPython/main.py", line 7, in <module>
    book = pd.read_excel(excel_file, sheet_name=None, header=None)
  File "/Users/ponsuke/tryPython/venv/lib/python3.8/site-packages/pandas/util/_decorators.py", line 296, in wrapper
    return func(*args, **kwargs)
  File "/Users/ponsuke/tryPython/venv/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 304, in read_excel
    io = ExcelFile(io, engine=engine)
  File "/Users/ponsuke/tryPython/venv/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 867, in __init__
    self._reader = self._engines[engine](self._io)
  File "/Users/ponsuke/tryPython/venv/lib/python3.8/site-packages/pandas/io/excel/_xlrd.py", line 21, in __init__
    import_optional_dependency("xlrd", extra=err_msg)
  File "/Users/ponsuke/tryPython/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.

Process finished with exit code 1

main.py

import pandas as pd

# ...Kürzung...
if __name__ == '__main__':
    excel_file = 'Book.xlsx'
    book = pd.read_excel(excel_file, sheet_name=None, header=None)

Ursache: Pandas benötigt xlrd, hat es aber nicht installiert

Sie müssen auch das xlrd-Paket installieren, um Excel-Dateien lesen zu können. Lesen und Schreiben von Excel mit Python Pandas | Earl Effect

Aktion: Installieren Sie xlrd

% pip install xlrd
Collecting xlrd
  Downloading xlrd-1.2.0-py2.py3-none-any.whl (103 kB)
     |████████████████████████████████| 103 kB 3.0 MB/s 
Installing collected packages: xlrd
Successfully installed xlrd-1.2.0