database cleaning/merging/deduplication & fuzzy matching - repost

Cerrado Publicado Jan 18, 2014 Pagado a la entrega
Cerrado Pagado a la entrega

I have a DataBase I'm building (excel) that contains records from many different sources. 77k rows and 50+ columns in total.

I would like to condense it by unique address but keep all the other unique data cells in the rows.

This will require some type of fuzzy matching as the duplicate addresses are not all 100% exact, ie:

300 Water Street suite #3 | Portland | Oregon

300 Water Street | Portland | Oregon

300 Water St | Portland | Oregon

The above examples would all be the same record. Each row may have different corresponding data in the columns that needs to be condensed into one row.

I have normalized the data as much as I can using my limited excel skills and powergrep. I have made sure the states, cities and abbreviations are all consistent for easier duplicate recognition.

I estimate that there is probably 20k actual unique addresses, which is what this should be condensed to, but keeping all the unique cells. making a very rich data set at the end.

I'm not sure if Excel can handle this type of project perhaps you have a better solution using sql or VBA Access or some other db manipulation/deduplication tool.

Let me know via PM how you would best tackle this.

Big Data Sales Administración de bases de datos Excel Microsoft Access MySQL

Nº del proyecto: #5335763

Sobre el proyecto

4 propuestas Proyecto remoto Activo Feb 25, 2014

4 freelancers están ofertando un promedio de $183 por este trabajo

mattsrinc

Hi, your file would be best processed with R (programming language). I understand you need to "deduplicate" addresses only and that you have "states, cities and abbreviations" already the same for the same data (but I Más

$177 USD en 2 días
(33 comentarios)
5.0
Beacon09

A proposal has not yet been provided

$200 USD en 14 días
(2 comentarios)
3.0
logoDS761

Hello, i am very experienced vb6 / vba macro coding in all Ms. Office Excel/Access/Word/Powerpoint + Vb.net 2005/2013 and will do this excellent quality for you!

$155 USD en 3 días
(2 comentarios)
1.4
cimemi

Hello, I would try to import the data into MySQL, and do the cleaning using DB queries. Please send me the data in order to check if this is possible.

$200 USD en 5 días
(0 comentarios)
1.9