set -euo pipefail
export LC_ALL=C
cd project
awk -F '\t' 'NR>1 && $4=="valid" && $3!="NA" {s[$2]+=$3; n[$2]++} END {split("A B",g," "); for(i=1;i<=2;i++) printf "%s: %.0f / %d = %.2f\n",g[i],s[g[i]],n[g[i]],s[g[i]]/n[g[i]]}' data/measurements.tsv