转发:Python - pandas DataFrame数据的合并与拼接(merge、join、concat)
总结得很全面!
比如将一个文件夹下所有文件合并:
#merge
# import os
#import pandas as pd
# file_list = []
# path = r'input file path /'
# for file in os.listdir(path):
# df = pd.read_csv(path+file)
# file_list.append(df)
# all_VA = pd.concat(file_list)
# all_VA.to_csv(path+'5455.csv',index = False)
# print('done!')