Walmart Stores Coffee Analysis
This Python demo project is a practical showcase of using SerpApi's Walmart Search Engine Results API plus how extracted data could be used in exploratory data analysis.
This repo covers:
- Extracting data from Walmart Organic results.
- Extracting data from all store pages using SerpApi pagination.
- Extracting data from 500 Walmart stores. SerpApi provides JSON Walmart Stores Locations with 4.460 stores in total.
- My full process of exploratory data 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
Kaggle Dataset: https://www.kaggle.com/datasets/dimitryzub/walmart-coffee-listings-from-500-stores
Key Takeaways
- The most popular coffee seller is Walmart.
- The most popular coffee type is medium roast.
- More weight (grams) doesn't equal 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 data set.
- ~300-500 grams is the most frequent weight.
- The highest coffee price is $77 (Lavazza perfetto single-serve k-cup)
Data Sources
Walmart. Data was extracted using Walmart Search Engine Results API from SerpApi.