How to find maximum within dataset from two grouped columns

Asked Apr 12 '19 at 17:32

Active Apr 12 '19 at 17:40

Viewed 18 times

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

edited Apr 12 '19 at 17:40

Cohan

4,384
2
22
40

asked Apr 12 '19 at 17:32

MUHAMMAD AHMAD L1F14BSCS0435

Have you tried this? https://stackoverflow.com/questions/15705630/python-getting-the-row-which-has-the-max-value-in-groups-using-groupby – Cohan Apr 12 '19 at 17:38
Is this a pd.Series or pd.DataFrame? Do you have multiindex for the index of your dataframe? – Scott Boston Apr 12 '19 at 17:41
1

df.groupby(level=0).idxmax() – BENY Apr 12 '19 at 17:41

How to find maximum within dataset from two grouped columns

0 Answers0