"""第四轮C10:构造实收数据的事件、日历与描述统计。仅使用标准库。 运行后在脚本相邻位置生成同名JSON;金额单位元,天数按日期相减,不含起日。 不推算税额、劳动权利、收益或未来收入;空值保留未知,不替换成零。 """ from pathlib import Path from datetime import date, timedelta from fractions import Fraction from math import sqrt import json def number(x): if isinstance(x, Fraction): return int(x) if x.denominator == 1 else round(float(x), 8) if isinstance(x, float): return round(x, 8) if isinstance(x, list): return [number(v) for v in x] if isinstance(x, tuple): return [number(v) for v in x] if isinstance(x, dict): return {k: number(v) for k, v in x.items()} return x def allocation(expected, payments, cutoff): months = sorted(set(expected) | {p[1][:7] for p in payments if p[1] <= cutoff}) cash_months = sorted({p[1][:7] for p in payments if p[1] <= cutoff}) matrix = [] for service, amount in expected.items(): cells = {m: sum(p[2] for p in payments if p[0] == service and p[1][:7] == m and p[1] <= cutoff) for m in cash_months} received = sum(cells.values()) matrix.append(dict(service=service, confirmed_net=amount, cash_cells=cells, received=received, unpaid=amount-received)) curves = [dict(month=m, service=expected.get(m, 0), cash=sum(p[2] for p in payments if p[1][:7] == m and p[1] <= cutoff)) for m in months] return dict(matrix=matrix, curves=curves, confirmed=sum(expected.values()), received=sum(r['received'] for r in matrix), unpaid=sum(r['unpaid'] for r in matrix)) def cumulative(snapshots): rows=[] for i,(month,value) in enumerate(snapshots): if not i: rows.append(dict(month=month,cumulative=value,increment=None,status='仅作期初基线')) continue prev,base=snapshots[i-1] y,m=map(int,month.split('-'));py,pm=map(int,prev.split('-')) gap=(y-py)*12+m-pm if y!=py: status='已确认年度重置' if m==1 else '跨年但缺期初,不能拆分' inc=value if m==1 else None elif valuebalance+new or offset>confirmed:raise ValueError('抵扣超过可清余额或当期确认数') opening=balance;balance+=new-offset payout=confirmed-offset rows.append(dict(month=month,opening=opening,new_advance=new,confirmed=confirmed,offset=offset,settlement_cash=payout,cash=new+payout,closing=balance)) total_confirmed=sum(r['confirmed'] for r in rows);total_cash=sum(r['cash'] for r in rows) return dict(rows=rows,confirmed=total_confirmed,cash=total_cash,unsettled=balance,identity_difference=total_cash-total_confirmed-balance) def calendar(anchor,year,amount): d=date.fromisoformat(anchor);start=date(year,1,1);end=date(year,12,31) while d=total),months_80=next(r['rank'] for r in ranked if r['cumulative']*5>=total*4),top_two_share=Fraction(sum(sorted(values,reverse=True)[:2]),total),calendar_cumulative=[sum(values[:i]) for i in range(1,len(values)+1)]) def season(years): totals={y:sum(values) for y,values in years.items()};rows=[];order=sorted(years) for m in range(12): row=dict(month=m+1,amounts={y:years[y][m] for y in order},shares={y:Fraction(years[y][m],totals[y]) if totals[y] else None for y in order},yoy={}) for prev,curr in zip(order,order[1:]): base=years[prev][m];row['yoy'][prev+'_'+curr]=Fraction(years[curr][m]-base,base) if base else None rows.append(row) return dict(totals=totals,rows=rows) def trend(values): n=len(values);ts=list(range(1,n+1));tbar=Fraction(sum(ts),n);mean=Fraction(sum(values),n) sxx=sum((t-tbar)**2 for t in ts);sxy=sum((t-tbar)*(y-mean) for t,y in zip(ts,values)) slope=sxy/sxx;intercept=mean-slope*tbar;rows=[] for t,y in zip(ts,values): fitted=intercept+slope*t;residual=y-fitted rows.append(dict(t=t,y=y,t_centered=t-tbar,y_centered=y-mean,cross=(t-tbar)*(y-mean),fit=fitted,residual=residual,residual_square=residual**2)) total_ss=sum((y-mean)**2 for y in values);trend_ss=sum((r['fit']-mean)**2 for r in rows);residual_ss=sum(r['residual_square'] for r in rows) return dict(n=n,mean=mean,t_mean=tbar,sxx=sxx,sxy=sxy,slope=slope,intercept=intercept,rows=rows,total_ss=total_ss,trend_ss=trend_ss,residual_ss=residual_ss,population_variance=total_ss/n,population_sd=sqrt(total_ss/n),identity_difference=total_ss-trend_ss-residual_ss,residual_sum=sum(r['residual'] for r in rows)) def sources(amounts,groups): if any(x<0 for x in amounts):raise ValueError('本份额模型不接受负收入,应先处理退款口径') total=sum(amounts) def summarize(labels,values): rows=[dict(source=label,amount=value,share=Fraction(value,total) if total else None,square=Fraction(value,total)**2 if total else None) for label,value in zip(labels,values)] hhi=sum(r['square'] for r in rows) if total else None return dict(rows=rows,count=sum(x>0 for x in values),hhi=hhi,effective=1/hhi if hhi else None) grouped={} for a,g in zip(amounts,groups):grouped[g]=grouped.get(g,0)+a return dict(total=total,payers=summarize([f'P{i+1}' for i in range(len(amounts))],amounts),grouped=summarize(list(grouped),list(grouped.values()))) def lag(events,cutoff): rows=[];received=[];censored=[] for key,delivered,confirmed,paid,amount in events: d=date.fromisoformat(delivered);c=date.fromisoformat(confirmed);end=date.fromisoformat(cutoff) if not d<=c<=end:raise ValueError('交付、确认与观察截点顺序不合法') observed=bool(paid and paid<=cutoff) if observed and date.fromisoformat(paid)