ImportError: No module named xlrd

[dhiliptcs]

I am trying to extract data from XL sheet and I tried to use the below

import xlrd

Error:
ImportError: No module named xlrd 

( I also tried "pandas", "openpyxl"; Same error resulted)

When I checked in lib folder, I was able to find xlrd package

in the path - /projects/software/miniconda_3.7.3/pkgs/xlrd-1.1.0-py35_0/lib/python3.5/site-packages/xlrd

can anyone please help me how to resolve this?

[Yoriz]

Do you have more than one install of python / are you sure you are using miniconda_3.7.3 in this instance.

[dhiliptcs]

Yes, I believe we do have the below.

python -V
Python 2.7.13

Looks like, we are not referring to below miniconda_3.7.3..

Please let me know how to utilize or install or invoke packages(specifically xlrd)

[Yoriz]

It depends how you are running the code ?

[dhiliptcs]

Thank you!

[brighteningeyes]

hi,
type

python3 -v

and check it's version
also, use

pip3 install xlrd

to install it
the same is true with pandas