Check whether a string is contained in a element (list) in Pandas

Question

I've got a pandas dataframe with the column 'Friends'. All elements in the column friends are list object. Example of a row in the column 'friends':

['erik', 'jason', 'eduard']

I want to return a dataframe in which I check whether eduard is the list. This is my example code:

df[df.friends.isin(['eduard'])

Help a cat out please

Answer 1

You need apply in this case, use the normal in operator to check if list contains eduard:

df[df.friends.apply(lambda x: 'eduard' in x)]

Example:

df = pd.DataFrame({"friends": [['erik', 'jason', 'eduard'], ['erik', 'jason']]})

df[df.friends.apply(lambda x: 'eduard' in x)]
#                 friends
#0  [erik, jason, eduard]