Data
Orders- Time and Day
So, from the above graph, its clear that Maximum no of orders are placed between 10:00AM and 5:00PM on Sunday and Monday.
Actions: Develop strategies to increase sales during the quietest days of the week:
Offer discounts on certain items.
Offer free delivery with orders over a specific dollar amount.
Positive note: Customers can shop on a Wednesday or Thursday, and most likely, they will never encounter “out of stock” items or delivery/pick delays.
Product Portfolio
Bestsellers Products
The highest ordered products are Banana, Bag of Organic Bananas, Organic Strawberries and Organic Baby Spinach. So to increase the sale of Strawberries the retailer can put it near the Bananas.
Less Popular Products
Categorically we see what areas we can improve sales on by addressing various marketing strategies.
Product | Number_of_Orders | Category |
Green Chile Anytime Sauce | 1 | Non-organic |
Pure Coconut Water With Orange | 1 | Non-organic |
Saline Nasal Mist | 1 | Non-organic |
Fresh Scent Dishwasher Cleaner | 1 | Non-organic |
Mint Chocolate Flavored Syrup | 1 | Non-organic |
Product | Number_of_Orders | Category |
Organic Spaghetti Style Pasta | 1 | Organic |
Organic Vegetable Greens & Greens Juice Blend | 1 | Organic |
Organic Peppermint Lemonade | 1 | Organic |
Organic Lemon Gingersnap | 1 | Organic |
Reg; Organic Apple Cider Vinegar 16 Fl Oz | 1 | Organic |
Market Basket Analysis
To conduct an Association Rule Mining or Market Basket Analysis, we need to build the transaction dataset. We need to gather information about user_id, order_id, and products_name. This last feature needs to be converted into one row, so we can get all the items that have been bought in the same transaction or order.
## user_id order_id
## 1 112108 1
## 2 79431 36
## 3 42756 38
## 4 17227 96
## 5 56463 98
## 6 125030 112
## V1
## 1 Bag of Organic Bananas,Bulgarian Yogurt,Organic Whole String Cheese,Organic 4% Milk Fat Whole Milk Cottage Cheese,Organic Hass Avocado,Cucumber Kirby,Lightly Smoked Sardines in Olive Oil,Organic Celery Hearts
## 2 Super Greens Salad,Grated Pecorino Romano Cheese,Organic Garnet Sweet Potato (Yam),Organic Half & Half,Prosciutto Americano,Asparagus,Spring Water,Cage Free Extra Large Grade AA Eggs
## 3 Flat Parsley Bunch,Organic Biologique Limes,Bunched Cilantro,Fresh Dill,Shelled Pistachios,Organic Raw Unfiltered Apple Cider Vinegar,Green Peas,Organic Hot House Tomato,Organic Baby Arugula
## 4 Organic Whole Strawberries,Organic Grape Tomatoes,Organic Cucumber,Organic Blueberries,Roasted Turkey,Organic Pomegranate Kernels,Organic Raspberries
## 5 Natural Spring Water,Organic Orange Juice With Calcium & Vitamin D,Olive Oil & Aloe Vera Hand Soap,Baby Swiss Slices Cheese,Organic Free Range Chicken Broth,Organic Raspberries,Raspberry Sorbet Pops,Aluminum Foil,Organic Whole Grassmilk Milk,Plastic Wrap,Black Beans,Corn Maize Tortillas,Organic Extra Virgin Oil Olive,Organic Lemonade,Lavender Scent Laundry Detergent,Queso Fresco,Mild Diced Green Chiles,Organic Raw Kombucha Gingerade,Organic Sliced Provalone Cheese,Organic Coconut Milk,Organic Ketchup,Uncured Applewood Smoked Bacon,Organic Corn Starch,Garbanzo Beans,Organic Chocolate Almondmilk Pudding,Uncured Genoa Salami,Tomatoes Crushed Organic,Organic Stringles Mozzarella String Cheese,Black Beans No Salt Added,Organic 2% Buttermilk,Organic Zucchini,Organic Cinnamon Apple Sauce,Organic Seasoned Yukon Select Potatoes Hashed Browns,Whole Milk Greek Blended Vanilla Bean Yogurt,Unsalted Cultured Butter,Organic Yellow Onion,Natural Chicken & Maple Breakfast Sausage Patty,Geranium Liquid Dish Soap,Pinto Beans No Salt Added,Organic Italian Parsley Bunch,Guacamole,100% Organic Unbleached All-Purpose Flour,Bag of Organic Bananas,Organic Hothouse Cucumbers,Sliced Pepperoni,Crackers Oyster,Organic Unsweetened Almond Milk,Organic Garlic,Plastic Spoons
## 6 Organic Lemon,Coconut Water Kefir,Organic Hass Avocado,Umcka Elderberry Intensive Cold + Flu Berry Flavor,Premium Epsom Salt,Hickory Honey Barbeque Baked Potato Chips,Baked Sea Salt & Vinegar Potato Chips,Sea Salt Baked Potato Chips,Marinara Pasta Sauce,I Heart Baby Kale,Fresh Cauliflower## transactions as itemMatrix in sparse format with
## 131210 rows (elements/itemsets/transactions) and
## 306433 columns (items) and a density of 3.866984e-05
##
## most frequent items:
## Banana Bag of Organic Bananas Organic Strawberries
## 17611 14604 10241
## Organic Baby Spinach Large Lemon (Other)
## 9326 7724 1495295
##
## element (itemset/transaction) length distribution:
## sizes
## 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
## 7930 8337 8887 8798 9332 8999 8719 8098 7239 6454 5888 5229 4636 4220 3603 3332
## 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
## 2893 2521 2279 1877 1656 1461 1271 1118 924 821 726 548 524 448 373 328
## 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
## 264 237 212 142 134 125 107 66 59 65 42 55 33 28 28 19
## 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
## 16 17 16 17 10 5 5 6 3 3 1 5 1 1 2 4
## 67 68 70 72 74 76 78 82
## 2 2 1 3 1 1 2 1
##
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 3.00 6.00 10.00 11.85 15.00 82.00
##
## includes extended item information - examples:
## labels
## 1 #2 Coffee Filters
## 2 #2 Cone White Coffee Filters
## 3 #2 Mechanical PencilsThe summary(tr) is a useful command that gives us information about our transaction object. Let’s take a look at what the above output says:
There are 131,210 transactions (rows) and 306,433 items (columns). Note that 306,433 are the product names involved in the dataset, and 131,210 transactions are collections of these items.
The summary can also tell you the most frequent items.
Element (itemset/transaction) length distribution: This tells you how many transactions are there for 1-itemset, for 2-itemset, and so on. The first row indicates the number of items, and the second row shows the number of transactions.
For example, there are 7930 transactions for three items, 8337 transactions for four things, and 82 items in one transaction.
