闻嗅复核：三大费用率结构分析

"""
金融风险管理 - q005
闻嗅复核基础：费用率结构分析
"""

metadata = {
    "id": "q005",
    "title": "闻嗅复核：三大费用率结构分析",
    "module": "闻嗅复核基础技术",
    "difficulty": "beginner",
    "data_files": ["case32_xyz_profit.csv"],
    "skills": ["费用率计算", "结构分析", "配比原则"],
    "estimated_minutes": 8
}

# 题目描述
"""
【题目】
读取case32_xyz_profit.csv，计算XYZ公司各期三大费用率：
- 销售费用率 = selling_expense / revenue
- 管理费用率 = admin_expense / revenue
- 财务费用率 = finance_expense / revenue

输出DataFrame，index为period，columns为三个费用率（保留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()))

    df = df.set_index('period')
    result = pd.DataFrame({
        '销售费用率': (df['selling_expense'] / df['revenue']).round(4),
        '管理费用率': (df['admin_expense'] / df['revenue']).round(4),
        '财务费用率': (df['finance_expense'] / df['revenue']).round(4),
    })

    return result.to_string()

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