Icon

Correcting_​Postal_​Addresses _​JKISeason3-10

You work as a data analyst for a delivery company, and some packages were not delivered last week due to address typos. Thanks to the postal carriers, addresses that were not found due to typos were marked as such. Given a dataset with successful deliveries (due to no typos) and unsuccessful ones (due to typos), your goal is to automatically fix the incorrect addresses by leveraging the correct ones.

Solved by value lookup and String matcher

Method 1:Use String Matcher Method 2:Value lookup Formatting the ZIp code: Usa Address_csvsplit address by ,New full addressNode 6split by typo Created a unique listremaning the columnadd zeros to zip codewhere length is less than 5created a new column state,city and zipcodefind the value in dictiuonary columncreated a new column state,city and zipcode CSV Reader Cell Splitter String Manipulation String Matcher Row Splitter DuplicateRow Filter Column Renamer Column Expressions String Manipulation Value Lookup String Manipulation Method 1:Use String Matcher Method 2:Value lookup Formatting the ZIp code: Usa Address_csvsplit address by ,New full addressNode 6split by typo Created a unique listremaning the columnadd zeros to zip codewhere length is less than 5created a new column state,city and zipcodefind the value in dictiuonary columncreated a new column state,city and zipcode CSV Reader Cell Splitter String Manipulation String Matcher Row Splitter DuplicateRow Filter Column Renamer Column Expressions String Manipulation Value Lookup String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: girib
Created at: 2024-07-19
On NodePit since: 2024-07-19
Last update: 2024-09-16
Created with KNIME version: v5.3.0
Tags: JKISeason3-10Justknimeit

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!