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.

python excel python-2.7 pandas

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 pdpd.read_excel('path/to/file.xlsx', engine='openpyxl')

python excel python-2.7 pandas

Either use:

pip install xlrd

And if you are using conda, use

conda install -c anaconda xlrd

That's it. good luck.

CodeHunter