← 返回题库
中级

计算各分类预算消耗进度

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    budgets = pd.read_csv(StringIO(open_url(____).read()))
    txs = pd.read_csv(StringIO(open_url(____).read()))
    print(____)
    for _, b in budgets.head(____).iterrows():
        spent = round(txs[(____)&(____)]['____'].sum(),____)
        limit = float(____)
        pct = round(____) if limit>____ else ____
        status = '____' if pct>=____ else ('____' if pct>=float(____) else '____')
        print(____)

示例

输入
solve()
期望输出
Budget usage (first 10):
  USR-0001 CAT-03: limit=791.0 spent=271.24 34.3% [OK]
  USR-0001 CAT-12: limit=1002.0 spent=0.0 0.0% [OK]
  USR-0001 CAT-04: limit=204.0 spent=0.0 0.0% [OK]
  USR-0001 CAT-05: limit=985.0 spent=285.13 28.9% [OK]
  USR-0001 CAT-06: limit=302.0 spent=237.61 78.7% [OK]
  USR-0002 CAT-02: limit=161.0 spent=0.0 0.0% [OK]
  USR-0002 CAT-06: limit=269.0 spent=0.0 0.0% [OK]
  USR-0002 CAT-05: limit=220.0 spent=674.89 306.8% [OVER]
  USR-0002 CAT-04: limit=301.0 spent=185.61 61.7% [OK]
  USR-0003 CAT-03: limit=888.0 spent=0.0 0.0% [OK]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册