I want a program where i can upload two csv files the files will be analysed and a third csv will be created as output.
The input file 1 will contain lists like this
inquiries
[login to view URL],2016-10-07,2016-10-08,23,18,5,21.7391,82.49565200,1.8974,0
[login to view URL],2016-10-07,2016-10-08,87,3,0,0.0000,0.00000000,0.0000,0
[login to view URL],2016-10-07,2016-10-08,34,13,5,14.7059,32.73529400,1.1130,0
input file 2 will contain a list like this
[login to view URL],155,692,4,0.58,2.58,0.08,0.45,2.00,0.08,0.1.25,y,shift,time
[login to view URL],155,692,4,0.58,2.58,0.08,0.45,2.00,0.08,0.31,y,ponsor,dis
[login to view URL],155,692,4,0.58,2.58,0.08,0.45,2.00,0.08,12.22,y,port,Bod
[login to view URL],1486,894,31,3.47,2.09,0.01,0.48,0.29,0.34,0.43,y,group,backtime
The program will find matches of the names in row one and then compare the the last row from file one with the 10 row from file two. Once the operation is complete the results will be available to export in the following format
[login to view URL],whichever file was highest, highest amount, lowest amount, %difference
so for the examples the output would be
[login to view URL], file1, 1.8974, 0.43, 441%
[login to view URL], file2, 1.25, 0.0000, 10000% (use 10000% when lowest is 0)
[login to view URL], file2, 12.22, 1.1130, 1089%
[login to view URL], no comparison
Hopefully that is enough information for a quote. If not ask.
Thanks