python pandas-基于包含字符串列表的列B更改列A中的值

试试这个:

In [97]: df
Out[97]:
                           genres
0  [Adventure, Animation, Comedy]
1               [Fantasy, Horror]
2                 [Comedy, Drama]
3                           [nan]
4                             NaN

In [98]: df['Comedy'] = df.genres.fillna('').apply(lambda x: len(set(x) & set(['Comedy'])) == 1)

In [99]: df
Out[99]:
                           genres  Comedy
0  [Adventure, Animation, Comedy]    True
1               [Fantasy, Horror]   False
2                 [Comedy, Drama]    True
3                           [nan]   False
4                             NaN   False

使用 in apply 如果有 list NaN s添加 fillna :

df["genres"] = df.genres.str.split("|")
df['new'] = df['genres'].fillna('').apply(lambda x: 'Comedy' in x)
print (df)
                                              genres    new
0  [Adventure, Animation, Children, Comedy, Fantasy]   True
1                     [Adventure, Children, Fantasy]  False
2                                  [Comedy, Romance]   True
3                           [Comedy, Drama, Romance]   True
4                                           [Comedy]   True
5                                                NaN  False

John Galt 对于解决方案:

df['new'] = ['Comedy' in x for x in df['genres']]

列表 使用 contains 带参数 na=False :

df['new'] = df['genres'].str.contains('Comedy', na=False)
print (df)
                                        genres    new
0  Adventure|Animation|Children|Comedy|Fantasy   True
1                   Adventure|Children|Fantasy  False
2                               Comedy|Romance   True
3                         Comedy|Drama|Romance   True
4                                       Comedy   True
5                                          NaN  False