利润表分析：营业利润与净利润质量

"""
金融风险管理 - q016
利润表分析：营业利润与净利润质量分析
"""

metadata = {
    "id": "q016",
    "title": "利润表分析：营业利润与净利润质量",
    "module": "利润表分析与异常识别",
    "difficulty": "beginner",
    "data_files": ["case32_xyz_profit.csv"],
    "skills": ["利润质量", "营业外损益分析", "核心利润占比"],
    "estimated_minutes": 10
}

# 题目描述
"""
【题目】
读取case32_xyz_profit.csv，分析XYZ公司各期利润质量：

计算：
- 核心利润 = operating_profit（营业利润，剔除营业外影响）
- 营业外净额 = non_op_income - non_op_expense
- 核心利润占净利润比 = operating_profit / net_profit
- 营业外净额占净利润比 = 营业外净额 / net_profit

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

    result = df[['operating_profit', 'net_profit', '营业外净额', '核心利润占净利润比', '营业外净额占净利润比']]
    return result.to_string()

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