I'd like to find the datetime where the highest price ($31) is.

If the highest price appears twice, return the earlier datetime.

Expected output should be 2021-09-29 08:00:00-04:00.

CodePudding user response：

I think you're looking for pandas.Series.idxmax():

row = df.loc[df['price'].idxmax()]

Output:

>>> row
volume                           1000
price                              31
datetime    2021-09-29 08:00:00-07:00
Name: 2, dtype: object