2020-05-11 - Calculating "value" of Whisky, age over cost
(original .ipynb)
Over lunchtime today I was curious about the relationship between a whisky's age and its price. Of course an older whisky will usually be more expensive than a younger one, but I wanted to see how true that was, if there were many outliers and what the "best" age/price ratio was. Note: I'm aware that "older" does not necessarily imply "better" - this is just a little exercise for fun. I first had to scrape the page for whiskies with an age statement, I did this by opening https://eshop.hyveco.cz/destilaty/whisky, expanding the page fully (by scrolling down and hitting "Zobrazit dalších N" a few times, running the following and deleting any that didn't have text like "12 YO" or "8YO":
const rawWhiskies = $(".seznamZbozi section")
let whiskies = [];
for (const whiskyElement of rawWhiskies) {
whiskies.push({ name: whiskyElement.children[1].innerText, price: whiskyElement.children[2].innerText });
}
JSON.stringify(whiskies)
This is below (it's quite long):
inputjson = """
[
{
"name":"Glen Scanlan 12YO 0,7l 40%",
"price":"472,00 Kč s DPH"
},
{
"name":"Glen Silvers 8YO Whisky 0,7l 40%",
"price":"576,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO 0,7l GB 40%",
"price":"580,00 Kč s DPH"
},
{
"name":"Glen Talloch Gold 12YO 0,7l 40% GB",
"price":"606,00 Kč s DPH"
},
{
"name":"Ballantines 12YO 0,7l 40% GB",
"price":"610,00 Kč s DPH"
},
{
"name":"Label 5 12YO 0,7l 40%",
"price":"625,00 Kč s DPH"
},
{
"name":"Speyburn 10YO 0,7l 40%",
"price":"639,00 Kč s DPH"
},
{
"name":"Glenfiddich 12YO 0,7l 40%",
"price":"640,00 Kč s DPH"
},
{
"name":"Antiquary 12YO 0,7l 40% GB",
"price":"642,00 Kč s DPH"
},
{
"name":"Glen Turner 12YO Legend 0,7l 40% GB",
"price":"692,00 Kč s DPH"
},
{
"name":"Glen Silvers 12YO 0,7l 40% GB",
"price":"702,00 Kč s DPH"
},
{
"name":"Glen Moray 12YO 0,7l 40% GB",
"price":"707,00 Kč s DPH"
},
{
"name":"Isle of Jura 10YO 0,7l 40%",
"price":"717,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO 0,7l 40% + POWERBANK GB",
"price":"720,00 Kč s DPH"
},
{
"name":"Tomatin 8YO 1,0l 40% GB",
"price":"729,00 Kč s DPH"
},
{
"name":"Glen Grant 10YO 1,0l 40%",
"price":"729,00 Kč s DPH"
},
{
"name":"J&B Jet 12YO 0,7l 40%",
"price":"732,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO 0,7l 40% GB +2skla",
"price":"742,00 Kč s DPH"
},
{
"name":"Dimple 15YO 0,7l 40% GB",
"price":"748,00 Kč s DPH"
},
{
"name":"Cardhu 12YO 0,7l 40%",
"price":"757,00 Kč s DPH"
},
{
"name":"Lauders 12YO 1,0l 40%",
"price":"768,00 Kč s DPH"
},
{
"name":"Grants Element. Oxegen 8YO 1,0l 40% GB",
"price":"773,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO 1,0l 40%",
"price":"778,00 Kč s DPH"
},
{
"name":"Bowmore 12YO 0,7l 40%",
"price":"782,00 Kč s DPH"
},
{
"name":"Old Pulteney 12YO 0,7l 40% GB",
"price":"792,00 Kč s DPH"
},
{
"name":"AnCnoc 12YO Single Malt 0,7 l 40% GB",
"price":"802,00 Kč s DPH"
},
{
"name":"Arran 10YO 0,7l 46% GB",
"price":"805,00 Kč s DPH"
},
{
"name":"Glenmorangie 10YO 0,7l 40% + sklenička ZDARMA",
"price":"817,00 Kč s DPH"
},
{
"name":"Glengoyne 10YO 0,7l 40% GT",
"price":"857,00 Kč s DPH"
},
{
"name":"Cardhu 12YO 0,7l 40% + 2 skla",
"price":"857,00 Kč s DPH"
},
{
"name":"Aberfeldy 12YO 0,7l 40% GB",
"price":"858,00 Kč s DPH"
},
{
"name":"BenRiach 10YO 0,7l 43% GB",
"price":"860,00 Kč s DPH"
},
{
"name":"Bowmore 10YO Dark & Intense 1,0l 40%",
"price":"869,00 Kč s DPH"
},
{
"name":"Tomatin 12YO 0,7l 43% GB",
"price":"870,00 Kč s DPH"
},
{
"name":"Laphroaig 10YO 0,7l 40%",
"price":"881,00 Kč s DPH"
},
{
"name":"BenRiach 10YO Curiositas NonChill 0,7l 46% GB",
"price":"902,00 Kč s DPH"
},
{
"name":"Glengoyne 12YO 0,7l 43% GT",
"price":"910,00 Kč s DPH"
},
{
"name":"Dewars 12YO 0,7l 40% + Still Watter GB",
"price":"922,00 Kč s DPH"
},
{
"name":"Glendronach 12YO 0,7l 43%",
"price":"922,00 Kč s DPH"
},
{
"name":"Highland Park 8YO 0,7l 43%",
"price":"932,00 Kč s DPH"
},
{
"name":"Glenfiddich 15YO 0,7l 40%",
"price":"935,00 Kč s DPH"
},
{
"name":"Glendronach 8YO 0,7l 46% Hielan GB",
"price":"947,00 Kč s DPH"
},
{
"name":"Glenfiddich 12YO 1,0l 40% GB",
"price":"950,00 Kč s DPH"
},
{
"name":"Aberlour 12YO Double Cask M.0,7l 40%",
"price":"950,00 Kč s DPH"
},
{
"name":"Inchmurrin 12YO 0,7l 46% GB",
"price":"972,00 Kč s DPH"
},
{
"name":"Glenfiddich 12YO 0,7l 40% + 2 skla",
"price":"972,00 Kč s DPH"
},
{
"name":"Knockando 15YO Richly Matured 0,7l 43%",
"price":"980,00 Kč s DPH"
},
{
"name":"Tomatin 12YO 1,0l 43% GB",
"price":"980,00 Kč s DPH"
},
{
"name":"Glen Moray 15YO 0,7l 40% GB",
"price":"990,00 Kč s DPH"
},
{
"name":"Glenmorangie 10YO 1,0l 40%",
"price":"990,00 Kč s DPH"
},
{
"name":"Ardbeg Wee Beastie 5YO 0,7l 47,4% + sklenička zdarma",
"price":"999,00 Kč s DPH"
},
{
"name":"Deanston 12YO Unchillfiltered 0,7l 46,3% GB",
"price":"1 002,00 Kč s DPH"
},
{
"name":"Glenlivet 12YO 0,7l 40%",
"price":"1 002,00 Kč s DPH"
},
{
"name":"Glenlivet 12YO First Fill 0,7l 40% GB",
"price":"1 006,00 Kč s DPH"
},
{
"name":"Caol Ila 12YO 0,7l 43%",
"price":"1 025,00 Kč s DPH"
},
{
"name":"Ardbeg 10YO 0,7l 46% GB",
"price":"1 025,00 Kč s DPH"
},
{
"name":"Aberlour 12YO Non Chill-Filtered 0,7l 48% GB",
"price":"1 030,00 Kč s DPH"
},
{
"name":"Dimple 15YO 1l 43% GB",
"price":"1 038,00 Kč s DPH"
},
{
"name":"Clynelish 14YO 0,7l 46% GB",
"price":"1 041,00 Kč s DPH"
},
{
"name":"Kolekce Caol Ila 12YO, Clyneslish 14YO, Talisker 10YO 0,2l 43%",
"price":"1 051,00 Kč s DPH"
},
{
"name":"Benromach 10YO 0,7l 43% + 2 skla GB",
"price":"1 062,00 Kč s DPH"
},
{
"name":"Glenmorangie 10YO 0,7l 40% + 2 skla GB",
"price":"1 062,00 Kč s DPH"
},
{
"name":"Ballantines 17YO 0,7l 40%",
"price":"1 070,00 Kč s DPH"
},
{
"name":"Glen Grant 12YO 0,7l 43% + 2 skla GB",
"price":"1 107,00 Kč s DPH"
},
{
"name":"Balvenie 12YO Double W. 0,7l 40%",
"price":"1 129,00 Kč s DPH"
},
{
"name":"Bunnahabhain 12YO 0,7l 46,3%",
"price":"1 152,00 Kč s DPH"
},
{
"name":"Dalmore 12YO 0,7l 40%",
"price":"1 172,00 Kč s DPH"
},
{
"name":"Chivas Regal 18YO 0,7l 40% GB",
"price":"1 190,00 Kč s DPH"
},
{
"name":"Glen Scotia 15YO 0,7l 46% GB",
"price":"1 202,00 Kč s DPH"
},
{
"name":"Aberfeldy 12YO 1l 40% GB",
"price":"1 210,00 Kč s DPH"
},
{
"name":"Ballechin 10YO 0,7l 46% GB",
"price":"1 215,00 Kč s DPH"
},
{
"name":"GlenAllachie 12YO 0,7l 46% GB",
"price":"1 237,00 Kč s DPH"
},
{
"name":"Glenfiddich 18YO 0,7l 40% GB",
"price":"1 282,00 Kč s DPH"
},
{
"name":"Tomintoul 16YO 1,0l 40% GT",
"price":"1 289,00 Kč s DPH"
},
{
"name":"Ballantines Miltonduff 15YO 0,7l 40% GT",
"price":"1 290,00 Kč s DPH"
},
{
"name":"Ballantines Glenburgie 15YO 0,7L 40%",
"price":"1 290,00 Kč s DPH"
},
{
"name":"Ardbeg 10YO Warehouse 0,7l 46% plech",
"price":"1 089,00 Kč s DPH"
},
{
"name":"Singleton of Dufftown 15YO 0,7l 40%",
"price":"1 301,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO Brothers 1l 40% GB",
"price":"1 308,00 Kč s DPH"
},
{
"name":"Bowmore 15YO Sherry Cask 0,7l 43% GB",
"price":"1 311,00 Kč s DPH"
},
{
"name":"Cardhu 15YO 0,7l 40%",
"price":"1 352,00 Kč s DPH"
},
{
"name":"Dalwhinnie 15YO 1l 43%",
"price":"1 369,00 Kč s DPH"
},
{
"name":"Edradour 12YO Caledonia 0,7l 46% GB",
"price":"1 382,00 Kč s DPH"
},
{
"name":"Knockando 18YO Slow Matured 0,7l 43% GT",
"price":"1 390,00 Kč s DPH"
},
{
"name":"Lagavulin 8YO 0,7l 48% GB",
"price":"1 407,00 Kč s DPH"
},
{
"name":"Craigellachie 13YO 0,7l 46%",
"price":"1 410,00 Kč s DPH"
},
{
"name":"Glen Deveron 16YO 1,0l 40% GB",
"price":"1 413,00 Kč s DPH"
},
{
"name":"Chivas Regal 12YO 1,75l 40%",
"price":"1 461,00 Kč s DPH"
},
{
"name":"Bowmore 15YO Golden & Elegant 1,0l 43%",
"price":"1 464,00 Kč s DPH"
},
{
"name":"Ardmore 12YO Portwood 0,7l 46% GB",
"price":"1 467,00 Kč s DPH"
},
{
"name":"Auchroisk 10YO 0,7l 43%",
"price":"1 472,00 Kč s DPH"
},
{
"name":"Glencadam 14YO Oloroso Serry 0,7l 46% GT",
"price":"1 492,00 Kč s DPH"
},
{
"name":"Inchmurrin 15YO 0,7l 46% plech",
"price":"1 497,00 Kč s DPH"
},
{
"name":"Inchmurrin Vintage 1996 19YO 0,7l 43% GB",
"price":"1 627,00 Kč s DPH"
},
{
"name":"Tomatin 18YO 0,7l 46% GB",
"price":"1 630,00 Kč s DPH"
},
{
"name":"Aberfeldy 16YO 0,7l GB",
"price":"1 669,00 Kč s DPH"
},
{
"name":"Glenlivet 18YO 0,7l 43%",
"price":"1 689,00 Kč s DPH"
},
{
"name":"Glen Garioch 15YO Sherry Cask 0,7l 53,7% GB",
"price":"1 699,00 Kč s DPH"
},
{
"name":"Glenfarclas 17YO 0,7l 43%",
"price":"1 712,00 Kč s DPH"
},
{
"name":"Glengoyne Gold 15YO 1,0l 40% GT",
"price":"1 768,00 Kč s DPH"
},
{
"name":"Balvenie 12YO Triple Cask 1,0l 40%",
"price":"1 790,00 Kč s DPH"
},
{
"name":"Macallan 12YO Double Cask 0,7l 40% GB",
"price":"1 790,00 Kč s DPH"
},
{
"name":"Macallan 12YO Fine Oak 0,7l 40%",
"price":"1 832,00 Kč s DPH"
},
{
"name":"Cardhu 18YO 0,7l 40%",
"price":"1 852,00 Kč s DPH"
},
{
"name":"Aberlour 18YO 0,5l 43%",
"price":"1 870,00 Kč s DPH"
},
{
"name":"Famous Grouse 16YO 1l 40%",
"price":"1 878,00 Kč s DPH"
},
{
"name":"Dalmore 15YO 0,7l 40%",
"price":"1 890,00 Kč s DPH"
},
{
"name":"Isle of Jura 18YO 0,7l 42% GB",
"price":"1 920,00 Kč s DPH"
},
{
"name":"Balvenie 14YO Caribbean Cask 0,7l 43%",
"price":"1 930,00 Kč s DPH"
},
{
"name":"Benromach 15YO 0,7l 43% GB",
"price":"1 954,00 Kč s DPH"
},
{
"name":"Auchentoshan 18YO Lowl 0,7l 43%",
"price":"1 962,00 Kč s DPH"
},
{
"name":"Bowmore White Sands 17YO 0,7l 43% GB",
"price":"1 992,00 Kč s DPH"
},
{
"name":"Ballantines 21YO 0,7l 40%",
"price":"1 999,00 Kč s DPH"
},
{
"name":"Auchentoshan 14YO Blood Oak 0,7l 46% GB",
"price":"2 001,00 Kč s DPH"
},
{
"name":"Glenfarclas 21YO 0,7l 43% GT",
"price":"2 112,00 Kč s DPH"
},
{
"name":"Chivas Regal 18YO Pininfar 0,7l 40%",
"price":"2 112,00 Kč s DPH"
},
{
"name":"Macallan 10Y Fine Oak 0,7l 40%",
"price":"2 201,00 Kč s DPH"
},
{
"name":"Glengoyne 18YO 0,7l 43% GB",
"price":"2 245,00 Kč s DPH"
},
{
"name":"Bowmore 18YO 0,7l 43%",
"price":"2 260,00 Kč s DPH"
},
{
"name":"Glendronach 18YO 0,7l 46% Allardice",
"price":"2 362,00 Kč s DPH"
},
{
"name":"Arran 18YO 0,7l 46% GB",
"price":"2 402,00 Kč s DPH"
},
{
"name":"Glenmorangie 18YO 0,7l 43% GB",
"price":"2 402,00 Kč s DPH"
},
{
"name":"Balvenie 16YO Triple Cask 0,7l 40%",
"price":"2 462,00 Kč s DPH"
},
{
"name":"Talisker 18YO 0,7l 45,8%",
"price":"2 527,00 Kč s DPH"
},
{
"name":"Craigellachie 17YO 0,7l 46% GT",
"price":"2 601,00 Kč s DPH"
},
{
"name":"Chivas Royal Salute 21YO 0,7l 40%",
"price":"2 620,00 Kč s DPH"
},
{
"name":"AnCnoc 18YO 0,7l 46% GB",
"price":"2 692,00 Kč s DPH"
},
{
"name":"Highland Park 15YO 0,7l 40% GB",
"price":"2 782,00 Kč s DPH"
},
{
"name":"Lagavulin 9YO Game of Thrones 0,7l 46% GB",
"price":"3 302,00 Kč s DPH"
},
{
"name":"Caol Ila 15YO Unpeated 0,7l 61,5% GB",
"price":"3 319,00 Kč s DPH"
},
{
"name":"Glenfiddich 19YO Age 2nd Bourbon 0,7l 40% GB",
"price":"3 332,00 Kč s DPH"
},
{
"name":"Glenfiddich 19YO Age 3rd Red 0,7l 40% GB",
"price":"3 342,00 Kč s DPH"
},
{
"name":"Mortlach Game of Thrones Six Kingdoms 15yo 0,7l 46%",
"price":"3 500,00 Kč s DPH"
},
{
"name":"Balvenie Double Wood 17YO 0,7l 43% GB",
"price":"3 622,00 Kč s DPH"
},
{
"name":"Macallan 15YO Fine Oak 0,7l 43%",
"price":"3 752,00 Kč s DPH"
},
{
"name":"Glenmorangie 19YO 0,7l 43% GB",
"price":"3 862,00 Kč s DPH"
},
{
"name":"Chivas Regal 18YO 1,75l 40%",
"price":"3 981,00 Kč s DPH"
},
{
"name":"BenRiach 22YO Albariza 0,7l 46% GB",
"price":"4 312,00 Kč s DPH"
},
{
"name":"Bushmills 21YO 0,7l 40% GB",
"price":"4 462,00 Kč s DPH"
},
{
"name":"Grants 25YO 0,7l 40%",
"price":"4 590,00 Kč s DPH"
},
{
"name":"Glenfiddich 21YO 0,7l 43,2% GB",
"price":"4 858,00 Kč s DPH"
},
{
"name":"Talisker 25YO 0,7l 45,8%",
"price":"5 912,00 Kč s DPH"
},
{
"name":"Chivas Regal 25YO 0,7l 40% GB",
"price":"6 242,00 Kč s DPH"
},
{
"name":"Highland Park 21YO 0,7l 47,5%",
"price":"6 832,00 Kč s DPH"
},
{
"name":"Glen Moray 25YO 0,7l 43% WGB",
"price":"7 162,00 Kč s DPH"
},
{
"name":"Bowmore 25YO 0,7l 43%",
"price":"8 900,00 Kč s DPH"
},
{
"name":"Glenlivet 25YO 0,7l 43% dřevo GB",
"price":"8 912,00 Kč s DPH"
},
{
"name":"Glenfiddich 25YO 0,7l 43% GB",
"price":"9 812,00 Kč s DPH"
},
{
"name":"Glenfiddich 26YO 0,7l 43% GB",
"price":"9 990,00 Kč s DPH"
},
{
"name":"Balvenie 25YO Single Barrel 0,7l 47,8%",
"price":"11 912,00 Kč s DPH"
},
{
"name":"Laphroaig 32YO 2011 0,7l 46,6% GB",
"price":"53 012,00 Kč s DPH"
}
]
"""
import json
import re
def get_age(whisky_name_str):
m = re.search("(\d+)\s?YO?", whisky_name_str, flags=re.IGNORECASE)
if not m:
raise Exception(f"can't get age from: {whisky_name_str}")
return int(m.groups()[0])
def get_volume(whisky_name_str):
m = re.search("(\d+)(,?)(\d*\s*)?L", whisky_name_str, flags=re.IGNORECASE)
if not m:
raise Exception(f"can't get volume from: {whisky_name_str}")
return float("".join(m.groups()).upper().replace("L", "").replace(",", "."))
def get_price(price_str):
# float for money = bad
# should probably just remove in the source json I created
# s/,/./ should probably be handled from the str->number parser using a locale
return float(price_str.replace("Kč s DPH", "").strip().replace(" ", "").replace(",", "."))
class Whisky:
def __init__(self, name_str, price_str):
self.name = name_str
self.age = get_age(name_str)
self.price = get_price(price_str)
self.volume = get_volume(name_str)
def crowns_per_year_per_litre(self):
return self.price / self.age / self.volume
def __str__(self):
return f"{self.crowns_per_year_per_litre():.2f}\t{self.name}, ({self.age} years): {self.price} CZK"
whiskies = []
for raw_whisky in json.loads(inputjson):
whiskies.append(Whisky(raw_whisky["name"], raw_whisky["price"]))
Let's take a quick look at the price per year per litre (?) to get an idea of the "value" :-)
There's quite a few so just the top 15 will do.
sorted_whiskies = sorted(whiskies, key=lambda w: w.crowns_per_year_per_litre())
for whisky in sorted_whiskies[:15]:
print(whisky)
56.19 Glen Scanlan 12YO 0,7l 40%, (12 years): 472.0 CZK 64.00 Lauders 12YO 1,0l 40%, (12 years): 768.0 CZK 64.83 Chivas Regal 12YO 1,0l 40%, (12 years): 778.0 CZK 69.05 Chivas Regal 12YO 0,7l GB 40%, (12 years): 580.0 CZK 69.20 Dimple 15YO 1l 43% GB, (15 years): 1038.0 CZK 69.57 Chivas Regal 12YO 1,75l 40%, (12 years): 1461.0 CZK 71.24 Dimple 15YO 0,7l 40% GB, (15 years): 748.0 CZK 72.14 Glen Talloch Gold 12YO 0,7l 40% GB, (12 years): 606.0 CZK 72.62 Ballantines 12YO 0,7l 40% GB, (12 years): 610.0 CZK 72.90 Glen Grant 10YO 1,0l 40%, (10 years): 729.0 CZK 74.40 Label 5 12YO 0,7l 40%, (12 years): 625.0 CZK 76.19 Glenfiddich 12YO 0,7l 40%, (12 years): 640.0 CZK 76.43 Antiquary 12YO 0,7l 40% GB, (12 years): 642.0 CZK 79.17 Glenfiddich 12YO 1,0l 40% GB, (12 years): 950.0 CZK 80.56 Tomintoul 16YO 1,0l 40% GT, (16 years): 1289.0 CZK
I'm quite surprised to see such an expensive whisky come out on top in my made-up "value" mark, but I sort of expected most of the remainder (either not super-famous single malts, or big-name blends). A couple of the last five surprised me - Glenfiddich 12 and Tomintoul 16. In fact a short while ago I picked up Glenfiddich 15 from hyveco at a special price of about 729 Kč, which would give it a score of 729 / 15 / 0.7 = 69.43 leaving it just outside the top five.
Let's round this out with a naive scatter plot with an extremely chaotic legend:
import matplotlib.pyplot as plt
import numpy as np
fig = plt.figure(figsize=(10,20))
ax = fig.add_subplot(211)
ax.set_title('Whisky price vs Age (hyveco.cz)')
ax.set_ylabel('Price (CZK)')
ax.set_xlabel('Age (Years)')
for whisky in sorted_whiskies:
ax.plot(whisky.age, whisky.price, "o", label=whisky.name)
plt.legend(loc='upper center', bbox_to_anchor=(0.5, -0.05), fancybox=True, shadow=True, ncol=2)
# plt.show()
plt.savefig("hyveco-whisky.png")
