Download the data set social$\_$indicator.txt from Module $8$ in Canvas.

Read it with python. Set the first column as the index when reading the file. $(1$ point$).$

Sort the row index into ascending order. $(1$ point$)$

Sort the column index lexicographically. $(1$ point$)$

Make a column west with True and False values indicating whether the region is west. Then

delete the original region column. $(1$ point$)$Suppose we are not interested in studying fertility rate $($totalfertilityrate$)$ and contraception $($contraception$).$ Drop these two columns. $(1$ point$)$

Which variable is the most correlated with GDP per capita? Which variable is the least correlated with GDP per capita? $(1$ point$)$

Use the column geographic$\_$location to create a new column called continent. Merge the values of the geographic$\_$location' column appropriately to obtain $6$ distinct values for the continent column Asia, Africa, North America, South America, Europe, and Oceania. Drop the column geographic$\_$location. $(2$ points$)$

Create a complete graph with European country names as nodes. $(2$ points$)$