turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community Home
- :
- Product Help
- :
- RapidMiner Studio Forum
- :
- convert from absolute value to percentage

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
Options
# convert from absolute value to percentage

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

02-20-2017 04:52 PM

02-20-2017 04:52 PM

Assume I have a recordset as this :

a1 a2 a3

1 1 2

2 2 1

1 2 1

and I want to convert it from absolute value to percentage so my outcome becomes like this :

a1 a2 a3

25% 25% 40%

50% 25% 40%

25% 50% 20%

Or in other words, for each of my attributes I want to get the sum by attribute, and then for each of the value the percentage.

I thought I would be able to do this with the loop attributes operator but I am not able to select the content so I'm doing something wrong somewhere.

What would be the easiest way to approach this?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

02-20-2017 05:45 PM

02-20-2017 05:45 PM

Solution

Accepted by topic author kayman

02-21-2017
04:54 AM

The Normalize operator has the useful option "proportion transformation" that rescales numeric attributes to be their fractional contribution out of 1. Use Generate Attributes to multiply this by 100 to get a percentage.

Andrew

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

02-20-2017 05:10 PM

02-20-2017 05:10 PM

The percentages in your example don't seem to line up properly, but based on your description, I think the fractional count function in the Aggregate operator does what you want. You just have to specify to group by your primary id variable, so it won't really be aggregating if you have no duplicates in your dataset. But that's fine. Note that if you want row percentages rather than column percentages you can do something similar with Generate Aggregation.

Brian T., **Lindon Ventures** - www.lindonventures.com

Analytics Consulting by Certified RapidMiner Analysts

Analytics Consulting by Certified RapidMiner Analysts

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

02-20-2017 05:45 PM

02-20-2017 05:45 PM

Solution

Accepted by topic author kayman

02-21-2017
04:54 AM

The Normalize operator has the useful option "proportion transformation" that rescales numeric attributes to be their fractional contribution out of 1. Use Generate Attributes to multiply this by 100 to get a percentage.

Andrew