Phython Assignment

Aswer the following questions below

Here is a link to the file in google drive to help answer this python questions https://drive.google.com/open?id=1U0ig0y0QRUVJjwmhB2uh8Im1B86zC5e_

Question 5 (15 points) What is the total population of the Essex county in 2017? The output should be an integer. Hint 1. Create a new dataFrame which selects the rows that are Essex in the column 'County 2. Choose the column POP2017' of the new dataFrame 3. Apply sum method to get the sum of that column In [5]: # You should write your answer within this cell # write your code of question 5 here Question 6 (15 points) Find the top five municipalities in population of 2017. List their county and the population of 2017. The output should be a dataFrame with two columns County and 'POP2017, and the municipality as the index. Hint 1. Sort df by the values in the column 'POP2017 in descending order. 2. Choose the first 5 rows of the sorted df, and select their columns County' and POP2017 Sortdfbythe valuesinthecolondof2017'elettheircolumnsCourtyard In [6]: # You should write your answer within this cell # write your code of question 5 here Question 5 (15 points) What is the total population of the Essex county in 2017? The output should be an integer. Hint 1. Create a new dataFrame which selects the rows that are Essex in the column 'County 2. Choose the column POP2017' of the new dataFrame 3. Apply sum method to get the sum of that column In [5]: # You should write your answer within this cell # write your code of question 5 here Question 6 (15 points) Find the top five municipalities in population of 2017. List their county and the population of 2017. The output should be a dataFrame with two columns County and 'POP2017, and the municipality as the index. Hint 1. Sort df by the values in the column 'POP2017 in descending order. 2. Choose the first 5 rows of the sorted df, and select their columns County' and POP2017 Sortdfbythe valuesinthecolondof2017'elettheircolumnsCourtyard In [6]: # You should write your answer within this cell # write your code of question 5 here