This exercise is aimed at introducing you to association rule mining. The Excel data set baskets1ntrans.xlsx has around 2800 observations/records of supermarket transaction data. Each record contains the customer’s ID and Products that they have purchased. Use this data set to understand the relationships among products (i.e., which products are purchased together). Look for interesting relationships and add screenshots of any subtle association patterns that you might find. More specifically, answer the following questions.
• Which association rules do you think are most important?
• Based on some of the association rules you found, make at least three business recommendations that might be beneficial to the company. These recommendations may include ideas about shelf organization, upselling, or cross-selling products. (Bonus points will be given to new/innovative ideas.)
• What are the Support, Confidence, and Lift values for the following rule?
• Wine, Canned Veg → Frozen Meal