← 返回题库
中级

计算患者就诊账单

未完成
中级参考 代码结构已给出，请填写 ____ 处 
def solve():
    from pyodide.http import open_url
    patients_csv = open_url(____).read()
    departments_csv = open_url(____).read()
    doctors_csv = open_url(____).read()
    appointments_csv = open_url(____).read()
    diagnoses_csv = open_url(____).read()
    prescriptions_csv = open_url(____).read()
    bills_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(____)

    result = pd.read_sql_query(____)
    print(result.to_string(____))
    conn.close()

示例

输入
solve()
期望输出
patient_name  registration_fee  drug_fee  exam_fee  total status
          黄强              15.0     560.0     650.0 1225.0   paid
          林静              15.0     186.0     380.0  581.0 unpaid
          周浩              15.0     187.5     280.0  482.5   paid
          李芳              15.0     245.0     180.0  440.0   paid
          郑博              15.0     320.0       0.0  335.0   paid
          王军              15.0     156.8     100.0  271.8   paid
          孙梅              15.0      98.0     150.0  263.0   paid
          马超              15.0       0.0     220.0  235.0   paid
          王军              15.0     156.8       0.0  171.8   paid
          陈霞              15.0       0.0     120.0  135.0 unpaid
          徐丽              15.0      89.0       0.0  104.0   paid
          张伟              15.0      68.5       0.0   83.5   paid
          赵磊              15.0      42.0       0.0   57.0   paid
          刘洋              15.0      38.5       0.0   53.5   paid
          张伟              15.0      28.5       0.0   43.5   paid
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册