← 返回题库
中级

子查询：IN中使用

未完成
中级参考 代码结构已给出，请填写 ____ 处 
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())
期望输出
[(63, 25, 'male', 2, 'own', 'little', 'moderate', 14421, 48, 'business', 'bad'), (95, 58, 'male', 2, 'rent', 'little', 'moderate', 15945, 54, 'business', 'bad'), (236, 23, 'male', 0, 'own', None, 'moderate', 14555, 6, 'car', 'bad'), (374, 60, 'female', 3, 'free', 'moderate', 'moderate', 14782, 60, 'vacation/others', 'bad'), (378, 57, 'male', 3, 'free', 'little', 'moderate', 14318, 36, 'car', 'bad'), (637, 21, 'male', 2, 'own', 'little', None, 15653, 60, 'radio/TV', 'good'), (818, 43, 'male', 3, 'own', 'little', 'little', 15857, 36, 'vacation/others', 'good'), (887, 23, 'male', 2, 'own', 'little', 'moderate', 15672, 48, 'business', 'bad'), (915, 32, 'female', 3, 'own', 'little', 'moderate', 18424, 48, 'vacation/others', 'bad'), (917, 68, 'male', 3, 'own', 'little', 'little', 14896, 6, 'car', 'bad')]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册