How to create a rank using two columns?

[UserBird]

Hello,

I have created a score for each row in my data set. Then I used 'bin' to create a column with the categories A,B,C,D based on the score (A with the top scores and D with the bottom scores). How can I create in DataIku a single column that goes from 0-100 for each category? My goal is to see where each row stands relevant within its category.

Thanks!

[Alex_Combessie]

Hi,

You can use a visual "Window" recipe to do that 🙂

First, define your windowing settings (partitioning column will be category and order column will be score)

Then, compute the rank using the quantile method with 100 quantiles.

 

Cheers,

Alex

[UserBird]

Thanks Alex. This answers my question 🙂