python判断某列有值_python – Pandas Dataframe检查列值是否在列列表中

使用申请：

df['flag'] = df.apply(lambda x: int(x['id'] in x['idlist']), axis=1)

print (df)

id idlist flag

0 12 [1, 5, 7, 12, 112] 1

1 112 [5, 7, 12, 111, 113] 0

类似：

df['flag'] = df.apply(lambda x: x['id'] in x['idlist'], axis=1).astype(int)

print (df)

id idlist flag

0 12 [1, 5, 7, 12, 112] 1

1 112 [5, 7, 12, 111, 113] 0

使用列表理解：

df['flag'] = [int(x[0] in x[1]) for x in df[['id', 'idlist']].values.tolist()]

print (df)

id idlist flag

0 12 [1, 5, 7, 12, 112] 1

1 112 [5, 7, 12, 111, 113] 0

过滤解决方案：

df = df[df.apply(lambda x: x['id'] in x['idlist'], axis=1)]

print (df)

id idlist

0 12 [1, 5, 7, 12, 112]

df = df[[x[0] in x[1] for x in df[['id', 'idlist']].values.tolist()]]

print (df)

id idlist

0 12 [1, 5, 7, 12, 112]