Name: Walmart Coffee Listings From 500 Stores
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Walmart Coffee Listings From 500 Stores

This dataset was created while I was working on a SerpApi demo project to showcase Walmart Search Engine Results API.

This dataset includes only Coffee listings from 500 Walmart stores, and the main point of it was to explore the most popular seller, coffee type, and other questions that I was interested in.

In total, there're 1399 coffee listings.

Key Project Takeaways

The most popular coffee seller is Walmart.
The most popular coffee type is a medium roast.
More weight (grams) doesn't equal a higher price.
- A lower gram coffee may cost more than a higher gram coffee.
The highest coffee weight is 2835 grams (2.8 kg).
"Folgers classic roast ground coffee" has 15k+ reviews which is the maximum value from the data set.
~300-500 grams is the most frequent weight.
The highest coffee price is $77 (Lavazza perfetto single-serve k-cup)

You can find a GitHub repository with a data extraction/analysis scripts and plots: https://github.com/dimitryzub/walmart-stores-coffee-analysis

There's also a full blog post that also shows data extraction steps: https://serpapi.com/blog/serpapi-demo-project-walmart-coffee-exploratory-data-analysis/#extracting-walmart-data

Tables

Coffee Listings From All Walmart Stores

@kaggle.dimitryzub_walmart_coffee_listings_from_500_stores.coffee_listings_from_all_walmart_stores

127.49 kB
1,400 rows
9 columns

CREATE TABLE coffee_listings_from_all_walmart_stores (
  "title" VARCHAR,
  "coffee_type" VARCHAR,
  "rating" DOUBLE,
  "reviews" BIGINT,
  "seller_name" VARCHAR,
  "thumbnail" VARCHAR,
  "price" DOUBLE,
  "weight" VARCHAR,
  "weight_formatted_to_gramms" DOUBLE
);