← 返回题库
中级

贷款期限分析

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(____)
    df = pd.read_csv(____)
    df.to_sql(____)
    result = conn.execute(____).fetchall()
    conn.close()
    return result

示例

输入
print(solve())
期望输出
[(4, 1662.8333333333333, 6), (5, 3448.0, 1), (6, 1787.7333333333333, 75), (7, 1779.2, 5), (8, 1373.0, 7), (9, 1714.7142857142858, 49), (10, 1888.9642857142858, 28), (11, 3047.8888888888887, 9), (12, 1787.4469273743016, 179), (13, 1547.25, 4), (14, 3790.75, 4), (15, 2216.171875, 64), (16, 1900.0, 2), (18, 2718.336283185841, 113), (20, 4313.25, 8), (21, 3073.5333333333333, 30), (22, 1979.0, 2), (24, 3243.554347826087, 184), (26, 7966.0, 1), (27, 4647.153846153846, 13), (28, 4857.666666666667, 3), (30, 4494.4, 40), (33, 4766.0, 3), (36, 5748.180722891566, 83), (39, 8405.8, 5), (40, 5998.0, 1), (42, 5846.818181818182, 11), (45, 5202.8, 5), (47, 10722.0, 1), (48, 7405.604166666667, 48), (54, 12690.5, 2), (60, 9973.76923076923, 13), (72, 5595.0, 1)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册