how we can transform data in categorie?

goldengriffs

hi dears,

i hava student performance dataset that must be categories in good,bad and average class.

how i can do it? which operators?

if value attribute <=10 then "bad"

if value attribute >=10 and <=15 then "average"

if value attribute >=15and <=20then "good"

for example,

rock=7

james=12

andesron= 17

rose=5

result:

rock= bad

james= average

anderson= good

rose=bad

 thanks

Thomas_Ott

Looks like you'll need the Generate Attributes operator to do your expression evaluations. Just create a new column called "label" and then do a few if-then statements 

Thomas_Ott

Looks like you'll need the Generate Attributes operator to do your expression evaluations. Just create a new column called "label" and then do a few if-then statements