appended_data = []
for infile in glob.glob('*.xlsx'):
    data = pandas.read_excel(infile)
appended_data.append(data)
appended_data = pd.concat(appended_data, axis=1)
appended_data.to_excel('appedned.xlsx')
Appending pandas dataframes generated in a for loop