mコマンドで集計の練習

hit_ranking.bash

#!/bin/bash
## hit ranking
cat ./batting_data.csv | 
mcut f=BAT_ID,H_FL,AB_FL | 
mselstr f=AB_FL v=T | 
mchgstr f=AB_FL c=T:1 | 
mcal c='if(${H_FL}>0, 1, 0)' a=HIT_FL |
mcut f=BAT_ID,HIT_FL,AB_FL |
msum k=BAT_ID f=HIT_FL:HIT,AB_FL:ATBAT | 
mselnum f=ATBAT c='[1,]' |
mcal c='${HIT}/${ATBAT}' a=AVG | 
mselnum f=ATBAT c='[4000,]' | 
msortf f=AVG%nr