#!/usr/bin/env python3
"""Case C2 - Simple physiology trend audit.
Use this as a starting point; do not treat a threshold as a diagnosis.
"""
import csv
from pathlib import Path
HERE=Path(__file__).resolve().parent
rows=[]
with open(HERE/'10_CREW_HEALTH_TREND_C2.csv',encoding='utf-8-sig') as f:
    rows=list(csv.DictReader(f))
by={}
for r in rows: by.setdefault(r['crew'],[]).append(r)
for crew,rs in by.items():
    rs=sorted(rs,key=lambda x:int(x['mission_day']))
    m0=float(rs[0]['body_mass_kg']); m1=float(rs[-1]['body_mass_kg'])
    k=min(float(x['potassium_mmol_L']) for x in rs)
    mg=min(float(x['magnesium_mmol_L']) for x in rs)
    pct=(m1-m0)/m0*100
    print(f'{crew:10s} mass change={pct:6.1f}%   min K={k:.2f}   min Mg={mg:.2f}')