Average value and SD of attributes

jean_claude_vanjean_claude_van Member Posts: 5 Contributor I
edited November 2018 in Help



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



  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist



    you can use Select Attributes with regular expression C.+


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




    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

    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.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.