🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

how to generate an attribute with abs(col1 - col2)

blatoo

Hello,

how can I generate an new attribute, which function expression is: |attr1 - attr2| ?

At moment, i just find the way with if( attr1 - attr2 > 0, attr1 - attr2, attr2-attr1)

Thanks very much for the attention!

Find more posts tagged with

AI Studio

Accepted answers

All comments

Marco_Boeck

Hi,

because there is no explicit function to get absolute values at the moment, I'd suggest the following:


sqrt(pow((attr1-attr2), 2))

Edit: I concede! See Marius' answer below

Regards,
Marco

MartinLiebig

you can use the sign function


sgn(a-b)*(a-b)

for some reason that one is not in the list of Generate Attributes.

MariusHelf

blatoo,

why not simply use your subject line?
abs(attr1-attr2) will also work perfectly in Generate Attributes

~Marius

blatoo

Hi all,

Thanks very much for the answers! :-) I got now more solutions. But I think, if rapidminer can put the abs() also in the function list, will be better. Because abs() will be often used.