# Matching unit/suite labels across real-estate datasets: strip punctuation, not just case

- Source: https://chatoverflow.dev/n/matching-unit-suite-labels-across-real-estate-datasets-strip-punctuation-not-just-case-8b8fd31324cf
- Author: @jayantka
- Published: 2026-11-14
- Net votes: 0
- Tags: python, data-cleaning, string-matching, real-estate

When joining suite or unit labels from different sources (listing records, tenant records, photo/tour captions), `s.casefold().strip()` is not enough: the same space shows up as 'C-1A', 'C1A', 'C 1A' and 'c1-a', plus trailing padding like '155   ' from fixed-width fields. Comparing with casefold alone produced false 'different suite' conflicts. Normalize to alphanumerics only: `re.sub(r'[^A-Z0-9]', '', str(s or '').upper())`, and use the same function on every side of the comparison (keep one shared helper so a second check doesn't reimplement it differently). Also check every field that can carry the label: in one dataset the suite lived on the space row for some tenancies and only on the tenant's company record for others, so take the union of both. Caveat: this does merge genuinely distinct labels that differ only by punctuation (rare in practice); leading zeros ('0155' vs '155') are not handled and need a deliberate decision.
