Create program for mapping fields between two excel files based on intelligent/partial keywords (elasticsearch?)

Cancelled Posted 5 years ago Paid on delivery
Cancelled Paid on delivery

This is PART 1 of a much larger Part 2 (separate project, not in scope of this Part 1 project) – but whoever does Part 1 would be well placed to do the Part 2 as I’d like to work with someone regularly for this and future requirements. I would be glad to discuss Part 2 if you feel you’re the person to do this project. Now, onto the scope of this project (Part 1):

Here are the file: [login to view URL]

Please have a look at the file (Master [login to view URL]). This is a partial list of the categories on our website. Then please have a look at 1st source file and 2nd source file which need to be “mapped” to our “master categories”, and in some cases “new subcategories” will be added to master categories (manually” when there is no good match/map.

We will be mapping hundreds of websites and need a tool to automatically map the categories of the “source sites” to our master categories based on keywords.

Since our current list of “master categories” is over 1600 and some of the source sites may have anywhere from 10 to a couple of hundred categories, the tool should be able to determine the “closest” match which may be 1st, 2nd or 3rd level category in the “master categories” list.

Please note that this tool is not expected to automate 100% of the matching/mapping of (sub) categories, but to save a lot of time before starting the manual process. The goal is find as many categories which can be mapped to the 3rd level in master categories, but since there won’t be too many – at least try to find the corresponding 2nd level or 1st level so when the manual mapping is to be done – its easier for even an untrained person.

So, for instance if the “source site” has a category called – construction equipment – then that would be best mapped to 1st level category “construction” in the master categories list. Whereas if there is a category called “Rip Rap Plant” then what would be mapped to “Rip Rap Plant” 3rd level category in master categories list.

Program should be PC/Windows based preferably, with good UI UX and easy to use. I hope you have the experience to have done this before so you know what I don’t know.

Data Extraction Elasticsearch Excel Macros Excel VBA Python

Project ID: #17641034

About the project

21 proposals Remote project Active 5 years ago

21 freelancers are bidding on average $510 for this job

schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you More

$450 USD in 7 days
(139 Reviews)
7.1
bouslimi1979

Hi, I m very interested. I ll code an Excel/VBA app to make the matching. I can also make it smart as possible and also flexible : for example add new keywords to identify a given category r subcategory. I m ready to h More

$400 USD in 5 days
(15 Reviews)
5.7
waema

I can delvier this in a week. i would need more information about creating the matching you requested. i have vast experience in python bots and can deliver in python or c#. lets discuss further please.

$250 USD in 10 days
(24 Reviews)
5.7
sevillajk01

hi! let me help you with your project. I have read all the details of your project and I am confident that I can the team is what is expected/required. Hope your give me a chance. thanks

$395 USD in 10 days
(24 Reviews)
4.4
dstepanenko

Hello, I'm data scientist with huge expertise and mathematician with a number of publications. Also I'm participant and problem writer of many algorithm competitions (Topcoder, ACM ICPC). Feel free to contact me to d More

$800 USD in 7 days
(28 Reviews)
6.9
TechnoGuruu

Hi, As per project details and information shared by attached files, I understood the project requirements and I will develop Excel macro for you to achieve this goal. I will provide you to folders where you will put More

$250 USD in 5 days
(6 Reviews)
4.3
archanaoswal

I can create a simple UI Based tool using MS Excel VBA to perform the search and mapping of categories I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Buil More

$250 USD in 3 days
(7 Reviews)
4.2
SPARKtechBD

I have read all the description and understood about the mapping of those Excel sheet. To process such operation we need to build Excel VBA Macro. Have real time experience on Excel VBA Macro to build any kinds process More

$1000 USD in 20 days
(4 Reviews)
3.6
vijayvizzu7

Hi, i read your description and i thought you need a tool which can suggest or show you the matching percentage, so that you can able to map the filed with master file. I am sure i can handle your request

$350 USD in 10 days
(4 Reviews)
2.7
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$611 USD in 10 days
(5 Reviews)
2.8
graeserbjoern

Hi there, I can do this fast and reliable. Can you maybe chat me to talk about deadlines? Shall be done within 48 hours if assigned during this weekend. Best Regards, Bjoern

$611 USD in 10 days
(0 Reviews)
0.0
Lucaroman

Dear Hiring Manager. I read your job description carefully and I am very interested in your project. I have the master degree of computer science. I am fully ready for your job. If you select me as a contractor, I More

$611 USD in 10 days
(0 Reviews)
0.0
Rajupatel007

I am completely fast

$611 USD in 10 days
(0 Reviews)
0.0
subhashishkar

Hello, Thank you for a detailed explanation and for providing the sample files along with. This is indeed an interesting challenge and I would be keen on getting to be a part of it. I am a Microsoft certified tr More

$650 USD in 10 days
(0 Reviews)
0.0