擅长:python、mysql、java
<p>示例数据:</p>
<pre><code>df1 = pd.DataFrame(['Cleared', 'Validating', 'Pending', 'Cleared', 'Blocked', 'Blocked'], index = [1234, 5678, 4321, 8765, 9876, 6789], columns=['Status'])
df1.index.name = 'ID'
df2 = pd.DataFrame(['Blocked', 'Validating', 'Pending', 'Cleared', 'Validating', 'Blocked'], index = [1234, 5678, 4321, 8765, 9876, 6789], columns = ['Status'])
df2.index.name = 'ID'
</code></pre>
<p>联接<code>df1</code>和<code>df2</code>为联接的数据帧上的列提供后缀</p>
<pre><code>df = df1.join(df2, lsuffix='_1', rsuffix='_2')
</code></pre>
<p>然后使用布尔索引</p>
<pre><code>df[df.Status_1 != df.Status_2]
</code></pre>