← 返回题库
中级

生成用户复习进度报表

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    schedules=pd.read_csv(StringIO(open_url(____).read()))
    users=pd.read_csv(StringIO(open_url(____).read()))
    def progress_report(____):
        s=schedules[schedules['____']==uid]
        if s.empty: return None
        total=len(____); by_status=dict(s.groupby(____).size())
        mastered=by_status.get(____)
        mastery_pct=round(____) if total>____ else ____
        avg_ef=round(s['____'].mean(),____)
        return {'____':total,'____':by_status.get(____),'____':by_status.get(____),'____':mastered,'____':by_status.get(____),'____':mastery_pct,'____':avg_ef}
    print(____)
    for _,u in users.head(____).iterrows():
        r=progress_report(____)
        if r: print(____)

示例

输入
solve()
期望输出
User progress reports:
  Alice: total=44 mastered=31 (70.5%) avg_ef=2.469
  Bob: total=50 mastered=34 (68.0%) avg_ef=2.478
  Carol: total=50 mastered=32 (64.0%) avg_ef=2.478
  David: total=50 mastered=29 (58.0%) avg_ef=2.458
  Eve: total=50 mastered=41 (82.0%) avg_ef=2.473
  Frank: total=50 mastered=33 (66.0%) avg_ef=2.438
  Grace: total=50 mastered=34 (68.0%) avg_ef=2.462
  Henry: total=50 mastered=27 (54.0%) avg_ef=2.466
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号,在浏览器中直接运行 Python 代码