- 论坛徽章:
- 1
|
awk 'BEGIN {s=1420041600;}{user[$1]++;arr[$1,$2]=1} END{ while (s<=1451491200) {now=strftime("%Y%m%d",s);s+=86400;for (i in user) {if(arr[i,now] !=1) print i,now,"absence" }}}' yourfile
其中$1 是你的用户ID ,该统计会统计出15年所有用户的缺席日期,结果如下 :
2 20150101 absence
3 20150101 absence
2 20150102 absence
1 20150103 absence
2 20150103 absence
3 20150103 absence
1 20150104 absence
2 20150104 absence
3 20150104 absence
1 20150105 absence
2 20150105 absence
3 20150105 absence
2 20150106 absence
3 20150106 absence
1 20150107 absence
2 20150107 absence
3 20150107 absence
1 20150108 absence
2 20150108 absence
3 20150108 absence
1 20150109 absence
2 20150109 absence 。。。。。。 |
|