w3resource

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?



Follow us on Facebook and Twitter for latest update.