indexing subsets within a column of a pandas dataframe

Question

df is a pandas dataframe.

this gives me my young subjects:

df_young = df[df['Age']<40]

this gives me my old subjects:

df_old = df[df['Age']>60]

Now I want to get my middleaged subjects with something like (invalid syntax):

df_middleage = df[df['Age']< 40 and < 60]

Does anyone know how to do that efficiently? Thanks.

joris · Accepted Answer · 2015-04-14 11:07:56Z

3

You can use &:

df_middleage = df[(df['Age'] > 40) & (df['Age'] < 60)]

answered Apr 14, 2015 at 10:19

joris

140k37 gold badges258 silver badges207 bronze badges

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

1 Comment

Thank you. That works - but the greater-than signs should be like that: df_middleage = df[(df['Age']> 40) & (df['Age']< 60)] to get the middleaged