#!/usr/bin/env python3 """Read the published saved CSV; no network access or output-file writes.""" import csv,json,sys from decimal import Decimal from statistics import median from collections import defaultdict def summarize(path): groups=defaultdict(list);saved=defaultdict(set) with open(path,encoding='utf-8-sig',newline='') as f: for row in csv.DictReader(f): if row['집계포함']!='포함':continue m=row['계약월'];groups[m].append(Decimal(row['금액(만원)'].replace(',','')));saved[m].add(row['자료저장시각(KST)']) result=[] for m,values in sorted(groups.items()): v=sorted(values);n=len(v);mid=median(v);indices=[(n+1)//2] if n%2 else [n//2,n//2+1] result.append(dict(month=m,saved_at_kst=sorted(saved[m]),count=n,sum_manwon=str(sum(v)),mean_manwon=str(sum(v)/n),median_manwon=str(mid),min_manwon=str(v[0]),max_manwon=str(v[-1]),middle_positions_one_based=indices,middle_values_manwon=[str(v[i-1]) for i in indices],median_is_observed=mid in v)) return dict(method='Sorted amounts; even median is mean of two middle values; Decimal arithmetic.',input_rows=sum(len(v) for v in groups.values()),groups=result,limits='Saved sample, not current prices or a matched-property index.') if __name__=='__main__':print(json.dumps(summarize(sys.argv[1]),ensure_ascii=False,indent=2))