python 写读CSV文件，计算总分以及平均分

import csv

results = [["姓名", "总分", "平均分"]]

rows = [
["姓名", "语文", "数学", "英语"],
["张三", 85, 92, 78],
["李四", 78, 88, 82],
["王五", 90, 76, 85],
]

with open("scores.csv", "w", newline="", encoding="utf-8") as f:
writer = csv.writer(f)
writer.writerows(rows)

with open("scores.csv", encoding="utf-8") as f:
reader = csv.DictReader(f)
for row in reader:
name = row["姓名"]
chinese = int(row["语文"])
math_score = int(row["数学"])
english = int(row["英语"])
total = chinese + math_score + english
avg = total / 3
results.append([name, total, f"{avg:.2f}"])

with open("report.csv", "w", newline="", encoding="utf-8") as f:
writer = csv.writer(f)
writer.writerows(results)