Generate percentages from absolute values

Question

Hey everybody.

I have a CSV reader operator. It reads the following data from a CSV file:
INSERT, SELECT, UPDATE, DELETE
5,10,0,0
1,2,2,0
30,0,0,0
...

I want to use an operator that generates the follow values (percentage of each column) from the original ones:
INSERT, SELECT, UPDATE, DELETE
33,66,0,0
20,40,40,0
100,0,0,0
...

Is there a way to do that?

Thanks in advance,
Leonardo

wessel · Answer

Sebastian made a small typo, so change: 'sum' into 'SumAll'

Its not that hard to figure out what is going on.
Basically each row is first summed over on every column. 
Then each column gets divided by the sum.

Best regards,

Wessel

onesix4 · Answer

Hi,
I have attempted to load this example to generate a percentage but the "Process" fails:

Oct 18, 2012 12:25:00 PM SEVERE: Process failed: operator cannot be executed (Unknown attribute: 'sum'). Check the log messages...
Oct 18, 2012 12:25:00 PM SEVERE: Here:           Process[1] (Process)
           subprocess 'Main Process'
             +- Generate Data[1] (Generate Data)
             +- Generate Aggregation[1] (Generate Aggregation)
             +- Loop Attributes[1] (Loop Attributes)
           subprocess 'Subprocess'
       ==>         +- Branch sum!=0?[1] (Branch)
           subprocess 'Then'
                      |  +- Generate Attributes[0] (Generate Attributes)
           subprocess 'Else'

I would like to have an example to generate a percentage column based on data read.
Thanks.

SebastianLoh · Answer

hi leonardormachado, I uploaded a process on my experiment. search for "Generate percentages from absolute values" in the myExperiment plugin and the just open the process and explanations in RM. Ciao Sebastian P.S.