如何合并几个csv文件的平均字段？

import csv

# 定义要合并的CSV文件列表
csv_files = ['file1.csv', 'file2.csv', 'file3.csv']

# 定义要合并的字段名称
field_name = '字段名'

# 初始化存储平均字段值的列表
average_values = []

# 逐个读取CSV文件并计算平均字段值
for file in csv_files:
    with open(file, 'r') as csv_file:
        csv_reader = csv.DictReader(csv_file)
        total_value = 0
        count = 0
        for row in csv_reader:
            total_value += float(row[field_name])
            count += 1
        average_value = total_value / count
        average_values.append(average_value)

# 写入新的CSV文件
with open('merged.csv', 'w', newline='') as csv_file:
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(['文件名', '平均字段值'])
    for i, file in enumerate(csv_files):
        csv_writer.writerow([file, average_values[i]])