Consider Share prices for a N number of companies given for each month since year 1990 in a CSV file. Format of the file is as below with first line as header. Year,Month,Company A, Company B,Company C, .............Company N 1990, Jan, 10, 15, 20, , ..........,50 1990, Feb, 10, 15, 20, , ..........,50 2013, Sep, 50, 10, 15............500 a) List for each Company year and month in which the share price was highest. b) Submit a unit test with sample data to support your solution.
List of companies
Name: CompanyA
Name: CompanyB
Name: CompanyC
Max share price company per year
For Month/Year: Jan/1990 : Leading Company with maximum share prices: CompanyB
For Month/Year: Feb/1990 : Leading Company with maximum share prices: CompanyC
For Month/Year: Mar/1990 : Leading Company with maximum share prices: CompanyC
For Month/Year: Apr/1990 : Leading Company with maximum share prices: CompanyB
etc
Each company best year/month and maximum share prices
CompanyA has best share value so far 90 in Nov/1991
CompanyB has best share value so far 53 in Nov/1990
CompanyC has best share value so far 51 in Mar/1991
Done
FOR A CSV FILE CONTAINING
Year,Month,CompanyA,CompanyB,CompanyC
1990,Jan,10,51,30
1990,Feb,2,11,40
1990,Mar,3,21,50
etc