0 votes
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!
by

1 Answer

0 votes

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

by
Thanks Alex. This answers my question :)
1,113 questions
1,156 answers
1,301 comments
11,008 users

┬ęDataiku 2012-2018 - Privacy Policy