Completed

Merge two excel files (partial matches allowed)

This project was successfully completed by jjk12345 for $125 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
33
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online