nysol_SuperChance.bash

#!/bin/bash

cat ./all2013.csv | 
  mselstr f=BAT_EVENT_FL v=T | 
  mcal c='if(${OUTS_CT}<2 && $s{BASE3_RUN_ID}!="", 1, 0)' a="SUPER_CHANCE" | 
  mcal c='if(${OUTS_CT}<2 && $s{BASE3_RUN_ID}!="" && regexs($s{EVENT_TX}, "3-H"),1, 0)' \
    a="SUPER_CHANCE_SCORED" | 
  mcut f=BAT_ID,SUPER_CHANCE,SUPER_CHANCE_SCORED | 
  msum k=BAT_ID f=SUPER_CHANCE,SUPER_CHANCE_SCORED | 
  mcal c='${SUPER_CHANCE_SCORED}/${SUPER_CHANCE}' a="SUPER_CHANCE_SCORED_RATE" | 
  msel c='${SUPER_CHANCE}>10' | 
  msortf f=SUPER_CHANCE_SCORED_RATE%nr | 
  head -n 10