# Computer Project #07   SOLUTION

Assignment Deliverable  The deliverable for this assignment is the following file:   proj07.py – the source code for your Python program  Be sure to use the specified file name and to submit it for grading via the handin system before the project deadline.
Assignment Background
One commonly hears reference to “the one percent” referring to the people whose income is in the top 1% of incomes.  What is the data behind that number and where do others fall?  Using the National Average Wage Index (AWI), an index used by the Social Security Administration to gauge a individual's earnings for the purpose of calculating their retirement benefit, we can answer such questions.
In this project, you will process AWI data. Example data for 2014 is provided in the file year2014.txt (2014 is the most recent year of complete data). The data is a table with the first row as the title and the second row defining the data fields; remaining rows are data.  The URL for the data is: https://www.ssa.gov/cgi-bin/netcomp.cgi?year=2014
Here is the second line of data from the file followed by descriptions of the data.  Notice that some data are ints and some are floats:
5,000.00 - 9,999.99  13,848,841  36,423,281  23.02549  102,586,913,092.61  7,407.62  Column 0 is bottom of this income range. Column 1 is the dash separating the bottom of the range from the top. Column 2 is the top of this income range.  Column 3 is the number of individuals in the income range. Column 4 is the cumulative number of individuals in this income range and all lower ranges. Column 5 is the Column 4 value represented as a cumulative percentage of all individuals. Column 6 is the combined income of all the individuals in this range of income. Column 7 is the average income of individuals in this range of income.
Assignment Specifications