Q1 Women’s Shoe Releases

One of my data sets was a 200 line table containing all sneaker releases from Adidas and Nike in Q1 of 2018. I chose the first three months of the year because this is often when there are several ‘hyped’ releases for Chinese New Year, Nike’s Air Max Day, Black History Month, and the NBA All Star Break. Brands are also trying to start the year off strong to set the pace for the rest of the year.

The data I collected was taken from multiple sneaker release tracking sites, and then filtered to take out any duplicates due to color and any grade school releases. I ended up with a fairly small data set with about 200 rows.

Screen Shot 2018-05-26 at 8.37.37 PM.png

I decided to see how many releases from Q1 of 2018 were for women with my query. I could have very well done a count query, but I wanted to be able to be able to see which were Nike and which were Adidas.  When Nike and Adidas release a women’s shoe, they name it with “women” in the shoe description, so I did a ‘contains’ in my where clause to filter out any shoes that don’t contain the phrase. My results are below.

Screen Shot 2018-05-26 at 8.36.22 PM.png

As you can see in the returned results, there were only 22 women-specific releases in Q1 of 2018. Nike has slightly more women’s releases than Adidas, most likely because Nike has made it clear that they are working towards gaining women’s loyalty (especially with the creation of Jordans for women). Nike has never had this many women’s special releases in the past, and none of the Adidas shoes that were released for women were necessarily ‘special releases’ so its possible that Nike is trying to play catch up with female consumers.

For my final project, we’ll see if its paying off; I will be comparing the average resale prices of the releases from Q1 2018 to their original price to see which brand started the year with more hype.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s