If the Shoe Fits
Have you been out shoe shopping and wonder how often your favorite brand goes on sale? Ever been curious to know if heels or flats are more expensive? As a shoe lover, I wanted to explore shoe data to make more data-driven decisions before purchasing shoes. A sample dataset is available on Kaggle with a list of 10,000 women's shoes and their product information from 2014-2017 using Datafiniti's product database. (Note that this is a sample from a 93 million product data listings with 300 million price offers from 1000s of online retailers).
I used this shiny project as an opportunity to analyze the following:
- How are shoe Styles correlated to Brand, Price, and Merchants
- How are shoe Brands correlated to Merchants and Price?
- How are Merchants correlated to Price, brand, and style?
- The first 3 brands listed (Dearfoams, Bamboo, C Label) exclusively offer shoes in the cheap price range
- About half (or 9/20) of the top brands don’t offer sneakers
- The majority of brands that offer sneakers are exclusive to producing sneaker shoe types
- About half (or 8/20) of the top brands offer expensive shoe styles
- Flats are the only style that top brands don’t offer in the expensive price range
- Mid-priced shoes seem to be the most common among top brands
- The top 3 brands with price discounts: Easy Spirit, Tommy Hilfiger, New Balance
- Over half of the top brands have discounted their shoes from 30 – 50%
- If you’re looking for a cheaper but popular athletic shoe, Easy Spirit or NB would be a much better option than Nike.
- Boots (unsurprising) have the highest price
- Boots also appear to have the widest price distribution, with Sandals not close behind
- The majority of styles are offered at cheap and mid-price ranges. All styles are also available at luxury prices
- It comes as a surprise that sneakers are the most discounted style
- A bit less surprising is that boots are the least discounted, with them being the most expensive shoe style
- Heels vs Flats: You're probably more likely to find a pair of heels on sale than flats
- Perhaps the demand is higher for flats because they're generally more comfortable than heels so they don't go on sale as much
- Ralph Lauren clearly offered the widest price range of styles
- Sears.com is the only multi-brand retailer offering luxury priced shoes
- It's also interesting to note that Sears.com offers a wide selection of all styles except sneakers
- Most retailers offer all styles