Combine dictionary of dataframes into 1 single dataframe
I think need concat
with dict comprehension:
dodf = {f: pd.read_excel(f, sheet_name=None) for f in files}
df = pd.concat([v for k,v in dodf.items()])
Or:
dodf = {f: pd.read_excel(f, sheet_name=None) for f in files}
df = pd.concat([pd.concat(v) for k,v in dodf.items()])
df_list = [ v for k,v in dodf.items()]
df = pd.concat(df_list ,axis=1)
does this work? It also depends whether the concat is by columns or by rows...