中级
闻嗅复核:综合异常关注清单生成
未完成
中级参考
代码结构已给出,请填写 ____ 处
"____""____""____"
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()))
h1 = df[df['____'] == '____'].iloc[____]
fy18 = df[df['____'] == '____'].iloc[____]
fy17 = df[df['____'] == '____'].iloc[____]
h2_rev = fy18['____'] - h1['____']
h2_cost = fy18['____'] - h1['____']
h2_sell = fy18['____'] - h1['____']
h2_admin = fy18['____'] - h1['____']
h2_op = fy18['____'] - h1['____']
monthly_h2 = h2_rev / ____
monthly_17 = fy17['____'] / ____
gm_h2 = (____) / h2_rev
gm_17 = (____) / fy17['____']
sell_h2 = h2_sell / h2_rev
sell_17 = fy17['____'] / fy17['____']
admin_h2 = h2_admin / h2_rev
admin_17 = fy17['____'] / fy17['____']
op_h2 = h2_op / h2_rev
op_17 = fy17['____'] / fy17['____']
checks = [
(____),
(____),
(____),
(____),
(____),
]
rows = []
for name, base, actual in checks:
dev = round((____) / abs(____), ____)
conclusion = '____' if abs(____) > ____ else '____'
rows.append({'____': name, '____': round(____),
'____': round(____), '____': dev, '____': conclusion})
return pd.DataFrame(____).to_string()
if __name__ == "____":
print(solve())
示例
输入
solve()
期望输出
检查项目 基准值(2017) 实际值(H2) 偏差率 结论 | 0 月均收入 2.005717e+07 3.605000e+07 0.7974 ⚠ 重点关注 | 1 毛利率 1.524000e-01 2.510000e-01 0.6470 ⚠ 重点关注 | 2 销售费用率 6.600000e-03 3.700000e-03 -0.4436 ⚠ 重点关注 | 3 管理费用率 3.740000e-02 2.770000e-02 -0.2582 ⚠ 重点关注 | 4 营业利润率 9.180000e-02 2.300000e-01 1.5065 ⚠ 重点关注
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199