Horje
dataframe groupby rank by multiple column value Code Example
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



Python

Related
check dictionary values pandas dataframe colu Code Example check dictionary values pandas dataframe colu Code Example
python copy sequence Code Example python copy sequence Code Example
urllib.error.HTTPError: HTTP Error 502 docker redis Code Example urllib.error.HTTPError: HTTP Error 502 docker redis Code Example
paystack python Code Example paystack python Code Example
python break list into multiple lines Code Example python break list into multiple lines Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje