/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

0 vote126 views6 answers
Python django
Python
1 vote136 views1 answer
Show number as 3 digit python
Python
0 vote125 views1 answer
Accumulator programming python
Python
0 vote149 views1 answer
Get source selenium python
Python
0 vote132 views1 answer
Inicair venv python
Python
0 vote139 views1 answer
Get all environment variables python
Python
3 votes157 views2 answers
What is indentation in python
Python
0 vote132 views1 answer
How to upload to PyPi with same name
Python
0 vote158 views1 answer
Change python 3.5 to 3.6 ubuntu
Python
0 vote157 views1 answer
Copy file merged hdfs
Python