pandas向下合并多个excel文件,注意concat合并出现错位混乱不对齐
一、所有excel放在文件夹合并:向下合并import pandas as pdimport osdef concat_excel(path,save_name): file_name_list = os.listdir(path) data_list = [] for i in file_name_list: if '.xlsx' in i: data = pd.read_excel(path+'\\'+i,header=None)