Should only take a few hours, if that to complete.
User will upload a CSV file with the following columns:
Unique ID, Parent First Name, Parent Last Name, Parent E-Mail Address, First Name, Last Name, Number of Visits, Date of Last Visit and Visit Dates
Immediate export of same file except that code will analyze csv file based on:
- Each unique ID and find the number of days between date of last visit and most recent visit prior to that and add that number in an additional column labeled Days Between Most Recent and Last
Then it will purge all duplicate rows for that unique ID and leave just one row for that unique ID that has the most recent Visit Date in it.
To give you an example of the process, the first file shows what the file would look like when uploaded.
The second image shows you what data to look for, first the unique ID, second the most recent visit date and third the most recent Previous visit date.
The third file shows you the end result of what the file should look like. You'll see all the extra lines have been purged leaving a clean file with only one of the unique ID's for each customer, the row that is left is based on the Visit Dates column and it is the date that is PREVIOUS to the MOST RECENT (or what is in the Date of Last Visit column). You'll also see it appended the number of days between PREVIOUS most recent date and Date of Last visit date.
You do not have to save anything to database if you don't want to, you don't have to save files to server, you don't have to change any columns around, or have logins or users accounts, literally is just an upload and download project.
It must be able to handle a lot of records, must be able to do calculation. Only one file will be uploaded/processed at a time so no need for batch uploading, etc.
35 freelancers are bidding on average $32 for this job
Hello sir, I have reviewed the attached images for before and after dta processing, I can do it as per your requirements and I can deliver it within 24 hours max. Thanks
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
hi next employer, I am interested in your project. I hold master degrèe in finance. Having more than 9 years experience of data entry, web scraping, excel based projects. hope you give a chance to work with you