UNIX for Dummies Questions & Answers

Hi,
I am searching for an awk-script that computes the mean values for the $2 column, but addicted to the values in the $1 column. It also should delete the unnecessary lines after computing...


An example (for some reason I cant use the code tag button):

cat list.txt

Code:

1  10
1  30
1  20
2  25
2  20
2  30

cat resultlist.txt

Code:

1 20
2 25

Many thanks in advance!

Björn

Try:

Code:

awk '{s[$1]+=$2;n[$1]++}END{for (i in s) print i,s[i]/n[i]}' list.txt

Thanks a lot bartus11!