← 返回题库
中级

关联分类与预算规则

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    budgets = pd.read_csv(StringIO(open_url(____).read()))
    cats = pd.read_csv(StringIO(open_url(____).read()))
    txs = pd.read_csv(StringIO(open_url(____).read()))
    spend = txs.groupby(____)['____'].sum().reset_index(____)
    summary = budgets.merge(____).merge(____)
    summary['____'] = summary['____'].fillna(____)
    summary['____'] = (summary['____']/summary['____'].astype(____)*____).round(____)
    print(____)
    for _, row in summary.head(____).iterrows():
        status = '____' if row['____']>____ else ('____' if row['____']>float(____) else '____')
        print(____)

示例

输入
solve()
期望输出
Budget vs actual:
  超市生鲜: limit=791.0 spent=2413.06 305.1% [OVER]
  住房水电: limit=1002.0 spent=898.73 89.7% [OK]
  交通出行: limit=204.0 spent=6843.64 3354.7% [OVER]
  网购: limit=985.0 spent=5725.29 581.2% [OVER]
  娱乐: limit=302.0 spent=4056.2 1343.1% [OVER]
  咖啡奶茶: limit=161.0 spent=6245.04 3878.9% [OVER]
  娱乐: limit=269.0 spent=4056.2 1507.9% [OVER]
  网购: limit=220.0 spent=5725.29 2602.4% [OVER]
  交通出行: limit=301.0 spent=6843.64 2273.6% [OVER]
  超市生鲜: limit=888.0 spent=2413.06 271.7% [OVER]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册