Python写的简单的学生成绩信息管理系统（简单版）

import csv
import os
import pandas as pd
import operator
self_students=[]
self_students_new=[0]


def main():
    main_login()
    while True:
        menu()
        choice = input()
        if choice == '0' :
            break
        elif choice == '1':
            main_login()
            print('此操作会删去之前所有值，请谨慎操作！！！')
            inputlable()
            write(csv_head3)
        elif choice == '2':
            inputinfo()
            write(input_list)
        elif choice == '3':
            find_user()
        elif choice == '4':
            clean_name()
        elif choice == '5':
            demistake()
        elif choice == '6':
            len_num()
        elif choice == '7':
            main_login()
            print_all()
        elif choice == '8':
            sort_goaldown()
        elif choice == '9':
            sort_goalup()
        elif choice == '10':
            go_by()
        elif choice == '11':
            csv_self()
        elif choice == '12':
            csv_goread()
        else:
            print('您输入的选项有错！！请重新输入！！')

def create_csv():
    path = 'datemake.csv'
    with open(path,'a',newline='',encoding='utf-8')as f:
        csv_write = csv.writer(f)

def write(input_list):
    with open('datemake.csv','a',newline='',encoding='utf-8') as f:
        f_csv = csv.writer(f)
        f_csv.writerow(input_list)    

def write(csv_head3):
    with open('datemake.csv','a',newline='',encoding='utf-8') as f:
        f_csv = csv.writer(f)
        f_csv.writerow(csv_head3)
def title():
    print('    学生信息管理系统')

def lines(n):
    print('=' * n)

def main_login():
    if os.path.exists(r'datemake.csv'):
        pass
    else:
        print('                      尚未导入学生信息，请先选择功能1建立成绩项目再导入!!!')
        create_csv()
def main_loginmake():
    with open('datemake.csv','r',encoding='utf-8-sig')as f:
        reader_take=csv.reader(f)
        result_take=list(reader_take)
    if result_take==[]:
        print('                      尚未导入学生信息，请先选择功能1建立成绩项目再选择功能2导入学生信息后使用!!!')
        main()
    else:
        pass

def csv_reader():
    main_loginmake()
    global self_students
    with open('datemake.csv','r')as f:
        reader=csv.reader(f)
        for row in reader:
            self_students.append(row)

def menu():
    title()
    lines(50)
    print("    0   退出系统")
    print("    1   创建成绩项目（首次创建使用）")
    print("    2   录入学生信息")
    print("    3   查找学生信息")
    print("    4   删除学生信息")
    print("    5   修改学生信息")
    print("    6   统计学生总人数")
    print("    7   显示所有学生信息")
    print("    8   按学生成绩高——低显示学生信息")
    print("    9   按学生成绩低——高显示学生成绩")
    print("    10  课程统计信息（每门课程平均分、最高分、最低分；每门课不及格百分比，优秀百分比）")
    print("    11  保存学生信息到文件（student.csv）")
    print("    12  从文件中读取数据（student.csv）")
    lines(50)
    print("请输入你的选择:",end='')

def inputlable():      #创建头文件（1）
    global csv_head3
    with open('datemake.csv','w',newline='',encoding='utf-8') as f:
        f_csv = csv.writer(f)
    csv_head1=[]
    csv_head=['number','name','gender','age']
    while True:
        print("您要创建成绩项目吗(Y/N):",end='')
        choice=input()
        if choice=='N'or choice=='n':
            print('操作成功!!!')
            break
        elif choice=='Y'or choice=='y':
            addlable_key=input('您要输入的项目为:')
            csv_head1.append(addlable_key)
            csv_head3=csv_head+csv_head1
        else:
            print('您的选择有误!!!')

def inputinfo(): #录入学生信息功能（2）
    main_loginmake()
    global input_list
    with open('datemake.csv','r',newline='',encoding='utf-8-sig')as f:
        reader=csv.reader(f)
        result=list(reader)
    input_list=[]
    number=input('number(输入back返回上一级菜单):')
    if number=='back':
        main()
    with open('datemake.csv','r')as csvfiles:
           reader11=csv.DictReader(csvfiles)
           for row in reader11:
               if row['number']==number:
                   print('该学号已存在!!!')
                   main()
    input_list.append(number)
    for i in result[0][1:]:
        print(i,':',end='')
        inputinfos=input()
        input_list.append(inputinfos)
        print('%s录入成功！！'%i)

def find_user():    #查找学生功能（3）
    main_loginmake()
    j=0
    print('你想通过什么方式查找(姓名或学号)')
    print('请输入你的选择(输入back返回上一级菜单):',end='')
    choice=input()
    if choice=='back':
        main()
    query_list=[]
    if choice=='姓名':
       print('请输入你要查询的姓名:',end='')
       choice_name=input()
       with open('datemake.csv','r')as csvfiles:
           reader3=csv.DictReader(csvfiles)
           for row in reader3:
               if row['name']==choice_name:
                   query_list.append(row)
       if query_list==[]:
           print('未查询到该学生信息,请检查是否录入系统!!!')
       else:
           for i in query_list:
               print(i)
    elif choice=='学号':
       print('请输入你要查询的学号:',end='')
       choice_num=input()
       with open('datemake.csv','r')as csvfiles:
           reader3=csv.DictReader(csvfiles)
           for row in reader3:
               if row['number']==choice_num:
                   query_list.append(row)
       if query_list==[]:
           print('未查询到该学生信息,请检查是否录入系统!!!')
       else:
           for i in query_list:
               print(i)
    else:
        print('输入选项有误或查询失败!!!')
def clean_name():
    main_loginmake()
    df=pd.read_csv('datemake.csv')
    ji_time=-1
    print('请输入你要操作的学号(输入back返回上一级菜单):',end='')
    choice_num=input()
    if choice_num=='back':
        main()
    with open('datemake.csv','r')as csvfiles:
        reader3=csv.DictReader(csvfiles)
        for row in reader3:
            ji_time+=1
            if row['number']==choice_num:
                df_new=df.drop(df.index[ji_time], inplace=True)
                df.to_csv('datemake.csv',index=0,encoding='utf-8')
                print('删除成功!!!')

def demistake():
    main_loginmake()
    clean_name()
    print('请重新录入信息')
    inputinfo()
    write(input_list)

def len_num():
    main_loginmake()
    filename='datemake.csv'
    list1=[]
    with open(filename,'r')as file:
            reader=csv.DictReader(file)
            list1=[row['number']for row in reader]
    a=len(list1)
    print('当前系统中共有%d人!!!'%a)
def print_all():
    main_loginmake()
    with open('datemake.csv','r')as csvfiles:
           reader3=csv.DictReader(csvfiles)
           for row in reader3:
               print (row)

def sort_goaldown():
    main_loginmake()
    list_sortdown=[]
    csv_reader()
    print('你想对哪一门成绩进行降序排序(输入back返回上一级菜单):',end='')
    choice=input()
    if choice=='back':
        main()
    df=pd.read_csv('datemake.csv')
    df=df.sort_values(choice)
    df.to_csv('datemake_sort.csv',index=False)
    with open('datemake_sort.csv','r')as f:
           reader5=csv.reader(f)
           result5=list(reader5)
    sort_time=len(result5)
    list_sort_down=[result5[0]]
    for i in result5:
        list_sort_down.append(result5[sort_time-1])
        sort_time-=1
    del list_sort_down[-1]
    for row in list_sort_down:
        print(row)
    
def sort_goalup():
    main_loginmake()
    csv_reader()
    print('你想对哪一门成绩进行升序排序(输入back返回上一级菜单):',end='')
    choice=input()
    if choice=='back':
        main()
    df=pd.read_csv('datemake.csv')
    df=df.sort_values(choice)
    print(df)

def go_by():
    main_loginmake()
    print('请输入设定的及格成绩:',end='')
    passing_score=float(input())
    print('请输入设定的优秀成绩:',end='')
    good_score=float(input())
    csv_reader()
    date=pd.read_csv('datemake.csv')
    date.head(2)
    date_new=date.drop(['number','name','gender','age'],axis=1)
    date_new.to_csv('datemak_new.csv',index=0)
    filename='datemak_new.csv'
    list2=[]
    list_sort=[]
    with open('datemak_new.csv','r',encoding='utf-8-sig')as f:
            reader15=csv.reader(f)
            result=list(reader15)
    go_time_csv=len(result[0])
    for i in range(go_time_csv):
        list1=list2=list_sort=[]
        sum=0
        dispassing_list=[]
        good_list=[]
        with open(filename,'r')as file:
            reader=csv.reader(file)
            list1=[row[i] for row in reader]
            list1[0]=0
            for j in list1:
                sum+=float(j)
                average=sum//(len(list1)-1)
                list_sort.append(float(j))
                if float(j) < passing_score:
                    dispassing_list.append(j)
                if float(j) >good_score:
                    good_list.append(j)
            list_sort.sort()
            max=list_sort[-2]
            min=list_sort[1]
            dispassing_num=float(((len(dispassing_list))/(len(list_sort)-1))*100)
            good_num=float(((len(good_list))/(len(list_sort)-1))*100)
            print(result[0][i],'的平均分为:',average,',最大值为:',max,'最小值为:',min,'不及格百分比为:',dispassing_num,'%','优秀百分比为:',good_num,'%')

def csv_self():
    main_loginmake()
    df=pd.read_csv('datemake.csv')
    df.to_csv('students.csv',index=0,encoding='utf-8')
    print('保存信息到students.csv成功!!!')

def csv_goread():
    csv_self()
    main_loginmake()
    goread=[]
    df=pd.read_csv('students.csv')
    df=df.sort_values('number')
    print(df)


main()

期末的时候写的，还没有优化，先发了后面有时间了优化