/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

10 votes280 views6 answers
Progress bar python
Python
3 votes340 views1 answer
Flask delete cookie stackoverflow
Python Flask
2 votes271 views1 answer
How to reapete the code in python
Python
83 votes293 views2 answers
Download python for windows7 64 bit
Python
0 vote281 views1 answer
Trim strings python
Python
0 vote318 views1 answer
Drop columns pyspark
Python
0 vote266 views1 answer
Python search list of lists for value return index
Python
0 vote296 views1 answer
Pytest runtimeerror: no application found. either work inside a view function or push an application context
Python
0 vote280 views1 answer
Python capture desktop as video source
Python
0 vote274 views1 answer
File attributes in os
Python