Icon

Association Rules - Excercise

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 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

Nodes

  • No nodes found

Extensions

  • No modules found

Links