Problem $2$

Download the data 'auto.csv darr $\text{'}$ to your Week $2$ folder. Load the auto data and name it auto.

Find the length and the shape of auto.

Drop the missing values and name the data auto again $($Hint: auto$=$auto.dropna$()).$

Find the column names of auto.

Find the first $20$ rows of auto.

Select columns 'car', 'cylinders' and $\text{'}$mpg$\text{'}.$

Select the cell at the third row $($row $2)$ and the fifth column $5($column $4)$

Select the data from row $30$ to row $100$ within the columns $\text{'}mpg\text{'}$ and 'car'

Sort auto by 'origin' and 'cylinders'

Drop auto columns 'displacement', 'weight', 'acceleration', and 'model', and name the remaining data as $\text{'}$my$\_$auto'

In the data table my$\_$auto, select the rows by the two conditions: origin is US and mpg greater than $30,$ and name the selected rows as 'piece $1\text{'}$

In the data table my$\_$auto, select the rows by the two conditions: origin is Japan and mpg greater than $30,$ and name the selected rows as 'piece $2\text{'}$

Merge piece $1$ and piece $2$ along rows, name the merged data as 'auto$\_$new', and save it to 'auto$\_$new.xlsx$\text{'}$

Group auto$\_$new by 'origin' and 'cylinders', and calculate the mean of other numerical columns.