闻嗅复核：营业收入增长率计算

"""
金融风险管理 - q004
闻嗅复核基础：营业收入增长率计算
"""

metadata = {
    "id": "q004",
    "title": "闻嗅复核：营业收入增长率计算",
    "module": "闻嗅复核基础技术",
    "difficulty": "beginner",
    "data_files": ["case32_xyz_profit.csv"],
    "skills": ["增长率计算", "同比分析", "趋势判断"],
    "estimated_minutes": 8
}

# 题目描述
"""
【题目】
读取case32_xyz_profit.csv，计算XYZ公司2018年全年相对2017年的各项收入/利润增长率：
- 营业收入增长率 = (2018FY_revenue - 2017FY_revenue) / 2017FY_revenue
- 营业成本增长率 = (2018FY_cost - 2017FY_cost) / 2017FY_cost
- 净利润增长率 = (2018FY_net_profit - 2017FY_net_profit) / 2017FY_net_profit

输出DataFrame，包含：指标名称、2017FY值、2018FY值、增长率（保留4位小数）
"""

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

    BASE_URL = "https://data.zuihe.com/finance/"
    df = pd.read_csv(StringIO(open_url(BASE_URL + "case32_xyz_profit.csv").read()))

    fy17 = df[df['period'] == '2017FY'].iloc[0]
    fy18 = df[df['period'] == '2018FY'].iloc[0]

    items = [
        ('营业收入', 'revenue'),
        ('营业成本', 'cost'),
        ('净利润', 'net_profit'),
    ]

    rows = []
    for name, col in items:
        v17 = fy17[col]
        v18 = fy18[col]
        growth = round((v18 - v17) / v17, 4)
        rows.append({'指标名称': name, '2017FY': v17, '2018FY': v18, '增长率': growth})

    return pd.DataFrame(rows).to_string()

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