w3resource

Pandas Practice Set-1: Count the number of unique values in cut series of diamonds DataFrame


34. Count Number of Unique Values in 'cut' Series

Write a Pandas program to count the number of unique values in cut series of diamonds DataFrame.

Sample Solution:

Python Code:

import pandas as pd
diamonds = pd.read_csv('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/diamonds.csv')
print("Original Dataframe:")
print(diamonds.head())
print("\nNumber of unique values in cut series of diamonds DataFrame:")
print(diamonds.cut.nunique())

Sample Output:

Original Dataframe:
   carat      cut color clarity  depth  table  price     x     y     z
0   0.23    Ideal     E     SI2   61.5   55.0    326  3.95  3.98  2.43
1   0.21  Premium     E     SI1   59.8   61.0    326  3.89  3.84  2.31
2   0.23     Good     E     VS1   56.9   65.0    327  4.05  4.07  2.31
3   0.29  Premium     I     VS2   62.4   58.0    334  4.20  4.23  2.63
4   0.31     Good     J     SI2   63.3   58.0    335  4.34  4.35  2.75

Number of unique values in cut series of diamonds DataFrame:
5

For more Practice: Solve these Related Problems:

  • Write a Pandas program to count the number of unique values in the 'cut' series using nunique().
  • Write a Pandas program to compute and print the total count of distinct diamond cuts in the DataFrame.
  • Write a Pandas program to use value_counts() and then determine the number of unique 'cut' values.
  • Write a Pandas program to display the unique count of the 'cut' column and compare it with the length of unique().

Go to:


Previous: Write a Pandas program to display the unique values in cut series of diamonds DataFrame.
Next: Write a Pandas program to compute a cross-tabulation of two Series in diamonds DataFrame.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.