w3resource

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


33. Display Unique Values in 'cut' Series

Write a Pandas program to display the 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("\nDisplay the unique values in cut series of diamonds DataFrame:")
print(diamonds.cut.unique())

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

Display the unique values in cut series of diamonds DataFrame:
['Ideal' 'Premium' 'Good' 'Very Good' 'Fair']

For more Practice: Solve these Related Problems:

  • Write a Pandas program to extract and display the unique values present in the 'cut' column.
  • Write a Pandas program to use the unique() function on the 'cut' series and then count the number of unique values.
  • Write a Pandas program to list all distinct diamond cuts from the DataFrame and sort them alphabetically.
  • Write a Pandas program to retrieve unique values from the 'cut' column and then verify their data types.

Python Code Editor:

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

Previous: Write a Pandas program to display percentages of each value of cut series occurs in diamonds DataFrame.
Next: Write a Pandas program to count the number of unique values in cut series of diamonds DataFrame.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.