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