# only average those with rates > 0 { if (NR==1) {sum=0; first=0; one = 0; count = 0; mark=0} if (NF==2) { if (first==1) { if ($1==one) # if ($1==one && $2>0) # Do we only want to count those with non-zero pprs? { sum = sum+$2; count = count+1 } if ($1 != one) { if (count > 0) {print one, sum/count} one = $1; count = 1; sum = $2 } } if (first==0) { first=1; one = $1; sum = $2; count = 1 } } } END { if (count > 0) {print one, sum/count} }