https://share.weiyun.com/6CdBA1Dj
望采纳,谢谢!
def menu():
print('===============================学生信息管理系统==========================')
print('**********************************功能菜单*****************************')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 1.录入学生信息')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 2.查找学生信息')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 3.删除学生信息')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 4.修改学生信息')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 5.学生成绩排序')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 6.统计学生总数')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 7.显示所有学生信息')
print('<span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span><span class="hljs-symbol">\t</span> 0.退出')
print('**********************************************************************')
print('========================================================================')
def main():
<span class="hljs-keyword">while</span> <span class="hljs-literal">True</span>:
menu()
choice = int (input(<span class="hljs-string">'请选择:'</span>))
<span class="hljs-keyword">if</span> choice <span class="hljs-keyword">in</span> [0,1,2,3,4,5,6,7]:
<span class="hljs-keyword">if</span> <span class="hljs-attribute">choice</span>==0:
answer = input(<span class="hljs-string">'您确定要退出吗?(y/n)'</span>)
<span class="hljs-keyword">if</span> <span class="hljs-attribute">answer</span>=='Y' <span class="hljs-keyword">or</span> answer ==<span class="hljs-string">'y'</span>:
<span class="hljs-built_in">print</span>(<span class="hljs-string">'感谢您的使用!'</span>)
break
<span class="hljs-keyword">else</span>:
continue
elif <span class="hljs-attribute">choice</span>==1:
insert()
elif <span class="hljs-attribute">choice</span>==2:
search()
elif <span class="hljs-attribute">choice</span>==3:
delete()
elif <span class="hljs-attribute">choice</span>==4:
modify()
elif <span class="hljs-attribute">choice</span>==5:
sort()
elif <span class="hljs-attribute">choice</span>==6:
total()
elif <span class="hljs-attribute">choice</span>==7:
show()
<span class="hljs-keyword">else</span>:
<span class="hljs-built_in">print</span>(<span class="hljs-string">'输入无效!请重新输入(0~7):'</span>)
continue
<span class="hljs-keyword">def</span> <span class="hljs-title function_">insert</span>():
student_list = []
<span class="hljs-keyword">while</span> <span class="hljs-literal">True</span>:
sid = <span class="hljs-built_in">int</span>(<span class="hljs-built_in">input</span>(<span class="hljs-string">'请输入学号:'</span>))
<span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> sid:
<span class="hljs-keyword">break</span>
sname = <span class="hljs-built_in">input</span>(<span class="hljs-string">'请输入学生姓名:'</span>)
<span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> sname:
<span class="hljs-keyword">break</span>
<span class="hljs-keyword">try</span>:
english = <span class="hljs-built_in">int</span>(<span class="hljs-built_in">input</span>(<span class="hljs-string">'请输入English成绩:'</span>))
java = <span class="hljs-built_in">int</span>(<span class="hljs-built_in">input</span>(<span class="hljs-string">'请输入java成绩:'</span>))
python = <span class="hljs-built_in">int</span>(<span class="hljs-built_in">input</span>(<span class="hljs-string">'请输入python成绩:'</span>))
<span class="hljs-keyword">except</span>:
<span class="hljs-built_in">print</span>(<span class="hljs-string">'输入数据无效!请重新输入:\n'</span>)
<span class="hljs-keyword">continue</span>
stu = {<span class="hljs-string">'sid'</span>:sid,<span class="hljs-string">'sname'</span>:sname,<span class="hljs-string">'English'</span>:english,<span class="hljs-string">'java'</span>:java,<span class="hljs-string">'python'</span>:python}
<span class="hljs-comment">#将学生信息添加到列表中</span>
student_list.append(stu)
answer = <span class="hljs-built_in">input</span>(<span class="hljs-string">'是否要继续添加?(y/n)'</span>)
<span class="hljs-keyword">if</span> answer==<span class="hljs-string">'y'</span> <span class="hljs-keyword">or</span> answer==<span class="hljs-string">'Y'</span>:
<span class="hljs-keyword">continue</span>
<span class="hljs-keyword">else</span>:
<span class="hljs-keyword">break</span>
<span class="hljs-comment">#调用save()方法将学生信息添加到文件中</span>
save(student_list)
<span class="hljs-built_in">print</span>(<span class="hljs-string">'学生信息录入成功!'</span>)
<span class="hljs-keyword">def</span> <span class="hljs-title function_">save</span>(<span class="hljs-params"><span class="hljs-built_in">list</span></span>):
<span class="hljs-keyword">try</span>:
stu_txt = <span class="hljs-built_in">open</span>(filename,<span class="hljs-string">'a'</span>,encoding=<span class="hljs-string">'utf-8'</span>)
<span class="hljs-keyword">except</span>:
stu_txt = <span class="hljs-built_in">open</span>(filename,<span class="hljs-string">'w'</span>,encoding=<span class="hljs-string">'utf-8'</span>)
<span class="hljs-keyword">for</span> item <span class="hljs-keyword">in</span> <span class="hljs-built_in">list</span>:
stu_txt.write(<span class="hljs-built_in">str</span>(item)+<span class="hljs-string">'\n'</span>)
stu_txt.close()
这要写前台吧,还得用pandas