Hi, Our in-house AS400 based application produce a timer file as follows:
TranName,Date Time, TimeA,A+B, TimeB MAC00029,20061027 112500.030,703,703,0 MAC00029,20061027 112500.342,703,719,16 MAC00056,20061027 112500.920,484,500,16 MAC00029,20061027 112501.186,812,812,0 MAC00029,20061027 112502.092,672,672,0 MAC00029,20061027 112502.264,687,687,0 MAC00056,20061027 112503.264,453,453,0 MAC00029,20061027 112502.920,1000,1000,0 MAC00029,20061027 112502.967,937,953,16 MAC00062,20061027 112503.592,515,515,0 MAC00054,20061027 112503.873,1047,1078,31 MAC00029,20061027 112503.857,1094,1110,16 MAC00029,20061027 112504.029,1094,1094,0 MAC00029,20061027 112504.029,1297,1313,16 MAC00029,20061027 112504.373,969,969,0 MAC00056,20061027 112505.373,453,453,0 MAC00029,20061027 112504.670,1219,1219,0 MAC00029,20061027 112505.061,968,968,0 MAC00029,20061027 112504.873,1297,1312,15 MAC00029,20061027 112505.029,1141,1156,15 MAC00029,20061027 112505.342,843,843,0 MAC00029,20061027 112505.560,844,844,0 MAC00029,20061027 112505.701,891,891,0 MAC00029,20061027 112505.623,969,969,0 MAC00029,20061027 112506.076,1016,1016,0 MAC00029,20061027 112506.185,907,907,0 MAC00056,20061027 112506.404,844,859,15 MAC00029,20061027 112506.232,1110,1125,15 MAC00029,20061027 112506.310,1032,1047,15 MAC00029,20061027 112506.701,703,703,0 MAC00029,20061027 112506.107,1391,1391,0 MAC00029,20061027 112506.264,1234,1234,0 MAC00029,20061027 112506.514,984,984,0 MAC00056,20061027 112506.904,750,766,16 MAC00045,20061027 112507.420,359,359,0 MAC00029,20061027 112506.810,1032,1032,0 MAC00029,20061027 112507.154,688,688,0 How do I user R to sort out by Transaction name, then average the TimeA and TimeB over 30 seconds interval? I have just started to lear R, but this task seems to be hard to me, so I would like to know if this is possible at all. Thanks a lot for your help. ____________________________________________________________________________________ Sponsored Link Degrees online in as fast as 1 Yr - MBA, Bachelor's, Master's, Associate Click now to apply http://yahoo.degrees.info ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.