Pandas Practice Set-1: Sort the 'price' Series in descending order of diamonds Dataframe
Pandas Practice Set-1: Exercise-13 with Solution
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?
Python: Tips of the Day
Find current directory and file's directory:
To get the full path to the directory a Python file is contained in, write this in that file:
import os dir_path = os.path.dirname(os.path.realpath(__file__))
(Note that the incantation above won't work if you've already used os.chdir() to change your current working directory, since the value of the __file__ constant is relative to the current working directory and is not changed by an os.chdir() call.)
To get the current working directory use
import os cwd = os.getcwd()
Documentation references for the modules, constants and functions used above:
- The os and os.path modules.
- The __file__ constant
- os.path.realpath(path) (returns "the canonical path of the specified filename, eliminating any symbolic links encountered in the path")
- os.path.dirname(path) (returns "the directory name of pathname path")
- os.getcwd() (returns "a string representing the current working directory")
- os.chdir(path) ("change the current working directory to path")
Ref: https://bit.ly/3fy0R6m
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework