So I want to filter a column of lists which should only contain specific items.

This my original table:

I want the rows which only have specific items in the lists: Hes3440, Nee8900, Hes3220

Which should generate the following output:

I am able to filter the dataset by making sure that at least one of the desired items is in each row, but this is not what I want.

Would appreciate any help!

thanks, M

CodePudding user response：

Use issubset in boolean indexing with Series.map:

L = ['Hes3440','Nee8900','Hes3220']

df = df[df.code.map(lambda x: set(x).issubset(L))]
print (df)
   id                         code
1   2           [Hes3440, Nee8900]
3   4           [Nee8900, Hes3440]
5   6           [Hes3220, Nee8900]
6   7  [Hes3220, Nee8900, Hes3440]

List comprehension alternative:

df = df[[set(x).issubset(L) for x in df.code]]