How To Count Distinct Values Of A Column?
Table Of Contents:
- Syntax Of ‘nunique( )’ Method In Pandas.
- Examples ‘nunique( )’ Method.
(1) Syntax:
DataFrame.nunique(axis=0, dropna=True)
Description:
- Count the number of distinct elements in the specified axis.
- Return Series with the number of distinct elements. Can ignore NaN values.
Parameters:
- axis {0 or ‘index’, 1 or ‘columns’}, default 0 –
- The axis to use. 0 or ‘index’ for row-wise, 1 or ‘columns’ for column-wise.
- dropna: bool, default True –
- Don’t include NaN in the counts.
Returns:
- Series
(2) Examples Of nunique() Method:
Example-1
import pandas as pd
student = {'Name':['Subrat','Abhispa','Arpita','Anuradha','Namita'],
'Roll_No':[100,101,102,103,104],
'Subject':['Math','English','Science','History','Commerce'],
'Mark':[95,88,76,73,93],
'Gender':['Male','Female','Female','Female','Female']}
student_object = pd.DataFrame(student)
student_object
Output:
# Describing Student DataFrame.
student_object.nunique()
Output:
Name 5
Roll_No 5
Subject 5
Mark 5
Gender 2
dtype: int64