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

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.

Evner: Data Extraction, Elasticsearch, Excel Macros, Excel VBA, Python

Se mere: create program compares files, create excel files mysql, program compare excel files, elasticsearch mapping file, elasticsearch keyword mapping, elasticsearch keyword vs text, elasticsearch multiple fields, elasticsearch data types, elasticsearch create index with mapping, elasticsearch mapping, elasticsearch dynamic mapping, create stand alone excel files, mapbasic create excel files, create excel files using, convert excel files stand alone program, create excel files php mysql, create excel files, job mapping excel files, standalone program read excel files, create locked fields excel

Om arbejdsgiveren:
( 160 bedømmelser ) San Ramon, United States

Projekt ID: #17641034

26 freelancere byder i gennemsnit $499 på dette job


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 Flere

$450 USD in 7 dage
(33 bedømmelser)

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 dage
(22 bedømmelser)

Hi Sir, I will create a python program which can do the comparison and need the necessary thing what you mentioned. I’m a Python Programmer. I have created many Bots to scrape the websites like Amazon(UK, USA, AU, d Flere

$470 USD in 3 dage
(18 bedømmelser)
$555 USD in 7 dage
(18 bedømmelser)

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 Flere

$800 USD in 7 dage
(17 bedømmelser)

Hi, there - My name is Phong. I have read your job description and I am very interested in this project because I have good experience with excel managing and python programming. I would love to speak with you furthe Flere

$100 USD in 2 dage
(13 bedømmelser)

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 Flere

$400 USD in 5 dage
(6 bedømmelser)

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 Flere

$250 USD in 3 dage
(7 bedømmelser)

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 Flere

$611 USD in 10 dage
(4 bedømmelser)

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 Flere

$250 USD in 5 dage
(2 bedømmelser)

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 dage
(3 bedømmelser)

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 dage
(4 bedømmelser)
$555 USD in 5 dage
(3 bedømmelser)
$100 USD in 3 dage
(1 bedømmelse)

"Hello, I am happy to inform you that I have read your project "" Create program for mapping fields between two excel files based on intelligent/partial keywords (elasticsearch?) "" description and understood all of Flere

$388 USD in 10 dage
(0 bedømmelser)
$1000 USD in 20 dage
(0 bedømmelser)
$277 USD in 10 dage
(0 bedømmelser)

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 Flere

$1000 USD in 20 dage
(0 bedømmelser)

hello,sir. I'm a professional programmer with 9 years of experience. I've already done this kind of project before. If you award me, I'll implement all of your requirements in a short time. Create program for mapping Flere

$611 USD in 4 dage
(0 bedømmelser)

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 Flere

$650 USD in 10 dage
(0 bedømmelser)