Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Map Operator isn't working with Aggregation Operator

Ellie98

Hello,

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

Image: https://us.v-cdn.net/6030995/uploads/editor/lv/xhd3l4tg0ak6.png

I got those values:

Image: https://us.v-cdn.net/6030995/uploads/editor/og/qdg17e70f4rr.png

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

Image: https://us.v-cdn.net/6030995/uploads/editor/l9/jqzbz8u10ai2.png

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!!

Find more posts tagged with

AI Studio

Categorization

Aggregate

Accepted answers

BalazsBaranyRM

Hi!

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.

Regards,
Balázs

All comments

Caperez

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.

Best

Ellie98

Hey @ceaperez,

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

Image: https://us.v-cdn.net/6030995/uploads/editor/9z/vftbewtmeb05.png

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

BalazsBaranyRM

Ellie98

Thank you so much @BalazsBarany! It worked 😁👍