Retail Basket Analytics: Customer Purchase Behavior & Product Affinity Insights

By abhishek.verma75000 · April 30, 2026

This report delivers a comprehensive analysis of customer purchasing behavior across 9,835 transactions, focusing on basket size distribution, item…

The analysis identified the most frequently purchased item pairs from your basket data. A horizontal bar chart has been generated showing the top 15 item pairs ranked by how often they appear together in the same basket, with color intensity indicating frequency.

The analysis identified the most frequently purchased grocery items across all transactions. A horizontal bar chart was generated showing the Top 20 Most Frequent Grocery Items, with items ranked by how often they appear. The chart uses a color gradient to highlight frequency differences, making it easy to spot the most popular items at a glance.

The analysis examined which items appear most frequently in large baskets containing 10 or more items. Two data tables were generated showing the item frequency results from these large basket transactions.

The basket size distribution across 9,835 transactions is right-skewed, meaning most customers buy just a few items per visit. Two bar charts and supporting data tables were generated to visualize this pattern — one showing the full distribution by exact item count, and another grouping transactions into categories (1 item, 2-3 items, etc.).

The analysis reveals which items customers most commonly place first in their shopping baskets, indicating priority or planned purchases. A horizontal bar chart and data table have been generated showing the top 15 priority items. Sausage tops the list, appearing as Item 1 in 825 transactions (8.39%), followed by whole milk (717 times, 7.29%) and frankfurter (580 times, 5.9%). Meat and dairy products dominate the top spots, suggesting these are the most intentional, planned purchases.

The analysis compared 2,159 single-item transactions against 7,876 multi-item baskets, revealing very different shopping behaviors. Two bar charts were generated showing the top 10 items for each basket type, along with a share comparison chart. Single-item trips are dominated by impulse or quick-grab purchases like canned beer (12.0%), soda (7.2%), and bottled beer (5.6%) — suggesting customers popping in for a specific drink. Multi-item baskets tell a different story, led by pantry staples: whole milk appears in 31.2% of larger baskets, followed by other vegetables (24.0%), rolls/buns (22.1%), and soda (20.3%). Items like whole milk and rolls/buns appear in both lists, but their dominance is far greater in multi-item baskets.

Across 9,835 transactions, the average basket size is 4.41 items, with a median of just 3 items — meaning most shoppers buy a small number of products. The distribution ranges from 1 to 32 items. A large majority (70.78%) of transactions contain 5 items or fewer, while only 6.61% have more than 10 items. The middle tier (6–10 items) accounts for 22.61% of transactions. Two visualizations were generated: a bar chart showing the full distribution of basket sizes with the average marked, and a pie chart breaking transactions into the three size categories.

The analysis examined how product variety changes across all 32 item positions in transactions. A bar chart was generated showing the number of unique items at each position (Item 1 through Item 32), along with a data table detailing the unique item counts and the percentage of transactions that include an item at each position.

The analysis successfully identified the top 20 most frequently purchased grocery items across all 32 basket position columns. A horizontal bar chart has been generated showing each item ranked by total count, with percentage labels displayed on each bar. A data table is also available with the full breakdown of counts and percentage shares for each item.

The analysis scanned all Item columns across the dataset and mapped every grocery item into higher-level categories. Two visualizations were generated: a pie chart showing each category's share of total basket appearances, and a ranked horizontal bar chart showing categories from least to most popular. Dairy dominates shopping baskets with 8,694 appearances, closely followed by Produce (8,232) and Beverages (6,237). Meat/Fish rounds out the top five with 3,708 appearances.

The analysis examined how often the top 10 most popular items appear together in the same transaction. Two visualizations were created: a heatmap matrix showing co-occurrence counts between all pairs of top-10 items, and a bar chart showing what percentage of each item's transactions also contain another top-10 item. The top 10 items by frequency are whole milk, other vegetables, rolls/buns, soda, yogurt, bottled water, root vegetables, tropical fruit, shopping bags, and sausage. The strongest product affinity is between 'whole milk' and 'other vegetables', which co-occur in 736 transactions — the highest pairing in the dataset.