awk应用示例

求文件中某一列的平均数

----------------------------------

awk 'BEGIN{sum=0.0;num=0}{sum+=$1;cnt++}END{printf "avg:%.2f",sum/cnt}' data.txt

if;else if

-----------

zcat access.log.201709260800.gz | awk -F'"`"' 'BEGIN{total=0;orig=0;mem=0;ssd=0;sata=0}{if($18==-1)orig++;else if($18==1)mem++;else if($18==2)ssd++;else if($18==3)sata++;total++}END{printf "hit:%.2f,mem:%.2f,ssd:%.2f,sata:%.2f\n",(total-orig)/total,mem/total,ssd/total,sata/total}'    
hit:0.94,mem:0.23,ssd:0.14,sata:0.50

while read t;do echo -n $t",";zcat access.log.$t.gz | awk -F'"`"' 'BEGIN{total=0;orig=0;mem=0;ssd=0;sata=0}{if($18==-1)orig++;else if($18==1)mem++;else if($18==2)ssd++;else if($18==3)sata++;total++}END{printf "hit:%.2f,mem:%.2f,ssd:%.2f,sata:%.2f\n",(total-orig)/total,mem/total,ssd/total,sata/total}' ;done< d