Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Average value and SD of attributes

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

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

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

    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 

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Telcontar120Telcontar120 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.