如何在多个csv中求出每个单元的平均值

import csv
from collections import defaultdict

# 存储每个单元格的总和和计数
cell_sum = defaultdict(int)
cell_count = defaultdict(int)

# 遍历每个CSV文件
csv_files = ['file1.csv', 'file2.csv', 'file3.csv']  # 替换成实际的文件名
for csv_file in csv_files:
    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        for row in reader:
            for i, cell in enumerate(row):
                # 跳过第一行表头
                if reader.line_num == 1:
                    continue
                cell_sum[i] += float(cell)
                cell_count[i] += 1

# 计算每个单元格的平均值
cell_avg = {i: cell_sum[i] / cell_count[i] for i in cell_sum}

# 输出每个单元格的平均值
for cell, avg in cell_avg.items():
    print(f"Cell {cell}: Average = {avg}")