Remove Duplicates

LilC

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'?

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

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!