中级
CASE表达式:简单分类
未完成
中级参考
代码结构已给出,请填写 ____ 处
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())
期望输出
[(1169, '低'), (5951, '中'), (2096, '低'), (7882, '高'), (4870, '中'), (9055, '高'), (2835, '低'), (6948, '中'), (3059, '中'), (5234, '中'), (1295, '低'), (4308, '中'), (1567, '低'), (1199, '低'), (1403, '低'), (1282, '低'), (2424, '低'), (8072, '高'), (12579, '高'), (3430, '中'), (2134, '低'), (2647, '低'), (2241, '低'), (1804, '低'), (2069, '低'), (1374, '低'), (426, '低'), (409, '低'), (2415, '低'), (6836, '中'), (1913, '低'), (4020, '中'), (5866, '中'), (1264, '低'), (1474, '低'), (4746, '中'), (6110, '中'), (2100, '低'), (1225, '低'), (458, '低'), (2333, '低'), (1158, '低'), (6204, '中'), (6187, '中'), (6143, '中'), (1393, '低'), (2299, '低'), (1352, '低'), (7228, '高'), (2073, '低'), (2333, '低'), (5965, '中'), (1262, '低'), (3378, '中'), (2225, '低'), (783, '低'), (6468, '中'), (9566, '高'), (1961, '低'), (6229, '中'), (1391, '低'), (1537, '低'), (1953, '低'), (14421, '高'), (3181, '中'), (5190, '中'), (2171, '低'), (1007, '低'), (1819, '低'), (2394, '低'), (8133, '高'), (730, '低'), (1164, '低'), (5954, '中'), (1977, '低'), (1526, '低'), (3965, '中'), (4771, '中'), (9436, '高'), (3832, '中'), (5943, '中'), (1213, '低'), (1568, '低'), (1755, '低'), (2315, '低'), (1412, '低'), (1295, '低'), (12612, '高'), (2249, '低'), (1108, '低'), (618, '低'), (1409, '低'), (797, '低'), (3617, '中'), (1318, '低'), (15945, '高'), (2012, '低'), (2622, '低'), (2337, '低'), (7057, '高'), (1469, '低'), (2323, '低'), (932, '低'), (1919, '低'), (2445, '低'), (11938, '高'), (6458, '中'), (6078, '中'), (7721, '高'), (1410, '低'), (1449, '低'), (392, '低'), (6260, '中'), (7855, '高'), (1680, '低'), (3578, '中'), (7174, '高'), (2132, '低'), (4281, '中'), (2366, '低'), (1835, '低'), (3868, '中'), (1768, '低'), (781, '低'), (1924, '低'), (2121, '低'), (701, '低'), (639, '低'), (1860, '低'), (3499, '中'), (8487, '高'), (6887, '中'), (2708, '低'), (1984, '低'), (10144, '高'), (1240, '低'), (8613, '高'), (766, '低'), (2728, '低'), (1881, '低'), (709, '低'), (4795, '中'), (3416, '中'), (2462, '低'), (2288, '低'), (3566, '中'), (860, '低'), (682, '低'), (5371, '中'), (1582, '低'), (1346, '低'), (1924, '低'), (5848, '中'), (7758, '高'), (6967, '中'), (1282, '低'), (1288, '低'), (339, '低'), (3512, '中'), (1898, '低'), (2872, '低'), (1055, '低'), (1262, '低'), (7308, '高'), (909, '低'), (2978, '低'), (1131, '低'), (1577, '低'), (3972, '中'), (1935, '低'), (950, '低'), (763, '低'), (2064, '低'), (1414, '低'), (3414, '中'), (7485, '高'), (2577, '低'), (338, '低'), (1963, '低'), (571, '低'), (9572, '高'), (4455, '中'), (1647, '低'), (3777, '中'), (884, '低'), (1360, '低'), (5129, '中'), (1175, '低'), (674, '低'), (3244, '中'), (4591, '中'), (3844, '中'), (3915, '中'), (2108, '低'), (3031, '中'), (1501, '低'), (1382, '低'), (951, '低'), (2760, '低'), (4297, '中'), (936, '低'), (1168, '低'), (5117, '中'), (902, '低'), (1495, '低'), (10623, '高'), (1935, '低'), (1424, '低'), (6568, '中'), (1413, '低'), (3074, '中'), (3835, '中'), (5293, '中'), (1908, '低'), (3342, '中'), (932, '低'), (3104, '中'), (3913, '中'), (3021, '中'), (1364, '低'), (625, '低'), (1200, '低'), (707, '低'), (2978, '低'), (4657, '中'), (2613, '低'), (10961, '高'), (7865, '高'), (1478, '低'), (3149, '中'), (4210, '中'), (2507, '低'), (2141, '低'), (866, '低'), (1544, '低'), (1823, '低'), (14555, '高'), (2767, '低'), (1291, '低'), (2522, '低'), (915, '低'), (1595, '低'), (4605, '中'), (1185, '低'), (3447, '中'), (1258, '低'), (717, '低'), (1204, '低'), (1925, '低'), (433, '低'), (666, '低'), (2251, '低'), (2150, '低'), (4151, '中'), (2030, '低'), (7418, '高'), (2684, '低'), (2149, '低'), (3812, '中'), (1154, '低'), (1657, '低'), (1603, '低'), (5302, '中'), (2748, '低'), (1231, '低'), (802, '低'), (6304, '中'), (1533, '低'), (8978, '高'), (999, '低'), (2662, '低'), (1402, '低'), (12169, '高'), (3060, '中'), (11998, '高'), (2697, '低'), (2404, '低'), (1262, '低'), (4611, '中'), (1901, '低'), (3368, '中'), (1574, '低'), (1445, '低'), (1520, '低'), (3878, '中'), (10722, '高'), (4788, '中'), (7582, '高'), (1092, '低'), (1024, '低'), (1076, '低'), (9398, '高'), (6419, '中'), (4796, '中'), (7629, '高'), (9960, '高'), (4675, '中'), (1287, '低'), (2515, '低'), (2745, '低'), (672, '低'), (3804, '中'), (1344, '低'), (1038, '低'), (10127, '高'), (1543, '低'), (4811, '中'), (727, '低'), (1237, '低'), (276, '低'), (5381, '中'), (5511, '中'), (3749, '中'), (685, '低'), (1494, '低'), (2746, '低'), (708, '低'), (4351, '中'), (701, '低'), (3643, '中'), (4249, '中'), (1938, '低'), (2910, '低'), (2659, '低'), (1028, '低'), (3398, '中'), (5801, '中'), (1525, '低'), (4473, '中'), (1068, '低'), (6615, '中'), (1864, '低'), (7408, '高'), (11590, '高'), (4110, '中'), (3384, '中'), (2101, '低'), (1275, '低'), (4169, '中'), (1521, '低'), (5743, '中'), (3599, '中'), (3213, '中'), (4439, '中'), (3949, '中'), (1459, '低'), (882, '低'), (3758, '中'), (1743, '低'), (1136, '低'), (1236, '低'), (959, '低'), (3229, '中'), (6199, '中'), (727, '低'), (1246, '低'), (2331, '低'), (4463, '中'), (776, '低'), (2406, '低'), (1239, '低'), (3399, '中'), (2247, '低'), (1766, '低'), (2473, '低'), (1542, '低'), (3850, '中'), (3650, '中'), (3446, '中'), (3001, '中'), (3079, '中'), (6070, '中'), (2146, '低'), (13756, '高'), (14782, '高'), (7685, '高'), (2320, '低'), (846, '低'), (14318, '高'), (362, '低'), (2212, '低'), (12976, '高'), (1283, '低'), (1330, '低'), (4272, '中'), (2238, '低'), (1126, '低'), (7374, '高'), (2326, '低'), (1449, '低'), (1820, '低'), (983, '低'), (3249, '中'), (1957, '低'), (2406, '低'), (11760, '高'), (2578, '低'), (2348, '低'), (1223, '低'), (1516, '低'), (1473, '低'), (1887, '低'), (8648, '高'), (802, '低'), (2899, '低'), (2039, '低'), (2197, '低'), (1053, '低'), (3235, '中'), (939, '低'), (1967, '低'), (7253, '高'), (2292, '低'), (1597, '低'), (1381, '低'), (5842, '中'), (2579, '低'), (8471, '高'), (2782, '低'), (1042, '低'), (3186, '中'), (2028, '低'), (958, '低'), (1591, '低'), (2762, '低'), (2779, '低'), (2743, '低'), (1149, '低'), (1313, '低'), (1190, '低'), (3448, '中'), (11328, '高'), (1872, '低'), (2058, '低'), (2136, '低'), (1484, '低'), (660, '低'), (1287, '低'), (3394, '中'), (609, '低'), (1884, '低'), (1620, '低'), (2629, '低'), (719, '低'), (5096, '中'), (1244, '低'), (1842, '低'), (2576, '低'), (1424, '低'), (1512, '低'), (11054, '高'), (518, '低'), (2759, '低'), (2670, '低'), (4817, '中'), (2679, '低'), (3905, '中'), (3386, '中'), (343, '低'), (4594, '中'), (3620, '中'), (1721, '低'), (3017, '中'), (754, '低'), (1950, '低'), (2924, '低'), (1659, '低'), (7238, '高'), (2764, '低'), (4679, '中'), (3092, '中'), (448, '低'), (654, '低'), (1238, '低'), (1245, '低'), (3114, '中'), (2569, '低'), (5152, '中'), (1037, '低'), (1478, '低'), (3573, '中'), (1201, '低'), (3622, '中'), (960, '低'), (1163, '低'), (1209, '低'), (3077, '中'), (3757, '中'), (1418, '低'), (3518, '中'), (1934, '低'), (8318, '高'), (1237, '低'), (368, '低'), (2122, '低'), (2996, '低'), (9034, '高'), (1585, '低'), (1301, '低'), (1323, '低'), (3123, '中'), (5493, '中'), (1126, '低'), (1216, '低'), (1207, '低'), (1309, '低'), (2360, '低'), (6850, '中'), (1413, '低'), (8588, '高'), (759, '低'), (4686, '中'), (2687, '低'), (585, '低'), (2255, '低'), (609, '低'), (1361, '低'), (7127, '高'), (1203, '低'), (700, '低'), (5507, '中'), (3190, '中'), (7119, '高'), (3488, '中'), (1113, '低'), (7966, '高'), (1532, '低'), (1503, '低'), (2302, '低'), (662, '低'), (2273, '低'), (2631, '低'), (1503, '低'), (1311, '低'), (3105, '中'), (2319, '低'), (1374, '低'), (3612, '中'), (7763, '高'), (3049, '中'), (1534, '低'), (2032, '低'), (6350, '中'), (2864, '低'), (1255, '低'), (1333, '低'), (2022, '低'), (1552, '低'), (626, '低'), (8858, '高'), (996, '低'), (1750, '低'), (6999, '中'), (1995, '低'), (1199, '低'), (1331, '低'), (2278, '低'), (5003, '中'), (3552, '中'), (1928, '低'), (2964, '低'), (1546, '低'), (683, '低'), (12389, '高'), (4712, '中'), (1553, '低'), (1372, '低'), (2578, '低'), (3979, '中'), (6758, '中'), (3234, '中'), (5954, '中'), (5433, '中'), (806, '低'), (1082, '低'), (2788, '低'), (2930, '低'), (1927, '低'), (2820, '低'), (937, '低'), (1056, '低'), (3124, '中'), (1388, '低'), (2384, '低'), (2133, '低'), (2039, '低'), (2799, '低'), (1289, '低'), (1217, '低'), (2246, '低'), (385, '低'), (1965, '低'), (1572, '低'), (2718, '低'), (1358, '低'), (931, '低'), (1442, '低'), (4241, '中'), (2775, '低'), (3863, '中'), (2329, '低'), (918, '低'), (1837, '低'), (3349, '中'), (1275, '低'), (2828, '低'), (4526, '中'), (2671, '低'), (2051, '低'), (1300, '低'), (741, '低'), (1240, '低'), (3357, '中'), (3632, '中'), (1808, '低'), (12204, '高'), (9157, '高'), (3676, '中'), (3441, '中'), (640, '低'), (3652, '中'), (1530, '低'), (3914, '中'), (1858, '低'), (2600, '低'), (1979, '低'), (2116, '低'), (1437, '低'), (4042, '中'), (3832, '中'), (3660, '中'), (1553, '低'), (1444, '低'), (1980, '低'), (1355, '低'), (1393, '低'), (1376, '低'), (15653, '高'), (1493, '低'), (4370, '中'), (750, '低'), (1308, '低'), (4623, '中'), (1851, '低'), (1880, '低'), (7980, '高'), (4583, '中'), (1386, '低'), (947, '低'), (684, '低'), (7476, '高'), (1922, '低'), (2303, '低'), (8086, '高'), (2346, '低'), (3973, '中'), (888, '低'), (10222, '高'), (4221, '中'), (6361, '中'), (1297, '低'), (900, '低'), (2241, '低'), (1050, '低'), (1047, '低'), (6314, '中'), (3496, '中'), (3609, '中'), (4843, '中'), (3017, '中'), (4139, '中'), (5742, '中'), (10366, '高'), (2080, '低'), (2580, '低'), (4530, '中'), (5150, '中'), (5595, '中'), (2384, '低'), (1453, '低'), (1538, '低'), (2279, '低'), (1478, '低'), (5103, '中'), (9857, '高'), (6527, '中'), (1347, '低'), (2862, '低'), (2753, '低'), (3651, '中'), (975, '低'), (2631, '低'), (2896, '低'), (4716, '中'), (2284, '低'), (1236, '低'), (1103, '低'), (926, '低'), (1800, '低'), (1905, '低'), (1123, '低'), (6331, '中'), (1377, '低'), (2503, '低'), (2528, '低'), (5324, '中'), (6560, '中'), (2969, '低'), (1206, '低'), (2118, '低'), (629, '低'), (1198, '低'), (2476, '低'), (1138, '低'), (14027, '高'), (7596, '高'), (3077, '中'), (1505, '低'), (3148, '中'), (6148, '中'), (1337, '低'), (433, '低'), (1228, '低'), (790, '低'), (2570, '低'), (250, '低'), (1316, '低'), (1882, '低'), (6416, '中'), (1275, '低'), (6403, '中'), (1987, '低'), (760, '低'), (2603, '低'), (3380, '中'), (3990, '中'), (11560, '高'), (4380, '中'), (6761, '中'), (4280, '中'), (2325, '低'), (1048, '低'), (3160, '中'), (2483, '低'), (14179, '高'), (1797, '低'), (2511, '低'), (1274, '低'), (5248, '中'), (3029, '中'), (428, '低'), (976, '低'), (841, '低'), (5771, '中'), (1555, '低'), (1285, '低'), (1299, '低'), (1271, '低'), (1393, '低'), (691, '低'), (5045, '中'), (2124, '低'), (2214, '低'), (12680, '高'), (2463, '低'), (1155, '低'), (3108, '中'), (2901, '低'), (3617, '中'), (1655, '低'), (2812, '低'), (8065, '高'), (3275, '中'), (2223, '低'), (1480, '低'), (1371, '低'), (3535, '中'), (3509, '中'), (5711, '中'), (3872, '中'), (4933, '中'), (1940, '低'), (1410, '低'), (836, '低'), (6468, '中'), (1941, '低'), (2675, '低'), (2751, '低'), (6224, '中'), (5998, '中'), (1188, '低'), (6313, '中'), (1221, '低'), (2892, '低'), (3062, '中'), (2301, '低'), (7511, '高'), (1258, '低'), (717, '低'), (1549, '低'), (1597, '低'), (1795, '低'), (4272, '中'), (976, '低'), (7472, '高'), (9271, '高'), (590, '低'), (930, '低'), (9283, '高'), (1778, '低'), (907, '低'), (484, '低'), (9629, '高'), (3051, '中'), (3931, '中'), (7432, '高'), (1338, '低'), (1554, '低'), (15857, '高'), (1345, '低'), (1101, '低'), (3016, '中'), (2712, '低'), (731, '低'), (3780, '中'), (1602, '低'), (3966, '中'), (4165, '中'), (8335, '高'), (6681, '中'), (2375, '低'), (1216, '低'), (11816, '高'), (5084, '中'), (2327, '低'), (1082, '低'), (886, '低'), (601, '低'), (2957, '低'), (2611, '低'), (5179, '中'), (2993, '低'), (1943, '低'), (1559, '低'), (3422, '中'), (3976, '中'), (6761, '中'), (1249, '低'), (1364, '低'), (709, '低'), (2235, '低'), (4042, '中'), (1471, '低'), (1442, '低'), (10875, '高'), (1474, '低'), (894, '低'), (3343, '中'), (3959, '中'), (3577, '中'), (5804, '中'), (2169, '低'), (2439, '低'), (4526, '中'), (2210, '低'), (2221, '低'), (2389, '低'), (3331, '中'), (7409, '高'), (652, '低'), (7678, '高'), (1343, '低'), (1382, '低'), (874, '低'), (3590, '中'), (1322, '低'), (1940, '低'), (3595, '中'), (1422, '低'), (6742, '中'), (7814, '高'), (9277, '高'), (2181, '低'), (1098, '低'), (4057, '中'), (795, '低'), (2825, '低'), (15672, '高'), (6614, '中'), (7824, '高'), (2442, '低'), (1829, '低'), (2171, '低'), (5800, '中'), (1169, '低'), (8947, '高'), (2606, '低'), (1592, '低'), (2186, '低'), (4153, '中'), (2625, '低'), (3485, '中'), (10477, '高'), (1386, '低'), (1278, '低'), (1107, '低'), (3763, '中'), (3711, '中'), (3594, '中'), (3195, '中'), (4454, '中'), (4736, '中'), (2991, '低'), (2142, '低'), (3161, '中'), (18424, '高'), (2848, '低'), (14896, '高'), (2359, '低'), (3345, '中'), (1817, '低'), (12749, '高'), (1366, '低'), (2002, '低'), (6872, '中'), (697, '低'), (1049, '低'), (10297, '高'), (1867, '低'), (1344, '低'), (1747, '低'), (1670, '低'), (1224, '低'), (522, '低'), (1498, '低'), (1919, '低'), (745, '低'), (2063, '低'), (6288, '中'), (6842, '中'), (3527, '中'), (1546, '低'), (929, '低'), (1455, '低'), (1845, '低'), (8358, '高'), (3349, '中'), (2859, '低'), (1533, '低'), (3621, '中'), (3590, '中'), (2145, '低'), (4113, '中'), (10974, '高'), (1893, '低'), (1231, '低'), (3656, '中'), (1154, '低'), (4006, '中'), (3069, '中'), (1740, '低'), (2353, '低'), (3556, '中'), (2397, '低'), (454, '低'), (1715, '低'), (2520, '低'), (3568, '中'), (7166, '高'), (3939, '中'), (1514, '低'), (7393, '高'), (1193, '低'), (7297, '高'), (2831, '低'), (1258, '低'), (753, '低'), (2427, '低'), (2538, '低'), (1264, '低'), (8386, '高'), (4844, '中'), (2923, '低'), (8229, '高'), (2028, '低'), (1433, '低'), (6289, '中'), (1409, '低'), (6579, '中'), (1743, '低'), (3565, '中'), (1569, '低'), (1936, '低'), (3959, '中'), (2390, '低'), (1736, '低'), (3857, '中'), (804, '低'), (1845, '低'), (4576, '中')]
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199