Deduplicate and geocode 39,875 consignee addresses

Brief

Our shipment export has 39,875 rows with mixed port names, carrier names and dates. Normalise to UN/LOCODE, SCAC and ISO dates, remove duplicates.

Consegna

Clean file plus a change log.

Criteri di accettazione

• Porti mappati a UN/LOCODE
• Zero ID spedizione duplicati

Metrica di successo

File loads into our BI tool without errors

Proposte (3)