How to create a rank using two columns?

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
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!

Answers

  • Alex_Combessie
    Alex_Combessie Alpha Tester, Dataiker Alumni Posts: 539 ✭✭✭✭✭✭✭✭✭
    Options

    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
    UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
    Options
    Thanks Alex. This answers my question :)
Setup Info
    Tags
      Help me…