Experiment 4 — Address Verification & Normalization

Experiment 4 — Address Verification & Normalization

Experiment Goal

This experiment validates and normalizes supplier addresses using an external address verification API. The goal is to ensure all addresses are complete, standardized, and consistent, even when variants or partial data exist.

Verification Process

  1. Data Loading: Import canonical supplier records from Experiment 3.
  2. API Requests: Submit addresses to an external verification API for cleaning and standardization.
  3. Normalization: Correct misspellings, expand abbreviations, and enforce consistent formatting.
  4. Comparison: Cross-check standardized addresses against input variants.
  5. Flagging: Mark records requiring manual review if verification fails.

Input Data

  • Source: Canonical supplier records from Experiment 3
  • Fields: Company Name, TIN, Address
  • API Used: External PH address verification service

Execution Controls

📊 Results Summary

✅ Total Addresses Processed: 50
🟢 Successfully Standardized: 47
🟡 Minor Discrepancies: 2
🔴 Failed Verifications: 1

Conclusions

  • Address verification successfully standardized 94% of records.
  • Minor discrepancies were due to abbreviations and formatting differences.
  • One failed verification highlights the need for manual review on exceptions.
  • Clean addresses are now prepared for inclusion in the final consensus supplier registry (Experiment 5).