Rating vs Price: Road to Understanding Whisky

Posted on May 18, 2020
The skills I demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.

In these tumultuous times, people have sought after countless remedies to alleviate any and all anxiety and stress. That could be reading, watching The Last Dance (Go Bulls!) or even taking a nice stroll outside. For me, and I assume many others, a nice glass of whisky seems to do the trick. However, whisky prices can often be ridiculously expensive, so I looked to discover some good bangs for your buck.


I scraped data from whiskyadvocate.com, a website with over 5000 reviewed bottles, each with a description including the brand or name, the price in dollars, the type of whisky, its rating, and a review from a certified WhiskyAdvocate reviewer. After scraping this data into one dataset, I ultimately added two columns, expected rating, which was a formula that took a bottle's price and returned what it's rating should be based on that price, and rating difference, which subtracts expected rating from the bottle's original rating; a positive rating difference means the whisky is a value play, while a negative rating difference means you probably should stay away from that bottle.


After some basic analyses, I found that the average price for a bottle of whisky was $360.91, and a median price of $79.00, with the cheapest bottle being Grand Grizzly at $7.00 and the most expensive being Diamond Jubilee by John Walker & Sons at a whopping $157,000.00. The average rating of whisky was 86.96 and the median rating was an 87, on a rating scale of 60-100. The highest rated bottles were Johnnie Walker Blue Label, Four Roses Limited Edition Small Batch (2013 Release), Bowmore 46 year old (distilled 1964), Parker's Heritage Collection 'Golden Anniversary', and Black Bowmore 42 year old 1964 vintage, each with a score of 97. The lowest rattled bottles were Woodford Reserve Master's Collection Five Malt and Cavalry, each with a score of 60.


There are 13 different certified reviewers, some with more reviews than others, but on average, they rate the bottles pretty similarly. However, it's important to note that if Dave Broom, Geoffrey Kleinman or Lew Bryson are reviewing your whiskies, they might not give you the best rating in terms of actual rating and expected rating.


In the dataset, there were 58 different types of whisky, so in order to find the most popular types, I filtered out all types of whisky with 89 or less total reviews, with 89 being the rounded average numbers of reviews per whisky type. From this, we find that Single Malt Scotch is the most popular by a large number based on total reviews, with Bourbon as a not-so-close second. While this group of most reviewed whisky types all seemed to be rated pretty similarly, on average, the number of reviews is a good indicator of what type is most sought after.

Price vs. Rating

I was curious to see if there was any correlation between price and rating, with the expectation being that the more expensive a bottle is, the higher its rating will be. That definitely was not the case. After doing a Pearson correlation between the two, it returned an r of .081, meaning there is little to no correlation between the two, which, in other words, suggests that you can find some great whiskies for cheap! This led me to make a few tools to help find some great value plays.

Top Rated Whiskies by Price

To start, I made tool that gives you a list of bottles sorted cheapest to most expensive, with a minimum rating of 90 or above, which I considered to be a good rating for whisky. The returned data table shows that you can get an amazing of bottle of whisky for as little as $20! Additionally, I made similar tools where you can filter the same kind of data by whisky type, if, for example, you're only looking for Scotch or Bourbon, and one where you can filter by reviewer, if your preferences align with a specific reviewer's preferences.

Top Valued Whiskies by Rating

Similarly, I created a tool where you select a minimum price baed on your desired spending limit, and it returns some great valued bottles sorted by rating difference; the higher the rating difference, the better the value, but really, any whisky with a positive rating difference is a good value play. From this, we find that there are countless excellent whiskies where you don't have to spend more than 3 digits. Like the Top Rated Whiskies by Price tool, I provide tools to filter by whisky type and reviewer.

Whisky Jargon

While it's clear and important to understand that you can get some incredible bottles of whisky at a very low price, I was also curious about how these certified reviewers talked about these bottles. Because of this I made a WordCloud of the most used words in reviewing whisky, accumulated from every review. Right away, the words that stand out most are note, sweet, finish, hint, spice, palate, nose and flavor. While I'm a huge whisky lover, I truly didn't know what some of these popular terms meant in relation to whisky, specifically, nose, finish and palate. In the long run, it could have been interesting to have two side-by-side WordClouds, one for highly-rated whiskies and one for poorly-rated whiskies, and see if there's a difference in descriptive words used.


Nose: To smell and ultimately judge the whisky, seeing if you can identify the different aromas

**There's a special whisky glass for nosing, called a nosing glass, which is engineered for nosing (wide at the bottom, narrow at the top)**

Finish: The longevity of the different flavors lingering in your mouth after tasting; a good whisky has a finish where the flavor changes over time

Palate: The steps of tasting of whisky; the first step is to judge the texture, with every subsequent step to determine the different flavors


Whisky is a dynamic beverage. There are several different types, good and bad, with an even larger number of flavors, at a wide range of prices. While whisky is often used to get you a little tipsy and feeling all warm and fuzzy inside, it's exciting and interesting to understand a bottle of whisky beyond its price, through nosing, palate, and its finish. However, the most important takeaway, clearly, is that cheap does not equal bad. No matter your relationship with whisky, you really never have to overspend for a good bottle. While you may be feeling generous and want to gift someone a good but expensive whisky, at the end of the day, you can always have some money left over in your pocket while enjoying a world class bottle of your choice.

About Author

Jack Goldman

A recent college graduate with a certification in Data Sciences, having a background in biopsychology, cognition and neuroscience as well as statistics, blended with experience in sports marketing and public relations.
View all posts by Jack Goldman >

Leave a Comment

No comments found.

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI