对文本分组求平均,最大,计数
awk '{max[$2]=max[$2]>$1?max[$2]:$1;number[$2]++;sum[$2]+=$1} END{for (i in max) print max[i], sum[i]/number[i],number[i],i}' OFS="\t" $1
对文本分组求平均,最大,计数
awk '{max[$2]=max[$2]>$1?max[$2]:$1;number[$2]++;sum[$2]+=$1} END{for (i in max) print max[i], sum[i]/number[i],number[i],i}' OFS="\t" $1