初级

AND与OR组合

未完成

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

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 > 40 OR "Credit amount" > 10000) AND Risk = \'good\'').fetchall()
    conn.close()
    return result

示例

输入

print(solve())

期望输出

[(0, 67, 'male', 2, 'own', None, 'little', 1169, 6, 'radio/TV', 'good'), (2, 49, 'male', 1, 'own', 'little', None, 2096, 12, 'education', 'good'), (3, 45, 'male', 2, 'free', 'little', 'little', 7882, 42, 'furniture/equipment', 'good'), (6, 53, 'male', 2, 'own', 'quite rich', None, 2835, 24, 'furniture/equipment', 'good'), (8, 61, 'male', 1, 'own', 'rich', None, 3059, 12, 'radio/TV', 'good'), (16, 53, 'male', 2, 'own', None, None, 2424, 24, 'radio/TV', 'good'), (20, 48, 'male', 2, 'own', 'little', None, 2134, 9, 'car', 'good'), (21, 44, 'male', 2, 'rent', 'quite rich', 'little', 2647, 6, 'radio/TV', 'good'), (22, 48, 'male', 1, 'rent', 'little', 'little', 2241, 10, 'car', 'good'), (23, 44, 'male', 2, 'own', 'moderate', 'moderate', 1804, 12, 'car', 'good'), (27, 42, 'female', 2, 'rent', 'rich', 'rich', 409, 12, 'radio/TV', 'good'), (33, 57, 'male', 1, 'rent', None, None, 1264, 12, 'business', 'good'), (42, 44, 'male', 1, 'own', 'little', 'moderate', 6204, 18, 'repairs', 'good'), (61, 50, 'male', 2, 'own', None, 'moderate', 1537, 15, 'radio/TV', 'good'), (65, 48, 'male', 2, 'own', None, None, 5190, 27, 'repairs', 'good'), (71, 46, 'male', 1, 'rent', None, None, 730, 7, 'radio/TV', 'good'), (72, 51, 'male', 3, 'free', 'little', 'little', 1164, 8, 'vacation/others', 'good'), (73, 41, 'female', 1, 'own', 'little', 'moderate', 5954, 42, 'business', 'good'), (75, 66, 'male', 3, 'free', 'little', 'little', 1526, 12, 'car', 'good'), (77, 51, 'male', 2, 'own', 'little', 'moderate', 4771, 11, 'radio/TV', 'good'), (81, 47, 'male', 2, 'own', 'quite rich', None, 1213, 15, 'radio/TV', 'good'), (83, 58, 'female', 1, 'own', 'little', 'little', 1755, 24, 'vacation/others', 'good'), (84, 52, 'male', 1, 'own', 'little', 'little', 2315, 10, 'radio/TV', 'good'), (90, 56, 'male', 2, 'own', 'little', None, 618, 12, 'radio/TV', 'good'), (91, 54, 'male', 2, 'own', 'little', 'little', 1409, 12, 'car', 'good'), (94, 54, 'male', 2, 'own', 'rich', 'moderate', 1318, 12, 'car', 'good'), (96, 61, 'female', 2, 'own', None, None, 2012, 12, 'education', 'good'), (100, 41, 'male', 1, 'rent', 'moderate', None, 1469, 24, 'car', 'good'), (115, 47, 'male', 2, 'own', None, None, 3578, 48, 'radio/TV', 'good'), (121, 41, 'female', 3, 'rent', 'little', None, 3868, 24, 'car', 'good'), (123, 63, 'male', 2, 'free', 'little', 'rich', 781, 10, 'car', 'good'), (133, 47, 'male', 2, 'free', 'little', None, 1984, 18, 'furniture/equipment', 'good'), (134, 21, 'female', 2, 'own', 'moderate', None, 10144, 60, 'radio/TV', 'good'), (139, 44, 'female', 1, 'rent', 'little', 'rich', 1881, 12, 'radio/TV', 'good'), (147, 51, 'female', 2, 'own', 'moderate', None, 682, 12, 'car', 'good'), (149, 46, 'male', 2, 'own', 'rich', None, 1582, 18, 'radio/TV', 'good'), (150, 42, 'male', 2, 'free', 'moderate', None, 1346, 6, 'radio/TV', 'good'), (156, 48, 'male', 2, 'own', 'moderate', 'little', 1288, 9, 'repairs', 'good'), (157, 45, 'male', 1, 'own', 'little', 'little', 339, 12, 'education', 'good'), (163, 70, 'male', 3, 'free', 'little', 'moderate', 7308, 10, 'car', 'good'), (176, 42, 'male', 2, 'own', 'little', 'little', 2577, 12, 'furniture/equipment', 'good'), (177, 52, 'male', 2, 'own', 'quite rich', 'little', 338, 6, 'radio/TV', 'good'), (179, 65, 'male', 2, 'own', 'little', 'little', 571, 21, 'car', 'good'), (183, 50, 'male', 2, 'own', 'rich', None, 3777, 24, 'furniture/equipment', 'good'), (187, 68, 'male', 0, 'free', 'little', 'moderate', 1175, 16, 'car', 'good'), (200, 52, 'male', 2, 'own', 'quite rich', None, 936, 9, 'education', 'good'), (205, 38, 'male', 3, 'free', 'little', 'little', 10623, 30, 'car', 'good'), (206, 43, 'male', 2, 'own', 'little', None, 1935, 12, 'furniture/equipment', 'good'), (209, 55, 'male', 2, 'own', 'rich', None, 1413, 12, 'car', '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'), (219, 64, 'female', 2, 'own', 'little', None, 1364, 10, 'car', 'good'), (231, 51, 'male', 1, 'free', 'quite rich', None, 2507, 9, 'car', 'good'), (234, 42, 'male', 1, 'own', 'little', None, 1544, 4, 'radio/TV', 'good'), (241, 51, 'male', 2, 'own', 'little', None, 1595, 6, 'radio/TV', 'good'), (246, 52, 'male', 2, 'own', 'little', None, 717, 12, 'radio/TV', 'good'), (251, 46, 'female', 1, 'own', 'little', 'rich', 2251, 12, 'furniture/equipment', 'good'), (259, 57, 'female', 1, 'own', 'moderate', None, 1154, 11, 'radio/TV', 'good'), (261, 55, 'female', 2, 'own', 'little', 'little', 1603, 24, 'radio/TV', 'good'), (263, 57, 'female', 1, 'free', 'little', None, 2748, 12, 'education', 'good'), (272, 36, 'male', 3, 'free', None, 'moderate', 12169, 48, 'car', 'good'), (277, 49, 'male', 1, 'own', None, 'little', 1262, 12, 'furniture/equipment', 'good'), (281, 50, 'male', 2, 'own', 'little', None, 1574, 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'), (285, 35, 'female', 1, 'own', 'little', 'little', 10722, 47, 'car', 'good'), (288, 49, 'female', 2, 'own', 'little', 'moderate', 1092, 12, 'radio/TV', 'good'), (292, 44, 'female', 3, 'free', 'little', 'little', 6419, 24, 'car', 'good'), (293, 56, 'male', 2, 'free', 'little', 'rich', 4796, 42, 'car', 'good'), (294, 46, 'male', 3, 'own', None, None, 7629, 48, 'business', 'good'), (297, 45, 'male', 1, 'own', None, None, 1287, 10, 'car', 'good'), (298, 43, 'male', 2, 'own', 'little', None, 2515, 18, 'furniture/equipment', 'good'), (300, 54, 'female', 0, 'own', 'little', None, 672, 6, 'car', 'good'), (303, 49, 'male', 2, 'own', 'little', 'little', 1038, 10, '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'), (330, 75, 'male', 3, 'free', 'little', 'little', 6615, 24, 'car', 'good'), (345, 43, 'female', 1, 'own', 'little', None, 1459, 15, 'radio/TV', 'good'), (354, 46, 'male', 2, 'free', 'quite rich', None, 727, 10, 'education', 'good'), (356, 49, 'male', 2, 'own', None, None, 2331, 12, 'radio/TV', 'good'), (360, 61, 'male', 2, 'free', None, 'moderate', 1239, 18, 'education', 'good'), (373, 63, 'male', 3, 'free', None, None, 13756, 60, 'car', 'good'), (379, 52, 'female', 1, 'own', 'moderate', None, 362, 6, 'car', 'good'), (395, 32, 'male', 2, 'rent', 'moderate', 'moderate', 11760, 39, 'education', 'good'), (396, 55, 'female', 3, 'free', 'little', 'little', 2578, 12, 'furniture/equipment', 'good'), (397, 46, 'male', 2, 'own', 'little', 'little', 2348, 36, 'furniture/equipment', 'good'), (399, 43, 'female', 1, 'own', 'rich', None, 1516, 24, 'radio/TV', 'good'), (404, 43, 'male', 2, 'own', None, 'moderate', 2899, 18, 'car', 'good'), (406, 43, 'male', 2, 'own', None, None, 2197, 24, 'car', 'good'), (422, 47, 'male', 1, 'own', 'little', 'moderate', 958, 12, 'car', 'good'), (427, 46, 'male', 2, 'own', 'rich', None, 1149, 18, 'radio/TV', 'good'), (430, 74, 'male', 1, 'own', 'little', None, 3448, 5, 'business', 'good'), (438, 65, 'male', 0, 'own', 'little', 'little', 3394, 42, 'repairs', 'good'), (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'), (465, 63, 'male', 2, 'own', 'little', 'little', 2924, 24, 'car', 'good'), (479, 44, 'male', 2, 'own', 'little', 'little', 1478, 15, 'furniture/equipment', 'good'), (482, 57, 'female', 2, 'rent', 'rich', 'little', 3622, 30, 'furniture/equipment', 'good'), (484, 44, 'male', 2, 'own', 'quite rich', None, 1163, 12, 'car', 'good'), (486, 52, 'male', 2, 'own', 'little', None, 3077, 12, 'radio/TV', 'good'), (487, 62, 'female', 2, 'free', 'little', None, 3757, 24, 'car', 'good'), (501, 42, 'male', 2, 'free', 'little', 'little', 5493, 36, 'car', 'good'), (502, 49, 'male', 2, 'own', 'moderate', 'rich', 1126, 9, 'radio/TV', 'good'), (509, 45, 'male', 3, 'own', 'moderate', None, 8588, 39, 'car', 'good'), (514, 54, 'male', 2, 'own', None, None, 2255, 24, 'car', 'good'), (518, 43, 'male', 2, 'own', 'moderate', 'little', 1203, 6, 'car', 'good'), (520, 44, 'male', 2, 'free', 'little', None, 5507, 24, 'repairs', 'good'), (527, 42, 'male', 1, 'own', 'little', None, 1503, 4, 'radio/TV', 'good'), (529, 41, 'male', 1, 'own', 'little', 'little', 662, 6, 'car', 'good'), (532, 41, 'male', 2, 'rent', 'little', None, 1503, 12, 'car', 'good'), (536, 75, 'female', 3, 'own', None, 'little', 1374, 6, 'car', 'good'), (539, 45, 'female', 1, 'own', 'little', 'rich', 3049, 18, 'furniture/equipment', 'good'), (541, 60, 'male', 2, 'free', 'little', None, 2032, 24, 'car', 'good'), (544, 61, 'male', 1, 'own', 'little', None, 1255, 12, 'car', 'good'), (551, 45, 'male', 1, 'own', 'quite rich', None, 1750, 6, 'radio/TV', 'good'), (554, 67, 'female', 3, 'own', 'little', 'moderate', 1199, 9, 'education', 'good'), (560, 49, 'male', 2, 'free', None, 'little', 2964, 24, 'car', 'good'), (568, 41, 'male', 2, 'own', None, 'moderate', 3979, 48, 'radio/TV', 'good'), (581, 49, 'male', 1, 'own', 'little', 'moderate', 3124, 12, 'car', 'good'), (584, 52, 'female', 3, 'free', None, None, 2133, 12, 'car', 'good'), (590, 58, 'female', 1, 'own', 'little', 'little', 385, 12, 'radio/TV', 'good'), (591, 42, 'female', 2, 'rent', None, 'moderate', 1965, 24, 'car', 'good'), (600, 45, 'female', 2, 'own', 'little', 'moderate', 2329, 7, 'radio/TV', 'good'), (606, 74, 'male', 3, 'own', 'little', None, 4526, 24, 'business', 'good'), (609, 45, 'male', 2, 'free', None, None, 1300, 15, 'car', 'good'), (615, 48, 'male', 3, 'own', None, 'moderate', 12204, 48, 'business', 'good'), (619, 49, 'male', 1, 'own', 'little', None, 640, 12, 'car', 'good'), (626, 41, 'male', 2, 'own', 'little', 'rich', 2116, 6, 'furniture/equipment', 'good'), (629, 64, 'male', 1, 'own', None, None, 3832, 9, 'education', 'good'), (635, 47, 'male', 2, 'own', 'little', None, 1393, 12, 'education', 'good'), (637, 21, 'male', 2, 'own', 'little', None, 15653, 60, 'radio/TV', 'good'), (650, 50, 'male', 3, 'free', 'little', 'little', 7476, 48, 'education', 'good'), (657, 37, 'male', 2, 'own', None, None, 10222, 48, 'radio/TV', 'good'), (659, 41, 'male', 2, 'own', 'little', 'moderate', 6361, 18, 'furniture/equipment', 'good'), (662, 50, 'male', 2, 'own', 'little', None, 2241, 21, 'furniture/equipment', 'good'), (664, 50, 'female', 1, 'own', 'little', 'rich', 1047, 6, 'education', 'good'), (669, 47, 'male', 2, 'own', 'little', 'rich', 3017, 30, 'radio/TV', 'good'), (672, 42, 'male', 3, 'own', 'little', None, 10366, 60, 'car', 'good'), (678, 64, 'male', 1, 'rent', 'little', 'little', 2384, 24, 'radio/TV', 'good'), (680, 56, 'female', 2, 'own', 'little', None, 1538, 6, 'education', 'good'), (683, 47, 'male', 2, 'free', 'little', None, 5103, 24, 'radio/TV', 'good'), (693, 44, 'male', 1, 'own', None, 'little', 4716, 6, 'car', 'good'), (695, 50, 'male', 2, 'rent', 'quite rich', None, 1236, 6, 'car', 'good'), (702, 47, 'female', 2, 'free', 'moderate', 'rich', 1377, 24, 'radio/TV', 'good'), (703, 41, 'male', 2, 'own', 'moderate', 'moderate', 2503, 30, 'business', 'good'), (712, 46, 'male', 3, 'own', None, None, 2476, 21, 'car', 'good'), (715, 63, 'male', 2, 'own', None, None, 7596, 30, 'car', 'good'), (723, 66, 'female', 1, 'own', 'quite rich', 'moderate', 790, 9, 'radio/TV', 'good'), (725, 41, 'female', 1, 'own', 'rich', None, 250, 6, 'car', 'good'), (726, 47, 'male', 1, 'own', 'quite rich', None, 1316, 15, 'radio/TV', 'good'), (732, 44, 'female', 1, 'own', 'little', 'moderate', 760, 8, 'radio/TV', 'good'), (738, 45, 'male', 3, 'own', 'little', None, 6761, 6, 'car', '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'), (750, 49, 'female', 2, 'own', 'little', 'little', 428, 6, 'furniture/equipment', 'good'), (756, 74, 'male', 0, 'own', 'little', 'rich', 1299, 6, 'car', 'good'), (760, 59, 'female', 2, 'own', None, None, 5045, 15, 'car', 'good'), (769, 63, 'male', 1, 'own', 'little', None, 1655, 12, 'radio/TV', 'good'), (773, 52, 'male', 2, 'own', 'moderate', None, 2223, 24, 'radio/TV', 'good'), (774, 66, 'male', 0, 'free', 'quite rich', 'rich', 1480, 12, 'car', 'good'), (779, 67, 'female', 2, 'own', 'little', 'moderate', 3872, 18, 'repairs', 'good'), (781, 60, 'male', 2, 'own', 'rich', None, 1940, 24, 'car', 'good'), (784, 60, 'male', 3, 'own', None, 'moderate', 6468, 20, 'car', 'good'), (791, 41, 'male', 3, 'own', None, None, 6313, 24, 'car', 'good'), (793, 51, 'male', 2, 'free', 'little', 'rich', 2892, 24, 'furniture/equipment', 'good'), (798, 54, 'male', 2, 'own', None, None, 717, 24, 'car', 'good'), (800, 54, 'male', 2, 'free', 'little', None, 1597, 24, 'education', 'good'), (801, 48, 'female', 1, 'rent', 'little', 'moderate', 1795, 18, 'radio/TV', 'good'), (807, 65, 'male', 2, 'own', None, None, 930, 12, 'radio/TV', 'good'), (808, 55, 'male', 3, 'free', 'little', 'moderate', 9283, 42, 'car', 'good'), (815, 54, 'female', 2, 'rent', 'little', 'moderate', 7432, 36, 'car', 'good'), (816, 62, 'male', 2, 'own', 'quite rich', None, 1338, 6, 'domestic appliances', 'good'), (818, 43, 'male', 3, 'own', 'little', 'little', 15857, 36, 'vacation/others', 'good'), (823, 47, 'male', 1, 'own', 'little', 'little', 731, 8, 'car', 'good'), (830, 44, 'male', 2, 'own', 'quite rich', None, 2375, 24, 'business', 'good'), (833, 42, 'female', 2, 'own', None, 'moderate', 5084, 24, 'radio/TV', 'good'), (838, 63, 'male', 2, 'own', 'little', 'little', 2957, 24, 'car', 'good'), (839, 46, 'male', 2, 'own', 'little', None, 2611, 24, 'radio/TV', 'good'), (843, 50, 'male', 2, 'own', 'little', None, 1559, 24, 'business', 'good'), (844, 47, 'male', 2, 'own', 'little', None, 3422, 18, 'furniture/equipment', 'good'), (848, 59, 'male', 2, 'own', 'little', 'little', 1364, 9, 'radio/TV', 'good'), (851, 43, 'male', 2, 'own', None, None, 4042, 24, 'car', 'good'), (854, 45, 'male', 2, 'own', 'little', None, 10875, 36, 'car', 'good'), (867, 42, 'male', 2, 'own', 'little', None, 3331, 12, 'furniture/equipment', 'good'), (871, 46, 'male', 2, 'own', 'little', 'rich', 1343, 6, 'car', 'good'), (881, 48, 'male', 2, 'free', None, None, 9277, 24, 'car', 'good'), (883, 65, 'female', 0, 'own', 'little', None, 1098, 18, 'radio/TV', 'good'), (890, 43, 'male', 3, 'own', 'little', 'little', 2442, 27, 'business', 'good'), (891, 46, 'male', 2, 'own', 'little', None, 1829, 15, 'radio/TV', 'good'), (901, 44, 'male', 2, 'own', None, None, 3485, 20, 'car', 'good'), (902, 42, 'male', 2, 'free', None, None, 10477, 36, 'car', 'good'), (908, 46, 'female', 1, 'own', 'little', None, 3594, 15, 'car', 'good'), (921, 37, 'male', 3, 'own', 'quite rich', None, 12749, 48, 'radio/TV', 'good'), (928, 58, 'male', 2, 'own', None, None, 1867, 30, 'radio/TV', 'good'), (929, 43, 'male', 1, 'own', 'little', 'little', 1344, 12, 'car', 'good'), (933, 42, 'male', 2, 'own', 'quite rich', None, 522, 12, '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'), (943, 42, 'male', 1, 'own', 'little', None, 1455, 4, 'car', 'good'), (944, 46, 'female', 2, 'rent', 'little', 'little', 1845, 15, 'furniture/equipment', 'good'), (955, 57, 'female', 3, 'rent', 'rich', 'little', 1231, 24, 'radio/TV', 'good'), (956, 49, 'male', 1, 'own', None, 'rich', 3656, 30, 'radio/TV', 'good'), (961, 47, 'male', 2, 'own', 'little', 'moderate', 2353, 21, 'car', 'good'), (967, 54, 'female', 3, 'rent', 'little', None, 3568, 15, 'radio/TV', 'good'), (971, 43, 'male', 1, 'own', 'little', None, 7393, 24, 'car', 'good'), (975, 57, 'female', 1, 'own', 'quite rich', 'rich', 1258, 24, 'radio/TV', 'good'), (976, 64, 'female', 2, 'own', 'little', 'moderate', 753, 6, 'radio/TV', 'good'), (977, 42, 'male', 2, 'own', None, 'moderate', 2427, 18, 'business', 'good'), (987, 64, 'female', 2, 'own', 'moderate', None, 1409, 13, 'radio/TV', 'good'), (989, 48, 'male', 1, 'own', 'little', 'moderate', 1743, 24, 'radio/TV', 'good'), (994, 50, 'male', 2, 'own', None, None, 2390, 12, 'car', 'good')]

Python 代码 🔒 登录后使用

def solve():
    pass

🔒

登录后即可练习

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

登录免费注册

AND与OR组合

示例

登录后即可练习

升级 VIP

联系客服