pandas find count of unique values in column code example
Example 1: count unique pandas
df['column'].nunique()
Example 2: get count of unique values in column pandas
df = df.groupby('domain')['ID'].nunique()
print (df)
domain
'facebook.com' 1
'google.com' 1
'twitter.com' 2
'vk.com' 3
Name: ID, dtype: int64
Example 3: how to count unique values in a column dataframe in python
dataframe.column.nunique()
Example 4: count how many unique rows a DataFrame has
df = pd.DataFrame(np.random.randint(0,2,size = (10,3)))
df
0 1 2
0 1 1 1
1 1 0 1
2 1 1 1
3 1 0 0
4 1 1 1
5 1 0 1
6 0 0 1
7 0 1 1
8 0 1 0
9 0 0 1
df.duplicated(keep = False) == False
0 False
1 False
2 False
3 True
4 False
5 False
6 False
7 True
8 True
9 False
dtype: bool
sum(df.duplicated(keep = False) = False)
3