/Python/Dataframe groupby rank by multiple column value

Dataframe groupby rank by multiple column value

df = df.sort_values(by=["x","y"], ascending=False)
df['rank']=tuple(zip(df.x,df.y))
df['rank']=df.groupby('sort_by',sort=False)['rank'].apply(lambda x : pd.Series(pd.factorize(x)[0])).values
df
Out[615]: 
  sort_by      x       y  rank
3       a  500.0  1000.0     1
1       a  200.0  2000.0     2
2       a  200.0  2000.0     2
7       a  200.0   100.5     3
0       a  100.5  4000.0     4
6       b    3.0   600.5     1
5       b    2.0   600.5     2
4       b    1.0   500.5     3

Source: stackoverflow.com

Similar codes

1 vote128 views1 answer
Save screenshot of screen in pygame
Python
2 votes130 views3 answers
Python random number generator no duplicates
Python
6 votes202 views2 answers
Flask form options
Python Flask
4 votes150 views2 answers
Remove columns that start with pandas
Python
0 vote136 views1 answer
Python display map
Python
0 vote156 views1 answer
Mechanize python #9
Python
0 vote124 views1 answer
Flask migrate multiple heads
Python
0 vote99 views1 answer
How to subtract up everything in a list python
Python
2 votes135 views3 answers
How to copy items from 1 list to another in python
Python
-2 votes137 views1 answer
Sort function in pandas dataframe to sort specific properties
Python