Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages, and makes importing and analyzing data much easier.
While analyzing the data, many times the user wants to see the unique values in a particular column, which can be done using Pandas unique() function.
To download the CSV file used, Click Here.
Syntax: Series.unique()
Return Type: Numpy array of unique values in that column
Example #1: Using Series.unique()
In this example, unique() method is used to know all type of unique values in Team column.
# importing pandas packageimport pandas as pd # making data frame from csv filedata = pd.read_csv("employees.csv") # storing unique value in a variablearr = data["Team"].unique() # printing arrayprint(arr) |
Output:
As shown in the output image, an array with all of the unique values in the column is returned.
Error and Exceptions:
- This method works only on series and not on Data Frames
- As shown in the output, this method includes NULL value as a unique value.
