Shell Programming and Scripting

R,6630,4918,1,2,1,2140.46,0.19,5,0.000226526,0.000159094,1800,5.9,10.9,22.7,67055157,0745                  
R,6630,4920,1,2,1,2159.54,-0.19,5,0.000208446,0.000160313,1808,4.9,10.9,28.7,67055157,0745                 
R,6630,4922,1,2,1,2129.16,0.29,5,0.000207469,0.000165304,1800,4.9,9.9,23.7,67055157,0745                   
R,6630,4924,1,2,1,2134.31,0.54,5,0.00024754,0.000167664,1792,3.0,15.8,23.7,67055157,0745                   
R,6720,5130,1,2,1,2153.83,0.62,5,0.00150284,0.000340223,-1000,4.0,5.9,10.9,67075197,0765                   
R,6720,5132,1,2,1,2118.86,0,5,0.0018297,0.00036593,-988,4.0,5.9,15.8,67075197,0765                         
R,6720,5134,1,2,1,2141.06,-0.14,5,0.00110744,0.000374551,976,3.0,5.9,16.8,67075197,0765                    
R,6720,5136,1,2,1,2139.05,0.21,5,0.00145681,0.000378479,960,4.0,5.9,14.8,67075197,0765                     
R,6720,5138,1,2,1,2119.32,0.05,5,0.0011558,0.00038862,948,4.0,5.9,15.8,67075197,0765                       
R,6720,5140,1,2,1,2146.79,0.05,5,0.000925699,0.000445295,-862,3.0,14.8,30.6,67075197,0765                  
R,6720,5240,1,2,1,2118.8,-0.13,nan,0.000251577,0.000113411,1856,7.9,8.9,21.7,65035127,1104                 
R,6720,5242,1,2,1,2104.16,-0.41,nan,0.000271981,0.000115383,-1496,4.9,9.9,17.8,65035127,1104               
R,6720,5244,1,2,1,2136.64,-0.27,nan,0.000269198,0.000118783,-1500,4.0,9.9,19.8,65035127,1104               
R,6720,5246,1,2,1,2101.84,-0.03,nan,0.000230368,0.000125439,-1504,4.0,7.9,26.7,65035127,1104               
R,6720,5248,1,2,1,2109.24,-0.03,nan,0.000206932,0.0001419,-1508,4.0,7.9,24.7,65035127,1104

R,6630,4918,1,2,1,2140.46,0.19,5,0.000226526,0.000159094,1800,5.9,10.9,22.7,67055157,0745,11.8       
R,6630,4920,1,2,1,2159.54,-0.19,5,0.000208446,0.000160313,1808,4.9,10.9,28.7,67055157,0745,11.8      
R,6630,4922,1,2,1,2129.16,0.29,5,0.000207469,0.000165304,1800,4.9,9.9,23.7,67055157,0745,11.8        
R,6630,4924,1,2,1,2134.31,0.54,5,0.00024754,0.000167664,1792,3.0,15.8,23.7,67055157,0745,11.8        
R,6720,5130,1,2,1,2153.83,0.62,5,0.00150284,0.000340223,-1000,4.0,5.9,10.9,67075197,0765,11.8        
R,6720,5132,1,2,1,2118.86,0,5,0.0018297,0.00036593,-988,4.0,5.9,15.8,67075197,0765,7.3               
R,6720,5134,1,2,1,2141.06,-0.14,5,0.00110744,0.000374551,976,3.0,5.9,16.8,67075197,0765,7.3          
R,6720,5136,1,2,1,2139.05,0.21,5,0.00145681,0.000378479,960,4.0,5.9,14.8,67075197,0765,7.3           
R,6720,5138,1,2,1,2119.32,0.05,5,0.0011558,0.00038862,948,4.0,5.9,15.8,67075197,0765,7.3             
R,6720,5140,1,2,1,2146.79,0.05,5,0.000925699,0.000445295,-862,3.0,14.8,30.6,67075197,0765,7.3        
R,6720,5240,1,2,1,2118.8,-0.13,nan,0.000251577,0.000113411,1856,7.9,8.9,21.7,65035127,1104,8.9       
R,6720,5242,1,2,1,2104.16,-0.41,nan,0.000271981,0.000115383,-1496,4.9,9.9,17.8,65035127,1104,8.9     
R,6720,5244,1,2,1,2136.64,-0.27,nan,0.000269198,0.000118783,-1500,4.0,9.9,19.8,65035127,1104,8,9     
R,6720,5246,1,2,1,2101.84,-0.03,nan,0.000230368,0.000125439,-1504,4.0,7.9,26.7,65035127,1104,8.9     
R,6720,5248,1,2,1,2109.24,-0.03,nan,0.000206932,0.0001419,-1508,4.0,7.9,24.7,65035127,1104,8.9

awk -F, '
        BEGIN {
                CONVFMT = "%.1f"
        }
        NR == FNR {
                A[$1,$2,$16] += $14
                C[$1,$2,$16]++
                next
        }
        {
                $0 = $0 FS A[$1,$2,$16] / C[$1,$2,$16]
        }
        1
' file file