I have a data set, first column is the ID, second is Date and Third is score.
Below is a sample data...
Now, how do i filter out the only the 2nd visit data of A, B & C
no date score
A 01-01-2010 10
A 01-01-2011 50
A 01-01-2012 183
A 05-03-2025 4
B 06-07-1998 32
B 02-02-2010 145
B 02-02-2011 145
B 02-02-2013 247
C 02-05-1976 127
C 02-04-2015 124
C 03-03-2025 0