← 返回题库
中级

对dti做等距10箱分析

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    loans_clean_csv = open_url(____).read()
    loans_featured_csv = open_url(____).read()
    iv_table_csv = open_url(____).read()
    import pandas as pd
    from io import StringIO
    df = pd.read_csv(StringIO(____))
    df['____']=pd.cut(df['____'].clip(____,____),bins=____)
    grp=df.groupby(____).agg(count=(____),default_rate=(____)).reset_index()
    grp['____']=grp['____'].round(____)
    print(grp.to_string(____))

示例

输入
solve()
期望输出
dti_eq  count  default_rate
(-0.06, 6.0]    697        0.1277
 (6.0, 12.0]   1897        0.1502
(12.0, 18.0]   2562        0.1850
(18.0, 24.0]   2325        0.1996
(24.0, 30.0]   1532        0.2245
(30.0, 36.0]    795        0.2516
(36.0, 42.0]    159        0.2704
(42.0, 48.0]      9        0.2222
(48.0, 54.0]      7        0.1429
(54.0, 60.0]     16        0.3750
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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