← 返回题库
中级

实现行内资金清算行内跨账号转账

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    account_types_csv = open_url(____).read()
    payment_channels_csv = open_url(____).read()
    accounts_csv = open_url(____).read()
    transfers_csv = open_url(____).read()
    clearing_batches_csv = open_url(____).read()
    import sqlite3, pandas as pd
    from io import StringIO
    conn = sqlite3.connect(____)
    pd.read_csv(StringIO(____)).to_sql(____)
    pd.read_csv(StringIO(____)).to_sql(____)
    sql = "____""____""____"
    result = pd.read_sql_query(____)
    print(result.to_string(____))
    conn.close()

示例

输入
solve()
期望输出
transfer_no   amount remark
TXN202606030001   5000.0    生活费
TXN202606030002  10000.0     借款
TXN202606040001  20000.0     还款
TXN202606050001  15000.0     工资
TXN202606050002  12000.0     工资
TXN202606050003  18000.0     工资
TXN202606060001   2000.0     缴费
TXN202606070001   3000.0     转账
TXN202606080001   1500.0   扫码支付
TXN202606080002 500000.0   货款结算
TXN202606090001    800.0    水电费
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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