The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Replacing individual values inside a column based on conditions
Learner IHey 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.