Using OpenRefine to clean addresses - Cluster Exact Match

Question

I am using Open Refine to clean up some addresses in a sheet (.csv). How do I cluster exact match in a column? It seems that the clustering algorithm will cluster addresses that are almost similar which only differs in the number. For example:

56, LORONG RENGAS, SELANGOR
76, LORONG RENGAS, SELANGOR
90, LORONG RENGAS, SELANGOR
76, lorong rengas, selangor
56, LORONG RENGAS, SELANGOR

How do I use OpenRefine to cluster these addresses according to exact match? Question sounds silly but I'm losing my head over this thing.

Thanks

score 1 · Accepted Answer · answered Dec 04 '14 at 12:49

1

Did you try using the facet function? Facet group records based on an extact match. You can watch those video on faceting and data profiling.

answered Dec 04 '14 at 12:49

magdmartin

1,712
3
20
43

1

Thanks, I've watched the videos and after cracking my head for a while I finally managed to do so by adjusting the parameters when doing the clustering. – antsemot Dec 12 '14 at 05:00
1

@Hack-R please try again. This should be fixed. – magdmartin Jun 29 '18 at 17:11

Using OpenRefine to clean addresses - Cluster Exact Match

1 Answers1