Objectives

In this analysis, I’d like to check:

What type of wines are popular
What regions has increased or decreased drastically in terms of number of awards the region received.
What makes the price expense

What type of wines are more popular?

It seems Zinfandel, Chardonnay, and Pinto Noir are Popular (i.e. got many awards so far)

Are there any increasing or decreasing regions?

As for increase, Monticello shows 800% increase compared with 2014. On the other hand, Finger Lakes decreased about 43% and Old Mission Peninsula decreased about 24% compared with 2014.

Monticello is in Virginia, Old Mission Peninsula is in Michigan, and Finger Lakes is in NY.

Monticello

Silver Award is increased a lot.

Finger Lakes

Silver Award is decreasing.

What makes the price expensive

So it seems Cabernet Sauvignon makes the price expense and vintage year 2009 seems contribute to high price.

Summary

So the top 3 popular Wine Varieties are Zinfandel, Chardonnay, and Pinto Noir are Popular Wines. As for increase, Monticello shows 800% increase compared with 2014. On the other hand, Finger Lakes decreased about 43% and Old Mission Peninsula decreased about 24% compared with 2014. For the price, it seems if the Varietal is Cabernet Sauvignon and vintage year is 2009, price tends to become higher.