my_csv.py

import csv

q = [["姓名", "语文", "数学", "英语"],
     ["小贝", 98, 99, 92],
     ["聪聪", 95, 91, 95]]
with open("scores.csv","w",encoding="utf-8",newline='\n') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(q)
    for i in q:
        writer.writerow(i)