id,v1,v2,v3,v4,v5
22,hi,hi,1,2,3
22,hi,hi,1,2,3
22,,,,,
33,hi,hi,2,3,4
33,hi,hi,2,3,4
33,hi,hi,2,3,4
33,,,,,
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,,,,,
Solved
I have a csv file where I want to calculate the sum of a respective attribute which have the same ID. In the example below I want to sum the values of v2 and add it in the correct place for id = 22, then go onto the next "group", thanks!
Best answer by nielsgerrits
nielsgerrits wrote:
I probably do not understand what you need. Can you add you expected output?
I still do not understand why one would want this :D but the attached workspace produces what you asked for.
+54stewartgr wrote:
Thanks! But how do I place the values found in the empty columns in the final row of each "group"?
I probably do not understand what you need. Can you add you expected output?
nielsgerrits wrote:
I probably do not understand what you need. Can you add you expected output?
id,v1,v2,v3,v4,v5
22,hi,hi,1,2,3
22,hi,hi,1,2,3
22,,,sumv2,summv3,sumv4,sumv5
33,hi,hi,2,3,4
33,hi,hi,2,3,4
33,hi,hi,2,3,4
33,,,sumv2,summv3,sumv4,sumv5
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,no,no,5,5,5
44,,,sumv2,summv3,sumv4,sumv5
+54- Best Answer
nielsgerrits wrote:
I probably do not understand what you need. Can you add you expected output?
I still do not understand why one would want this :D but the attached workspace produces what you asked for.
nielsgerrits wrote:
I probably do not understand what you need. Can you add you expected output?
Thank you very much! Is part of a larger system which has its requirements, odd as they may be.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.