How to retrieve columns with criteria for the latest date in Python?

Question

This is the original dataframe.

      Country     Date     Confirmed    Death   Recovered   newConfirmed    newDeath    newRecovered
No                              
1   Afghanistan 31/12/2019     0          0         0            0              0           0
2   Afghanistan 01/01/2020     0          0         0            0              0           0
3   Afghanistan 02/01/2020     0          0         0            0              0           0
4   Afghanistan 03/01/2020     0          0         0            0              0           0
5   Afghanistan 20/03/2020     0          0         0            0              0           0

I want to retrieve only Columns 'Country', 'Confirmed', 'Death', and 'Recovered' for the date '2020-03-20'(which is the latest date) from the original DataFrame into a new DataFrame.

How should I do this?

@jezrael i've worked on this but it doesnt give me the required answer. — Chaos Black, Mar 27 '20 at 11:43
@jezrael No, actually the max date is fixed on 20/03/2020 but there are more than one data with this date. Therefore it is not only the last row. — Chaos Black, Mar 27 '20 at 11:49
The question requires me to show Columns 'Country', 'Confirmed', 'Death', and 'Recovered' for the Max Date only. — Chaos Black, Mar 27 '20 at 11:51
@jezrael Thanks this works for geting the latest date but I also need to filter the Columns 'Country', 'Confirmed', 'Death', and 'Recovered'. — Chaos Black, Mar 27 '20 at 11:54

score 0 · Accepted Answer · answered Mar 27 '20 at 11:57

Use DataFrame.loc with filter by boolean indexing witth max values, but first is necessary convert strings to datetimes by to_datetime with dayfirst=True parameter:

df['Date'] = pd.to_datetime(df['Date'], dayfirst=True) 
df1 = df.loc[df['Date'].eq(df['Date'].max()), ['Country', 'Confirmed', 'Death', 'Recovered']]
print (df1)
       Country  Confirmed  Death  Recovered
5  Afghanistan          0      0          0

How to retrieve columns with criteria for the latest date in Python?

1 Answers1