Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
- General
- Platform
- Academic
- Partner
- Regional
User Groups
Documentation
Events
Altair Exchange
- Share or Download Projects
Resources
Employee Resources
- This tab can be seen by employees only. Please do not share these resources externally.
Groups
- Join a User Group
Support

Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Home
Discussions
Community Q&A

Remove Duplicates

Hi guys, I am new to RapidMiner, so please bear with me.
I am trying to use Turbo Prep to do some data cleansing before analysing because the dataset has many issues.
I will select name/ID and use remove duplicates function.
In this case:
ID: Number of buying:
AA01 8
AA01 10

It seems like RapidMiner will only keep the first row of 'Num of buying'.

Is there any way I can keep the average or sum or max or min of the column of 'Number of Buying'?

Find more posts tagged with

AI Studio

Accepted answers

BalazsBaranyRM

Hi!

Of course this is possible. However, this is called grouping or aggregation. You find it in Turbo Prep under "Pivot".

Regards,
Balázs

All comments

BalazsBaranyRM

Hi!

Of course this is possible. However, this is called grouping or aggregation. You find it in Turbo Prep under "Pivot".

Regards,
Balázs

LilC

Thank you!

Quick Links

All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups