按列汇总

liujunhzau524

20150501 10
20150502  15
20150501  20
如何将以上文件内容按照日期汇总如下
20150501  30
20150502  15

stupid_lee

1. awk '{a[$1]+=$2}END{for(i in a)print i,a[i]}'

复制代码

reyleon

1. awk '{if(!a[$1]++)b[++n]=$1}{m[$1]+=$2}END{for(i=1;i<=n;i++)print b[i],m[b[i]]}' file

复制代码

stupid_lee

reyleon 发表于 2015-05-12 17:21

看了好半天，原来6哥这个按顺序打印
新思路get

jcdiy0601

1. awk '{a[$1]+=$2}END{for(i in a)print i,a[i]}' 1

复制代码

fh21_xuejinlian

awk '{a[$1]+=$2}END{for(i in a)print i,a[i]}' file

moperyblue

1. awk '!a[$1]{b[++c]=$1}{a[$1]+=$2}END{for(;i++<c;)print b[i],a[b[i]]}'

复制代码