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,078 questions
1,123 answers
1,246 comments
10,710 users

┬ęDataiku 2012-2018 - Privacy Policy