Filtering duplicate rows with conditions

[realusername]

Let's say I have a dataset with duplicate rows like this:

Josh Green | 2010-2011
Josh Green | 2011-2012
Josh Green | 2012-2013
Sam White | 2011-2012
Sam White | 2013-2014
Sam White | 2016-2017
Paul Grays | 2010-2011

And I want to keep only unique names with the most recent date like this:

Josh Green | 2012-2013
Sam White | 2016-2017
Paul Grays | 2010-2011

Any way to accomplish that?

[martin.R]

This is one way:

library(dplyr)

df %>% 
  group_by(name) %>% 
  arrange(desc(year), .by_group = TRUE)
  filter(row_number() == 1)

[realusername]

Perfect, thank you so much.

Just in case anyone wants to use this, Martin forgot '%>%' so it's gonna look like this:

df %>% 
  group_by(name) %>% 
  arrange(desc(year), .by_group = TRUE) %>%
  filter(row_number() == 1)