Input file data :Nunavut,35000,1Alberta,4067000,34Saskatchewan,1098000,14Yukon,35000,1Manitoba,1278000,14British Columbia,4648000,42Ontario,13448000,121Quebec,8164000,78Prince Edward Island,142000,4Newfoundland,519000,7Northwest Territories,41000,1Nova Scotia,923000,11New Brunswick,747000,10 In Canada, the federal government is made up of a number of seats. The seats are divided among theprovinces; for example, Saskatchewan has 14 seats, while Ontario has 121.For this question, you will write a program using population data from the Canadian census to determinewhich provinces are over- or under- reprented in the federal government based on their populations.Using Numpy ArraysThe main purpose of this question is to practice data manipulation using numpy arrays. Therefore, for fullmarks, you must perform all of the significant calculations by using numpy array operations.You will need all three of: array arithmetic, array relations, and logical array indexing. The only place whereyou will use loops in your program is at the very beginning (for reading from file) and at the very end (forprinting the results).Task BreakdownThe steps below will help you break down this process into manageable pieces.Before you start anything, make sure you have imported the numpy module. This module is NOT standard,so if you are working on your own machine, you may need to install it first.Load the Data into ArraysDownload the file provincial_seats.txt from the course Moodle. The file looks like this:Nunavut ,35000,1Alberta , 4067000 ,34Saskatchewan , 1098000 , 14Yukon , 35000,1Each line consists of a province or territory's name, its population (rounded to the nearest thousand) andits number of seats in the government, all separated by commas.Write code to open this file and read this data into three separate lists (one for the names, one for thepopulations, and one for the seats). Then, convert each list to a numpy array using the .array() methodfrom numpy. Make sure to maintain the order so that the lists line up by position (i.e. Nunavut is first in thearray of names, and its matching population and seats are the first items in their respective arrays).Test these arrays before you move on! You will use them to perform all the following array calculations.Predicted SeatsUsing array operations on the loaded data, create an array that contains, for each province, the expectednumber of seats that each province WwOULD have if its seats were exactly proportional to its population.Round these values to the nearest integer (you can use numpy's .around () method).Hint: As part of this calculation, you'll probably need Canada's total population, and the total number ofseats. Think about how you can get these using the data you already have using numpy's .sum() method. Finding Over- and Under-represented provincesIf a province has more actual seats than the number of seats you calculated based on its population above,we'll call that province over-represented. If it has fewer actual seats than predicted seats, then it is under-represented.Use array relational operators and logical indexing to create three arrays for:• the names of the over-represented provinces• the expected seats of those provinces• the actual seats of those provincesThen do the same thing for the under-represented provinces.Finally, print your results to the console. You can use loops for this final task.Sample RunThe output of your program might look something like this:Based on population, the following provinces are over -repres ented :Actual : 1Nuna vutExpected: oSaskatchevanExpected : 11Actual: 14Expected : 0Expected : 12YukonActual: 1ManitobaActual: 14Prince Edward IslandExpected: 1Actual: 4NewfoundlandExpected : 5Actual: 7Northwest TerritoriesExpected: 0Actual : 1Nova ScotiaExpected: 9Actual: 11New BrunswickExpected: 7Actual: 10The following provinces are under -represented:AlbertaExpected: 39Actual: 34British ColumbiaExpected: 45Actual: 42Expected: 129Expected: 79OntarioActual: 121QuebecActual : 78

Programming is instructing a computer to do something for you with the help of a programming…

Answered: Input file data : Nunavut,35000,1…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE