python pd.concat([pd.ExcelFile(f) for f in all_filenames} code example
Example: concat dataframe from list of dataframe
import pandas as pd
df = pd.concat(list_of_dataframes)
import pandas as pd
df = pd.concat(list_of_dataframes)