database cleaning/merging/deduplication & fuzzy matching
$30-250 USD
Paid on delivery
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.
Project ID: #5335522
About the project
Awarded to:
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK b More
18 freelancers are bidding on average $139 for this job
Hello, can help you on this. Using some common tools is not really the best way for it so need to do some custom scripts exactly for this project.
Dear Sir, I can import all your data to a mysql database and process it and filter the duplicate data. I can do it right now for you. Best regards Thanh.
Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a More
I like to discuss more details about the project and deliver the relevant tools to your needs .
Greetings, I have taken note of your request to clean a database in your position. I can do that for you since been a software developer I can write a module to achieve your objective. I have been doing this kind of More
Dear Palmweb, Let me help you, I will use SQL and querying will be easier. Could you send the whole data? I will send the result sample. Thanks
