Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
Since December 2020 xlrd no longer supports xlsx-Files as explained in the official changelog. You can use openpyxl
instead:
pip install openpyxl
And in your python-file:
import pandas as pd
pd.read_excel(path/to/file.xlsx, engine=openpyxl)
Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
Thats it. good luck.
Related Posts
- Python Pandas – Missing required dependencies [numpy] 1
- python – Pandas DataFrame Groupby two columns and get counts
- How to delete multiple pandas (python) dataframes from memory to save RAM?
- Python Pandas – Find difference between two data frames
- python – Using pandas structures with large csv(iterate and chunksize)