AttributeError when accessing MultiIndex of pandas dataframe

Question

I have the following dataframe:

df1 = pd.DataFrame(np.random.randint(80, 120, size=(4,2)),
                   index=pd.MultiIndex.from_product([['English', 'Japanese'], ['like', 'dislike']]),
                   columns=['girl', 'boy']
                   )
print(df1)

How can I access just the English rows? This does not work:

print(df1.English)  # there I get error: AttributeError: 'DataFrame' object has no attribute 'English'

tdy · Accepted Answer · 2021-11-30 13:32:23Z

1

English is part of the row index, but df.English tries to access a column.
The row index is a MultiIndex, so it should be indexed as a tuple of (language, dis/like).

To select the English rows, use xs to get the cross-section:

df1.xs('English')

#          girl  boy
# like       87   91
# dislike    95   89

Or in this case, loc also works since the language is the first level of the MultiIndex:

df1.loc['English']

#          girl  boy
# like       87   91
# dislike    95   89

edited Nov 30, 2021 at 13:32

answered Nov 30, 2021 at 12:22

tdy

42k42 gold badges124 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AttributeError when accessing MultiIndex of pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related