Edinburgh Bakery Sales Data
Retail & Consumer Behavior
Tags and Keywords
Trusted By




"No reviews yet"
Free
About
This dataset pertains to "The Bread Basket", a bakery situated in Edinburgh, and is ideally suited for Market Basket Analysis. It records customer transactions for various items ordered online, providing insights into purchasing patterns. The dataset encompasses 20,507 entries and over 9,000 unique transactions, captured over a period spanning from 26 January 2011 to 27 December 2003.
Columns
- Transaction: A unique identifier for each customer order. This column includes various statistical measures such as mean, standard deviation, and quantiles, indicating a wide range of transaction IDs.
- Item: Lists the specific items purchased by customers. Analysis shows Coffee as the most common item (27%), followed by Bread (16%), with other items making up the remaining 57%. There are 94 unique items recorded.
- date_time: Captures the exact date and time of each transaction, formatted as dd-mm-yyyy hh:mm. This column has 9,182 unique date and time entries.
- period_day: Specifies the period of the day when an order was placed. The majority of transactions occur in the afternoon (56%), followed by the morning (41%), with a small percentage falling into other periods.
- weekday_weekend: Indicates whether the transaction occurred on a weekday (62%) or during the weekend (38%), providing context on buying habits across the week.
Distribution
The dataset is provided as a CSV file named "bread basket.csv", with a size of approximately 975.95 kB. It contains 20,507 individual entries across five columns, representing over 9,000 distinct transactions. Specific numbers for rows or records are available through the entry count.
Usage
This dataset is perfectly suited for various analytical applications, including:
- Market Basket Analysis: To identify associations between items frequently purchased together.
- Exploratory Data Analysis (EDA): To uncover initial patterns, anomalies, and test hypotheses within the bakery's sales data.
- Data Cleaning: The structure allows for practice in data validation and preparation.
- Insights into customer purchasing behaviour based on time of day and day of the week.
Coverage
The geographic scope of the data is limited to "The Bread Basket" bakery in Edinburgh. The time range for the transactions spans from 26 January 2011 to 27 December 2003. No specific demographic details are provided beyond the general customer base of the bakery. The dataset contains 20,507 entries and more than 9,000 transactions, providing a rich record of sales during this period.
License
CC0: Public Domain
Who Can Use It
This dataset is highly beneficial for:
- Retail analysts and business strategists: To understand sales patterns, optimise product placement, and develop targeted promotions.
- Data scientists and students: For practical application of market basket analysis algorithms, data cleaning techniques, and exploratory data analysis using programming languages like Python.
- Researchers: Studying consumer behaviour in the food retail sector.
Dataset Name Suggestions
- The Bread Basket Bakery Transactions
- Edinburgh Bakery Sales Data
- Market Basket Analysis for Bakery
- Bakery Customer Order History
Attributes
Original Data Source: Edinburgh Bakery Sales Data