ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd

We Are Going To Discuss About ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd. So lets Start this Python Article.

ImportError: Missing optional dependency ‘xlrd’. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd

  1. How to solve ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd

    You can install openpyxl using pip install openpyxl and then try:
    pd.read_excel('2018_pressures.xlsx', engine='openpyxl')
    This is an alternative solution but it will work.

  2. ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd

    You can install openpyxl using pip install openpyxl and then try:
    pd.read_excel('2018_pressures.xlsx', engine='openpyxl')
    This is an alternative solution but it will work.

Solution 1

You can install openpyxl using pip install openpyxl and then try:

pd.read_excel('2018_pressures.xlsx', engine='openpyxl')

This is an alternative solution but it will work.

Original Author Hamza usman ghani Of This Content

Solution 2

I share with you my experience on this !

  1. step check whether you have the following excel packages installed: openpyxl, odf, xlrd

to check:
pip list or conda list

  1. If there is no installation package reading the excel file, then install one of them with this method:

    pip install xlrd, pip install openpyxl, pip install odf or pip install pyxslb

for conda : conda install xlrd, conda install openpyxl, conda install odf, conda install pyxslb
then check again whether your file reads correctly:

dataFrame = pd. read_excel('C:/.../.xlsx', engine= 'openpyxl')

if it gives an error again, it means that you are using another interpreter to read the code if you want to read it in https://www.kaggle.com/abdumaleek/kasco-tasks/editkaggle or in collaboration, then you need to install the package for reading exel file again

for example, in kaggle :
!pip install openpyxl

import openpyxl
df = pd. read_excel('C:/.../.xlsx', engine= 'openpyxl')

this is 100% should work
support with a like

Original Author Abdumaleek Of This Content

Solution 3

I’m in Windows 10. I downloaded all of Anaconda on 1 computer and just the Spyder part on a different computer from Anaconda web site. The computer with all of Anaconda on it did not get this error; the computer with just Spyder on it got this error of not being able to find xlrd when doing the following

import pandas as pd

import urllib.request

urllib.request.urlretrieve("https:a internet file name in here that is an xlsx file", "sample.xlsx")

df = pd.read_excel("sample.xlsx")

df

Original Author Pat b Of This Content

Conclusion

So This is all About This Tutorial. Hope This Tutorial Helped You. Thank You.

Also Read,

ittutorial team

I am an Information Technology Engineer. I have Completed my MCA And I have 4 Year Plus Experience, I am a web developer with knowledge of multiple back-end platforms Like PHP, Node.js, Python and frontend JavaScript frameworks Like Angular, React, and Vue.

Leave a Comment