For this assignment you are to process a CSV file containing $5$ years of historical data

for IBM $($from $2/8/2013$ through $2/7/2018).$ This file is in a CSV file format and can be

downloaded from canvas. Each line of the file represents the stock data for that day.

The format of the file is as follows $($shown with the first line of data$)$:

Date Open High Low Close Volume Name

$2/8/2013199\mathrm{.}97202\mathrm{.}09199\mathrm{.}68201\mathrm{.}682893254$ IBM

You are to write a Python program that will read in all of the data for IBM and compute

the average closing price $($Close$)$ for each year of data available. The output should be

displayed as follows:

STOCK TICKER: IBM

$2013$ Average Closing Price: xxx$.$xx

$2014$ Average Closing Price: xxx$.$xx

$2015$ Average Closing Price: xxx$.$xx

$2016$ Average Closing Price: xxx$.$xx

$2017$ Average Closing Price: xxx$.$xx

$2018$ Average Closing Price: xxx$.$xx

Program Requirements Rubric

$1)(5$ points$)$ In your current project directory

create a new python file called

process$\_$ticker.py$.$

Call a function called process$\_$file$()$ which

will read and process the data

$2$ pts

$3$ pts

The file is called $$process$\_$ticker.py$$

The function is called $$process$\_$file$$

$2)(25$ points$)$ Program reads data from the

file successfully splitting line data into

individual token values.

$25$ pts Program reads file data and splits each line into

individual token values

$3)(20$ points$)$ Program uses correct fields to

partition data into necessary fields

required to compute the averages, e$.$g$.,$

date, close.

$20$ pts Program processes correct fields to compute the

required results, e$.$g$.,$ date, close.

$4)(25$ points$)$ Program successfully

computes yearly averages using closing

price

$25$ pts Program uses closing price data for each date

range and computes the correct average closing

price by year.

$5)(25$ points$)$ Program displays results as

shown above

$25$ pts Program displays results in required format, see

above.