Mixing
Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
I am trying to read a .xlsx with pandas, but get the follwing error:
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
Traceback (most recent call last):
File "/Users/Vineeth/PycharmProjects/DataAnalysis1/try1.py", line 9, in <module>
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 230, in read_excel
io = ExcelFile(io, engine=engine)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 263, in __init__
raise ImportError(err_msg)
ImportError: Install xlrd >= 0.9.0 for Excel support
I've also tried
data = pd.read_excel("DataAnalysis1/temp1.xlsx", low_memory=False).fillna(value=0)
And I Still get the same error.
Background: I'm trying to extract an excel file with multiple worksheets as a dict of data frames.I installed xlrd version 0.9.0 and the latest version(1.1.0) but I still get the same error. Thanks!
python excel python-2.7 pandas
edited Jan 2 '18 at 19:18
Grr
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
add a comment |
I am trying to read a .xlsx with pandas, but get the follwing error:
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
Traceback (most recent call last):
File "/Users/Vineeth/PycharmProjects/DataAnalysis1/try1.py", line 9, in <module>
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 230, in read_excel
io = ExcelFile(io, engine=engine)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 263, in __init__
raise ImportError(err_msg)
ImportError: Install xlrd >= 0.9.0 for Excel support
I've also tried
data = pd.read_excel("DataAnalysis1/temp1.xlsx", low_memory=False).fillna(value=0)
And I Still get the same error.
Background: I'm trying to extract an excel file with multiple worksheets as a dict of data frames.I installed xlrd version 0.9.0 and the latest version(1.1.0) but I still get the same error. Thanks!
python excel python-2.7 pandas
edited Jan 2 '18 at 19:18
Grr
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
3
Did you try listening to the error message and installing thexlrdpackage?
– coldspeed
Jan 2 '18 at 19:13
Yes, I installed thexlrdpackage. Edit: I tried to import the package, but python gives me aimport xlrd ImportError: No module named xlrderror
– Vineeth Sai
Jan 2 '18 at 19:18
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20
add a comment |
I am trying to read a .xlsx with pandas, but get the follwing error:
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
Traceback (most recent call last):
File "/Users/Vineeth/PycharmProjects/DataAnalysis1/try1.py", line 9, in <module>
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 230, in read_excel
io = ExcelFile(io, engine=engine)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 263, in __init__
raise ImportError(err_msg)
ImportError: Install xlrd >= 0.9.0 for Excel support
I've also tried
data = pd.read_excel("DataAnalysis1/temp1.xlsx", low_memory=False).fillna(value=0)
And I Still get the same error.
Background: I'm trying to extract an excel file with multiple worksheets as a dict of data frames.I installed xlrd version 0.9.0 and the latest version(1.1.0) but I still get the same error. Thanks!
python excel python-2.7 pandas
edited Jan 2 '18 at 19:18
Grr
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
I am trying to read a .xlsx with pandas, but get the follwing error:
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
Traceback (most recent call last):
File "/Users/Vineeth/PycharmProjects/DataAnalysis1/try1.py", line 9, in <module>
data = pd.read_excel(low_memory=False, io="DataAnalysis1/temp1.xlsx").fillna(value=0)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 230, in read_excel
io = ExcelFile(io, engine=engine)
File "/Users/Vineeth/venv/lib/python2.7/site-packages/pandas/io/excel.py", line 263, in __init__
raise ImportError(err_msg)
ImportError: Install xlrd >= 0.9.0 for Excel support
I've also tried
data = pd.read_excel("DataAnalysis1/temp1.xlsx", low_memory=False).fillna(value=0)
And I Still get the same error.
Background: I'm trying to extract an excel file with multiple worksheets as a dict of data frames.I installed xlrd version 0.9.0 and the latest version(1.1.0) but I still get the same error. Thanks!
python excel python-2.7 pandas
python excel python-2.7 pandas
edited Jan 2 '18 at 19:18
Grr
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
edited Jan 2 '18 at 19:18
Grr
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
edited Jan 2 '18 at 19:18
Grr
8,02343149
edited Jan 2 '18 at 19:18
Grr
8,02343149
edited Jan 2 '18 at 19:18
Grr
8,02343149
8,02343149
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
asked Jan 2 '18 at 19:12
Vineeth SaiVineeth Sai
147126
147126
3
Did you try listening to the error message and installing thexlrdpackage?
– coldspeed
Jan 2 '18 at 19:13
Yes, I installed thexlrdpackage. Edit: I tried to import the package, but python gives me aimport xlrd ImportError: No module named xlrderror
– Vineeth Sai
Jan 2 '18 at 19:18
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20
add a comment |
3
Did you try listening to the error message and installing thexlrdpackage?
– coldspeed
Jan 2 '18 at 19:13
Yes, I installed thexlrdpackage. Edit: I tried to import the package, but python gives me aimport xlrd ImportError: No module named xlrderror
– Vineeth Sai
Jan 2 '18 at 19:18
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20
3
3
Did you try listening to the error message and installing the
xlrd package?– coldspeed
Jan 2 '18 at 19:13
Did you try listening to the error message and installing the
xlrd package?– coldspeed
Jan 2 '18 at 19:13
Yes, I installed the
xlrd package. Edit: I tried to import the package, but python gives me a import xlrd ImportError: No module named xlrd error– Vineeth Sai
Jan 2 '18 at 19:18
Yes, I installed the
xlrd package. Edit: I tried to import the package, but python gives me a import xlrd ImportError: No module named xlrd error– Vineeth Sai
Jan 2 '18 at 19:18
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20
add a comment |
8 Answers
8
active
oldest
votes
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :Install xlrd >= 0.9.0 for Excel support:/
– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
add a comment |
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
That's it. good luck.
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
add a comment |
I don't know if this will be helpful for someone, but I had the same problem.
I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there.
What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there.
Hope this is useful for someone :D
edited Jul 25 '18 at 20:33
NickD
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
add a comment |
This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)
However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.
pip install --upgrade pandas
pip install --upgrade xlrd
Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence
The following should work, assuming your pip install operated on python2.
python3 -m pip install xlrd
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
add a comment |
First of all you need to install xlrd & pandas packages. Then try below code.
import xlrd
import pandas as pd
xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
add a comment |
You need to install the "xlrd" lib
For Linux (Ubuntu and Derivates):
Installing via pip:
python -m pip install --user xlrd
Install system-wide via a Linux package manager:
*sudo apt-get install python-xlrd
Windows:
Installing via pip:
*pip install xlrd
Download the files:
https://pypi.org/project/xlrd/
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
add a comment |
Was getting the error while I was using jupyter.
ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support
it was resolved for me after using.
!pip install xlrd
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
add a comment |
Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:Python27Scripts.." folder.
In another word, there are 2 different versions of xlrd in the machine.
when you check the version below, it reads the one not in the "..:Python27Scripts.." folder, no matter how updated you done with pip.
print xlrd.__version__
Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)
answered Feb 18 at 1:05
Mark KMark K
2,41862448
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f48066517%2fpython-pandas-pd-read-excel-giving-importerror-install-xlrd-0-9-0-for-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
8 Answers
8
active
oldest
votes
8 Answers
8
active
oldest
votes
active
oldest
votes
active
oldest
votes
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :Install xlrd >= 0.9.0 for Excel support:/
– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
add a comment |
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :Install xlrd >= 0.9.0 for Excel support:/
– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
add a comment |
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
As @COLDSPEED so eloquently pointed out the error explicitly tells you to install xlrd.
pip install xlrd
And you will be good to go.
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
answered Jan 2 '18 at 19:17
GrrGrr
8,02343149
8,02343149
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :Install xlrd >= 0.9.0 for Excel support:/
– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
add a comment |
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :Install xlrd >= 0.9.0 for Excel support:/
– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
3
3
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
I exactly had the same issue, I had to force re-install xlrd. pip install --upgrade --force-reinstall xlrd
– Tamas Szuromi
Feb 5 '18 at 13:17
3
3
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :
Install xlrd >= 0.9.0 for Excel support :/– ThePassenger
May 14 '18 at 10:12
@TamasSzuromi Unfortunately I keep having the same error message after trying both of your commands :
Install xlrd >= 0.9.0 for Excel support :/– ThePassenger
May 14 '18 at 10:12
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
same here (on v 1.1.0)...and I cannot import it either, as suggested here stackoverflow.com/questions/51227745/…
– jjrr
Nov 1 '18 at 15:39
add a comment |
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
That's it. good luck.
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
add a comment |
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
That's it. good luck.
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
add a comment |
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
That's it. good luck.
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
Either use:
pip install xlrd
And if you are using conda, use
conda install -c anaconda xlrd
That's it. good luck.
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
answered Nov 12 '18 at 14:18
E. ErfanE. Erfan
151211
151211
add a comment |
add a comment |
I don't know if this will be helpful for someone, but I had the same problem.
I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there.
What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there.
Hope this is useful for someone :D
edited Jul 25 '18 at 20:33
NickD
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
add a comment |
I don't know if this will be helpful for someone, but I had the same problem.
I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there.
What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there.
Hope this is useful for someone :D
edited Jul 25 '18 at 20:33
NickD
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
add a comment |
I don't know if this will be helpful for someone, but I had the same problem.
I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there.
What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there.
Hope this is useful for someone :D
edited Jul 25 '18 at 20:33
NickD
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
I don't know if this will be helpful for someone, but I had the same problem.
I wrote pip install xlrd in the anaconda prompt while in the specific environment and it said it was installed, but when I looked at the installed packages it wasn't there.
What solved the problem was "moving" (I don't know the terminology for it) into the Scripts folder of the specific environment and do the pip install xlrd there.
Hope this is useful for someone :D
edited Jul 25 '18 at 20:33
NickD
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
edited Jul 25 '18 at 20:33
NickD
2,3671922
edited Jul 25 '18 at 20:33
NickD
2,3671922
edited Jul 25 '18 at 20:33
NickD
2,3671922
2,3671922
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
answered Jul 25 '18 at 19:27
Consuelo de tontosConsuelo de tontos
111
111
add a comment |
add a comment |
This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)
However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.
pip install --upgrade pandas
pip install --upgrade xlrd
Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence
The following should work, assuming your pip install operated on python2.
python3 -m pip install xlrd
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
add a comment |
This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)
However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.
pip install --upgrade pandas
pip install --upgrade xlrd
Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence
The following should work, assuming your pip install operated on python2.
python3 -m pip install xlrd
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
add a comment |
This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)
However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.
pip install --upgrade pandas
pip install --upgrade xlrd
Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence
The following should work, assuming your pip install operated on python2.
python3 -m pip install xlrd
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
This happened to me after I ran a script with cProfile a la python3 -m cProfile script.py even though xlrd was already installed and had never thrown this error before. it persisted even under python3 script.py. (Granted, I agree this wasn't what happened to OP, given the obvious import error)
However, for cases like mine, the following fixed the issue, despite being told "requirement already met" in every case.
pip install --upgrade pandas
pip install --upgrade xlrd
Pretty confounding stuff; not sure if cProfile was the cause or just a coincidence
The following should work, assuming your pip install operated on python2.
python3 -m pip install xlrd
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
edited Mar 6 '18 at 14:26
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
answered Mar 6 '18 at 14:20
Mike PalmiceMike Palmice
379311
379311
add a comment |
add a comment |
First of all you need to install xlrd & pandas packages. Then try below code.
import xlrd
import pandas as pd
xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
add a comment |
First of all you need to install xlrd & pandas packages. Then try below code.
import xlrd
import pandas as pd
xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
add a comment |
First of all you need to install xlrd & pandas packages. Then try below code.
import xlrd
import pandas as pd
xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
First of all you need to install xlrd & pandas packages. Then try below code.
import xlrd
import pandas as pd
xl = pd.ExcelFile("fileName.xlsx")
print(xl.parse(xl.sheet_names[0]))
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
answered Mar 27 '18 at 15:07
reza.cse08reza.cse08
3,5912827
3,5912827
add a comment |
add a comment |
You need to install the "xlrd" lib
For Linux (Ubuntu and Derivates):
Installing via pip:
python -m pip install --user xlrd
Install system-wide via a Linux package manager:
*sudo apt-get install python-xlrd
Windows:
Installing via pip:
*pip install xlrd
Download the files:
https://pypi.org/project/xlrd/
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
add a comment |
You need to install the "xlrd" lib
For Linux (Ubuntu and Derivates):
Installing via pip:
python -m pip install --user xlrd
Install system-wide via a Linux package manager:
*sudo apt-get install python-xlrd
Windows:
Installing via pip:
*pip install xlrd
Download the files:
https://pypi.org/project/xlrd/
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
add a comment |
You need to install the "xlrd" lib
For Linux (Ubuntu and Derivates):
Installing via pip:
python -m pip install --user xlrd
Install system-wide via a Linux package manager:
*sudo apt-get install python-xlrd
Windows:
Installing via pip:
*pip install xlrd
Download the files:
https://pypi.org/project/xlrd/
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
You need to install the "xlrd" lib
For Linux (Ubuntu and Derivates):
Installing via pip:
python -m pip install --user xlrd
Install system-wide via a Linux package manager:
*sudo apt-get install python-xlrd
Windows:
Installing via pip:
*pip install xlrd
Download the files:
https://pypi.org/project/xlrd/
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
edited May 21 '18 at 19:05
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
answered May 21 '18 at 19:00
nilsovianinilsoviani
5210
5210
add a comment |
add a comment |
Was getting the error while I was using jupyter.
ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support
it was resolved for me after using.
!pip install xlrd
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
add a comment |
Was getting the error while I was using jupyter.
ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support
it was resolved for me after using.
!pip install xlrd
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
add a comment |
Was getting the error while I was using jupyter.
ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support
it was resolved for me after using.
!pip install xlrd
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
Was getting the error while I was using jupyter.
ModuleNotFoundError: No module named 'xlrd'
...
ImportError: Install xlrd >= 0.9.0 for Excel support
it was resolved for me after using.
!pip install xlrd
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
answered Jan 1 at 12:24
Santosh sanwalSantosh sanwal
84
84
add a comment |
add a comment |
Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:Python27Scripts.." folder.
In another word, there are 2 different versions of xlrd in the machine.
when you check the version below, it reads the one not in the "..:Python27Scripts.." folder, no matter how updated you done with pip.
print xlrd.__version__
Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)
answered Feb 18 at 1:05
Mark KMark K
2,41862448
add a comment |
Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:Python27Scripts.." folder.
In another word, there are 2 different versions of xlrd in the machine.
when you check the version below, it reads the one not in the "..:Python27Scripts.." folder, no matter how updated you done with pip.
print xlrd.__version__
Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)
answered Feb 18 at 1:05
Mark KMark K
2,41862448
add a comment |
Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:Python27Scripts.." folder.
In another word, there are 2 different versions of xlrd in the machine.
when you check the version below, it reads the one not in the "..:Python27Scripts.." folder, no matter how updated you done with pip.
print xlrd.__version__
Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)
answered Feb 18 at 1:05
Mark KMark K
2,41862448
Another possibility, is the machine has an older version of xlrd installed separately, and it's not in the "..:Python27Scripts.." folder.
In another word, there are 2 different versions of xlrd in the machine.
when you check the version below, it reads the one not in the "..:Python27Scripts.." folder, no matter how updated you done with pip.
print xlrd.__version__
Delete the whole redundant sub-folder, and it works. (in addition to xlrd, I had another library encountered the same)
answered Feb 18 at 1:05
Mark KMark K
2,41862448
answered Feb 18 at 1:05
Mark KMark K
2,41862448
answered Feb 18 at 1:05
Mark KMark K
2,41862448
answered Feb 18 at 1:05
Mark KMark K
2,41862448
2,41862448
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f48066517%2fpython-pandas-pd-read-excel-giving-importerror-install-xlrd-0-9-0-for-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
Did you try listening to the error message and installing the
xlrdpackage?– coldspeed
Jan 2 '18 at 19:13
Yes, I installed the
xlrdpackage. Edit: I tried to import the package, but python gives me aimport xlrd ImportError: No module named xlrderror– Vineeth Sai
Jan 2 '18 at 19:18
I'm guessing you installed for a different python version.
– coldspeed
Jan 2 '18 at 19:20