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