Icon

Association Rules - Solution

hshld & tnsct count Create lookup table for "category names" to"category numbers" Association rules Sort Top Rules on basket by Lift readre_hw_data Rule engine to fixblank and NULLcategory = "NULL" Remove category= "NULL" Transformcategorynames tonumbers Create RuleID and ungroupAntecedents Convert column "category_name (tonumber)" to string Join Antecedent to category_name(to number) column Group by per RuleID and ConcatenateAntecedents, category_names columns; Join Consequent to correspondingcategory_name fix NULLNode 3Transform categorynames to numbersFilter category name and numbercheck they are uniqueConcatenate_transactionsTransform to listRetrieve association rulesNode 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Top rulesfor "lift" valuereadre_hw_datafilter NULL Rule Engine GroupBy Category to Number Column Filter GroupBy GroupBy Cell Splitter Association RuleLearner (Borgelt) RowID Ungroup Number To String(deprecated) Joiner (deprecated) GroupBy Column Rename(deprecated) Joiner (deprecated) Column Rename(deprecated) Sorter File Reader Rule-basedRow Filter hshld & tnsct count Create lookup table for "category names" to"category numbers" Association rules Sort Top Rules on basket by Lift readre_hw_data Rule engine to fixblank and NULLcategory = "NULL" Remove category= "NULL" Transformcategorynames tonumbers Create RuleID and ungroupAntecedents Convert column "category_name (tonumber)" to string Join Antecedent to category_name(to number) column Group by per RuleID and ConcatenateAntecedents, category_names columns; Join Consequent to correspondingcategory_name fix NULLNode 3Transform categorynames to numbersFilter category name and numbercheck they are uniqueConcatenate_transactionsTransform to listRetrieve association rulesNode 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Top rulesfor "lift" valuereadre_hw_datafilter NULLRule Engine GroupBy Category to Number Column Filter GroupBy GroupBy Cell Splitter Association RuleLearner (Borgelt) RowID Ungroup Number To String(deprecated) Joiner (deprecated) GroupBy Column Rename(deprecated) Joiner (deprecated) Column Rename(deprecated) Sorter File Reader Rule-basedRow Filter

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: malacaria.s
Created at: 2020-03-27
On NodePit since: 2024-09-24
Last update: 2024-10-18
Created with KNIME version: v5.2.0

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

Try NodePit Runner!