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
