New column generation (USING FORMULA) based on a set of conditions
I want to create a new column using an existing one ( A numerical field having values from 0-100)
I'd like my new column to score the values as
0-15 -> 5
16-30 ->4
31-45 ->3
46-60 -> 2
61-rest ->1
Can I use " formula" on the existing column to achieve this?
Best Answer
-
Hi,
Yes indeed you can use Formula processor with nested 'if()' conditions to achieve your value remapping.
You can also use "Discretize (bin) Numerical values" from the processor list with a custom raw value remapping and enter your boundaries and target values.
Hope this helps
Answers
-
I actually implemented the binning logic!
Wasn't sure if that was the right way to go about it though.
Thanks for the solution + reassurance. Cheers!
-
Is there a way to define bins based on a different variable?
For example if there is a data point with type as type 1 then use bins like 1-15, 15-20 etc for it and if the type is type 2 , then use bins like 1-5, 5-10 and so on?
