h2oai / h2oai/datatable

similar to `pandas.Series.rank()`

Open
#3,148 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
C++
Stars
1.9k
Forks
164
Avg merge
7h 31m
Merged PRs (30d)
1

Description

```
import pandas as pd
#
df = pd.DataFrame({
'name1':['A', 'B','A', 'B', 'A','B'],
'name2':['a','b','c','d','e','f'],
'goal':[92,91,90,89,88,87]
})
def f(x):
x['rank_num'] = x['goal'].rank(ascending=False)
return x
df1 = df.groupby('name1').apply(lambda x:f(x)).sort_values(['name1', 'name2'])
print(df1)

`
  | name1 | name2 | goal | rank_num
-- | -- | -- | -- | --
A | a | 92 | 1.0
A | c | 90 | 2.0
A | e | 88 | 3.0
B | b | 91 | 1.0
B | d | 89 | 2.0
B | f | 87 | 3.0
`

```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.