Shell Programming and Scripting

NM_0    1.22    CR5    0.366  n_21663  0.4  n_1664  0.1  n_21665  0.64
NM_11    1.36    AK09   0.44  n_19168  0.9 n_19169 -0.02

awk '{
    ind=sprintf("%s %s %s",$1,$2,$3)
    t[ind]+=$4
    n[ind]++
    s[ind]=s[ind] " " $5 " " $4
}
END{
    for(i in t) printf "%s %.3f %s\n",i,t[i]/n[i],s[i]
}' file

awk '{
    # create an index composed by the concatanation of fields 1 to 3
    ind=sprintf("%s %s %s",$1,$2,$3)

    # array that compute the total for every line having the same $1,$2,$3
    t[ind]+=$4

    # this one counts the number of lines processed for every line having the same $1,$2,$3
    n[ind]++

    # here we concatenate the fields 5 and 4 for every line having the same $1,$2,$3
    s[ind]=s[ind] " " $5 " " $4

    # alternative to get rid of the extra space
    s[ind]=sprintf("%s%s%s %s", s[ind], s[ind]?" ":"", $5, $4)
}

# when all lines have been processed, we traverse the respective arrays and compute the average
END{
    for(i in t) printf "%s %.3f %s\n",i,t[i]/n[i],s[i]
}'

awk '{
key=sprintf("%s %s %s",$1,$2,$3)
arr[key]+=$4
brr[key]++
crr[key]=sprintf("%s %s",crr[key],$5)
}
END{
for (i in arr)
 print i" "arr[i]/brr[i]" "crr[i]
}'