Hi Thanks for the links. Regards
On Tuesday, February 24, 2015 at 11:47:34 AM UTC, pgs wrote: > > Hi > I have a txt file which I'm trying to perform a compuation(FUNCTION) on > groups of data - the Grouping being Col1 then Col2. > eg > > Say my txt file has the following > > Col1, Col2, Col3 Col4 > A 15:00 4 8 > A 15:00 6 5 > A 15:30 2 4 > A 15:30 8 7 > B 12:00 5 2 > B 12:00 4 1 > B 18:00 2 6 > B 18:00 1 7 > B 18:00 4 0.5 etc etc > > myfunction = map((x,y) -> x / y * 2, Col3,Col4) > I then want to sum the results of my computation using the function e g > > So, when applying "myfunction"? - the result set is... > A 15:00 1 > A 15:00 2.4 > sum 3.4 > A 15:30 1 > A 15:30 2.28 > sum 3.28 > So, the end game for me is just to see the final "sum" as an output - eg > A 15:00 3.4 > A 15:30 3.28 > etc > is this possible? > > Regards > >
