subset rows of pandas dataframe by string match on column

Question

pool is a dataframe, and one of the columns is "Name" If key == 'Bob', then this line correctly gives me all the rows where Name=='Bob':

keyrows = pool[key == pool.Name]

I instead want to get all the rows that match 'Bob', like "Bob Jones" and "Bob Marley", etc.

So I changed '==' to 'in', but it doesn't work as I expected:

keyrows = pool[key in pool.Name]

I get KeyError: False

Any help would be much appreciated.

TPM · Accepted Answer · 2015-11-22 16:47:21Z

6

@behzad.nouri gave me the solution:

keyrows = pool[pool.Name.str.contains(key)]

does exactly what I want.

answered Nov 22, 2015 at 16:47

TPM

9144 gold badges10 silver badges21 bronze badges

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

1 Answer 1