← 返回题库
中级

统计退款订单数量与退款金额分布

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    orders=pd.read_csv(StringIO(open_url(____).read()))
    payments=pd.read_csv(StringIO(open_url(____).read()))
    refund_orders=orders[orders['____']=='____']
    print(____)
    refunded_payments=payments[payments['____']=='____']
    print(____)
    print(____)
    print(____)
    merch_refund=refund_orders.groupby(____).size().nlargest(____)
    print(____)
    for mid,cnt in merch_refund.items():
        print(____)

示例

输入
solve()
期望输出
Refund requested orders: 13
Refunded payments: 13
Total refund amount: 1742.54
Avg refund amount: 134.04
Top 3 merchants by refund count:
  MER-0002: 2
  MER-0005: 2
  MER-0014: 2
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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