Answers for "pandas find duplicates keep one"

keep only one duplicate in pandas

import pandas as pd
df = pd.DataFrame({"A":["foo", "foo", "foo", "bar"], "B":[0,1,1,1], "C":["A","A","B","A"]})
df.drop_duplicates(subset=['A', 'C'], keep=False)

count duplicates in one column pandas

df.pivot_table(index=['DataFrame Column'], aggfunc='size')