python小技巧---快速合并文件夹中的所有的文件

废话不说。这里直接展示出代码，希望对大家有帮助

import os
import pandas as pd
path = r'E:\xx\xxx'
big_file =[]
for file in os.listdir(path):
    big_file.append(pd.read_excel(os.path.join(path,file)))
writer = pd.ExcelWriter(r'E:\xxx\xx.xlsx')
pd.concat(big_file).to_excel(writer,'sheet1',index=False)
writer.close()