Perform Satistical Operations on Columns in CSV Files
by lokety on Mar.07, 2007, under Posts
This is a simple but powerful way to process files in Unix, using the humble program awk.
To calculate sum or average of a numerical column of a comma separated file, create a text file like so:
{ s += $3 }
END { printf “sum = %.2f, avg = %.2f, hits = %d\n”, s, s/NR, NR }
Use your creative juices to save it with a meaningful name, say, test.awk.
Call awk with this file, like so:
You should see the sum, average and number of lines processed. In this example, it is assumed that the values in each line are separated by commas, and the numerical column is the third one.
For more information on awk, RTFM or Google it.
Technorati Tags: programming, unix, awk, comma separated values, csv, sum, average, statistical
Related posts:
- Print Unix File Timestamp Accurate Down to Seconds
- Print Yesterday’s Date Using Perl
- Over-Generous Taxpayers or Defective Calculators?
Buy Stock Images
iStockphoto.com - Newest Uploads
The world's fastest growing royalty-free stock photography collection
Tree bark and root details Monday, 4 January 2010, 6:20 am
Dry and worn details of a tree bark and rootSource:
iStockphoto.com - Newest Uploads | lokety
Big American Breakfast Sunday, 3 January 2010, 8:25 pm
A large serving of breakfast including steak, bacon, sausages, fries, eggs, tomatoes and toast.Source:
Loading ...
