Merge two excel files (partial matches allowed)
$30-250 USD
Paid on delivery
Hello - I need a web script (Python/Django preferably, but I am open to other languages) to merge two excel files.
Excel 1 has columns: Name, Age, DOB, Subject
Excel 2 has columns: Nom, Birthday, School, Hobby
Merge criteria (user will specify):
Name = Nom
DOB = Birthday
So, now, you'll generate a third Excel file (Excel 3) with columns:
Name, Age, DOB, Subject, School, Hobby
(note that Nom and Birthday columns are missing because they are suppose to be same as Name and DOB)
User can also enable "partial matches" and "multiple matches"
If partial matches are allowed: That is, let's say if you have "Jon" in Name column and "Jonathan" in Nom column.
Then, they will be matched. But add a column indicating "partial_match"
User can also enable "multiple matches"
eg: If you find two Jon in Excel 1 and two Jonathan in Excel 2
then you'll generate 4 rows. But add a column saying "multiple_match_set1" so that I can see which rows had multiple matches.
Thanks
Project ID: #4168800
About the project
Awarded to:
Ill do it for you right now, should only take a few hours. Message me. UC Davis Engineering student here.
26 freelancers are bidding on average $123 for this job
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.
Hi, I'm an expert in Data Structure and Algorithm. My preferred language is Python and I'm totally confident to handle your project. Please kindly check your message
Interesting task. Will do it in Perl, the language designed for text processing of all scales.
Hello. Can by done inside Django. Do you have hosting fot it? Maybe the Google app engine can be the good place. BTW: Often .csv format is more usefull then .xls or .xlsx, especially if working with milions rows.
Hi Cris, will do it fast due to rich experience in working with Excel in Python. Django UI if you need it.
Hi. I am a Carnegie Mellon University student. I am more than equipped to handle this task and can complete it quickly and cheaply (I am a student after all). Please let me know if your interested
Respected Sir, I have experience in automating various tests, formatting and storing the results in excel sheet using perl script. I can complete your task in 2 days with quality. Thank You K. Shriram