如何使用python将三个csv文件数据写入一个包含一个日期列和三个数据列的csv文件

import csv
from datetime import datetime

header = ['日期', '数据1', '数据2', '数据3']

with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(header)

# 第一个源CSV文件
with open('file1.csv', 'r') as file:
    reader = csv.reader(file)
    next(reader)  # 跳过表头
    for row in reader:
        date = datetime.strptime(row[0], '%Y-%m-%d')  # 假设日期列为第一列
        data1 = float(row[1])  # 假设数据1列为第二列
        data2 = float(row[2])  # 假设数据2列为第三列
        data3 = float(row[3])  # 假设数据3列为第四列

        with open('output.csv', 'a', newline='') as file:
            writer = csv.writer(file)
            writer.writerow([date, data1, data2, data3])

# 第二个源CSV文件
with open('file2.csv', 'r') as file:
    reader = csv.reader(file)
    next(reader)  # 跳过表头
    for row in reader:
        date = datetime.strptime(row[0], '%Y-%m-%d')  # 假设日期列为第一列
        data1 = float(row[1])  # 假设数据1列为第二列
        data2 = float(row[2])  # 假设数据2列为第三列
        data3 = float(row[3])  # 假设数据3列为第四列

        with open('output.csv', 'a', newline='') as file:
            writer = csv.writer(file)
            writer.writerow([date, data1, data2, data3])

# 第三个源CSV文件
with open('file3.csv', 'r') as file:
    reader = csv.reader(file)
    next(reader)  # 跳过表头
    for row in reader:
        date = datetime.strptime(row[0], '%Y-%m-%d')  # 假设日期列为第一列
        data1 = float(row[1])  # 假设数据1列为第二列
        data2 = float(row[2])  # 假设数据2列为第三列
        data3 = float(row[3])  # 假设数据3列为第四列

        with open('output.csv', 'a', newline='') as file:
            writer = csv.writer(file)
            writer.writerow([date, data1, data2, data3])