pandas check if duplicates in column keep the latter code example
Example: count duplicates in one column pandas
df.pivot_table(index=['DataFrame Column'], aggfunc='size')
df.pivot_table(index=['DataFrame Column'], aggfunc='size')