如何合并保存在同一主文件夹内不同子文件夹中的2000个CSV文件

import os
import csv

def merge_csv_files(folder_path, output_file):
    # 获取主文件夹下的所有子文件夹
    subfolders = [f.path for f in os.scandir(folder_path) if f.is_dir()]

    with open(output_file, 'w', newline='') as outfile:
        writer = csv.writer(outfile)

        for subfolder in subfolders:
            # 获取子文件夹下的所有CSV文件
            csv_files = [f.path for f in os.scandir(subfolder) if f.is_file() and f.name.endswith('.csv')]

            for csv_file in csv_files:
                with open(csv_file, 'r') as infile:
                    reader = csv.reader(infile)
                    next(reader)  # 跳过CSV文件的标题行

                    for row in reader:
                        writer.writerow(row)

    print("合并完成！")

# 调用函数进行合并
merge_csv_files('主文件夹路径', '合并后的文件路径')