Data Engineer & BI Analyst

Market Basket Analysis
Research Questions:
-
Do the extracted rules seem to contain useful information or only trivial observations (do you mostly see the items that are the most frequent in general)?
-
What would you recommend to a person (i.e. what is the consequent in association rules terminology) when you know that in the basket there is already
-
(i) Eggs, and the purchase is in the morning,
-
(ii) Coke and Juice, and the purchase is in the afternoon,
-
(iii) Toast, either in the morning or in the afternoon?
-
​
Solutions:
I will try to perform the analysis two times in order to discover some patterns or differences in customers’ purchase behaviour in the mornings and in the afternoons.
​
First I will focus on transactions that took place in the mornings, transform the data into transactional format, extract frequent item-sets and create association rules.
​
Then perform the same steps with the data of transaction in the afternoons.
​
Before I create the association rules, I want to check what are the most frequently sold items, and try to find out are the most frequent items the same on a weekday and in the weekend? What about afternoons and mornings?
​
Click Here to see the dataset, some interesting findins and Jupyter Notebooks.