查找 ia strn 列在同一數據框中的列表列中，並創建具有值的第三列 (Find ia a strn column is in a list column in the same data frame and create a 3rd column with a value)

問題描述

查找 ia strn 列在同一數據框中的列表列中，並創建具有值的第三列 (Find ia a strn column is in a list column in the same data frame and create a 3rd column with a value)

我有這個包含 2 列的數據框，“Column A” 和“B列”，A列是一個字符串，B列是一個列表：

A        B                               c
cat      | cat | elephant | gorilla |    YES
dog      | monkey | duck | giraffe |     NO
bird     | cow | bird | hamster |        YES

我想評估A列是否在B列中如果是這樣在這個新列 C 中寫“是”或“否”

我嘗試了很多方法，最後一個是：

df_epl["Marketo LSC"] = df_epl["Data Entry Point"].isin("Entry Point List")

但它給了我這個錯誤：

in isin

raise TypeError(TypeError: only list‑like objects are allowed to be passed to isin(), you passed a [str]

參考解法

方法 1:

Try this

import pandas as pd
df = pd.read_csv('res.csv') #Your csv here
C = []
for i in range(0,len(df)):
  if df['A'][i] in df['B'][i]:
    C.append('YES')
  else:
    C.append('NO')
df['C'] = C
print(df)

(by Berny、SURYA TEJA)

參考文件

1. Find ia a strn column is in a list column in the same data frame and create a 3rd column with a value (CC BY‑SA 2.5/3.0/4.0)