算平均值

秋天的絮儿 发表于 2013-01-05 06:25

大家好

有如下一个rate.log文件，如何运用shell算出其Rate一栏的平均值啊？

Lot No Date Rate
====== ==== ====
WLB6840H-2 2012-12-29 98.48%
WLB6537HN-TB 2012-12-29 98.59%
WLB6938B-BC 2012-12-28 98.74%
WLB6939H-3 2013-01-03 98.36%
WLB6829H-TB3 2013-01-03 97.65%
WLB6352H-TB 2013-01-03 98.10%
WLB7087H-1 2013-01-03 98.34%
WLB6842H-BC 2012-12-29 98.23%
WLB6308H-1 2012-12-28 98.75%
WLB6225H-3 2012-12-29 97.61%
WLB6727HN 2012-12-28 98.15%
WLB6824G-1 2012-12-28 98.15%
WLB6379H-1 2012-12-29 97.75%
WLB6471H-2 2012-12-28 98.29%
WKF5737AH-2 2012-12-28 99.19%
WLB6442H-2 2012-12-29 98.62%
WLB6820-TB3 2012-12-28 98.79%
WLB6979H-2 2012-12-29 97.05%
WLB6920H-TB 2012-12-28 98.22%
WLB5144-3 2012-12-29 97.41%
WLB6671 2012-12-29 97.41%
WLB6225H-TB2 2012-12-29 97.59%
WLB6763H-BCC 2012-12-28 98.21%
WLB6548H-1 2012-12-29 97.58%
WLB6507H-3 2012-12-29 98.52%
WLB5242H-2 2012-12-28 95.86%
WKBGP68H-TBW 2013-01-04 97.37%
WLB7144H-TB2 2013-01-03 98.29%
WKBGP71H-4 2013-01-03 98.66%

crazyhadoop 发表于 2013-01-05 08:34

cat rate.log |awk '{sum+= $3} END {print "sum= ",sum/NR}'

udevu 发表于 2013-01-05 14:47

awk '{if(NR>2)sum+= $3} END {print "avg = ",sum/(NR-2)}' rate.log

秋天的絮儿 发表于 2013-01-05 20:42

回复 2# crazyhadoop

你好，感谢你。
可以算出了。谢谢

页: [1]

Chinaunix's Archiver

算平均值