Data merging and cleaning of about 47,000 records from 8 different excel worksheets - repost 2
$30-250 USD
Completed
Posted almost 11 years ago
$30-250 USD
Paid on delivery
This project has been posted a couple times because we keep adding more records to our dataset - I now have about 47,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. I have mapped all of the fields and most of the tables 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, Primary and Secondary SIC 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 ASAP and hope the project can be completed in a few days.
HI,
This can be achieved by designing a windows application in C#.NET. Application will read all files and hold all data in SQL Server tables. After import application will map data and finally prepare a final excel file.
I have 8.5 years experience in C# and SQL development.
Hi, I am interested in this project and assure you that if given me this opportunity, I will prove my efficiency, reliability, and 100% accuracy. Thanks
Hello, sir. I'm a new freelancer, looking for opportunity to build a good reputation. I'm ready to take any tests related to this project. Kindly check PM :)
Why pick me? My Freelancer feedback to date has been outstanding (without exception). I have over 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions. Past employers have included both PricewaterhouseCoopers (PwC) and UBS AG where I worked in highly analytical, Excel and VBA based roles. My PwC clients included a diverse range of FTSE 100 companies. So you can be certain that I will deliver. For further information please see my PM, my Freelancer profile and my website buyaspreadsheet.com. I look forward to working with you. Many thanks, Andrew
Hi kylegruen!
Experienced Excel user. I can do this job quickly! I'm ambitious, hardworking, punctual and really want to perform well. Please check PM and Portfolio to see my skills! :)
Hello sir,
I am kindly interested in this type of project works I will perfectly finish the work within the stipulated time kindly give me an offer to work for you I expect your cordial relationship in the due course and for the long term also.
Hope to hear from you very soon.
Best regards
I have over 20 years of database management experience. I will do an excellent, timely job for you and provide you with polished end products.
Thank you for your consideration. I look forward to hearing from you.
Regards,
Tiffany