df1 = pd.DataFrame({"fields": [["boy", "apple", "toy", "orange", "bear", "eat"],
["orange", "girl", "red"]]})
df2 = pd.DataFrame({"other fields": [["boy", "girl", "orange"]})
我想在df1中添加一列,指示字段与其他字段重叠的情况, 样本输出:
|fields| overlap?|
|------|---------|
|boy |Y
|apple |N
|toy |N
|orange|Y
|bear |N
|eat |N
|orange|Y
|girl |Y
|red |N
首先,我将在df1上分解字段,但我不确定检查两个数据框之间重叠值的下一步是什么。谢谢!