Data merging and cleaning of about 20,000 records from 8 different excel files
$30-250 USD
Closed
Posted almost 11 years ago
$30-250 USD
Paid on delivery
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
:: ADDRESS
:: CITY, STATE, ZIP
:: PHONE
:: FAX
:: EMAIL
::WEBSITE
:: Contact Name
:: SOURCE
:: 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.
Will create a sample application that will do it automatically and in the end you will have your clean and neat data and application as well so in future if you want to do it again you can do it yourself.
Hi, I am expert in SQL and Excel both and complete this work easily. I am expert in this kind of work and already completed more than 195 projects. tks.
Hi I have more than nine years experience Database Administration and Data migration. let me get a chance to do the job. I will ensure you best quality of work. thanks.
Greetings,
We are good at excel , we got experience in doing such kind of projects, which can be verified with our feebacks.
You can proivde us with the file to clean, we can start working on it
thanks and regards
Dear Kyle, I can do this with high accuracy. I have done many similar jobs. Can provide a set of macros to process the data as you need.
Best regards,
Cuong NH
Kyle,
I have completed similar assignments already, but I am sending you an 'interactive' graph that will let you judge my Excel skills in data manipulation for yourself.
I will work under a Confidentiality and Non-Disclosure Agreement if you want, and will start as soon as you want next week. Based on your description I am confident you will have the 'blended' material back within 24 hours,
More details on the Private Message Board.
Bob Allen-Turl