Cannot make 'pandas' module to work...

[ellie145]

Happy New Year to everyone!

I'm a total noob in python...
I was trying to import the Pandas module and I keep receiving the same error. I was googling that for a couple of hours but some solutions that I found were difficult for me to follow.
The error is the following:

Error:
Traceback (most recent call last):
  File "/home/ellie/Desktop/test.py", line 6, in <module>
    df_xlsx = pd.read_excel('x.xlsx')
  File "/home/ellie/.local/lib/python3.8/site-packages/pandas/util/_decorators.py", line 299, in wrapper
    return func(*args, **kwargs)
  File "/home/ellie/.local/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 336, in read_excel
    io = ExcelFile(io, storage_options=storage_options, engine=engine)
  File "/home/ellie/.local/lib/python3.8/site-packages/pandas/io/excel/_base.py", line 1052, in __init__
    xlrd_version = LooseVersion(xlrd.__version__)
AttributeError: module 'xlrd' has no attribute '__version__'

As far as I know this error is not correlated to my script, it's something in pandas module right?


Does anyone know how to fix this?
I uninstalled and re-installed pandas multiple times.
I'm a Linux user, I don't know if it's related...

Thanks in advance!

[robsuttonjr]

Possibly your xlrd is too old and not updated. Check this thread:

https://stackoverflow.com/questions/6554...te-version

[ellie145]

Possibly your xlrd is too old and not updated. Check this thread:

https://stackoverflow.com/questions/6554...te-version

yes it was! thank you so much for your reply!