a JOj@sdZddlZddZdS)uD OCF/NI 信号计算。 口径：动态最近 5 年年报累计。 Nc Cs>d}tj||dtid}|jr&tS|dtjddt|d<g}|dD]\}}|d}|d }||d|dk}t |dkr| |dddd t |d qV|d  }|d  } | d kr|| nt d} | d ks|d ks| dkrd} n| dkrd} nd} | ||| | | t |d qVt|S)u8从 financial_summary 计算最近 5 年年报 OCF/NI。z SELECT code, report_date, ocf, net_profit FROM financial_summary WHERE report_date LIKE '%1231' AND ocf IS NOT NULL AND net_profit IS NOT NULL code)dtype report_dateNyear insufficient)r ocf_cum_5ynet_profit_cum_5yocf_ni_ratio_5y ocf_ni_status data_yearsocf net_profitrnang? unhealthywatchhealthy)pdread_sqlstrempty DataFrameastypeintgroupby sort_valuesmaxlenappendsumfloat) connsqldfresultsrg latest_yearrecentZocf_cumZnp_cumZratiostatusr+4/tmp/quant_ocf_run_20260709_v2/ocf/signals/ocf_ni.py fetch_ocf_ni sJ"       r-)__doc__pandasrr-r+r+r+r,s