Icon

JKISeason3-10_​RBre

Correcting Postal Addresses

Challenge 10
Level: Medium

Description: 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.

Author: Aline Bessa

Comments:
Addresses are store locations so only one number in street makes sense
not suitable for consumer addresses, as there could be several numbers at the same street.

URL: Dataset https://api.hub.knime.com/repository/Users/alinebessa/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2010%20-%20Dataset/usa_addresses.csv:data?version=current-state

Node 33DatasetNode 53has typocorrectNode 55Node 56Node 57DuplicateRow Filter CSV Reader String Manipulation Row Splitter String Manipulation Value Lookup Column Renamer Node 33DatasetNode 53has typocorrectNode 55Node 56Node 57DuplicateRow Filter CSV Reader String Manipulation Row Splitter String Manipulation Value Lookup Column Renamer

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: RB
Created at: 2024-07-17
On NodePit since: 2024-07-18
Last update: 2024-12-17
Created with KNIME version: v5.2.5
Tags: JKISeason3-10

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

Try NodePit Runner!