df.loc[df['column_name'] == some_value]
details in:
http://stackoverflow.com/questions/17071871/select-rows-from-a-dataframe-based-on-values-in-a-column-in-pandas