import numpy as np

with open('成绩单数字.csv', 'r', encoding='utf-8') as f:
    dic = {}
    for i in f.readlines():
        i = i.strip().split(',')
        dic[i[0]] = [s for s in i[1:]]

name_of_people, name_of_subject = input(), input()
n = dic['姓名'].index(name_of_subject)
ls = np.array([eval(i) for i in dic[name_of_people][1:]])
lw = np.array([eval(dic[i][n]) for i in list(dic.keys())[1:]])
lw = sorted(lw, reverse=True)
print(f'{name_of_people}同学的总分为{np.sum(ls):.2f}')
print(f'{name_of_people}同学的平均分为{np.mean(ls):.2f}')
print(f'{name_of_subject}课程平均成绩为{np.mean(lw):.2f}')
print(f'{name_of_subject}课程中位数为{np.median(lw):.2f}')
print(f'{name_of_subject}课程标准差为{np.std(lw):.2f}')

扫描下方二维码图片,关注后了解更多精彩内容!!

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐