KeyError while accessing multi index dataframe in Pandas

Question

I have the following dataframe having "Location" and "Name" as the index.

Location  Name   Cost   Item Purchased                
Store 1   Chris  22.5   Dog Food
          Kevyn   2.5   Kitty Litter
Store 2   Vinod   5.0   Bird Seed

I can access df.loc["Store 1"] But df.loc["Store 1"]["Kevyn"] is giving me KeyError. What am I doing wrong?

pass a tuple df.loc[("Store 1","Kevyn")], see the docs pandas.pydata.org/pandas-docs/stable/… — EdChum
– EdChum, Commented Feb 22, 2017 at 16:56

miradulo · Accepted Answer · 2017-02-22 16:57:11Z

3

You're using some incorrect chained indexing here, where you want to be indexing both levels of the MultiIndex with something like

df.loc['Store 1', 'Kevyn']

See Basic indexing on axis with MultiIndex in the docs.

answered Feb 22, 2017 at 16:57

miradulo

29.8k7 gold badges86 silver badges97 bronze badges

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

Comments

EdChum · Accepted Answer · 2019-08-02 10:26:35Z

1

You need to pass a tuple:

In [100]:
df.loc[('Store 1', 'Kevyn'),:]

Out[100]:
Cost                       2.5
Item Purchased    Kitty Litter
Name: (Store 1, Kevyn), dtype: object

The docs detail how to index

edited Aug 2, 2019 at 10:26

answered Feb 22, 2017 at 17:01

EdChum

397k204 gold badges836 silver badges583 bronze badges

1 Comment

Robert Over a year ago

In fact, you should use df.loc[('Store 1', 'Kevyn'),:] in order to avoid misinterpretations, cf. pandas.pydata.org/pandas-docs/stable/user_guide/…

Collectives™ on Stack Overflow

KeyError while accessing multi index dataframe in Pandas

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related