擅长:python、mysql、java
<p>与新行保持一致</p>
<pre><code>#Check column which is a concat of System and Email
userdf['check']=userdf.System.str.cat(userdf.Email)
importdf['check']=importdf.System.str.cat(importdf.Email)
</code></pre>
<p>#{<cd1>}te</p>
<pre><code> res=userdf.assign(filter=np.where([x not in y for x, y in zip(userdf.check,importdf.check)],'drop','keep')).drop(columns=['check'])
print(res)
System Email filter
1 Basic testimail@yahoo.com keep
2 Backend anotheremail@yahoo.com drop
3 Basic newemail@yahoo.com drop
</code></pre>