"Generate Attribute using values of Aggregate Attributes"

svtorykhsvtorykh Member Posts: 35 Guru
edited June 2019 in Help

Hi RM team, seems to be a very basic calculation, but can't create an expression for the following scenario.

I have example set with Positivity values (positive, neutral, negative). I'm using aggregate operator to perform counts for all example set.

 

Have table as output in the following format:

Positivity(Att1) Count of Positivity (Att2)

Positive                    500

Neutral                     100

Negative                   500

 

I then need to generate another Attribute (positivity %), which needs to have a ratio value based on positive/negative values from att2.

 

What is the proper expression to use in this case?

 

Thanks!

Answers

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

    Hi @svtorykh,

    one way to do this is to extract the number of examples before hand using Extract Macro and then simply divide by it using Generate Attributes.

     

    Best,

    Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.