/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

122 votes173 views6 answers
Prompt python
Python
1 vote184 views1 answer
Format integer to be money python
Python
31 votes405 views6 answers
Django admin create superuser
Python Django
34 votes204 views6 answers
Name columns pandas
Python
0 vote230 views1 answer
Django check if user is staff in template
Python Django
1 vote181 views1 answer
>>> import numpy Illegal instruction (core dumped)
Python
0 vote220 views1 answer
?: (corsheaders.E013) Origin '.' in CORS_ORIGIN_WHITELIST is missing scheme or netloc HINT: Add a scheme (e.g. https://) or netloc (e.g. example.com).
Python
0 vote234 views1 answer
Staticmethod vs classmethod python
Python
5 votes275 views3 answers
Pytorch 1.7
Python
1 vote177 views1 answer
How to get the value out of a dictionary python3
Python