AWK(?) Help - Shell Programming and Scripting

earnstaf · #1 11-09-2007

Hi all,

I'm having trouble figuring out awk. I'm pretty sure it would be the best tool for the job here. I have a tab-delimited file called score that looks like:

Code:

john     0         1         0
sam      0         1         1
john     2         1         1
sam     0         1          0
sam     1         1          1
john     2         1          1

There could be an unlimited # of names.

The columns are $1 = name, $2 = score, $3 = games, $4 = wins. I want to add up all of $2, $3 and $4 and also divide $4 by $3 (pct of games won) to produce a $5 for each unique name and display each name as it's own line (with the math done) and under a heading of NAME SCORE GAMES WINS PCT.

I'm able to print out the unique names with:

Code:

awk '{
arr[$1] = $1}
END {
for (x in arr )
print arr[x] }' score

However, I don't think that is very scalable to more names, and I'm not sure where the math of the associated columns needs to go.

Any help would be greatly appriciated.

Franklin52 · #2 11-09-2007

Try this:

Code:

awk '
BEGIN {printf("NAME\tSCORE\tGAMES\tWINS\tPCT\n")}
{
  name[$1]=$1
  score[$1]+=$2
  games[$1]+=$3
  wins[$1]+=$4
}
END{for(i in name){printf("%s\t%s\t%s\t%s\t%f\n", name[i], score[i], games[i], wins[i], wins[i]/games[i])}}
' file

Regards

earnstaf · #3 11-09-2007

Works like a charm... thank you... this taught me a lot about arrays, despite being for a dumb little shell script game

I really appreciate your help.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode