df = pd.DataFrame({'column_a':['ga lt','ka','ku','na ma',np.nan, np.nan],
'column_b':['se','ga','ma po','na','ka ch', 'wa wo']})
vals = [y for x in df['column_b'] for y in x.split()]
mask = df['column_a'].str.split(expand=True).isin(vals).any(axis=1)
df = df.loc[mask, 'column_a'].to_frame('column_a_in_column_b')
print (df)
column_a_in_column_b
0 ga lt
1 ka
3 na ma
检查^{} 按^{} 拆分的第一列的值和第二列的扁平拆分值,并按^{} 获得每行至少一个} ,如有必要,按^{} 创建一列
True
值,通过筛选第一列传递到^{Dataframe
:相关问题 更多 >
编程相关推荐