[Solved] Remove duplicate on multiple columns keep newest [closed]


In R, using dplyr:

data %>% 
    group_by(Name, CoordinateX, CoordinateY) %>% 
    arrange(desc(Date)) %>% 
    distinct() %>% 
    ungroup()

Give the output:

Name       Date CoordinateX CoordinateY
Aaa  2018-08-29      650000      134999
Bbb  2010-08-29      650000      134999
Bbb  2010-08-29      655600      134999
Ccc  2010-08-29      655600      134999

solved Remove duplicate on multiple columns keep newest [closed]