Consider data given in $$HW$2\_$Data$\_$A$$ Microsoft Excel Comma Separated Values $(.$csv$)$ file about laptop prices.

Using the given data, do the tasks given below. A$1.(3$ points$)$ Read the data $($Assume the first row in $"$HW$2\_$Data$\_$A$"$ contains the column headings$).$ Display:

$($i$)10$ randomly selected rows

$($ii$)15$ last rows for all columns

A$2.(5$ points$)$ Create a new dataframe named ISE$291$ by selecting the first $25$ rows from column$-4($processor$\_$name$)$ to column$-11($ssd$).$ Then, sort the first column of the new dataframe in ascending order and the second column of the new dataframe in descending order.

A$3.(4$ points$)$ Considering the new dataframe from part $2,$ display the separate statistical summary for numerical and non$-$numerical columns

A$4.(6$ points$)$ From the original dataset $"$HW$2\_$Data$\_$A$",$ how many laptops have an 'AMD' processor with $\text{'}4$ GB$\text{'}$ of RAM and a price below $5000?$

A$5.(5$ points$)$ Add a new column $($Int$\_$Price$)$ by converting 'Price' column values from float to nearest integer using the $.$apply$()$ method and a custom function. $[$Note: using lambda function is not allowed$]$

A$6.(3$ points$)$ Display the box$-$plot for the "price" column, and differentiate by $*$processor$\_$brand$*$ column.

A$7.(8$ points$)$ For all laptops priced above $30,000,$ plot a countplot showing their 'processor$\_$name', and differentiate by 'brand' column.

$($i$)$ How many processors were actually found?

$($ii$)$ What can you conclude from the plot?

A$8.(8$ points$)$ Display the countplot showing the memory size 'ram$\_$gb$\text{'}$ differentiated by 'processor$\_$name'.

$($i$)$ What is the most commonly available memory size?

$($ii$)$ Which brand of processors has the largest memory size?

A$9.(8$ points$)$ Plot the violinplot for the companies acer, ASUS, and HP$.$ Display the 'Price' vs 'Touchscreen', and differentiate w$.$r$.$t 'brand' columns.

$($i$)$ For HP brand, compare their product with respect to the reported median value?

$($ii$)$ Which company has the lowest price for touchscreen type in terms of the median value?