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