I am trying to calculate the Mean and STDV for a table. I know that the the "Math Formula" is the correct node to use, but my table is quite large. I am having trouble doing this in a loop.
Ideally I would like to go from a table like this
Col1 Col2 Col3
Row1 1 4 6
Row2 2 5 8
Row3 2 4 1
to:-
Col1 Col2 Col3
Row1 1 4 6
Row2 2 5 8
Row3 2 4 1
Mean 1.67 4.33 5.00
STDV 0.58 0.58 3.61
is there any easy way to do this?
at the moment the math formula node is appended to a new column so the results look like this:
Just use the GroupBy node. This is very powerful for this type of analysis, just dont choose a column to GroupBy, go straight to the second tab in the node.