← 返回题库
中级

查询中等额度客户

未完成
中级参考 代码结构已给出，请填写 ____ 处 
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())
期望输出
[(336, 23, 'female', 1, 'own', 'little', 'moderate', 2101, 13, 'radio/TV', 'good'), (193, 29, 'male', 2, 'rent', 'little', None, 2108, 6, 'radio/TV', 'good'), (626, 41, 'male', 2, 'own', 'little', 'rich', 2116, 6, 'furniture/equipment', 'good'), (709, 37, 'male', 1, 'own', 'little', 'moderate', 2118, 9, 'radio/TV', 'good'), (125, 30, 'male', 2, 'own', 'little', 'little', 2121, 12, 'car', 'good'), (494, 39, 'male', 1, 'rent', 'little', 'little', 2122, 12, 'car', 'good'), (761, 24, 'female', 2, 'rent', 'little', 'little', 2124, 18, 'furniture/equipment', 'bad'), (117, 27, 'female', 2, 'rent', None, 'little', 2132, 10, 'furniture/equipment', 'good'), (584, 52, 'female', 3, 'free', None, None, 2133, 12, 'car', 'good'), (20, 48, 'male', 2, 'own', 'little', None, 2134, 9, 'car', 'good')]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册