← 返回题库
中级

综合案例实战:Z-Score危险区公司筛选

未完成
中级参考 代码结构已给出,请填写 ____ 处
"____""____""____"

metadata = {
    "____": "____",
    "____": "____",
    "____": "____",
    "____": "____",
    "____": ["____", "____"],
    "____": ["____", "____", "____"],
    "____": ____
}

"____""____""____"

def solve():
    import pandas as pd
    from pyodide.http import open_url
    from io import StringIO

    BASE_URL = "____"
    zs = pd.read_csv(StringIO(open_url(____).read()))
    bs = pd.read_csv(StringIO(open_url(____).read()))

    zs23 = zs[zs['____'] == '____'][['____', '____']]
    bs23 = bs[(____) & (____)][
        ['____', '____', '____', '____']]

    df = zs23.merge(____).dropna(____)
    df = df[df['____'] > ____]
    df['____'] = (____).round(____)

    c1 = (____).sum()
    c2 = ((____) & (____)).sum()
    c3 = ((____) & (____)).sum()
    total = len(____)

    stat = (____)
    result = df[df['____'] < ____].nsmallest(____, '____')[
        ['____', '____', '____', '____']
    ].reset_index(____)
    return stat + result.to_string()

if __name__ == "____":
    print(solve())

示例

输入
solve()
期望输出
=== 2023年Z-Score危险区分类统计 === | 超级危险 (Z<0): 6家 (1.27%) | 高度危险 (0<=Z<1.0): 39家 (8.25%) | 中度危险 (1.0<=Z<1.81): 71家 (15.01%) |  | 超级危险公司TOP10: |     Stkcd ShortName    ZScore   资产负债率 | 0  300338      开元教育 -4.444630  1.2171 | 1  300167    ST 迪威迅 -1.360675  0.9270 | 2  603559     ST 通脉 -0.529853  0.9453 | 3  300237      美晨生态 -0.489319  0.9781 | 4  300198      纳川股份 -0.369889  0.8292 | 5  605069      正和生态 -0.081612  0.6688
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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