删除重复的 pandas df

尝试使用 DataFrame.drop_duplicates 参数但没有成功，因为重复项没有被删除.

Trying use the DataFrame.drop_duplicates parameters but without luck as the duplicates are not being removed.

希望根据inc_id"列删除.如果在该列中找到重复项，则应仅保留最后一行.

Looking to remove based on column "inc_id". If find duplicates in that column should keep only the last row.

我的 df 是:

    inc_id  inc_cr_date
0   1049670 121
1   1049670 55
2   1049667 121
3   1049640 89
4   1049666 12
5   1049666 25

输出应该是:

    inc_id  inc_cr_date
0   1049670 55
1   1049667 121
2   1049640 89
3   1049666 25

代码是:

df = df.drop_duplicates(subset='inc_id', keep="last")

知道我在这里遗漏了什么吗?谢谢.

Any idea what am I missing here? Thanks.