Find Jobs
Hire Freelancers

harmonizing name of firms manually

$30-250 USD

Completed
Posted about 6 years ago

$30-250 USD

Paid on delivery
In "[login to view URL]," there are 459,903 different names of firms sorted alphabetically (only first half included here due to file size limit). The first column was created from a code to standardize names of firms from multiple data sources. We would like to harmonize the data further manually. For example, "l a county high for the arts" and "l a county high school arts" are effectively the same firms but shown as different. Another example is "l and t tech service" and "l and tech service." Some cases will be not so clear, then use your discretion and make the best guess, or google original firm names if that helps. When you find those cases, go to "[login to view URL]" and enter name to keep and name to change. It could be arbitrary but keep more standard looking name: "l a county high school arts" and "l and tech service" from previous examples. If there are more than two names to change, copy a name to keep twice and list names to change in multiple rows. For uncertain cases, please make a note. Do exactly the same exercise for 116,586 observations in "[login to view URL]" using "revisions_2.xlsx." Quote total time and price and let me know how you will proceed. Any ideas are welcome. I expect to have less five percent of false positive and false negative errors. I will randomly pick cases and check if those were harmonized well, and vice versa before ending the project. I will also have similar projects coming ahead.
Project ID: 16447657

About the project

29 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
Hi, I received an invitation to bid on this project. I have gone through the details and going through the excel files. I am interested to work on this project. Please go through my reviews so that you are confident about me. Hope to chat soon Thanks Sajid
$250 USD in 13 days
4.8 (35 reviews)
4.8
4.8
29 freelancers are bidding on average $201 USD for this job
User Avatar
Dear Sir, I have gone through your project details and understand that you need to harmonize the data further manually. I have 5 years of experience in Data Entry, Data Mining, Data Processing, Excel, Web Search I will find the name match in the sheet and harmonize the data. Kindly ping me to discuss further details.
$250 USD in 3 days
4.9 (285 reviews)
7.7
7.7
User Avatar
Hello MUNSEO , I have done very similar work OF FINDING SIMILAR NAMES 6 months before. i have rad your project description and checked the attached files. We are team of 6 people. We will do manual work and finally will do google search also to complete remaining ones.
$300 USD in 6 days
4.8 (418 reviews)
7.4
7.4
User Avatar
Hi, I am a highly trained on Data Entry ,Data Analysis, Copy Typing, Data Mining, Research, Web search, scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel. Thanks
$500 USD in 3 days
4.9 (155 reviews)
6.4
6.4
User Avatar
Hello, I have read your project description and not so clear, I have some question. Please send me a message for discussion. My bid price is negotiable.
$500 USD in 10 days
5.0 (74 reviews)
5.7
5.7
User Avatar
Dear Sir, I have read your job description & have understood your all requirement. I have also a big team to complete it earlier. After seeing my previous record, You will decide that I will be the right person for you. Now you can justify me and give me a chance to serve you. Best regards Md. Tanjir Hossain
$155 USD in 3 days
5.0 (170 reviews)
5.9
5.9
User Avatar
I am very able to harmonize names manually I am ready to start regards
$144 USD in 3 days
4.7 (107 reviews)
6.3
6.3
User Avatar
Hello, Good day! I can complete the project within your specified deadline. You are rest assured of the quality of my work. You can check my profile for review. Thank you.
$166 USD in 3 days
4.6 (66 reviews)
5.4
5.4
User Avatar
i have checked your attached excel file. i can do this. let me make some sample for you, if you like my work then i can tell u full price and time
$144 USD in 3 days
5.0 (11 reviews)
3.9
3.9
User Avatar
Dear Sir/Madam, I would like to offer my bid and a method to check 576,489 observations with close to 1% of false positive and false negative errors. Starting with column zip code instead of name, entries with the same zip code next to each other are more likely to be names of the same firm. I will focus on the zip code while cross checking at the same time with the names. The errors can come from 2 factors: (1) zip code is wrong and (2) different names of the firms are not in alphabet order. For the names that I sort out, I'll check 100% on google for the correct names. Besides the method, you will also have a detailed-oriented and hard-working student for your project to keep the errors minimal. This is what I can think of right now so thanks to consider my proposal. I'll not let you down. I hope to have a chance to work with you. Best regards, Giang.
$250 USD in 10 days
5.0 (7 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$35 USD in 3 days
4.7 (5 reviews)
2.3
2.3
User Avatar
Greetings, experienced professional in the field of Macros and Excel Spreadsheet, having more than 5 years experience in such projects. Allow me to complete your task. Best Regards
$155 USD in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Hi, This is jee. I read your given requirement and we are ready to do the samples before you award the job. Once you have satisfied with the sample of work then you award the job to us. Please advise, Jee.
$90 USD in 2 days
5.0 (1 review)
1.0
1.0
User Avatar
hello, i have read your description. i am the best who complete your task, so accept the offer to start work as soon you deliver. thanks regards. Pervaiz Ali Soomro Relevant Skills and Experience i have an experience of 15 years in word, excel with all formulae, power point as well.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience harmonizing information to remove redundancies from my job as a Data Entry Analyst. I can harmonize the names of firms on the excel file in a timely and accurate manner. I understand that at times I’ll need to search up the firms' names in order to verify that it is the same firm and not similarly named firms. I also understand that my discretion will be required to determine what is the standardized version of the firm’s name. I will strive to follow your instructions and complete the project in a timely manner.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i have gone through the job summary and I am very much intrested in working on this project. Kindly message me the file with the records as I am not able to view the uploaded files. Relevant Skills and Experience Expert in excel. Data entry Data processing
$133 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$144 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Saya sudah terbiasa dengan excel lebih dari 10 tahun, dengan menggunakan rumus vlookup/hlookup,Concatenate dll, saya merasa yakin bisa menyelesaikannya sesuai permintaan
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
La Jolla, United States
5.0
4
Payment method verified
Member since Nov 3, 2015

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.