PYTHON

count duplicate rows in python

import pandas as pd

#print how many duplicate rows in the dataframe
print(df.duplicated().sum())

count how many duplicates python pandas

df.duplicated(subset='one', keep='first').sum()

pandas duplicated rows count

import pandas as pd

# Shows count of all the rows with duplicate values

df.duplicated(keep=False).sum()

check for duplicates in a pandas Series

animals = pd.Series(['lama', 'cow', 'lama', 'beetle', 'lama'])
>>> animals.duplicated()

pandas count duplicateds

In [28]:
df.groupby(df.columns.tolist(),as_index=False).size()

Out[28]:
one    three  two  
False  False  True     1
True   False  False    2
       True   True     1
dtype: int64