How to select and extract the rows with the same ID which has the minimum value in one column in jupyter?

Question

I have a data frame that has some rows with the same ID which includes different starcounter values.

I need to keep the rows with a minimum value and delete the extra rows to reach this table: .

Thank you in advance.

score 4 · Answer 1 · answered Jan 01 '20 at 11:10

4

What you need is

df2 = df.sort_values('starcounter').drop_duplicates(['ID'], keep='first')

answered Jan 01 '20 at 11:10

GihanDB

score 1 · Answer 2 · answered Jan 01 '20 at 10:30

1

Here's a one liner to do this:

df.loc[df.groupby('ID')['starcounter'].idxmin()]

answered Jan 01 '20 at 10:30

YOLO

2 Answers2