I have the below set of data in which I'm trying to create a ranking column. Specifically, I want to create a ranking based on the player's team. For example, Tyreek Hill would get a ranking of 1 and Travis Kelce would get a ranking of 2 (since he's the second-listed player on here). Additionally, in this case, Chris Godwin would get a 1 and Mike Evans would get a 2, while the rest of the players would get a 1 because they're the only one on their team listed. Here's the data:
player team 1 Michael Thomas NO 2 Davante Adams GB 3 Julio Jones ATL 4 Tyreek Hill KC 5 DeAndre Hopkins ARI 6 Travis Kelce KC 7 Chris Godwin TB 8 George Kittle SF 9 Kenny Golladay DET 10 Mike Evans TB 11 Allen Robinson CHI
Any thoughts on how to do this best?