/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

-2 votes153 views1 answer
Tkinter bind function with arguments
Python
2 votes177 views1 answer
Sum all values of a dictionary python
Python
0 vote161 views1 answer
Coefficient of variation python
Python
0 vote213 views2 answers
Extract email address using expression in django
Python Django
0 vote164 views1 answer
What is require_self
Python
0 vote148 views2 answers
Negation of boolean in pyhton
Python
1 vote156 views1 answer
Check if any values overlap in numpy array
Python
1 vote174 views1 answer
Need Clang >= 7 to compile Filament from source
Python
0 vote166 views1 answer
Python read excel sheet name
Python
12 votes167 views1 answer
Append a line to a text file python
Python