count not duplicated values in a complete dataframe not just column 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')