python - Pandas 搜索字符串的特定列

Question

我正在尝试搜索我的 DataFrame 中的特定列。如果这些列中的任何一个包含关键字“匹配”，那么我想用"is"写入“结果”列

当前方向

Result Google    Bing    Search
       Matched   Matched Matched

       Matched   
                         Matched

预期结果

Result Google    Bing    Search
 Yes   Matched   Matched Matched
 No   
 Yes   Matched   
 Yes                     Matched

Answer 1

使用numpy.where测试值由 DataFrame.eq与 DataFrame.any每行至少测试一个值:

cols = ['Google', 'Bing', 'Search']
df['Result'] = np.where(df[cols].eq('Matched').any(axis=1), 'Yes','No')
print (df)
  Result   Google     Bing   Search
0    Yes  Matched  Matched  Matched
1     No      NaN      NaN      NaN
2    Yes  Matched      NaN      NaN
3    Yes      NaN  Matched      NaN