Average value and SD of attributes

jean_claude_van
jean_claude_van New Altair Community Member
edited November 2024 in Community Q&A

Hello

 

I have a dataset in which I would like

i) to select automatically all the attributes having a name starting by letter C,

ii) then calculate the average value and standard deviation of the values of each attribute,

ii) get a final table with the name of the attributes and their average values and standard deviations.

Do you now operators I could use for that. I spent the afternoon without any success.

 

Jean Claude

Tagged:

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee

    Hi,

     

    you can use Select Attributes with regular expression C.+

     

    Afterwards, you use Aggregate and activate the "default aggregation" which uses all attributes.

     

    Best,

    Martin 

  • Telcontar120
    Telcontar120 New Altair Community Member

    Or you can use "Loop Attributes" and do a similar Aggregate operation inside the loop and then feed the results out to a dataset that you append together at the end.

Categories