擅长:python、mysql、java
<p>将<code>duplicated()</code>与<code>keep</code>参数一起使用为False,这允许我们识别所有重复项</p>
<pre><code>df2 = df[df.duplicated(subset=['Final Addres'],keep=False)]
print(df2)
NAME PROFILE URL Final Addres
0 ProfileA appexample.co/userxyz http://example.com
1 ProfileB appexample.co/userxyz_1 http://example.com
2 ProfileC appexample.co/userabc http://anotherexample.com
3 ProfileD appexample.co/userabc_3 http://anotherexample.com
</code></pre>