I have two columns Pclass and Embarked. I want to know every class's highest Embarked category. E. g
Pclass Embarked
1 C 85
Q 2
S 127
2 C 17
S 3
Q 164
3 S 66
Q 72
C 353
PClass 1 highest Embarked in S
PClass 2 highest Embarked in Q
PClass 3 highest Embarked in C