take the last no duplicate rows pandas code example
Example 1: python: remove duplicate in a specific column
df = df.drop_duplicates(subset=['Column1', 'Column2'], keep='first')
Example 2: get duplicate and remove but keep last in python df
drop_duplicates(self, subset=None, keep="last", inplace=False)