闻嗅复核：营业外收支占利润总额比重

"""
金融风险管理 - q008
闻嗅复核基础：营业外收支分析
"""

metadata = {
    "id": "q008",
    "title": "闻嗅复核：营业外收支占利润总额比重",
    "module": "闻嗅复核基础技术",
    "difficulty": "beginner",
    "data_files": ["case32_xyz_profit.csv"],
    "skills": ["非经常性损益分析", "占比计算", "异常关注"],
    "estimated_minutes": 8
}

# 题目描述
"""
【题目】
读取case32_xyz_profit.csv，计算XYZ公司各期营业外收支净额及其占利润总额的比重：
- 营业外净额 = non_op_income - non_op_expense
- 占比 = 营业外净额 / total_profit

输出DataFrame，index为period，包含：non_op_income、non_op_expense、营业外净额、占比（保留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')
    df['营业外净额'] = df['non_op_income'] - df['non_op_expense']
    df['占利润总额比'] = (df['营业外净额'] / df['total_profit']).round(4)

    result = df[['non_op_income', 'non_op_expense', '营业外净额', '占利润总额比']]
    return result.to_string()

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