← 返回题库
初级

实现账户余额查询含冻结可用总余额

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
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(accounts_csv)).to_sql('accounts', conn, index=False, if_exists='replace')
    result = pd.read_sql_query("SELECT account_no, balance, frozen_amount, available_balance FROM accounts ORDER BY id", conn)
    print(result.to_string(index=False))
    conn.close()

示例

输入
solve()
期望输出
account_no    balance  frozen_amount  available_balance
6212001000000001    55000.0              0            55000.0
6212001000000002    18500.0              0            18500.0
6212002000000003    82000.0              0            82000.0
6212001000000004     9800.0           9800                0.0
6212001000000005    36000.0              0            36000.0
6212003000000006    14200.0              0            14200.0
6212002000000007   128000.0              0           128000.0
6212001000000008    37500.0              0            37500.0
6212004000000009    12000.0              0            12000.0
6212003000000010    66000.0              0            66000.0
9900001000000011  5800000.0              0          5800000.0
9900002000000012  2300000.0              0          2300000.0
9900003000000013   980000.0              0           980000.0
      1000000014 50000000.0              0         50000000.0
      2000000015        0.0              0                0.0
6222001000000016    45000.0              0            45000.0
6228001000000017    23000.0              0            23000.0
6215001000000018     8500.0              0             8500.0
6215002000000019     3200.0              0             3200.0
9900004000000020   450000.0              0           450000.0
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册