examples to group
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

Hi,
I think the operator you search for is Discretize by User Specification.
Best,
Martin
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.
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.
Sort by:
1 - 2 of
21
Hi,
I think the operator you search for is Discretize by User Specification.
Best,
Martin
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.
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.