- 论坛徽章:
- 32
|
本帖最后由 yestreenstars 于 2012-12-20 17:28 编辑
- awk '{for(i=3;i<=NF;i++){a[$2,i]+=$i}b[$2]++}END{for(i in b){printf "%-2s",i;for(j=3;j<=NF;j++)printf "%-5.2f",a[i,j]/b[i];print ""}}'
复制代码- [root@localhost ~]# cat i
- 12 a 4 5 6 7
- 13 a 8 5 7 9
- 14 a 4 2 9 6
- 15 b 7 9 5 6
- 16 b 2 3 4 6
- 17 c 1 2 6 6
- [root@localhost ~]# awk '{for(i=3;i<=NF;i++){a[$2,i]+=$i}b[$2]++}END{for(i in b){printf "%-2s",i;for(j=3;j<=NF;j++)printf "%-5.2f",a[i,j]/b[i];print ""}}' i
- a 5.33 4.00 7.33 7.33
- b 4.50 6.00 4.50 6.00
- c 1.00 2.00 6.00 6.00
- [root@localhost ~]#
复制代码 |
|