Join us, on May 27th, for an introduction to the new Dataiku Academy Learn more

How to create a rank using two columns?

Dataiker
Dataiker
How to create a rank using two columns?
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!
0 Kudos
2 Replies
Dataiker
Dataiker

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

0 Kudos
Dataiker
Dataiker
Author
Thanks Alex. This answers my question 🙂
0 Kudos
Labels (3)