- 论坛徽章:
- 28
|
本帖最后由 moperyblue 于 2017-01-05 09:55 编辑
回复 5# DDkalin
more file
- tom 2013-04 A 1
- tom 2013-04 A 2
- tom 2013-04 S 3
- tom 2014-04 D 2
- tom 2016-04 F 3
- jack 2013-04 S 1
- jack 2013-06 A 1
- jack 2015-04 Z 2
- jack 2013-11 S 2
- jack 2011-09 X 3
- jine 2012-12 D 2
- jine 2012-12 W 1
- jine 2012-12 A 3
- jine 2012-12 D 3
- ming 2016-11 A 2
复制代码
- awk 'BEGIN{print "name count_1 count_2 count_3"}{a[$1,$NF]++;if(!b[$1]++){d[++c]=$1}}END{while(i++<c){printf d[i] FS;for(j=0;j++<3;)printf (a[d[i],j]?a[d[i],j]:0) (j<3?FS:RS)}}' file|column -t
复制代码
#如果name不需按先后顺序
- awk 'BEGIN{print "name count_1 count_2 count_3"}{a[$1,$NF]++;b[$1]}END{for(i in b){printf i FS;for(j=0;j++<3;)printf (a[i,j]?a[i,j]:0) (j<3?FS:RS)}}' file|column -t
复制代码 |
|