CIS2250-Lab 6 Solved

Our obejctive is to produce a file that has three columns that describe
1. the year of the data
2. how many years after graduation the graduate is reporting (2 or 5)
3. the income (you will find this in a column called “VALUE”
Your file should describe earnings for all people holding an undergraduate degree.
The educationON.csv file contains all of this information, and more (for instance,
there is information for people with graduate degrees as well).
Your task is to determine how to obtain the correct data by writing and running a
perl program.
Using any of your past perl programs as a starting point, write a program that will
extract the data to answer this question.
Put your program in a file called undergradCSincome.pl. Your program should take
a single argument: the name of the data file.
Print out the results to the screen in the format shown here below. If everything has
worked correctly, you should see exactly this output:
Year,YearsAfterGraduation,Dollars
2010,"Median employment income two years after graduation",55600
2010,"Median employment income five years after graduation",72800
2011,"Median employment income two years after graduation",58800
2011,"Median employment income five years after graduation",72800
2012,"Median employment income two years after graduation",58900
2012,"Median employment income five years after graduation",75800
A file containing this data is available on CourseLink for your reference.
Task 2 Description: Produce a plot based on your data
Collect the output of your program into a data file, as we did in the last lab:
$ p e r l undergradCSincome . pl educationON . csv income . csv
Write a program to plot your data as a line graph, based on the createNameRankPlot.pl
file we used in Lab 4. Call your new program createUndergradCSincomePlot.pl.
Running the following command should produce the plot on the next page:
$ p e r l createUndergradCSincomePlot . pl income . csv income . pd f
Upload to Courselink
Upload both of your new perl programs to CourseLink:
• undergradCSincome.pl
• createUndergradCSincomePlot.pl
Project Kicko?
Once you have completed these tasks, be sure everyone in your group has read the
“Project Overview” document in CourseLink, and come up with a strategy to reach
the first milestone described in this document for the next lab.

Overview
Learning objectives: # Extending our
pair programming skills to the project
team H# Dealing with large data sets
Extracting and examining fields

coordination + communication (3/6)
(*)[The skill scale is from 0 (Fundamental Awareness) to 6 (Main Focus).]
Image description
A pair of black books. Image source
publicdomainvectors.org CC0 1.0
●
●
●
●
●
●
55000
60000
65000
70000
75000
2010.0 2010.5 2011.0 2011.5 2012.0
Year
Dollars
YearsAfterGraduation
●
●
Median employment income five years after graduation
Median employm