count duplicates pandas 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()

Example 3: count duplicates in one column pandas

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