I have code which looks like the following and I am trying to get the highest rank for each publisher each month:
Rank Title Publisher Year Month Date 1 a1 a 2000 April Apr 2000 2 b1 b 2000 April Apr 2000 3 a2 a 2000 April Apr 2000 1 a3 a 2000 May May 2000
So I would want a new dataset that had every row except row three since that is publisher a's second highest rated book for that month.
I don't know how to go about doing this so any suggestions would be appreciated. Thank you all!