← 返回题库
中级

OFFSET分页

未完成
中级参考 代码结构已给出，请填写 ____ 处 
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())
期望输出
[(744, 30, 'male', 3, 'own', None, 'little', 14179, 39, 'furniture/equipment', 'good'), (714, 27, 'male', 3, 'own', 'little', 'moderate', 14027, 60, 'car', 'bad'), (373, 63, 'male', 3, 'free', None, None, 13756, 60, 'car', 'good'), (381, 38, 'female', 3, 'free', 'little', 'moderate', 12976, 18, 'car', 'bad'), (921, 37, 'male', 3, 'own', 'quite rich', None, 12749, 48, 'radio/TV', 'good'), (763, 30, 'male', 3, 'free', None, None, 12680, 21, 'car', 'bad'), (87, 47, 'male', 2, 'free', 'moderate', 'moderate', 12612, 36, 'education', 'bad'), (18, 44, 'female', 3, 'free', 'little', 'moderate', 12579, 24, 'car', 'bad'), (563, 37, 'male', 2, 'free', None, 'moderate', 12389, 36, 'car', 'bad'), (615, 48, 'male', 3, 'own', None, 'moderate', 12204, 48, 'business', 'good')]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册