#!/usr/bin/env python3 """Read the supplied CSV and compare explicit unknown-classification scenarios. No network, market query or inferred actual contract classification. """ import argparse,csv,json from decimal import Decimal,ROUND_HALF_UP from fractions import Fraction from pathlib import Path def read_rows(path): rows=[];ids=set() with path.open(newline='',encoding='utf-8-sig') as f: reader=csv.DictReader(f) if reader.fieldnames!=['id','kind','monthly']:raise ValueError('CSV columns must be id,kind,monthly') for r in reader: if not r['id'] or r['id'] in ids:raise ValueError('Nonempty unique id required') ids.add(r['id']);kind=r['kind'].strip() if kind not in ('new','renewed',''):raise ValueError('kind must be new, renewed or empty') raw=Decimal(r['monthly']) if not raw.is_finite() or raw<0:raise ValueError('monthly must be a finite nonnegative amount') rows.append({'id':r['id'],'kind':kind or None,'monthly':str(raw)}) if not rows:raise ValueError('Empty CSV') return rows def summary(rows): values=[Fraction(r['monthly']) for r in rows];total=sum(values,Fraction(0)) mean=total/len(values) if values else None def rounded(x):return str((Decimal(x.numerator)/Decimal(x.denominator)).quantize(Decimal('.01'),rounding=ROUND_HALF_UP)) if x is not None else None return {'count':len(values),'sum_exact':str(total),'mean_exact':str(mean) if mean is not None else None,'mean_rounded':rounded(mean)} def calculate(rows): scenarios=[] for assignment in (None,'new','renewed'): groups={k:[] for k in ['new','renewed','unknown']} for r in rows:groups[r['kind'] or assignment or 'unknown'].append(r) values={k:summary(v) for k,v in groups.items()} if sum(v['count'] for v in values.values())!=len(rows):raise ValueError('Row count lost') scenarios.append({'unknown_assignment':assignment,'groups':values}) return {'kind':'synthetic lease CSV classification sensitivity; not observed market data','rows_read':rows,'overall':summary(rows),'scenarios':scenarios,'limits':'Only group assignment changes. Blank kind is unknown, not zero monthly rent. These scenarios do not infer actual contract types or bound the housing market.'} if __name__=='__main__': p=argparse.ArgumentParser();p.add_argument('--input',type=Path,required=True);p.add_argument('--output',type=Path,required=True);a=p.parse_args() result=calculate(read_rows(a.input)) with a.output.open('x',encoding='utf-8') as f:json.dump(result,f,ensure_ascii=False,indent=2);f.write('\n')