初级

WHERE：IS NULL判断

未完成

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

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 "Saving accounts" IS NULL').fetchall()
    conn.close()
    return result

示例

输入

print(solve())

期望输出

[(0, 67, 'male', 2, 'own', None, 'little', 1169, 6, 'radio/TV', 'good'), (5, 35, 'male', 1, 'free', None, None, 9055, 36, 'education', 'good'), (16, 53, 'male', 2, 'own', None, None, 2424, 24, 'radio/TV', 'good'), (17, 25, 'male', 2, 'own', None, 'little', 8072, 30, 'business', 'good'), (24, 26, 'male', 2, 'own', None, None, 2069, 10, 'furniture/equipment', 'good'), (33, 57, 'male', 1, 'rent', None, None, 1264, 12, 'business', 'good'), (50, 29, 'male', 1, 'own', None, 'moderate', 2333, 24, 'furniture/equipment', 'good'), (53, 31, 'male', 2, 'own', None, None, 3378, 18, 'car', 'good'), (55, 26, 'male', 1, 'own', None, None, 783, 6, 'car', 'good'), (56, 52, 'male', 3, 'own', None, 'moderate', 6468, 12, 'radio/TV', 'bad'), (61, 50, 'male', 2, 'own', None, 'moderate', 1537, 15, 'radio/TV', 'good'), (65, 48, 'male', 2, 'own', None, None, 5190, 27, 'repairs', 'good'), (69, 25, 'female', 2, 'own', None, None, 2394, 36, 'radio/TV', 'good'), (71, 46, 'male', 1, 'rent', None, None, 730, 7, 'radio/TV', 'good'), (74, 40, 'male', 3, 'own', None, 'little', 1977, 36, 'education', 'bad'), (78, 39, 'male', 1, 'own', None, None, 9436, 54, 'car', 'good'), (80, 44, 'female', 2, 'own', None, None, 5943, 24, 'radio/TV', 'bad'), (92, 33, 'female', 1, 'own', None, None, 797, 12, 'radio/TV', 'bad'), (93, 20, 'male', 2, 'rent', None, 'rich', 3617, 24, 'furniture/equipment', 'good'), (96, 61, 'female', 2, 'own', None, None, 2012, 12, 'education', 'good'), (99, 36, 'male', 3, 'rent', None, 'moderate', 7057, 20, 'car', 'good'), (104, 26, 'male', 2, 'rent', None, None, 2445, 12, 'car', 'good'), (108, 30, 'female', 2, 'own', None, 'little', 7721, 24, 'furniture/equipment', 'good'), (115, 47, 'male', 2, 'own', None, None, 3578, 48, 'radio/TV', 'good'), (116, 30, 'female', 3, 'own', None, 'little', 7174, 42, 'radio/TV', 'bad'), (117, 27, 'female', 2, 'rent', None, 'little', 2132, 10, 'furniture/equipment', 'good'), (124, 27, 'female', 2, 'rent', None, 'moderate', 1924, 18, 'furniture/equipment', 'bad'), (130, 24, 'female', 2, 'own', None, 'moderate', 8487, 48, 'car', 'good'), (135, 38, 'female', 2, 'own', None, None, 1240, 12, 'radio/TV', 'good'), (138, 35, 'male', 2, 'own', None, 'moderate', 2728, 15, 'radio/TV', 'good'), (159, 34, 'male', 1, 'own', None, None, 1898, 6, 'radio/TV', 'good'), (175, 53, 'female', 3, 'own', None, None, 7485, 30, 'car', 'bad'), (182, 40, 'male', 1, 'own', None, 'little', 1647, 21, 'car', 'bad'), (198, 36, 'male', 2, 'free', None, 'moderate', 2760, 24, 'car', 'good'), (210, 33, 'male', 2, 'own', None, None, 3074, 9, 'radio/TV', 'good'), (211, 45, 'female', 1, 'own', None, None, 3835, 36, 'radio/TV', 'good'), (214, 51, 'male', 2, 'own', None, None, 3342, 36, 'radio/TV', 'good'), (215, 39, 'female', 1, 'own', None, 'moderate', 932, 6, 'education', 'good'), (221, 23, 'female', 2, 'rent', None, 'little', 1200, 12, 'education', 'good'), (223, 32, 'male', 2, 'own', None, None, 2978, 24, 'business', 'good'), (236, 23, 'male', 0, 'own', None, 'moderate', 14555, 6, 'car', 'bad'), (240, 29, 'female', 2, 'own', None, 'little', 915, 24, 'car', 'bad'), (254, 24, 'male', 2, 'own', None, 'moderate', 2030, 9, 'furniture/equipment', 'good'), (255, 27, 'male', 1, 'own', None, 'moderate', 7418, 60, 'radio/TV', 'good'), (266, 36, 'male', 2, 'own', None, None, 6304, 36, 'business', 'good'), (269, 25, 'male', 2, 'own', None, None, 999, 24, 'radio/TV', 'good'), (270, 32, 'male', 2, 'own', None, None, 2662, 18, 'car', 'good'), (272, 36, 'male', 3, 'free', None, 'moderate', 12169, 48, 'car', 'good'), (277, 49, 'male', 1, 'own', None, 'little', 1262, 12, 'furniture/equipment', 'good'), (282, 49, 'male', 1, 'own', None, 'rich', 1445, 18, 'radio/TV', 'good'), (283, 63, 'male', 2, 'own', None, None, 1520, 15, 'furniture/equipment', 'good'), (294, 46, 'male', 3, 'own', None, None, 7629, 48, 'business', 'good'), (296, 20, 'female', 2, 'rent', None, None, 4675, 12, 'car', 'good'), (297, 45, 'male', 1, 'own', None, None, 1287, 10, 'car', 'good'), (302, 37, 'male', 1, 'own', None, 'rich', 1344, 24, 'car', 'bad'), (306, 24, 'female', 1, 'rent', None, None, 4811, 30, 'car', 'good'), (310, 40, 'male', 0, 'free', None, 'moderate', 5381, 48, 'vacation/others', 'good'), (314, 29, 'male', 1, 'own', None, 'rich', 1494, 4, 'car', 'good'), (317, 48, 'female', 1, 'own', None, 'moderate', 4351, 24, 'furniture/equipment', 'good'), (326, 49, 'male', 2, 'rent', None, None, 5801, 12, 'furniture/equipment', 'good'), (337, 24, 'female', 2, 'rent', None, 'little', 1275, 15, 'domestic appliances', 'bad'), (352, 38, 'male', 3, 'own', None, None, 3229, 18, 'car', 'good'), (356, 49, 'male', 2, 'own', None, None, 2331, 12, 'radio/TV', 'good'), (360, 61, 'male', 2, 'free', None, 'moderate', 1239, 18, 'education', 'good'), (361, 37, 'male', 3, 'own', None, 'rich', 3399, 12, 'radio/TV', 'good'), (370, 36, 'male', 2, 'own', None, None, 3079, 36, 'car', 'good'), (373, 63, 'male', 3, 'free', None, None, 13756, 60, 'car', 'good'), (377, 36, 'male', 2, 'free', None, None, 846, 7, 'radio/TV', 'good'), (380, 39, 'male', 2, 'own', None, 'little', 2212, 20, 'furniture/equipment', 'good'), (382, 25, 'female', 2, 'rent', None, None, 1283, 22, 'car', 'good'), (386, 21, 'female', 2, 'rent', None, None, 1126, 18, 'radio/TV', 'good'), (401, 28, 'male', 2, 'own', None, 'moderate', 1887, 18, 'business', 'good'), (404, 43, 'male', 2, 'own', None, 'moderate', 2899, 18, 'car', 'good'), (406, 43, 'male', 2, 'own', None, None, 2197, 24, 'car', 'good'), (414, 35, 'female', 2, 'own', None, 'little', 1381, 24, 'car', 'bad'), (417, 23, 'female', 2, 'rent', None, 'little', 8471, 18, 'education', 'good'), (419, 33, 'female', 2, 'own', None, 'moderate', 1042, 18, 'car', 'bad'), (421, 30, 'male', 2, 'own', None, 'moderate', 2028, 12, 'car', 'good'), (424, 25, 'female', 2, 'own', None, 'moderate', 2762, 12, 'furniture/equipment', 'bad'), (435, 25, 'male', 2, 'own', None, 'moderate', 1484, 12, 'radio/TV', 'bad'), (445, 41, 'female', 1, 'rent', None, None, 1244, 9, 'education', 'good'), (448, 55, 'female', 3, 'own', None, 'rich', 1424, 12, 'furniture/equipment', 'good'), (450, 30, 'male', 3, 'own', None, None, 11054, 36, 'car', 'good'), (463, 38, 'male', 2, 'own', None, 'moderate', 754, 12, 'education', 'good'), (467, 32, 'male', 2, 'own', None, None, 7238, 48, 'radio/TV', 'good'), (473, 36, 'male', 3, 'own', None, None, 1238, 6, 'education', 'good'), (493, 38, 'male', 2, 'own', None, 'moderate', 368, 6, 'radio/TV', 'good'), (495, 20, 'male', 2, 'own', None, 'little', 2996, 24, 'furniture/equipment', 'bad'), (505, 27, 'male', 1, 'own', None, None, 1309, 10, 'car', 'bad'), (514, 54, 'male', 2, 'own', None, None, 2255, 24, 'car', 'good'), (519, 36, 'male', 2, 'free', None, None, 700, 6, 'radio/TV', 'good'), (534, 25, 'male', 2, 'own', None, None, 3105, 24, 'radio/TV', 'good'), (536, 75, 'female', 3, 'own', None, 'little', 1374, 6, 'car', 'good'), (542, 31, 'male', 2, 'own', None, 'little', 6350, 30, 'furniture/equipment', 'bad'), (549, 35, 'male', 2, 'free', None, None, 8858, 48, 'car', 'good'), (550, 23, 'female', 2, 'own', None, None, 996, 12, 'repairs', 'good'), (557, 29, 'female', 2, 'own', None, None, 5003, 21, 'car', 'bad'), (560, 49, 'male', 2, 'free', None, 'little', 2964, 24, 'car', 'good'), (563, 37, 'male', 2, 'free', None, 'moderate', 12389, 36, 'car', 'bad'), (564, 37, 'male', 3, 'own', None, 'moderate', 4712, 24, 'business', 'good'), (568, 41, 'male', 2, 'own', None, 'moderate', 3979, 48, 'radio/TV', 'good'), (572, 26, 'female', 3, 'rent', None, None, 5433, 24, 'car', 'good'), (577, 33, 'female', 2, 'own', None, None, 1927, 24, 'education', 'good'), (584, 52, 'female', 3, 'free', None, None, 2133, 12, 'car', 'good'), (591, 42, 'female', 2, 'rent', None, 'moderate', 1965, 24, 'car', 'good'), (594, 40, 'male', 3, 'own', None, 'little', 1358, 24, 'vacation/others', 'bad'), (609, 45, 'male', 2, 'free', None, None, 1300, 15, 'car', 'good'), (615, 48, 'male', 3, 'own', None, 'moderate', 12204, 48, 'business', 'good'), (616, 27, 'male', 3, 'free', None, 'moderate', 9157, 60, 'radio/TV', 'good'), (622, 38, 'male', 2, 'own', None, None, 3914, 48, 'business', 'bad'), (625, 35, 'male', 2, 'own', None, None, 1979, 15, 'radio/TV', 'good'), (629, 64, 'male', 1, 'own', None, None, 3832, 9, 'education', 'good'), (632, 23, 'male', 2, 'own', None, 'moderate', 1444, 15, 'radio/TV', 'good'), (645, 27, 'male', 2, 'rent', None, None, 7980, 36, 'business', 'bad'), (657, 37, 'male', 2, 'own', None, None, 10222, 48, 'radio/TV', 'good'), (661, 23, 'male', 2, 'own', None, 'little', 900, 12, 'car', 'bad'), (681, 37, 'male', 2, 'free', None, None, 2279, 12, 'radio/TV', 'good'), (685, 34, 'male', 2, 'free', None, None, 6527, 60, 'car', 'good'), (686, 27, 'male', 2, 'own', None, 'rich', 1347, 10, 'radio/TV', 'good'), (693, 44, 'male', 1, 'own', None, 'little', 4716, 6, 'car', 'good'), (712, 46, 'male', 3, 'own', None, None, 2476, 21, 'car', 'good'), (715, 63, 'male', 2, 'own', None, None, 7596, 30, 'car', 'good'), (716, 40, 'male', 2, 'own', None, None, 3077, 30, 'radio/TV', 'good'), (718, 31, 'male', 2, 'own', None, 'rich', 3148, 24, 'radio/TV', 'good'), (735, 29, 'female', 0, 'own', None, 'moderate', 3990, 36, 'domestic appliances', 'good'), (742, 41, 'male', 2, 'own', None, None, 3160, 21, 'radio/TV', 'good'), (744, 30, 'male', 3, 'own', None, 'little', 14179, 39, 'furniture/equipment', 'good'), (748, 26, 'male', 2, 'own', None, None, 5248, 21, 'car', 'good'), (755, 32, 'female', 2, 'rent', None, 'little', 1285, 24, 'car', 'bad'), (757, 39, 'male', 2, 'free', None, 'rich', 1271, 15, 'radio/TV', 'bad'), (760, 59, 'female', 2, 'own', None, None, 5045, 15, 'car', 'good'), (763, 30, 'male', 3, 'free', None, None, 12680, 21, 'car', 'bad'), (767, 31, 'female', 2, 'rent', None, None, 2901, 10, 'car', 'good'), (770, 26, 'female', 2, 'rent', None, 'little', 2812, 24, 'car', 'good'), (775, 25, 'female', 2, 'rent', None, 'little', 1371, 24, 'car', 'bad'), (784, 60, 'male', 3, 'own', None, 'moderate', 6468, 20, 'car', 'good'), (787, 38, 'male', 2, 'own', None, None, 2751, 48, 'car', 'good'), (791, 41, 'male', 3, 'own', None, None, 6313, 24, 'car', 'good'), (792, 27, 'male', 2, 'own', None, None, 1221, 6, 'furniture/equipment', 'good'), (796, 51, 'male', 2, 'free', None, 'little', 7511, 18, 'car', 'bad'), (798, 54, 'male', 2, 'own', None, None, 717, 24, 'car', 'good'), (799, 35, 'male', 0, 'own', None, 'moderate', 1549, 9, 'car', 'good'), (803, 35, 'male', 2, 'own', None, None, 976, 12, 'radio/TV', 'good'), (804, 24, 'female', 0, 'rent', None, 'moderate', 7472, 12, 'car', 'good'), (807, 65, 'male', 2, 'own', None, None, 930, 12, 'radio/TV', 'good'), (828, 47, 'male', 2, 'free', None, 'little', 8335, 36, 'car', 'bad'), (829, 38, 'male', 2, 'free', None, 'moderate', 6681, 48, 'business', 'good'), (833, 42, 'female', 2, 'own', None, 'moderate', 5084, 24, 'radio/TV', 'good'), (836, 21, 'female', 2, 'own', None, None, 886, 12, 'radio/TV', 'good'), (845, 35, 'male', 2, 'own', None, 'moderate', 3976, 21, 'furniture/equipment', 'good'), (846, 68, 'male', 2, 'rent', None, None, 6761, 18, 'car', 'bad'), (851, 43, 'male', 2, 'own', None, None, 4042, 24, 'car', 'good'), (856, 40, 'female', 2, 'own', None, None, 894, 10, 'education', 'good'), (868, 37, 'male', 2, 'own', None, None, 7409, 36, 'business', 'good'), (873, 24, 'female', 2, 'own', None, None, 874, 15, 'domestic appliances', 'good'), (879, 36, 'male', 2, 'own', None, None, 6742, 30, 'radio/TV', 'good'), (881, 48, 'male', 2, 'free', None, None, 9277, 24, 'car', 'good'), (882, 36, 'male', 2, 'own', None, 'moderate', 2181, 30, 'car', 'good'), (886, 34, 'male', 2, 'own', None, 'moderate', 2825, 24, 'business', 'good'), (889, 40, 'male', 2, 'rent', None, None, 7824, 28, 'car', 'good'), (894, 29, 'male', 2, 'own', None, None, 1169, 18, 'radio/TV', 'good'), (895, 31, 'male', 3, 'own', None, None, 8947, 36, 'car', 'good'), (898, 33, 'female', 1, 'rent', None, None, 2186, 15, 'furniture/equipment', 'good'), (901, 44, 'male', 2, 'own', None, None, 3485, 20, 'car', 'good'), (902, 42, 'male', 2, 'free', None, None, 10477, 36, 'car', 'good'), (903, 40, 'male', 2, 'rent', None, None, 1386, 15, 'radio/TV', 'good'), (906, 24, 'male', 1, 'own', None, 'little', 3763, 21, 'car', 'good'), (907, 27, 'male', 2, 'own', None, 'moderate', 3711, 36, 'education', 'good'), (909, 33, 'female', 1, 'own', None, 'moderate', 3195, 9, 'car', 'good'), (912, 25, 'female', 2, 'own', None, 'moderate', 2991, 30, 'radio/TV', 'good'), (928, 58, 'male', 2, 'own', None, None, 1867, 30, 'radio/TV', 'good'), (939, 46, 'male', 3, 'own', None, None, 6842, 24, 'car', 'good'), (940, 45, 'male', 3, 'own', None, None, 3527, 12, 'car', 'good'), (942, 31, 'male', 2, 'own', None, None, 929, 24, 'furniture/equipment', 'good'), (947, 38, 'male', 3, 'own', None, None, 2859, 12, 'car', 'good'), (956, 49, 'male', 1, 'own', None, 'rich', 3656, 30, 'radio/TV', 'good'), (962, 29, 'male', 2, 'own', None, None, 3556, 15, 'car', 'good'), (965, 26, 'female', 2, 'own', None, 'moderate', 1715, 30, 'radio/TV', 'good'), (968, 29, 'male', 2, 'rent', None, None, 7166, 42, 'radio/TV', 'good'), (977, 42, 'male', 2, 'own', None, 'moderate', 2427, 18, 'business', 'good'), (990, 37, 'male', 1, 'own', None, None, 3565, 12, 'education', 'good'), (992, 23, 'male', 1, 'rent', None, 'little', 1936, 18, 'radio/TV', 'good'), (994, 50, 'male', 2, 'own', None, None, 2390, 12, 'car', 'good')]

Python 代码 🔒 登录后使用

def solve():
    pass

🔒

登录后即可练习

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

登录免费注册

WHERE：IS NULL判断

示例

登录后即可练习

升级 VIP

联系客服