采用python文件相关函数和方法,使用faker随机生成20个学生的姓名,平时成绩,期中成绩,期末成绩,姓名要求中文名,成绩介于40到100之间,然后输入到成绩表.csv文件中,读取成绩表.csv文件数据计算每个学生最终成绩,最终成绩=平时成绩0.2+期中成绩0.3+期末成绩*0.5,然后将学生姓名和最终成绩写入score.csv文件中,格式要求姓名和最终成绩用逗号隔开,每个学生数据输出后换行
时间: 2023-05-31 19:03:18 浏览: 82
# 导入相关模块
import csv
from faker import Faker
import random
# 随机生成20个学生的姓名,平时成绩,期中成绩,期末成绩
def create_scores():
fake = Faker('zh_CN') # 中文名
scores = []
for i in range(20):
name = fake.name()
usual_score = random.randint(40, 100)
midterm_score = random.randint(40, 100)
final_score = random.randint(40, 100)
scores.append([name, usual_score, midterm_score, final_score])
return scores
# 将数据写入csv文件中
def write_to_csv(data):
with open('成绩表.csv', 'w', newline='', encoding='utf-8') as f:
writer = csv.writer(f)
writer.writerow(['姓名', '平时成绩', '期中成绩', '期末成绩'])
writer.writerows(data)
# 读取csv文件中的数据,计算每个学生的最终成绩并写入文件中
def calculate_score():
with open('成绩表.csv', 'r', newline='', encoding='utf-8') as f:
reader = csv.reader(f)
next(reader) # 跳过表头
scores = []
for row in reader:
usual_score = int(row[1])
midterm_score = int(row[2])
final_score = int(row[3])
total_score = usual_score * 0.2 + midterm_score * 0.3 + final_score * 0.5
name = row[0]
scores.append([name, round(total_score, 2)])
with open('score.csv', 'w', newline='', encoding='utf-8') as f:
writer = csv.writer(f)
writer.writerow(['姓名', '最终成绩'])
writer.writerows(scores)
if __name__ == '__main__':
scores = create_scores() # 调用函数生成数据
write_to_csv(scores) # 将数据写入csv文件中
calculate_score() # 读取csv文件中的数据,计算每个学生的最终成绩并写入文件中