擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.drop_duplicates.html" rel="nofollow noreferrer">^{<cd1>}</a></p>
<pre><code>new_df = df.drop_duplicates('Player', keep='last')
print(new_df)
</code></pre>
<p>如果要选中<code>PreviousTeam</code>,请使用:</p>
<pre><code>df.loc[~df.groupby('Player')['PreviousTeam']
.shift(-1)
.eq(df['CurrentTeam'])]
</code></pre>
<p><strong>输出</strong></p>
<pre><code> Player CurrentTeam PreviousTeam
1 David Team B Null
2 George Team C Null
4 James Team C Team B
</code></pre>