Find Jobs
Hire Freelancers

I would like to hire a Coder

$30-250 USD

已关闭
已发布将近 7 年前

$30-250 USD

货到付款
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.
项目 ID: 14627305

关于此项目

15提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
15威客以平均价$192 USD来参与此工作竞价
用户头像
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 在3天之内
4.9 (38条评论)
7.4
7.4
用户头像
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 在3天之内
5.0 (100条评论)
5.6
5.6
用户头像
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 在3天之内
4.9 (15条评论)
5.5
5.5
用户头像
I am an expert in this field. Stay tuned, I'm is still working on this proposal.
$155 USD 在3天之内
5.0 (7条评论)
4.3
4.3
用户头像
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 在5天之内
4.9 (2条评论)
4.4
4.4
用户头像
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 在3天之内
5.0 (3条评论)
3.6
3.6
用户头像
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 在7天之内
5.0 (6条评论)
3.3
3.3
用户头像
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 在10天之内
5.0 (2条评论)
3.3
3.3
用户头像
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 在3天之内
5.0 (2条评论)
2.9
2.9
用户头像
A proposal has not yet been provided
$188 USD 在5天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在4天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
0.0
0
会员自7月 11, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。