如何将多个csv文件集群到一个文件目录中

import os
import csv

# 定义文件夹路径和目标文件夹路径
csv_folder = 'path/to/csv/folder'
target_folder = 'path/to/target/folder'

# 创建目标文件夹
os.makedirs(target_folder, exist_ok=True)

# 遍历CSV文件夹
for filename in os.listdir(csv_folder):
    if filename.endswith('.csv'):
        csv_path = os.path.join(csv_folder, filename)
        
        # 打开CSV文件并读取数据
        with open(csv_path, 'r', newline='') as csvfile:
            reader = csv.reader(csvfile)
            data = list(reader)
        
        # 将数据追加到新的CSV文件
        target_file = os.path.join(target_folder, 'merged.csv')
        with open(target_file, 'a', newline='') as csvfile:
            writer = csv.writer(csvfile)
            writer.writerows(data)

# 合并完成
print('CSV文件合并完成！')