← 返回题库
初级

NULLIF函数

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

示例

输入
print(solve())
期望输出
[(6,), (48,), (12,), (42,), (24,), (36,), (24,), (36,), (12,), (30,), (12,), (48,), (12,), (24,), (15,), (24,), (24,), (30,), (24,), (24,), (9,), (6,), (10,), (12,), (10,), (6,), (6,), (12,), (7,), (60,), (18,), (24,), (18,), (12,), (12,), (45,), (48,), (18,), (10,), (9,), (30,), (12,), (18,), (30,), (48,), (11,), (36,), (6,), (11,), (12,), (24,), (27,), (12,), (18,), (36,), (6,), (12,), (36,), (18,), (36,), (9,), (15,), (36,), (48,), (24,), (27,), (12,), (12,), (36,), (36,), (36,), (7,), (8,), (42,), (36,), (12,), (42,), (11,), (54,), (30,), (24,), (15,), (18,), (24,), (10,), (12,), (18,), (36,), (18,), (12,), (12,), (12,), (12,), (24,), (12,), (54,), (12,), (18,), (36,), (20,), (24,), (36,), (6,), (9,), (12,), (24,), (18,), (12,), (24,), (14,), (6,), (15,), (18,), (36,), (12,), (48,), (42,), (10,), (33,), (12,), (21,), (24,), (12,), (10,), (18,), (12,), (12,), (12,), (12,), (12,), (48,), (36,), (15,), (18,), (60,), (12,), (27,), (12,), (15,), (12,), (6,), (36,), (27,), (18,), (21,), (48,), (6,), (12,), (36,), (18,), (6,), (10,), (36,), (24,), (24,), (12,), (9,), (12,), (24,), (6,), (24,), (18,), (15,), (10,), (36,), (6,), (18,), (11,), (24,), (24,), (15,), (12,), (24,), (8,), (21,), (30,), (12,), (6,), (12,), (21,), (36,), (36,), (21,), (24,), (18,), (15,), (9,), (16,), (12,), (18,), (24,), (48,), (27,), (6,), (45,), (9,), (6,), (12,), (24,), (18,), (9,), (12,), (27,), (12,), (12,), (30,), (12,), (12,), (24,), (12,), (9,), (36,), (27,), (30,), (36,), (6,), (18,), (36,), (24,), (10,), (12,), (12,), (12,), (24,), (15,), (36,), (48,), (12,), (9,), (24,), (36,), (9,), (12,), (18,), (4,), (24,), (6,), (21,), (12,), (30,), (24,), (6,), (48,), (12,), (12,), (24,), (12,), (6,), (24,), (18,), (6,), (12,), (30,), (24,), (9,), (60,), (24,), (12,), (15,), (11,), (12,), (24,), (18,), (12,), (10,), (15,), (36,), (24,), (14,), (24,), (18,), (12,), (48,), (48,), (30,), (9,), (18,), (12,), (6,), (24,), (15,), (12,), (18,), (15,), (24,), (47,), (48,), (48,), (12,), (24,), (12,), (36,), (24,), (42,), (48,), (48,), (12,), (10,), (18,), (21,), (6,), (36,), (24,), (10,), (48,), (6,), (30,), (12,), (8,), (9,), (48,), (24,), (24,), (12,), (4,), (36,), (12,), (24,), (12,), (15,), (30,), (24,), (24,), (18,), (18,), (8,), (12,), (24,), (36,), (6,), (24,), (18,), (60,), (48,), (24,), (6,), (13,), (15,), (24,), (10,), (24,), (21,), (18,), (18,), (10,), (15,), (13,), (24,), (6,), (9,), (9,), (9,), (18,), (12,), (10,), (24,), (12,), (36,), (12,), (30,), (18,), (12,), (12,), (6,), (18,), (12,), (18,), (18,), (36,), (18,), (36,), (18,), (10,), (60,), (60,), (48,), (18,), (7,), (36,), (6,), (20,), (18,), (22,), (12,), (30,), (18,), (18,), (18,), (15,), (9,), (18,), (12,), (36,), (6,), (9,), (39,), (12,), (36,), (12,), (24,), (18,), (18,), (24,), (14,), (18,), (24,), (24,), (15,), (24,), (12,), (24,), (33,), (12,), (10,), (24,), (36,), (12,), (18,), (21,), (18,), (15,), (12,), (12,), (21,), (12,), (18,), (28,), (18,), (9,), (18,), (5,), (24,), (6,), (24,), (9,), (12,), (6,), (24,), (42,), (12,), (12,), (12,), (20,), (12,), (48,), (9,), (36,), (7,), (12,), (15,), (36,), (6,), (12,), (24,), (24,), (24,), (11,), (12,), (6,), (18,), (36,), (15,), (12,), (12,), (18,), (24,), (24,), (48,), (33,), (24,), (24,), (6,), (9,), (6,), (18,), (18,), (39,), (24,), (12,), (15,), (12,), (24,), (30,), (15,), (12,), (6,), (12,), (24,), (10,), (6,), (12,), (27,), (6,), (6,), (12,), (24,), (36,), (24,), (18,), (6,), (24,), (36,), (9,), (24,), (24,), (10,), (15,), (15,), (24,), (39,), (12,), (36,), (15,), (12,), (24,), (6,), (6,), (36,), (6,), (6,), (24,), (18,), (48,), (24,), (18,), (26,), (15,), (4,), (36,), (6,), (36,), (15,), (12,), (24,), (24,), (21,), (6,), (18,), (48,), (18,), (12,), (24,), (30,), (18,), (12,), (24,), (24,), (24,), (12,), (48,), (12,), (6,), (48,), (12,), (9,), (12,), (18,), (21,), (24,), (18,), (24,), (24,), (6,), (36,), (24,), (24,), (12,), (24,), (48,), (48,), (24,), (30,), (24,), (15,), (9,), (15,), (12,), (24,), (36,), (24,), (18,), (12,), (9,), (36,), (12,), (18,), (9,), (12,), (18,), (12,), (12,), (24,), (21,), (24,), (24,), (6,), (24,), (24,), (18,), (24,), (7,), (9,), (24,), (36,), (10,), (24,), (24,), (36,), (18,), (15,), (12,), (10,), (21,), (24,), (18,), (48,), (60,), (6,), (30,), (12,), (21,), (18,), (48,), (12,), (18,), (15,), (6,), (9,), (42,), (9,), (24,), (18,), (15,), (9,), (24,), (12,), (24,), (60,), (12,), (42,), (18,), (15,), (15,), (24,), (18,), (36,), (30,), (12,), (24,), (12,), (48,), (12,), (24,), (36,), (24,), (14,), (12,), (48,), (30,), (18,), (12,), (12,), (21,), (6,), (6,), (24,), (30,), (48,), (12,), (30,), (24,), (36,), (60,), (6,), (21,), (30,), (24,), (72,), (24,), (18,), (6,), (12,), (15,), (24,), (36,), (60,), (10,), (36,), (9,), (12,), (15,), (15,), (24,), (6,), (24,), (6,), (12,), (12,), (18,), (15,), (12,), (48,), (24,), (30,), (27,), (15,), (48,), (12,), (9,), (9,), (18,), (6,), (21,), (9,), (60,), (30,), (30,), (18,), (24,), (20,), (9,), (6,), (12,), (9,), (27,), (6,), (15,), (18,), (48,), (24,), (24,), (24,), (8,), (24,), (4,), (36,), (24,), (18,), (6,), (30,), (24,), (10,), (21,), (24,), (39,), (13,), (15,), (12,), (21,), (15,), (6,), (18,), (12,), (30,), (12,), (24,), (6,), (15,), (24,), (12,), (15,), (18,), (12,), (21,), (24,), (12,), (30,), (10,), (12,), (12,), (24,), (36,), (21,), (24,), (12,), (24,), (36,), (18,), (36,), (18,), (39,), (24,), (12,), (12,), (20,), (18,), (22,), (48,), (48,), (40,), (21,), (24,), (6,), (24,), (24,), (9,), (18,), (12,), (24,), (9,), (24,), (18,), (20,), (12,), (12,), (36,), (6,), (12,), (42,), (15,), (8,), (6,), (36,), (48,), (48,), (36,), (6,), (6,), (36,), (18,), (12,), (12,), (36,), (8,), (18,), (21,), (18,), (18,), (36,), (48,), (24,), (18,), (45,), (24,), (15,), (12,), (12,), (4,), (24,), (24,), (36,), (21,), (18,), (24,), (18,), (21,), (18,), (24,), (9,), (12,), (20,), (24,), (15,), (18,), (36,), (24,), (10,), (15,), (15,), (9,), (24,), (18,), (24,), (27,), (10,), (15,), (18,), (12,), (36,), (12,), (36,), (6,), (24,), (15,), (12,), (11,), (18,), (36,), (9,), (30,), (24,), (24,), (30,), (18,), (24,), (12,), (24,), (48,), (36,), (28,), (27,), (15,), (12,), (36,), (18,), (36,), (21,), (12,), (15,), (18,), (16,), (20,), (36,), (15,), (24,), (12,), (21,), (36,), (15,), (9,), (36,), (24,), (30,), (11,), (24,), (48,), (10,), (6,), (24,), (24,), (18,), (48,), (9,), (12,), (24,), (12,), (18,), (48,), (30,), (12,), (24,), (9,), (9,), (12,), (12,), (30,), (9,), (6,), (60,), (24,), (12,), (10,), (24,), (4,), (15,), (48,), (24,), (12,), (18,), (24,), (18,), (36,), (24,), (36,), (12,), (24,), (30,), (9,), (28,), (24,), (6,), (21,), (15,), (24,), (6,), (30,), (27,), (15,), (42,), (11,), (15,), (24,), (24,), (60,), (30,), (24,), (6,), (18,), (24,), (15,), (30,), (48,), (21,), (36,), (24,), (15,), (42,), (13,), (24,), (24,), (12,), (15,), (18,), (36,), (12,), (12,), (30,), (12,), (45,), (45,)]
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册