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?
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.
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! 🙂