Search Results

Ok, so I tried this
awk '
{arr[$1] += $3
count[$1] ++
}
END {for (a in arr) {print "id avg “ a " = " arr[a] / count[a]
}
}
'...

The first two column values are lat/long values. They are for specific locations, so considering the first column as an id is fine, I think.

I am using UNIX on a mac (not sure if that's what you...

So I have a large amount of comma delimited data that looks like this:

30.498001,-87.881412,0.024958
30.498001,-87.881412,0.035684
30.498001,-87.881412,,0.026
34.758781,-87.650562,0.034292...