練習 – Wine_dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>country</th>\n",
       "      <th>description</th>\n",
       "      <th>designation</th>\n",
       "      <th>points</th>\n",
       "      <th>price</th>\n",
       "      <th>province</th>\n",
       "      <th>region_1</th>\n",
       "      <th>region_2</th>\n",
       "      <th>variety</th>\n",
       "      <th>winery</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>US</td>\n",
       "      <td>This tremendous 100% varietal wine hails from ...</td>\n",
       "      <td>Martha's Vineyard</td>\n",
       "      <td>96</td>\n",
       "      <td>235.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Heitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Ripe aromas of fig, blackberry and cassis are ...</td>\n",
       "      <td>Carodorum Selección Especial Reserva</td>\n",
       "      <td>96</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Bodega Carmen Rodríguez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>US</td>\n",
       "      <td>Mac Watson honors the memory of a wine once ma...</td>\n",
       "      <td>Special Selected Late Harvest</td>\n",
       "      <td>96</td>\n",
       "      <td>90.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Knights Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Sauvignon Blanc</td>\n",
       "      <td>Macauley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>US</td>\n",
       "      <td>This spent 20 months in 30% new French oak, an...</td>\n",
       "      <td>Reserve</td>\n",
       "      <td>96</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Ponzi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>France</td>\n",
       "      <td>This is the top wine from La Bégude, named aft...</td>\n",
       "      <td>La Brûlade</td>\n",
       "      <td>95</td>\n",
       "      <td>66.0</td>\n",
       "      <td>Provence</td>\n",
       "      <td>Bandol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Provence red blend</td>\n",
       "      <td>Domaine de la Bégude</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Deep, dense and pure from the opening bell, th...</td>\n",
       "      <td>Numanthia</td>\n",
       "      <td>95</td>\n",
       "      <td>73.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Numanthia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Slightly gritty black-fruit aromas include a s...</td>\n",
       "      <td>San Román</td>\n",
       "      <td>95</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Maurodos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Lush cedary black-fruit aromas are luxe and of...</td>\n",
       "      <td>Carodorum Único Crianza</td>\n",
       "      <td>95</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Bodega Carmen Rodríguez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>US</td>\n",
       "      <td>This re-named vineyard was formerly bottled as...</td>\n",
       "      <td>Silice</td>\n",
       "      <td>95</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Chehalem Mountains</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bergström</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>US</td>\n",
       "      <td>The producer sources from two blocks of the vi...</td>\n",
       "      <td>Gap's Crown Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Blue Farm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Elegance, complexity and structure come togeth...</td>\n",
       "      <td>Ronco della Chiesa</td>\n",
       "      <td>95</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Northeastern Italy</td>\n",
       "      <td>Collio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Friulano</td>\n",
       "      <td>Borgo del Tiglio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>US</td>\n",
       "      <td>From 18-year-old vines, this supple well-balan...</td>\n",
       "      <td>Estate Vineyard Wadensvil Block</td>\n",
       "      <td>95</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Ribbon Ridge</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Patricia Green Cellars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>US</td>\n",
       "      <td>A standout even in this terrific lineup of 201...</td>\n",
       "      <td>Weber Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Dundee Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Patricia Green Cellars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>France</td>\n",
       "      <td>This wine is in peak condition. The tannins an...</td>\n",
       "      <td>Château Montus Prestige</td>\n",
       "      <td>95</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Madiran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tannat</td>\n",
       "      <td>Vignobles Brumont</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>US</td>\n",
       "      <td>With its sophisticated mix of mineral, acid an...</td>\n",
       "      <td>Grace Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>185.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Dundee Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Domaine Serene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>US</td>\n",
       "      <td>First made in 2006, this succulent luscious Ch...</td>\n",
       "      <td>Sigrid</td>\n",
       "      <td>95</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Bergström</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>US</td>\n",
       "      <td>This blockbuster, powerhouse of a wine suggest...</td>\n",
       "      <td>Rainin Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>325.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Diamond Mountain District</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Hall</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Nicely oaked blackberry, licorice, vanilla and...</td>\n",
       "      <td>6 Años Reserva Premium</td>\n",
       "      <td>95</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Ribera del Duero</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tempranillo</td>\n",
       "      <td>Valduero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>France</td>\n",
       "      <td>Coming from a seven-acre vineyard named after ...</td>\n",
       "      <td>Le Pigeonnier</td>\n",
       "      <td>95</td>\n",
       "      <td>290.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Cahors</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malbec</td>\n",
       "      <td>Château Lagrézette</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>US</td>\n",
       "      <td>This fresh and lively medium-bodied wine is be...</td>\n",
       "      <td>Gap's Crown Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>75.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Gary Farrell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>US</td>\n",
       "      <td>Heitz has made this stellar rosé from the rare...</td>\n",
       "      <td>Grignolino</td>\n",
       "      <td>95</td>\n",
       "      <td>24.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Rosé</td>\n",
       "      <td>Heitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Alluring, complex and powerful aromas of grill...</td>\n",
       "      <td>Prado Enea Gran Reserva</td>\n",
       "      <td>95</td>\n",
       "      <td>79.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Rioja</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tempranillo Blend</td>\n",
       "      <td>Muga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Tarry blackberry and cheesy oak aromas are app...</td>\n",
       "      <td>Termanthia</td>\n",
       "      <td>95</td>\n",
       "      <td>220.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Numanthia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>US</td>\n",
       "      <td>The apogee of this ambitious winery's white wi...</td>\n",
       "      <td>Giallo Solare</td>\n",
       "      <td>95</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Edna Valley</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Center of Effort</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>US</td>\n",
       "      <td>San Jose-based producer Adam Comartin heads 1,...</td>\n",
       "      <td>R-Bar-R Ranch</td>\n",
       "      <td>95</td>\n",
       "      <td>45.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Santa Cruz Mountains</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Comartin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>New Zealand</td>\n",
       "      <td>Yields were down in 2015, but intensity is up,...</td>\n",
       "      <td>Maté's Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Kumeu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Kumeu River</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>US</td>\n",
       "      <td>Bergström has made a Shea designate since 2003...</td>\n",
       "      <td>Shea Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bergström</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>US</td>\n",
       "      <td>Focused and dense, this intense wine captures ...</td>\n",
       "      <td>Abetina</td>\n",
       "      <td>94</td>\n",
       "      <td>105.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Ponzi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>US</td>\n",
       "      <td>Cranberry, baked rhubarb, anise and crushed sl...</td>\n",
       "      <td>Garys' Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Santa Lucia Highlands</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Roar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>US</td>\n",
       "      <td>This standout Rocks District wine brings earth...</td>\n",
       "      <td>The Funk Estate</td>\n",
       "      <td>94</td>\n",
       "      <td>60.0</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Walla Walla Valley (WA)</td>\n",
       "      <td>Columbia Valley</td>\n",
       "      <td>Syrah</td>\n",
       "      <td>Saviah</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>US</td>\n",
       "      <td>Sweetened tannins highlight a depth of chocola...</td>\n",
       "      <td>District Collection</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>California</td>\n",
       "      <td>St. Helena</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Raymond</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>US</td>\n",
       "      <td>This wine draws from a handful of tremendous v...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>45.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Red Car</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This offers aromas of red rose, wild berry, da...</td>\n",
       "      <td>Bussia Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Silvano Bolmida</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>US</td>\n",
       "      <td>Massively fruity, this is an apple/pear bonanz...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Gris</td>\n",
       "      <td>Trinity Vineyards</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>It is the ripe dark Alicante Bouschet that dom...</td>\n",
       "      <td>Premium</td>\n",
       "      <td>91</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Alentejo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Portuguese Red</td>\n",
       "      <td>Adega Cooperativa de Borba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>US</td>\n",
       "      <td>An elegant blend from different estate vineyar...</td>\n",
       "      <td>Premier Cuvée</td>\n",
       "      <td>91</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Archery Summit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>France</td>\n",
       "      <td>This wine is bone-dry, although with some age ...</td>\n",
       "      <td>Le Nombre d'Or Brut Nature</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Champagne</td>\n",
       "      <td>Champagne</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Aubry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>US</td>\n",
       "      <td>Given four months in concrete egg, this is an ...</td>\n",
       "      <td>Juliana Vineyard</td>\n",
       "      <td>91</td>\n",
       "      <td>38.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Sauvignon Blanc</td>\n",
       "      <td>B Cellars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>US</td>\n",
       "      <td>This wine over-delivers in quality for the pri...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>28.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>B Side</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Underbrush, smoke, mocha and dark fruit aromas...</td>\n",
       "      <td>Boscato</td>\n",
       "      <td>91</td>\n",
       "      <td>75.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Bel Colle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>US</td>\n",
       "      <td>Generous black-cherry fruit anchors this barre...</td>\n",
       "      <td>Aeolian</td>\n",
       "      <td>91</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Eola-Amity Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bethel Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Israel</td>\n",
       "      <td>Dark red violet in color, this wine has aromas...</td>\n",
       "      <td>Reserve</td>\n",
       "      <td>91</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Upper Galilee</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Binyamina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Berry, baking spice, dried iris, mint and a hi...</td>\n",
       "      <td>Palliano Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Roero</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Ceste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This hearty red opens with aromas of leafy und...</td>\n",
       "      <td>del Comune di Serralunga d'Alba</td>\n",
       "      <td>91</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina Cucco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Enticing aromas of woodland berry, crushed ros...</td>\n",
       "      <td>Bricco Luciani</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina del Monastero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of French oak, coconut, vanilla and spi...</td>\n",
       "      <td>Bricco Gattera</td>\n",
       "      <td>91</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cordero di Montezemolo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>France</td>\n",
       "      <td>This delicious, refreshing wine is textured, t...</td>\n",
       "      <td>Montmains Premier Cru</td>\n",
       "      <td>91</td>\n",
       "      <td>45.0</td>\n",
       "      <td>Burgundy</td>\n",
       "      <td>Chablis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Domaine Gérard Duplessis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>US</td>\n",
       "      <td>From a multiplicity of vineyards, this wine wo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>22.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Eagle Glen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>US</td>\n",
       "      <td>The first Pinot Noir release from this produce...</td>\n",
       "      <td>Bacigalupi Vineyard</td>\n",
       "      <td>91</td>\n",
       "      <td>65.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Russian River Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Eleven Eleven</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>US</td>\n",
       "      <td>A red Meritage driven by 73% Cabernet Sauvigno...</td>\n",
       "      <td>Magnificat</td>\n",
       "      <td>91</td>\n",
       "      <td>50.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Meritage</td>\n",
       "      <td>Franciscan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>US</td>\n",
       "      <td>Bright, light oak shadings dress up this mediu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>California</td>\n",
       "      <td>California</td>\n",
       "      <td>California Other</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Belle Ambiance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>The local Baga grape, better known for produci...</td>\n",
       "      <td>Marquês de Marialva Rosé Bruto</td>\n",
       "      <td>86</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Beira Atlantico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Baga</td>\n",
       "      <td>Adega de Cantanhede</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of white spring flower, orchard fruit a...</td>\n",
       "      <td>Nature</td>\n",
       "      <td>86</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Veneto</td>\n",
       "      <td>Prosecco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Glera</td>\n",
       "      <td>De Stefani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>US</td>\n",
       "      <td>A smoky scent and earthy, crisp-apple flavors ...</td>\n",
       "      <td>Small Lot Blend</td>\n",
       "      <td>86</td>\n",
       "      <td>13.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Mendocino County</td>\n",
       "      <td>Mendocino/Lake Counties</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Parducci</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>This family-owned estate has produced an immed...</td>\n",
       "      <td>Muros de Vinha</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Douro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Portuguese Red</td>\n",
       "      <td>Quinta do Portal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>France</td>\n",
       "      <td>This is a smooth, soft wine that is full of bl...</td>\n",
       "      <td>Château Beauvillain-Monpezat</td>\n",
       "      <td>86</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Cahors</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malbec-Merlot</td>\n",
       "      <td>Rigal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>US</td>\n",
       "      <td>This is an easygoing wine that's neither too o...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>18.0</td>\n",
       "      <td>California</td>\n",
       "      <td>California</td>\n",
       "      <td>California Other</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>The Naked Grape</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>US</td>\n",
       "      <td>Blended with small amounts of Merlot, Cabernet...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>36.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Tin Barn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>France</td>\n",
       "      <td>Closer to Bordeaux than is Cahors, this is Mal...</td>\n",
       "      <td>Pigmentum</td>\n",
       "      <td>86</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Buzet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Merlot-Malbec</td>\n",
       "      <td>Georges Vigouroux</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>France</td>\n",
       "      <td>This is a blend of 60% Ugni Blanc and 40% Colo...</td>\n",
       "      <td>Pigmentum</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Côtes de Gascogne</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ugni Blanc-Colombard</td>\n",
       "      <td>Georges Vigouroux</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        country                                        description  \\\n",
       "0            US  This tremendous 100% varietal wine hails from ...   \n",
       "1         Spain  Ripe aromas of fig, blackberry and cassis are ...   \n",
       "2            US  Mac Watson honors the memory of a wine once ma...   \n",
       "3            US  This spent 20 months in 30% new French oak, an...   \n",
       "4        France  This is the top wine from La Bégude, named aft...   \n",
       "5         Spain  Deep, dense and pure from the opening bell, th...   \n",
       "6         Spain  Slightly gritty black-fruit aromas include a s...   \n",
       "7         Spain  Lush cedary black-fruit aromas are luxe and of...   \n",
       "8            US  This re-named vineyard was formerly bottled as...   \n",
       "9            US  The producer sources from two blocks of the vi...   \n",
       "10        Italy  Elegance, complexity and structure come togeth...   \n",
       "11           US  From 18-year-old vines, this supple well-balan...   \n",
       "12           US  A standout even in this terrific lineup of 201...   \n",
       "13       France  This wine is in peak condition. The tannins an...   \n",
       "14           US  With its sophisticated mix of mineral, acid an...   \n",
       "15           US  First made in 2006, this succulent luscious Ch...   \n",
       "16           US  This blockbuster, powerhouse of a wine suggest...   \n",
       "17        Spain  Nicely oaked blackberry, licorice, vanilla and...   \n",
       "18       France  Coming from a seven-acre vineyard named after ...   \n",
       "19           US  This fresh and lively medium-bodied wine is be...   \n",
       "20           US  Heitz has made this stellar rosé from the rare...   \n",
       "21        Spain  Alluring, complex and powerful aromas of grill...   \n",
       "22        Spain  Tarry blackberry and cheesy oak aromas are app...   \n",
       "23           US  The apogee of this ambitious winery's white wi...   \n",
       "24           US  San Jose-based producer Adam Comartin heads 1,...   \n",
       "25  New Zealand  Yields were down in 2015, but intensity is up,...   \n",
       "26           US  Bergström has made a Shea designate since 2003...   \n",
       "27           US  Focused and dense, this intense wine captures ...   \n",
       "28           US  Cranberry, baked rhubarb, anise and crushed sl...   \n",
       "29           US  This standout Rocks District wine brings earth...   \n",
       "..          ...                                                ...   \n",
       "70           US  Sweetened tannins highlight a depth of chocola...   \n",
       "71           US  This wine draws from a handful of tremendous v...   \n",
       "72        Italy  This offers aromas of red rose, wild berry, da...   \n",
       "73           US  Massively fruity, this is an apple/pear bonanz...   \n",
       "74     Portugal  It is the ripe dark Alicante Bouschet that dom...   \n",
       "75           US  An elegant blend from different estate vineyar...   \n",
       "76       France  This wine is bone-dry, although with some age ...   \n",
       "77           US  Given four months in concrete egg, this is an ...   \n",
       "78           US  This wine over-delivers in quality for the pri...   \n",
       "79        Italy  Underbrush, smoke, mocha and dark fruit aromas...   \n",
       "80           US  Generous black-cherry fruit anchors this barre...   \n",
       "81       Israel  Dark red violet in color, this wine has aromas...   \n",
       "82        Italy  Berry, baking spice, dried iris, mint and a hi...   \n",
       "83        Italy  This hearty red opens with aromas of leafy und...   \n",
       "84        Italy  Enticing aromas of woodland berry, crushed ros...   \n",
       "85        Italy  Aromas of French oak, coconut, vanilla and spi...   \n",
       "86       France  This delicious, refreshing wine is textured, t...   \n",
       "87           US  From a multiplicity of vineyards, this wine wo...   \n",
       "88           US  The first Pinot Noir release from this produce...   \n",
       "89           US  A red Meritage driven by 73% Cabernet Sauvigno...   \n",
       "90           US  Bright, light oak shadings dress up this mediu...   \n",
       "91     Portugal  The local Baga grape, better known for produci...   \n",
       "92        Italy  Aromas of white spring flower, orchard fruit a...   \n",
       "93           US  A smoky scent and earthy, crisp-apple flavors ...   \n",
       "94     Portugal  This family-owned estate has produced an immed...   \n",
       "95       France  This is a smooth, soft wine that is full of bl...   \n",
       "96           US  This is an easygoing wine that's neither too o...   \n",
       "97           US  Blended with small amounts of Merlot, Cabernet...   \n",
       "98       France  Closer to Bordeaux than is Cahors, this is Mal...   \n",
       "99       France  This is a blend of 60% Ugni Blanc and 40% Colo...   \n",
       "\n",
       "                             designation  points  price            province  \\\n",
       "0                      Martha's Vineyard      96  235.0          California   \n",
       "1   Carodorum Selección Especial Reserva      96  110.0      Northern Spain   \n",
       "2          Special Selected Late Harvest      96   90.0          California   \n",
       "3                                Reserve      96   65.0              Oregon   \n",
       "4                             La Brûlade      95   66.0            Provence   \n",
       "5                              Numanthia      95   73.0      Northern Spain   \n",
       "6                              San Román      95   65.0      Northern Spain   \n",
       "7                Carodorum Único Crianza      95  110.0      Northern Spain   \n",
       "8                                 Silice      95   65.0              Oregon   \n",
       "9                   Gap's Crown Vineyard      95   60.0          California   \n",
       "10                    Ronco della Chiesa      95   80.0  Northeastern Italy   \n",
       "11       Estate Vineyard Wadensvil Block      95   48.0              Oregon   \n",
       "12                        Weber Vineyard      95   48.0              Oregon   \n",
       "13               Château Montus Prestige      95   90.0    Southwest France   \n",
       "14                        Grace Vineyard      95  185.0              Oregon   \n",
       "15                                Sigrid      95   90.0              Oregon   \n",
       "16                       Rainin Vineyard      95  325.0          California   \n",
       "17                6 Años Reserva Premium      95   80.0      Northern Spain   \n",
       "18                         Le Pigeonnier      95  290.0    Southwest France   \n",
       "19                  Gap's Crown Vineyard      95   75.0          California   \n",
       "20                            Grignolino      95   24.0          California   \n",
       "21               Prado Enea Gran Reserva      95   79.0      Northern Spain   \n",
       "22                            Termanthia      95  220.0      Northern Spain   \n",
       "23                         Giallo Solare      95   60.0          California   \n",
       "24                         R-Bar-R Ranch      95   45.0          California   \n",
       "25                       Maté's Vineyard      94   57.0               Kumeu   \n",
       "26                         Shea Vineyard      94   62.0              Oregon   \n",
       "27                               Abetina      94  105.0              Oregon   \n",
       "28                       Garys' Vineyard      94   60.0          California   \n",
       "29                       The Funk Estate      94   60.0          Washington   \n",
       "..                                   ...     ...    ...                 ...   \n",
       "70                   District Collection      91   85.0          California   \n",
       "71                                   NaN      91   45.0          California   \n",
       "72                        Bussia Riserva      91    NaN            Piedmont   \n",
       "73                                   NaN      91   19.0              Oregon   \n",
       "74                               Premium      91   15.0            Alentejo   \n",
       "75                         Premier Cuvée      91   54.0              Oregon   \n",
       "76            Le Nombre d'Or Brut Nature      91   85.0           Champagne   \n",
       "77                      Juliana Vineyard      91   38.0          California   \n",
       "78                                   NaN      91   28.0          California   \n",
       "79                               Boscato      91   75.0            Piedmont   \n",
       "80                               Aeolian      91   42.0              Oregon   \n",
       "81                               Reserve      91   25.0       Upper Galilee   \n",
       "82                      Palliano Riserva      91    NaN            Piedmont   \n",
       "83       del Comune di Serralunga d'Alba      91   59.0            Piedmont   \n",
       "84                        Bricco Luciani      91   85.0            Piedmont   \n",
       "85                        Bricco Gattera      91   80.0            Piedmont   \n",
       "86                 Montmains Premier Cru      91   45.0            Burgundy   \n",
       "87                                   NaN      91   22.0          California   \n",
       "88                   Bacigalupi Vineyard      91   65.0          California   \n",
       "89                            Magnificat      91   50.0          California   \n",
       "90                                   NaN      86   10.0          California   \n",
       "91        Marquês de Marialva Rosé Bruto      86   12.0     Beira Atlantico   \n",
       "92                                Nature      86   22.0              Veneto   \n",
       "93                       Small Lot Blend      86   13.0          California   \n",
       "94                        Muros de Vinha      86   10.0               Douro   \n",
       "95          Château Beauvillain-Monpezat      86   14.0    Southwest France   \n",
       "96                                   NaN      86   18.0          California   \n",
       "97                                   NaN      86   36.0          California   \n",
       "98                             Pigmentum      86   15.0    Southwest France   \n",
       "99                             Pigmentum      86   10.0    Southwest France   \n",
       "\n",
       "                     region_1                 region_2               variety  \\\n",
       "0                 Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "1                        Toro                      NaN         Tinta de Toro   \n",
       "2              Knights Valley                   Sonoma       Sauvignon Blanc   \n",
       "3           Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "4                      Bandol                      NaN    Provence red blend   \n",
       "5                        Toro                      NaN         Tinta de Toro   \n",
       "6                        Toro                      NaN         Tinta de Toro   \n",
       "7                        Toro                      NaN         Tinta de Toro   \n",
       "8          Chehalem Mountains        Willamette Valley            Pinot Noir   \n",
       "9                Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "10                     Collio                      NaN              Friulano   \n",
       "11               Ribbon Ridge        Willamette Valley            Pinot Noir   \n",
       "12               Dundee Hills        Willamette Valley            Pinot Noir   \n",
       "13                    Madiran                      NaN                Tannat   \n",
       "14               Dundee Hills        Willamette Valley            Pinot Noir   \n",
       "15          Willamette Valley        Willamette Valley            Chardonnay   \n",
       "16  Diamond Mountain District                     Napa    Cabernet Sauvignon   \n",
       "17           Ribera del Duero                      NaN           Tempranillo   \n",
       "18                     Cahors                      NaN                Malbec   \n",
       "19               Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "20                Napa Valley                     Napa                  Rosé   \n",
       "21                      Rioja                      NaN     Tempranillo Blend   \n",
       "22                       Toro                      NaN         Tinta de Toro   \n",
       "23                Edna Valley            Central Coast            Chardonnay   \n",
       "24       Santa Cruz Mountains            Central Coast            Pinot Noir   \n",
       "25                        NaN                      NaN            Chardonnay   \n",
       "26          Willamette Valley                      NaN            Pinot Noir   \n",
       "27          Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "28      Santa Lucia Highlands            Central Coast            Pinot Noir   \n",
       "29    Walla Walla Valley (WA)          Columbia Valley                 Syrah   \n",
       "..                        ...                      ...                   ...   \n",
       "70                 St. Helena                     Napa    Cabernet Sauvignon   \n",
       "71               Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "72                     Barolo                      NaN              Nebbiolo   \n",
       "73          Willamette Valley        Willamette Valley            Pinot Gris   \n",
       "74                        NaN                      NaN        Portuguese Red   \n",
       "75          Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "76                  Champagne                      NaN            Chardonnay   \n",
       "77                Napa Valley                     Napa       Sauvignon Blanc   \n",
       "78                Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "79                     Barolo                      NaN              Nebbiolo   \n",
       "80           Eola-Amity Hills        Willamette Valley            Pinot Noir   \n",
       "81                        NaN                      NaN    Cabernet Sauvignon   \n",
       "82                      Roero                      NaN              Nebbiolo   \n",
       "83                     Barolo                      NaN              Nebbiolo   \n",
       "84                     Barolo                      NaN              Nebbiolo   \n",
       "85                     Barolo                      NaN              Nebbiolo   \n",
       "86                    Chablis                      NaN            Chardonnay   \n",
       "87                Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "88       Russian River Valley                   Sonoma            Pinot Noir   \n",
       "89                Napa Valley                     Napa              Meritage   \n",
       "90                 California         California Other    Cabernet Sauvignon   \n",
       "91                        NaN                      NaN                  Baga   \n",
       "92                   Prosecco                      NaN                 Glera   \n",
       "93           Mendocino County  Mendocino/Lake Counties            Chardonnay   \n",
       "94                        NaN                      NaN        Portuguese Red   \n",
       "95                     Cahors                      NaN         Malbec-Merlot   \n",
       "96                 California         California Other            Chardonnay   \n",
       "97              Sonoma Valley                   Sonoma    Cabernet Sauvignon   \n",
       "98                      Buzet                      NaN         Merlot-Malbec   \n",
       "99          Côtes de Gascogne                      NaN  Ugni Blanc-Colombard   \n",
       "\n",
       "                        winery  \n",
       "0                        Heitz  \n",
       "1      Bodega Carmen Rodríguez  \n",
       "2                     Macauley  \n",
       "3                        Ponzi  \n",
       "4         Domaine de la Bégude  \n",
       "5                    Numanthia  \n",
       "6                     Maurodos  \n",
       "7      Bodega Carmen Rodríguez  \n",
       "8                    Bergström  \n",
       "9                    Blue Farm  \n",
       "10            Borgo del Tiglio  \n",
       "11      Patricia Green Cellars  \n",
       "12      Patricia Green Cellars  \n",
       "13           Vignobles Brumont  \n",
       "14              Domaine Serene  \n",
       "15                   Bergström  \n",
       "16                        Hall  \n",
       "17                    Valduero  \n",
       "18          Château Lagrézette  \n",
       "19                Gary Farrell  \n",
       "20                       Heitz  \n",
       "21                        Muga  \n",
       "22                   Numanthia  \n",
       "23            Center of Effort  \n",
       "24                    Comartin  \n",
       "25                 Kumeu River  \n",
       "26                   Bergström  \n",
       "27                       Ponzi  \n",
       "28                        Roar  \n",
       "29                      Saviah  \n",
       "..                         ...  \n",
       "70                     Raymond  \n",
       "71                     Red Car  \n",
       "72             Silvano Bolmida  \n",
       "73           Trinity Vineyards  \n",
       "74  Adega Cooperativa de Borba  \n",
       "75              Archery Summit  \n",
       "76                       Aubry  \n",
       "77                   B Cellars  \n",
       "78                      B Side  \n",
       "79                   Bel Colle  \n",
       "80              Bethel Heights  \n",
       "81                   Binyamina  \n",
       "82                       Ceste  \n",
       "83               Cascina Cucco  \n",
       "84       Cascina del Monastero  \n",
       "85      Cordero di Montezemolo  \n",
       "86    Domaine Gérard Duplessis  \n",
       "87                  Eagle Glen  \n",
       "88               Eleven Eleven  \n",
       "89                  Franciscan  \n",
       "90              Belle Ambiance  \n",
       "91         Adega de Cantanhede  \n",
       "92                  De Stefani  \n",
       "93                    Parducci  \n",
       "94            Quinta do Portal  \n",
       "95                       Rigal  \n",
       "96             The Naked Grape  \n",
       "97                    Tin Barn  \n",
       "98           Georges Vigouroux  \n",
       "99           Georges Vigouroux  \n",
       "\n",
       "[100 rows x 10 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wine_dataset = pd.read_csv(\"wines.csv\")\n",
    "wine_dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. 讀取wines.csv，查看其概觀內容( hint: head )"
   ]
  },
  {
   "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>country</th>\n",
       "      <th>description</th>\n",
       "      <th>designation</th>\n",
       "      <th>points</th>\n",
       "      <th>price</th>\n",
       "      <th>province</th>\n",
       "      <th>region_1</th>\n",
       "      <th>region_2</th>\n",
       "      <th>variety</th>\n",
       "      <th>winery</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>US</td>\n",
       "      <td>This tremendous 100% varietal wine hails from ...</td>\n",
       "      <td>Martha's Vineyard</td>\n",
       "      <td>96</td>\n",
       "      <td>235.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Heitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Ripe aromas of fig, blackberry and cassis are ...</td>\n",
       "      <td>Carodorum Selección Especial Reserva</td>\n",
       "      <td>96</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Bodega Carmen Rodríguez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>US</td>\n",
       "      <td>Mac Watson honors the memory of a wine once ma...</td>\n",
       "      <td>Special Selected Late Harvest</td>\n",
       "      <td>96</td>\n",
       "      <td>90.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Knights Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Sauvignon Blanc</td>\n",
       "      <td>Macauley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>US</td>\n",
       "      <td>This spent 20 months in 30% new French oak, an...</td>\n",
       "      <td>Reserve</td>\n",
       "      <td>96</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Ponzi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>France</td>\n",
       "      <td>This is the top wine from La Bégude, named aft...</td>\n",
       "      <td>La Brûlade</td>\n",
       "      <td>95</td>\n",
       "      <td>66.0</td>\n",
       "      <td>Provence</td>\n",
       "      <td>Bandol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Provence red blend</td>\n",
       "      <td>Domaine de la Bégude</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  country                                        description  \\\n",
       "0      US  This tremendous 100% varietal wine hails from ...   \n",
       "1   Spain  Ripe aromas of fig, blackberry and cassis are ...   \n",
       "2      US  Mac Watson honors the memory of a wine once ma...   \n",
       "3      US  This spent 20 months in 30% new French oak, an...   \n",
       "4  France  This is the top wine from La Bégude, named aft...   \n",
       "\n",
       "                            designation  points  price        province  \\\n",
       "0                     Martha's Vineyard      96  235.0      California   \n",
       "1  Carodorum Selección Especial Reserva      96  110.0  Northern Spain   \n",
       "2         Special Selected Late Harvest      96   90.0      California   \n",
       "3                               Reserve      96   65.0          Oregon   \n",
       "4                            La Brûlade      95   66.0        Provence   \n",
       "\n",
       "            region_1           region_2             variety  \\\n",
       "0        Napa Valley               Napa  Cabernet Sauvignon   \n",
       "1               Toro                NaN       Tinta de Toro   \n",
       "2     Knights Valley             Sonoma     Sauvignon Blanc   \n",
       "3  Willamette Valley  Willamette Valley          Pinot Noir   \n",
       "4             Bandol                NaN  Provence red blend   \n",
       "\n",
       "                    winery  \n",
       "0                    Heitz  \n",
       "1  Bodega Carmen Rodríguez  \n",
       "2                 Macauley  \n",
       "3                    Ponzi  \n",
       "4     Domaine de la Bégude  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 假設我想看前五筆資料\n",
    "wine_dataset.head(n=5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2.找出points欄位之標準差、平均"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "statistic = wine_dataset.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(statistic)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    100.000000\n",
       "mean      91.390000\n",
       "std        2.744673\n",
       "min       86.000000\n",
       "25%       90.000000\n",
       "50%       91.000000\n",
       "75%       94.250000\n",
       "max       96.000000\n",
       "Name: points, dtype: float64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "statistic[:]['points']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "std:  2.7446734456456428\n",
      "mean:  91.39\n"
     ]
    }
   ],
   "source": [
    "print (\"std: \",statistic[:]['points'][2])\n",
    "print (\"mean: \",statistic[:]['points'][1])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.找出country為Italy的所有row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>country</th>\n",
       "      <th>description</th>\n",
       "      <th>designation</th>\n",
       "      <th>points</th>\n",
       "      <th>price</th>\n",
       "      <th>province</th>\n",
       "      <th>region_1</th>\n",
       "      <th>region_2</th>\n",
       "      <th>variety</th>\n",
       "      <th>winery</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Elegance, complexity and structure come togeth...</td>\n",
       "      <td>Ronco della Chiesa</td>\n",
       "      <td>95</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Northeastern Italy</td>\n",
       "      <td>Collio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Friulano</td>\n",
       "      <td>Borgo del Tiglio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Underbrush, scorched earth, menthol and plum s...</td>\n",
       "      <td>Vigna Piaggia</td>\n",
       "      <td>90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Brunello di Montalcino</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Abbadia Ardenga</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Forest floor, tilled soil, mature berry and a ...</td>\n",
       "      <td>Riserva</td>\n",
       "      <td>90</td>\n",
       "      <td>135.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Brunello di Montalcino</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Carillon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of forest floor, violet, red berry and ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Vino Nobile di Montepulciano</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Avignonesi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This has a charming nose that boasts rose, vio...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Chianti Classico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Casina di Cornia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This bright, savory wine delivers aromas and f...</td>\n",
       "      <td>Riserva</td>\n",
       "      <td>90</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Chianti Classico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red Blend</td>\n",
       "      <td>Castello di Monterinaldi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of dark-skinned berry, rose and wild he...</td>\n",
       "      <td>Riserva</td>\n",
       "      <td>90</td>\n",
       "      <td>39.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Chianti Classico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red Blend</td>\n",
       "      <td>Rignana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Italy</td>\n",
       "      <td>A blend of 90% Sangiovese and 10% Canaiolo, th...</td>\n",
       "      <td>Vigneto Odoardo Beccari Riserva</td>\n",
       "      <td>90</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Chianti Classico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red Blend</td>\n",
       "      <td>Vignavecchia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Sunbaked earth, ripe berry, baking spice and a...</td>\n",
       "      <td>Poggio alle Mura</td>\n",
       "      <td>90</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Brunello di Montalcino</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Banfi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Ripe dark-skinned berry, forest floor and cook...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Brunello di Montalcino</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Brunelli Martoccia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This robust red opens with aromas of espresso,...</td>\n",
       "      <td>Riserva</td>\n",
       "      <td>90</td>\n",
       "      <td>100.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Brunello di Montalcino</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sangiovese</td>\n",
       "      <td>Capanne Ricci</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This savory blend of 40% Merlot, 30% Cabernet ...</td>\n",
       "      <td>Poggio Bestiale</td>\n",
       "      <td>90</td>\n",
       "      <td>60.0</td>\n",
       "      <td>Tuscany</td>\n",
       "      <td>Maremma Toscana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Red Blend</td>\n",
       "      <td>Fattoria di Magliano</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This offers aromas of red rose, wild berry, da...</td>\n",
       "      <td>Bussia Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Silvano Bolmida</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Underbrush, smoke, mocha and dark fruit aromas...</td>\n",
       "      <td>Boscato</td>\n",
       "      <td>91</td>\n",
       "      <td>75.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Bel Colle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Berry, baking spice, dried iris, mint and a hi...</td>\n",
       "      <td>Palliano Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Roero</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Ceste</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This hearty red opens with aromas of leafy und...</td>\n",
       "      <td>del Comune di Serralunga d'Alba</td>\n",
       "      <td>91</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina Cucco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Enticing aromas of woodland berry, crushed ros...</td>\n",
       "      <td>Bricco Luciani</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina del Monastero</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of French oak, coconut, vanilla and spi...</td>\n",
       "      <td>Bricco Gattera</td>\n",
       "      <td>91</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cordero di Montezemolo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of white spring flower, orchard fruit a...</td>\n",
       "      <td>Nature</td>\n",
       "      <td>86</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Veneto</td>\n",
       "      <td>Prosecco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Glera</td>\n",
       "      <td>De Stefani</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   country                                        description  \\\n",
       "10   Italy  Elegance, complexity and structure come togeth...   \n",
       "32   Italy  Underbrush, scorched earth, menthol and plum s...   \n",
       "35   Italy  Forest floor, tilled soil, mature berry and a ...   \n",
       "37   Italy  Aromas of forest floor, violet, red berry and ...   \n",
       "38   Italy  This has a charming nose that boasts rose, vio...   \n",
       "39   Italy  This bright, savory wine delivers aromas and f...   \n",
       "43   Italy  Aromas of dark-skinned berry, rose and wild he...   \n",
       "45   Italy  A blend of 90% Sangiovese and 10% Canaiolo, th...   \n",
       "46   Italy  Sunbaked earth, ripe berry, baking spice and a...   \n",
       "48   Italy  Ripe dark-skinned berry, forest floor and cook...   \n",
       "50   Italy  This robust red opens with aromas of espresso,...   \n",
       "59   Italy  This savory blend of 40% Merlot, 30% Cabernet ...   \n",
       "72   Italy  This offers aromas of red rose, wild berry, da...   \n",
       "79   Italy  Underbrush, smoke, mocha and dark fruit aromas...   \n",
       "82   Italy  Berry, baking spice, dried iris, mint and a hi...   \n",
       "83   Italy  This hearty red opens with aromas of leafy und...   \n",
       "84   Italy  Enticing aromas of woodland berry, crushed ros...   \n",
       "85   Italy  Aromas of French oak, coconut, vanilla and spi...   \n",
       "92   Italy  Aromas of white spring flower, orchard fruit a...   \n",
       "\n",
       "                        designation  points  price            province  \\\n",
       "10               Ronco della Chiesa      95   80.0  Northeastern Italy   \n",
       "32                    Vigna Piaggia      90    NaN             Tuscany   \n",
       "35                          Riserva      90  135.0             Tuscany   \n",
       "37                              NaN      90   29.0             Tuscany   \n",
       "38                              NaN      90   23.0             Tuscany   \n",
       "39                          Riserva      90   29.0             Tuscany   \n",
       "43                          Riserva      90   39.0             Tuscany   \n",
       "45  Vigneto Odoardo Beccari Riserva      90   30.0             Tuscany   \n",
       "46                 Poggio alle Mura      90   90.0             Tuscany   \n",
       "48                              NaN      90   50.0             Tuscany   \n",
       "50                          Riserva      90  100.0             Tuscany   \n",
       "59                  Poggio Bestiale      90   60.0             Tuscany   \n",
       "72                   Bussia Riserva      91    NaN            Piedmont   \n",
       "79                          Boscato      91   75.0            Piedmont   \n",
       "82                 Palliano Riserva      91    NaN            Piedmont   \n",
       "83  del Comune di Serralunga d'Alba      91   59.0            Piedmont   \n",
       "84                   Bricco Luciani      91   85.0            Piedmont   \n",
       "85                   Bricco Gattera      91   80.0            Piedmont   \n",
       "92                           Nature      86   22.0              Veneto   \n",
       "\n",
       "                        region_1 region_2     variety  \\\n",
       "10                        Collio      NaN    Friulano   \n",
       "32        Brunello di Montalcino      NaN  Sangiovese   \n",
       "35        Brunello di Montalcino      NaN  Sangiovese   \n",
       "37  Vino Nobile di Montepulciano      NaN  Sangiovese   \n",
       "38              Chianti Classico      NaN  Sangiovese   \n",
       "39              Chianti Classico      NaN   Red Blend   \n",
       "43              Chianti Classico      NaN   Red Blend   \n",
       "45              Chianti Classico      NaN   Red Blend   \n",
       "46        Brunello di Montalcino      NaN  Sangiovese   \n",
       "48        Brunello di Montalcino      NaN  Sangiovese   \n",
       "50        Brunello di Montalcino      NaN  Sangiovese   \n",
       "59               Maremma Toscana      NaN   Red Blend   \n",
       "72                        Barolo      NaN    Nebbiolo   \n",
       "79                        Barolo      NaN    Nebbiolo   \n",
       "82                         Roero      NaN    Nebbiolo   \n",
       "83                        Barolo      NaN    Nebbiolo   \n",
       "84                        Barolo      NaN    Nebbiolo   \n",
       "85                        Barolo      NaN    Nebbiolo   \n",
       "92                      Prosecco      NaN       Glera   \n",
       "\n",
       "                      winery  \n",
       "10          Borgo del Tiglio  \n",
       "32           Abbadia Ardenga  \n",
       "35                  Carillon  \n",
       "37                Avignonesi  \n",
       "38          Casina di Cornia  \n",
       "39  Castello di Monterinaldi  \n",
       "43                   Rignana  \n",
       "45              Vignavecchia  \n",
       "46                     Banfi  \n",
       "48        Brunelli Martoccia  \n",
       "50             Capanne Ricci  \n",
       "59      Fattoria di Magliano  \n",
       "72           Silvano Bolmida  \n",
       "79                 Bel Colle  \n",
       "82                     Ceste  \n",
       "83             Cascina Cucco  \n",
       "84     Cascina del Monastero  \n",
       "85    Cordero di Montezemolo  \n",
       "92                De Stefani  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wine_dataset.loc[wine_dataset['country']=='Italy', :]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4.在df_data新增一個欄位”CP”, 其值為points / price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>country</th>\n",
       "      <th>description</th>\n",
       "      <th>designation</th>\n",
       "      <th>points</th>\n",
       "      <th>price</th>\n",
       "      <th>province</th>\n",
       "      <th>region_1</th>\n",
       "      <th>region_2</th>\n",
       "      <th>variety</th>\n",
       "      <th>winery</th>\n",
       "      <th>points/price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>US</td>\n",
       "      <td>This tremendous 100% varietal wine hails from ...</td>\n",
       "      <td>Martha's Vineyard</td>\n",
       "      <td>96</td>\n",
       "      <td>235.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Heitz</td>\n",
       "      <td>0.408511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Ripe aromas of fig, blackberry and cassis are ...</td>\n",
       "      <td>Carodorum Selección Especial Reserva</td>\n",
       "      <td>96</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Bodega Carmen Rodríguez</td>\n",
       "      <td>0.872727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>US</td>\n",
       "      <td>Mac Watson honors the memory of a wine once ma...</td>\n",
       "      <td>Special Selected Late Harvest</td>\n",
       "      <td>96</td>\n",
       "      <td>90.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Knights Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Sauvignon Blanc</td>\n",
       "      <td>Macauley</td>\n",
       "      <td>1.066667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>US</td>\n",
       "      <td>This spent 20 months in 30% new French oak, an...</td>\n",
       "      <td>Reserve</td>\n",
       "      <td>96</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Ponzi</td>\n",
       "      <td>1.476923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>France</td>\n",
       "      <td>This is the top wine from La Bégude, named aft...</td>\n",
       "      <td>La Brûlade</td>\n",
       "      <td>95</td>\n",
       "      <td>66.0</td>\n",
       "      <td>Provence</td>\n",
       "      <td>Bandol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Provence red blend</td>\n",
       "      <td>Domaine de la Bégude</td>\n",
       "      <td>1.439394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Deep, dense and pure from the opening bell, th...</td>\n",
       "      <td>Numanthia</td>\n",
       "      <td>95</td>\n",
       "      <td>73.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Numanthia</td>\n",
       "      <td>1.301370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Slightly gritty black-fruit aromas include a s...</td>\n",
       "      <td>San Román</td>\n",
       "      <td>95</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Maurodos</td>\n",
       "      <td>1.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Lush cedary black-fruit aromas are luxe and of...</td>\n",
       "      <td>Carodorum Único Crianza</td>\n",
       "      <td>95</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Bodega Carmen Rodríguez</td>\n",
       "      <td>0.863636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>US</td>\n",
       "      <td>This re-named vineyard was formerly bottled as...</td>\n",
       "      <td>Silice</td>\n",
       "      <td>95</td>\n",
       "      <td>65.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Chehalem Mountains</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bergström</td>\n",
       "      <td>1.461538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>US</td>\n",
       "      <td>The producer sources from two blocks of the vi...</td>\n",
       "      <td>Gap's Crown Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Blue Farm</td>\n",
       "      <td>1.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Elegance, complexity and structure come togeth...</td>\n",
       "      <td>Ronco della Chiesa</td>\n",
       "      <td>95</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Northeastern Italy</td>\n",
       "      <td>Collio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Friulano</td>\n",
       "      <td>Borgo del Tiglio</td>\n",
       "      <td>1.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>US</td>\n",
       "      <td>From 18-year-old vines, this supple well-balan...</td>\n",
       "      <td>Estate Vineyard Wadensvil Block</td>\n",
       "      <td>95</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Ribbon Ridge</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Patricia Green Cellars</td>\n",
       "      <td>1.979167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>US</td>\n",
       "      <td>A standout even in this terrific lineup of 201...</td>\n",
       "      <td>Weber Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Dundee Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Patricia Green Cellars</td>\n",
       "      <td>1.979167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>France</td>\n",
       "      <td>This wine is in peak condition. The tannins an...</td>\n",
       "      <td>Château Montus Prestige</td>\n",
       "      <td>95</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Madiran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tannat</td>\n",
       "      <td>Vignobles Brumont</td>\n",
       "      <td>1.055556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>US</td>\n",
       "      <td>With its sophisticated mix of mineral, acid an...</td>\n",
       "      <td>Grace Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>185.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Dundee Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Domaine Serene</td>\n",
       "      <td>0.513514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>US</td>\n",
       "      <td>First made in 2006, this succulent luscious Ch...</td>\n",
       "      <td>Sigrid</td>\n",
       "      <td>95</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Bergström</td>\n",
       "      <td>1.055556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>US</td>\n",
       "      <td>This blockbuster, powerhouse of a wine suggest...</td>\n",
       "      <td>Rainin Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>325.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Diamond Mountain District</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Hall</td>\n",
       "      <td>0.292308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Nicely oaked blackberry, licorice, vanilla and...</td>\n",
       "      <td>6 Años Reserva Premium</td>\n",
       "      <td>95</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Ribera del Duero</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tempranillo</td>\n",
       "      <td>Valduero</td>\n",
       "      <td>1.187500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>France</td>\n",
       "      <td>Coming from a seven-acre vineyard named after ...</td>\n",
       "      <td>Le Pigeonnier</td>\n",
       "      <td>95</td>\n",
       "      <td>290.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Cahors</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malbec</td>\n",
       "      <td>Château Lagrézette</td>\n",
       "      <td>0.327586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>US</td>\n",
       "      <td>This fresh and lively medium-bodied wine is be...</td>\n",
       "      <td>Gap's Crown Vineyard</td>\n",
       "      <td>95</td>\n",
       "      <td>75.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Gary Farrell</td>\n",
       "      <td>1.266667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>US</td>\n",
       "      <td>Heitz has made this stellar rosé from the rare...</td>\n",
       "      <td>Grignolino</td>\n",
       "      <td>95</td>\n",
       "      <td>24.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Rosé</td>\n",
       "      <td>Heitz</td>\n",
       "      <td>3.958333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Alluring, complex and powerful aromas of grill...</td>\n",
       "      <td>Prado Enea Gran Reserva</td>\n",
       "      <td>95</td>\n",
       "      <td>79.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Rioja</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tempranillo Blend</td>\n",
       "      <td>Muga</td>\n",
       "      <td>1.202532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Spain</td>\n",
       "      <td>Tarry blackberry and cheesy oak aromas are app...</td>\n",
       "      <td>Termanthia</td>\n",
       "      <td>95</td>\n",
       "      <td>220.0</td>\n",
       "      <td>Northern Spain</td>\n",
       "      <td>Toro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tinta de Toro</td>\n",
       "      <td>Numanthia</td>\n",
       "      <td>0.431818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>US</td>\n",
       "      <td>The apogee of this ambitious winery's white wi...</td>\n",
       "      <td>Giallo Solare</td>\n",
       "      <td>95</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Edna Valley</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Center of Effort</td>\n",
       "      <td>1.583333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>US</td>\n",
       "      <td>San Jose-based producer Adam Comartin heads 1,...</td>\n",
       "      <td>R-Bar-R Ranch</td>\n",
       "      <td>95</td>\n",
       "      <td>45.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Santa Cruz Mountains</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Comartin</td>\n",
       "      <td>2.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>New Zealand</td>\n",
       "      <td>Yields were down in 2015, but intensity is up,...</td>\n",
       "      <td>Maté's Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>57.0</td>\n",
       "      <td>Kumeu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Kumeu River</td>\n",
       "      <td>1.649123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>US</td>\n",
       "      <td>Bergström has made a Shea designate since 2003...</td>\n",
       "      <td>Shea Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>62.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bergström</td>\n",
       "      <td>1.516129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>US</td>\n",
       "      <td>Focused and dense, this intense wine captures ...</td>\n",
       "      <td>Abetina</td>\n",
       "      <td>94</td>\n",
       "      <td>105.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Ponzi</td>\n",
       "      <td>0.895238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>US</td>\n",
       "      <td>Cranberry, baked rhubarb, anise and crushed sl...</td>\n",
       "      <td>Garys' Vineyard</td>\n",
       "      <td>94</td>\n",
       "      <td>60.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Santa Lucia Highlands</td>\n",
       "      <td>Central Coast</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Roar</td>\n",
       "      <td>1.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>US</td>\n",
       "      <td>This standout Rocks District wine brings earth...</td>\n",
       "      <td>The Funk Estate</td>\n",
       "      <td>94</td>\n",
       "      <td>60.0</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Walla Walla Valley (WA)</td>\n",
       "      <td>Columbia Valley</td>\n",
       "      <td>Syrah</td>\n",
       "      <td>Saviah</td>\n",
       "      <td>1.566667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>US</td>\n",
       "      <td>Sweetened tannins highlight a depth of chocola...</td>\n",
       "      <td>District Collection</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>California</td>\n",
       "      <td>St. Helena</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Raymond</td>\n",
       "      <td>1.070588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>US</td>\n",
       "      <td>This wine draws from a handful of tremendous v...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>45.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Coast</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Red Car</td>\n",
       "      <td>2.022222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This offers aromas of red rose, wild berry, da...</td>\n",
       "      <td>Bussia Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Silvano Bolmida</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>US</td>\n",
       "      <td>Massively fruity, this is an apple/pear bonanz...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Gris</td>\n",
       "      <td>Trinity Vineyards</td>\n",
       "      <td>4.789474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>It is the ripe dark Alicante Bouschet that dom...</td>\n",
       "      <td>Premium</td>\n",
       "      <td>91</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Alentejo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Portuguese Red</td>\n",
       "      <td>Adega Cooperativa de Borba</td>\n",
       "      <td>6.066667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>US</td>\n",
       "      <td>An elegant blend from different estate vineyar...</td>\n",
       "      <td>Premier Cuvée</td>\n",
       "      <td>91</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Archery Summit</td>\n",
       "      <td>1.685185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>France</td>\n",
       "      <td>This wine is bone-dry, although with some age ...</td>\n",
       "      <td>Le Nombre d'Or Brut Nature</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Champagne</td>\n",
       "      <td>Champagne</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Aubry</td>\n",
       "      <td>1.070588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>US</td>\n",
       "      <td>Given four months in concrete egg, this is an ...</td>\n",
       "      <td>Juliana Vineyard</td>\n",
       "      <td>91</td>\n",
       "      <td>38.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Sauvignon Blanc</td>\n",
       "      <td>B Cellars</td>\n",
       "      <td>2.394737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>US</td>\n",
       "      <td>This wine over-delivers in quality for the pri...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>28.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>B Side</td>\n",
       "      <td>3.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Underbrush, smoke, mocha and dark fruit aromas...</td>\n",
       "      <td>Boscato</td>\n",
       "      <td>91</td>\n",
       "      <td>75.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Bel Colle</td>\n",
       "      <td>1.213333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>US</td>\n",
       "      <td>Generous black-cherry fruit anchors this barre...</td>\n",
       "      <td>Aeolian</td>\n",
       "      <td>91</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Eola-Amity Hills</td>\n",
       "      <td>Willamette Valley</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Bethel Heights</td>\n",
       "      <td>2.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Israel</td>\n",
       "      <td>Dark red violet in color, this wine has aromas...</td>\n",
       "      <td>Reserve</td>\n",
       "      <td>91</td>\n",
       "      <td>25.0</td>\n",
       "      <td>Upper Galilee</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Binyamina</td>\n",
       "      <td>3.640000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Berry, baking spice, dried iris, mint and a hi...</td>\n",
       "      <td>Palliano Riserva</td>\n",
       "      <td>91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Roero</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Ceste</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Italy</td>\n",
       "      <td>This hearty red opens with aromas of leafy und...</td>\n",
       "      <td>del Comune di Serralunga d'Alba</td>\n",
       "      <td>91</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina Cucco</td>\n",
       "      <td>1.542373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Enticing aromas of woodland berry, crushed ros...</td>\n",
       "      <td>Bricco Luciani</td>\n",
       "      <td>91</td>\n",
       "      <td>85.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cascina del Monastero</td>\n",
       "      <td>1.070588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of French oak, coconut, vanilla and spi...</td>\n",
       "      <td>Bricco Gattera</td>\n",
       "      <td>91</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Piedmont</td>\n",
       "      <td>Barolo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nebbiolo</td>\n",
       "      <td>Cordero di Montezemolo</td>\n",
       "      <td>1.137500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>France</td>\n",
       "      <td>This delicious, refreshing wine is textured, t...</td>\n",
       "      <td>Montmains Premier Cru</td>\n",
       "      <td>91</td>\n",
       "      <td>45.0</td>\n",
       "      <td>Burgundy</td>\n",
       "      <td>Chablis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Domaine Gérard Duplessis</td>\n",
       "      <td>2.022222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>US</td>\n",
       "      <td>From a multiplicity of vineyards, this wine wo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>22.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Eagle Glen</td>\n",
       "      <td>4.136364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>US</td>\n",
       "      <td>The first Pinot Noir release from this produce...</td>\n",
       "      <td>Bacigalupi Vineyard</td>\n",
       "      <td>91</td>\n",
       "      <td>65.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Russian River Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Pinot Noir</td>\n",
       "      <td>Eleven Eleven</td>\n",
       "      <td>1.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>US</td>\n",
       "      <td>A red Meritage driven by 73% Cabernet Sauvigno...</td>\n",
       "      <td>Magnificat</td>\n",
       "      <td>91</td>\n",
       "      <td>50.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Napa Valley</td>\n",
       "      <td>Napa</td>\n",
       "      <td>Meritage</td>\n",
       "      <td>Franciscan</td>\n",
       "      <td>1.820000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>US</td>\n",
       "      <td>Bright, light oak shadings dress up this mediu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>California</td>\n",
       "      <td>California</td>\n",
       "      <td>California Other</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Belle Ambiance</td>\n",
       "      <td>8.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>The local Baga grape, better known for produci...</td>\n",
       "      <td>Marquês de Marialva Rosé Bruto</td>\n",
       "      <td>86</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Beira Atlantico</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Baga</td>\n",
       "      <td>Adega de Cantanhede</td>\n",
       "      <td>7.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Italy</td>\n",
       "      <td>Aromas of white spring flower, orchard fruit a...</td>\n",
       "      <td>Nature</td>\n",
       "      <td>86</td>\n",
       "      <td>22.0</td>\n",
       "      <td>Veneto</td>\n",
       "      <td>Prosecco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Glera</td>\n",
       "      <td>De Stefani</td>\n",
       "      <td>3.909091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>US</td>\n",
       "      <td>A smoky scent and earthy, crisp-apple flavors ...</td>\n",
       "      <td>Small Lot Blend</td>\n",
       "      <td>86</td>\n",
       "      <td>13.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Mendocino County</td>\n",
       "      <td>Mendocino/Lake Counties</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>Parducci</td>\n",
       "      <td>6.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Portugal</td>\n",
       "      <td>This family-owned estate has produced an immed...</td>\n",
       "      <td>Muros de Vinha</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Douro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Portuguese Red</td>\n",
       "      <td>Quinta do Portal</td>\n",
       "      <td>8.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>France</td>\n",
       "      <td>This is a smooth, soft wine that is full of bl...</td>\n",
       "      <td>Château Beauvillain-Monpezat</td>\n",
       "      <td>86</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Cahors</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Malbec-Merlot</td>\n",
       "      <td>Rigal</td>\n",
       "      <td>6.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>US</td>\n",
       "      <td>This is an easygoing wine that's neither too o...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>18.0</td>\n",
       "      <td>California</td>\n",
       "      <td>California</td>\n",
       "      <td>California Other</td>\n",
       "      <td>Chardonnay</td>\n",
       "      <td>The Naked Grape</td>\n",
       "      <td>4.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>US</td>\n",
       "      <td>Blended with small amounts of Merlot, Cabernet...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86</td>\n",
       "      <td>36.0</td>\n",
       "      <td>California</td>\n",
       "      <td>Sonoma Valley</td>\n",
       "      <td>Sonoma</td>\n",
       "      <td>Cabernet Sauvignon</td>\n",
       "      <td>Tin Barn</td>\n",
       "      <td>2.388889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>France</td>\n",
       "      <td>Closer to Bordeaux than is Cahors, this is Mal...</td>\n",
       "      <td>Pigmentum</td>\n",
       "      <td>86</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Buzet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Merlot-Malbec</td>\n",
       "      <td>Georges Vigouroux</td>\n",
       "      <td>5.733333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>France</td>\n",
       "      <td>This is a blend of 60% Ugni Blanc and 40% Colo...</td>\n",
       "      <td>Pigmentum</td>\n",
       "      <td>86</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Southwest France</td>\n",
       "      <td>Côtes de Gascogne</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ugni Blanc-Colombard</td>\n",
       "      <td>Georges Vigouroux</td>\n",
       "      <td>8.600000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        country                                        description  \\\n",
       "0            US  This tremendous 100% varietal wine hails from ...   \n",
       "1         Spain  Ripe aromas of fig, blackberry and cassis are ...   \n",
       "2            US  Mac Watson honors the memory of a wine once ma...   \n",
       "3            US  This spent 20 months in 30% new French oak, an...   \n",
       "4        France  This is the top wine from La Bégude, named aft...   \n",
       "5         Spain  Deep, dense and pure from the opening bell, th...   \n",
       "6         Spain  Slightly gritty black-fruit aromas include a s...   \n",
       "7         Spain  Lush cedary black-fruit aromas are luxe and of...   \n",
       "8            US  This re-named vineyard was formerly bottled as...   \n",
       "9            US  The producer sources from two blocks of the vi...   \n",
       "10        Italy  Elegance, complexity and structure come togeth...   \n",
       "11           US  From 18-year-old vines, this supple well-balan...   \n",
       "12           US  A standout even in this terrific lineup of 201...   \n",
       "13       France  This wine is in peak condition. The tannins an...   \n",
       "14           US  With its sophisticated mix of mineral, acid an...   \n",
       "15           US  First made in 2006, this succulent luscious Ch...   \n",
       "16           US  This blockbuster, powerhouse of a wine suggest...   \n",
       "17        Spain  Nicely oaked blackberry, licorice, vanilla and...   \n",
       "18       France  Coming from a seven-acre vineyard named after ...   \n",
       "19           US  This fresh and lively medium-bodied wine is be...   \n",
       "20           US  Heitz has made this stellar rosé from the rare...   \n",
       "21        Spain  Alluring, complex and powerful aromas of grill...   \n",
       "22        Spain  Tarry blackberry and cheesy oak aromas are app...   \n",
       "23           US  The apogee of this ambitious winery's white wi...   \n",
       "24           US  San Jose-based producer Adam Comartin heads 1,...   \n",
       "25  New Zealand  Yields were down in 2015, but intensity is up,...   \n",
       "26           US  Bergström has made a Shea designate since 2003...   \n",
       "27           US  Focused and dense, this intense wine captures ...   \n",
       "28           US  Cranberry, baked rhubarb, anise and crushed sl...   \n",
       "29           US  This standout Rocks District wine brings earth...   \n",
       "..          ...                                                ...   \n",
       "70           US  Sweetened tannins highlight a depth of chocola...   \n",
       "71           US  This wine draws from a handful of tremendous v...   \n",
       "72        Italy  This offers aromas of red rose, wild berry, da...   \n",
       "73           US  Massively fruity, this is an apple/pear bonanz...   \n",
       "74     Portugal  It is the ripe dark Alicante Bouschet that dom...   \n",
       "75           US  An elegant blend from different estate vineyar...   \n",
       "76       France  This wine is bone-dry, although with some age ...   \n",
       "77           US  Given four months in concrete egg, this is an ...   \n",
       "78           US  This wine over-delivers in quality for the pri...   \n",
       "79        Italy  Underbrush, smoke, mocha and dark fruit aromas...   \n",
       "80           US  Generous black-cherry fruit anchors this barre...   \n",
       "81       Israel  Dark red violet in color, this wine has aromas...   \n",
       "82        Italy  Berry, baking spice, dried iris, mint and a hi...   \n",
       "83        Italy  This hearty red opens with aromas of leafy und...   \n",
       "84        Italy  Enticing aromas of woodland berry, crushed ros...   \n",
       "85        Italy  Aromas of French oak, coconut, vanilla and spi...   \n",
       "86       France  This delicious, refreshing wine is textured, t...   \n",
       "87           US  From a multiplicity of vineyards, this wine wo...   \n",
       "88           US  The first Pinot Noir release from this produce...   \n",
       "89           US  A red Meritage driven by 73% Cabernet Sauvigno...   \n",
       "90           US  Bright, light oak shadings dress up this mediu...   \n",
       "91     Portugal  The local Baga grape, better known for produci...   \n",
       "92        Italy  Aromas of white spring flower, orchard fruit a...   \n",
       "93           US  A smoky scent and earthy, crisp-apple flavors ...   \n",
       "94     Portugal  This family-owned estate has produced an immed...   \n",
       "95       France  This is a smooth, soft wine that is full of bl...   \n",
       "96           US  This is an easygoing wine that's neither too o...   \n",
       "97           US  Blended with small amounts of Merlot, Cabernet...   \n",
       "98       France  Closer to Bordeaux than is Cahors, this is Mal...   \n",
       "99       France  This is a blend of 60% Ugni Blanc and 40% Colo...   \n",
       "\n",
       "                             designation  points  price            province  \\\n",
       "0                      Martha's Vineyard      96  235.0          California   \n",
       "1   Carodorum Selección Especial Reserva      96  110.0      Northern Spain   \n",
       "2          Special Selected Late Harvest      96   90.0          California   \n",
       "3                                Reserve      96   65.0              Oregon   \n",
       "4                             La Brûlade      95   66.0            Provence   \n",
       "5                              Numanthia      95   73.0      Northern Spain   \n",
       "6                              San Román      95   65.0      Northern Spain   \n",
       "7                Carodorum Único Crianza      95  110.0      Northern Spain   \n",
       "8                                 Silice      95   65.0              Oregon   \n",
       "9                   Gap's Crown Vineyard      95   60.0          California   \n",
       "10                    Ronco della Chiesa      95   80.0  Northeastern Italy   \n",
       "11       Estate Vineyard Wadensvil Block      95   48.0              Oregon   \n",
       "12                        Weber Vineyard      95   48.0              Oregon   \n",
       "13               Château Montus Prestige      95   90.0    Southwest France   \n",
       "14                        Grace Vineyard      95  185.0              Oregon   \n",
       "15                                Sigrid      95   90.0              Oregon   \n",
       "16                       Rainin Vineyard      95  325.0          California   \n",
       "17                6 Años Reserva Premium      95   80.0      Northern Spain   \n",
       "18                         Le Pigeonnier      95  290.0    Southwest France   \n",
       "19                  Gap's Crown Vineyard      95   75.0          California   \n",
       "20                            Grignolino      95   24.0          California   \n",
       "21               Prado Enea Gran Reserva      95   79.0      Northern Spain   \n",
       "22                            Termanthia      95  220.0      Northern Spain   \n",
       "23                         Giallo Solare      95   60.0          California   \n",
       "24                         R-Bar-R Ranch      95   45.0          California   \n",
       "25                       Maté's Vineyard      94   57.0               Kumeu   \n",
       "26                         Shea Vineyard      94   62.0              Oregon   \n",
       "27                               Abetina      94  105.0              Oregon   \n",
       "28                       Garys' Vineyard      94   60.0          California   \n",
       "29                       The Funk Estate      94   60.0          Washington   \n",
       "..                                   ...     ...    ...                 ...   \n",
       "70                   District Collection      91   85.0          California   \n",
       "71                                   NaN      91   45.0          California   \n",
       "72                        Bussia Riserva      91    NaN            Piedmont   \n",
       "73                                   NaN      91   19.0              Oregon   \n",
       "74                               Premium      91   15.0            Alentejo   \n",
       "75                         Premier Cuvée      91   54.0              Oregon   \n",
       "76            Le Nombre d'Or Brut Nature      91   85.0           Champagne   \n",
       "77                      Juliana Vineyard      91   38.0          California   \n",
       "78                                   NaN      91   28.0          California   \n",
       "79                               Boscato      91   75.0            Piedmont   \n",
       "80                               Aeolian      91   42.0              Oregon   \n",
       "81                               Reserve      91   25.0       Upper Galilee   \n",
       "82                      Palliano Riserva      91    NaN            Piedmont   \n",
       "83       del Comune di Serralunga d'Alba      91   59.0            Piedmont   \n",
       "84                        Bricco Luciani      91   85.0            Piedmont   \n",
       "85                        Bricco Gattera      91   80.0            Piedmont   \n",
       "86                 Montmains Premier Cru      91   45.0            Burgundy   \n",
       "87                                   NaN      91   22.0          California   \n",
       "88                   Bacigalupi Vineyard      91   65.0          California   \n",
       "89                            Magnificat      91   50.0          California   \n",
       "90                                   NaN      86   10.0          California   \n",
       "91        Marquês de Marialva Rosé Bruto      86   12.0     Beira Atlantico   \n",
       "92                                Nature      86   22.0              Veneto   \n",
       "93                       Small Lot Blend      86   13.0          California   \n",
       "94                        Muros de Vinha      86   10.0               Douro   \n",
       "95          Château Beauvillain-Monpezat      86   14.0    Southwest France   \n",
       "96                                   NaN      86   18.0          California   \n",
       "97                                   NaN      86   36.0          California   \n",
       "98                             Pigmentum      86   15.0    Southwest France   \n",
       "99                             Pigmentum      86   10.0    Southwest France   \n",
       "\n",
       "                     region_1                 region_2               variety  \\\n",
       "0                 Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "1                        Toro                      NaN         Tinta de Toro   \n",
       "2              Knights Valley                   Sonoma       Sauvignon Blanc   \n",
       "3           Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "4                      Bandol                      NaN    Provence red blend   \n",
       "5                        Toro                      NaN         Tinta de Toro   \n",
       "6                        Toro                      NaN         Tinta de Toro   \n",
       "7                        Toro                      NaN         Tinta de Toro   \n",
       "8          Chehalem Mountains        Willamette Valley            Pinot Noir   \n",
       "9                Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "10                     Collio                      NaN              Friulano   \n",
       "11               Ribbon Ridge        Willamette Valley            Pinot Noir   \n",
       "12               Dundee Hills        Willamette Valley            Pinot Noir   \n",
       "13                    Madiran                      NaN                Tannat   \n",
       "14               Dundee Hills        Willamette Valley            Pinot Noir   \n",
       "15          Willamette Valley        Willamette Valley            Chardonnay   \n",
       "16  Diamond Mountain District                     Napa    Cabernet Sauvignon   \n",
       "17           Ribera del Duero                      NaN           Tempranillo   \n",
       "18                     Cahors                      NaN                Malbec   \n",
       "19               Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "20                Napa Valley                     Napa                  Rosé   \n",
       "21                      Rioja                      NaN     Tempranillo Blend   \n",
       "22                       Toro                      NaN         Tinta de Toro   \n",
       "23                Edna Valley            Central Coast            Chardonnay   \n",
       "24       Santa Cruz Mountains            Central Coast            Pinot Noir   \n",
       "25                        NaN                      NaN            Chardonnay   \n",
       "26          Willamette Valley                      NaN            Pinot Noir   \n",
       "27          Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "28      Santa Lucia Highlands            Central Coast            Pinot Noir   \n",
       "29    Walla Walla Valley (WA)          Columbia Valley                 Syrah   \n",
       "..                        ...                      ...                   ...   \n",
       "70                 St. Helena                     Napa    Cabernet Sauvignon   \n",
       "71               Sonoma Coast                   Sonoma            Pinot Noir   \n",
       "72                     Barolo                      NaN              Nebbiolo   \n",
       "73          Willamette Valley        Willamette Valley            Pinot Gris   \n",
       "74                        NaN                      NaN        Portuguese Red   \n",
       "75          Willamette Valley        Willamette Valley            Pinot Noir   \n",
       "76                  Champagne                      NaN            Chardonnay   \n",
       "77                Napa Valley                     Napa       Sauvignon Blanc   \n",
       "78                Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "79                     Barolo                      NaN              Nebbiolo   \n",
       "80           Eola-Amity Hills        Willamette Valley            Pinot Noir   \n",
       "81                        NaN                      NaN    Cabernet Sauvignon   \n",
       "82                      Roero                      NaN              Nebbiolo   \n",
       "83                     Barolo                      NaN              Nebbiolo   \n",
       "84                     Barolo                      NaN              Nebbiolo   \n",
       "85                     Barolo                      NaN              Nebbiolo   \n",
       "86                    Chablis                      NaN            Chardonnay   \n",
       "87                Napa Valley                     Napa    Cabernet Sauvignon   \n",
       "88       Russian River Valley                   Sonoma            Pinot Noir   \n",
       "89                Napa Valley                     Napa              Meritage   \n",
       "90                 California         California Other    Cabernet Sauvignon   \n",
       "91                        NaN                      NaN                  Baga   \n",
       "92                   Prosecco                      NaN                 Glera   \n",
       "93           Mendocino County  Mendocino/Lake Counties            Chardonnay   \n",
       "94                        NaN                      NaN        Portuguese Red   \n",
       "95                     Cahors                      NaN         Malbec-Merlot   \n",
       "96                 California         California Other            Chardonnay   \n",
       "97              Sonoma Valley                   Sonoma    Cabernet Sauvignon   \n",
       "98                      Buzet                      NaN         Merlot-Malbec   \n",
       "99          Côtes de Gascogne                      NaN  Ugni Blanc-Colombard   \n",
       "\n",
       "                        winery  points/price  \n",
       "0                        Heitz      0.408511  \n",
       "1      Bodega Carmen Rodríguez      0.872727  \n",
       "2                     Macauley      1.066667  \n",
       "3                        Ponzi      1.476923  \n",
       "4         Domaine de la Bégude      1.439394  \n",
       "5                    Numanthia      1.301370  \n",
       "6                     Maurodos      1.461538  \n",
       "7      Bodega Carmen Rodríguez      0.863636  \n",
       "8                    Bergström      1.461538  \n",
       "9                    Blue Farm      1.583333  \n",
       "10            Borgo del Tiglio      1.187500  \n",
       "11      Patricia Green Cellars      1.979167  \n",
       "12      Patricia Green Cellars      1.979167  \n",
       "13           Vignobles Brumont      1.055556  \n",
       "14              Domaine Serene      0.513514  \n",
       "15                   Bergström      1.055556  \n",
       "16                        Hall      0.292308  \n",
       "17                    Valduero      1.187500  \n",
       "18          Château Lagrézette      0.327586  \n",
       "19                Gary Farrell      1.266667  \n",
       "20                       Heitz      3.958333  \n",
       "21                        Muga      1.202532  \n",
       "22                   Numanthia      0.431818  \n",
       "23            Center of Effort      1.583333  \n",
       "24                    Comartin      2.111111  \n",
       "25                 Kumeu River      1.649123  \n",
       "26                   Bergström      1.516129  \n",
       "27                       Ponzi      0.895238  \n",
       "28                        Roar      1.566667  \n",
       "29                      Saviah      1.566667  \n",
       "..                         ...           ...  \n",
       "70                     Raymond      1.070588  \n",
       "71                     Red Car      2.022222  \n",
       "72             Silvano Bolmida           NaN  \n",
       "73           Trinity Vineyards      4.789474  \n",
       "74  Adega Cooperativa de Borba      6.066667  \n",
       "75              Archery Summit      1.685185  \n",
       "76                       Aubry      1.070588  \n",
       "77                   B Cellars      2.394737  \n",
       "78                      B Side      3.250000  \n",
       "79                   Bel Colle      1.213333  \n",
       "80              Bethel Heights      2.166667  \n",
       "81                   Binyamina      3.640000  \n",
       "82                       Ceste           NaN  \n",
       "83               Cascina Cucco      1.542373  \n",
       "84       Cascina del Monastero      1.070588  \n",
       "85      Cordero di Montezemolo      1.137500  \n",
       "86    Domaine Gérard Duplessis      2.022222  \n",
       "87                  Eagle Glen      4.136364  \n",
       "88               Eleven Eleven      1.400000  \n",
       "89                  Franciscan      1.820000  \n",
       "90              Belle Ambiance      8.600000  \n",
       "91         Adega de Cantanhede      7.166667  \n",
       "92                  De Stefani      3.909091  \n",
       "93                    Parducci      6.615385  \n",
       "94            Quinta do Portal      8.600000  \n",
       "95                       Rigal      6.142857  \n",
       "96             The Naked Grape      4.777778  \n",
       "97                    Tin Barn      2.388889  \n",
       "98           Georges Vigouroux      5.733333  \n",
       "99           Georges Vigouroux      8.600000  \n",
       "\n",
       "[100 rows x 11 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "wine_dataset[\"points/price\"] = wine_dataset[\"points\"]/wine_dataset[\"price\"]\n",
    "wine_dataset"
   ]
  }
 ],
 "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.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}