Getting an AttributeError: 'dict' object has no attribute 'parse' . While trying to read into multiple xlsx files

Question

Hello I am trying to read and open two excel files into one data frame however I get this error.

AttributeError: 'dict' object has no attribute 'parse'

My objective is to use pandas and merge these two xlsx files into a data frame. How do I this. Help appreciated Here is my code below:

# import modules
from IPython.display import display
import pandas as pd
import numpy as np
pd.set_option("display.max_rows", 999)
pd.set_option('max_colwidth',100)
%matplotlib inline

# filenames
file_names = ["data/OrderReport.xlsx", "data/OrderReport2.xlsx"]

reading_files = [(pd.read_excel(f, sheetname=None, parse_cols=None))for f in file_names]

frames = [x.parse(x.sheet_names[0], header=None,index_col=None) for x in reading_files]

Answer 1

With the "new" read_excel function it creates a dict of DataFrames (if you pass sheetname=None), there's no need to call parse (as there is no ExcelFile). Previously you had to create an ExcelFile and then parse each sheet. See here.

Therefore reading_files is a list of dicts of DataFrames... It's unclear how you want to merge this into a single-DataFrame (there's lots of choices!).