pandas read number of duplicates code example

Example 1: print duplicates elements in column pandas

mask = df.columnname.duplicated(keep=False)
print (df[mask])

Example 2: count duplicates in one column pandas

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