"Generate Attribute using values of Aggregate Attributes"

svtorykhsvtorykh MemberPosts:35Guru
edited June 2019 inHelp

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 ProfessorPosts:3,404RM 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
    sgenzer jczogalla
Sign InorRegisterto comment.