随机生成50名学生，姓名，学号，语数外各科成绩，并存至csv文件中

[王宝龙]

import random
import pandas as pd
from faker import Faker
from random import randint
import csv
header = ['id', '学号', '姓名', '语文','数学','外语']
fake = Faker("zh-cn")//能够识别（输出）中文gbk或者utf-8编码
rows=[[]]
for id in range(1,51):
    if id<10:
        rows=rows+[[id,'202012200040'+str(id),fake.name(),random.randint(0,99),random.randint(0,99),random.randint(0,99)]]
    else:
        rows = rows + [[id, '20201220004' + str(id), fake.name(), random.randint(0, 99), random.randint(0, 99),
                        random.randint(0, 99)]]
del(rows[0])
with open('score.csv', 'w', encoding='UTF8', newline='') as f:
    writer = csv.writer(f)
        # write the header
    writer.writerow(header)
        # write the data
    writer.writerows(rows)
df = pd.read_csv("score.csv")
df.head(6)
df.drop([3])
df.to_csv("data_new1.csv",index=True,encoding="utf-8")