Compare a list of product names and return most similar products

€8-30 EUR

Скасований

Опублікований

over 7 years ago

€8-30 EUR

Оплачується при отриманні

We have a list of 10.000 rows that is constanlty updating. So this must be done automatically in excel or php. It will take every row and compare it with all the others. then it will return the most similar results. Those similar results will have some common text. This text must be returned in another column in order to match them. For example: Azzaro Chrome Eau De Toilette 100ml Azzaro Chrome Eau De Toilette 100ml & 100ml Aftershave Azzaro Chrome Eau De Toilette 100ml & 200ml Shower Gel Azzaro Chrome Sport Eau De Toilette 100ml Azzaro Chrome Sport Eau De Toilette 30ml Azzaro Chrome Sport Shower Gel 50ml Xpel Tea Tree 100% Pure Tea Tree Oil 10ml Xpel Tea Tree 100% Pure Tea Tree Oil 30ml Xpel Tea Tree Anti-bacterial Handwash 500ml Xpel Tea Tree Facial Scrub 250ml Xpel Tea Tree Foaming Face Wash 200ml The manufacturer will be given in another column and it should be subtracted from the product name. for the examples above the manufactures are Azzaro and Xpel. So the final product names for similarity comparison will be Chrome Eau De Toilette 100ml Chrome Eau De Toilette 100ml & 100ml Aftershave Chrome Eau De Toilette 100ml & 200ml Shower Gel Chrome Sport Eau De Toilette 100ml Chrome Sport Eau De Toilette 30ml Chrome Sport Shower Gel 50ml Tea Tree 100% Pure Tea Tree Oil 10ml Tea Flower 100% Pure Tea Tree Oil 30ml Tea Tree Anti-bacterial Handwash 500ml Tea Tree Facial Scrub 250ml Tea Tree Foaming Face Wash 200ml We must get the most similar results for each row. Do not ask us how. If we knew how we would have done it ourselves. Similarity is the key word. Some first thoughts is to order them by name and check word by word.

Excel

PHP

ID проекту: 12713860

Про проект

40 пропозицій(-ї)

Дистанційний проект

Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@arielaleksander

I read your bid, I can do this using Power pivot and some Macros. If you give me the job I can start it after 6PM Est time. January 11, 2017 Dear Hiring Manager I am 20 years old guy and live in Brazil. I worked as administrative assistant in a private university for almost 5 years, providing assistance for a team of 22 courses coordinators and 336 teachers and taking care about the projectors booking. Currently I work as Virtual Assistant for a company of plumbing services, in Durham, North Carolina, doing customer service and taking care of their inventory, ordering new items for technicians, participating of meetings with the team and creating reports with excel. I have experience working with Office tools like (OneNote, Power Point, Outlook, Word, Access and Excel). My experience with excel includes creating pivot tables, charts, writing formulas (Vlookup,IFERROR,SUM,IFS), working data on Power Query and Power pivot. I also have experience working with Google Apps(Hangout, Google Docs, Gmail and Google Drive). You should expect I dedicated and experience employee, that is passionate, proactive, detail oriented, punctual and eager to excel. That’re the reasons why I think that I’m the best fit for this job. Call me on the chat and let discuss this position. Ariel Silva

€17 EUR за 1 день

5,0

(3 відгуки(-ів))

0,7

40 фрілансерів(-и) готові виконати цю роботу у середньому за €31 EUR

@schoudhary1553

Aquaholix Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

€200 EUR за 1 день

4,9

(594 відгуки(-ів))

8,5

@BitLabs

Hello, I have gone through your outsourced requirements "Compare a list of product names and return most similar products" and have analyzed that I have right skills (Excel, PHP) to execute your esteemed project. I will complete your project today, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)

€35 EUR за 1 день

5,0

(131 відгуки(-ів))

6,8

@sy3d

please check my profile, i've no incomplete project we can perform this task in excel as well as PHP please share file, i'll show demo before you hire me i assure you, i'll complete this task as per your requirements I am looking to hear from you thx

€30 EUR за 1 день

4,7

(300 відгуки(-ів))

7,4

@Harun1986

Hello, Sir, I will send the quick sample. I will fill in a spreadsheet with data for you. I have using tactically use many things but Google for finding keyword relented companies, Email, address, Person name, phone, etc. I can do the work acquired perfect in time. Please ask me a sample B4 award. I am sure you will like my work sample. Waiting for your positive response. Thank you

€23 EUR за 1 день

4,9

(168 відгуки(-ів))

6,6

@testotorko

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. I also have worked over many Wordpress projects. Have good communication skills and great responsibility.

€30 EUR за 3 дні(-в)

4,9

(123 відгуки(-ів))

5,8

@pinesucceed01

Dear Prospective Client, I am drafting a complete new message and will submit it shortly. As based on my initial review I can confirm its feasibility & as I am great fit technically and have good understanding of the domain & your requirement & would submit a detailed response soon. Meanwhile I would really appreciate it if you can initiate the PERSONAL MESSAGE BOARD so that we can connect with each other. Thanks

€23 EUR за 1 день

4,8

(30 відгуки(-ів))

5,7

@LidijaP

My name is Lydia, I'm working on the computer last 15 years. My Top Skills Excel, Microsoft Office,Internet Research.

€34 EUR за 1 день

5,0

(15 відгуки(-ів))

4,9

@ChinmoySarker

Hi! Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. Sincerely Yours obedient helpful person

€14 EUR за 1 день

5,0

(24 відгуки(-ів))

4,8

@Diliphero

Greetings, I would like to submit my proposal for your project on Excel. I Understand the importance of this project due to my educational background and I will do this job with great care and responsibility. I am a qualified professional from Sri Lanka with a degree in Management & Finance with 13 years of managerial experience. I can do the data conversion, Excel projects including formulas, search the internet for data, Etc. I am a full-time freelancer, and I can start working immediately. Look forward to discussing with you the opportunity offered. Kind regards, Dilip.

€30 EUR за 1 день

4,8

(15 відгуки(-ів))

5,0

@teeares

I have created many macros in Excel, I will be able to do this task. Would the first word be always the manufacturer? There may be more complications if the manufacturer,s name consists of two words. Any way let me have a look at your list, then I can confirm whether I can do it.

€19 EUR за 1 день

4,5

(50 відгуки(-ів))

5,0

@microservices

Hi, Please consider us for this project and give us an opportunity to showcase our work to you. We can assure you on time we will deliver a bug free application . So we will discuss more on it in near future . Best Regards, MSTS

€24 EUR за 3 дні(-в)

5,0

(12 відгуки(-ів))

3,7

@iftekhertalukder

Hello, I am able to do the work for a short time because I have a team of several members. I will complete the with sincerity, honesty and diligently, thanks

€8 EUR за 1 день

5,0

(1 відгук)

0,4

@malokmalik

Give me chance and i will prove you myself within time

€8 EUR за 1 день

0,0

(0 відгуки(-ів))

0,0

@dipanshumittal

I can understand this type of job work, This task is very easy. Method for doing this task -> search for first white space -> extract data till then and place in next column by above method we can do your task Regards, Dipanshu Mittal HP: +91 9818477012

€10 EUR за 1 день

0,0

(0 відгуки(-ів))

0,0

@piyujaindata

Hello Sir/Mam, Me And My Employees are Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. If you are looking for data entry or search work as you show in your project title than I am the right person for you. available 24-7. a trusted Freelancer. Regards & Thanks

€13 EUR за 1 день

0,0

(0 відгуки(-ів))

0,0

@siddharthverma94

What you need is a basic text matching algorithm. I have been working on machine learning for quiet a time and can do this work along with suggesting better ways to suggest better products based on what user is seeing .

€28 EUR за 2 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@rsim7686

A proposal has not yet been provided

€23 EUR за 10 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@ahmedtaher2020

A proposal has not yet been provided

€29 EUR за 2 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@mayo01

will do a quality job for you within a possible frame of time, I Knw my profile doesn't shows it yet but I can get the job done

€29 EUR за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@vw6950258vw

This is my first bid of a project in this platform. Relatively new in freelancing but have handled about 5 projects previously. Most importantly I have real working experience in development of CMS, APIs and Android development.

€29 EUR за 3 дні(-в)