my.py

import csv

data = [["姓名", "语文", "数学", "英语"],["小贝", 98, 99, 92],["聪聪", 95, 91, 95]]

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