如何将多个csv合并为一个具有相同行的csv？

import os
import csv

# 指定CSV文件所在的文件夹路径
folder_path = 'path/to/your/csv/files'

# 指定合并后的CSV文件名
output_file = 'merged.csv'

# 获取文件夹中的所有CSV文件
csv_files = [f for f in os.listdir(folder_path) if f.endswith('.csv')]

# 打开输出文件
with open(output_file, 'w', newline='', encoding='utf-8') as outfile:
    writer = csv.writer(outfile)

    # 遍历所有CSV文件
    for file in csv_files:
        file_path = os.path.join(folder_path, file)

        # 打开CSV文件
        with open(file_path, 'r', newline='', encoding='utf-8') as infile:
            reader = csv.reader(infile)

            # 如果是第一个文件，则写入标题行
            if file == csv_files[0]:
                writer.writerow(next(reader))

            # 写入数据行
            for row in reader:
                writer.writerow(row)

print(f'Merged CSV files into {output_file}')