Lengkap

Data merge- Excel/DataProcessing

The project is to merge datasets. I have a master dataset of 5138 entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have 51 files of 50-150 entries each that contain business name, address, longitude/latitude. These 51 files merged into one long file. I want the entity identifier from the master data set matched onto the entries on the second dataset. The names and addresses will match but not always textually exactly. (For example, the address in one might say 5158 S Windsor Dr and the address in the other might say 5158 South Windsor Dr).

Please specify how you would do this. By hand is one possibility, but you must have facility with US address/language conventions.

Kemahiran: Pemprosesan Data, Excel

Tentang Klien:
( 30 ulasan ) New Haven, United States

ID Projek: #1256940

Dianugerahkan kepada:

greggfletcher

Hello, i am an expert at data mining and consolidation. Please refer to your PMB. Regards.

$250 USD dalam sehari
(39 Ulasan)
6.4

21 pekerja bebas membida secara purata $256 untuk pekerjaan ini

diamond247

Hello, Business database expert. Let's speak in PM. Thanks

$250 USD dalam 3 hari
(81 Ulasan)
6.5
pishty

I am interested on your project. I left you a message for more details.

$250 USD dalam 3 hari
(49 Ulasan)
6.0
binaryromel

##### Excel expert here! Please check PM. #####

$250 USD dalam sehari
(68 Ulasan)
5.7
nagybatonyi

Most items can be matched by a series of refined matching formulas gradually decreasing the number of unmatched entries which shall be matched ba a final visual check. If you send me some sample files I'll do a pilot s Lagi

$250 USD dalam 2 hari
(53 Ulasan)
5.7
vbexcel

Excel/VBA expert - ten years experience.

$250 USD dalam 2 hari
(28 Ulasan)
5.5
dataconsultants

Please check PMB for details, Thank you

$270 USD dalam 3 hari
(71 Ulasan)
5.4
MDavidCrompton

Hi, This is not a problem I have done several such projects. Check my feedback and a reference in private message. I would set up multiple match criteria and then ultimately visual check. The result would be spot on. Lagi

$300 USD dalam 4 hari
(26 Ulasan)
5.0
psprongs

Hi, I have a good deal of experience in excel data processing. I can help with merging of the datasets and can start immediately. Please check PMB psprongs

$250 USD dalam sehari
(10 Ulasan)
4.5
abbie3290

Please check your PMB.

$250 USD dalam 5 hari
(20 Ulasan)
4.5
jkumarsanson

Please refer my inbox

$250 USD dalam 2 hari
(10 Ulasan)
3.4
Uthe2009

Hello, I'm available to work on your data conversion task. Thank you.

$250 USD dalam 5 hari
(7 Ulasan)
3.1
prabhabusiness

Hi, Please check PMB

$250 USD dalam 3 hari
(1 Ulasan)
1.0
BioDramaticGurl

Hello I'm so interested in this job and I've taken my ICDL with a very good knowledge of EXCEL , for more informations I've sent my CV in PM Thank you and hope to hear from you soon !

$300 USD dalam 5 hari
(0 Ulasan)
0.0
cristinacazacu

I can do that. I work in Excel.

$250 USD dalam 2 hari
(0 Ulasan)
0.0
Arctechno

Dear Sir, We can very well understand your requirement and will be happy to get started with the work. Please Send your File. I am ready to start this work immediately. Please Try us once & you will be HAPPY that you h Lagi

$250 USD dalam 2 hari
(0 Ulasan)
0.0
waheeduddin

Sir, i am ready to work on your project.

$250 USD dalam sehari
(0 Ulasan)
0.0
feathersky

I can use C# to finish this task. I have finished some code that can deal with CSV file and calculate the similarity of two string.

$250 USD dalam sehari
(0 Ulasan)
0.0
dangerald

i'm willing to do the job and deliver the goods ahead of time

$250 USD dalam sehari
(0 Ulasan)
0.0
jennibrite

Hello, I am new to freelancer, but this is a task I can do quickly and without error. I have expert level excel skills and a lot of experience with large sets of data. I will be following up with a personal message Lagi

$250 USD dalam 2 hari
(0 Ulasan)
0.0
raviprakash10

i am excel certified. I would be happy to talk more about the requirements and my approach. thanks

$250 USD dalam 2 hari
(0 Ulasan)
0.0