def csv_students():
    global student_infos
    import csv
    student_infos = []
    with open(r"成绩详细.csv", encoding='utf-8-sig') as file:#将你的CSV文件和该程序文件放在一个文件夹下面
        f_csv = csv.reader(file)
        header = next(f_csv)
        for row in f_csv:
            student_info = {}
            for index in range(6):
                student_info[header[index]] = row[index]
            student_infos.append(student_info)
        # 格式化打印函数，使其输出自动对齐
        add_print1()

def scores_students():
    for scores in student_infos:
        total = float(scores["实验1"]) * 1 / 10 + float(scores["实验2"]) * 1 / 10 + \
                float(scores["实验3"]) * 2 / 10 + float(scores["期末成绩"]) * 6 / 10
        scores["总评成绩"] = total
    # 根据总评成绩进行排名，并打印出来（附加功能）
    student_infos.sort(key=lambda item: item["总评成绩"], reverse=True)
    i = 0
    for score in student_infos:
        i += 1
        score["班级排名"] = i
    add_print2()
    import json
    # 将解析后的CSV文件，转换为python对象，并储存在一个文件里面（附加功能）
    with open(r"student.txt", "w", encoding="utf_8") as file:
        json.dump(student_infos, file, ensure_ascii=False, indent=0)

def grad_students():
    num1 = 0
    num2 = 0
    num3 = 0
    num4 = 0
    num5 = 0
    for scores in student_infos:
        grade = float(scores["总评成绩"])
        if grade < 60:
            num1 += 1
        elif grade >= 60 and grade < 70:
            num2 += 1
        elif grade >= 70 and grade < 80:
            num3 += 1
        elif grade >= 80 and grade < 90:
            num4 += 1
        elif grade >= 90 and grade <= 100:
            num5 += 1
    all = int(num1 + num2 + num3 + num4 + num5)
    print("\t总的人数有%s人" % (all))
    # 打印出分数段人数和所占比
    print("\t[0, 60)的有 {}人 ".format(num1), "\t占比为{}".format(str(num1 / all * 100)[:4] + "%"))
    print("\t[60,70)的有{}人".format(num2), "\t占比为{}".format(str(num2 / all * 100)[:4] + "%"))
    print("\t[70,80)的有{}人".format(num3), "\t占比为{}".format(str(num3 / all * 100)[:4] + "%"))
    print("\t[80,90)的有{}人".format(num4), "\t占比为{}".format(str(num4 / all * 100)[:4] + "%"))
    print("\t[90,100]的有{}人".format(num5), "\t占比为{}".format(str(num5 / all * 100)[:4] + "%"))

def find_students():
    while True:
        study_num = input("请输入您要查找的学号： ")
        for score in student_infos:
            if score["学号"] == study_num:
                print("姓名：", score["姓名"], "学号：", score["学号"], "实验1：",
                      score["实验1"], "实验2：", score["实验2"], "实验3：",
                      score["实验3"], "期末成绩：", score["期末成绩"], "总评成绩：",
                      score["总评成绩"], "班级排名：", score["班级排名"])
            continue