初级

WHERE：小于条件

未完成

初级参考完整示例代码供参考，建议自己理解后重新输入

def solve():
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(':memory:')
    df = pd.read_csv('https://liangdaima.com/static/data/german_credit_risk.csv')
    df.to_sql('german_credit_risk', conn, index=False)
    result = conn.execute('SELECT * FROM german_credit_risk WHERE Age < 25').fetchall()
    conn.close()
    return result

示例

输入

print(solve())

期望输出

[(1, 22, 'female', 2, 'own', 'little', 'moderate', 5951, 48, 'radio/TV', 'bad'), (11, 24, 'female', 2, 'rent', 'little', 'little', 4308, 48, 'business', 'bad'), (12, 22, 'female', 2, 'own', 'little', 'moderate', 1567, 12, 'radio/TV', 'good'), (39, 24, 'male', 2, 'own', 'little', 'moderate', 458, 9, 'radio/TV', 'good'), (43, 24, 'male', 2, 'rent', 'moderate', 'little', 6187, 30, 'car', 'good'), (47, 23, 'female', 0, 'rent', 'quite rich', 'little', 1352, 6, 'car', 'good'), (58, 23, 'female', 3, 'own', 'little', 'rich', 1961, 18, 'car', 'good'), (59, 23, 'female', 1, 'rent', 'little', 'little', 6229, 36, 'furniture/equipment', 'bad'), (67, 22, 'male', 2, 'own', 'rich', 'moderate', 1007, 12, 'car', 'good'), (79, 22, 'male', 2, 'own', 'little', 'moderate', 3832, 30, 'furniture/equipment', 'good'), (82, 24, 'female', 1, 'rent', 'moderate', None, 1568, 18, 'business', 'good'), (93, 20, 'male', 2, 'rent', None, 'rich', 3617, 24, 'furniture/equipment', 'good'), (101, 24, 'male', 2, 'rent', 'little', 'moderate', 2323, 36, 'radio/TV', 'good'), (102, 24, 'female', 2, 'own', 'little', None, 932, 6, 'radio/TV', 'good'), (111, 23, 'female', 2, 'rent', 'little', 'rich', 392, 15, 'education', 'good'), (118, 23, 'female', 2, 'own', 'quite rich', 'little', 4281, 33, 'furniture/equipment', 'bad'), (122, 24, 'male', 1, 'rent', 'little', None, 1768, 12, 'furniture/equipment', 'good'), (130, 24, 'female', 2, 'own', None, 'moderate', 8487, 48, 'car', 'good'), (134, 21, 'female', 2, 'own', 'moderate', None, 10144, 60, 'radio/TV', 'good'), (143, 22, 'male', 2, 'own', 'little', 'little', 2462, 18, 'furniture/equipment', 'bad'), (144, 23, 'female', 2, 'own', 'little', None, 2288, 21, 'furniture/equipment', 'good'), (152, 24, 'male', 2, 'own', 'little', 'rich', 5848, 36, 'radio/TV', 'good'), (155, 20, 'female', 2, 'rent', 'little', 'little', 1282, 12, 'furniture/equipment', 'bad'), (167, 20, 'female', 2, 'own', 'rich', 'moderate', 1577, 11, 'furniture/equipment', 'good'), (188, 20, 'male', 2, 'own', 'moderate', 'little', 674, 12, 'radio/TV', 'bad'), (194, 21, 'male', 2, 'rent', 'moderate', 'moderate', 3031, 45, 'radio/TV', 'bad'), (203, 21, 'male', 2, 'rent', 'little', 'little', 902, 12, 'education', 'bad'), (208, 21, 'male', 1, 'own', 'little', 'little', 6568, 24, 'business', 'good'), (217, 23, 'male', 2, 'own', 'little', 'rich', 3913, 36, 'radio/TV', 'good'), (218, 24, 'male', 1, 'rent', 'little', 'little', 3021, 24, 'furniture/equipment', 'good'), (221, 23, 'female', 2, 'rent', None, 'little', 1200, 12, 'education', 'good'), (228, 22, 'male', 2, 'own', 'little', None, 1478, 9, 'radio/TV', 'bad'), (229, 22, 'male', 2, 'free', 'little', 'little', 3149, 24, 'furniture/equipment', 'good'), (236, 23, 'male', 0, 'own', None, 'moderate', 14555, 6, 'car', 'bad'), (242, 24, 'male', 2, 'free', 'little', 'little', 4605, 48, 'car', 'bad'), (249, 22, 'female', 2, 'rent', 'little', None, 433, 18, 'radio/TV', 'bad'), (252, 24, 'female', 2, 'own', 'little', 'moderate', 2150, 30, 'car', 'bad'), (254, 24, 'male', 2, 'own', None, 'moderate', 2030, 9, 'furniture/equipment', 'good'), (258, 23, 'female', 2, 'own', 'moderate', None, 3812, 15, 'car', 'good'), (280, 23, 'male', 2, 'rent', 'rich', None, 3368, 15, 'car', 'good'), (296, 20, 'female', 2, 'rent', None, None, 4675, 12, 'car', 'good'), (306, 24, 'female', 1, 'rent', None, None, 4811, 30, 'car', 'good'), (308, 24, 'female', 2, 'own', 'little', 'moderate', 1237, 8, 'furniture/equipment', 'bad'), (309, 22, 'male', 1, 'rent', 'little', 'moderate', 276, 9, 'car', 'good'), (332, 24, 'female', 3, 'own', 'moderate', 'moderate', 7408, 60, 'car', 'bad'), (333, 24, 'female', 1, 'rent', 'moderate', None, 11590, 48, 'car', 'bad'), (334, 23, 'male', 2, 'rent', 'little', 'little', 4110, 24, 'furniture/equipment', 'bad'), (336, 23, 'female', 1, 'own', 'little', 'moderate', 2101, 13, 'radio/TV', 'good'), (337, 24, 'female', 2, 'rent', None, 'little', 1275, 15, 'domestic appliances', 'bad'), (340, 24, 'female', 2, 'free', 'little', 'moderate', 5743, 24, 'education', 'good'), (346, 23, 'male', 2, 'own', 'little', 'moderate', 882, 13, 'radio/TV', 'good'), (347, 23, 'female', 0, 'rent', 'quite rich', 'moderate', 3758, 24, 'radio/TV', 'good'), (350, 23, 'female', 2, 'rent', 'little', None, 1236, 9, 'domestic appliances', 'good'), (355, 23, 'male', 1, 'own', 'little', 'moderate', 1246, 24, 'car', 'bad'), (359, 23, 'female', 2, 'rent', 'little', 'little', 2406, 30, 'furniture/equipment', 'bad'), (363, 21, 'male', 2, 'rent', 'little', None, 1766, 6, 'furniture/equipment', 'good'), (367, 22, 'female', 2, 'rent', 'little', 'little', 3650, 18, 'furniture/equipment', 'good'), (372, 23, 'female', 2, 'rent', 'little', None, 2146, 10, 'furniture/equipment', 'good'), (386, 21, 'female', 2, 'rent', None, None, 1126, 18, 'radio/TV', 'good'), (391, 19, 'female', 1, 'rent', 'rich', 'moderate', 983, 12, 'furniture/equipment', 'good'), (405, 22, 'male', 2, 'own', 'little', 'moderate', 2039, 24, 'radio/TV', 'bad'), (410, 20, 'female', 2, 'own', 'little', 'moderate', 1967, 24, 'radio/TV', 'good'), (417, 23, 'female', 2, 'rent', None, 'little', 8471, 18, 'education', 'good'), (420, 20, 'female', 2, 'rent', 'rich', None, 3186, 15, 'car', 'good'), (425, 21, 'male', 2, 'rent', 'little', 'moderate', 2779, 18, 'car', 'good'), (428, 20, 'male', 2, 'own', 'little', None, 1313, 9, 'furniture/equipment', 'good'), (436, 23, 'male', 1, 'rent', 'quite rich', None, 660, 6, 'repairs', 'good'), (470, 22, 'male', 2, 'rent', 'moderate', 'moderate', 3092, 24, 'radio/TV', 'bad'), (471, 23, 'female', 2, 'own', 'little', 'little', 448, 6, 'education', 'bad'), (476, 24, 'male', 2, 'own', 'quite rich', None, 2569, 39, 'car', 'good'), (480, 23, 'female', 1, 'own', 'little', 'moderate', 3573, 12, 'radio/TV', 'good'), (495, 20, 'male', 2, 'own', None, 'little', 2996, 24, 'furniture/equipment', 'bad'), (504, 24, 'female', 2, 'rent', 'little', 'little', 1207, 24, 'car', 'bad'), (513, 20, 'male', 2, 'rent', 'little', 'moderate', 585, 12, 'radio/TV', 'good'), (517, 23, 'female', 2, 'rent', 'little', None, 7127, 36, 'furniture/equipment', 'bad'), (521, 24, 'female', 2, 'own', 'little', 'little', 3190, 18, 'radio/TV', 'bad'), (523, 23, 'female', 2, 'own', 'moderate', None, 3488, 24, 'car', 'good'), (540, 23, 'male', 2, 'rent', 'little', 'moderate', 1534, 12, 'radio/TV', 'bad'), (548, 24, 'female', 1, 'own', 'little', 'little', 626, 12, 'radio/TV', 'bad'), (550, 23, 'female', 2, 'own', None, None, 996, 12, 'repairs', 'good'), (555, 22, 'male', 2, 'own', 'little', 'moderate', 1331, 12, 'radio/TV', 'bad'), (561, 24, 'male', 1, 'rent', 'little', 'little', 1546, 24, 'radio/TV', 'bad'), (565, 23, 'female', 2, 'rent', 'moderate', 'moderate', 1553, 24, 'radio/TV', 'good'), (570, 23, 'female', 1, 'rent', 'little', 'little', 3234, 24, 'furniture/equipment', 'bad'), (573, 22, 'female', 1, 'own', 'little', 'little', 806, 15, 'business', 'good'), (575, 24, 'female', 2, 'own', 'little', None, 2788, 15, 'furniture/equipment', 'good'), (585, 20, 'female', 2, 'rent', 'little', 'little', 2039, 18, 'furniture/equipment', 'bad'), (587, 21, 'male', 1, 'own', 'little', 'little', 1289, 12, 'furniture/equipment', 'good'), (593, 20, 'female', 1, 'rent', 'little', 'moderate', 2718, 24, 'car', 'bad'), (596, 23, 'female', 2, 'rent', 'little', 'little', 1442, 24, 'car', 'bad'), (604, 23, 'female', 2, 'own', 'little', 'rich', 1275, 10, 'furniture/equipment', 'good'), (605, 22, 'male', 2, 'own', 'quite rich', 'little', 2828, 24, 'furniture/equipment', 'good'), (610, 22, 'female', 2, 'own', 'moderate', 'little', 741, 12, 'domestic appliances', 'bad'), (613, 22, 'female', 2, 'rent', 'little', 'little', 3632, 24, 'car', 'good'), (614, 22, 'female', 2, 'own', 'little', None, 1808, 18, 'furniture/equipment', 'bad'), (618, 21, 'female', 2, 'rent', 'moderate', 'moderate', 3441, 30, 'furniture/equipment', 'bad'), (623, 22, 'female', 2, 'rent', 'little', 'little', 1858, 12, 'furniture/equipment', 'good'), (632, 23, 'male', 2, 'own', None, 'moderate', 1444, 15, 'radio/TV', 'good'), (633, 19, 'female', 2, 'rent', 'little', None, 1980, 9, 'furniture/equipment', 'bad'), (637, 21, 'male', 2, 'own', 'little', None, 15653, 60, 'radio/TV', 'good'), (655, 22, 'male', 2, 'free', 'little', 'little', 3973, 14, 'car', 'good'), (660, 23, 'male', 2, 'rent', 'little', 'rich', 1297, 12, 'radio/TV', 'good'), (661, 23, 'male', 2, 'own', None, 'little', 900, 12, 'car', 'bad'), (673, 24, 'male', 2, 'own', 'quite rich', None, 2080, 6, 'car', 'good'), (677, 24, 'male', 2, 'own', 'moderate', 'moderate', 5595, 72, 'radio/TV', 'bad'), (698, 24, 'male', 2, 'own', 'little', None, 1800, 18, 'radio/TV', 'good'), (706, 24, 'male', 2, 'own', 'moderate', 'moderate', 6560, 48, 'car', 'bad'), (721, 24, 'female', 2, 'rent', 'rich', 'moderate', 433, 6, 'education', 'bad'), (722, 24, 'female', 1, 'own', 'little', 'little', 1228, 12, 'car', 'bad'), (724, 21, 'female', 2, 'rent', 'little', None, 2570, 27, 'car', 'bad'), (731, 21, 'male', 1, 'rent', 'little', 'little', 1987, 24, 'radio/TV', 'bad'), (736, 23, 'female', 3, 'rent', 'little', 'moderate', 11560, 24, 'car', 'bad'), (741, 23, 'male', 1, 'own', 'little', 'moderate', 1048, 10, 'radio/TV', 'good'), (743, 22, 'male', 2, 'own', 'quite rich', 'little', 2483, 24, 'furniture/equipment', 'good'), (746, 23, 'female', 2, 'rent', 'little', 'little', 2511, 15, 'car', 'good'), (751, 23, 'female', 1, 'own', 'little', 'little', 976, 18, 'car', 'bad'), (752, 23, 'female', 1, 'rent', 'moderate', 'moderate', 841, 12, 'business', 'good'), (761, 24, 'female', 2, 'rent', 'little', 'little', 2124, 18, 'furniture/equipment', 'bad'), (762, 24, 'male', 1, 'own', 'little', 'little', 2214, 12, 'radio/TV', 'good'), (783, 23, 'female', 1, 'own', 'moderate', 'moderate', 836, 12, 'car', 'bad'), (795, 22, 'female', 2, 'rent', 'moderate', None, 2301, 9, 'furniture/equipment', 'good'), (797, 22, 'female', 1, 'rent', 'little', None, 1258, 12, 'furniture/equipment', 'good'), (802, 24, 'female', 2, 'own', 'little', 'little', 4272, 20, 'furniture/equipment', 'good'), (804, 24, 'female', 0, 'rent', None, 'moderate', 7472, 12, 'car', 'good'), (805, 24, 'male', 2, 'own', 'little', 'little', 9271, 36, 'car', 'bad'), (812, 24, 'male', 2, 'own', 'little', 'little', 9629, 36, 'car', 'bad'), (817, 24, 'female', 2, 'rent', 'little', None, 1554, 6, 'radio/TV', 'good'), (821, 24, 'male', 2, 'own', 'little', 'rich', 3016, 12, 'radio/TV', 'good'), (831, 23, 'female', 2, 'rent', 'little', 'little', 1216, 18, 'car', 'bad'), (836, 21, 'female', 2, 'own', None, None, 886, 12, 'radio/TV', 'good'), (837, 23, 'female', 1, 'rent', 'little', None, 601, 4, 'furniture/equipment', 'good'), (842, 23, 'female', 2, 'own', 'little', None, 1943, 18, 'repairs', 'bad'), (865, 20, 'female', 2, 'rent', 'quite rich', None, 2221, 15, 'furniture/equipment', 'good'), (869, 24, 'female', 2, 'rent', 'little', 'little', 652, 12, 'furniture/equipment', 'good'), (873, 24, 'female', 2, 'own', None, None, 874, 15, 'domestic appliances', 'good'), (887, 23, 'male', 2, 'own', 'little', 'moderate', 15672, 48, 'business', 'bad'), (905, 20, 'male', 3, 'rent', 'little', 'little', 1107, 12, 'radio/TV', 'good'), (906, 24, 'male', 1, 'own', None, 'little', 3763, 21, 'car', 'good'), (922, 22, 'female', 2, 'rent', 'little', 'little', 1366, 9, 'radio/TV', 'bad'), (926, 21, 'female', 2, 'rent', 'little', 'little', 1049, 18, 'furniture/equipment', 'good'), (930, 24, 'male', 1, 'own', 'little', 'little', 1747, 24, 'furniture/equipment', 'good'), (931, 22, 'female', 2, 'own', 'little', 'moderate', 1670, 9, 'radio/TV', 'bad'), (934, 23, 'female', 2, 'own', 'little', 'little', 1498, 12, 'radio/TV', 'good'), (951, 24, 'male', 2, 'own', 'little', 'little', 2145, 36, 'business', 'bad'), (964, 22, 'male', 1, 'own', 'little', 'moderate', 454, 6, 'repairs', 'good'), (966, 23, 'male', 1, 'own', 'quite rich', 'moderate', 2520, 27, 'radio/TV', 'bad'), (970, 22, 'male', 2, 'own', 'moderate', 'moderate', 1514, 15, 'repairs', 'good'), (992, 23, 'male', 1, 'rent', None, 'little', 1936, 18, 'radio/TV', 'good'), (998, 23, 'male', 2, 'free', 'little', 'little', 1845, 45, 'radio/TV', 'bad')]

Python 代码 🔒 登录后使用

def solve():
    pass

🔒

登录后即可练习

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

登录免费注册

WHERE：小于条件

示例

登录后即可练习

升级 VIP

联系客服