#!/usr/bin/env python3 """Reproduce AMR calculations using the supplied CSV inputs and Python standard library. Run from any working directory. --self-test verifies deliberate defects are rejected. If the original offered IEA CSV is present, also compare normalized input cells to it. """ from pathlib import Path from decimal import Decimal import csv,json,copy,sys,hashlib R=Path(__file__).resolve().parent D=R/'data' if (R/'data').is_dir() else R TOL=Decimal('0.000051') def read(name): with (D/name).open(newline='') as f:return list(csv.DictReader(f)) def d(x):return Decimal(str(x)) def close(a,b,tol=TOL): a,b=d(a),d(b) if not a.is_finite() or abs(a-b)>tol:raise AssertionError((str(a),str(b))) def check(data): m=data['vehicle-minerals.csv'];assert len(m)==9;names=[r['Included material category'] for r in m] assert names==['Copper','Lithium','Nickel','Manganese','Cobalt','Graphite','Zinc','Rare earths','Others'] ec='Electric car (kg per modeled vehicle)';cc='Conventional car (kg per modeled vehicle)';dif='AMR difference (kg per modeled vehicle)' ev=sum(d(r[ec]) for r in m);conv=sum(d(r[cc]) for r in m);inc=ev-conv for r in m: close(r[dif],d(r[ec])-d(r[cc]));close(r['AMR share of 173.11 kg increment (%)'],(d(r[ec])-d(r[cc]))/inc*100);close(r['AMR share of electric included-category total (%)'],d(r[ec])/ev*100) t=data['benchmark-totals.csv'];close(t[0]['AMR sum of included categories (kg per vehicle)'],ev);close(t[1]['AMR sum of included categories (kg per vehicle)'],conv) calc=data['benchmark-calculations.csv'];top=sum(d(r[dif]) for r in m if r['Included material category'] in ['Graphite','Nickel','Copper']) for row,expected in zip(calc,[ev/conv,inc,top,top/inc*100]):close(row['Result'],expected) ratios=data['mineral-ratios.csv'];defined=0 for a,b in zip(m,ratios): assert a['Included material category']==b['Included material category'];close(a[ec],b[ec]);close(a[cc],b[cc]) if d(a[cc])==0:assert b['AMR electric-to-conventional ratio']=='Not defined: zero model baseline' else:close(b['AMR electric-to-conventional ratio'],d(a[ec])/d(a[cc]));defined+=1 assert defined==4 adoption=data['chemistry-adoption.csv'];assert [(int(r['Year']),r['LFP relation'],int(r['Threshold (%)'])) for r in adoption]==[(2025,'>',50),(2025,'>',90)] assert 'registered four-wheeler' in adoption[0]['Denominator and coverage'] and 'LFMP' in adoption[0]['Denominator and coverage'] applications=data['deployment-applications.csv'];assert [(r['Relation'],int(r['Threshold (%)'])) for r in applications]==[('>',70),('>',15),('<',5)] assert [r['Source bound'] for r in data['chemistry-price-context.csv']]==['>15%','<5%','>40%'] idx=data['deployment-index.csv'];assert [int(r['Year']) for r in idx]==[2020,2025];close(idx[0]['AMR deployment index (2020 = 100)'],100);close(idx[1]['AMR deployment index (2020 = 100)'],600) classes=data['chemistry-classification.csv'];assert 'NMC622' in classes[1]['Chemistries included in the 2025 chart notes'];assert 'LFMP' in classes[2]['Chemistries included in the 2025 chart notes'] return {'included_electric_kg':str(ev),'included_conventional_kg':str(conv),'included_ratio':str(ev/conv),'increment_kg':str(inc),'graphite_nickel_copper_increment_kg':str(top),'selected_increment_share_percent':str(top/inc*100),'defined_mineral_ratios':defined,'undefined_zero_baseline_ratios':len(m)-defined,'chemistry_and_application_inequalities':'preserved','deployment_index_2025':600} files=['vehicle-minerals.csv','benchmark-totals.csv','benchmark-calculations.csv','mineral-ratios.csv','chemistry-adoption.csv','deployment-applications.csv','chemistry-price-context.csv','deployment-index.csv','chemistry-classification.csv'] data={n:read(n) for n in files};out=check(data) original=R/'iea-vehicle-source.csv' if original.exists(): raw=original.read_bytes();lines=raw.decode().splitlines();start=next(i for i,s in enumerate(lines) if s.startswith(',Copper,'));rows=list(csv.reader(lines[start:]));m=data['vehicle-minerals.csv'] for i,r in enumerate(m): assert r['Included material category']==rows[0][i+1];close(r['Electric car (kg per modeled vehicle)'],rows[1][i+1],Decimal('0'));close(r['Conventional car (kg per modeled vehicle)'],rows[2][i+1],Decimal('0')) assert raw.startswith(b'Source: IEA. Licence: CC BY 4.0') out['original_offered_csv_parity']='all18 material input cells match exactly; preamble intact';out['original_csv_sha256']=hashlib.sha256(raw).hexdigest() if '--self-test' in sys.argv: mutations=[('vehicle-minerals.csv',0,'AMR difference (kg per modeled vehicle)','53.2'),('benchmark-totals.csv',0,'AMR sum of included categories (kg per vehicle)','207'),('benchmark-calculations.csv',3,'Result','80'),('mineral-ratios.csv',1,'AMR electric-to-conventional ratio','100'),('chemistry-adoption.csv',0,'LFP relation','='),('deployment-applications.csv',2,'Relation','>'),('deployment-index.csv',1,'AMR deployment index (2020 = 100)','500')] for filename,row,col,val in mutations: bad=copy.deepcopy(data);bad[filename][row][col]=val try:check(bad) except AssertionError:continue raise AssertionError('Deliberate defect passed: '+filename+' '+col) out['deliberate_defect_tests_passed']=len(mutations) print(json.dumps(out,indent=2))