← 返回题库
中级

实现拨备计提贷款余额乘对应拨备率

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    clients_csv = open_url(____).read()
    loans_csv = open_url(____).read()
    loan_classifications_csv = open_url(____).read()
    loan_provisions_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(____)
    lc = pd.read_sql_query(____)
    lp = pd.read_sql_query(____)
    merged = lc.merge(____).fillna(____)
    merged['____'] = (____).round(____)
    merged['____'] = (____).round(____)
    print(merged[['____','____','____','____','____','____','____']].to_string(____))
    conn.close()

示例

输入
solve()
期望输出
loan_id classification  outstanding_balance  provision_rate  theoretical  actual_provision  diff
       1         NORMAL                88000            0.01        880.0             880.0   0.0
       2         NORMAL               795000            0.01       7950.0            7950.0   0.0
       3         NORMAL               500000            0.01       5000.0            5000.0   0.0
       4         NORMAL               145000            0.01       1450.0            1450.0   0.0
       5          WATCH                52000            0.02       1040.0            1040.0   0.0
       6    SUBSTANDARD              1350000            0.25     337500.0          337500.0   0.0
       7         NORMAL              1190000            0.01      11900.0           11900.0   0.0
       8         NORMAL              1800000            0.01      18000.0           18000.0   0.0
       9    SUBSTANDARD                28000            0.25       7000.0            7000.0   0.0
      10         NORMAL                    0            0.01          0.0               0.0   0.0
      11       DOUBTFUL                22000            0.50      11000.0           11000.0   0.0
      12         NORMAL                18000            0.01        180.0             180.0   0.0
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册