擅长:python、mysql、java
<p>在<code>sort_values</code>之后使用<code>drop_duplicated</code></p>
<pre><code>df.date=pd.to_datetime(df.date,dayfirst=True)
yourdf=df.sort_values('date').drop_duplicates('year',keep='last')
yourdf
Out[413]:
year date id
0 2017 2017-01-01 72297143
1 2018 2018-04-22 6de190ee
4 2019 2019-12-03 7d81a711
yourdf.drop('id',axis=1,inplace=True)
</code></pre>