← 返回题库
初级

算术计算

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
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"/Duration AS monthly_payment FROM german_credit_risk').fetchall()
    conn.close()
    return result

示例

输入
print(solve())
期望输出
[(194,), (123,), (174,), (187,), (202,), (251,), (118,), (193,), (254,), (174,), (107,), (89,), (130,), (49,), (93,), (53,), (101,), (269,), (524,), (142,), (237,), (441,), (224,), (150,), (206,), (229,), (71,), (34,), (345,), (113,), (106,), (167,), (325,), (105,), (122,), (105,), (127,), (116,), (122,), (50,), (77,), (96,), (344,), (206,), (127,), (126,), (63,), (225,), (657,), (172,), (97,), (220,), (105,), (187,), (61,), (130,), (539,), (265,), (108,), (173,), (154,), (102,), (54,), (300,), (132,), (192,), (180,), (83,), (50,), (66,), (225,), (104,), (145,), (141,), (54,), (127,), (94,), (433,), (174,), (127,), (247,), (80,), (87,), (73,), (231,), (117,), (71,), (350,), (124,), (92,), (51,), (117,), (66,), (150,), (109,), (295,), (167,), (145,), (64,), (352,), (61,), (64,), (155,), (213,), (203,), (497,), (358,), (506,), (321,), (100,), (241,), (26,), (347,), (218,), (140,), (74,), (170,), (213,), (129,), (197,), (87,), (161,), (147,), (78,), (106,), (176,), (58,), (53,), (155,), (291,), (176,), (191,), (180,), (110,), (169,), (103,), (319,), (63,), (181,), (156,), (118,), (133,), (126,), (136,), (108,), (74,), (143,), (56,), (149,), (87,), (224,), (192,), (162,), (323,), (290,), (106,), (143,), (28,), (146,), (316,), (119,), (58,), (84,), (730,), (25,), (496,), (62,), (143,), (165,), (80,), (63,), (63,), (86,), (176,), (162,), (249,), (214,), (56,), (163,), (27,), (265,), (123,), (78,), (157,), (49,), (90,), (569,), (73,), (56,), (180,), (191,), (80,), (145,), (351,), (67,), (166,), (230,), (79,), (115,), (238,), (104,), (97,), (189,), (75,), (124,), (354,), (161,), (118,), (273,), (117,), (341,), (106,), (196,), (63,), (92,), (155,), (172,), (108,), (125,), (136,), (52,), (100,), (58,), (124,), (310,), (72,), (228,), (655,), (164,), (131,), (116,), (278,), (178,), (48,), (386,), (75,), (2425,), (131,), (107,), (84,), (38,), (265,), (95,), (98,), (287,), (52,), (59,), (200,), (80,), (24,), (111,), (187,), (71,), (172,), (225,), (123,), (111,), (179,), (254,), (104,), (138,), (66,), (294,), (229,), (123,), (53,), (175,), (63,), (641,), (41,), (147,), (116,), (253,), (63,), (399,), (299,), (133,), (105,), (768,), (79,), (224,), (131,), (80,), (101,), (161,), (228,), (99,), (157,), (91,), (42,), (89,), (261,), (267,), (114,), (158,), (207,), (389,), (128,), (139,), (130,), (112,), (105,), (56,), (103,), (210,), (257,), (160,), (60,), (154,), (30,), (112,), (229,), (156,), (57,), (373,), (76,), (59,), (181,), (58,), (242,), (141,), (80,), (121,), (147,), (57,), (424,), (483,), (63,), (124,), (178,), (275,), (103,), (123,), (241,), (171,), (564,), (161,), (85,), (173,), (152,), (239,), (171,), (178,), (246,), (394,), (97,), (67,), (156,), (290,), (126,), (137,), (106,), (179,), (516,), (72,), (51,), (194,), (123,), (64,), (80,), (68,), (283,), (187,), (294,), (137,), (128,), (213,), (202,), (95,), (166,), (85,), (337,), (214,), (229,), (246,), (160,), (128,), (120,), (397,), (60,), (110,), (720,), (58,), (110,), (142,), (124,), (62,), (409,), (155,), (161,), (101,), (81,), (90,), (326,), (267,), (301,), (214,), (65,), (101,), (63,), (81,), (104,), (360,), (57,), (161,), (84,), (91,), (70,), (134,), (78,), (81,), (219,), (191,), (159,), (57,), (162,), (214,), (470,), (132,), (57,), (212,), (169,), (79,), (75,), (230,), (154,), (97,), (63,), (145,), (66,), (689,), (472,), (312,), (85,), (237,), (123,), (110,), (53,), (80,), (50,), (157,), (135,), (131,), (59,), (106,), (138,), (51,), (368,), (118,), (100,), (307,), (86,), (229,), (111,), (200,), (111,), (355,), (282,), (57,), (255,), (100,), (114,), (251,), (62,), (108,), (121,), (69,), (150,), (83,), (194,), (128,), (74,), (72,), (206,), (69,), (173,), (65,), (214,), (86,), (98,), (297,), (50,), (120,), (64,), (96,), (201,), (256,), (156,), (141,), (586,), (161,), (308,), (206,), (61,), (176,), (124,), (250,), (66,), (72,), (220,), (130,), (152,), (125,), (50,), (50,), (130,), (157,), (456,), (58,), (220,), (63,), (130,), (179,), (48,), (93,), (101,), (226,), (197,), (200,), (116,), (229,), (177,), (148,), (145,), (61,), (306,), (102,), (375,), (63,), (110,), (63,), (175,), (125,), (54,), (129,), (110,), (229,), (200,), (161,), (169,), (127,), (84,), (211,), (159,), (104,), (55,), (84,), (64,), (52,), (184,), (83,), (291,), (145,), (166,), (133,), (110,), (126,), (238,), (148,), (107,), (123,), (64,), (113,), (344,), (196,), (64,), (114,), (107,), (82,), (140,), (134,), (198,), (226,), (53,), (120,), (185,), (244,), (80,), (78,), (39,), (58,), (260,), (154,), (66,), (177,), (113,), (311,), (107,), (67,), (187,), (32,), (81,), (74,), (113,), (56,), (155,), (60,), (176,), (154,), (160,), (332,), (102,), (76,), (93,), (127,), (117,), (188,), (74,), (113,), (86,), (61,), (124,), (159,), (151,), (100,), (254,), (152,), (612,), (114,), (53,), (173,), (85,), (81,), (154,), (144,), (131,), (352,), (159,), (96,), (425,), (152,), (86,), (96,), (220,), (56,), (116,), (57,), (260,), (124,), (104,), (41,), (87,), (308,), (77,), (104,), (221,), (152,), (115,), (39,), (57,), (155,), (160,), (95,), (224,), (97,), (283,), (74,), (212,), (140,), (353,), (108,), (75,), (106,), (175,), (174,), (263,), (116,), (75,), (403,), (100,), (172,), (159,), (172,), (346,), (122,), (151,), (214,), (77,), (99,), (80,), (256,), (189,), (98,), (212,), (273,), (108,), (134,), (79,), (305,), (304,), (65,), (175,), (120,), (786,), (95,), (206,), (91,), (77,), (100,), (127,), (93,), (131,), (57,), (83,), (93,), (354,), (136,), (247,), (134,), (235,), (34,), (199,), (117,), (126,), (233,), (253,), (102,), (83,), (131,), (307,), (148,), (72,), (102,), (87,), (95,), (41,), (87,), (104,), (133,), (53,), (266,), (82,), (95,), (108,), (845,), (110,), (481,), (243,), (1126,), (142,), (96,), (104,), (150,), (103,), (363,), (138,), (167,), (106,), (249,), (201,), (71,), (54,), (70,), (192,), (129,), (53,), (216,), (84,), (58,), (57,), (336,), (118,), (184,), (603,), (102,), (96,), (103,), (290,), (301,), (137,), (117,), (224,), (155,), (92,), (123,), (57,), (98,), (194,), (158,), (215,), (126,), (80,), (117,), (69,), (323,), (107,), (121,), (57,), (129,), (149,), (56,), (263,), (203,), (120,), (127,), (255,), (417,), (104,), (29,), (172,), (66,), (99,), (213,), (81,), (622,), (257,), (98,), (77,), (221,), (118,), (113,), (80,), (267,), (63,), (81,), (206,), (223,), (259,), (440,), (74,), (91,), (251,), (75,), (91,), (210,), (76,), (220,), (231,), (231,), (139,), (98,), (67,), (262,), (211,), (155,), (90,), (73,), (150,), (123,), (108,), (143,), (142,), (107,), (64,), (190,), (189,), (375,), (52,), (151,), (59,), (111,), (168,), (98,), (80,), (302,), (61,), (89,), (222,), (263,), (397,), (241,), (120,), (101,), (167,), (221,), (148,), (132,), (277,), (205,), (54,), (213,), (223,), (57,), (58,), (299,), (120,), (107,), (99,), (158,), (224,), (325,), (386,), (72,), (61,), (169,), (66,), (117,), (326,), (183,), (279,), (90,), (121,), (180,), (161,), (64,), (248,), (124,), (132,), (145,), (230,), (164,), (174,), (291,), (92,), (53,), (92,), (179,), (103,), (239,), (355,), (123,), (197,), (99,), (194,), (131,), (383,), (284,), (2482,), (98,), (139,), (100,), (265,), (151,), (166,), (286,), (58,), (58,), (214,), (62,), (112,), (72,), (185,), (136,), (43,), (124,), (63,), (82,), (343,), (104,), (285,), (293,), (154,), (38,), (363,), (123,), (174,), (139,), (238,), (85,), (150,), (199,), (59,), (171,), (304,), (157,), (51,), (121,), (128,), (143,), (127,), (290,), (112,), (237,), (99,), (75,), (57,), (93,), (237,), (170,), (358,), (100,), (308,), (49,), (121,), (94,), (52,), (125,), (134,), (105,), (84,), (279,), (100,), (139,), (228,), (84,), (95,), (149,), (108,), (274,), (72,), (297,), (104,), (107,), (109,), (199,), (144,), (128,), (67,), (41,), (101,)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册