
Looking for an PHP-Expert with "Levenshtein distance"-knowledge - Need a small tool
- or -
Post a project like this3704
$$
- Posted:
- Proposals: 3
- Remote
- #892119
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Hey folks,
1st list with 20.000 entries: http://prntscr.com/8dkgup
2nd list with 4.000 entries: http://prntscr.com/8dkh2f
Basically I need to add the additional values from list 1 added to the row on list 2 if it matches.
Problem is, there are additional words on list 1 or 2, so there are very few exact matches.
Algorithm which can be used: Levenshtein distance https://en.wikipedia.org/wiki/Levenshtein_distance
Workaround:
Make a small tool i.e. in PHP with which when you click the first entry from list 2, it shows all matches from list 1 based on your algorithm. Now an data-entry guy can select the correct one if it's available. Otherwise he can skip.
If a match was selected, the additional rows are added to the corresponding product from list 2. (i.e. in a DB).
Let me know you plan to do it.
Regards
1st list with 20.000 entries: http://prntscr.com/8dkgup
2nd list with 4.000 entries: http://prntscr.com/8dkh2f
Basically I need to add the additional values from list 1 added to the row on list 2 if it matches.
Problem is, there are additional words on list 1 or 2, so there are very few exact matches.
Algorithm which can be used: Levenshtein distance https://en.wikipedia.org/wiki/Levenshtein_distance
Workaround:
Make a small tool i.e. in PHP with which when you click the first entry from list 2, it shows all matches from list 1 based on your algorithm. Now an data-entry guy can select the correct one if it's available. Otherwise he can skip.
If a match was selected, the additional rows are added to the corresponding product from list 2. (i.e. in a DB).
Let me know you plan to do it.
Regards
Jetlir I.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
14 Sep 2015
Albania
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies