Pandas Practice Set-1: Sort a Series by its values and index of diamonds DataFrame
Pandas Practice Set-1: Exercise-46 with Solution
Write a Pandas program to sort a Series by its values and index 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("\nSeries sorted by its values:")
print(diamonds.cut.value_counts().sort_values())
print("\nSeries sorted by its index:")
print(diamonds.cut.value_counts().sort_index())
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 Series sorted by its values: Fair 1610 Good 4906 Very Good 12082 Premium 13791 Ideal 21551 Name: cut, dtype: int64 Series sorted by its index: Fair 1610 Good 4906 Ideal 21551 Premium 13791 Very Good 12082 Name: cut, dtype: int64
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous:Write a Pandas program to access a specified Series index and the Series values of diamonds DataFrame.
Next: Write a Pandas program to calculate the multiply of length, width and depth for each cut of diamonds DataFrame.
What is the difficulty level of this exercise?
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/python-exercises/pandas/practice-set1/pandas-practice-set1-exercise-46.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics