How to find the min value of a column, for each unique value in another column?

Asked Dec 23 '21 at 05:05

Active Dec 23 '21 at 07:53

Viewed 25 times

Here is my dataframe ().

   raceId     stop      
0   841       26.898     
1   841       25.021     
2   841       23.426     
3   841       23.251     
4   841       23.842

So I want to find the minimum value in column stop for each unique value in raceID. How would I do that exactly. My index goes up to the hundreds so I feel like having a for loop wouldn't be efficient. Thanks for any help.

edited Dec 23 '21 at 07:53

Sibtain Reza

asked Dec 23 '21 at 05:05

JoeMama786

2

Use `df.groupby('raceId', as_index=False)['stop'].min()` – jezrael Dec 23 '21 at 05:07

How to find the min value of a column, for each unique value in another column?

0 Answers0