Agreggation Groupby #2: get the highest date

PHOTO

Sat Jan 23 2021 20:28:42 GMT+0000 (Coordinated Universal Time)

Saved by @exe

# Get the highest date of each group

df.groupby('ID', as_index=False)['Date'].max()

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Data Analysis

@exe

Filtering with multiple conditions '&' operator Filtering Boolean indexing with square brackets Filtering Boolean indexing with .loc Filtering with multiple conditions 'or' operator Agreggation Groupby #1: get total sum Agreggation Groupby #2: get the highest date Pivoting data Creating conditional columns numpy.where Conditional columns with list comprehension Aggregation with multiple functions groupby

Browse more snippets >>