Map Operator isn't working with Aggregation Operator

Ellie98Ellie98 Member Posts: 27 Contributor II

I calculated the average value of each product with the Aggregation operator. 

I got those values: 

Now I'm trying to categorize 2 products together. Wines and Meat, Fish and Gold, Fruits and Sweets, like this: 

I want to visualize all 3 categories in the Pie Plot Type but if I run this process I still only get all averages of each product. Why isn't the mapping operator working? Do I have to save the aggregated attributes first? with apply model or something? 

Thanks in advance!! :smiley:

Best Answer

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted

    No, you won't be able to create duplicate names with Rename by Replacing either. 

    You could rotate the example set with Transpose so that attributes become values. Then you could use Map for renaming the averages. 



  • Options
    ceaperezceaperez Member Posts: 525 Unicorn
    Hi, @Ellie98

    the Map operator works with values (rows) over the Attributes. To change the Attribute (column) name you need to work with Rename Operator.

  • Options
    Ellie98Ellie98 Member Posts: 27 Contributor II
    Hey @ceaperez,

    Thank you for your answer. It says that I can't use the same name 2 times. 

    Do I have to use Rename by Replacing instead? I'm not sure how that one works. 

  • Options
    Ellie98Ellie98 Member Posts: 27 Contributor II
    Thank you so much @BalazsBarany! It worked 😁👍
Sign In or Register to comment.