Error: Pandas requires version '1.1.0' or newer of 'xlrd' (version '1.0.0' currently installed)

user_6900402 0
Viewed 18063

I've recently upgraded my Pandas version from 0.20.0 to 1.0.5 to be able to use the explode() function. Then when I tried reading an Excel file, it threw an error Pandas requires version '1.1.0' or newer of 'xlrd' (version '1.0.0' currently installed). So I installed xlrd-1.2.0 using my Anaconda prompt and then restarted the kernel in my Jupyter notebook but I still keep getting the same error. Checking the xlrd version in the notebook using the following shows 1.0.0 as the installed version.

import pkg_resources
pkg_resources.get_distribution("xlrd").version

I even tried !pip install xlrd in the notebook but it says Requirement already satisfied: xlrd in c:\users\<username>\appdata\local\continuum\anaconda3\lib\site-packages (1.0.0)

I'm not sure what to do as I can't run any of my code now. Please help!

pandas xlrd python
3 Answers

I had a similar issue. I got the same error. However i do not have Anaconda installed. I managed to solve the issue with the below upgrade.

pip install --upgrade xlrd
user_36223440

I had the same issue with another package in Spyder. I solved it with pip install. Did you try that already?

user_123633780

I faced the same problem in Colab when read .xls file use upgrade pandas solve this

!pip install --upgrade pandas

I guess you can try this in local environment

pip install --upgrade pandas
user_109626990
Related