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?