3
Size: a a a
3
IK
IK
KM
KM
KM
IK
KM
IK
IK
AB
IK
IK
MC
A
a
import pandas as pd
from os.path import isfile, join
import os
mypath = r'C:\files\excel'
#files_path = [os.listdir(mypath)]
files_path = [os.path.join(mypath,x) for x in os.listdir(mypath)]
# print (files_path)
all_file_frames = []
for x in files_path:
print('Reading %s'%x)
tab = pd.read_excel(x)
all_file_frames.append(tab)
all_frame = pd.concat(all_file_frames,axis=0)
all_frame.to_excel('final_file.xlsx')
SE
A
SE
A