Problem $4$: Diamonds Data $($Part $2)$

We will continue working with the Diamonds dataset in this problem. We will start by using sorting to identify

the most expensive diamonds in the dataset.

Sort the contents of the diamonds DataFrame in descending order by price. Use show$()$ to display the first

$5$ rows of the sorted DataFrame.

New, we will identify the largest five diamonds in the dataset.

Sort the contents of the diamonds DataFrame in descending order by carat. Use show$()$ to display the first

$5$ rows of the sorted DataFrame.

In the next two cells, we will explore the price per carat for diamonds in the dataset.

Create a code cell to complete the following tasks:

$1.$ Create a new DataFrame named diamonds$\_$ppc$.$ This DataFrame should contain all columns from

diamonds but should also contain a column named price$\_$per$\_$carat. Values in this new column

should be equal to the price of the diamond divided by the carat size, rounded to $2$ decimal places.

$2.$ Sort the contents of the diamonds$\_$ppc DataFrame in descending order by price$\_$per$\_$carat. Use

show$()$ to display the first $5$ rows of the sorted DataFrame.

In the previous cell, we identified the diamonds with the highest price per carat. We will now identify the

diamonds with the lowest.

Sort the contents of the diamonds$\_$ppc DataFrame in ascending order by price$\_$per$\_$carat. Use show$()$

to display the first $5$ rows of the sorted DataFrame.

In the last part of this problem, we will graphically explore the relationship between price$\_$per$\_$carat and

carat.

Create a code cell to complete the following tasks:

$1.$ Use the sample$()$ method to draw a sample from diamonds$\_$ppc$.$ Use fraction$=0\mathrm{.}25$ and

seed$=1.$ Convert the sample to a Pandas DataFrame and store the result in ppc$\_$ample$\_$pdf$.$

$2.$ Use the data in the sample to create a scatter plot of price$\_$per$\_$carat versus carat. When

creating the scatter plot, set alpha$=0\mathrm{.}5$ and select a named color for the points. Label the x$-$axis

"Carat" and label the y$-$axis "Price per Carat". Use plt$.$show$()$ to display the plot.