Apr 9, 2009

Using awk to calculate sum/average

awk is a small powerful tool for processing column oriented text data.
Suppose I have file Marks.txt whose contents are

Use the following command to calculate the sum of the entries in column 3

cat Marks.txt | awk '{sum+=$3} END {print "Total=", sum}'

To get the average, use the following command

cat Marks.txt | awk '{sum+= $3} END {print "Average=", sum/NR}'

No comments :

Post a Comment