中级
分位数查询
未完成
中级参考
代码结构已给出，请填写 ____ 处
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())
期望输出
[(725, 41, 'female', 1, 'own', 'rich', None, 250, 6, 'car', 'good'), (309, 22, 'male', 1, 'rent', 'little', 'moderate', 276, 9, 'car', 'good'), (177, 52, 'male', 2, 'own', 'quite rich', 'little', 338, 6, 'radio/TV', 'good'), (157, 45, 'male', 1, 'own', 'little', 'little', 339, 12, 'education', 'good'), (458, 27, 'female', 2, 'own', 'little', 'little', 343, 6, 'domestic appliances', 'good'), (379, 52, 'female', 1, 'own', 'moderate', None, 362, 6, 'car', 'good'), (493, 38, 'male', 2, 'own', None, 'moderate', 368, 6, 'radio/TV', 'good'), (590, 58, 'female', 1, 'own', 'little', 'little', 385, 12, 'radio/TV', 'good'), (111, 23, 'female', 2, 'rent', 'little', 'rich', 392, 15, 'education', 'good'), (27, 42, 'female', 2, 'rent', 'rich', 'rich', 409, 12, 'radio/TV', 'good'), (26, 39, 'male', 1, 'own', 'little', None, 426, 6, 'radio/TV', 'good'), (750, 49, 'female', 2, 'own', 'little', 'little', 428, 6, 'furniture/equipment', 'good'), (249, 22, 'female', 2, 'rent', 'little', None, 433, 18, 'radio/TV', 'bad'), (721, 24, 'female', 2, 'rent', 'rich', 'moderate', 433, 6, 'education', 'bad'), (471, 23, 'female', 2, 'own', 'little', 'little', 448, 6, 'education', 'bad'), (964, 22, 'male', 1, 'own', 'little', 'moderate', 454, 6, 'repairs', 'good'), (39, 24, 'male', 2, 'own', 'little', 'moderate', 458, 9, 'radio/TV', 'good'), (811, 28, 'male', 1, 'own', 'little', 'moderate', 484, 6, 'radio/TV', 'good'), (451, 29, 'female', 2, 'own', 'little', None, 518, 6, 'radio/TV', 'good'), (933, 42, 'male', 2, 'own', 'quite rich', None, 522, 12, 'radio/TV', 'good'), (179, 65, 'male', 2, 'own', 'little', 'little', 571, 21, 'car', 'good'), (513, 20, 'male', 2, 'rent', 'little', 'moderate', 585, 12, 'radio/TV', 'good'), (806, 26, 'male', 1, 'own', 'little', 'moderate', 590, 6, 'radio/TV', 'good'), (837, 23, 'female', 1, 'rent', 'little', None, 601, 4, 'furniture/equipment', 'good'), (439, 26, 'female', 0, 'own', 'little', 'rich', 609, 12, 'business', 'bad'), (515, 37, 'female', 2, 'own', 'little', 'little', 609, 6, 'car', 'good'), (90, 56, 'male', 2, 'own', 'little', None, 618, 12, 'radio/TV', 'good'), (220, 26, 'male', 1, 'own', 'little', 'moderate', 625, 12, 'radio/TV', 'good'), (548, 24, 'female', 1, 'own', 'little', 'little', 626, 12, 'radio/TV', 'bad'), (710, 32, 'male', 3, 'own', 'quite rich', None, 629, 18, 'radio/TV', 'good'), (127, 30, 'male', 2, 'own', 'little', 'moderate', 639, 12, 'repairs', 'bad'), (619, 49, 'male', 1, 'own', 'little', None, 640, 12, 'car', 'good'), (869, 24, 'female', 2, 'rent', 'little', 'little', 652, 12, 'furniture/equipment', 'good'), (472, 28, 'male', 1, 'own', 'little', 'little', 654, 9, 'car', 'bad'), (436, 23, 'male', 1, 'rent', 'quite rich', None, 660, 6, 'repairs', 'good'), (529, 41, 'male', 1, 'own', 'little', 'little', 662, 6, 'car', 'good'), (250, 39, 'female', 1, 'own', 'rich', 'little', 666, 6, 'car', 'good'), (300, 54, 'female', 0, 'own', 'little', None, 672, 6, 'car', 'good'), (188, 20, 'male', 2, 'own', 'moderate', 'little', 674, 12, 'radio/TV', 'bad'), (147, 51, 'female', 2, 'own', 'moderate', None, 682, 12, 'car', 'good'), (562, 29, 'female', 2, 'own', 'little', 'rich', 683, 6, 'radio/TV', 'good'), (649, 40, 'male', 1, 'rent', 'little', 'little', 684, 12, 'education', 'bad'), (313, 25, 'male', 1, 'own', 'little', 'moderate', 685, 12, 'car', 'bad'), (759, 35, 'male', 2, 'own', 'little', 'little', 691, 12, 'car', 'bad'), (925, 46, 'male', 2, 'own', 'little', 'little', 697, 12, 'car', 'bad'), (519, 36, 'male', 2, 'free', None, None, 700, 6, 'radio/TV', 'good'), (126, 40, 'male', 1, 'own', 'little', 'little', 701, 12, 'radio/TV', 'good'), (318, 32, 'male', 2, 'own', 'little', None, 701, 12, 'education', 'good'), (222, 30, 'male', 2, 'own', 'little', None, 707, 12, 'radio/TV', 'good'), (316, 38, 'male', 1, 'own', 'little', 'little', 708, 12, 'furniture/equipment', 'good'), (140, 27, 'male', 0, 'own', 'rich', 'rich', 709, 6, 'car', 'good'), (849, 57, 'male', 1, 'own', 'little', 'little', 709, 12, 'radio/TV', 'bad'), (246, 52, 'male', 2, 'own', 'little', None, 717, 12, 'radio/TV', 'good'), (798, 54, 'male', 2, 'own', None, None, 717, 24, 'car', 'good'), (443, 41, 'male', 1, 'own', 'little', None, 719, 12, 'education', 'bad'), (307, 33, 'male', 1, 'own', 'moderate', 'little', 727, 12, 'radio/TV', 'bad'), (354, 46, 'male', 2, 'free', 'quite rich', None, 727, 10, 'education', 'good'), (71, 46, 'male', 1, 'rent', None, None, 730, 7, 'radio/TV', 'good'), (823, 47, 'male', 1, 'own', 'little', 'little', 731, 8, 'car', 'good'), (610, 22, 'female', 2, 'own', 'moderate', 'little', 741, 12, 'domestic appliances', 'bad'), (936, 28, 'female', 1, 'own', 'little', 'rich', 745, 9, 'radio/TV', 'bad'), (640, 27, 'female', 0, 'own', 'little', 'little', 750, 18, 'education', 'bad'), (976, 64, 'female', 2, 'own', 'little', 'moderate', 753, 6, 'radio/TV', 'good'), (463, 38, 'male', 2, 'own', None, 'moderate', 754, 12, 'education', 'good'), (510, 26, 'male', 2, 'own', 'little', 'little', 759, 12, 'car', 'bad'), (732, 44, 'female', 1, 'own', 'little', 'moderate', 760, 8, 'radio/TV', 'good'), (171, 26, 'female', 2, 'own', 'little', None, 763, 12, 'furniture/equipment', 'good'), (137, 66, 'male', 1, 'own', 'quite rich', 'moderate', 766, 12, 'radio/TV', 'bad'), (358, 28, 'male', 2, 'own', 'little', None, 776, 12, 'radio/TV', 'good'), (123, 63, 'male', 2, 'free', 'little', 'rich', 781, 10, 'car', 'good'), (55, 26, 'male', 1, 'own', None, None, 783, 6, 'car', 'good'), (723, 66, 'female', 1, 'own', 'quite rich', 'moderate', 790, 9, 'radio/TV', 'good'), (885, 53, 'female', 2, 'own', 'little', 'little', 795, 12, 'education', 'bad'), (92, 33, 'female', 1, 'own', None, None, 797, 12, 'radio/TV', 'bad'), (265, 37, 'male', 2, 'own', 'little', 'moderate', 802, 15, 'radio/TV', 'bad'), (403, 27, 'male', 1, 'own', 'little', None, 802, 14, 'car', 'good'), (997, 38, 'male', 2, 'own', 'little', None, 804, 12, 'radio/TV', 'good'), (573, 22, 'female', 1, 'own', 'little', 'little', 806, 15, 'business', 'good'), (783, 23, 'female', 1, 'own', 'moderate', 'moderate', 836, 12, 'car', 'bad'), (752, 23, 'female', 1, 'rent', 'moderate', 'moderate', 841, 12, 'business', 'good'), (377, 36, 'male', 2, 'free', None, None, 846, 7, 'radio/TV', 'good'), (146, 39, 'female', 2, 'own', 'little', 'little', 860, 6, 'car', 'good'), (233, 25, 'male', 1, 'own', 'little', 'moderate', 866, 18, 'radio/TV', 'good'), (873, 24, 'female', 2, 'own', None, None, 874, 15, 'domestic appliances', 'good'), (346, 23, 'male', 2, 'own', 'little', 'moderate', 882, 13, 'radio/TV', 'good'), (184, 36, 'male', 2, 'own', 'little', 'moderate', 884, 18, 'car', 'bad'), (836, 21, 'female', 2, 'own', None, None, 886, 12, 'radio/TV', 'good'), (656, 41, 'male', 1, 'own', 'little', 'moderate', 888, 12, 'car', 'bad'), (856, 40, 'female', 2, 'own', None, None, 894, 10, 'education', 'good'), (661, 23, 'male', 2, 'own', None, 'little', 900, 12, 'car', 'bad'), (203, 21, 'male', 2, 'rent', 'little', 'little', 902, 12, 'education', 'bad'), (810, 26, 'male', 2, 'own', 'little', 'moderate', 907, 8, 'business', 'good'), (164, 36, 'male', 2, 'own', 'quite rich', None, 909, 36, 'car', 'good'), (240, 29, 'female', 2, 'own', None, 'little', 915, 24, 'car', 'bad'), (601, 30, 'female', 2, 'own', 'little', 'moderate', 918, 9, 'furniture/equipment', 'bad'), (697, 38, 'female', 0, 'own', 'little', None, 926, 12, 'car', 'good'), (942, 31, 'male', 2, 'own', None, None, 929, 24, 'furniture/equipment', 'good'), (807, 65, 'male', 2, 'own', None, None, 930, 12, 'radio/TV', 'good'), (595, 32, 'female', 1, 'own', 'moderate', 'moderate', 931, 6, 'car', 'bad'), (102, 24, 'female', 2, 'own', 'little', None, 932, 6, 'radio/TV', 'good')]
👑
升级 VIP
解锁全部题目，畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199
