学习通人工智能的习题答案（人工智能创新班查询学生历次考试进步程序）

from pyecharts.charts import Bar,Timeline

from pyecharts import options as opts

import pandas as pd

import os

def get_sbd_rank(file,name):

""" 取某人某次考试级排数据 """

file_path = path file

df = pd.read_excel(file_path,sheet_name='创新班数据')

somebody_df = df[df['姓名']==name].loc[:,'语文级排'::3]

col = somebody_df.columns.tolist()

rank_val = somebody_df.values[0].tolist()

# print(col,rank_val)

return col,rank_val

def get_sbd_all_rank(file_path,name):

""" 通过调用上面函数，取某人所有考试级排数据 """

files = os.listdir(file_path)

for file in files:

if file.startswith('【'):

continue

else:files.remove(file)

# print(files)

# 创建图表

timeline = Timeline(init_opts=opts.InitOpts(page_title=f'{name}历次考试级排成绩'))

for file_name in files:

ret = get_sbd_rank(file_name,name) # 取某生单次考试级排数据

print(ret)

""" 某学生历次考试级排轮播 """

bar = Bar()

bar.add_xaxis(ret[0])

title = file_name.split('】')[0][1:]

bar.add_yaxis(series_name=title,y_axis=ret[1])

bar.set_global_opts(title_opts=opts.TitleOpts(title=f'{name} {title} 考试成绩级排(升序)'))

timeline.add(bar,title)

timeline.render(f'某某同学历次考试成绩级排轮播图(升序).html')

print('... 图表已生成 ...')

# file_path = r'C:\Users\Administrator\Desktop\创新班成绩/【7年级上第7周】10月限时训练初一级成绩统计（公布）.xlsx'

path = r'C:\Users\Administrator\Desktop\创新班成绩/'

name = input('请输入姓名：')

get_sbd_all_rank(path,name)

人工智能创新班历次考试级排查询程序