擅长:python、mysql、java
<p>IICU</p>
<p>使df有一个常见的情况。然后使用布尔索引和np.where检查和属性</p>
<p>使用布尔索引结合np.where检查和属性</p>
<p>使用的数据帧</p>
<p><a href="https://i.stack.imgur.com/UsmYT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UsmYT.png" alt="enter image description here"/></a></p>
<pre><code>df["namematch "] = np.where((df.drop("overall_name", 1).apply(lambda x:x.str.lower())).isin(df["overall_name"].str.lower()).any(1),'match','nomatch')
#Make df have a common case. In this situation made it lower case
#df=df.apply(lambda x:x.str.lower())
# df["namematch "] = np.where(df.drop("overall_name", 1).isin(df["overall_name"]).any(1),'match','nomatch')
</code></pre>
<p>结果</p>
<p><a href="https://i.stack.imgur.com/ht1LA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ht1LA.png" alt="enter image description here"/></a></p>