🎉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

examples to group

User: "Thiru"
New Altair Community Member
Updated by Jocelyn
days
325
100
3250
1250
2200
4500
10
75
100
478
4250
3400
1000

I've an attribute similar to the above.  I want to generate new attribute with  new values ( as smll, medium, mediumbig, big )
after  classify the examples of above attribute  into 4 groups :  days <100 -> small ,  <1550 - medium , < 3500 - mediumbig,    >3500 - big.   I tried to use  "if then" description , but it doesnt give the results.   can some one help?

thanks
thiru





Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "MartinLiebig"
    Altair Employee
    Accepted Answer
    Hi,
    I think the operator you search for is Discretize by User Specification.

    Best,
    Martin
    User: "kayman"
    New Altair Community Member
    Accepted Answer
    the if then approach should work also, but ensure your logic states it needs to be smaller as figure a AND bigger as figure b.
    If you just state smaller then and forget not bigger then you just overrule all your previous definitions

    example

    assume date is 50

    date smaller than 100 ? TRUE
    date smaller than 500 ? Also TRUE

    Discretize does the same, and is far less error prone than a multi if then else function so better use that one indeed. Also here ensure you set a complete boundary rather than just a single one.