python Ranking on rows having same value is giving random ranking not as ascending = False

Question

Here is df, I want to Rank on value on group "Id" , ranking within class

df['Rank']=df.groupby(["Id"])[' value'].rank(ascending=0)

Expected Result

Result what I get from above code Result what I get from above code

Above code works well if value are unique Example df

Your example is ambiguous. Can you `print(df.sample(5).to_dict("list"))` and add it to your post with the matching expected output ? — Timeless, Dec 02 '22 at 06:26

score 0 · Answer 1 · answered Dec 02 '22 at 07:11

df['Rank']= df.groupby('ID')['Value'].rank(ascending=False, method='dense').astype(int)

print(df)

   ID Class  Value  Rank
0  US     A     10     1
1  US     B     10     1
2  US     C      2     2
3  US     D      2     2

Input used :

   ID Class  Value
0  US     A     10
1  US     B     10
2  US     C      2
3  US     D      2

1 Answers1