← 返回题库
初级

别名AS

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
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 "Credit amount" AS 信用额度 FROM german_credit_risk').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,)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册