Create program for mapping fields between two excel files based on intelligent/partial keywords (elasticsearch?)
$100-1000 USD
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.
Project ID: #17641034
About the project
21 freelancers are bidding on average $510 for this 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 More
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
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.
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
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
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
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
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
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
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
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
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