The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.

# round real values to the n-th decimal?

Member Posts: 344 Unicorn
edited November 2018 in Help

hi,

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?

• 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
• Member Posts: 24 Contributor I

How do I insert the round in the function expression?

Tried using

Function expression

rand(round())

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.

• 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.

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

`rand()*5`

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

`ceil(rand()*5)`

ceil() rounds to the next integer "above"

floow() rounds to the next integer "below"

Happy Mining,

Edin

P.S.:

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

• Member Posts: 24 Contributor I

Hi Edin,

Thank you really appreciate the explanation.

Best Regards,

Nick