← 返回题库
中级

实现开户功能:验证客户+产品+初始存款

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    offices_csv = open_url(____).read()
    staff_csv = open_url(____).read()
    currencies_csv = open_url(____).read()
    savings_products_csv = open_url(____).read()
    interest_rate_charts_csv = open_url(____).read()
    clients_csv = open_url(____).read()
    savings_accounts_csv = open_url(____).read()
    import sqlite3
    import pandas as pd
    from io import StringIO

    conn = sqlite3.connect(____)
    pd.read_csv(StringIO(____)).to_sql(____)
    pd.read_csv(StringIO(____)).to_sql(____)

    client_id = ____
    product_id = ____  # 三个月定期
    initial_deposit = ____

    client = conn.execute('____', (____)).fetchone()
    product = conn.execute('____', (____)).fetchone()

    if not client:
        print(____)
    elif not product:
        print(____)
    elif initial_deposit < product[____]:
        print(____)
    else:
        result = {
            '____': client[____],
            '____': product[____],
            '____': initial_deposit,
            '____': '____'
        }
        print(____)
    conn.close()

示例

输入
solve()
期望输出
{'client_name': '赵志强', 'product_name': '三个月定期', 'initial_deposit': 20000.0, 'status': 'SUCCESS'}
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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