# -*- coding:utf-8 -*-
#file: row_col.py
A = []
infile = open('1.txt','r')
for line in infile:
    line = line.strip()
    a = line.split()
    A.append(a)
infile.close
print '''1、查看学生信息
2、增加学生信息
3、删除学生信息
4、修改学生信息
5、查找学生信息
6、统计分析
7、显示制作人与信息和帮助信息
0、退出班级档案管理系统
'''
f = open('1.txt','r')
operator = int(raw_input('请选择操作:'))
if operator == 1:
    R = f.read()
    print R
    f.close
student = []
if operator == 2:
    num=raw_input('请输入学号')
    name=raw_input('请输入姓名')
    gender=raw_input('请输入性别')
    age=raw_input('请输入年龄')
    eng=raw_input('请输入英语成绩')
    math=raw_input('请输入高数成绩')
    phy=raw_input('请输入大物成绩')
    student=['\n',num,'\t',name,'\t',gender,'\t',age,'\t',eng,'\t',math,'\t',phy]
    f.close()
    f=open('1.txt','a')
    for i in student:
        f.write(i)
elif operator == 3:
    lines=[]
    f.close()
    f=open('1.txt','r')
    for line in f:
        lines.append(line)
        print line
    print '您要删除学生的行数'
    i=int(raw_input('请输入行数'))
    del lines[i-1]
    f.close()
    f=open('1.txt','w')
    f.writelines(lines)
    f.close()
elif operator == 4:
    lines=[]
    f.close()
    f=open('1.txt','r')
    for line in f.readlines():
        lines.append(line)
        print line
    print '请输入您想修改的学生信息所在行数'
    i=int(raw_input('请输入行数'))
    del lines[i-1]
    print ('请输入你想修改的学生学号')
    num=raw_input()
    print ('请输入你想修改的学生姓名')
    name=raw_input()
    print ('请输入你想修改的学生性别')
    gender=raw_input()
    print ('请输入你想修改的学生年龄')
    age=raw_input()
    print ('请输入你想修改的学生的英语成绩')
    eng=raw_input()
    print ('请输入你想修改的学生的高数成绩')
    math=raw_input()
    print ('请输入你想修改的学生的大物成绩')
    phy=raw_input()
    student=['\n',num,'\t',name,'\t',gender,'\t',age,'\t',eng,'\t',math,'\t',phy]
    f.close()
    f=open('1.txt','a')
    for i in student:
        f.write(i)
elif operator == 5:
    f.close()
    f=open('1.txt',"r")
    names=[]
    lines=[]
    for line in f:
        lines.append(line)
        a=line.split()
        name=a[1]
        names.append(name)
        print names
    b=names.index(raw_input('姓名：'))
    print lines[b]
elif operator == 6:
    print '''1.班级人数
    2.最小年龄，最大年龄，平均年龄
    3.最高成绩，最低成绩，平均成绩
    4.按成绩排序
    '''
    operator = int(raw_input('请选择操作:'))
    if operator == 1:
        f.close()
        f=open('1.txt','r')
        lines=[]
        for line in f:
            lines.append(line)
        people=len(lines)
        print '班级人数:',people
    elif operator == 2:
        f.close()
        f=open('1.txt',"r")
        lines=[]
        ages=[]
        for line in f:
            a=line.split()
            age=float(a[3])
            ages.append(age)
        a=len(ages)
        minimum=min(ages)
        maximum=max(ages)
        average=sum(ages[0:a])/a
        print '最小值:',minimum
        print '最大值:',maximum
        print '平均值:',average
    elif operator == 3:
        print '''1.英语
        2.高数
        3.大物
        '''
        operator = int(raw_input('请选择操作:'))
        if operator == 1:
            f.close()
            f=open('1.txt',"r")
            lines=[]
            engs=[]
            for line in f:
                a=line.split()
                eng=float(a[4])
                engs.append(eng)
            a=len(engs)
            mineng=min(engs)
            maxeng=max(engs)
            avereng=sum(engs[0:a])/a
            print '最小值:',mineng
            print '最大值:',maxeng
            print '平均值:',avereng
        elif operator == 2:
            f.close()
            f=open ('1.txt','r')
            lines=[]
            maths=[]
            for line in f:
                a=line.split()
                math=float(a[5])
                maths.append(math)
            a=len(maths)
            minmath=min(maths)
            maxmath=max(maths)
            avermath=sum(maths[0:a])/a
            print '最小值:',minmath
            print '最大值:',maxmath
            print '平均值:',avermath
        elif operator == 3:
            f.close()
            f=open('1.txt','r')
            lines=[]
            phys=[]
            for line in f:
                a=line.split()
                phy=float(a[5])
                phys.append(phy)
            a=len(phys)
            minphy=min(phys)
            maxphy=max(phys)
            averphy=sum(phys[0:a])/a
            print '最小值:',minphy
            print '最大值:',maxphy
            print '平均值:',averphy
    elif operator == 4:
            print '''1.英语
            2.高数
            3.大物
            '''
elif operator == 7:
    print '''
    主要制作者:田耕耘
    团队:谢文坤,王炫澄,李文垚
    特别鸣谢:邓老师的帮助,以及郭笑天同学的帮助
    trips:1、确定操作后敲击回车;
    2、按步骤进行;
    ......
    '''
elif operator == 0:
    pass