Calculate average for repeated ID within a data

Shell Programming and Scripting
1

I have an awk script that gives the following output:

Average end-to-end transmission delay 2.7 to 5.7 is 0.635392 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 0.66272 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 0.691712 seconds
Average end-to-end transmission delay 2.6 to 5.6 is 0.716631 seconds
Average end-to-end transmission delay 2.8 to 5.8 is 0.740759 seconds
Average end-to-end transmission delay 2.9 to 5.9 is 0.764887 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 0.792215 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 0.821207 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 0.850199 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 0.880855 seconds
Average end-to-end transmission delay 2.4 to 5.4 is 0.910199 seconds
Average end-to-end transmission delay 2.4 to 5.4 is 0.941207 seconds
Average end-to-end transmission delay 2.7 to 5.7 is 0.966617 seconds
Average end-to-end transmission delay 2.0 to 5.0 is 0.990745 seconds
Average end-to-end transmission delay 2.8 to 5.8 is 1.01487 seconds
Average end-to-end transmission delay 2.5 to 5.5 is 1.0422 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.09852 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.12751 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.15817 seconds
Average end-to-end transmission delay 2.6 to 5.6 is 1.19043 seconds
Average end-to-end transmission delay 2.6 to 5.6 is 1.22435 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 1.25167 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 1.28067 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 1.30966 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 1.34031 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 1.37097 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 1.40329 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 1.43561 seconds
Average end-to-end transmission delay 2.3 to 6.3 is 3.8106 seconds
Average end-to-end transmission delay 2.7 to 6.7 is 3.83473 seconds
Average end-to-end transmission delay 2.4 to 6.4 is 3.85886 seconds
Average end-to-end transmission delay 2.8 to 6.8 is 3.88299 seconds
Average end-to-end transmission delay 2.9 to 6.9 is 3.90712 seconds
Average end-to-end transmission delay 2.5 to 6.5 is 3.93124 seconds
Average end-to-end transmission delay 2.6 to 6.6 is 3.95537 seconds
Average end-to-end transmission delay 2.7 to 6.7 is 3.9795 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.00683 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.03582 seconds
Average end-to-end transmission delay 2.8 to 6.8 is 4.05995 seconds
Average end-to-end transmission delay 2.1 to 6.1 is 4.08728 seconds
Average end-to-end transmission delay 2.1 to 6.1 is 4.11627 seconds
Average end-to-end transmission delay 2.2 to 6.2 is 4.1451 seconds
Average end-to-end transmission delay 2.2 to 6.2 is 4.1756 seconds
Average end-to-end transmission delay 2.9 to 6.9 is 4.20469 seconds
Average end-to-end transmission delay 2.3 to 6.3 is 4.23222 seconds
Average end-to-end transmission delay 2.3 to 6.3 is 4.26141 seconds
Average end-to-end transmission delay 2.4 to 6.4 is 4.28874 seconds
Average end-to-end transmission delay 2.4 to 6.4 is 4.31773 seconds
Average end-to-end transmission delay 2.5 to 6.5 is 4.34506 seconds
Average end-to-end transmission delay 2.5 to 6.5 is 4.37405 seconds
Average end-to-end transmission delay 2.6 to 6.6 is 4.40288 seconds
Average end-to-end transmission delay 2.6 to 6.6 is 4.43337 seconds
Average end-to-end transmission delay 2.7 to 6.7 is 4.46386 seconds
Average end-to-end transmission delay 2.7 to 6.7 is 4.49602 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.52335 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.55234 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.58133 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.61199 seconds

The time is calculated from (i.e. 2.X ) to (y.z ) where x,y,z could be any number. I have a cases where the same 2.x to the same y.z is repeated with different time value. I need to calculate average time . for example from the above sample we have :

Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.09852 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.12751 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.15817 seconds

I want the output to be instead :
Average end-to-end transmission delay 2.1 to 5.1 is 1.113433 seconds which is (1.06953+1.09852 +1.12751 +1.15817 )/4.

I want to do that for all of other values.

2

try

$ awk '{A[$5,$7]+=$9;B[$5,$7]++}END{for(i in B){split(i,P,SUBSEP);print "Average end-to-end transmission delay "P[1],"to",P[2],"is",A/B,"seconds"}}' file

Average end-to-end transmission delay 2.7 to 6.7 is 4.19353 seconds
Average end-to-end transmission delay 2.6 to 5.6 is 1.0438 seconds
Average end-to-end transmission delay 2.6 to 6.6 is 4.26387 seconds
Average end-to-end transmission delay 2.5 to 5.5 is 1.0422 seconds
Average end-to-end transmission delay 2.5 to 6.5 is 4.21678 seconds
Average end-to-end transmission delay 2.4 to 5.4 is 0.925703 seconds
Average end-to-end transmission delay 2.4 to 6.4 is 4.15511 seconds
Average end-to-end transmission delay 2.3 to 5.3 is 1.18818 seconds
Average end-to-end transmission delay 2.3 to 6.3 is 4.10141 seconds
Average end-to-end transmission delay 2.2 to 5.2 is 1.13262 seconds
Average end-to-end transmission delay 2.2 to 6.2 is 4.16035 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 0.968027 seconds
Average end-to-end transmission delay 2.1 to 6.1 is 4.10177 seconds
Average end-to-end transmission delay 2.0 to 5.0 is 0.990745 seconds
Average end-to-end transmission delay 2.0 to 6.0 is 4.38528 seconds
Average end-to-end transmission delay 2.9 to 5.9 is 0.764887 seconds
Average end-to-end transmission delay 2.9 to 6.9 is 4.05591 seconds
Average end-to-end transmission delay 2.8 to 5.8 is 0.877814 seconds
Average end-to-end transmission delay 2.8 to 6.8 is 3.97147 seconds
Average end-to-end transmission delay 2.7 to 5.7 is 0.801004 seconds
3

Yes it works. Thank you ...

One last modifications..How about if I want to calculate the first hit. for example instead of calculating the average, I want to filtered out the repeated occurrences. For example;

Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.09852 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.12751 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.15817 seconds

The output would be only the first hit;

Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds

and ignore the rest repeated occurrences.

4

In that case try:

awk '!A[$5,$7]++' file
5

Thanks .. It works