csv_combine.py

import os
import csv

directory = "/path/to/csv_folder/"
headers = []
merged_file_data = []

for file_name in os.listdir(directory):
    index = 0
    file_path = os.path.join(directory, file_name)
    with open(file_path, "r") as csv_file:
        csv_reader = csv.reader(csv_file)
        for line in csv_reader:
            index += 1
            if index == 1 and not headers:
                headers.append(line)
            elif index == 1:
                continue
            else:
                merged_file_data.append(line)

with open("output.csv", "w") as outfile:
    csv_writer = csv.writer(outfile)
    csv_writer.writerows(headers + merged_file_data)