Search for a row in a dataframe containing a string from a list

Question

I am trying to search for the row of which contains a string within a list.

df:

           Column1            Out1
0          ['x', 'y']         (0, 2)
1          ['a', 'b']         (3, 0)
etc.

I have attempted the following to search for the row that contains 'a' in a list under Column1, as suggested in this answer:

print df['Column1'].isin(['a'])

With the expectation of such an outcome:

1         ['a', 'b']          (3, 0)

However, I seem to be receiving the following error:

TypeError: unhashable type: 'list'

jezrael · Accepted Answer · 2017-10-12 15:52:29Z

3

Need in for check values in lists:

df = df[df['Column1'].apply(lambda x: 'a' in x)]

Sample:

df = pd.DataFrame({'Column1':[['x','y'], ['a','b']],
                   'Out1':[(0,2), (3,0)]})
print (df)
  Column1    Out1
0  [x, y]  (0, 2)
1  [a, b]  (3, 0)

df1 = df[df['Column1'].apply(lambda x: 'a' in x)]
print (df1)
  Column1    Out1
1  [a, b]  (3, 0)

df1 = df[['a' in x for x in df['Column1']]]
print (df1)
  Column1    Out1
1  [a, b]  (3, 0)

answered Oct 12, 2017 at 15:52

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Enigmatic Over a year ago

Awesome. Thanks again! ;)

Enigmatic Over a year ago

Is one advantageous over another in any way?

jezrael Over a year ago

Hard question, second should be a bit faster, but failed if NaNs.

Minions · Accepted Answer · 2018-12-05 15:34:07Z

0

What you did in the beginning is correct:

df['Column1'].isin(['a'])

but you to wrap it with square brackets of the same dataframe.

here is an example:

threads = ['1111', '2222', '3333', '4444']
dev_data = train[(train['thread_col'].isin(threads))]

(dev_data) is a dataframe contains the results' rows.

answered Dec 5, 2018 at 15:34

Minions

5,5376 gold badges56 silver badges105 bronze badges

Collectives™ on Stack Overflow

Search for a row in a dataframe containing a string from a list

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related