Closed

Data merging and cleaning of about 20,000 records from 8 different excel files

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.

Two additional notes:
:: Please provide the final files in excel (.xls or.xlsx) format
:: I will only forward sample files to those shortlisted. I'll have a sample excel file with all of the fields I'd like to see in the master record, but you might find more when working through the files

I am still collecting some records this week so this project won't begin until next week

We will have future additional data to clean and merge with the master file so any suggestions that will help automate this task for us going forward will help us...

Thanks for bidding. I will award this project on Monday.

Skills: Big Data, Data Processing, Database Administration, Excel, SQL

See more: data merging cleaning, sample of bids, review of companies, processing the data, primary data, one key data, looking for duplicate data in excel, city of hope, about companies, yelp contact phone, merging companies, master excel, sort excel, merge data, master data, houzz, excel tools, excel duplicate, email me about more, email appending, data merge, combine excel, cleaning, cleaning company, appending

About the Employer:
( 31 reviews ) Vancouver, BC, Canada

Project ID: #4484198

70 freelancers are bidding on average $117 for this job

greggfletcher

Hello, i have expertise in data processing. I would like to see a sample of the files. Best Regards.

$262 USD in 5 days
(24 Reviews)
5.7
pishty

I am interested in your project.

$100 USD in 3 days
(29 Reviews)
5.6
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$79 USD in 4 days
(32 Reviews)
5.5
Nhcuong

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

$99 USD in 10 days
(24 Reviews)
5.0
THEHIGHTECHSOL

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 regar More

$84 USD in 3 days
(26 Reviews)
4.9
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$99 USD in 3 days
(14 Reviews)
4.4
dpune

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.

$110 USD in 3 days
(13 Reviews)
4.2
abbie3290

I have experience in SQL. I can help you in this. Please check PMB.

$275 USD in 3 days
(19 Reviews)
4.1
pablotorres

i can do it

$30 USD in 7 days
(14 Reviews)
3.9
innovese

I have lots of experience with databases (SQL, MongoDB, SQL Server) and can start immediately for you.

$165 USD in 3 days
(4 Reviews)
3.9
Reza2012

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.

$90 USD in 3 days
(5 Reviews)
3.7
ideadezigner

Sir, I can do this job

$34 USD in 7 days
(8 Reviews)
3.6
jitendraparmar07

I've done similar type of work many [url removed, login to view] check your PMB.

$147 USD in 3 days
(4 Reviews)
3.5
jiashahood

Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks

$99 USD in 3 days
(7 Reviews)
3.2
ramlak

Excel expert ready to start the work. Let's start

$159 USD in 5 days
(6 Reviews)
3.2
omaralieissa

Hi, easy task if done through programming, please let me know if you are interested in a program which will make this task, i can do it, thanks.

$82 USD in 3 days
(5 Reviews)
3.0
charmw

Dear Mr. Gruen: I have experience creating Excel solutions; including combining multiple files, automated duplication detection, separate exception tracking, and report generation. I am very detail-oriented, with expe More

$154 USD in 3 days
(4 Reviews)
2.9
counterpuncher

For your consideration. Thanks.

$55 USD in 3 days
(3 Reviews)
2.9
DataDKR

I can create standard or customized algorithms according the needs of the project.

$133 USD in 10 days
(3 Reviews)
2.8
muzammil21

we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB

$144 USD in 3 days
(4 Reviews)
2.6