Given that the academic$-$staff salaries dataset, which is stored as$"$Salaries$.$csv$"$ file. The dataset is Given that the academic$-$staff salaries dataset, which is stored as$"$Salaries$.$csv$"$ file. The dataset is

located on the Google Drive and contained inside:

My Drive$/$datasets$/$csV

The $1$st line looks like:

rank, discipline, phd$,$service, sex,salary

Prof, B$,56,49,$Male, $186960$

The dataset looks like

Answer the following questions:

A$)$ Write the code necessary to load the file into a DataFrame sal$\_$df $($include all

steps$)?$

B$)$ Write the code necessary to create a subset DataFrame for the column rank? Answer the following questions:

A$)$ Write the code necessary to load the file into a DataFrame sal$\_$df $($include all

steps$)?$

B$)$ Write the code necessary to create a subset DataFrame for the column rank?

C$)$ Make a copy from the sal$\_$df above, then write the steps necessary to drop Missing

values from the DataFrame?

D$)$ In one line of code, find the max salary for each professor rank?

located on the Google Drive and contained inside:

My Drive$/$datasets$/$csv

The $1$st line looks like:

rank, discipline, phd$,$ service, sex, salary

Prof, B$,56,49,$ Male, $186960$

The dataset looks like

rank discipline phd service

$0$ AssocProf

$1$

Prof

$2$

Prof

$3$

Prof

$4$ AsstProf

$5$

Prof

$6$

Prof

$7$ AssocProf

$8$ AsstProf

$9$ AsstProf

$10$

Prof

$11$

Prof

$12$

AsstProf

$13$ AssocProf

$14$

Prof

B

B

$12$

$28$

$45$

$20$

$4$

$18$

$13$

$23$

$25$

$11$

$11$

$17$

sex

salary

Male $119800\mathrm{.}0$

$23$

$45$

Male $126933\mathrm{.}0$

Male $146856\mathrm{.}0$

$8$ Male $102000\mathrm{.}0$

$3$ Male $91000\mathrm{.}0$

$18$ Female $129000\mathrm{.}0$

$36$ Female $137000\mathrm{.}0$

$8$ Female $74830\mathrm{.}0$

$2$ Female $80225\mathrm{.}0$

$0$ Female $77000\mathrm{.}0$

$19$ Female $151768\mathrm{.}0$

$25$ Female $140096\mathrm{.}0$

$3$ Female $74692\mathrm{.}0$

$11$ Female $103613\mathrm{.}0$

$17$ Female

NaN

Answer the following questions:

A$)$ Write the code necessary to load the file into a DataFrame sal$\_$df $($include all steps$)?$

B$)$ Write the code necessary to create a subset DataFrame for the column rank?

C$)$ Make a copy from the sal$\_$df above, then write the steps necessary to drop Missing values from the DataFrame?

D$)$ In one line of code, find the max salary for each$$professor$$rank$?$