Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Replacing individual values inside a column based on conditions
Hey everyone,
I've just started testing RapidMiner and I'm having a bit of trouble doing this one task.
Basically I need to replace existing values with custom values in one column based on a condition.
So basically, I need to change TOTAL_SALDO numbers based on the value of the Month column. I'm having trouble finding a way to do that in RapidMiner.
I guess one could write the desired expression the following way:
IF Month == 3 THEN TOTAL_SALDO = -682.51 ELSE IF Month == 6 THEN TOTAL_SALDO = -6602.66 ELSE IF Month == 9 THEN TOTAL_SALDO = -29141.54 ELSE TOTAL_SALDO = 110778.17
Thank you for your attention!
0
Answers
You can use the generate attribute operator. You can build this if statement.
Please refer to this video from our academy.
Feature Generation demo | RapidMiner Studio