Pandas Practice Set-1: Sort the 'price' Series in descending order of diamonds Dataframe
Write a Pandas program to sort the 'price' Series in descending order (returns a 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("\nprice Series in descending order :")
result = diamonds.price.sort_values(ascending=False)
print(result)
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 price Series in descending order : 27749 18823 27748 18818 27747 18806 27746 18804 27745 18803 27744 18797 27743 18795 27742 18795 27741 18791 27740 18791 27739 18788 27738 18787 27737 18784 27736 18781 27735 18780 27734 18779 27733 18777 27732 18768 27731 18766 27730 18760 27729 18759 27728 18757 27727 18756 27726 18745 27725 18741 27724 18741 27723 18741 27722 18736 27721 18735 27720 18731 28264 357 28261 357 28262 357 26 355 25 354 24 353 22 353 23 353 21 352 20 351 19 351 18 351 17 351 16 348 14 345 15 345 13 344 12 342 11 340 10 339 9 338 8 337 7 337 6 336 5 336 4 335 3 334 2 327 1 326 0 326 Name: price, Length: 53940, 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 sort the 'cut' Series in ascending order (returns a Series) of diamonds Dataframe.
Next: Write a pandas program to sort the entire diamonds DataFrame by the ‘carat’ Series in ascending and descending order.
What is the difficulty level of this exercise?
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics