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