Pandas get second minimum value from datetime column

Question

I have a data frame with a DateTime column, I can get minimum value by using

df['Date'].min()

How can I get the second, third... smallest values

possible duplicate of https://stackoverflow.com/questions/24943902/python-pandas-select-2nd-smallest-value-in-groupby — tawab_shakeel, Jul 21 '19 at 06:37

score 4 · Answer 1 · answered Jul 21 '19 at 06:24

4

Use nlargest or nsmallest

For second largest,

series.nlargest(2).iloc[-1]

answered Jul 21 '19 at 06:24

score 0 · Answer 2 · answered Jul 21 '19 at 06:24

0

Make sure your dates are in datetime first:

df['Sampled_Date'] = pd.to_datetime(df['Sampled_Date'])

Then drop the duplicates, take the nsmallest(2), and take the last value of that:

df['Sampled_Date'].drop_duplicates().nsmallest(2).iloc[-1]

answered Jul 21 '19 at 06:24

sudoxx

Hey, I had a full working answer your Fast.com question, but the question got deleted. If you reopen the question I can post it? Or contact me from the email in my info, whichever you prefer – abdusco Jul 21 '19 at 06:48
I've created a question and wrote a detailed answer for you: https://stackoverflow.com/q/57131422/5298150 – abdusco Jul 21 '19 at 08:11

2 Answers2