CCF and KW Consumption

Write an application using the files Data.csv, RatesCCF.csv, RatesKW.csv provided by your instructor.

Your application will read the content from these files into three different arrays and then make the appropriate calculations to demonstrate your understanding of arrays manipulation.

The files provided for this assignment represent the data collected for six years of electricity and natural gas consumption. Below you will find a brief description of the content found in the files:

• Data.csv - (Two columns: CCF KW) Jan 10-15, Feb 10-15, Mar 10-15, Apr 10-15, etc.
• RatesCCF.csv - (price per CCF for every month with a span of six years) // refer to RatesCCF.pdf for a visual representation.
• RatesKW.csv (price per KW for every month with a span of six years) // refer to RatesKW.pdf for a visual representation.

Your application should end up with three different 7x13 arrays. These arrays are the result of calculating the data found in Data.csv by their corresponding rates. The averages are calculated on a row/column basis resulting in a 7x13 matrix.

Your calculated arrays should be saved to a file called Results.txt which should be properly formatted for readability; refer to Results.pdf to verify your calculations.