Pandas loc: Multiindexing and selecting rows with specific index values

Question

I have a dataframe having 3 columns A B C

I have indexed column A,B and sorted

df = ( df.set_index([A,B]).sort_index())

I want to select rows with index A(1,2) and index B (2,3)

df1 = df.loc[[[1,2],[2,3]]]

It throws an error.. what am i doing wrong.. I did experiment with few other things and not able to come with a solution..

cs95 · Accepted Answer · 2017-10-17 00:38:02Z

1

IIUC, you use tuples, since that's how MultiIndex values are hashed (since lists cannot be hashed).

print(df.loc[[(1, 2), (2, 3)]])
      C
A B
1 2  10
2 3  20

answered Oct 17, 2017 at 0:38

cs95

406k106 gold badges744 silver badges797 bronze badges

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

1 Answer 1