• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Programming Expert

Solving All of Your Programming Headaches

  • Home
  • Learn to Code
    • Python
    • JavaScript
  • Code Snippets
    • HTML
    • JavaScript
    • jQuery
    • PHP
    • Python
    • SAS
    • Ruby
  • About
You are here: Home / Python / nunique pandas – Get Number of Unique Values in DataFrame

nunique pandas – Get Number of Unique Values in DataFrame

December 20, 2021 Leave a Comment

To get the number of unique values in a pandas DataFrame or Series, the simplest way is to use the pandas nunique() function.

df["variable"].nunique()

When working with data, it’s important to be able to find the basic descriptive statistics of a set of data.

One basic descriptive statistic which is important is the number of unique values in a dataset.

To get the number of unique values in a DataFrame, we can use the pandas nunique() function.

The following code will get you the count of unique values of a series in Python:

df["variable"].nunique()

If you want to get the number of unique values of an entire DataFrame in pandas, you can call nunique() in the following way:

df.nunique()

Getting the Count of Unique Values of All Columns in DataFrame Using Pandas

Let’s say I have the following pandas DataFrame:

     Name  Weight_Change Month
0     Jim         -16.20     1
1   Sally          12.81     1
2     Bob         -20.45     1
3     Sue          15.35     1
4    Jill         -12.43     1
5   Larry         -18.52     1
6     Jim          -6.10     2   
7   Sally          -2.81     2  
8     Bob          12.45     2
9     Sue          -0.32     2
10   Jill          -1.23     2
11  Larry          -8.52     2
12    Jim           5.20     3 
13  Sally          12.81     3  
14    Bob          -2.45     3
15    Sue           5.35     3
16   Jill          -2.43     3
17  Larry          -1.85     3

We can call the nunique function on the DataFrame to get the number of unique values for all of the columns.

Below shows you how to use nunique() to count the unique values of the columns of a pandas DataFrame.

print(df.nunique())

Name              6
Weight_Change    18
Month             3
dtype: int64

Getting the Count of Unique Values of a Column Using Pandas

Let’s say we only want to get the count of unique values of a single column in a pandas DataFrame.

In the DataFrame above, let’s get the count of unique values for the column “Month”. We should expect 3, respectively.

To get the count of unique values, I can do the following in my python code:

print(df["Month"].nunique())

#Output:
3

If you want to get the count of unique values for multiple columns, you can do the following.

In the DataFrame above, let’s get the count of unique values for the columns “Month” and “Name”. We should expect 3 and 6, respectively.

To get the count of unique values of the two columns, you can do the following in your Python code:

print(df[["Month", "Name"]].nunique())

#Output:
3
6
dtype: int64

Hopefully this article has been useful for you to find the number of unique values in a pandas DataFrame using Python.

Other Articles You'll Also Like:

  • 1.  numpy pi – Get Value of pi Using numpy Module in Python
  • 2.  Python Check if Dictionary Value is Empty
  • 3.  Python Check if Attribute Exists in Object with hasattr() Function
  • 4.  Multiple Condition While Loops in Python
  • 5.  Convert String to Float with float() in Python
  • 6.  e in Python – Using Math Module to Get Euler’s Constant e
  • 7.  Python if else do nothing – Using pass Statement to Do Nothing in Python
  • 8.  Python acos – Find Arccosine and Inverse Cosine of Number
  • 9.  Write Integer to File Using Python
  • 10.  Using Python to Remove Commas from String

About The Programming Expert

The Programming Expert is a compilation of a programmer’s findings in the world of software development, website creation, and automation of processes.

Programming allows us to create amazing applications which make our work more efficient, repeatable and accurate.

At the end of the day, we want to be able to just push a button and let the code do it’s magic.

You can read more about us on our about page.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

About The Programming Expert

the programming expert main image

Welcome to The Programming Expert. We are a group of US-based programming professionals who have helped companies build, maintain, and improve everything from simple websites to large-scale projects.

We built The Programming Expert to help you solve your programming problems with useful coding methods and functions in various programming languages.

Search

Learn Coding from Experts on Udemy

Looking to boost your skills and learn how to become a programming expert?

Check out the links below to view Udemy courses for learning to program in the following languages:

Copyright © 2023 · The Programming Expert · About · Privacy Policy