how to check distinct values in a column in python code example
Example 1: how to get distinct value in a column dataframe in python
df.column.unique()
Example 2: pandas count distinct values in a column
Series.value_counts(self, normalize=False, sort=True, ascending=False, bins=None, dropna=True)
Example 3: pandas count distinct values in column
#column name ISSDTM
pd.to_datetime(df.ISSDTM, errors='coerce').dt.year
#result
0 2013
1 2013
2 2009
3 2009
Name: ISSDTM, dtype: int64