[SOLVED] read the file, add number and get the average

Alkass · 04-29-2010, 05:51 PM

Hi

I have a file which has several entries with

# comment 1

1245

# comment 2

5667

# comment 3

456456

how can I read the file, sum the numbers ( "avoid" the #lines) and then get the average of the numbers?

I do

awk '{s+=$0} END {print s}' /tmp/file.txt

and this give me the sum correctly, but how can I get also the average ?

Thanks in advance!

pixellany · 04-29-2010, 06:03 PM

If you first strip off everything but the numbers, then I think you can let AWK report the total number of lines.

Then just divide the total by the number of lines.

PTrenholme · 04-29-2010, 06:31 PM

Try

Code:

awk '/^(#|$)/{next;}{++c;s+=$1} END {printf ("%d records: ",c);c=(c>0?c:1);print "sum: " s ", average: " s/c}' ' /tmp/file.txt

Alkass · 04-29-2010, 06:52 PM

Quote:

Originally Posted by PTrenholme

Try

Code:

awk '/^(#|$)/{next;}{++c;s+=$1} END {printf ("%d records: ",c);c=(c>0?c:1);print "sum: " s ", average: " s/c}' ' /tmp/file.txt

thanks!

grail · 04-30-2010, 12:14 AM

Please mark as SOLVED as you have your solution.