need an AWK code: put in parallel & average them

Hi,

I have a data as follow:

1, 1.0 4.00
1, 2.0 4.00
1, 3.0 4.43
1, 4.0 4.40
1, 5.0 4.48
2, 1.0 0.00
2, 2.0 4.40
2, 3.0 3.40
2, 4.0 4.40
2, 5.0 1.47
3, 1.0 1.00
3, 2.0 3.40
3, 3.0 2.40
3, 4.0 2.40
3, 5.0 2.40

I want to print out in parallel:

1.0 4.00 0.00 1.00
2.0 4.00 4.40 3.40
3.0 4.43 3.40 2.40
4.0 4.40 4.40 2.40
5.0 4.48 1.47 2.40

Then, average each line (desired output):

1.0 1.66
2.0 3.93
3.0 3.41
4.0 3.73
5.0 2.78

Please, let me know how to write an AWK code to do above job.

Thanks

Try:

awk  '{ arr[$2]=arr[$2]" "$3; } END {
for (i in arr) {
print i" "arr >>"Parallel_out";
split(arr,ar);
printf "%s %.2f\n",i,(ar[1]+ar[2]+ar[3])/3 >>"avg_out";
}}'  < file

Output:

cat avg_out

cat Parallel_out