round real values to the n-th decimal?

Fred12Fred12 Member Posts: 344 Unicorn
edited November 2018 in Help


is there any operator than can round or cut of some real number on the n-th decimal, e.g on the 5 number after the comma or so?

do this for one or any columns?


  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

    I believe the "round" function available in generate attributes will do what you want quite easily!  

    You also have the 'format numbers' operator but that will turn it into a nominal value.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • Options
    SHSguySHSguy Member Posts: 24 Contributor I

    How do I insert the round in the function expression? 

    Tried using 

    Function expression



    also two separate function expressions no luck 


    attribute 1 rand()

    attribute 1 round()


    also if maybe you know, how do I limit the random function between two numbers rand(1,5) does not work at all. 


    Thank you in advance. 


  • Options
    Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    Hi @SHSguy,


    I am not sure what you want to achieve in your first use case.

    If you want to round a random number the order of functions is wrong. It needs to be round(rand(),x) with x being the number of decimals to round to.


    Regarding your second question:

    The rand() function always delivers a floating point number between 0 and 1. So one possible solution would be


     to get values between 0 and 5. If want them rounded to the next integer you would do


    ceil() rounds to the next integer "above"

    floow() rounds to the next integer "below"


    Happy Mining,




    An explanation to all function is given if you click on the i next to the function (see screenshot) image.png





  • Options
    SHSguySHSguy Member Posts: 24 Contributor I

    Hi Edin, 


    Thank you really appreciate the explanation.


    Best Regards,


Sign In or Register to comment.