Find Jobs
Hire Freelancers

I would like to hire a Coder

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I would like some JS that will basically perform a vlookup. CSV1 is a list of names (column 1) paired with ID numbers (column 2). CSV2 consists of two columns as well, with names in both column 1 and column 2. Each pair of names that share a row in CSV2 are related. I would like the JS to 1) output a CSV3 with all the names in CSV2, in their same rows and columns, but with their name strings replaced by their ID numbers. I intend to use this at a workshop so several people coming to the table with their own CSV2s (likely including several of the same people but spelled slightly differently). My CSV1 will be the authority to which everyone must normalize the names in the CSVs they have brought. Ideally, the JS would include a kind of fuzzy search or predictive text function? Is there a way to provide the user with options, so they can select which name from my CSV1 best matches the (differently spelled) name in their CSV2 so that the output CSV3s are uniform for all participants? The idea would be to write a little Python or JS script that that takes (a.) a CSV with names and SDFB unique IDs and (b.) an edge list of names (but not unique IDs) and outputs an edge list using the unique IDs. This would really help participants get their data in shape for Six Degrees.
Project ID: 14627305

About the project

15 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $192 USD for this job
User Avatar
Hello. My understanding of the problem: - You have a list of names where each name has a unique identifier (CSV-1). - You have multiple individuals, each with their own list where each row has 2 names (CSV-2). - The records in CSV-1 contain authoritative names to which the records in CSV-2 must be normalized. - The program should allow a user with the "key" (CSV-1) to process their own CSV-2 in order to generate a CSV-3. - A CSV-3 has rows with 2 columns, just like CSV-2, but this time every name has been replaced with the ID (from CSV-1) of the authoritative name that it matches. - The catch is that the names may be spelled differently in unpredictable ways so the program will have to use one or more of the following: * fuzzy logic * interactive processing My Solution: The program will take the key (CSV-1) and source (CSV-2). It will then automatically replace any exact matches without the need for user-intervention. The program will then allow the user to step through the remainders in CSV-2 and select any names from CSV-1 to match them with. This might involve some fuzzy logic to provide a short-list of possible matches, even if it's just by initial. Are the lists expected to be too large for stepping to be feasible?
$180 USD in 3 days
4.9 (38 reviews)
7.4
7.4
User Avatar
Hi I'm interested in your project. I can compete the functionality the functionality as you want. Please accept the bid and create the milestone. I am ready to start the project.
$99 USD in 3 days
5.0 (100 reviews)
5.6
5.6
User Avatar
Hi. I have review your job description carefully. I am a highly skilled developed with 6+ years experience in full stack web development, cross platform mobile app development like Ionic, Xamarin, Unity, Phonegap, web scraping & crawling, reverse engineering and programming like c++,python,java,node js or something. Also I have already experienced with the job similar to this job. Please contact me. Looking forward to hearing from you soon. Best regards. bestit4u. PS: Please don't mind the price, The price will be flexible according to more job details and what you want.
$166 USD in 3 days
4.9 (15 reviews)
5.5
5.5
User Avatar
I am an expert in this field. Stay tuned, I'm is still working on this proposal.
$155 USD in 3 days
5.0 (7 reviews)
4.3
4.3
User Avatar
Hi, I am an experienced python coder with expertise in data processing. I'd be happy to write a tune-able script with fuzzy logic to 'normalize' names to your CSV. Regards, Erik Relevant Skills and Experience Python, Data Processing, Fuzzy Logic, CSV Proposed Milestones $180 USD - Deliver python source code implementing a fuzzy logic csv normalization Can you provide your baseline CSV and a few examples of 'client' CSVs?
$180 USD in 5 days
4.9 (2 reviews)
4.4
4.4
User Avatar
Hello, Honorable Hiring Manager, Relevant Skills and Experience I am Expert Web Developer & I have 7+ years of experience. Proposed Milestones $155 USD - Project Milestone
$155 USD in 3 days
5.0 (3 reviews)
3.6
3.6
User Avatar
Hello, Greetings! I have gone through your requirement you are looking for small website. I have 8 years of experience in web development. Relevant Skills and Experience Coding, Javascript Proposed Milestones $200 USD - . $200 USD - . From when we can start work?
$400 USD in 7 days
5.0 (6 reviews)
3.3
3.3
User Avatar
I have very reasonable and successful experience in the following: - 6 PHP+MySQL, node.js, JavaScript + Ajax sites: small auction site for car dealer, site for selling coupons for local shops and corporate site for insurance company. - all site were done by me from 0. I got just PSD files and did all responsive HTML coding for MAC/Win: FF/Chrome/IE/Safari. - I used WooCommerce to apply payment gateways, UPS API for shipping, OAUTH API (SSO 2); - I have great knowledge how develop well optimized DB and less about NoSQL DB; My previous employers always complimented me that I have good creative taste
$277 USD in 10 days
5.0 (2 reviews)
3.3
3.3
User Avatar
We are pretty neat at solving problems like this and experts in javascript. Have figured out a solution to this lets discuss as i can not write it here because of 200 char limit. Relevant Skills and Experience Javascript, problem solving Proposed Milestones $155 USD - Pay on completion
$155 USD in 3 days
5.0 (2 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$188 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can make write a code to do exactly what you want. Relevant Skills and Experience Javascript, python, database experience Proposed Milestones $77.5 USD - database $77.5 USD - search function
$155 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good experience with Python, & I can implement the solution you described in the project. I have built Python scripts that does something close to what you are looking for. Relevant Skills and Experience Python Proposed Milestones $75 USD - Python script that perfroms the vLookup & stores the results in a third CSV file $100 USD - provide the user with options to select which name from my CSV1 best matches the name in their CSV2
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We've done several project similar to your requirements .We've dedicated team of experts to deliver quality solution within your time frame.I can answer your queries on CHAT Relevant Skills and Experience 3-4 yrs Proposed Milestones $150 USD - Advance Milestones $150 USD - Project Completion
$300 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello I am mihir having more then 8 years of experience design/develop java/j2ee projects, very strong STRUTS,HTML,CSS,JQUERY, JDBC,SERVLET,JSP,EJBs, SWING, JIDESOFT. let's discuss specs in details Relevant Skills and Experience design/develop java/j2ee , STRUTS,HTML,CSS,JQUERY, JDBC,SERVLET,JSP,EJBs, SWING, JIDESOFT Proposed Milestones $77.5 USD - design $77.5 USD - develop, test
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jul 11, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.