初级
LIKE：百分号通配符
未完成
初级参考
完整示例代码供参考，建议自己理解后重新输入
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 Purpose LIKE \'bu%\'').fetchall()
conn.close()
return result示例
输入
print(solve())
期望输出
[(11, 24, 'female', 2, 'rent', 'little', 'little', 4308, 48, 'business', 'bad'), (17, 25, 'male', 2, 'own', None, 'little', 8072, 30, 'business', 'good'), (29, 63, 'male', 2, 'own', 'little', 'little', 6836, 60, 'business', 'bad'), (30, 36, 'male', 2, 'own', 'rich', 'moderate', 1913, 18, 'business', 'good'), (33, 57, 'male', 1, 'rent', None, None, 1264, 12, 'business', 'good'), (60, 27, 'male', 2, 'own', 'little', 'moderate', 1391, 9, 'business', 'good'), (62, 61, 'male', 3, 'free', 'little', 'moderate', 1953, 36, 'business', 'bad'), (63, 25, 'male', 2, 'own', 'little', 'moderate', 14421, 48, 'business', 'bad'), (73, 41, 'female', 1, 'own', 'little', 'moderate', 5954, 42, 'business', 'good'), (82, 24, 'female', 1, 'rent', 'moderate', None, 1568, 18, 'business', 'good'), (85, 29, 'female', 3, 'own', 'little', None, 1412, 12, 'business', 'good'), (95, 58, 'male', 2, 'rent', 'little', 'moderate', 15945, 54, 'business', 'bad'), (97, 34, 'male', 2, 'own', 'moderate', 'moderate', 2622, 18, 'business', 'good'), (109, 35, 'male', 2, 'own', 'quite rich', 'moderate', 1410, 14, 'business', 'good'), (110, 31, 'male', 2, 'own', 'moderate', 'moderate', 1449, 6, 'business', 'good'), (145, 30, 'male', 2, 'own', 'moderate', 'moderate', 3566, 48, 'business', 'good'), (154, 36, 'male', 3, 'rent', 'moderate', 'moderate', 6967, 24, 'business', 'good'), (169, 31, 'male', 2, 'own', 'little', 'moderate', 1935, 24, 'business', 'bad'), (180, 28, 'male', 2, 'own', 'little', None, 9572, 36, 'business', 'bad'), (181, 30, 'male', 3, 'own', 'little', 'moderate', 4455, 36, 'business', 'bad'), (190, 54, 'male', 3, 'own', 'rich', None, 4591, 24, 'business', 'bad'), (191, 34, 'male', 1, 'free', 'moderate', 'moderate', 3844, 48, 'business', 'bad'), (192, 36, 'male', 2, 'own', 'little', 'moderate', 3915, 27, 'business', 'bad'), (202, 26, 'male', 2, 'own', 'little', None, 5117, 27, 'business', 'good'), (208, 21, 'male', 1, 'own', 'little', 'little', 6568, 24, 'business', 'good'), (212, 50, 'male', 2, 'own', 'little', 'little', 5293, 27, 'business', 'bad'), (213, 66, 'male', 3, 'own', 'little', 'rich', 1908, 30, 'business', 'bad'), (216, 31, 'male', 2, 'own', 'little', 'little', 3104, 18, 'business', 'good'), (223, 32, 'male', 2, 'own', None, None, 2978, 24, 'business', 'good'), (237, 61, 'male', 1, 'rent', 'moderate', 'moderate', 2767, 21, 'business', 'bad'), (243, 27, 'female', 2, 'own', 'little', None, 1185, 12, 'business', 'good'), (245, 25, 'male', 2, 'own', 'little', None, 1258, 24, 'business', 'good'), (266, 36, 'male', 2, 'own', None, None, 6304, 36, 'business', 'good'), (290, 26, 'male', 2, 'own', 'little', None, 1076, 12, 'business', 'good'), (294, 46, 'male', 3, 'own', None, None, 7629, 48, 'business', 'good'), (343, 33, 'male', 3, 'own', 'little', 'moderate', 4439, 18, 'business', 'good'), (348, 34, 'male', 1, 'own', 'moderate', None, 1743, 6, 'business', 'good'), (365, 36, 'male', 2, 'own', 'little', None, 1542, 12, 'business', 'good'), (375, 37, 'female', 2, 'rent', 'little', 'little', 7685, 48, 'business', 'bad'), (384, 26, 'male', 1, 'own', 'moderate', None, 4272, 30, 'business', 'good'), (388, 27, 'male', 2, 'own', 'quite rich', 'moderate', 2326, 15, 'business', 'good'), (389, 27, 'female', 2, 'own', 'little', None, 1449, 9, 'business', 'good'), (401, 28, 'male', 2, 'own', None, 'moderate', 1887, 18, 'business', 'good'), (402, 27, 'male', 2, 'own', 'little', None, 8648, 24, 'business', 'bad'), (412, 42, 'male', 3, 'own', 'little', None, 2292, 12, 'business', 'bad'), (430, 74, 'male', 1, 'own', 'little', None, 3448, 5, 'business', 'good'), (439, 26, 'female', 0, 'own', 'little', 'rich', 609, 12, 'business', 'bad'), (464, 34, 'male', 2, 'own', 'little', None, 1950, 18, 'business', 'good'), (468, 26, 'female', 2, 'own', 'little', None, 2764, 33, 'business', 'good'), (478, 39, 'male', 1, 'own', 'moderate', 'moderate', 1037, 12, 'business', 'good'), (491, 42, 'female', 3, 'free', 'little', 'moderate', 8318, 27, 'business', 'bad'), (512, 26, 'male', 2, 'rent', 'little', 'rich', 2687, 15, 'business', 'good'), (564, 37, 'male', 3, 'own', None, 'moderate', 4712, 24, 'business', 'good'), (573, 22, 'female', 1, 'own', 'little', 'little', 806, 15, 'business', 'good'), (592, 36, 'female', 1, 'own', 'rich', None, 1572, 21, 'business', 'good'), (597, 36, 'male', 1, 'own', 'little', 'moderate', 4241, 24, 'business', 'bad'), (599, 32, 'male', 2, 'free', 'little', None, 3863, 24, 'business', 'good'), (606, 74, 'male', 3, 'own', 'little', None, 4526, 24, 'business', 'good'), (615, 48, 'male', 3, 'own', None, 'moderate', 12204, 48, 'business', 'good'), (620, 27, 'male', 2, 'own', 'little', 'moderate', 3652, 21, 'business', 'good'), (622, 38, 'male', 2, 'own', None, None, 3914, 48, 'business', 'bad'), (645, 27, 'male', 2, 'rent', None, None, 7980, 36, 'business', 'bad'), (658, 28, 'female', 2, 'own', 'little', 'moderate', 4221, 30, 'business', 'good'), (667, 27, 'female', 2, 'own', 'little', None, 3609, 48, 'business', 'good'), (670, 27, 'male', 1, 'own', 'moderate', None, 4139, 24, 'business', 'good'), (671, 31, 'male', 2, 'own', 'moderate', None, 5742, 36, 'business', 'good'), (674, 41, 'male', 1, 'own', 'quite rich', None, 2580, 21, 'business', 'bad'), (684, 31, 'male', 1, 'own', 'moderate', 'moderate', 9857, 36, 'business', 'good'), (703, 41, 'male', 2, 'own', 'moderate', 'moderate', 2503, 30, 'business', 'good'), (704, 32, 'female', 2, 'own', 'little', 'moderate', 2528, 27, 'business', 'good'), (728, 59, 'female', 2, 'rent', 'little', 'moderate', 6416, 48, 'business', 'bad'), (729, 36, 'male', 2, 'own', 'rich', 'rich', 1275, 24, 'business', 'good'), (739, 26, 'female', 1, 'rent', 'moderate', 'moderate', 4280, 30, 'business', 'bad'), (745, 28, 'male', 1, 'own', 'little', 'little', 1797, 13, 'business', 'good'), (752, 23, 'female', 1, 'rent', 'moderate', 'moderate', 841, 12, 'business', 'good'), (785, 35, 'male', 1, 'own', 'rich', 'moderate', 1941, 18, 'business', 'good'), (790, 39, 'female', 2, 'own', 'little', 'moderate', 1188, 21, 'business', 'bad'), (810, 26, 'male', 2, 'own', 'little', 'moderate', 907, 8, 'business', 'good'), (827, 36, 'male', 2, 'own', 'little', None, 4165, 18, 'business', 'bad'), (829, 38, 'male', 2, 'free', None, 'moderate', 6681, 48, 'business', 'good'), (830, 44, 'male', 2, 'own', 'quite rich', None, 2375, 24, 'business', 'good'), (832, 29, 'male', 2, 'rent', 'little', 'little', 11816, 45, 'business', 'bad'), (843, 50, 'male', 2, 'own', 'little', None, 1559, 24, 'business', 'good'), (861, 28, 'male', 2, 'own', 'little', None, 2169, 18, 'business', 'bad'), (868, 37, 'male', 2, 'own', None, None, 7409, 36, 'business', 'good'), (872, 26, 'male', 2, 'own', 'moderate', 'little', 1382, 24, 'business', 'good'), (886, 34, 'male', 2, 'own', None, 'moderate', 2825, 24, 'business', 'good'), (887, 23, 'male', 2, 'own', 'little', 'moderate', 15672, 48, 'business', 'bad'), (890, 43, 'male', 3, 'own', 'little', 'little', 2442, 27, 'business', 'good'), (913, 28, 'male', 2, 'own', 'rich', None, 2142, 11, 'business', 'good'), (914, 31, 'male', 2, 'rent', 'little', 'little', 3161, 24, 'business', 'bad'), (950, 40, 'male', 0, 'own', 'little', 'moderate', 3590, 18, 'business', 'good'), (951, 24, 'male', 2, 'own', 'little', 'little', 2145, 36, 'business', 'bad'), (973, 36, 'male', 2, 'rent', 'little', 'little', 7297, 60, 'business', 'bad'), (977, 42, 'male', 2, 'own', None, 'moderate', 2427, 18, 'business', 'good'), (981, 33, 'male', 3, 'rent', 'little', None, 4844, 48, 'business', 'bad'), (986, 33, 'male', 2, 'own', 'little', 'rich', 6289, 42, 'business', 'good')]
👑
升级 VIP
解锁全部题目，畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199
