I have a dataframe simillar to this but with 26400 observations:
ID | year of visit 1 2005 1 2006 1 2007 2 2002 2 2003 3 2005 3 2006
I want to create a new data frame with only the last year of visit of each patient. Like this:
ID | year of visit 1 2007 2 2003 3 2006
Thank you very much in advance.
