在Python中链接两个大型CSV的记录？

import csv

def merge_csv(file1, file2, output_file):
    # 读取第一个CSV文件
    with open(file1, 'r') as csv_file1:
        csv_reader1 = csv.DictReader(csv_file1)
        data1 = list(csv_reader1)

    # 读取第二个CSV文件
    with open(file2, 'r') as csv_file2:
        csv_reader2 = csv.DictReader(csv_file2)
        data2 = list(csv_reader2)

    # 合并两个CSV文件的记录
    merged_data = data1 + data2

    # 写入合并后的记录到输出文件
    with open(output_file, 'w', newline='') as csv_output:
        fieldnames = merged_data[0].keys()
        writer = csv.DictWriter(csv_output, fieldnames=fieldnames)
        writer.writeheader()
        writer.writerows(merged_data)

file1 = 'path/to/file1.csv'
file2 = 'path/to/file2.csv'
output_file = 'path/to/output.csv'
merge_csv(file1, file2, output_file)