As noted in the release email, linked to from the release tweet and noted in large orange warning that appears on the front page of the documentation, and less orange, but still present, in the readme on the repository and the release on pypi:
xlrd has explicitly removed support for anything other than xls files.
In your case, the solution is to:
- make sure you are on a recent version of Pandas, at least 1.0.1, and preferably the latest release. 1.2 will make his even clearer.
- install
openpyxl
: https://openpyxl.readthedocs.io/en/stable/ - change your Pandas code to be:
df1 = pd.read_excel( os.path.join(APP_PATH, "Data", "aug_latest.xlsm"), engine='openpyxl', )
Related Posts:
- Renaming column names in Pandas
- Delete a column from a Pandas DataFrame
- Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- Writing a pandas DataFrame to CSV file
- Adding new column to existing DataFrame in Python pandas
- Modifing data while using iterrows() does not work
- How to change the order of DataFrame columns?
- What does `ValueError: cannot reindex from a duplicate axis` mean?
- Pandas DataFrame Groupby two columns and get counts
- ValueError: Unknown label type: ‘continuous’
- How to fix IndexError: invalid index to scalar variable
- ImportError: No module named pandas
- Create a Pandas Dataframe by appending one row at a time
- Creating an empty Pandas DataFrame, then filling it?
- How do I select rows from a DataFrame based on column values?
- How do I get the row count of a Pandas DataFrame?
- Python Pandas Counting the Occurrences of a Specific value
- Convert pandas dataframe to NumPy array
- Count unique values per groups with Pandas
- DataFrame constructor not properly called
- Convert pandas Series to DataFrame
- Error:cannot convert float NaN to integer in pandas
- ImportError: Missing required dependencies [‘numpy’]
- Replacing column values in a pandas DataFrame
- How to iterate over rows in a DataFrame in Pandas
- How do I get the row count of a Pandas DataFrame?
- Pandas “Can only compare identically-labeled DataFrame objects” error
- Pandas: ValueError: cannot convert float NaN to integer
- Get list from pandas dataframe column or row?
- ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
- ‘DataFrame’ object has no attribute ‘sort’
- ‘DataFrame’ object has no attribute ‘sort’
- pandas: merge (join) two data frames on multiple columns
- TypeError: cannot unpack non-iterable int objec
- Pandas DataFrame column to list
- Rename Pandas DataFrame Index
- Convert DataFrame column type from string to datetime, dd/mm/yyyy format
- How to customize a scatter matrix to see all titles?
- Get a list from Pandas DataFrame column headers
- What is dtype(‘O’), in pandas?
- What is dtype(‘O’), in pandas?
- Python TypeError: cannot convert the series to
when trying to do math on dataframe - ValueError: ‘object too deep for desired array’
- Shuffle DataFrame rows
- How to take column-slices of dataframe in pandas
- Group by index + column in pandas
- Pandas: change data type of Series to String
- Normalize data in pandas
- Convert a Pandas DataFrame to a dictionary
- Selecting with complex criteria from pandas.DataFrame
- Create a Pandas Dataframe by appending one row at a time
- module ‘pandas’ has no attribute ‘rolling_mean’
- Modify the legend of pandas bar plot
- Count unique values using pandas groupby
- Ignoring NaNs with str.containsv
- Count unique values per groups with Pandas [duplicate]
- Map to List error: Series object not callable
- Pandas DataFrame: replace all values in a column, based on condition
- How to convert string to datetime format in pandas python?
- No numeric types to aggregate – change in groupby() behaviour?
- Pandas – How to flatten a hierarchical index in columns
- Pandas OR statement ending in series contains
- Solution for SpecificationError: nested renamer is not supported while agg() along with groupby()
- How to check if a column exists in Pandas
- How to get a value from a cell of a dataframe?
- Pandas split DataFrame by column value
- Groupby value counts on the dataframe pandas
- AttributeError: ‘Series’ object has no attribute ‘reshape’
- Pandas – Drop function error (label not contained in axis)
- Pandas index column title or name
- Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
- datetime to string with series in pandas
- import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
- How to add pandas data to an existing csv file?
- Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
- Find the unique values in a column and then sort them
- pandas groupby sort within groups
- if else function in pandas dataframe
- cannot convert the series to
- Read data (.dat file) with Pandas
- How to convert index of a pandas dataframe into a column
- Replacing Pandas or Numpy Nan with a None to use with MysqlDB
- pandas replace multiple values one column
- Boolean Series key will be reindexed to match DataFrame index
- Convert floats to ints in Pandas?
- pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
- Difference between data type ‘datetime64[ns]’ and ‘
- Merging two DataFrames
- pandas: multiple conditions while indexing data frame – unexpected behavior
- Extract first and last row of a dataframe in pandas
- How to print a specific row of a pandas DataFrame?
- Logical operators for Boolean indexing in Pandas
- How to update Pandas from Anaconda and is it possible to use eclipse with this last
- vectorize conditional assignment in pandas dataframe
- Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
- Extracting specific selected columns to new DataFrame as a copy
- Compare two columns using pandas
- alueError: ordinal must be >= 1