generate unique id based on one column sequential values pandas code example

Example 1: values of unique from dataframe with count

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

Example 2: dataframe unique values in each column

for col in df:
    print(df[col].unique())