<p>我有两个数据帧<code>DfMaster</code>和<code>DfRemove</code></p>
<p><code>DfMaster</code>看起来像:</p>
<pre><code> Id Name Building
0 4653 Jane Smith A
1 3467 Steve Jones B
2 34 Kim Lee F
3 4567 John Evans A
4 3643 Kevin Franks S
5 244 Stella Howard D
</code></pre>
<p><code>DfRemove</code>看起来像:</p>
<pre><code> Id Name Building
0 4567 John Evans A
1 244 Stella Howard D
</code></pre>
<p>如果记录出现在<code>DfRemove</code>,我想从<code>DfMaster</code>中删除它们。所以这个例子中我的新<code>DfMaster</code>看起来像:</p>
<pre><code> Id Name Building
0 4653 Jane Smith A
1 3467 Steve Jones B
2 34 Kim Lee F
3 3643 Kevin Franks S
</code></pre>
<p>约翰和斯特拉被带走的地方</p>
<p>我试过:</p>
<pre><code>DfMaster [DfMaster [~DfRemove [id]]]
</code></pre>
<p>没有成功</p>
<p>如果记录出现在<code>DfRemove</code>中,有人能告诉我如何从<code>DfMaster</code>中删除记录吗</p>
<p>你就快到了,只要做:</p>
<pre><code>DfMaster= DfMaster[~DfMaster.Id.isin(DfRemove.Id)]
</code></pre>
<p>输出:</p>
<pre><code> Id Name Building
0 4653 Jane Smith A
1 3467 Steve Jones B
2 34 Kim Lee F
3 3643 Kevin Franks S
</code></pre>