← 返回题库
中级

分析取餐记录与未取餐情况

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    srv=pd.read_csv(StringIO(open_url(____).read()))
    print(____)
    served=len(____); total=len(____)
    print(____)
    print(____)
    by_type=srv.groupby(____).agg(total=(____),served=(____)).reset_index()
    print(____)
    for _,r in by_type.iterrows():
        rate=round(____) if r['____']>____ else ____
        print(____)

示例

输入
solve()
期望输出
Total records: 800
Served: 760 (95.0%)
Not served: 40 (5.0%)
By meal type:
  breakfast: 209/215 (97.2%)
  dinner: 195/207 (94.2%)
  lunch: 356/378 (94.2%)
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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