In Progress

Data merge- Address matching

The project is to merge datasets. I have a master dataset of 50,000+ entities. This data includes business name, business address, longitude/latitude, etc. This is in text (tab delimited) format. Then, I have a file of about 10000 entries each that contain business name, address, longitude/latitude. 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.

Skills: Data Processing, Excel

See more: data processing business, how to master excel, business entities, merge data, master data, longitude, latitude, data merge, data longitude, tab delimited text, tab delimited format, address name format, merge excel project, delimited data, match merge excel, matching excel file, data matching project, matching excel, address excel format, name data processing business, names data processing business, excel data matching, tab data, longitude latitude excel, excel delimited

About the Employer:
( 30 reviews ) New Haven, United States

Project ID: #1284185

Awarded to:

greggfletcher

Hello.

$400 USD in 4 days
(39 Reviews)
6.4

60 freelancers are bidding on average $294 for this job

opu00

======= please check pm for details....Thanks ========

$250 USD in 5 days
(261 Reviews)
7.1
fareastern

Hi judy, please check my private message.

$250 USD in 2 days
(102 Reviews)
6.9
Dhruvika111

Dear judykitch, Please check your PM For Professional Quote and details. Thanks Dhruvika

$300 USD in 3 days
(104 Reviews)
6.9
diamond247

Expert here, we complete 12 project for verification which is same as your project, please see the PM for more details

$262 USD in 3 days
(81 Reviews)
6.5
nikhil08

Hi, Please check Inbox for details.

$250 USD in 2 days
(61 Reviews)
6.4
danielgpratidya

I'm in ****>>>

$250 USD in 1 day
(115 Reviews)
6.1
binaryromel

##### Experienced! Please check PM. #####

$250 USD in 2 days
(68 Reviews)
5.7
nagybatonyi

There are refined Excel matching methods. Exact matches can be filtered out easily, the remaining part shall also be partially matched and visually supervised for 100% accuracy. If you send me a sample, I'm going to sh More

$280 USD in 3 days
(53 Reviews)
5.7
yourjmr

I have read and understood the project details. Check PMB for more details.

$250 USD in 2 days
(81 Reviews)
5.4
hemi

Please refer private message for all details regarding this bid. Thanks in advance.

$270 USD in 6 days
(27 Reviews)
4.8
ExactSystems

Please see detail on PMB. regards

$250 USD in 3 days
(5 Reviews)
4.6
AlexMU17

Ready to do it manually and with excellent accuracy. Please read a private message for details.

$250 USD in 7 days
(19 Reviews)
4.5
candida

I am a 1st class degree holder in Computing and Information Systems at London Metropolitan University, UK. I am with 5 years experience in data entry and online researches. I have done so many similar projects and I am More

$250 USD in 5 days
(13 Reviews)
4.4
Gooroo

Hello Mrs Judy! I am confident to do this correctly and efficiently using several methods & criteria. Kindly see PM! Experienced ICT & Office professional for over 20yrs. Just give me a chance, please! Thanks!

$275 USD in 2 days
(17 Reviews)
4.3
Engineer85

Hi I am interested in doing this project. Can complete in required time with accuracy. Please check PM for more details. thanks

$250 USD in 1 day
(13 Reviews)
4.4
stacross

We'd like to bid on your project "Data merge- Address matching". Have a look at PM.

$250 USD in 0 days
(18 Reviews)
4.2
shacoim

***Plz Check PM***

$250 USD in 5 days
(11 Reviews)
3.9
sujiumesh

hi, Please check the pmb

$250 USD in 3 days
(13 Reviews)
3.9
kaplar90

I am an expert at writing macros in excel and I can write a script that will compare the latitude and longitude which should be unique to each entry and merge the files with that script.

$275 USD in 2 days
(4 Reviews)
3.9
Shijidhar

Hai, Please refer PM for details. Thanks

$500 USD in 15 days
(5 Reviews)
3.7