How do I check if a string exists within a string within a column

Question

What I want to do I figured would look like this:

(t in df[self.target]).any()

But I am getting:

AttributeError: 'bool' object has no attribute 'any'

`(t in df[self.target])` returns a boolean object, `True` or `False`, for whether or not t is in that iterator. — Keozon, Aug 04 '16 at 21:37

score 4 · Accepted Answer · answered Aug 04 '16 at 22:52

4

You can use Pandas str methods (docs).

df[self.target].str.contains(t).any()

answered Aug 04 '16 at 22:52

Alex

Asish M. · Answer 2 · 2016-08-04T22:04:13.893

0

I'm assuming it's a pandas DataFrame. Try this

(df[self.target] == t).any()

EDIT:

any((t in k for k in df[self.target]))

edited Aug 04 '16 at 22:04

answered Aug 04 '16 at 21:42

Asish M.

This returns True if there is an exact match "foo" == "foo", but will not catch the case where "foo" in "foobar". – birdmw Aug 04 '16 at 21:51
edit: AttributeError: 'generator' object has no attribute 'any' – birdmw Aug 04 '16 at 22:02

2 Answers2