如何在python中合并更多的csv文件？

import csv
import os

folder_path = "your_folder_path"

file_list = [file for file in os.listdir(folder_path) if file.endswith(".csv")]

output_file = "merged.csv"

with open(output_file, "w", newline="") as outfile:
    writer = csv.writer(outfile)
    
    # 写入表头（如果需要）
    writer.writerow(["Column1", "Column2", "Column3"])  # 替换为实际的表头
    
    for file_name in file_list:
        with open(os.path.join(folder_path, file_name), "r") as infile:
            reader = csv.reader(infile)
            
            # 跳过表头（如果需要）
            next(reader)
            
            # 逐行写入数据
            for row in reader:
                writer.writerow(row)