Remove Duplicates

LilC
LilC New Altair Community Member
edited November 2024 in Community Q&A
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'?
Tagged:

Best Answer

Answers

  • LilC
    LilC New Altair Community Member
    Thank you!