Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[FEA] top N rows by group #2592

Closed
jangorecki opened this issue Aug 15, 2019 · 1 comment · Fixed by #12939
Closed

[FEA] top N rows by group #2592

jangorecki opened this issue Aug 15, 2019 · 1 comment · Fixed by #12939
Assignees
@wence-
Labels
feature request New feature or request libcudf Affects libcudf (C++/CUDA) code. Python Affects Python cuDF API.
Milestone
Pandas API Alignm...

Comments

@jangorecki
Copy link

I would like to select top N (2 in below example) rows by group. Below is pandas code used for that.

import pandas as pd
d = pd.DataFrame.from_dict(dict([('id2', [1, 2, 1, 2, 1, 2]), ('id4', [1, 1, 1, 1, 1, 1]), ('v3', [1, 3, 2, 3, 3, 3])]))
d.sort_values('v3', ascending=False).groupby(['id2','id4']).head(2)

What is the cudf API to achieve it?
@jangorecki jangorecki added Needs Triage Need team to review and classify question Further information is requested labels Aug 15, 2019
@kkraus14 kkraus14 changed the title [QST] top N rows by group [FEA] top N rows by group Aug 15, 2019
@kkraus14 kkraus14 added Python Affects Python cuDF API. libcudf Affects libcudf (C++/CUDA) code. and removed Needs Triage Need team to review and classify question Further information is requested labels Aug 15, 2019
@kkraus14
Copy link
Collaborator

@jangorecki Changed this to a feature request.

@kkraus14 kkraus14 added the feature request New feature or request label Aug 15, 2019
@shwina shwina mentioned this issue Aug 15, 2019
Closed
@jangorecki jangorecki mentioned this issue Aug 23, 2019
Closed
@beckernick beckernick mentioned this issue Feb 14, 2020
Closed
@GregoryKimball GregoryKimball assigned shwina and unassigned shwina Jun 24, 2022
@beckernick beckernick mentioned this issue Nov 30, 2022
Closed
@wence- wence- self-assigned this Mar 9, 2023
wence- added a commit to wence-/cudf that referenced this issue Mar 14, 2023
@wence-
Implement groupby.head and groupby.tail
caa2970 
- Closes rapidsai#2592
- Closes rapidsai#12245
@wence- wence- mentioned this issue Mar 14, 2023
Merged
3 tasks
rapids-bot bot pushed a commit that referenced this issue Mar 16, 2023
@wence-
Implement groupby.head and groupby.tail (#12939)
9ceecb1 
These methods can be implemented by grouping the dataframe and
then selecting appropriate slices from each group. This is less
memory-efficient than it could be (since the entire grouping must
be constructed before discarding most of it).

- Closes #2592
- Closes #12245

Authors:
  - Lawrence Mitchell (https://github.com/wence-)

Approvers:
  - Ashwin Srinath (https://github.com/shwina)

URL: #12939
@bdice bdice mentioned this issue Apr 7, 2023
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wence- wence-

Labels
feature request New feature or request libcudf Affects libcudf (C++/CUDA) code. Python Affects Python cuDF API.
Projects
None yet
Milestone
Pandas API Alignment and Coverage
Development

Successfully merging a pull request may close this issue.

Implement groupby.head and groupby.tail wence-/cudf
5 participants
@wence- @shwina @jangorecki @kkraus14 @beckernick