Using a dataset to segment data
![PhilippeDulac](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar5.png)
PhilippeDulac
Registered Posts: 11 ✭✭✭
Hi,
I would like to associate a "category" to my data depending on values in a column and ranges defined on another dataset.
Categories definition dataset :
age category | min | max |
A | 0 | 10 |
B | 11 | 20 |
C | 21 | 30 |
D | 31 | 45 |
My_data dataset :
Name | age | Category |
XXX | 8 | A |
YYY | 22 | C |
What is the best way to determine category in my_data ?
Thanks in advance for your help,
Philippe
Best Answer
-
Hi @PhilippeDulac
,To achieve that, you may use the Join recipe to do a left join with your two datasets using condition on Age superior to your min and inferior to your max and keeping the column you want.
Hope this helps !
Answers
-
Perfect !
Exactly what I was expecting.
Thanks a lot Wlukusa