Merge two excel files (partial matches allowed)

In Progress

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

Skills: Perl, PHP, Python, Software Architecture

See more: merge excel files partial matches allowed, python merge excel files, php script school, php school script, python excel, nom, excel python, excel 2013, python Django php, web script python, django add, allowed, excel can open file, files missing, partial php, php partial, excel file columns, php excel file generate, django excel, python web script, merge excel perl, excel file perl, can open excel files, find matches files, script merge

About the Employer:
( 84 reviews ) Plano, Canada

Project ID: #4168800

Awarded to:

jjk12345

Ill do it for you right now, should only take a few hours. Message me. UC Davis Engineering student here.

$125 USD in 1 day
(0 Reviews)
2.4

32 freelancers are bidding on average $127 for this job

SigmaVisual

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.

$199 USD in 5 days
(219 Reviews)
7.7
procoder898

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

$99 USD in 2 days
(41 Reviews)
5.7
djain01

Hi, Pls check the private message. Thanks djain01

$500 USD in 10 days
(40 Reviews)
5.3
hrarcon

Ready to work on your project.

$250 USD in 10 days
(5 Reviews)
5.0
andriy3s

Hi, I'll be glad to do that for you in Python.

$100 USD in 5 days
(35 Reviews)
5.0
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD in 4 days
(7 Reviews)
4.6
eghlima

hi, I am exper in python. I can do it easily.

$30 USD in 1 day
(17 Reviews)
4.4
bcsaba

Think can do this for you :)

$30 USD in 1 day
(28 Reviews)
4.3
edatawiz

I have the needed experience. Please check my PM for more information.

$100 USD in 5 days
(7 Reviews)
4.2
psfever

Python Programmer Here!

$75 USD in 3 days
(9 Reviews)
3.9
zeet2020

check your pm

$120 USD in 10 days
(6 Reviews)
3.5
manishadk

I am expert in Excel , Macro. Please check PMB for details.

$100 USD in 1 day
(7 Reviews)
3.5
igupta005

I can do it in 1 day in perl script.

$150 USD in 1 day
(2 Reviews)
3.2
FunkyVogel

Hello i can do this for you. German quality and efficiency guaranteed!

$50 USD in 2 days
(2 Reviews)
2.2
jungleru

Hello, I can write this script. I can use Django or Flask or client javascript only.

$90 USD in 2 days
(2 Reviews)
1.3
prabhatg

Hi I am expert python/Django Developer. Please check PMB.

$250 USD in 3 days
(2 Reviews)
1.0
onlyLekha

can do it in php

$175 USD in 2 days
(0 Reviews)
0.0
zeshan411

hy i am interested in your project this is very very easy for me

$50 USD in 1 day
(0 Reviews)
0.0
zkutch

Hello. More 20 years programming experiense. See pmb, please.

$150 USD in 1 day
(0 Reviews)
0.0
Incidentals

Capable of this simple task

$250 USD in 1 day
(0 Reviews)
0.0