Skip to content

Instantly share code, notes, and snippets.

@avoajaugochukwu

avoajaugochukwu/append files and output result

Last active July 9, 2020 07:13
Show Gist options
  • Save avoajaugochukwu/5ce19f7da292dc41f1d8b1137163d57c to your computer and use it in GitHub Desktop.
Save avoajaugochukwu/5ce19f7da292dc41f1d8b1137163d57c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
append files and output result
holder_list = list()
for i in range(len(all_excel_files)):
cfile = pd.read_excel(all_excel_files[i])
cfile.insert(0, "file_name", all_excel_files[i])
holder_list.append(cfile)
df = pd.concat(holder_list)
df.to_excel('output.xlsx', index=False)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment