You can get the count distinct values (equivalent to SQL count(distinct) ) in pandas using DataFrame.groupby(), nunique(), DataFrame.agg(), DataFrame.transform(), pandas.crosstab(), Series.value_counts() and pandas.pivot_table() method. In Pandas, you can use groupby()…