awk 分组统计数据

cat ip2.txt  | sort -k 1 | awk -F " " '{print $1"\t"$3}'| awk '{a[$1 "\t" $2]++}END{for(i in a)print i,"\t",a[i]}' | awk '{sum+=$3} {print($1, $2, $3, sum)}' | sort -k 4 -n -r | awk 'BEGIN{t=0}{t++;if(t==1)sum=$4} {printf "%s\t%10s\t\t%5d\t\t%.2f\%\n",$1,$2, $3, $3*100/sum; }'

 

 

 

 

四川省  telecom(电信)              12           6.86%

江苏省  cmcc(移动)                  1           0.57%

吉林省  unicom(联通)                2           1.14%

国内未知  unicom(联通)              1           0.57%

贵州省  telecom(电信)               2           1.14%

吉林省  telecom(电信)               1           0.57%

福建省  telecom(电信)               4           2.29%

 

北京市  unicom(联通)               14           8.00%