Charles Avoaja avoajaugochukwu

avoajaugochukwu / install glob

Created July 7, 2020 21:33

pip install glob

avoajaugochukwu / install pandas

Created July 7, 2020 21:57

pip install pandas

avoajaugochukwu / import packages

Created July 7, 2020 22:10

avoajaugochukwu / check for output

Created July 7, 2020 22:14

	if os.path.exists('output.xlsx'):
	os.remove('output.xlsx')

avoajaugochukwu / read all excel files

Last active July 9, 2020 06:23

all_excel_files = [i for i in glob.glob('*.xlsx')]

avoajaugochukwu / so far - read all excel

Created July 9, 2020 06:26

	import os
	import glob
	import pandas as pd

	if os.path.exists('output.xlsx'):
	os.remove('output.xlsx')

	all_excel_files = [i for i in glob.glob('*.xlsx')]

	print(all_excel_files)

avoajaugochukwu / install xlrd

Created July 9, 2020 06:39

pip install xlrd

avoajaugochukwu / install openpyxl

Created July 9, 2020 06:53

pip install openpyxl

avoajaugochukwu / append files and output result

Last active July 9, 2020 07:13

	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)

avoajaugochukwu / combine Excel all code

Created July 9, 2020 07:25

	import os
	import glob
	import pandas as pd

	if os.path.exists('output.xlsx'):
	os.remove('output.xlsx')

	all_excel_files = [i for i in glob.glob('*.xlsx')]

	holder_list = list()