← 返回题库
中级

奶茶咖啡分类预算专项追踪

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    txs=pd.read_csv(StringIO(open_url(____).read()))
    budgets=pd.read_csv(StringIO(open_url(____).read()))
    cafe=txs[txs['____']=='____']; cb=budgets[budgets['____']=='____']
    print(____)
    print(____)
    by_user=cafe.groupby(____)['____'].sum().reset_index()
    merged=by_user.merge(____).fillna(____)
    merged['____']=merged['____'].astype(____)
    over=merged[merged['____']>merged['____']]
    print(____)
    for _,r in over.iterrows(): print(____)

示例

输入
solve()
期望输出
Cafe: 23 txs total=6245.04 avg=271.52
Users with cafe budget: 15
Over budget: 14
  USR-0001: spent=900.25 limit=0.0
  USR-0004: spent=315.41 limit=0.0
  USR-0012: spent=270.6 limit=171.0
  USR-0014: spent=54.75 limit=0.0
  USR-0015: spent=540.4 limit=157.0
  USR-0016: spent=182.68 limit=0.0
  USR-0018: spent=1057.09 limit=112.0
  USR-0019: spent=472.98 limit=0.0
  USR-0020: spent=714.83 limit=0.0
  USR-0021: spent=149.47 limit=85.0
  USR-0025: spent=961.7 limit=0.0
  USR-0027: spent=131.7 limit=82.0
  USR-0028: spent=455.67 limit=91.0
  USR-0029: spent=37.51 limit=0.0
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册