Data merging and cleaning of about 20,000 records from 8 different excel files
This project received 70 bids from talented freelancers with an average bid price of $117 USD.Get free quotes for a project like this
I have about 20,000 records of companies from 8-10 different sources in excel tables. The data has a number of different fields with some tables having more data than others. Most of the table have a minimum of
:: BUSINESS NAME
:: CITY, STATE, ZIP
:: Contact Name
:: Additional Fields could include: Keyword (specific to source), Primary NAIC code, Rating (Yelp, Yellowpages, Houzz), Trade Associations, Project Size, Year Established, Category, License(s), Geographic area served, Map ID (URL) and others...
I would like bids for the following data merging and cleaning deliverables:
:: combine files into one master file encompassing all of the fields available across the files (save this file separately)
:: merge any duplicate records, appending any additional fields so that each company record is complete
:: remove any duplicate records that couldn't be merged to or appended to the other existing records (save this as a separate worksheet)
:: sort by state and provide me with counts by state (please enter summary in separate worksheet)
Accuracy, and attention to detail are key for this project. We are looking for someone with SQL or high level excel skills to complete this task using scripts or cleaning tools. After as much automated merging and cleaning as possible can be completed, please review a sample of the records manually to ensure accuracy. We will check final records for accuracy and to ensure that no companies have been deleted....
Looking forward to working with you. We will select a bidder early next week (May 6, 2013)and hope the project can be completed in a few days.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online