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!

Related Posts:

  1. Loading a file with more than one line of JSON into Pandas
  2. Renaming column names in Pandas
  3. How to deal with SettingWithCopyWarning in Pandas
  4. How to deal with SettingWithCopyWarning in Pandas
  5. How to iterate over rows in a DataFrame in Pandas
  6. Writing a pandas DataFrame to CSV file
  7. ImportError: No module named pandas
  8. How to change the order of DataFrame columns?
  9. RuntimeWarning: invalid value encountered in divide
  10. ImportError: No module named pandas. Pandas installed pip
  11. How can I use the apply() function for a single column?
  12. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  13. “Series objects are mutable and cannot be hashed” error
  14. WinError 2 The system cannot find the file specified (Python)
  15. Merging dataframes on index with pandas
  16. Could not find a version that satisfies the requirement tensorflow
  17. sklearn error ValueError: Input contains NaN, infinity or a value too large for dtype(‘float64’)
  18. Convert Python dict into a dataframe
  19. Local variable referenced before assignment?
  20. re.sub erroring with “Expected string or bytes-like object”
  21. ln (Natural Log) in Python
  22. How do I select rows from a DataFrame based on column values?
  23. How do I select rows from a DataFrame based on column values?
  24. DataFrame constructor not properly called! error
  25. Pandas group-by and sum
  26. How do I get the row count of a Pandas DataFrame?
  27. Python pandas groupby aggregate on multiple columns, then pivot
  28. Python Traceback (most recent call last)
  29. How to pip or easy_install tkinter on Windows
  30. Python Pandas – Missing required dependencies [‘numpy’] 1
  31. What is the meaning of [:] in python [duplicate]
  32. pandas DataFrame “no numeric data to plot” error
  33. Remove list from list in Python
  34. pandas: filter rows of DataFrame with operator chaining
  35. Pandas how to use pd.cut()
  36. How to Read .txt in Pandas
  37. Get a list from Pandas DataFrame column headers
  38. How to import files in python using sys.path.append?
  39. Get total of Pandas column
  40. How do I install the yaml package for Python?
  41. Type error: cannot convert the series to
  42. Change figure size and figure format in matplotlib
  43. How to check whether a pandas DataFrame is empty?
  44. Convert columns to string in Pandas
  45. Change column type in pandas
  46. Create 3D array using Python
  47. Python: pandas merge multiple dataframes
  48. How to load a tsv file into a Pandas DataFrame?
  49. How to count the NaN values in a column in pandas DataFrame
  50. How to iterate over columns of pandas dataframe to run regression
  51. JSON to pandas DataFrame
  52. Converting between datetime and Pandas Timestamp objects
  53. Pandas – DataFrame object is not callable
  54. Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
  55. Convert pandas data frame to series
  56. Converting strings to floats in a DataFrame
  57. Get first row value of a given column
  58. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  59. How to add an empty column to a dataframe?
  60. Deleting DataFrame row in Pandas based on column value
  61. How to apply a function to two columns of Pandas dataframe
  62. Pandas long to wide reshape, by two variables
  63. Python – ‘ascii’ codec can’t decode byte
  64. Convert categorical data in pandas dataframe
  65. Difference between scikit-learn and sklearn
  66. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  67. SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
  68. How to detect key presses?
  69. OSError: Initializing from file failed on csv in Pandas
  70. AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
  71. Insert a row to pandas dataframe
  72. Python Pandas ValueError Arrays Must be All Same Length
  73. How to save a Seaborn plot into a file
  74. TypeError: ‘_io.TextIOWrapper’ object is not subscriptable
  75. Subtract two columns in dataframe
  76. pandas DataFrame: replace nan values with average of columns
  77. Plot correlation matrix using pandas
  78. Pandas error “Can only use .str accessor with string values”
  79. Python 101: Can’t open file: No such file or directory
  80. TypeError: argument of type ‘NoneType’ is not iterable
  81. Rename specific column(s) in pandas
  82. How to convert column with dtype as object to string in Pandas Dataframe
  83. Installation of pygame with Anaconda
  84. urllib and “SSL: CERTIFICATE_VERIFY_FAILED” Error
  85. Pandas: sum up multiple columns into one column without last column
  86. python pandas remove duplicate columns
  87. How can I copy a Python string?
  88. What is the meaning of “int(a[::-1])” in Python?
  89. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  90. Python: Convert timedelta to int in a dataframe
  91. How to completely uninstall python 2.7.13 on Ubuntu 16.04
  92. Calculate weighted average using a pandas/dataframe
  93. Got continuous is not supported error in RandomForestRegressor
  94. Spell Checker for Python
  95. ValueError: multiclass format is not supported
  96. In python, how can I print lines that do NOT contain a certain string, rather than print lines which DO contain a certain string:
  97. input() error – NameError: name ‘…’ is not defined
  98. ValueError: Must pass DataFrame with boolean values only
  99. Python 2.7 mixing iteration and read methods would lose data
  100. Homebrew brew doctor warning about /Library/Frameworks/Python.framework, even with brew’s Python installed

Leave a Comment