count is unique pandas code example

Example 1: values of unique from dataframe with count

data = df.groupby('ColumnName')['IDColumnName'].nunique()
print(data)

Example 2: dataframe number of unique rows

1
# get the unique values (rows) by retaining last row
2
df.drop_duplicates(keep='last')