"""Reproduce AMR nickel statistics from the extracted public CSV bundle.""" import csv import json from decimal import Decimal from pathlib import Path HERE = Path(__file__).resolve().parent DATA = HERE / 'data' if (HERE / 'data').is_dir() else HERE def rows(dataset): with (DATA / f'nickel-{dataset}.csv').open(newline='') as handle: return list(csv.reader(handle))[1:] def pct(numerator, denominator): return f'{Decimal(numerator)/Decimal(denominator)*100:.4f}' def verify_mine_tables(): mine = rows('world-mine-production') world = int(mine[-1][2]) assert mine[-1][0] == 'World total (rounded)' for _, prior, current, change, share in mine: assert pct(int(current)-int(prior),prior)==change assert pct(current,world)==share for _, older, revised, delta, revision in rows('2024-estimate-revisions'): assert int(revised)-int(older)==int(delta) assert pct(delta,older)==revision indonesia = next(r for r in mine if r[0]=='Indonesia') return indonesia[-1] def verify_stage_tables(): stages={} for stage in ('mine','refining'): published = rows('iea-'+stage+'-supply') stages[stage] = {r[0]:list(map(int,r[1:])) for r in published} shares = rows('indonesia-stage-shares') for i,(_, mining, world_mining, mine_share, refining, world_refining, refining_share) in enumerate(shares): numbers=(int(mining),int(world_mining),int(refining),int(world_refining)) assert numbers==(stages['mine']['Indonesia'][i],stages['mine']['World'][i],stages['refining']['Indonesia'][i],stages['refining']['World'][i]) assert pct(mining,world_mining)==mine_share assert pct(refining,world_refining)==refining_share increase={} for stage, w0, w1, dw, i0, i1, di, other, contribution in rows('indonesia-contribution-to-growth'): w0,w1,dw,i0,i1,di,other=map(int,(w0,w1,dw,i0,i1,di,other)) source=stages['mine' if stage=='Mining' else 'refining'] assert [w0,w1]==source['World'][:2] and [i0,i1]==source['Indonesia'][:2] assert dw==w1-w0 and di==i1-i0 and other==dw-di and pct(di,dw)==contribution increase[stage]=contribution return shares[1][3],shares[1][6],increase def main(): mine_usgs=verify_mine_tables() mining, refining, growth=verify_stage_tables() demand=next(r for r in rows('iea-demand-by-use-and-scenario') if r[0]=='2025 history') clean=pct(demand[1],demand[6]) ev=pct(demand[2],demand[6]) assert round(Decimal(clean)) == int(demand[-1]) assert (mine_usgs,mining,refining,growth['Mining'],growth['Refining'],clean)==('66.6667','62.6812','45.0791','106.6110','75.8824','17.6954') print(json.dumps({'USGS_indonesia_2025_mining_share_percent':mine_usgs,'IEA_indonesia_2025_mining_share_percent':mining, 'IEA_indonesia_2025_refining_share_percent':refining,'IEA_indonesia_2021_to_2025_net_growth_percent':growth, 'IEA_2025_clean_energy_demand_percent':clean,'IEA_2025_electric_vehicle_demand_percent':ev})) if __name__=='__main__': main()