← 返回题库
初级

实现账单按日汇总统计

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    txs = pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-ledger/state_02/transactions.csv").read()))
    daily = txs.groupby('tx_date').agg(count=('tx_id','count'),total=('amount','sum'),avg=('amount','mean'),users=('user_id','nunique')).reset_index()
    daily['total'] = daily['total'].round(2); daily['avg'] = daily['avg'].round(2)
    print("Daily summary (first 10):")
    for _, row in daily.head(10).iterrows():
        print(f"  {row['tx_date']}: txs={row['count']} total={row['total']} avg={row['avg']} users={row['users']}")

示例

输入
solve()
期望输出
Daily summary (first 10):
  2026-01-01: txs=5 total=1236.9 avg=247.38 users=5
  2026-01-02: txs=8 total=1668.8 avg=208.6 users=7
  2026-01-03: txs=4 total=1343.86 avg=335.96 users=4
  2026-01-04: txs=6 total=1255.01 avg=209.17 users=6
  2026-01-05: txs=4 total=1004.03 avg=251.01 users=3
  2026-01-06: txs=4 total=1283.58 avg=320.9 users=3
  2026-01-07: txs=4 total=1196.65 avg=299.16 users=4
  2026-01-08: txs=4 total=701.53 avg=175.38 users=3
  2026-01-09: txs=7 total=1497.11 avg=213.87 users=5
  2026-01-10: txs=3 total=381.08 avg=127.03 users=3
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册