← 返回题库
初级

实现转账备注用途记录

未完成 100%
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    account_types_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/account_types.csv").read()
    payment_channels_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/payment_channels.csv").read()
    transfer_types_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/transfer_types.csv").read()
    transaction_limits_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/transaction_limits.csv").read()
    accounts_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/accounts.csv").read()
    transfers_csv = open_url("https://data.zuihe.com/dbd/payment/state_01/transfers.csv").read()
    import sqlite3, pandas as pd
    from io import StringIO
    conn = sqlite3.connect(':memory:')
    pd.read_csv(StringIO(transfers_csv)).to_sql('transfers', conn, index=False, if_exists='replace')
    result = pd.read_sql_query("SELECT transfer_no, remark FROM transfers WHERE remark IS NOT NULL AND remark != '' ORDER BY created_at", conn)
    print(result.to_string(index=False))
    conn.close()

示例

输入
solve()
期望输出
transfer_no remark
TXN202606030001    生活费
TXN202606030002     借款
TXN202606040001     还款
TXN202606040002   跨行转账
TXN202606050001     工资
TXN202606050002     工资
TXN202606050003     工资
TXN202606060001     缴费
TXN202606060002   大额转账
TXN202606070001     转账
TXN202606070002     货款
TXN202606070003   大额转账
TXN202606080001   扫码支付
TXN202606080002   货款结算
TXN202606090001    水电费
REV202606090001   冲正10
TXN202606100001   大额转账
TXN202606100002    投资款
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册