Dark Mode
Walmart Coffee Selection Analysis
Food & Beverage Consumption
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This dataset presents 1399 coffee listings from 500 Walmart stores, compiled as part of a SerpApi demonstration project focusing on search engine results. Its primary purpose was to facilitate the exploration of popular coffee sellers, prevalent coffee types, and other related market insights. Key findings from this dataset include Walmart being the most popular seller, with medium roast identified as the most common coffee type. Interestingly, a higher weight in grams does not always correlate with a higher price, and conversely, a lower gram coffee may be more expensive. The dataset captures significant details such as the "Folgers classic roast ground coffee" having over 15,000 reviews, which is the maximum recorded value, and the most frequent coffee weight falling between approximately 300-500 grams. The highest coffee price observed is £77 for a Lavazza perfetto single-serve k-cup.
Columns
- title: A string field detailing the full product title, for example, "folgers classic roast ground coffee, 40.3-ounce".
- coffee_type: A list of strings indicating the type of coffee, such as "medium roast". This column may contain missing values for some entries.
- rating: A float representing the average customer rating for the product, with values ranging from 0 to 5. The mean rating is approximately 3.98.
- reviews: An integer field indicating the total number of customer reviews for a product. The average number of reviews is around 441, with some products having over 15,000 reviews.
- seller_name: A string identifying the seller of the coffee product, with "walmart.com" being the most common.
- thumbnail: A string containing the URL to the product's thumbnail image.
- price: A float representing the price of the coffee product, measured in pounds sterling. Prices range up to £77.1, with a mean of £14.
- weight: A string indicating the original reported weight of the product, which can include various units or state "not mentioned".
- weight_formatted_to_gramms: A float providing the standardised weight of the product in grams, useful for quantitative analysis. The mean weight is approximately 621 grams, with the highest recorded weight being 2835 grams (2.8 kilograms).
Distribution
This dataset is provided as a CSV file, with a size of 391.35 KB. It comprises 1400 records (rows) and 9 distinct columns, offering a structured overview of coffee listings.
Usage
This dataset is ideal for:
- Market analysis and competitive intelligence in the coffee retail sector.
- Identifying popular products and sellers on large e-commerce platforms like Walmart.
- Pricing strategy analysis, including understanding the relationship between product weight and price.
- Customer review and rating analysis to gauge product success and consumer sentiment.
- Developing and testing data extraction and analysis scripts.
- Exploratory data analysis and data visualisation projects.
- Data cleaning exercises for product listing data.
Coverage
The dataset covers coffee listings from 500 distinct Walmart stores across an unspecified geographical area. It captures product data available at the time of extraction for the SerpApi demo project. Specific time ranges or demographic scopes are not detailed.
License
CC0: Public Domain
Who Can Use It
This dataset is suitable for:
- Data analysts looking to perform market research on consumer goods.
- Retail strategists interested in product performance and competitive landscapes.
- Developers who want to practice data extraction, cleaning, and analysis techniques.
- Students and researchers conducting studies on e-commerce trends or consumer behaviour.
- Coffee enthusiasts keen to delve into product specifics and market dynamics of coffee sales.
Dataset Name Suggestions
- Walmart Coffee Products Database
- Retail Coffee Listings from Walmart
- Walmart Coffee Market Insights
- Coffee Product Data (Walmart Stores)
- Walmart Coffee Selection Analysis
Attributes
Original Data Source: Walmart Coffee Selection Analysis
QUALITY