处理json文件，并将数据汇总至Excel表格

从scores.jason文件中读取学生信息,输出学生的学号，姓名，各科成绩，平均分, 各科标准差

效果：

# # 从scores.jason文件中读取学生信息,输出学生的学号，姓名，各科成绩，平均分, 各科标准差
import statistics as stats
import openpyxl
import json
wb = openpyxl.Workbook()
sheet = wb.active
with open('../scores.json', mode='r', encoding='utf-8') as file_obj:
    result_dict = json.load(file_obj)
    scores_list = result_dict['成绩']
    # 处理数据
    # 语文分数
    verbol_scores = list()
    math_scores = list()
    eng_scores = list()
    for studend in scores_list: # type: dict
        sum_scores = 0
        for k, v in studend.items():
            if k == '语文':
                verbol_scores.append(v)
                sum_scores += v
            if k == '数学':
                math_scores.append(v)
                sum_scores += v
            if k == '英语':
                eng_scores.append(v)
                sum_scores += v
        studend['平均分'] = round(sum_scores/3, 2)
    # 按照平均分大小排序，升序
    scores_list.sort(key=lambda x: x['平均分'], reverse=False)

    # 计算标准差
    verbol_std, math_std, eng_std = stats.pstdev(verbol_scores), stats.pstdev(math_scores), stats.pstdev(eng_scores)

    # 写数据
    sheet.append([i for i in scores_list[0]])
    for student in scores_list: # type: dict
        # 将dict_values对象转化为list
        sheet.append(list(student.values()))
    print(scores_list)
    # 写标准差
    row = sheet.max_row + 1
    for col, value in zip(('CDE'), (verbol_std, math_std, eng_std)):
        sheet[f'{col}{row}'] = value


wb.save('C://Users/小碧宰治/Desktop/test.xlsx')