要求:python合并两个文件夹下相同文件名的csv文件
代码:
folder1_path = r'folder1_path'
folder2_path = r'folder2_path'
save_path = r'save_path '
files1 = os.listdir(folder1_path)
files1 = [file for file in files1 if file.endswith('.csv')]
files2 = os.listdir(folder2_path)
files2 = [file for file in files2 if file.endswith('.csv')]
for file1 in files1:
if file1 in files2:
df1 = pd.read_csv(os.path.join(folder1_path, file1))
df2 = pd.read_csv(os.path.join(folder2_path, file1))
merged_df = pd.concat([df1, df2], ignore_index=True)#按行合并
# 输出合并后的文件
print(f"Merged file for {file1}")
# print(merged_df)
merged_df.to_csv(os.path.join(save_path,file1),index=False)
print('done!')