擅长:python、mysql、java
<p>IIUC,您可以执行左合并并指定仅在左数据帧中的值</p>
<pre><code>new_df = (
pd.merge(df1, df2, on=["System", "Email"], how="left", indicator=True)
.query('_merge == "left_only"')
.drop("_merge", 1)
)
print(new_df)
System Email
1 Basic anotheremail@yahoo.com
2 Backend newemail@yahoo.com
</code></pre>
<h2>细节</h2>
<pre><code>pd.merge(df1,df2,on=['System','Email'],how='left',indicator=True)
System Email _merge
0 Basic testimail@yahoo.com both # < we will drop this.
1 Basic anotheremail@yahoo.com left_only
2 Backend newemail@yahoo.com left_only
</code></pre>