question

MohamedElHamrouni-4343 avatar image
1 Vote"
MohamedElHamrouni-4343 asked MohamedElHamrouni-4343 answered

Round columns in Azure ML

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.

azure-machine-learning
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

MohamedElHamrouni-4343 avatar image
1 Vote"
MohamedElHamrouni-4343 answered

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.

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GiftA-MSFT avatar image
0 Votes"
GiftA-MSFT answered

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


5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.