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,218 questions
1,249 answers
1,410 comments
11,782 users

┬ęDataiku 2012-2018 - Privacy Policy