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
[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.
31 freelancers are bidding on average $101 for this job
Hello, I can write a script that will be able to do what you are looking for. I'm ready to start working on your project. If you have any questions, please ask.
Hi, I have already created the script to make third csv file using 2 different csvs for products. Let me know when we can discuss. My skypeid is: [login to view URL] Thanks.
Read your requirements, I can do it within a day. Ph.D ECE major at Georgia Tech. Good at C Programming and RTL Design using Verilog. 2 years experience in industry