初级
校验账单用户归属一致性
未完成
初级参考
完整示例代码供参考,建议自己理解后重新输入
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()))
rcp = pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-ledger/state_01/receipts.csv").read()))
rcp_map = dict(zip(rcp['receipt_id'], rcp['user_id']))
issues = []
for _, tx in txs[txs['receipt_id']!=''].iterrows():
ruser = rcp_map.get(tx['receipt_id'])
if ruser and ruser != tx['user_id']:
issues.append({'tx':tx['tx_id'],'tx_user':tx['user_id'],'rcp_user':ruser})
print(f"With receipt: {len(txs[txs['receipt_id']!=''])} | Mismatches: {len(issues)}")
for i in issues[:3]:
print(f" {i['tx']}: tx_user={i['tx_user']} != rcp_user={i['rcp_user']}")
示例
输入
solve()
期望输出
With receipt: 250 | Mismatches: 0
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199