Icon

Using Association Rules for Market Basket Analysis

Market Basket Analysis: Apply Association Rules

This workflow takes pre-built association rules and applies them to a new set of data

URL: Market Basket Analysis and Recommandation Engines https://www.knime.org/knime-applications/market-basket-analysis-and-recommendation-engines

BLOG: Market Basket Analysis and Recommandation Engines https://www.knime.org/blog/market-basket-analysis-and-recommendation-engines

Market Basket Analysis: Deploy Association RulesTask. Apply the pre-built association rules to a new set of dataA use case is described at URL: https://www.knime.org/knime-applications/market-basket-analysis-and-recommendation-enginesCheck how to work with collections at the following URL: https://www.knime.org/blog/collection-cookbook Data Reading3 files: - Association rules - Products info - Read current basket data. The files are located in TheData/BasketsFor the basket data, in this case we used a Table Creatornode. You can read your current basket data from yourdatabase or from whatever source. Double-click the metanode to see the subworkflow ReportingDisplay the two recommendations in a report. Data Processing - Find the best match for the current basket using the Subset Matchernode - Find top matching rules in terms of highest support, highestconfidence, and highest revenue - Calculate total price of current basket - Append price of current basket - Split the two top recommendations in two different tablesDouble-click the metanode to see the subworkflow Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report”button in the toolbar (make surethat the KNIME Report Designerextension is installed. If not, go toFile, then Install KNIMEExtensions/KNIME ReportDesigner)3) Select "Run" from the reportenvironment 4) Choose your preferred format tosee the final report.Note: If you have changed theKNIME Workbench, click View/Reset Perspective to see allpanels in the Report Designer Read association rules and product infoRecommendationFind best match for yourcurrent shop cartInsert the content of your shop cart through a Table Creator nodeRecommendation 2Calculate total price of current basketFind top 2 rulesby: support, confidence, revenueAppend price ofcurrent basketand split the tworecommendationsTransforms string rowinto item collection Product Infos /Association Rules Data to Report Subset Matcher Table Creator Data to Report Total Price ofcurrent Basket Top 2 Rules Refine Cell Splitter Market Basket Analysis: Deploy Association RulesTask. Apply the pre-built association rules to a new set of dataA use case is described at URL: https://www.knime.org/knime-applications/market-basket-analysis-and-recommendation-enginesCheck how to work with collections at the following URL: https://www.knime.org/blog/collection-cookbook Data Reading3 files: - Association rules - Products info - Read current basket data. The files are located in TheData/BasketsFor the basket data, in this case we used a Table Creatornode. You can read your current basket data from yourdatabase or from whatever source. Double-click the metanode to see the subworkflow ReportingDisplay the two recommendations in a report. Data Processing - Find the best match for the current basket using the Subset Matchernode - Find top matching rules in terms of highest support, highestconfidence, and highest revenue - Calculate total price of current basket - Append price of current basket - Split the two top recommendations in two different tablesDouble-click the metanode to see the subworkflow Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report”button in the toolbar (make surethat the KNIME Report Designerextension is installed. If not, go toFile, then Install KNIMEExtensions/KNIME ReportDesigner)3) Select "Run" from the reportenvironment 4) Choose your preferred format tosee the final report.Note: If you have changed theKNIME Workbench, click View/Reset Perspective to see allpanels in the Report Designer Read association rules and product infoRecommendationFind best match for yourcurrent shop cartInsert the content of your shop cart through a Table Creator nodeRecommendation 2Calculate total price of current basketFind top 2 rulesby: support, confidence, revenueAppend price ofcurrent basketand split the tworecommendationsTransforms string rowinto item collection Product Infos /Association Rules Data to Report Subset Matcher Table Creator Data to Report Total Price ofcurrent Basket Top 2 Rules Refine Cell Splitter

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: rosy
Created at: 2015-03-23
On NodePit since: 2020-07-16
Last update: 2024-04-17
Created with KNIME version: v4.1.0
Tags: retail association rules recommandation engine market basket analysis MBA Apriori algorithm Borgelt data collection Quickform deployment

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

Try NodePit Runner!