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.
Generate binominal attribute based on comparison of two values
Hello,
I'm quite new to RapidMiner, but I have an assignment from school.
I want to generate a new attribute (Difference in estimated revenue), based on a comparison of two REALs in two different attributes. If the two values are the same, the generated attribute value should be set to "true". If otherwise, the value should be "false". Below an example:
The problem you see here, is that the value "true" is often falsely assigned to the generated attribute, as you can see that the two REALs are actually the same. The value "false" was expected here.
What is going wrong? The function expression I used is: if([Estimated Annual Revenue]!=[Estimated Annual Revenue calculated], "true", "false").
Note: The attribute Estimated Annual Revenue calculated comes from an Generate Attribute with a function expression of Net Price*Estimated Annual Quantity.
Can I force the function expression to compare the values up to 3 digits after the comma? I think that there is a small difference in the values, but because the values are rounded up to 3 digits after the comma, I cannot see that.
I hope someone can help me!
Kind regards,
Igor van Haasteren
I'm quite new to RapidMiner, but I have an assignment from school.
I want to generate a new attribute (Difference in estimated revenue), based on a comparison of two REALs in two different attributes. If the two values are the same, the generated attribute value should be set to "true". If otherwise, the value should be "false". Below an example:
The problem you see here, is that the value "true" is often falsely assigned to the generated attribute, as you can see that the two REALs are actually the same. The value "false" was expected here.
What is going wrong? The function expression I used is: if([Estimated Annual Revenue]!=[Estimated Annual Revenue calculated], "true", "false").
Note: The attribute Estimated Annual Revenue calculated comes from an Generate Attribute with a function expression of Net Price*Estimated Annual Quantity.
Can I force the function expression to compare the values up to 3 digits after the comma? I think that there is a small difference in the values, but because the values are rounded up to 3 digits after the comma, I cannot see that.
I hope someone can help me!
Kind regards,
Igor van Haasteren
Tagged:
0
Best Answer
-
MartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,529 RM Data ScientistHi,to check if thats the problem you can mouse over the 1312.800, it should show you the full string. Otherwise you can just change the number of digits in the settings.~Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany0