harmonizing name of firms manually
$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
Awarded to:
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 More
29 freelancers are bidding on average $201 for this job
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 More
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 wi More
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
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.
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 More
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.
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
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 s More
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
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.
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 More
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’l More
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 More
Saya sudah terbiasa dengan excel lebih dari 10 tahun, dengan menggunakan rumus vlookup/hlookup,Concatenate dll, saya merasa yakin bisa menyelesaikannya sesuai permintaan