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