← 返回题库
初级

统计处方中抗生素使用率与费用占比

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    presc=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-medibook/state_02/prescriptions.csv").read()))
    antibiotic=presc[presc['drug_category']=='抗生素']
    print(f"Total prescriptions: {len(presc)}")
    print(f"Antibiotic prescriptions: {len(antibiotic)} ({round(len(antibiotic)/len(presc)*100,1)}%)")
    print(f"Total antibiotic cost: {round(antibiotic['total_price'].sum(),2)}")
    print(f"Antibiotic cost as % of total: {round(antibiotic['total_price'].sum()/presc['total_price'].sum()*100,1)}%")

示例

输入
solve()
期望输出
Total prescriptions: 182
Antibiotic prescriptions: 31 (17.0%)
Total antibiotic cost: 1833.5
Antibiotic cost as % of total: 24.6%
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册