exercise.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Practice your skills loading data from a CSV file\n",
    "In this exercise, you will load a CSV file and you'll perform some operations on it to extract data. If you know how to do this with the Pandas library, you can use that. If not, you can use the csv library with the ready-to-use example this notebook provides."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from csv import DictReader\n",
    "\n",
    "# Open the CSV file and read it into a list of dictionaries and ignore unicode errors\n",
    "\n",
    "with open('sample_data/wine-ratings-small.csv', encoding='utf-8', errors='ignore') as f:\n",
    "    reader = DictReader(f)\n",
    "    wines = list(reader)\n",
    "\n",
    "\n",
    "# The wines variable is now a list of dictionaries, one for each row in the CSV file. This is the sample output of a single entry:\n",
    "# {'': '1',\n",
    "#  'name': 'Laurenz V Charming Gruner Veltliner 2014',\n",
    "#  'grape': '',\n",
    "#  'region': 'Kamptal, Austria',\n",
    "#  'variety': 'White Wine',\n",
    "#  'rating': '90.0',\n",
    "#  'notes': ''}\n",
    "\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Looping over the list of dictionaries can be tricky with plain Python. Specialized libraries like Pandas make this much easier but the downside is that you need to learn a new library. The following code is a bit more verbose but it's a good exercise to learn how to work with dictionaries in Python.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'': '24',\n",
       "  'name': 'Lava Vine Winery Napa Valley Cabernet Sauvignon 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'A wonderful representation of how amazing the 2014 vintage could be and how to balance Napa Valley’s Intensity. A ripe cherry and cassis entry with dusted cocoa and a touch of graham cracker entice. The silky rich entry is so balanced there seems to be no separation from mid-palate through the lengthy finish with multitudes of fruit and spice to accompany. This Cabernet Sauvignon is fully integrated, super complex and will age beautifully.'},\n",
       " {'': '25',\n",
       "  'name': 'Lava Vine Winery Napa Valley Reserve Cabernet Sauvignon 2012',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Black berries and hints of strawberry invite with muddled cherry cola spices. Deep earthy tones on a silk entry proceed to a rich, full mid-palate. Expressive tannins make for a beautiful finish.'},\n",
       " {'': '26',\n",
       "  'name': 'Lava Vine Winery Napa Valley Reserve Cabernet Sauvignon 2013',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'A slight minty nose with dark chocolate and fresh blueberry captivate the senses. Notes of a baking spice dance on the pallet before giving way to rich, dark, and earthy finish. This extremely balanced gem will continue to show plenty of structure and integrity for years to come. Enjoy!'},\n",
       " {'': '288',\n",
       "  'name': 'Leaping Lizard Cabernet Sauvignon 2007',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '90.0',\n",
       "  'notes': 'Our Cabernet Sauvignon is a full-bodied, fruit-forward wine that shows great structure with balanced acidity. Cassis, plum and crushed berry aromas are layered with a slight perfume/floral note and a hint of spicy oak. Red fruit flavors are found on the mid-palate through to the lingering finish. This wine is aged for\\xa018 months \\xa0in a mix of old and new oak barrels giving the wine a velvety finish with fine-grain tannins and a soft mouthfeel.'},\n",
       " {'': '685',\n",
       "  'name': 'Levendi Stagecoach Cabernet Sauvignon 2008',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'From the Stagecoach Vineyard high on the eastern volcanic ridge above Napa, comes this rich and decadent, limited production Cabernet Sauvignon. The vivid red soils and rocky slopes come together to produce a wine with an aroma of sweet blackberry and cassis fruit that carries over into a superbly balanced and polished palate. '},\n",
       " {'': '686',\n",
       "  'name': 'Levendi Sweeney Ranch Chardonnay 2010',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Beautifully ripe apple with a hint of caramel and oak spice, filled in with lemon chiffon notes. Caramelized apple and lemon vanilla cream flavors on the palate, with the texture gracefully balanced between a rich center and a crisp finish.'},\n",
       " {'': '692',\n",
       "  'name': 'Levy & McClellan Proprietary Red 2004',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Full-bodied yet beautifully silky and seductive, it has shed most of its tannins, resulting in a complex, singular red wine of majestic proportions.'},\n",
       " {'': '693',\n",
       "  'name': 'Levy & McClellan Proprietary Red 2005',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Uncompromising viticultural practices andmeticulously detailed vinification rewarded us with a wine ofgreat concentration and ripeness. The round supple tanninsin the 2005 Levy & McClellan are the result of thecool growing conditions and the extended ripening. As the wine develops, the expression of the site where it is grown continues to come to the forefront. Accentuated by the low yield in a year known for more generosity, combined with26 months in barrel, the result is a profoundly concentrated, supple and full-bodied wine.'},\n",
       " {'': '694',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2000',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '90.0',\n",
       "  'notes': 'Medium-red color. Dark, Bordeaux-like aromas of currant and cedar, medium-full body, bright red currant and ripe cherry-like fruit on the palate, notes of cocoa and roasted coffee, very lively on the palate, a touch of oak (but not sweet) and cedar. Nice balance and shows exceptional length. This is not a fruit bomb--it has the real depth and class that many wines at twice the price wish they had. Should pair well with any veal or beef dish, lamb, pork loin or chops, and chicken dishes made with  mushrooms. Pretty good with medium-strong cheeses, too.  '},\n",
       " {'': '695',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2005',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'A bright bouquet of wild black raspberry, dark plum, and Rainier cherry joined by vanilla, sweet tobacco and new saddle leather. A lively blend of blackberry, jammy raspberry and black currant fruit mingled with black pepper and baking spice, reinforced by assertive yet balanced sweet tannins and refreshing acidity.'},\n",
       " {'': '696',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2001',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Intense black cherry, plum, and berry aromas intermingled with notes of anise, pain grille, and cedar. Rich cherry, red plum and raspberry flavors; white pepper, tobacco, and allspice; full-bodied with sweet, chewy tannins, balanced ripeness and fresh acidity.'},\n",
       " {'': '697',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2006',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'An enticing mix of sweet black cherry, chocolate, and tobacco aromas. A blend of bramble berry and black cherry fruit mixed with exotic spice, earth, and tobacco flavors, backed by substantial, velvety tannins, marvelous texture and a lengthy finish. '},\n",
       " {'': '698',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2007',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Intense black cherry, plum, and berry aromas intermingled with notes of anise, pain grille, and cedar. Rich cherry, red plum and raspberry flavors; white pepper, tobacco, and allspice; full-bodied with sweet, chewy tannins, balanced ripeness and fresh acidity.'},\n",
       " {'': '699',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2009',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Red cherry, plum and brambleberry aromas with hints of cedar and chocolate. Vibrant blackberry, plum and tart cherry fruit intermingled with allspice, white pepper and vanilla on the palate with polished tannins and a long finish.'},\n",
       " {'': '700',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2010',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'An enticing mix of sweet black cherry, currant, dark cocoa, and toasty oak aromas. A blend of blackberry and black cherry fruit mixed with cassis, mineral, espresso and tobacco flavors; round, chewy tannins, marvellous texture and a lengthy finish.'},\n",
       " {'': '701',\n",
       "  'name': 'Lewelling Cabernet Sauvignon 2012',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Aromas of Bing cherry, currant and blackberry fruit, cocoa, vanilla, and baking spices. Intense blackberry, cassis, plum, and cherry flavors;coffee, anise and mineral; full-bodied, with fresh acidity,sweet, silky tannins and a rich mouth-feel.'},\n",
       " {'': '702',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2003',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'The bouquet is blackberry, black currant, roasted coffee, vanilla and exotic spice aromas.  The flavor is rich black cherry and currant, licorice, mineral and expresso flavors; superb body and complexity coupled with balanced ripeness and fresh acidity; polished but firm tannins, layered richness and a long finish.'},\n",
       " {'': '703',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2005',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'Bouquet: opulent aromas of black currant, blackberry, cherry, vanilla, and sweet toasty oak with a hint of anise.'},\n",
       " {'': '704',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2006',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'Sumptuous aromas of rich dark berries, vanilla, and sweet smoke Flavors are sweet black cherry and blackberry flavors mingled with tobacco, mineral and wood smoke; bold, substantial tannins, mouthfilling richness, layered complexity, and a strong finish. '},\n",
       " {'': '705',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2009',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Bouquet of enticing raspberry, cassis, and red plum aromas mixed with notes of chocolate and toasty oak. Flavors are rich blueberry, Bing cherry, and red raspberry flavors are also mingled with woodsmoke, earth, and spice; mouthfilling, velvety tannins and a complex, lingering finish.'},\n",
       " {'': '706',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2008',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '98.0',\n",
       "  'notes': 'Sumptuous aromas of blackberry, cassis, Bing cherry and spice mixed with highlights of tobacco, cedar, vanilla and anise. Concentrated black plum, black cherry, and cassis flavors; allspice, dark cocoa, juniper and sweet smoke; exceptional depth and complexity; multi-layered richness; mouthfilling, velvety tannins and a lingering finish.'},\n",
       " {'': '707',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2007',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '98.0',\n",
       "  'notes': 'An enticing mix of black fruit, tobacco and toasty oak aromas mingled with highlights of vanilla, cedar and licorice.  Concentrated black cherry, cassis, blueberry pie and espresso flavors; sweet smoke, anise and cedar; mouth-filling complexity and layered richness; dense but polished tannins and a very long finish.'},\n",
       " {'': '708',\n",
       "  'name': 'Lewelling Wight Vineyard Cabernet Sauvignon 2010',\n",
       "  'grape': '',\n",
       "  'region': 'St. Helena, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'Sumptuous aromas of rich dark berries, cassis, vanilla, and sweet smoke. Bing cherry, blackcurrant and blackberry flavors mingled with spice box, mineral and dark cocoa; velvety tannins, mouthfilling richness, layered complexity, and a lingering finish.'},\n",
       " {'': '709',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2002\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '96.0',\n",
       "  'notes': 'Number 12 on'},\n",
       " {'': '710',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2003\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': \"The formula for the 2002 Alec's Blend was so successful the winery again combined 60% Syrah, 30% Merlot, and 10% Cabernet Sauvignon to create this delicious wine, named after Dennis' first son. The wine is loaded with seductive oak spice, candle wax, and ripe black fruit. Hedonistic, rich, and complex, the wine has great mouth-feel with balance, depth, and a long, lingering finish.\"},\n",
       " {'': '711',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2007\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': \"These days drifting the rear wheel of his 4-stroke bike on a dirt oval is Alec's idea of fun, while his 2007 vintage wine is a straight-line sprint to pleasure. 70% Syrah, 20% Cabernet Sauvignon and 10% Merlot, this is one sweet ride, loaded with wild blackberries and laced with mocha, cola, and vanilla oak spice. Super-smooth, plush and round, there's plenty of throttle too, with chocolaty tannins and just enough grip to keep the fun serious. 1,400 cases produced.\"},\n",
       " {'': '712',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2009\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': \"With Alec already starting high school it's feeling like life in the fast lane. Top Gear is actually his favorite TV show and this new blend of 80% Syrah, 17% Merlot and 3% Cabernet Sauvignon packs plenty of power and youthful pleasure. Sappy black cherry and blueberry fruits are injected with clove and vanilla oak spice plus traces of truffle and sandalwood. Lively off the line, the palate performs with all the complex componentry and smooth power of a 4-valve, liquid-cooled 4-stroke engine.\"},\n",
       " {'': '713',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2005\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Everyone agrees that Alec is one sweet kid, and his blend from the 2005 vintage is the wine equivalent of \"wild mountain blackberry\" –a favorite flavor ice cream from childhood. 70% Syrah and 30% Cabernet Sauvignon, the wine is opulent, ripe and seductive with cedar-laced oak spice aromas, coffee shadings and scoopfuls of juicy black fruit. The plush palate packs a chocolate truffle surprise with great length and soft, chewy tannins.'},\n",
       " {'': '714',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2010\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': \"All-mountain is Alec's favorite kind of cycling and it best describes this deliciously complex blend.  Heading up trail, the air is heavy with wild blueberry, violets, and oak forest aromas.  Dropping into descent, deep chutes of blue-black fruit consume a full 160mm of fork travel.  Picking up speed the palate turns lively and technical with youthful acidity and some tight twists through the trees.  Mocha and espresso bean flavors kick in just as you glide through the dust to a fine chocolaty finish. \"},\n",
       " {'': '715',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2014\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': \"With one year of college completed, Alec's wine is both boy and man in this boundary-pushing blend of Syrah 60%, Merlot 34% and Cabernet 6%. Asserting his independence through explosively ripe blackberry and huckleberry fruits, there's also kirsch-like cherry cola, spicy oak, supple tannin and a trace of s'mores that's closer to home. Tremendously youthful and seriously good fun, Alec's Blend remains a kid at heart.\"},\n",
       " {'': '716',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2013\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'A blend of 60% Syrah, 22% Merlot and 18% Cabernet Sauvignon - a power trio of guitar, bass and drums that rocks harder than any vintage in recent memory. Super ripe blackberry, vanilla blueberry, mocha and oak spices gain presence and steadily push the volume past 10. Tons of ripe, hedonistic fruit brings big stage presence while handsomely hewn tannins add drive and keep this wall of sound distortion free.'},\n",
       " {'': '717',\n",
       "  'name': \"Lewis Cellars Alec's Blend Red 2017\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Complex and fruit-forward with opulent black cherry and a dash of sweet molasses. Sporting plush palate texture throughout, the wine finishes with delicious chocolatey tannins. '},\n",
       " {'': '724',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2002',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '96.0',\n",
       "  'notes': 'Showcasing the unique personalities of small hillside vineyards from Pritchard Hill, Oakville and Rutherford, the 2002 Napa Valley Cabernet delivers compelling aromas of mocha, ripe berries, tobacco and sweet oak spice. The wine is 100% Cabernet Sauvignon, complex, rich and focused. With a deep core of black fruit and traces of briar and vanilla, it turns chocolaty and long on the palate with serious, integrated tannins.'},\n",
       " {'': '725',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2004',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Showcasing the unique personalities of small hillside vineyards from Pritchard Hill, Rutherford, and Calistoga our 2004 Napa Valley Cabernet delivers compelling aromas of black currant, mocha and sweet oak spice. 100% Cabernet Sauvignon, the wine is complex, rich and focused. Built around a core of concentrated fruit, it serves up sumptuous, round, mouth-feel with traces of tobacco and briar. Beautifully structured, the wine develops distinctive chocolate flavors that travel long on the finish with finely integrated tannins.'},\n",
       " {'': '726',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2005',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'Showcasing the unique personalities of small hillside vineyards from Pritchard Hill, Rutherford, and Calistoga our 2005 Napa Valley Cabernet delivers complex aromas of black currant, sweet oak spice, espresso and tobacco. 100% Cabernet Sauvignon, the wine makes a sweeping broad entry with briary, black fruit at the core and compelling chocolate flavors that yield to a long chewy finish.'},\n",
       " {'': '727',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2012',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': \"The 2012 ranks among Lewis Cellars' best bottlings of Napa Cabernet. Enticing, deep-fruited aromas of black currant, berry and chocolate are stippled with cedar, clove and cinnamon oak spices. The palate centers on opulent core fruit that swirls around a defined structure of supple tannins. With complex undertones of truffle, black pepper and briar, this interplay finally winds down to a long chocolaty finish.\"},\n",
       " {'': '728',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2015',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Like an Aston Martin V-12 the 2015 Napa Valley Cabernet is a silky powerhouse of fruit at wide-open-throttle. Black currant, plum and juicy ripe berries rev freely on the palate with seductive oak spice, candle wax and semi-sweet chocolate aromas. Fine-tuned and polished, the wine is deceptively powerful with supple, sweeping tannins.'},\n",
       " {'': '729',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': \"Our 2014 Napa Valley Cab takes center stage in a flashy jumpsuit with super plush fruit and sexy oak spices - Elvis is in the house! There's a whole lotta fruit going on, playing out in perfect pitch and velvety voice - it's irresistibly good. Classic, three-chord composition provides structure with notes of cedar, clove and sweet tobacco for added melody. Finely polished with chocolaty tannins, something like blue suede shoes.\"},\n",
       " {'': '730',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2013',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': '#1'},\n",
       " {'': '731',\n",
       "  'name': 'Lewis Cellars Cabernet Sauvignon 2017',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Dense, layered aromas with sweet cocoa, alluring oak spice and wow-factor frontal fruit, the wine is showy yet seriously structured. Creamy melted berry character gives way to supple muscle with integrated tannins and a long, lavish finish.'},\n",
       " {'': '732',\n",
       "  'name': 'Lewis Cellars Cuvee L 2005',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Think of Cuvee L as super-charged Lewis Reserve Cabernet. Red wine at red-line. First created from the spectacular 1997 vintage, the single best barrels from our finest lots fuel this rare wine. Cuvee L is not produced every year. It is only blended when we have the components to create a wine of greater intensity, depth and distinction than our Reserve Cabernet. '},\n",
       " {'': '733',\n",
       "  'name': 'Lewis Cellars Cuvee L 2006',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'First created from the spectacular 1997 vintage, the single best barrels from our finest lots fuel this rare wine. Think of Cuvee L as super-charged Lewis Reserve Cabernet. Cuvee L is not produced every year. It is only blended when we have the components to create a wine of greater intensity, depth and distinction than our Reserve Cabernet. '},\n",
       " {'': '734',\n",
       "  'name': 'Lewis Cellars Cuvee L Cabernet Sauvignon 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Our 2014 Cuvee L carries a cargo of fruit more laden than a Spanish galleon. Awash with crushed berries, clove and black truffle the wine superbly melds redolent ripe fruit with sweet oak spices. Broad and round on entry, this 100% Cabernet Sauvignon swells at mid-palate and packs a plush yet potent finish like a chocolate-coated cannonball.'},\n",
       " {'': '735',\n",
       "  'name': 'Lewis Cellars Cuvee L Cabernet Sauvignon 2015',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '96.0',\n",
       "  'notes': 'Straight from James Fenimore Cooper’s novel, Last of the Mohicans, comes our 2015 Cuvee L – a noble savage from an outstanding vintage with great depth of character. 100% Cabernet Sauvignon with the strength of a grizzly and the soul of a chief this onyx and indigo wine is cloaked in tiers of blackberry with a quiver of clove and cedary oak spices. Broad paths of richly rendered fruit trail into hand-hewn tannins reflecting nature’s winding ways.'},\n",
       " {'': '736',\n",
       "  'name': 'Lewis Cellars Hillstone Vineyard Cabernet Sauvignon 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Rutherford, Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'This gorgeous wine, equal parts show-house and rustic cabin, sits along an alpine lake deep with black currants and massive ripe fruit. The air is redolent, with blackberry, clove, candle wax and vanilla oak spices. Picking up weight and muscle below the surface, the wine is anchored in fine tannins.'},\n",
       " {'': '737',\n",
       "  'name': 'Lewis Cellars Hudson Vineyards Syrah 2006',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'The relatively cool 2006 harvest enhanced the inherent Rhone character of our Hudson Vineyards Syrah from these famously farmed vines in Napa Carneros. Finely woven and complex this 100% Syrah from a single small block serves up a potpourri of red/black fruits, white pepper, herbes de Provence, and allspice. Black raspberry fruit flavors are framed in toasty oak and brought to fine focus. '},\n",
       " {'': '738',\n",
       "  'name': \"Lewis Cellars Mason's Cabernet Sauvignon 2003\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': \"In keeping with family tradition, this bottling celebrates the birth of Dennis' third son, Mason, in January 2003. Mason's wine is 100% Cabernet Sauvignon sourced from a single vineyard on a sunny ridge high on Mt. Veeder, farmed by Napa Valley legend, David Abreu. The wine is plush and spicy with ripe, forward fruit and soft, round tannins, brimming with wild berries, toasty oak and shadings of briar and tobacco.\"},\n",
       " {'': '739',\n",
       "  'name': \"Lewis Cellars Mason's Cabernet Sauvignon 2015\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': \"Mason has been going to CrossFit and it shows. No whiskers yet but his 2015 vintage has more serious character, complexity and muscle than ever. Redolent with deeply ripened berries, baker's chocolate, cola, and cedary oak spice the wine is concentrated and rich on entry. Picking up notes of café latte toward the finish, a network of sinewy yet supple tannins provides a platform for this bulked up wine. \"},\n",
       " {'': '740',\n",
       "  'name': \"Lewis Cellars Mason's Cabernet Sauvignon 2018\",\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Sporting some Senior-year swagger, the 2018 Mason’s Cabernet is front-loaded with black plum, cherry, chocolate and cedary spice.  Sourced from several of the same vineyards as our Napa Cabernet this wine is boldly fruited yet youthful with tons of juicy character and a deliciously fresh finish.'},\n",
       " {'': '741',\n",
       "  'name': 'Lewis Cellars Merlot 2000',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'Bursting with black plum and sweet cedar our Merlot is opulent and delicious, rivaling any of our Merlot bottlings to date. These low-yielding vines from Oakville, Oak Knoll and Pritchard Hill have produced a wine that is smooth, yet thickly textured, jammy yet serious.'},\n",
       " {'': '742',\n",
       "  'name': 'Lewis Cellars Napa Valley Chardonnay 2008',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'Crafted from a combination of Oak Knoll vines and longer-hanging Carneros clusters, our 2008 Napa Valley Chardonnay is satisfyingly ripe, yet focused and fresh in the same sip. Showy stone fruit, pear, hazelnut and toasty oak spices spill from the glass. Rich-bodied, fruitful and round on the palate with vanilla and subtle minerality, the wine is threaded with lively acidity bringing length and focus to a fine finish.'},\n",
       " {'': '743',\n",
       "  'name': 'Lewis Cellars Napa Valley Chardonnay 2015',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Grapes for the 2015 Napa Chardonnay came in early and the wine centers around ripe Bosc pear and Fuji apple with delicious caramel custard, pie crust and hazelnut. Thickly textured and satiny smooth like Deux-Sevres butter, the richness and weight are buttressed with native acidity and subtle minerality bringing complexity and length to this delicious wine.'},\n",
       " {'': '744',\n",
       "  'name': 'Lewis Cellars Napa Valley Chardonnay 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Another warm vintage and generous crop brought plenty of sun-kissed fruit for our 2014 Napa Valley Chardonnay. Ripened red and green pears with white peach are threaded with tantalizing cinnamon, nutmeg and caramel spices. The cream-textured palate is opulent, full-bodied and delicious with notes of vanilla, mineral and flaky croissant that carry into a long and increasingly focused finish. '},\n",
       " {'': '745',\n",
       "  'name': 'Lewis Cellars Napa Valley Chardonnay 2016',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Golden delicious apple, honeysuckle blossom and toasty caramel spice aromas are served up generously in the 2016 Napa Chardonnay. Silky in texture with ripe tree fruit and plenty of drive the wine is athletic and complex with a tail of smoky mineral and lees character.'},\n",
       " {'': '746',\n",
       "  'name': 'Lewis Cellars Napa Valley Syrah 2006',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Crafted from hillside blocks in low-vigor volcanic soils at 1,500 feet, this 100% Syrah shows a taut, restrained character before erupting loads of oaky sweet spice, vanilla and cocoa aromas. At its core, the 2006 Syrah is dense and deeply fruited with ripe blueberry and brooding black fruit, thick with fleshy texture and firm tannins.'},\n",
       " {'': '747',\n",
       "  'name': 'Lewis Cellars Napa Valley Syrah 2007',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': \"Our 2007 Syrah Napa Valley is the muscle car, the big-block powered bottle from our Rhone wine line-up. Mountain vines in low-vigor volcanic soils at 1,500 feet yield high-octane juice that's practically jet-black and packed with cedary oak spice and smoky dark fruit. Brambly, lifted and dense, the wine is also vibrant and fresh, framed with chewy, long-throw tannins that travel far down the road.\"},\n",
       " {'': '748',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon (1.5 Liter Magnum) 2011',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Scarce in quantity the 2011 Reserve Cabernet delivers plenty of complex aromas and lots of classic character. Sourced from a small collection of hillside and benchland vineyards in Calistoga, Oak Knoll and Rutherford, the wine centers around ripe currant and blue-black fruits threaded with tobacco leaf, nutmeg, baking spices and sweet toasty oak. Elegant and supple at first sip the wine gains focus, finishing with fine structure.'},\n",
       " {'': '749',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon (1.5 Liter Magnum) 2016',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'This Cabernet is a silky powerhouse of fruit at wide-open-throttle. Black currant, plum and juicy ripe berries rev freely on the palate with seductive oak spice, candle wax and semi-sweet chocolate aromas. Fine-tuned and polished, the wine is deceptively powerful with supple, sweeping tannins.'},\n",
       " {'': '750',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon (1.5L Magnum) 2004',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': \"This 2004 bottling could be Lewis Cellars' most captivating Reserve Cabernet Sauvignon yet. It combines the breadth and power of vintages like ’97 and ’01, with the depth and rich fruit of the ’02 vintage. Crafted from Pritchard Hill, Calistoga, Rutherford and Oak Knoll hillside vineyards and blended with 8% Cabernet Franc, the nose is a powder keg of explosive black fruit and blueberries with seamlessly fused oak spices, cedar, cocoa and espresso. The palate is a cannonball of concentrated core fruit with delicious, chewy texture and rich, round mouthfeel that travels leagues on sinewy tannins.\"},\n",
       " {'': '751',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 1995',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '90.0',\n",
       "  'notes': 'The nose is powerful with cedar, oak and blackberry aromas. The palate is muscular, densely layered with black fruit and dark chocolate flavors, integrated with full round tannins. Delicious now, this wine will continue to improve with bottle age.'},\n",
       " {'': '752',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2000',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '91.0',\n",
       "  'notes': 'Our 2000 Reserve Cabernet is a beautiful, showy wine, spilling-over with spicy oak and aromatic cedar, centered on opulent black fruit. Absolutely rich, ripe and round, we used 90% Cabernet Sauvignon, 7% Cabernet Franc and 3% Merlot in this Reserve blend. A cloak of vanilla, clove and seductive oak spice wraps around a deeply fruited core of currant and wild berries with hints of anise and chocolate that gradually give way to long, mouth-coating tannins. 2,300 cases produced. '},\n",
       " {'': '753',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2005',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Our 2005 Reserve Cabernet Sauvignon is a broad-shouldered blend of 93% Cabernet and 7% Cabernet Franc, crafted from Pritchard Hill, Calistoga, Rutherford and Oak Knoll hillside vineyards. The nose is saturated with blackberry and sweet oak spice, tinged with toffee and chocolate. On entry the wine is brooding, tightly packed with fleshy fruit and sinewy texture that gathers richness and length on the palate with satisfying, fine-grained tannins.'},\n",
       " {'': '754',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2006',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'Seductive, sleek and serious best describe our 2006 Reserve Cabernet Sauvignon. 96% Cabernet and 4% Cabernet Franc, this opulent wine is crafted from Pritchard Hill, Calistoga, Rutherford and Oak Knoll hillside vineyards. Cedary sweet oak spice, black fruit and cocoa aromas are potent. On entry the wine is deeply fruited, plush and round with kirsch, café mocha and blackberry flavors supporting very supple, fine-grained tannins and delivering great texture and length.'},\n",
       " {'': '755',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2007',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'From the exceptional 2007 vintage, with production down 15% from 2006, we have crafted a densely woven, deeply fruited Reserve Cabernet rooted in Pritchard Hill, Calistoga, Rutherford and Oak Knoll hillside vineyards. Broad-shouldered and muscular, this blend of 97% Cabernet Sauvignon and 3% Cabernet Franc is packed with black currants and berries, dark chocolate, espresso, and sweet cedar and oak spice. Thickly textured on a massive scale with saturated fruit and sinewy tannins, this wine will stand tall for many years. 1,700 cases produced.'},\n",
       " {'': '756',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2008',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': 'Built for comfort as much as speed, the 2008 vintage is packed with fruit and ready to roll, reminding us of our outstanding 2002 Reserve Cabernet. Like the rich interior of a Ferrari GTB, the nose is showy, ripe and rustic with black currant, clove, tar and exotic oak spices. Under the hood this blend of 98% Cabernet Sauvignon and 2% Petit Verdot shows plenty of extract and fleshy fruit delivering seamless power and expansive mouth feel. Moderate, chocolaty tannins engage mid-palate to gradually tighten the chassis and bring a lively quality to the ride.'},\n",
       " {'': '757',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2009',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '94.0',\n",
       "  'notes': \"This elegant and opulently spiced 2009 Reserve Cabernet is sourced from a small collection of hillside and benchland vineyards rooted in the Oak Knoll and Calistoga appellations. Infused with exotic oak, cocoa and clove spices this blend of 98% Cabernet Sauvignon and 2% Petit Verdot is powerfully aromatic. Sweet black currant and boysenberry flavors gradually take the backseat to a more muscular mid-palate framed with sinewy tannins and baker's chocolate.\"},\n",
       " {'': '758',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2010',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '96.0',\n",
       "  'notes': ''},\n",
       " {'': '759',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2011',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Scarce in quantity the 2011 Reserve Cabernet delivers plenty of complex aromas and lots of classic character. Sourced from a small collection of hillside and benchland vineyards in Calistoga, Oak Knoll and Rutherford, the wine centers around ripe currant and blue-black fruits threaded with tobacco leaf, nutmeg, baking spices and sweet toasty oak. Elegant and supple at first sip the wine gains focus, finishing with fine structure.'},\n",
       " {'': '760',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2015',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'From the outstanding 2015 vintage the Reserve Cabernet is powerfully seductive, brilliant and black in hue with kirsch-like crushed berries and showy cedar spice. Ripe, hi-tone fruit aromas are laced with candlewax, clove and cocoa. Expansive, with tiers of black fruit and velvety texture, the palate builds depth and power culminating in a muscular, long finish with supple young tannins.'},\n",
       " {'': '761',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2014',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '95.0',\n",
       "  'notes': 'The best qualities from our past two vintages come together like yin and yang in our singular 2014 Reserve Cabernet.  Radiant color and soaring aromas of ripe blackberry, toasty oak spices, black truffle and cappuccino make an impressive entrée.  Fleshy and supple at first, the wine expands into deeper, more concentrated fruit layers with chocolaty, fine-grained tannins.'},\n",
       " {'': '762',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon 2016',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'There is distinct power and complexity to our 2016 Reserve Cabernet. Navy blue-black yet brilliant in color the wine is front-loaded with ripe fruit of crushed currants and berries. Secondary notes bring mineral and earth aromas laced with sweet anise and oak spice. Packed with fruit on entry, a dusky, sinewy character develops on the palate with fine-grained tannins tailing to the finish.'},\n",
       " {'': '763',\n",
       "  'name': 'Lewis Cellars Reserve Cabernet Sauvignon (scuffed labels) 2012',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '96.0',\n",
       "  'notes': 'The headline reads: \"2012 Reserve Cabernet - Return of the Big Block\". Running on high octane aromas and built on an iron block with deep reserves of black fruit this 100% Cabernet blend delivers 700 horsepower at the wheels. Coming off idle the nose slowly explodes with sappy dark and rustic berries, clove, cedar and sweet oak spices. Forged, ripe fruit pistons pump out the power for miles until finally finishing with an impressive band of ported and polished tannins. Motor must be warmed-up before driving!'},\n",
       " {'': '764',\n",
       "  'name': 'Lewis Cellars Reserve Chardonnay 2008',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Bottled unfined and unfiltered in December last year, our 2008 Reserve Chardonnay shows fantastic focus, complexity and richness. There is great breadth and allure in the nose of crushed blossoms and stone, lime zest, hazelnut and pear; but the palate takes center stage. Like a French kiss, the wine is sumptuous and silky-rich in texture with creamy minerality and endlessly intriguing notes of bread crust and caramel. The palate retains great focus and structure throughout, as it leads to a long, luxurious finish.'},\n",
       " {'': '765',\n",
       "  'name': 'Lewis Cellars Reserve Chardonnay 2015',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Neil Young\\'s \"Cinnamon Girl\" best captures the character of our rocking 2015 Reserve Chardonnay. Ripe yet succulent D\\'Anjou pear, gardenia blossom, sweet mineral spice and toasty brioche aromas come singing through. Broad-shouldered, with creamy textured leesy flavors, the wine reaches great depth while maintaining precision and serious structure.'},\n",
       " {'': '766',\n",
       "  'name': 'Lewis Cellars Reserve Chardonnay 2018',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'From the long growing season of 2018, this Napa Reserve Chardonnay has super showy aromatics, deliciously complex flavors and alluring texture that can’t be captured in words. Opening with white flower blossoms, green pear, lime zest and crushed stone mineral the wine is fragrant and long-limbed. Profoundly rich and silky texture is underpinned with structural detail and a stunningly long tail.'},\n",
       " {'': '767',\n",
       "  'name': 'Lewis Cellars Reserve Chardonnay 2017',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '93.0',\n",
       "  'notes': 'Think of our 2017 Reserve Chardonnay as a Rolls Royce Wraith – offering a sumptuous interior with serious performance. A plethora of heady aromas alight from the glass with Anjou pear, warm brioche, sweet mineral spice and gardenia blossom. Lush yet lively with great depth and gauzy texture the wine shows impeccable build quality and attention to detail with a miles long finish.'},\n",
       " {'': '768',\n",
       "  'name': 'Lewis Cellars Reserve Merlot 1995',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'Red Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'When asked to describe our Reserve Merlot as briefly as possible our response is \"velvet hammer.\" Supple and velvety rich on the palate, layered with dark ripe fruit, the wine finishes polished and round.'},\n",
       " {'': '769',\n",
       "  'name': 'Lewis Cellars Sauvignon Blanc 2016',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '90.0',\n",
       "  'notes': \"The warm, vibrant character and seductive imagery of Paul Gauguin's Tahiti are captured in our 2016 Sauvignon Blanc. Awash in ripe mango, guava and papaya and laced with tropical blossoms, vanilla and spice, the wine is lush and luxuriant, fruitful to the core, yet draped in native acidity and a fleck of salinity that frame and lengthen the canvas.\"},\n",
       " {'': '770',\n",
       "  'name': 'Lewis Cellars Sauvignon Blanc 2018',\n",
       "  'grape': '',\n",
       "  'region': 'Napa Valley, California',\n",
       "  'variety': 'White Wine',\n",
       "  'rating': '92.0',\n",
       "  'notes': 'Like a sailplane this 2018 Sauvignon Blanc soars with alluring floral spice, lemon-lime zest and hints of vanilla. A leading edge of native acidity frames a camber line of ripe mango and tropical fruit that tails gracefully with succulent lime skin and subtle mineral.'}]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# This example creates a new list that only has wines from Napa Valley. The new list is called napa_wines:\n",
    "napa_wines = []\n",
    "for wine in wines:\n",
    "    if 'Napa' in wine['region']:\n",
    "        napa_wines.append(wine)\n",
    "\n",
    "napa_wines"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**NOTE**: If you are trying to use ratings, remember that you will need to convert the ratings to integers for numerical comparisons."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Using Pandas\n",
    "Alternatively, you can use the Pandas library to load the CSV file and then extract the data. You'll need to install the Pandas library first. You can do this with the following command:\n",
    "\n",
    "```bash\n",
    "pip install pandas\n",
    "```\n",
    "\n",
    "Then, you can use the following code to load the CSV file and extract the data:\n",
    "\n",
    "```python\n",
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('sample_data/wine-ratings-small.csv')\n",
    "df.head()\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>grape</th>\n",
       "      <th>region</th>\n",
       "      <th>variety</th>\n",
       "      <th>rating</th>\n",
       "      <th>notes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Laurenz V Charming Gruner Veltliner 2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kamptal, Austria</td>\n",
       "      <td>White Wine</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Aromas of ripe apples and a typical Veltliner ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Laurenz V Charming Gruner Veltliner 2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kamptal, Austria</td>\n",
       "      <td>White Wine</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Aromas of ripe apples and a typical Veltliner ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Laurenz V Singing Gruner Veltliner 2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>White Wine</td>\n",
       "      <td>90.0</td>\n",
       "      <td>A very attractive fruit bouquet yields apple, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Laurenz V Singing Gruner Veltliner 2010</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>White Wine</td>\n",
       "      <td>88.0</td>\n",
       "      <td>A very attractive fruit bouquet yields apple, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Laurenz V Singing Gruner Veltliner 2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Austria</td>\n",
       "      <td>White Wine</td>\n",
       "      <td>88.0</td>\n",
       "      <td>A very attractive fruit bouquet yields apple, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       name  grape            region  \\\n",
       "0  Laurenz V Charming Gruner Veltliner 2013    NaN  Kamptal, Austria   \n",
       "1  Laurenz V Charming Gruner Veltliner 2014    NaN  Kamptal, Austria   \n",
       "2   Laurenz V Singing Gruner Veltliner 2007    NaN           Austria   \n",
       "3   Laurenz V Singing Gruner Veltliner 2010    NaN           Austria   \n",
       "4   Laurenz V Singing Gruner Veltliner 2011    NaN           Austria   \n",
       "\n",
       "      variety  rating                                              notes  \n",
       "0  White Wine    90.0  Aromas of ripe apples and a typical Veltliner ...  \n",
       "1  White Wine    90.0  Aromas of ripe apples and a typical Veltliner ...  \n",
       "2  White Wine    90.0  A very attractive fruit bouquet yields apple, ...  \n",
       "3  White Wine    88.0  A very attractive fruit bouquet yields apple, ...  \n",
       "4  White Wine    88.0  A very attractive fruit bouquet yields apple, ...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv(\"sample_data/wine-ratings-small.csv\", index_col=0) # read the csv file and set the index column to 0\n",
    "df.head() # show the first 5 rows of the dataframe\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Manipulate data with Pandas or as a dictionary\n",
    "At this point, you can use Pandas if you know how to use it. Otherwise, you can use the data as a dictionary. You can use the following code to extract the data:\n",
    "\n",
    "```python\n",
    "data = df.to_dict()\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{0: 'Laurenz V Charming Gruner Veltliner 2013',\n",
       " 1: 'Laurenz V Charming Gruner Veltliner 2014',\n",
       " 2: 'Laurenz V Singing Gruner Veltliner 2007',\n",
       " 3: 'Laurenz V Singing Gruner Veltliner 2010',\n",
       " 4: 'Laurenz V Singing Gruner Veltliner 2011',\n",
       " 5: 'Laurenz V Singing Gruner Veltliner 2013',\n",
       " 6: 'Lava Cap American River Red',\n",
       " 7: 'Lava Cap Barbera 2010',\n",
       " 8: 'Lava Cap Battonage Chardonnay 2012',\n",
       " 9: 'Lava Cap Cabernet Sauvignon 2013',\n",
       " 10: 'Lava Cap Cabernet Sauvignon 2016',\n",
       " 11: 'Lava Cap Petite Sirah 2013',\n",
       " 12: 'Lava Cap Petite Sirah 2014',\n",
       " 13: 'Lava Cap Petite Sirah 2016',\n",
       " 14: 'Lava Cap Reserve Chardonnay 2015',\n",
       " 15: 'Lava Cap Reserve Chardonnay 2018',\n",
       " 16: 'Lava Cap Reserve Chardonnay 2016',\n",
       " 17: 'Lava Cap Reserve Merlot 2015',\n",
       " 18: 'Lava Cap Sauvignon Blanc 2015',\n",
       " 19: 'Lava Cap Sauvignon Blanc 2017',\n",
       " 20: 'Lava Cap Syrah 2009',\n",
       " 21: 'Lava Cap Syrah 2014',\n",
       " 22: 'Lava Cap Syrah 2013',\n",
       " 23: 'Lava Vine Winery Knights Valley Reserve Cabernet Sauvignon 2013',\n",
       " 24: 'Lava Vine Winery Napa Valley Cabernet Sauvignon 2014',\n",
       " 25: 'Lava Vine Winery Napa Valley Reserve Cabernet Sauvignon 2012',\n",
       " 26: 'Lava Vine Winery Napa Valley Reserve Cabernet Sauvignon 2013',\n",
       " 27: 'Lavau Chateauneuf-du-Pape 2016',\n",
       " 28: 'Lavau Chateauneuf-du-Pape 2014',\n",
       " 29: 'Lavau Chateauneuf-du-Pape 2015',\n",
       " 30: 'Lavau Gigondas 2013',\n",
       " 31: 'Lavau Gigondas 2013',\n",
       " 32: 'Lavau Gigondas 2014',\n",
       " 33: 'Lavau Gigondas 2015',\n",
       " 34: 'Lavau Gigondas 2016',\n",
       " 35: 'Lavau Rasteau 2015',\n",
       " 36: 'Lavau Rasteau 2016',\n",
       " 37: \"L'Aventure Cabernet Sauvignon 2006\",\n",
       " 38: \"L'Aventure Chloe 2014\",\n",
       " 39: \"L'Aventure Cote A Cote 2006\",\n",
       " 40: \"L'Aventure Cote A Cote 2007\",\n",
       " 41: \"L'Aventure Cote A Cote 2010\",\n",
       " 42: \"L'Aventure Cote A Cote 2011\",\n",
       " 43: \"L'Aventure Cote A Cote 2014\",\n",
       " 44: \"L'Aventure Cote A Cote (slightly stained labels) 2012\",\n",
       " 45: \"L'Aventure Estate Cuvee (1.5 Liter Magnum) 2008\",\n",
       " 46: \"L'Aventure Estate Cuvee 2004\",\n",
       " 47: \"L'Aventure Estate Cuvee 2005\",\n",
       " 48: \"L'Aventure Estate Cuvee 2006\",\n",
       " 49: \"L'Aventure Estate Cuvee 2007\",\n",
       " 50: \"L'Aventure Estate Cuvee 2008\",\n",
       " 51: \"L'Aventure Estate Cuvee 2010\",\n",
       " 52: \"L'Aventure Estate Cuvee 2011\",\n",
       " 53: \"L'Aventure Estate Cuvee 2013\",\n",
       " 54: \"L'Aventure Estate Cuvee 2012\",\n",
       " 55: \"L'Aventure Estate Cuvee 2014\",\n",
       " 56: \"L'Aventure Estate Cuvee 2016\",\n",
       " 57: \"L'Aventure Optimus (1.5 Liter Magnum) 2012\",\n",
       " 58: \"L'Aventure Optimus 2005\",\n",
       " 59: \"L'Aventure Optimus 2007\",\n",
       " 60: \"L'Aventure Optimus 2008\",\n",
       " 61: \"L'Aventure Optimus 2011\",\n",
       " 62: \"L'Aventure Optimus 2015\",\n",
       " 63: \"L'Aventure Optimus 2016\",\n",
       " 64: \"L'Aventure Optimus 2017\",\n",
       " 65: \"L'Aventure Optimus 2012\",\n",
       " 66: 'Lavinea Elton Chardonnay 2016',\n",
       " 67: 'Lavinea Elton Pinot Noir 2016',\n",
       " 68: 'Lavinea Lazy River Pinot Noir 2016',\n",
       " 69: 'Lavinea Nysa Pinot Noir 2016',\n",
       " 70: 'Lavinea Tualatin Pinot Noir 2016',\n",
       " 71: 'Lavinea Tualatin Pinot Noir 2017',\n",
       " 72: 'Lavradores de Feitoria Tres Bagos 2003',\n",
       " 73: 'Lavradores de Feitoria Tres Bagos 2004',\n",
       " 74: 'Law Estate Wines Audacious 2016',\n",
       " 75: 'Law Estate Wines Sagacious 2016',\n",
       " 76: \"Lawson's Dry Hills Gewurztraminer 2009\",\n",
       " 77: \"Lawson's Dry Hills Gewurztraminer 2014\",\n",
       " 78: \"Lawson's Dry Hills Pinot Noir 2005\",\n",
       " 79: \"Lawson's Dry Hills Sauvignon Blanc 2014\",\n",
       " 80: 'Layer Cake Cabernet Sauvignon 2010',\n",
       " 81: 'Layer Cake Chardonnay 2011',\n",
       " 82: 'Layer Cake Garnacha 2011',\n",
       " 83: 'Layer Cake Malbec 2008',\n",
       " 84: 'Layer Cake Primitivo aka Zinfandel 2008',\n",
       " 85: 'Layer Cake Shiraz 2008',\n",
       " 86: 'Layer Cake Shiraz 2009',\n",
       " 87: 'Layer Cake Shiraz 2014',\n",
       " 88: 'Layer Cake Shiraz 2013',\n",
       " 89: 'Layer Cake Shiraz 2010',\n",
       " 90: 'Layer Cake Virgin Chardonnay 2009',\n",
       " 91: 'Le Berne Vino Nobile di Montepulciano 2011',\n",
       " 92: 'Le Bonheur Cabernet Sauvignon 1997',\n",
       " 93: 'Le Bonheur Chardonnay 1999',\n",
       " 94: 'Le Brun de Neuville Authentique Brut Assemblage',\n",
       " 95: 'Le Cadeau Vineyard Diversite Pinot Noir 2014',\n",
       " 96: 'Le Cadeau Vineyard Diversite Pinot Noir 2015',\n",
       " 97: 'Le Cadeau Vineyard Rocheux Pinot Noir 2015',\n",
       " 98: 'Le Cadeau Vineyard Rocheux Pinot Noir 2016',\n",
       " 99: 'Le Cadeau Vineyard Rocheux Reserve Pinot Noir 2014',\n",
       " 100: 'Le Carre 2007',\n",
       " 101: 'Le Carre 2008',\n",
       " 102: 'Le Carre 2009',\n",
       " 103: 'Le Carre 2010',\n",
       " 104: 'Le Carre 2011',\n",
       " 105: 'Le Carre 2012',\n",
       " 106: 'Le Casematte Faro 2014',\n",
       " 107: 'Le Casematte Faro 2013',\n",
       " 108: 'Le Casematte Faro 2016',\n",
       " 109: \"Le Casematte Nero d'Avola 2015\",\n",
       " 110: 'Le Casematte Peloro Rosso 2014',\n",
       " 111: 'Le Casematte Peloro Rosso 2015',\n",
       " 112: 'Le Casematte Peloro Bianco 2017',\n",
       " 113: 'Le Casematte Peloro Rosso 2017',\n",
       " 114: 'Le Charmel Rhone Blend 2011',\n",
       " 115: 'Le Chiuse Brunello di Montalcino 2008',\n",
       " 116: 'Le Chiuse Brunello di Montalcino 2010',\n",
       " 117: 'Le Chiuse Brunello di Montalcino 2011',\n",
       " 118: 'Le Chiuse Brunello di Montalcino 2012',\n",
       " 119: 'Le Chiuse Brunello di Montalcino 2013',\n",
       " 120: 'Le Chiuse Brunello di Montalcino 2015',\n",
       " 121: 'Le Chiuse Brunello di Montalcino (375ML half-bottle) 2011',\n",
       " 122: 'Le Chiuse Brunello di Montalcino (375ML half-bottle) 2013',\n",
       " 123: 'Le Chiuse Brunello di Montalcino (375ML half-bottle) 2012',\n",
       " 124: 'Le Chiuse Brunello di Montalcino Riserva 2006',\n",
       " 125: 'Le Chiuse Brunello di Montalcino Riserva 2009',\n",
       " 126: 'Le Chiuse Rosso di Montalcino 2015',\n",
       " 127: 'Le Chiuse Rosso di Montalcino 2017',\n",
       " 128: 'Le Cirque Grenache Gris 2014',\n",
       " 129: 'Le Cirque Grenache Gris 2015',\n",
       " 130: 'Le Cirque Rouge 2014',\n",
       " 131: \"Le Clos d'un Jour Un Jour sur Terre Cahors 2005\",\n",
       " 132: 'Le Colture Brut Rose',\n",
       " 133: 'Le Colture Fagher Prosecco Superiore Brut',\n",
       " 134: 'Le Colture Prosecco Superiore di Cartizze',\n",
       " 135: 'Le Corti Chianti Classico 2011',\n",
       " 136: 'Le Corti Chianti Classico 2012',\n",
       " 137: 'Le Corti Chianti Classico 2013',\n",
       " 138: 'Le Corti Don Tommaso Chianti Classico 2007',\n",
       " 139: 'Le Corti Chianti Classico 2016',\n",
       " 140: 'Le Corti Don Tommaso Chianti Classico 2008',\n",
       " 141: 'Le Corti Don Tommaso Chianti Classico 2013',\n",
       " 142: 'Le Corti Don Tommaso Chianti Classico 2014',\n",
       " 143: 'Le Corti Don Tommaso Chianti Classico 2009',\n",
       " 144: 'Le Corti Tenuta Birillo Rosso 2010',\n",
       " 145: \"Le Domaine D'Henri Chablis Fourchaume Premier Cru 2014\",\n",
       " 146: \"Le Domaine D'Henri Chablis Fourchaume Premier Cru 2015\",\n",
       " 147: \"Le Domaine D'Henri Chablis Fourchaume Premier Cru Vieilles Vignes 2014\",\n",
       " 148: 'Le Dome 2006',\n",
       " 149: 'Le Dome 2008',\n",
       " 150: 'Le Dome 2009',\n",
       " 151: 'Le Dome 2011',\n",
       " 152: 'Le Dome 2012',\n",
       " 153: 'Le Due Terre Colli Orientali del Friuli Sacrisassi 2005',\n",
       " 154: 'Le Due Terre Colli Orientali del Friuli Sacrisassi 2007',\n",
       " 155: 'Le Dome 2016',\n",
       " 156: 'Le Dome 2010',\n",
       " 157: 'Le Dome 2014',\n",
       " 158: 'Le Fonti Chianti Classico 2009',\n",
       " 159: 'Le Grand Courtage Blanc de Blancs Brut Bedazzled Bottle',\n",
       " 160: 'Le Grand Courtage Rose Brut Bedazzled Bottle',\n",
       " 161: 'Le Jas des Papes Chateauneuf-du-Pape 2010',\n",
       " 162: 'Le Macchiole (1.5 Liter Magnum) 2013',\n",
       " 163: 'Le Macchiole 1999',\n",
       " 164: 'Le Macchiole 2006',\n",
       " 165: 'Le Macchiole 2005',\n",
       " 166: 'Le Macchiole 2008',\n",
       " 167: 'Le Macchiole 2006',\n",
       " 168: 'Le Macchiole 2009',\n",
       " 169: 'Le Macchiole 2010',\n",
       " 170: 'Le Macchiole 2013',\n",
       " 171: 'Le Macchiole Messorio (1.5 Liter Magnum) 2010',\n",
       " 172: 'Le Macchiole 2012',\n",
       " 173: 'Le Macchiole Messorio 2000',\n",
       " 174: 'Le Macchiole Messorio 2002',\n",
       " 175: 'Le Macchiole Messorio 2003',\n",
       " 176: 'Le Macchiole Messorio 2005',\n",
       " 177: 'Le Macchiole Messorio 2007',\n",
       " 178: 'Le Macchiole Messorio 2009',\n",
       " 179: 'Le Macchiole Messorio 2010',\n",
       " 180: 'Le Macchiole Messorio 2012',\n",
       " 181: 'Le Macchiole Messorio 2011',\n",
       " 182: 'Le Macchiole Messorio 2013',\n",
       " 183: 'Le Macchiole Messorio 2014',\n",
       " 184: 'Le Macchiole Paleo (1.5 Liter Magnum) 2007',\n",
       " 185: 'Le Macchiole Paleo (1.5 Liter Magnum) 2009',\n",
       " 186: 'Le Macchiole Paleo (1.5 Liter Magnum) 2011',\n",
       " 187: 'Le Macchiole Paleo 1998',\n",
       " 188: 'Le Macchiole Paleo 2003',\n",
       " 189: 'Le Macchiole Paleo 2001',\n",
       " 190: 'Le Macchiole Paleo 2004',\n",
       " 191: 'Le Macchiole Paleo 2005',\n",
       " 192: 'Le Macchiole Paleo 2007',\n",
       " 193: 'Le Macchiole Paleo 2008',\n",
       " 194: 'Le Macchiole Paleo 2009',\n",
       " 195: 'Le Macchiole Paleo 2010',\n",
       " 196: 'Le Macchiole Paleo 2011',\n",
       " 197: 'Le Macchiole Paleo 2012',\n",
       " 198: 'Le Macchiole Paleo 2013',\n",
       " 199: 'Le Macchiole Paleo 2014',\n",
       " 200: 'Le Macchiole Paleo (3 Liter Bottle) 2011',\n",
       " 201: 'Le Macchiole Paleo Bianco 2007',\n",
       " 202: 'Le Macchiole Paleo Bianco 2013',\n",
       " 203: 'Le Macchiole Paleo Bianco 2015',\n",
       " 204: 'Le Macchiole Paleo Bianco 2016',\n",
       " 205: 'Le Macchiole Paleo Bianco 2017',\n",
       " 206: 'Le Macchiole Scrio 2004',\n",
       " 207: 'Le Macchiole Scrio 2001',\n",
       " 208: 'Le Macchiole Scrio 2005',\n",
       " 209: 'Le Macchiole Scrio 2006',\n",
       " 210: 'Le Macchiole Scrio 2010',\n",
       " 211: 'Le Macchiole Scrio 2012',\n",
       " 212: 'Le Macchiole Scrio 2011',\n",
       " 213: 'Le Macchiole Scrio 2013',\n",
       " 214: 'Le Mistral 2008',\n",
       " 215: 'Le Paradou Grenache 2012',\n",
       " 216: 'Le Macchiole Scrio 2015',\n",
       " 217: 'Le Potazzine Gorelli Brunello di Montalcino 1997',\n",
       " 218: 'Le Potazzine Gorelli Brunello di Montalcino 2008',\n",
       " 219: 'Le Potazzine Gorelli Brunello di Montalcino 2009',\n",
       " 220: 'Le Potazzine Gorelli Brunello di Montalcino 2011',\n",
       " 221: 'Le Potazzine Gorelli Brunello di Montalcino 2010',\n",
       " 222: 'Le Potazzine Gorelli Brunello di Montalcino 2012',\n",
       " 223: 'Le Potazzine Rosso di Montalcino 2012',\n",
       " 224: 'Le Potazzine Gorelli Brunello di Montalcino 2013',\n",
       " 225: 'Le Potazzine Rosso di Montalcino 2014',\n",
       " 226: 'Le Potazzine Rosso di Montalcino 2015',\n",
       " 227: 'Le Potazzine Rosso di Montalcino 2017',\n",
       " 228: \"Le P'tit Paysan Jack's Hill Chardonnay 2011\",\n",
       " 229: \"Le P'tit Paysan Jack's Hill Chardonnay 2013\",\n",
       " 230: \"Le P'tit Paysan Jack's Hill Chardonnay 2015\",\n",
       " 231: \"Le P'tit Paysan La Marea Albarino 2014\",\n",
       " 232: \"Le P'tit Paysan La Marea Albarino 2015\",\n",
       " 233: \"Le P'tit Paysan La Marea Grenache 2013\",\n",
       " 234: \"Le P'tit Paysan Le P'tit Pape 2011\",\n",
       " 235: \"Le P'tit Paysan Le P'tit Pape 2013\",\n",
       " 236: \"Le P'tit Paysan Le P'tit Pape 2012\",\n",
       " 237: \"Le P'tit Paysan Le P'tit Pape 2014\",\n",
       " 238: \"Le P'tit Paysan Le P'tit Pape 2015\",\n",
       " 239: \"Le P'tit Paysan Le P'tit Pape 2016\",\n",
       " 240: \"Le P'tit Paysan Le P'tit Pape 2017\",\n",
       " 241: \"Le P'tit Paysan Petite Sirah 2011\",\n",
       " 242: \"Le P'tit Paysan Petite Sirah 2013\",\n",
       " 243: \"Le P'tit Paysan Rose 2018\",\n",
       " 244: 'Le Ragnaie Brunello di Montalcino 2010',\n",
       " 245: 'Le Ragose Amarone Della Valpolicella 2004',\n",
       " 246: 'Le Ragose Amarone Della Valpolicella 2005',\n",
       " 247: 'Le Roi des Pierres Sancerre 2014',\n",
       " 248: 'Le Roi des Pierres Sancerre 2015',\n",
       " 249: 'Le Roi des Pierres Sancerre 2016',\n",
       " 250: 'Le Roi des Pierres Sancerre Rose 2016',\n",
       " 251: 'Le Salette Amarone Classico 2011',\n",
       " 252: 'Le Salette Amarone Classico 2012',\n",
       " 253: 'Le Salette Amarone Classico 2013',\n",
       " 254: 'Le Salette Amarone della Valpolicella Pergole Vece Recioto (500ML) 2011',\n",
       " 255: 'Le Salette La Marega Amarone 2011',\n",
       " 256: 'Le Salette La Marega Amarone 2012',\n",
       " 257: 'Le Salette La Marega Amarone 2013',\n",
       " 258: 'Le Salette Pergole Vece Amarone 2008',\n",
       " 259: 'Le Salette Pergole Vece Amarone 2011',\n",
       " 260: 'Le Salette Pergole Vece Amarone 2012',\n",
       " 261: 'Le Salette Pergole Vece Amarone 2015',\n",
       " 262: 'Le Salette Valpolicella Classico 2012',\n",
       " 263: 'Le Terrazze Rosso Conero 2009',\n",
       " 264: 'Le Vieux Donjon Chateauneuf-du-Pape (1.5 Liter Magnum) 2003',\n",
       " 265: 'Le Vieux Donjon Chateauneuf-du-Pape (1.5 Liter Magnum) 2005',\n",
       " 266: 'Le Vieux Donjon Chateauneuf-du-Pape (1.5 Liter Magnum) 2012',\n",
       " 267: 'Le Vieux Donjon Chateauneuf-du-Pape (1.5 Liter Magnum) 2015',\n",
       " 268: 'Le Vieux Donjon Chateauneuf-du-Pape 2001',\n",
       " 269: 'Le Vieux Donjon Chateauneuf-du-Pape 2003',\n",
       " 270: 'Le Vieux Donjon Chateauneuf-du-Pape 2006',\n",
       " 271: 'Le Vieux Donjon Chateauneuf-du-Pape 2007',\n",
       " 272: 'Le Vieux Donjon Chateauneuf-du-Pape 2012',\n",
       " 273: 'Le Vieux Donjon Chateauneuf-du-Pape 2013',\n",
       " 274: 'Le Vieux Donjon Chateauneuf-du-Pape 2016',\n",
       " 275: 'Le Vieux Donjon Chateauneuf-du-Pape (375ML half-bottle) 2006',\n",
       " 276: 'Le Vieux Donjon Chateauneuf-du-Pape (375ML half-bottle) 2012',\n",
       " 277: 'Le Vieux Donjon Chateauneuf-du-Pape Blanc 2006',\n",
       " 278: 'Le Vigne di Eli Etna Bianco 2012',\n",
       " 279: 'Le Vigne di Eli Etna Rosso 2012',\n",
       " 280: 'Le Vigne di Eli Moganazzi-Volta Sciara Etna Rosso 2014',\n",
       " 281: 'Le Vigne di Eli Moganazzi-Volta Sciara Etna Rosso 2016',\n",
       " 282: 'Le Vigne Winery Paso Robles Cabernet Sauvignon 2016',\n",
       " 283: 'Lea Wines Sta. Rita Hills Pinot Noir 2013',\n",
       " 284: 'Lea Wines Sta. Rita Hills Pinot Noir 2014',\n",
       " 285: \"Leacock's 10 Year Bual Madiera\",\n",
       " 286: \"Leacock's Bual 1966\",\n",
       " 287: \"Leacock's Rainwater Madeira\",\n",
       " 288: 'Leaping Lizard Cabernet Sauvignon 2007',\n",
       " 289: 'Leasingham Bin 61 Shiraz 1997',\n",
       " 290: 'Leasingham Bin 61 Shiraz 1999',\n",
       " 291: 'Leasingham Bin 61 Shiraz 2001',\n",
       " 292: 'Leasingham Bin 61 Shiraz 2002',\n",
       " 293: 'Leasingham Bin 61 Shiraz 2000',\n",
       " 294: 'Leasingham Bin 61 Shiraz 1998',\n",
       " 295: 'Leasingham Bin 7 Riesling 2001',\n",
       " 296: 'Leasingham Bin 7 Riesling 2003',\n",
       " 297: 'Leasingham Bin 7 Riesling 2004',\n",
       " 298: 'Leasingham Bin 7 Riesling 2005',\n",
       " 299: 'Leasingham Clare Classic Cabernet Sauvignon 1997',\n",
       " 300: 'Leasingham Clare Classic Shiraz 1997',\n",
       " 301: 'Leasingham Clare Classic Shiraz 1998',\n",
       " 302: 'Leasingham Clare Classic Shiraz 2001',\n",
       " 303: 'Leasingham Clare Valley Bin 56 Cabernet Sauvignon 1999',\n",
       " 304: 'Leasingham Magnus Riesling 2003',\n",
       " 305: 'Leasingham Magnus Riesling 2006',\n",
       " 306: 'Leasingham Magnus Riesling 2007',\n",
       " 307: 'Leasingham Magnus Riesling 2004',\n",
       " 308: 'Lecheneaut Gevrey-Chambertin 2015',\n",
       " 309: 'Lecheneaut Gevrey-Chambertin 2014',\n",
       " 310: 'Lecheneaut Morey-Saint-Denis 2012',\n",
       " 311: 'Lecheneaut Morey-Saint-Denis 2016',\n",
       " 312: 'Lecheneaut Morey-St-Denis 2014',\n",
       " 313: 'Lecheneaut Morey-St-Denis 2015',\n",
       " 314: 'Lecheneaut Nuits-St. Georges 2014',\n",
       " 315: 'Lecheneaut Nuits-St. Georges 2015',\n",
       " 316: 'Lecheneaut Nuits-St. Georges Damodes Premier Cru 2011',\n",
       " 317: 'Lecheneaut Nuits-St. Georges Damodes Premier Cru 2014',\n",
       " 318: 'Lecheneaut Nuits-St. Georges Damodes Premier Cru 2015',\n",
       " 319: 'Lecheneaut Nuits-St. Georges Damodes Premier Cru 2016',\n",
       " 320: 'Lecheneaut Nuits-St-Georges Les Pruliers Premier Cru 2015',\n",
       " 321: \"L'Ecole 41 Barrel Fermented Semillon 2002\",\n",
       " 322: \"L'Ecole 41 Barrel Fermented Semillon 2004\",\n",
       " 323: \"L'Ecole 41 Chardonnay 2004\",\n",
       " 324: \"L'Ecole 41 Chardonnay 2006\",\n",
       " 325: \"L'Ecole 41 Chardonnay 2005\",\n",
       " 326: \"L'Ecole 41 Chardonnay 2008\",\n",
       " 327: \"L'Ecole 41 Chardonnay 2009\",\n",
       " 328: \"L'Ecole 41 Chardonnay 2007\",\n",
       " 329: \"L'Ecole 41 Chardonnay 2012\",\n",
       " 330: \"L'Ecole 41 Chardonnay 2013\",\n",
       " 331: \"L'Ecole 41 Chardonnay 2014\",\n",
       " 332: \"L'Ecole 41 Chardonnay 2015\",\n",
       " 333: \"L'Ecole 41 Chardonnay 2016\",\n",
       " 334: \"L'Ecole 41 Chardonnay 2018\",\n",
       " 335: \"L'Ecole 41 Columbia Valley Cabernet Sauvignon 2007\",\n",
       " 336: \"L'Ecole 41 Columbia Valley Cabernet Sauvignon 2011\",\n",
       " 337: \"L'Ecole 41 Columbia Valley Cabernet Sauvignon 2012\",\n",
       " 338: \"L'Ecole 41 Columbia Valley Cabernet Sauvignon 2015\",\n",
       " 339: \"L'Ecole 41 Columbia Valley Merlot 2000\",\n",
       " 340: \"L'Ecole 41 Columbia Valley Merlot 2003\",\n",
       " 341: \"L'Ecole 41 Columbia Valley Merlot 2004\",\n",
       " 342: \"L'Ecole 41 Columbia Valley Merlot 2005\",\n",
       " 343: \"L'Ecole 41 Columbia Valley Merlot 2006\",\n",
       " 344: \"L'Ecole 41 Columbia Valley Merlot 2007\",\n",
       " 345: \"L'Ecole 41 Columbia Valley Merlot 2010\",\n",
       " 346: \"L'Ecole 41 Columbia Valley Merlot 2011\",\n",
       " 347: \"L'Ecole 41 Columbia Valley Merlot 2012\",\n",
       " 348: \"L'Ecole 41 Columbia Valley Merlot 2013\",\n",
       " 349: \"L'Ecole 41 Columbia Valley Merlot 2008\",\n",
       " 350: \"L'Ecole 41 Columbia Valley Merlot 2014\",\n",
       " 351: \"L'Ecole 41 Columbia Valley Merlot 2016\",\n",
       " 352: \"L'Ecole 41 Columbia Valley Syrah 2012\",\n",
       " 353: \"L'Ecole 41 Columbia Valley Syrah 2014\",\n",
       " 354: \"L'Ecole 41 Columbia Valley Syrah 2013\",\n",
       " 355: \"L'Ecole 41 Columbia Valley Syrah 2015\",\n",
       " 356: \"L'Ecole 41 Columbia Valley Syrah 2016\",\n",
       " 357: \"L'Ecole 41 Ferguson Estate Red 2012\",\n",
       " 358: \"L'Ecole 41 Ferguson Estate Red 2013\",\n",
       " 359: \"L'Ecole 41 Ferguson Estate Red 2014\",\n",
       " 360: \"L'Ecole 41 Ferguson Estate Red 2017\",\n",
       " 361: \"L'Ecole 41 Fries Vineyard Semillon 2002\",\n",
       " 362: \"L'Ecole 41 Fries Vineyard Semillon 2003\",\n",
       " 363: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2007\",\n",
       " 364: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2008\",\n",
       " 365: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2009\",\n",
       " 366: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2010\",\n",
       " 367: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2012\",\n",
       " 368: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2011\",\n",
       " 369: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2013\",\n",
       " 370: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2014\",\n",
       " 371: \"L'Ecole 41 Luminesce Seven Hills Vineyard 2016\",\n",
       " 372: \"L'Ecole 41 Old Vines Chenin Blanc 2011\",\n",
       " 373: \"L'Ecole 41 Old Vines Chenin Blanc 2010\",\n",
       " 374: \"L'Ecole 41 Old Vines Chenin Blanc 2014\",\n",
       " 375: \"L'Ecole 41 Old Vines Chenin Blanc 2013\",\n",
       " 376: \"L'Ecole 41 Old Vines Chenin Blanc 2012\",\n",
       " 377: \"L'Ecole 41 Old Vines Chenin Blanc 2015\",\n",
       " 378: \"L'Ecole 41 Old Vines Chenin Blanc 2016\",\n",
       " 379: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2001\",\n",
       " 380: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2006\",\n",
       " 381: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2008\",\n",
       " 382: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2007\",\n",
       " 383: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2012\",\n",
       " 384: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2013\",\n",
       " 385: \"L'Ecole 41 Pepper Bridge Vineyard Apogee 2014\",\n",
       " 386: \"L'Ecole 41 Semillon 2005\",\n",
       " 387: \"L'Ecole 41 Semillon 2006\",\n",
       " 388: \"L'Ecole 41 Semillon 2007\",\n",
       " 389: \"L'Ecole 41 Semillon 2008\",\n",
       " 390: \"L'Ecole 41 Semillon 2010\",\n",
       " 391: \"L'Ecole 41 Semillon 2009\",\n",
       " 392: \"L'Ecole 41 Semillon 2012\",\n",
       " 393: \"L'Ecole 41 Semillon 2013\",\n",
       " 394: \"L'Ecole 41 Semillon 2015\",\n",
       " 395: \"L'Ecole 41 Semillon 2018\",\n",
       " 396: \"L'Ecole 41 Seven Hills Vineyard Estate Syrah 2001\",\n",
       " 397: \"L'Ecole 41 Seven Hills Vineyard Estate Syrah 2011\",\n",
       " 398: \"L'Ecole 41 Seven Hills Vineyard Estate Syrah 2014\",\n",
       " 399: \"L'Ecole 41 Seven Hills Vineyard Estate Syrah 2015\",\n",
       " 400: \"L'Ecole 41 Seven Hills Vineyard Merlot 2000\",\n",
       " 401: \"L'Ecole 41 Seven Hills Vineyard Merlot 2001\",\n",
       " 402: \"L'Ecole 41 Seven Hills Vineyard Merlot 2000\",\n",
       " 403: \"L'Ecole 41 Seven Hills Vineyard Merlot 2002\",\n",
       " 404: \"L'Ecole 41 Seven Hills Vineyard Merlot 2005\",\n",
       " 405: \"L'Ecole 41 Seven Hills Vineyard Merlot 2007\",\n",
       " 406: \"L'Ecole 41 Seven Hills Vineyard Perigee 2002\",\n",
       " 407: \"L'Ecole 41 Seven Hills Vineyard Perigee 2007\",\n",
       " 408: \"L'Ecole 41 Seven Hills Vineyard Perigee 2011\",\n",
       " 409: \"L'Ecole 41 Seven Hills Vineyard Perigee 2012\",\n",
       " 410: \"L'Ecole 41 Seven Hills Vineyard Perigee 2014\",\n",
       " 411: \"L'Ecole 41 Seven Hills Vineyard Perigee 2015\",\n",
       " 412: \"L'Ecole 41 Seven Hills Vineyard Perigee 2013\",\n",
       " 413: \"L'Ecole 41 Walla Voila Chenin Blanc 2009\",\n",
       " 414: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 1998\",\n",
       " 415: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2000\",\n",
       " 416: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2001\",\n",
       " 417: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2007\",\n",
       " 418: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2009\",\n",
       " 419: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2010\",\n",
       " 420: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2011\",\n",
       " 421: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2012\",\n",
       " 422: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2013\",\n",
       " 423: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2014\",\n",
       " 424: \"L'Ecole 41 Walla Walla Valley Cabernet Sauvignon 2016\",\n",
       " 425: \"L'Ecole 41 Walla Walla Valley Syrah 2003\",\n",
       " 426: \"L'Ecole 41 Walla Walla Valley Syrah 2004\",\n",
       " 427: 'Ledge Catacombs Red Blend 2011',\n",
       " 428: 'Ledge Vineyard Drive Red Blend 2012',\n",
       " 429: 'Leese-Fitch Cabernet Sauvignon 2015',\n",
       " 430: 'Leese-Fitch Cabernet Sauvignon 2016',\n",
       " 431: 'Leese-Fitch Chardonnay 2015',\n",
       " 432: 'Leese-Fitch Chardonnay 2016',\n",
       " 433: 'Leese-Fitch Chardonnay 2017',\n",
       " 434: 'Leese-Fitch Pinot Noir 2016',\n",
       " 435: 'Leese-Fitch Sauvignon Blanc 2010',\n",
       " 436: 'Leese-Fitch Sauvignon Blanc 2015',\n",
       " 437: 'Leese-Fitch Sauvignon Blanc 2017',\n",
       " 438: 'Leese-Fitch Zinfandel 2016',\n",
       " 439: 'Leeuwin Estate Art Series Cabernet Sauvignon 1997',\n",
       " 440: 'Leeuwin Estate Art Series Cabernet Sauvignon 1998',\n",
       " 441: 'Leeuwin Estate Art Series Cabernet Sauvignon 1999',\n",
       " 442: 'Leeuwin Estate Art Series Cabernet Sauvignon 2001',\n",
       " 443: 'Leeuwin Estate Art Series Cabernet Sauvignon 2002',\n",
       " 444: 'Leeuwin Estate Art Series Cabernet Sauvignon 2003',\n",
       " 445: 'Leeuwin Estate Art Series Cabernet Sauvignon 2005',\n",
       " 446: 'Leeuwin Estate Art Series Cabernet Sauvignon 2006',\n",
       " 447: 'Leeuwin Estate Art Series Cabernet Sauvignon 2007',\n",
       " 448: 'Leeuwin Estate Art Series Cabernet Sauvignon 2008',\n",
       " 449: 'Leeuwin Estate Art Series Cabernet Sauvignon 2009',\n",
       " 450: 'Leeuwin Estate Art Series Cabernet Sauvignon 2010',\n",
       " 451: 'Leeuwin Estate Art Series Cabernet Sauvignon 2011',\n",
       " 452: 'Leeuwin Estate Art Series Cabernet Sauvignon 2013',\n",
       " 453: 'Leeuwin Estate Art Series Cabernet Sauvignon 2012',\n",
       " 454: 'Leeuwin Estate Art Series Cabernet Sauvignon 2015',\n",
       " 455: 'Leeuwin Estate Art Series Chardonnay 1998',\n",
       " 456: 'Leeuwin Estate Art Series Chardonnay 2000',\n",
       " 457: 'Leeuwin Estate Art Series Chardonnay 1999',\n",
       " 458: 'Leeuwin Estate Art Series Chardonnay 2002',\n",
       " 459: 'Leeuwin Estate Art Series Chardonnay 2003',\n",
       " 460: 'Leeuwin Estate Art Series Chardonnay 2004',\n",
       " 461: 'Leeuwin Estate Art Series Chardonnay 2001',\n",
       " 462: 'Leeuwin Estate Art Series Chardonnay 2005',\n",
       " 463: 'Leeuwin Estate Art Series Chardonnay 2006',\n",
       " 464: 'Leeuwin Estate Art Series Chardonnay 2007',\n",
       " 465: 'Leeuwin Estate Art Series Chardonnay 2010',\n",
       " 466: 'Leeuwin Estate Art Series Chardonnay 2011',\n",
       " 467: 'Leeuwin Estate Art Series Chardonnay 2013',\n",
       " 468: 'Leeuwin Estate Art Series Chardonnay 2009',\n",
       " 469: 'Leeuwin Estate Art Series Chardonnay 2012',\n",
       " 470: 'Leeuwin Estate Art Series Chardonnay 2014',\n",
       " 471: 'Leeuwin Estate Art Series Chardonnay 2008',\n",
       " 472: 'Leeuwin Estate Art Series Riesling 2001',\n",
       " 473: 'Leeuwin Estate Art Series Riesling 2006',\n",
       " 474: 'Leeuwin Estate Art Series Riesling 2004',\n",
       " 475: 'Leeuwin Estate Art Series Riesling 2008',\n",
       " 476: 'Leeuwin Estate Art Series Riesling 2010',\n",
       " 477: 'Leeuwin Estate Art Series Riesling 2002',\n",
       " 478: 'Leeuwin Estate Art Series Riesling 2011',\n",
       " 479: 'Leeuwin Estate Art Series Riesling 2012',\n",
       " 480: 'Leeuwin Estate Art Series Riesling 2013',\n",
       " 481: 'Leeuwin Estate Art Series Riesling 2014',\n",
       " 482: 'Leeuwin Estate Art Series Riesling 2015',\n",
       " 483: 'Leeuwin Estate Art Series Shiraz 1999',\n",
       " 484: 'Leeuwin Estate Art Series Shiraz 2000',\n",
       " 485: 'Leeuwin Estate Art Series Shiraz 2007',\n",
       " 486: 'Leeuwin Estate Art Series Shiraz 2009',\n",
       " 487: 'Leeuwin Estate Art Series Shiraz 2010',\n",
       " 488: 'Leeuwin Estate Art Series Shiraz 2012',\n",
       " 489: 'Leeuwin Estate Art Series Shiraz 2011',\n",
       " 490: 'Leeuwin Estate Art Series Shiraz 2013',\n",
       " 491: 'Leeuwin Estate Art Series Shiraz 2014',\n",
       " 492: 'Leeuwin Estate Margaret River Riesling 2000',\n",
       " 493: 'Leeuwin Estate Margaret River Riesling 1999',\n",
       " 494: 'Leeuwin Estate Prelude Cabernet Merlot (stained label) 1997',\n",
       " 495: 'Leeuwin Estate Prelude Vineyards Cabernet Sauvignon 2013',\n",
       " 496: 'Leeuwin Estate Prelude Vineyards Cabernet Sauvignon 2014',\n",
       " 497: 'Leeuwin Estate Prelude Vineyards Chardonnay 2001',\n",
       " 498: 'Leeuwin Estate Prelude Vineyards Chardonnay 2000',\n",
       " 499: 'Leeuwin Estate Prelude Vineyards Chardonnay 2004',\n",
       " 500: 'Leeuwin Estate Prelude Vineyards Chardonnay 2003',\n",
       " 501: 'Leeuwin Estate Prelude Vineyards Chardonnay 2006',\n",
       " 502: 'Leeuwin Estate Prelude Vineyards Chardonnay 2007',\n",
       " 503: 'Leeuwin Estate Prelude Vineyards Chardonnay 1999',\n",
       " 504: 'Leeuwin Estate Prelude Vineyards Chardonnay 2009',\n",
       " 505: 'Leeuwin Estate Prelude Vineyards Chardonnay 2010',\n",
       " 506: 'Leeuwin Estate Prelude Vineyards Chardonnay 2011',\n",
       " 507: 'Leeuwin Estate Prelude Vineyards Chardonnay 2012',\n",
       " 508: 'Leeuwin Estate Prelude Vineyards Chardonnay 2013',\n",
       " 509: 'Leeuwin Estate Prelude Vineyards Chardonnay 2014',\n",
       " 510: 'Leeuwin Estate Prelude Vineyards Chardonnay 2015',\n",
       " 511: 'Leeuwin Estate Prelude Vineyards Chardonnay 2018',\n",
       " 512: 'Leeuwin Estate Prelude Vineyards Chardonnay 2016',\n",
       " 513: 'Leeuwin Estate Siblings Sauvignon Blanc 2018',\n",
       " 514: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 1999',\n",
       " 515: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2002',\n",
       " 516: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2004',\n",
       " 517: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2011',\n",
       " 518: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2014',\n",
       " 519: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2015',\n",
       " 520: 'Leeuwin Estate Siblings Sauvignon Blanc Semillon 2016',\n",
       " 521: 'Leeuwin Estate Siblings Shiraz 2003',\n",
       " 522: 'Leeuwin Estate Siblings Shiraz 2007',\n",
       " 523: 'Leeuwin Estate Siblings Shiraz 2004',\n",
       " 524: 'Leeuwin Estate Siblings Shiraz 2012',\n",
       " 525: 'Leeuwin Estate Siblings Shiraz 2014',\n",
       " 526: 'Leeuwin Estate Siblings Shiraz 2013',\n",
       " 527: \"Left Coast Cellars Cali's Cuvee Pinot Noir 2006\",\n",
       " 528: \"Left Coast Cellars Cali's Cuvee Pinot Noir 2013\",\n",
       " 529: \"Left Coast Cellars Cali's Cuvee Pinot Noir 2014\",\n",
       " 530: \"Left Coast Cellars Cali's Cuvee Pinot Noir 2016\",\n",
       " 531: 'Left Coast Cellars Latitude 45 Pinot Noir 2014',\n",
       " 532: 'Left Coast Cellars The Orchards Pinot Gris 2009',\n",
       " 533: 'Legacy Red 2013',\n",
       " 534: 'Legaris Crianza 2005',\n",
       " 535: 'Legaris Crianza 2009',\n",
       " 536: 'Legaris Crianza 2010',\n",
       " 537: 'Legaris Crianza 2012',\n",
       " 538: 'Lemelson Chardonnay Reserve 2012',\n",
       " 539: 'Lemelson Dry Riesling 2008',\n",
       " 540: 'Lemelson Dry Riesling 2009',\n",
       " 541: 'Lemelson Dry Riesling 2012',\n",
       " 542: 'Lemelson Jerome Reserve Pinot Noir 2012',\n",
       " 543: 'Lemelson Dry Riesling 2015',\n",
       " 544: 'Lemelson Meyer Vineyard Pinot Noir 2012',\n",
       " 545: 'Lemelson Meyer Vineyard Pinot Noir 2015',\n",
       " 546: 'Lemelson Stermer Vineyard Pinot Noir 2014',\n",
       " 547: \"Lemelson Thea's Select Pinot Noir 2000\",\n",
       " 548: \"Lemelson Thea's Select Pinot Noir 2006\",\n",
       " 549: \"Lemelson Thea's Select Pinot Noir 2012\",\n",
       " 550: \"Lemelson Thea's Select Pinot Noir 2014\",\n",
       " 551: \"Lemelson Thea's Select Pinot Noir 2015\",\n",
       " 552: 'Lengs and Cooter Shiraz The Victor 2005',\n",
       " 553: 'Lengs and Cooter Shiraz The Victor 2006',\n",
       " 554: 'Lengs and Cooter The Victor 2002',\n",
       " 555: 'Leo Steen Ascona Vineyard Cabernet Franc 2017',\n",
       " 556: 'Leo Steen Jurassic Vineyard Chenin Blanc 2012',\n",
       " 557: 'Leo Steen Jurassic Vineyard Chenin Blanc 2013',\n",
       " 558: 'Leo Steen Chardonnay 2015',\n",
       " 559: 'Leo Steen Jurassic Vineyard Chenin Blanc 2015',\n",
       " 560: 'Leo Steen Jurassic Vineyard Chenin Blanc 2016',\n",
       " 561: 'Leo Steen Peaberry Chenin Blanc 2016',\n",
       " 562: 'Leo Steen Provisor Vineyard Grenache 2016',\n",
       " 563: 'Leo Steen Provisor Vineyard Grenache 2015',\n",
       " 564: 'Leo Steen Saini Vineyard Chenin Blanc 2015',\n",
       " 565: 'Leo Steen Saini Vineyard Chenin Blanc 2016',\n",
       " 566: 'Leo Steen Scala Vineyard Syrah 2013',\n",
       " 567: 'Leone de Castris Primitivo di Manduria Villa Santera 2009',\n",
       " 568: 'Leone de Castris Salice Salentino Riserva 2006',\n",
       " 569: 'Leone de Castris Salice Salentino Riserva 2007',\n",
       " 570: 'Leone de Castris Salice Salentino Riserva 2010',\n",
       " 571: 'Leone de Castris Salice Salentino Riserva 2011',\n",
       " 572: 'Leone de Castris Salice Salentino Riserva 2014',\n",
       " 573: 'Leone de Castris Salice Salentino Riserva 2015',\n",
       " 574: 'Leonetti Cabernet Sauvignon (1.5 Liter Magnum) 2014',\n",
       " 575: 'Leone de Castris Verdeca Bianco Messapia 2009',\n",
       " 576: 'Leonetti Cabernet Sauvignon 1994',\n",
       " 577: 'Leonetti Cabernet Sauvignon 1995',\n",
       " 578: 'Leonetti Cabernet Sauvignon 1997',\n",
       " 579: 'Leonetti Cabernet Sauvignon 1998',\n",
       " 580: 'Leonetti Cabernet Sauvignon 2001',\n",
       " 581: 'Leonetti Cabernet Sauvignon 2000',\n",
       " 582: 'Leonetti Cabernet Sauvignon 2005',\n",
       " 583: 'Leonetti Cabernet Sauvignon 2010',\n",
       " 584: 'Leonetti Cabernet Sauvignon 2011',\n",
       " 585: 'Leonetti Cabernet Sauvignon 2012',\n",
       " 586: 'Leonetti Cabernet Sauvignon 2013',\n",
       " 587: 'Leonetti Cabernet Sauvignon 2014',\n",
       " 588: 'Leonetti Cabernet Sauvignon 2015',\n",
       " 589: 'Leonetti Cabernet Sauvignon (damaged label) 2007',\n",
       " 590: 'Leonetti Cabernet Sauvignon (damaged label) 2009',\n",
       " 591: 'Leonetti Merlot 1993',\n",
       " 592: 'Leonetti Merlot 1995',\n",
       " 593: 'Leonetti Merlot 1997',\n",
       " 594: 'Leonetti Merlot 1998',\n",
       " 595: 'Leonetti Merlot 1999',\n",
       " 596: 'Leonetti Merlot 2001',\n",
       " 597: 'Leonetti Merlot 2003',\n",
       " 598: 'Leonetti Merlot 2004',\n",
       " 599: 'Leonetti Merlot 2005',\n",
       " 600: 'Leonetti Merlot 2007',\n",
       " 601: 'Leonetti Merlot 2006',\n",
       " 602: 'Leonetti Merlot 2008',\n",
       " 603: 'Leonetti Merlot 2012',\n",
       " 604: 'Leonetti Merlot 2010',\n",
       " 605: 'Leonetti Merlot 2013',\n",
       " 606: 'Leonetti Merlot 2015',\n",
       " 607: 'Leonetti Merlot 2014',\n",
       " 608: 'Leonetti Merlot 2016',\n",
       " 609: 'Leonetti Merlot (loose foil capsule) 2000',\n",
       " 610: 'Leonetti Merlot (scuffed labels) 2011',\n",
       " 611: 'Leonetti Reserve 1998',\n",
       " 612: 'Leonetti Reserve 2002',\n",
       " 613: 'Leonetti Reserve 2005',\n",
       " 614: 'Leonetti Reserve 2000',\n",
       " 615: 'Leonetti Reserve 2006',\n",
       " 616: 'Leonetti Reserve 2011',\n",
       " 617: 'Leonetti Reserve 2012',\n",
       " 618: 'Leonetti Reserve 2014',\n",
       " 619: 'Leonetti Reserve 2013',\n",
       " 620: 'Leonetti Reserve 2015',\n",
       " 621: 'Leonetti Reserve (torn label) 2007',\n",
       " 622: 'Leonetti Reserve (torn label) 2008',\n",
       " 623: 'Leonetti Sangiovese 2005',\n",
       " 624: 'Leonetti Sangiovese 2000',\n",
       " 625: 'Leonetti Sangiovese 2006',\n",
       " 626: 'Leonetti Sangiovese 2007',\n",
       " 627: 'Leonetti Sangiovese 2008',\n",
       " 628: 'Leonetti Sangiovese 2009',\n",
       " 629: 'Leonetti Sangiovese 2011',\n",
       " 630: 'Leonetti Sangiovese 2010',\n",
       " 631: 'Leonetti Sangiovese 2013',\n",
       " 632: 'Leonetti Sangiovese 2012',\n",
       " 633: 'Leonetti Sangiovese 2014',\n",
       " 634: 'Leonetti Seven Hills Vineyard Reserve Cabernet Sauvignon 1996',\n",
       " 635: 'Les Alexandrins Cornas 2016',\n",
       " 636: 'Les Alexandrins Domaine Crozes-Hermitage 2016',\n",
       " 637: 'Les Alexandrins Domaine Saint-Joseph 2015',\n",
       " 638: 'Les Alexandrins Domaine Saint-Joseph 2016',\n",
       " 639: 'Les Alexandrins Maison Crozes-Hermitage 2016',\n",
       " 640: 'Les Alexandrins Syrah 2018',\n",
       " 641: \"Les Alexandrins Terrasses de l'Eridan Cotes du Rhone Blanc 2017\",\n",
       " 642: \"Les Alexandrins Terrasses de l'Eridan Cotes du Rhone Rouge 2017\",\n",
       " 643: 'Les Asteries 2005',\n",
       " 644: 'Les Asteries 2007',\n",
       " 645: 'Les Asteries 2008',\n",
       " 646: 'Les Asteries 2009',\n",
       " 647: 'Les Asteries 2011',\n",
       " 648: 'Les Asteries 2010',\n",
       " 649: \"Les Clefs d'Or Les Craus Centenaires 2015\",\n",
       " 650: \"Les Clefs d'Or Les Craus Centenaires 2009\",\n",
       " 651: \"Les Clefs d'Or Les Craus Centenaires 2010\",\n",
       " 652: 'Les Cretes Coteau La Tour 2008',\n",
       " 653: 'Les Cretes Le Sommet Nebbiolo 2016',\n",
       " 654: 'Les Cretes Les Abeilles 2006',\n",
       " 655: \"Les Cretes Valle d'Aosta Chardonnay 2010\",\n",
       " 656: \"Les Cretes Valle d'Aosta Cuvee Bois Chardonnay 2016\",\n",
       " 657: 'Les Forts de Latour 1996',\n",
       " 658: 'Les Forts de Latour 1999',\n",
       " 659: 'Les Forts de Latour 2000',\n",
       " 660: 'Les Forts de Latour 2001',\n",
       " 661: 'Les Forts de Latour 2005',\n",
       " 662: 'Les Forts de Latour 2008',\n",
       " 663: 'Les Forts de Latour 2009',\n",
       " 664: 'Les Garrigues Cotes du Rhone 2017',\n",
       " 665: 'Les Halos de Jupiter Chateauneuf-du-Pape 2009',\n",
       " 666: 'Les Halos de Jupiter Chateauneuf-du-Pape Adrastee 2009',\n",
       " 667: 'Les Halos de Jupiter Cotes du Rhone 2010',\n",
       " 668: 'Les Hauts de Lagarde Bordeaux Blanc 2013',\n",
       " 669: \"Les Quatre Tours Coteaux d'Aix en Provence 2016\",\n",
       " 670: \"Les Vignerons d'Estezargues La Granacha Cotes du Rhone Villages Signargues 2008\",\n",
       " 671: \"Les Vignerons d'Estezargues La Granacha Cotes du Rhone Villages Signargues 2009\",\n",
       " 672: 'Les Vignerons de Tautavel Cotes du Roussillon Villages Tautavel Silex 2012',\n",
       " 673: \"Les Vignerons d'Estezargues La Granacha Cotes du Rhone Villages Signargues 2007\",\n",
       " 674: \"Les Vins Breban L'Opale de La Presqu'ile de St-Tropez Provence 2012\",\n",
       " 675: 'Les Vignes Oubliées Coteaux du Languedoc Terrasses du Larzac 2014',\n",
       " 676: \"L'Esprit de Chevalier Pessac Leognan 2000\",\n",
       " 677: 'Leth Steinagrund Gruner Veltliner 2007',\n",
       " 678: 'Leth Steinagrund Gruner Veltliner 2008',\n",
       " 679: 'Leth Steinagrund Gruner Veltliner 2010',\n",
       " 680: 'Leth Steinagrund Gruner Veltliner 2012',\n",
       " 681: 'Leth Steinagrund Gruner Veltliner 2015',\n",
       " 682: 'Leth Steinagrund Gruner Veltliner 2016',\n",
       " 683: 'Leth Steinagrund Gruner Veltliner 2017',\n",
       " 684: 'Levendi River South Ranch Pinot Noir 2013',\n",
       " 685: 'Levendi Stagecoach Cabernet Sauvignon 2008',\n",
       " 686: 'Levendi Sweeney Ranch Chardonnay 2010',\n",
       " 687: 'Levet La Chavaroche Cote Rotie 2013',\n",
       " 688: 'Levet Les Journaries Cote Rotie 2010',\n",
       " 689: 'Leviathan (1.5 Liter Magnum) 2016',\n",
       " 690: 'Leviathan 2010',\n",
       " 691: 'Leviathan 2011',\n",
       " 692: 'Levy & McClellan Proprietary Red 2004',\n",
       " 693: 'Levy & McClellan Proprietary Red 2005',\n",
       " 694: 'Lewelling Cabernet Sauvignon 2000',\n",
       " 695: 'Lewelling Cabernet Sauvignon 2005',\n",
       " 696: 'Lewelling Cabernet Sauvignon 2001',\n",
       " 697: 'Lewelling Cabernet Sauvignon 2006',\n",
       " 698: 'Lewelling Cabernet Sauvignon 2007',\n",
       " 699: 'Lewelling Cabernet Sauvignon 2009',\n",
       " 700: 'Lewelling Cabernet Sauvignon 2010',\n",
       " 701: 'Lewelling Cabernet Sauvignon 2012',\n",
       " 702: 'Lewelling Wight Vineyard Cabernet Sauvignon 2003',\n",
       " 703: 'Lewelling Wight Vineyard Cabernet Sauvignon 2005',\n",
       " 704: 'Lewelling Wight Vineyard Cabernet Sauvignon 2006',\n",
       " 705: 'Lewelling Wight Vineyard Cabernet Sauvignon 2009',\n",
       " 706: 'Lewelling Wight Vineyard Cabernet Sauvignon 2008',\n",
       " 707: 'Lewelling Wight Vineyard Cabernet Sauvignon 2007',\n",
       " 708: 'Lewelling Wight Vineyard Cabernet Sauvignon 2010',\n",
       " 709: \"Lewis Cellars Alec's Blend Red 2002\",\n",
       " 710: \"Lewis Cellars Alec's Blend Red 2003\",\n",
       " 711: \"Lewis Cellars Alec's Blend Red 2007\",\n",
       " 712: \"Lewis Cellars Alec's Blend Red 2009\",\n",
       " 713: \"Lewis Cellars Alec's Blend Red 2005\",\n",
       " 714: \"Lewis Cellars Alec's Blend Red 2010\",\n",
       " 715: \"Lewis Cellars Alec's Blend Red 2014\",\n",
       " 716: \"Lewis Cellars Alec's Blend Red 2013\",\n",
       " 717: \"Lewis Cellars Alec's Blend Red 2017\",\n",
       " 718: 'Lewis Cellars Barcaglia Lane Chardonnay 2006',\n",
       " 719: 'Lewis Cellars Barcaglia Lane Chardonnay 2008',\n",
       " 720: 'Lewis Cellars Barcaglia Lane Chardonnay 2009',\n",
       " 721: 'Lewis Cellars Barcaglia Lane Chardonnay 2015',\n",
       " 722: 'Lewis Cellars Barcaglia Lane Chardonnay 2014',\n",
       " 723: 'Lewis Cellars Barcaglia Lane Chardonnay 2017',\n",
       " 724: 'Lewis Cellars Cabernet Sauvignon 2002',\n",
       " 725: 'Lewis Cellars Cabernet Sauvignon 2004',\n",
       " 726: 'Lewis Cellars Cabernet Sauvignon 2005',\n",
       " 727: 'Lewis Cellars Cabernet Sauvignon 2012',\n",
       " 728: 'Lewis Cellars Cabernet Sauvignon 2015',\n",
       " 729: 'Lewis Cellars Cabernet Sauvignon 2014',\n",
       " 730: 'Lewis Cellars Cabernet Sauvignon 2013',\n",
       " 731: 'Lewis Cellars Cabernet Sauvignon 2017',\n",
       " 732: 'Lewis Cellars Cuvee L 2005',\n",
       " 733: 'Lewis Cellars Cuvee L 2006',\n",
       " 734: 'Lewis Cellars Cuvee L Cabernet Sauvignon 2014',\n",
       " 735: 'Lewis Cellars Cuvee L Cabernet Sauvignon 2015',\n",
       " 736: 'Lewis Cellars Hillstone Vineyard Cabernet Sauvignon 2014',\n",
       " 737: 'Lewis Cellars Hudson Vineyards Syrah 2006',\n",
       " 738: \"Lewis Cellars Mason's Cabernet Sauvignon 2003\",\n",
       " 739: \"Lewis Cellars Mason's Cabernet Sauvignon 2015\",\n",
       " 740: \"Lewis Cellars Mason's Cabernet Sauvignon 2018\",\n",
       " 741: 'Lewis Cellars Merlot 2000',\n",
       " 742: 'Lewis Cellars Napa Valley Chardonnay 2008',\n",
       " 743: 'Lewis Cellars Napa Valley Chardonnay 2015',\n",
       " 744: 'Lewis Cellars Napa Valley Chardonnay 2014',\n",
       " 745: 'Lewis Cellars Napa Valley Chardonnay 2016',\n",
       " 746: 'Lewis Cellars Napa Valley Syrah 2006',\n",
       " 747: 'Lewis Cellars Napa Valley Syrah 2007',\n",
       " 748: 'Lewis Cellars Reserve Cabernet Sauvignon (1.5 Liter Magnum) 2011',\n",
       " 749: 'Lewis Cellars Reserve Cabernet Sauvignon (1.5 Liter Magnum) 2016',\n",
       " 750: 'Lewis Cellars Reserve Cabernet Sauvignon (1.5L Magnum) 2004',\n",
       " 751: 'Lewis Cellars Reserve Cabernet Sauvignon 1995',\n",
       " 752: 'Lewis Cellars Reserve Cabernet Sauvignon 2000',\n",
       " 753: 'Lewis Cellars Reserve Cabernet Sauvignon 2005',\n",
       " 754: 'Lewis Cellars Reserve Cabernet Sauvignon 2006',\n",
       " 755: 'Lewis Cellars Reserve Cabernet Sauvignon 2007',\n",
       " 756: 'Lewis Cellars Reserve Cabernet Sauvignon 2008',\n",
       " 757: 'Lewis Cellars Reserve Cabernet Sauvignon 2009',\n",
       " 758: 'Lewis Cellars Reserve Cabernet Sauvignon 2010',\n",
       " 759: 'Lewis Cellars Reserve Cabernet Sauvignon 2011',\n",
       " 760: 'Lewis Cellars Reserve Cabernet Sauvignon 2015',\n",
       " 761: 'Lewis Cellars Reserve Cabernet Sauvignon 2014',\n",
       " 762: 'Lewis Cellars Reserve Cabernet Sauvignon 2016',\n",
       " 763: 'Lewis Cellars Reserve Cabernet Sauvignon (scuffed labels) 2012',\n",
       " 764: 'Lewis Cellars Reserve Chardonnay 2008',\n",
       " 765: 'Lewis Cellars Reserve Chardonnay 2015',\n",
       " 766: 'Lewis Cellars Reserve Chardonnay 2018',\n",
       " 767: 'Lewis Cellars Reserve Chardonnay 2017',\n",
       " 768: 'Lewis Cellars Reserve Merlot 1995',\n",
       " 769: 'Lewis Cellars Sauvignon Blanc 2016',\n",
       " 770: 'Lewis Cellars Sauvignon Blanc 2018',\n",
       " 771: 'Lewis Cellars Sonoma Chardonnay 2014',\n",
       " 772: 'Lewis Cellars Sonoma Chardonnay 2015',\n",
       " 773: 'Lewis Cellars Sonoma Chardonnay 2017',\n",
       " 774: 'Lewis Cellars Sonoma Valley Chardonnay 2008',\n",
       " 775: \"Lewis Cellars Syrah Ethan's Blend 2005\",\n",
       " 776: \"Lewis Cellars Syrah Ethan's Blend 2014\",\n",
       " 777: \"Lewis Cellars Syrah Ethan's Blend 2009\",\n",
       " 778: 'Lexington Apex Red 2011',\n",
       " 779: 'Lexington Gist Ranch Cabernet Sauvignon 2011'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict_data = df.to_dict()\n",
    "# You'll get several keys, one for each column in the dataframe. You can access the values of a column by using the column name as a key. You'll also\n",
    "# get the index of each row as a key. You can access the values of a row by using the index as a key.\n",
    "\n",
    "dict_data['name'] # get the values of the 'name' column\n",
    "# sample output:\n",
    "# {0: 'Laurenz V Charming Gruner Veltliner 2013',\n",
    "# 1: 'Laurenz V Charming Gruner Veltliner 2014', ...}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Laurenz V Charming Gruner Veltliner 2013 90.0 Kamptal, Austria\n"
     ]
    }
   ],
   "source": [
    "# if you want to get the values of a row, you can use the index of the row as a key, but you have to use it for every column you need. For example:\n",
    "print(dict_data['name'][0], # get the value of the 'name' column for the row with index 0\n",
    "dict_data['rating'][0], # get the value of the 'rating' column for the row with index 0\n",
    "dict_data['region'][0], # get the value of the 'region' column for the row with index 0\n",
    ")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "#trying to get the highest-rated red wines\n",
    "import pandas as pd\n",
    "df = pd.read_csv(\"sample_data/wine-ratings-small.csv\", index_col=0)\n",
    "topred_wines = []\n",
    "for wine in wines:\n",
    "    if 'Red Wine' in wine['variety'] and ('95.0'or'96.0'or'97.0'or'98.0'or'99.0'or'100.0') in wine['rating']:\n",
    "        topred_wines.append(wine)\n",
    "\n",
    "topred_wines\n",
    "\n",
    "import json\n",
    "\n",
    "# Serializing json\n",
    "json_object = json.dumps(topred_wines)\n",
    "\n",
    "# Writing to sample.json\n",
    "with open(\"topredwines.json\", \"w\") as outfile:\n",
    "\toutfile.write(json_object)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}