"""Retrospective baseline comparison, NOT a new solar discovery or real-time backtest.
Source: WDC-SILSO, Royal Observatory of Belgium, Brussels, version 2.0.
Annual data: https://www.sidc.be/SILSO/DATA/SN_y_tot_V2.0.txt
Data license: CC BY-NC 4.0. See https://www.sidc.be/SILSO/datafiles
Uses cached snapshot if available. Do not select dates/models based on outcomes.
This demonstration chose its interval retrospectively, before computing its result.
"""
import pathlib,urllib.request,hashlib,json,csv,math,statistics
p=pathlib.Path(__file__).parent
source=p/'yearly_source.txt'
if not source.exists():
 source.write_bytes(urllib.request.urlopen('https://www.sidc.be/SILSO/DATA/SN_y_tot_V2.0.txt').read())
raw=source.read_bytes()
a={int(float(row[0])):float(row[1]) for row in (line.split() for line in raw.decode().splitlines())}
rows=[dict(year=y,actual=a[y],lag11=a[y-11],lastyear=a[y-1]) for y in range(2000,2025)]
assert len(rows)==25 and all(r['actual']>=0 for r in rows)
metrics={}
for k in ['lag11','lastyear']:
 errors=[r[k]-r['actual'] for r in rows]
 metrics[k]={'MAE':sum(map(abs,errors))/25,'RMSE':math.sqrt(sum(e*e for e in errors)/25)}
metrics['wins_lag11']=sum(abs(r['lag11']-r['actual'])<abs(r['lastyear']-r['actual']) for r in rows)
metrics['n']=25
metrics['source']='https://www.sidc.be/SILSO/DATA/SN_y_tot_V2.0.txt'
metrics['source_sha256']=hashlib.sha256(raw).hexdigest()
metrics['MAE_relative_increase']=metrics['lag11']['MAE']/metrics['lastyear']['MAE']-1
with (p/'yearly_results.csv').open('w') as f:
 w=csv.DictWriter(f,fieldnames=rows[0].keys());w.writeheader();w.writerows(rows)
(p/'yearly_results.json').write_text(json.dumps(metrics,indent=2))
print(json.dumps(metrics,indent=2))
