批量组合CSV删除标题

import csv
import os

def merge_csv_without_header(input_folder, output_file):
    with open(output_file, 'w', newline='') as outfile:
        writer = csv.writer(outfile)
        first_file = True
        for filename in os.listdir(input_folder):
            if filename.endswith('.csv'):
                with open(os.path.join(input_folder, filename), 'r') as infile:
                    reader = csv.reader(infile)
                    header = next(reader)  # 读取标题行
                    if first_file:
                        writer.writerow(header)  # 写入第一个文件的标题行
                        first_file = False
                    for row in reader:
                        writer.writerow(row)

# 示例用法
input_folder = 'path/to/input/folder'
output_file = 'path/to/output/file.csv'
merge_csv_without_header(input_folder, output_file)