Read xlsx to pandas df

PHOTO EMBED

Sun Jan 23 2022 13:12:47 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #python

pd.read_excel('path/to/file.xlsx', engine='openpyxl')
content_copyCOPY

Since December 2020 xlrd no longer supports xlsx-Files as explained in the official changelog. You can use openpyxl instead:

https://stackoverflow.com/questions/48066517/python-pandas-pd-read-excel-giving-importerror-install-xlrd-0-9-0-for-excel