← 返回题库
中级

闻嗅复核:上下半年数据对比分析

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

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

# 题目描述
"____""____""____"

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

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

    cols = ['____', '____', '____', '____', '____']
    h1 = df[df['____'] == '____'][cols].values[____]
    fy = df[df['____'] == '____'][cols].values[____]
    h2 = fy - h1

    result = pd.DataFrame([h1, h2, (____).round(____)],
                          index=['____', '____', '____'],
                          columns=cols)
    return result.to_string()

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

示例

输入
solve()
期望输出
revenue          cost  selling_expense  operating_profit    net_profit | 2018H1  1.204000e+08  1.000000e+08      820000.0000      1.286000e+07  9.390000e+06 | 2018H2  2.163000e+08  1.620000e+08      800000.0000      4.975000e+07  3.760500e+07 | H2占全年%  6.424000e-01  6.183000e-01           0.4938      7.946000e-01  8.002000e-01
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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