Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide python code for this assignment please. Assignment Overview (learning objectives) This assignment will give you more experience on the use of 1. Lists

Please provide python code for this assignment please.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Assignment Overview (learning objectives) This assignment will give you more experience on the use of 1. Lists 2. Functions 3. iteration 4. string The goal of this project is to analyze census data Assignment Background Immigration is in the news. One of the powerful things you can do with Python is investigate data related to current news. One question might be: how many immigrants are in the US? We go to the US Census, a task mandated in the Constitution (www.census.gov and https://factfinder.census.gov/) Between the required 10-year census they survey for all sorts of data. Here we consider the percentage of residents who are native born, naturalized citizens and non-citizens. (If you are curious, the data file has data on a wide variety of stuff: income broken down into many categories, average rent, education levels, etc.) The data in the 2016 file is by state so there are 51 rows of data (includes Washington D.C., but not territories such as Puerto Rico). There are hundreds of columns; we are only interested in a few There is a second file of data from the year 2000 that we use for comparison of total US counts. It is structured differently that the 2016 data so our desired information is in different columns with different headers. Project Description Your program must meet the following specifications 1. 2. At program start prompt the user for the files to be analyzed: year 2016 first, then year 2000 You have to use the eight functions in the provided proj06.py skeleton. You have to implement and use the a. open file): Returns the file pointer to the file opened by asking user for the file name. Error checking is required. b. find index (header_list,s): Takes two arguments. The first is the header row split into a list of strings. The second argument is a string. Return the index (int) of the string s in the header row list. This index is the column index of the string in the data file c. read 2016 file (fp): Takes a file pointer as an argument and returns a sorted list of tuples of data in the file. The tuples are sorted on the last item in the tuples- temgetter is useful for sorting on an tem that is not first in the tuple. Sorting is smallest to largest. Percentages are with respect to total residents, i.e. native naturalized non-citizen. The values are to be found using the string value_ pass that string to the find index function which returns the column index (this Assignment Overview (learning objectives) This assignment will give you more experience on the use of 1. Lists 2. Functions 3. iteration 4. string The goal of this project is to analyze census data Assignment Background Immigration is in the news. One of the powerful things you can do with Python is investigate data related to current news. One question might be: how many immigrants are in the US? We go to the US Census, a task mandated in the Constitution (www.census.gov and https://factfinder.census.gov/) Between the required 10-year census they survey for all sorts of data. Here we consider the percentage of residents who are native born, naturalized citizens and non-citizens. (If you are curious, the data file has data on a wide variety of stuff: income broken down into many categories, average rent, education levels, etc.) The data in the 2016 file is by state so there are 51 rows of data (includes Washington D.C., but not territories such as Puerto Rico). There are hundreds of columns; we are only interested in a few There is a second file of data from the year 2000 that we use for comparison of total US counts. It is structured differently that the 2016 data so our desired information is in different columns with different headers. Project Description Your program must meet the following specifications 1. 2. At program start prompt the user for the files to be analyzed: year 2016 first, then year 2000 You have to use the eight functions in the provided proj06.py skeleton. You have to implement and use the a. open file): Returns the file pointer to the file opened by asking user for the file name. Error checking is required. b. find index (header_list,s): Takes two arguments. The first is the header row split into a list of strings. The second argument is a string. Return the index (int) of the string s in the header row list. This index is the column index of the string in the data file c. read 2016 file (fp): Takes a file pointer as an argument and returns a sorted list of tuples of data in the file. The tuples are sorted on the last item in the tuples- temgetter is useful for sorting on an tem that is not first in the tuple. Sorting is smallest to largest. Percentages are with respect to total residents, i.e. native naturalized non-citizen. The values are to be found using the string value_ pass that string to the find index function which returns the column index (this

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions

Question

2. What recommendations will you make to the city council?

Answered: 1 week ago