Index into dataframe by column value

Question

I have a dataframe and I want to access certain entries based on particular column values. For example...the data frame has four columns 'A, B, C, D'

I want to grab a particular entry where 'A=1' and another where 'B=42'. Is there an easy way to do this?

joris · Accepted Answer · 2014-03-21 21:39:32Z

3

This is called boolean indexing, where you slice the dataframe based on a condition:

df[df['A']==1]

or if both have to be true:

df[(df['A']==1) & (df['B']==42)]

answered Mar 21, 2014 at 21:39

joris

140k37 gold badges257 silver badges207 bronze badges

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

1 Answer 1