Hi all,
I'm currently working with a fairly large data set which I have transposed into a table that looks the attached file.
What I'm trying to do is keep only instances where the same names appears 3 times (as I would like to take the average of the highest 3 grades over 3 courses, but some students have only taken two of those courses, or none at all). Essentially, I would like to keep instances of names that appear across all 3 courses and remove ones that appear in 2 or fewer.
Any suggestions would be greatly appreciated.
Thank you!
Bookmarks