query to count duplicate records in pandas dataframe code example
Example 1: print duplicates elements in column pandas
mask = df.columnname.duplicated(keep=False)
print (df[mask])
Example 2: count how many duplicates python pandas
df.duplicated(subset='one', keep='first').sum()