Round columns in Azure ML

Question

Hello,

I have made an experiment in Azure ML with a coefficient of detemination reaching 86% (regression). I would like to improve it using the rounding of several features (columns). I would like to round some columns to "xx-ten" example: 1854 => 1850 (up and down if possible)
I have used ceil functions before to avoid decimal numbers but here this is another case. I cannot see how to do this.

Can anyone help in this please?

Kind Regards,

Mohamed.

Answer 1

Hello Dear,

Thank you for your advice. I have found in the rounding area the "tomultiple" function where I can decide to round a number to tens, hundreds... (example: tomultiple(2583,10) => 2580).

Thank you :)

Mohamed.

Answer 2

Hi, the Apply Math Operation module has a rounding operator that can be used to round up/down on a given column set.