Hello, I am struggling for a long time with below Fuzzy matching. I have below dataset. This is already an output of a fuzzy match with matching for Name, City, State, Zip NameCityStateZipMIELEForest ParkIL60130MIELE BROADWAYForest ParkIL60130MIELE PARTNERS FULFILLMENTForest ParkIL60130MIELE PARTNERS WAREHOUSINGForest ParkIL60130 The output I am expecting is below, I want all the name to be same when the City State Zips are same: NameCityStateZipMIELEForest ParkIL60130MIELEForest ParkIL60130MIELEForest ParkIL60130MIELEForest ParkIL60130 Any suggestion would be highly appreciated.

Fuzzy match name cleansing

Hello,

I am struggling for a long time with below Fuzzy matching. I have below dataset. This is already an output of a fuzzy match with matching for Name, City, State, Zip

Name	City	State	Zip
MIELE	Forest Park	IL	60130
MIELE BROADWAY	Forest Park	IL	60130
MIELE PARTNERS FULFILLMENT	Forest Park	IL	60130
MIELE PARTNERS WAREHOUSING	Forest Park	IL	60130

The output I am expecting is below, I want all the name to be same when the City State Zips are same:

Name	City	State	Zip
MIELE	Forest Park	IL	60130
MIELE	Forest Park	IL	60130
MIELE	Forest Park	IL	60130
MIELE	Forest Park	IL	60130

Any suggestion would be highly appreciated.

Datasets

Text Mining

Accepted answers

pedrodrfaria

I have attached an example doing the previous way I suggested and also doing fuzzy matching.

Please remember to assign the post a solution so other people can see it as the answer to do Fuzzy Matching doing via Purge Mode.

Fuzzy match name cleansing.yxmd

All comments

pedrodrfaria

Hi @spencer046

You can definitely do a fuzzy matching logic to get to the point you want, however, if your only need is that specific, then you can just go ahead and use a much simpler logic:

Please let me know if you actually is required to do a fuzzy match or if the above solution does not solve your problem.

Please assign a solution to the post if your questions were answered.

Pedro.

Fuzzy match name cleansing.yxmd

spencer046

Hi @pedrodrfaria thank you so much. That's onw way of sorting that out, but I am more interested in learning if this can be sorted out using Fuzzy Matches. I also have names with different starts that have same city state zip.

Los Angeles_CA_90023 BAY CITIES C O BARBARA
Los Angeles_CA_90023 DDC CALIFORNIA
Los Angeles_CA_90023 Dependable Distribution Center
Los Angeles_CA_90023 LOS ANGELES SERVICE CENTER
Los Angeles_CA_90023 MEILE

I need to have a functionality where it can group different names under one name for same city state zip.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703