In [2]:
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
from pandas import Series,DataFrame
import seaborn as sns
In [3]:
input_data = pd.read_csv("winemag-data_first150k.csv")
In [7]:
input_data.head()
Out[7]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
0
0
US
This tremendous 100% varietal wine hails from ...
Martha's Vineyard
96
235.0
California
Napa Valley
Napa
Cabernet Sauvignon
Heitz
1
1
Spain
Ripe aromas of fig, blackberry and cassis are ...
Carodorum Selección Especial Reserva
96
110.0
Northern Spain
Toro
NaN
Tinta de Toro
Bodega Carmen Rodríguez
2
2
US
Mac Watson honors the memory of a wine once ma...
Special Selected Late Harvest
96
90.0
California
Knights Valley
Sonoma
Sauvignon Blanc
Macauley
3
3
US
This spent 20 months in 30% new French oak, an...
Reserve
96
65.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
4
4
France
This is the top wine from La Bégude, named aft...
La Brûlade
95
66.0
Provence
Bandol
NaN
Provence red blend
Domaine de la Bégude
In [17]:
input_data["description"]
input_data["description"][0]
input_data["description"][0:10]
input_data[0:10]
input_data.iloc[:1,2]
Out[17]:
0 This tremendous 100% varietal wine hails from ...
Name: description, dtype: object
In [6]:
# 第一行
input_data.iloc[0]
Out[6]:
Unnamed: 0 0
country US
description This tremendous 100% varietal wine hails from ...
designation Martha's Vineyard
points 96
price 235
province California
region_1 Napa Valley
region_2 Napa
variety Cabernet Sauvignon
winery Heitz
Name: 0, dtype: object
In [12]:
# 第一行第二列
input_data.iloc[0,1]
Out[12]:
'US'
In [14]:
# 最后一行，
input_data.iloc[-1:]
# 最后五行
input_data.iloc[-5:]
Out[14]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
150929
150929
Italy
More Pinot Grigios should taste like this. A r...
NaN
90
15.0
Northeastern Italy
Alto Adige
NaN
Pinot Grigio
Alois Lageder
In [9]:
# 第二列
input_data.iloc[:,1]
Out[9]:
0 US
1 Spain
2 US
3 US
4 France
5 Spain
6 Spain
7 Spain
8 US
9 US
10 Italy
11 US
12 US
13 France
14 US
15 US
16 US
17 Spain
18 France
19 US
20 US
21 Spain
22 Spain
23 US
24 US
25 New Zealand
26 US
27 US
28 US
29 US
...
150900 Chile
150901 Chile
150902 Chile
150903 Chile
150904 Chile
150905 Chile
150906 France
150907 France
150908 France
150909 France
150910 France
150911 France
150912 France
150913 France
150914 US
150915 US
150916 US
150917 France
150918 France
150919 France
150920 Italy
150921 France
150922 Italy
150923 France
150924 France
150925 Italy
150926 France
150927 Italy
150928 France
150929 Italy
Name: country, Length: 150930, dtype: object
In [10]:
#第1,3,5行的第四列
input_data.iloc[[0,2,4],3]
Out[10]:
0 Martha's Vineyard
2 Special Selected Late Harvest
4 La Brûlade
Name: designation, dtype: object
In [11]:
input_data.head()
Out[11]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
0
0
US
This tremendous 100% varietal wine hails from ...
Martha's Vineyard
96
235.0
California
Napa Valley
Napa
Cabernet Sauvignon
Heitz
1
1
Spain
Ripe aromas of fig, blackberry and cassis are ...
Carodorum Selección Especial Reserva
96
110.0
Northern Spain
Toro
NaN
Tinta de Toro
Bodega Carmen Rodríguez
2
2
US
Mac Watson honors the memory of a wine once ma...
Special Selected Late Harvest
96
90.0
California
Knights Valley
Sonoma
Sauvignon Blanc
Macauley
3
3
US
This spent 20 months in 30% new French oak, an...
Reserve
96
65.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
4
4
France
This is the top wine from La Bégude, named aft...
La Brûlade
95
66.0
Provence
Bandol
NaN
Provence red blend
Domaine de la Bégude
In [15]:
# 1到9行"country","points"两列
input_data.loc[0:8,["country","points"]]
Out[15]:
country
points
0
US
96
1
Spain
96
2
US
96
3
US
96
4
France
95
5
Spain
95
6
Spain
95
7
Spain
95
8
US
95
In [21]:
# "points"列
input_data.loc[:,"points"]
Out[21]:
0 96
1 96
2 96
3 96
4 95
5 95
6 95
7 95
8 95
9 95
10 95
11 95
12 95
13 95
14 95
15 95
16 95
17 95
18 95
19 95
20 95
21 95
22 95
23 95
24 95
25 94
26 94
27 94
28 94
29 94
..
150900 81
150901 81
150902 81
150903 81
150904 81
150905 80
150906 93
150907 92
150908 90
150909 89
150910 89
150911 87
150912 87
150913 94
150914 94
150915 93
150916 93
150917 92
150918 92
150919 91
150920 91
150921 91
150922 91
150923 91
150924 91
150925 91
150926 91
150927 91
150928 90
150929 90
Name: points, Length: 150930, dtype: int64
In [25]:
input_data.loc[(input_data["country"]=="US")&(input_data.points>95)]
Out[25]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
0
0
US
This tremendous 100% varietal wine hails from ...
Martha's Vineyard
96
235.0
California
Napa Valley
Napa
Cabernet Sauvignon
Heitz
2
2
US
Mac Watson honors the memory of a wine once ma...
Special Selected Late Harvest
96
90.0
California
Knights Valley
Sonoma
Sauvignon Blanc
Macauley
3
3
US
This spent 20 months in 30% new French oak, an...
Reserve
96
65.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
2149
2149
US
Pretty as all get-out, this wine is a floral m...
Coastlands Vineyard
98
75.0
California
Sonoma Coast
Sonoma
Pinot Noir
Williams Selyem
2431
2431
US
Marked by both reduction and oak, this wine fe...
Two Birds Estate Grown
97
90.0
California
Russian River Valley
Sonoma
Pinot Noir
Arista
2438
2438
US
This wine from Jordan Fiorentini is a stunning...
Block B Paderewski Vineyard
96
90.0
California
Paso Robles
Central Coast
Syrah
Epoch Estate Wines
2439
2439
US
This is possibly the most savory rendition of ...
Estate
96
40.0
California
San Luis Obispo County
Central Coast
Syrah
Stolo
2441
2441
US
An extra dollop of toasty oak amplifies the de...
Estate Justina
96
85.0
Oregon
Chehalem Mountains
Willamette Valley
Pinot Noir
Alloro
2442
2442
US
A best-of blend from several of the producer's...
NaN
96
54.0
California
Russian River Valley
Sonoma
Pinot Noir
Arista
2445
2445
US
Somehow, in a stellar 2014 lineup, this vineya...
Abbott Claim Vineyard
96
63.0
Oregon
Willamette Valley
NaN
Pinot Noir
Ken Wright
2455
2455
US
This riveting wine displays the exceptional fi...
Bryce Vineyard
96
63.0
Oregon
Ribbon Ridge
Willamette Valley
Pinot Noir
Ken Wright
2457
2457
US
This wine shows a high degree of spiciness wit...
Lewis MacGregor Estate Vineyard
96
85.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
2731
2731
US
This rich, hearty and ultimately lovely blend ...
Soul of a Lion
96
150.0
California
Adelaida District
Central Coast
Cabernet Sauvignon
Daou
6004
6004
US
This is beautifully lilting in preciously defi...
Bucher Vineyard
97
59.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
6007
6007
US
Separate from the other Original Vines bottlin...
Original Vines Estate
96
85.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
The Eyrie Vineyards
6008
6008
US
Those who think they prefer anything but Chard...
Drake Estate Vineyard
96
65.0
California
Russian River Valley
Sonoma
Chardonnay
Williams Selyem
6009
6009
US
Sanguine and brooding in dense layers of juicy...
Signature Series
96
95.0
California
Napa Valley
Napa
Cabernet Sauvignon
Darioush
6010
6010
US
A block selection, this most rare offering fro...
Édition Limitée
96
85.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
Domaine Drouhin Oregon
10006
10006
US
Seductively smooth and intriguingly aromatic, ...
Westside Road Neighbors
98
69.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
10007
10007
US
This wine is deliciously elegant yet decadentl...
Ritchie Vineyard
97
65.0
California
Russian River Valley
Sonoma
Chardonnay
Ramey
10010
10010
US
This longstanding collaboration between vintne...
Hyde Vineyard
96
65.0
California
Carneros
Napa-Sonoma
Chardonnay
Ramey
10011
10011
US
Silky, with pronounced tannins that should mel...
Olivet Lane Vineyard
96
75.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
10014
10014
US
This wine comes from a new vineyard source for...
Woolsey Road Vineyard
96
65.0
California
Russian River Valley
Sonoma
Chardonnay
Ramey
10507
10507
US
Let the conversations about minerality begin. ...
Moon Select
97
70.0
California
Sonoma Coast
Sonoma
Chardonnay
Flowers
10510
10510
US
Williams Selyem expresses the intricacies of t...
Precious Mountain Vineyard
97
95.0
California
Sonoma Coast
Sonoma
Pinot Noir
Williams Selyem
10513
10513
US
This delicious blend is 70% Cabernet Sauvignon...
The Creator Old Stones
96
60.0
Washington
Walla Walla Valley (WA)
Columbia Valley
Cabernet Sauvignon-Syrah
K Vintners
10516
10516
US
You can taste the California sun in every sip ...
Allen Vineyard
96
82.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
10519
10519
US
As with previous vintages, this rare wine spen...
The Hustler
96
100.0
Washington
Walla Walla Valley (WA)
Columbia Valley
Syrah
K Vintners
10539
10539
US
This is a Pinot Noir of considerable force. Yo...
30th Anniversary Cuvée Estate Vineyard
97
125.0
California
Russian River Valley
Sonoma
Pinot Noir
Williams Selyem
10597
10597
US
A single-barrel reserve, this wine is compact ...
Latifeh
96
100.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ayoub
...
...
...
...
...
...
...
...
...
...
...
...
137377
137377
US
It's hard to consistently get scores this high...
van der Kamp Vineyard
96
40.0
California
Sonoma Mountain
Sonoma
Pinot Noir
Bjornstad
137378
137378
US
All the oaky, leesy richness is there, with bu...
NaN
96
34.0
California
Santa Lucia Highlands
Central Coast
Chardonnay
Boekenoogen
137379
137379
US
This first estate-grown bottling of Rediviva i...
Columbia Rediviva
96
48.0
Washington
Horse Heaven Hills
Columbia Valley
Cabernet Sauvignon-Syrah
Buty
138868
138868
US
This is a great 2005 Pinot Noir, the best ever...
Rosemary's Vineyard
97
70.0
California
Arroyo Grande Valley
Central Coast
Pinot Noir
Talley
138923
138923
US
This single-vineyard bottling is great. It's ...
Wurtele Vineyard
96
50.0
California
Napa
NaN
Cabernet Sauvignon
Terra Valentine
139140
139140
US
This wine is as fine as anything from Santa Ri...
Fe Ciega Vineyard
96
56.0
California
Sta. Rita Hills
Central Coast
Pinot Noir
Ojai
139141
139141
US
Solidly in the Hillside Select model, this vig...
Hillside Select
96
200.0
California
Stags Leap District
Napa
Cabernet Sauvignon
Shafer
142294
142294
US
This companion wine to the famous Harlan Estat...
NaN
98
95.0
California
Napa Valley
Napa
Cabernet Blend
The Maiden
142297
142297
US
Oaky. A bit backward, closed. Lots of primary ...
To Kalon Vineyard Reserve
97
NaN
California
Napa Valley
Napa
Cabernet Sauvignon
Robert Mondavi
142299
142299
US
I far prefer this to the 30th Anniversary bott...
To Kalon Vineyard Reserve
96
NaN
California
Napa Valley
Napa
Cabernet Sauvignon
Robert Mondavi
142304
142304
US
Very fine wine. Denser, richer, more powerful ...
Vecina
96
210.0
California
Napa Valley
Napa
Cabernet Blend
BOND
142697
142697
US
A stupendous wine that epitomizes the Harlan s...
NaN
98
300.0
California
Napa Valley
Napa
Cabernet Sauvignon
Harlan Estate
143522
143522
US
Impossibly aromatic. Hard to imagine greater c...
Red Wine
100
245.0
California
Rutherford
Napa
Cabernet Blend
Sloan
143523
143523
US
The aroma is deep and inviting, equal parts ne...
NaN
99
245.0
California
Napa Valley
Napa
Cabernet Blend
Harlan Estate
143524
143524
US
From the winery's estate vineyard, high up on ...
IX Estate Red Wine
98
175.0
California
Napa Valley
Napa
Bordeaux-style Red Blend
Colgin
143525
143525
US
Fragrant, showing cascades of violets, caramel...
NaN
98
110.0
California
Rutherford
Napa
Cabernet Blend
Rubicon Estate
143527
143527
US
Some great Cabs are drinkable when young, whil...
Reserve
97
100.0
California
Diamond Mountain District
Napa
Red Blend
Von Strasser
143528
143528
US
A masterpiece from this near perfect vintage. ...
Rubicon
97
100.0
California
Rutherford
Napa
Red Blend
Niebaum-Coppola
143529
143529
US
The impression is of a young, tannicly closed ...
Hillside Select
97
190.0
California
Stags Leap District
Napa
Cabernet Sauvignon
Shafer
143530
143530
US
Ripe and flashy, offering tiers of cassis, cho...
Red Wine
96
500.0
California
Oakville
Napa
Cabernet Blend
Screaming Eagle
143531
143531
US
Nearly 100% Cabernet Sauvignon, this firm youn...
Claret
96
110.0
California
Napa Valley
Napa
Cabernet Blend
Robert Foley
143533
143533
US
Stunning. Explodes with the most intricately d...
Eisele Vineyard
96
185.0
California
Napa Valley
Napa
Cabernet Sauvignon
Araujo
143534
143534
US
More structured than the Melbury, with deeper,...
St. Eden
96
225.0
California
Napa Valley
Napa
Cabernet Blend
BOND
143626
143626
US
Beautiful wine, lush and soft in the style of ...
Special Selection
97
136.0
California
Napa Valley
Napa
Cabernet Sauvignon
Caymus
144495
144495
US
So good, it makes you want to shout. Possesses...
Scion
96
50.0
California
Alexander Valley
Sonoma
Cabernet Blend
Robert Young
144868
144868
US
This flamboyant wine is drenched in new oak th...
Late Harvest Wine
96
75.0
California
Napa Valley
Napa
White Blend
Dolce
144869
144869
US
Classic Napa Cab, right up there with the grea...
Cask 23
96
150.0
California
Napa Valley
Napa
Cabernet Sauvignon
Stag's Leap Wine Cellars
145673
145673
US
Complex aromas of cassis, dough, espresso, bac...
Reserve
96
60.0
California
Napa Valley
Napa
Cabernet Sauvignon
Lewis
148047
148047
US
The most complete and compelling of Diamond Cr...
Red Rock Terrace
97
175.0
California
Napa Valley
Napa
Cabernet Sauvignon
Diamond Creek
148048
148048
US
This shows winemaker Greg LaFollette's master ...
30th Anniversary Cuvee
96
45.0
California
Russian River Valley
Sonoma
Pinot Noir
De Loach
536 rows × 11 columns
In [43]:
input_data.query('country == ["US"]')
Out[43]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
0
0
US
This tremendous 100% varietal wine hails from ...
Martha's Vineyard
96
235.0
California
Napa Valley
Napa
Cabernet Sauvignon
Heitz
2
2
US
Mac Watson honors the memory of a wine once ma...
Special Selected Late Harvest
96
90.0
California
Knights Valley
Sonoma
Sauvignon Blanc
Macauley
3
3
US
This spent 20 months in 30% new French oak, an...
Reserve
96
65.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
8
8
US
This re-named vineyard was formerly bottled as...
Silice
95
65.0
Oregon
Chehalem Mountains
Willamette Valley
Pinot Noir
Bergström
9
9
US
The producer sources from two blocks of the vi...
Gap's Crown Vineyard
95
60.0
California
Sonoma Coast
Sonoma
Pinot Noir
Blue Farm
11
11
US
From 18-year-old vines, this supple well-balan...
Estate Vineyard Wadensvil Block
95
48.0
Oregon
Ribbon Ridge
Willamette Valley
Pinot Noir
Patricia Green Cellars
12
12
US
A standout even in this terrific lineup of 201...
Weber Vineyard
95
48.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
Patricia Green Cellars
14
14
US
With its sophisticated mix of mineral, acid an...
Grace Vineyard
95
185.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
Domaine Serene
15
15
US
First made in 2006, this succulent luscious Ch...
Sigrid
95
90.0
Oregon
Willamette Valley
Willamette Valley
Chardonnay
Bergström
16
16
US
This blockbuster, powerhouse of a wine suggest...
Rainin Vineyard
95
325.0
California
Diamond Mountain District
Napa
Cabernet Sauvignon
Hall
19
19
US
This fresh and lively medium-bodied wine is be...
Gap's Crown Vineyard
95
75.0
California
Sonoma Coast
Sonoma
Pinot Noir
Gary Farrell
20
20
US
Heitz has made this stellar rosé from the rare...
Grignolino
95
24.0
California
Napa Valley
Napa
Rosé
Heitz
23
23
US
The apogee of this ambitious winery's white wi...
Giallo Solare
95
60.0
California
Edna Valley
Central Coast
Chardonnay
Center of Effort
24
24
US
San Jose-based producer Adam Comartin heads 1,...
R-Bar-R Ranch
95
45.0
California
Santa Cruz Mountains
Central Coast
Pinot Noir
Comartin
26
26
US
Bergström has made a Shea designate since 2003...
Shea Vineyard
94
62.0
Oregon
Willamette Valley
NaN
Pinot Noir
Bergström
27
27
US
Focused and dense, this intense wine captures ...
Abetina
94
105.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
28
28
US
Cranberry, baked rhubarb, anise and crushed sl...
Garys' Vineyard
94
60.0
California
Santa Lucia Highlands
Central Coast
Pinot Noir
Roar
29
29
US
This standout Rocks District wine brings earth...
The Funk Estate
94
60.0
Washington
Walla Walla Valley (WA)
Columbia Valley
Syrah
Saviah
31
31
US
Steely and perfumed, this wine sees only 20% n...
Babushka
90
37.0
California
Russian River Valley
Sonoma
Chardonnay
Zepaltas
34
34
US
The aromas entice with notes of wet stone, hon...
Conner Lee Vineyard
90
42.0
Washington
Columbia Valley (WA)
Columbia Valley
Chardonnay
Buty
42
42
US
This is an aromatic brooder with aromas of sco...
Private Reserve
90
55.0
Idaho
NaN
NaN
Petite Sirah
Huston
47
47
US
Blended with 9% Malbec, 9% Cabernet Franc and ...
Estate Grown
90
60.0
California
Mount Veeder
Napa
Cabernet Sauvignon
Brandlin
49
49
US
The aromas of blue fruit, herbs and spice are ...
NaN
90
40.0
Washington
Red Mountain
Columbia Valley
Cabernet Sauvignon
Canvasback
54
54
US
There's a lot to like in this nicely priced wh...
NaN
90
18.0
California
Russian River Valley
Sonoma
Chardonnay
De Loach
55
55
US
A blend of Cabernet from Grand Ciel (31%), Cie...
Four Flags
90
69.0
Washington
Red Mountain
Columbia Valley
Cabernet Sauvignon
DeLille
57
57
US
While exuberantly fruity, almost tropical on t...
Reserve
90
25.0
New York
Finger Lakes
Finger Lakes
Riesling
Dr. Konstantin Frank
58
58
US
Cabernet makes up just over half of this blend...
Final Final
90
30.0
Washington
Columbia Valley (WA)
Columbia Valley
Cabernet Sauvignon-Syrah
Efeste
65
65
US
Fresh boysenberries and a blueberry sorbet cha...
Estate Select
91
36.0
California
Santa Clara Valley
Central Coast
Syrah
Jason-Stephens
67
67
US
From the producer's monumental Atlas Peak vine...
Animo
91
85.0
California
Napa Valley
Napa
Cabernet Sauvignon
Michael Mondavi Family Estate
68
68
US
Big, bold, dark and chewy, this builds upon su...
Schindler Vineyard
91
50.0
Oregon
Eola-Amity Hills
Willamette Valley
Pinot Noir
Panther Creek
...
...
...
...
...
...
...
...
...
...
...
...
150812
150812
US
Ripe, muscular wine, with a full throttle nose...
Reserve
88
25.0
California
Napa Valley
Napa
Zinfandel
Stonehedge
150821
150821
US
Here's a nice, refreshing wine very close in p...
NaN
87
14.0
California
Monterey
Central Coast
Pinot Blanc
Ventana
150825
150825
US
Still dependable despite changes in ownership,...
NaN
87
22.0
California
Napa Valley
Napa
Cabernet Sauvignon
William Hill Estate
150827
150827
US
Opens with blackberries and spices; fruity, fo...
Epoch II Millenium Cuvée
87
60.0
California
Dry Creek Valley
Sonoma
Cabernet Sauvignon
Dry Creek Vineyard
150831
150831
US
A rich, creamy wine, loaded with personality. ...
Dutton Vineyard
87
22.0
California
Russian River Valley
Sonoma
Chardonnay
Fritz
150832
150832
US
Enough berry and plum richness and smoky oak t...
NaN
87
17.0
California
Sonoma County
Sonoma
Merlot
Kenwood
150835
150835
US
A little earthy, with plummy aromas accompanie...
NaN
86
28.0
California
Arroyo Grande Valley
Central Coast
Pinot Noir
Talley
150836
150836
US
With this wine, Callaway takes a step away fro...
Coastal
86
10.0
California
California
California Other
Chardonnay
Callaway
150837
150837
US
If you didn't know the price and had to guess,...
NaN
86
10.0
California
Sonoma County
Sonoma
Chardonnay
Dreyer Sonoma
150847
150847
US
The nose seems lean and vaguely unripe. You ge...
NaN
85
20.0
California
Napa Valley
Napa
Merlot
Newlan
150849
150849
US
Cabernet Franc, used in Bordeaux blends and on...
NaN
85
32.0
California
Santa Cruz Mountains
Central Coast
Cabernet Franc
Clos La Chance
150852
150852
US
Aromas of sun-dried tomatoes, coffee, cinnamon...
NaN
85
21.0
California
Sonoma County
Sonoma
Merlot
Dry Creek Vineyard
150856
150856
US
White Merlot? Why not? It's actually a deep ro...
Forest Fire
84
8.0
California
California
California Other
Chardonnay
Forest Glen
150858
150858
US
With a hefty case production, the wine is ligh...
NaN
84
15.0
California
Napa Valley
Napa
Chardonnay
William Hill Estate
150859
150859
US
A blast of clean, ripe citrus, peach and pear ...
NaN
84
6.0
California
California
California Other
Chardonnay
Sutter Home
150861
150861
US
From a dependable producer and a fine vintage ...
Reserve
84
16.0
California
Sonoma County
Sonoma
Chardonnay
Clos du Bois
150865
150865
US
Starts out with Cabernet-like aromas of black ...
NaN
84
10.0
California
California
California Other
Merlot
Compass
150869
150869
US
A clean, well made wine displaying Cab Franc's...
NaN
84
24.0
California
Sonoma Valley
Sonoma
Cabernet Franc
Nelson
150873
150873
US
With a color akin to the soft pink of ripe pea...
White
83
7.0
California
Amador County
Sierra Foothills
Zinfandel
Montevina
150875
150875
US
From the folks who invented white Zinfandel, a...
NaN
83
6.0
California
California
California Other
Zinfandel
Sutter Home
150879
150879
US
A heavy wine, atypical of the appellation, whi...
NaN
83
16.0
California
Anderson Valley
Mendocino/Lake Counties
Pinot Noir
Edmeades
150883
150883
US
A coppery colored, off-dry-to-frankly-sweet wi...
Reserve White
83
7.0
California
California
California Other
Zinfandel
Glen Ellen
150884
150884
US
Here's a nice everyday drinking wine with some...
NaN
83
10.0
California
California
California Other
Chardonnay
Hawk Crest
150886
150886
US
A soft, round quaffer filled with warmth. Slig...
NaN
82
10.0
California
California
California Other
Merlot
Camelot
150889
150889
US
A bizarre style of wine. The aromas are Port-l...
Lafond Vineyard
82
35.0
California
Santa Ynez Valley
Central Coast
Pinot Noir
Lafond
150892
150892
US
A light, earthy wine, with violet, berry and t...
Coastal
82
10.0
California
California
California Other
Merlot
Callaway
150896
150896
US
Some raspberry fruit in the aroma, but things ...
NaN
82
10.0
California
California
California Other
Pinot Noir
Camelot
150914
150914
US
Old-gold in color, and thick and syrupy. The a...
Late Harvest Cluster Select
94
25.0
California
Anderson Valley
Mendocino/Lake Counties
White Riesling
Navarro
150915
150915
US
Decades ago, Beringer’s then-winemaker Myron N...
Nightingale
93
30.0
California
North Coast
North Coast
White Blend
Beringer
150916
150916
US
An impressive wine that presents a full bouque...
J. Schram
93
65.0
California
Napa Valley
Napa
Champagne Blend
Schramsberg
62397 rows × 11 columns
In [26]:
input_data.loc[(input_data["country"]=="US")|(input_data.points>95)]
Out[26]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
0
0
US
This tremendous 100% varietal wine hails from ...
Martha's Vineyard
96
235.0
California
Napa Valley
Napa
Cabernet Sauvignon
Heitz
1
1
Spain
Ripe aromas of fig, blackberry and cassis are ...
Carodorum Selección Especial Reserva
96
110.0
Northern Spain
Toro
NaN
Tinta de Toro
Bodega Carmen Rodríguez
2
2
US
Mac Watson honors the memory of a wine once ma...
Special Selected Late Harvest
96
90.0
California
Knights Valley
Sonoma
Sauvignon Blanc
Macauley
3
3
US
This spent 20 months in 30% new French oak, an...
Reserve
96
65.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
8
8
US
This re-named vineyard was formerly bottled as...
Silice
95
65.0
Oregon
Chehalem Mountains
Willamette Valley
Pinot Noir
Bergström
9
9
US
The producer sources from two blocks of the vi...
Gap's Crown Vineyard
95
60.0
California
Sonoma Coast
Sonoma
Pinot Noir
Blue Farm
11
11
US
From 18-year-old vines, this supple well-balan...
Estate Vineyard Wadensvil Block
95
48.0
Oregon
Ribbon Ridge
Willamette Valley
Pinot Noir
Patricia Green Cellars
12
12
US
A standout even in this terrific lineup of 201...
Weber Vineyard
95
48.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
Patricia Green Cellars
14
14
US
With its sophisticated mix of mineral, acid an...
Grace Vineyard
95
185.0
Oregon
Dundee Hills
Willamette Valley
Pinot Noir
Domaine Serene
15
15
US
First made in 2006, this succulent luscious Ch...
Sigrid
95
90.0
Oregon
Willamette Valley
Willamette Valley
Chardonnay
Bergström
16
16
US
This blockbuster, powerhouse of a wine suggest...
Rainin Vineyard
95
325.0
California
Diamond Mountain District
Napa
Cabernet Sauvignon
Hall
19
19
US
This fresh and lively medium-bodied wine is be...
Gap's Crown Vineyard
95
75.0
California
Sonoma Coast
Sonoma
Pinot Noir
Gary Farrell
20
20
US
Heitz has made this stellar rosé from the rare...
Grignolino
95
24.0
California
Napa Valley
Napa
Rosé
Heitz
23
23
US
The apogee of this ambitious winery's white wi...
Giallo Solare
95
60.0
California
Edna Valley
Central Coast
Chardonnay
Center of Effort
24
24
US
San Jose-based producer Adam Comartin heads 1,...
R-Bar-R Ranch
95
45.0
California
Santa Cruz Mountains
Central Coast
Pinot Noir
Comartin
26
26
US
Bergström has made a Shea designate since 2003...
Shea Vineyard
94
62.0
Oregon
Willamette Valley
NaN
Pinot Noir
Bergström
27
27
US
Focused and dense, this intense wine captures ...
Abetina
94
105.0
Oregon
Willamette Valley
Willamette Valley
Pinot Noir
Ponzi
28
28
US
Cranberry, baked rhubarb, anise and crushed sl...
Garys' Vineyard
94
60.0
California
Santa Lucia Highlands
Central Coast
Pinot Noir
Roar
29
29
US
This standout Rocks District wine brings earth...
The Funk Estate
94
60.0
Washington
Walla Walla Valley (WA)
Columbia Valley
Syrah
Saviah
31
31
US
Steely and perfumed, this wine sees only 20% n...
Babushka
90
37.0
California
Russian River Valley
Sonoma
Chardonnay
Zepaltas
34
34
US
The aromas entice with notes of wet stone, hon...
Conner Lee Vineyard
90
42.0
Washington
Columbia Valley (WA)
Columbia Valley
Chardonnay
Buty
42
42
US
This is an aromatic brooder with aromas of sco...
Private Reserve
90
55.0
Idaho
NaN
NaN
Petite Sirah
Huston
47
47
US
Blended with 9% Malbec, 9% Cabernet Franc and ...
Estate Grown
90
60.0
California
Mount Veeder
Napa
Cabernet Sauvignon
Brandlin
49
49
US
The aromas of blue fruit, herbs and spice are ...
NaN
90
40.0
Washington
Red Mountain
Columbia Valley
Cabernet Sauvignon
Canvasback
54
54
US
There's a lot to like in this nicely priced wh...
NaN
90
18.0
California
Russian River Valley
Sonoma
Chardonnay
De Loach
55
55
US
A blend of Cabernet from Grand Ciel (31%), Cie...
Four Flags
90
69.0
Washington
Red Mountain
Columbia Valley
Cabernet Sauvignon
DeLille
57
57
US
While exuberantly fruity, almost tropical on t...
Reserve
90
25.0
New York
Finger Lakes
Finger Lakes
Riesling
Dr. Konstantin Frank
58
58
US
Cabernet makes up just over half of this blend...
Final Final
90
30.0
Washington
Columbia Valley (WA)
Columbia Valley
Cabernet Sauvignon-Syrah
Efeste
65
65
US
Fresh boysenberries and a blueberry sorbet cha...
Estate Select
91
36.0
California
Santa Clara Valley
Central Coast
Syrah
Jason-Stephens
67
67
US
From the producer's monumental Atlas Peak vine...
Animo
91
85.0
California
Napa Valley
Napa
Cabernet Sauvignon
Michael Mondavi Family Estate
...
...
...
...
...
...
...
...
...
...
...
...
150812
150812
US
Ripe, muscular wine, with a full throttle nose...
Reserve
88
25.0
California
Napa Valley
Napa
Zinfandel
Stonehedge
150821
150821
US
Here's a nice, refreshing wine very close in p...
NaN
87
14.0
California
Monterey
Central Coast
Pinot Blanc
Ventana
150825
150825
US
Still dependable despite changes in ownership,...
NaN
87
22.0
California
Napa Valley
Napa
Cabernet Sauvignon
William Hill Estate
150827
150827
US
Opens with blackberries and spices; fruity, fo...
Epoch II Millenium Cuvée
87
60.0
California
Dry Creek Valley
Sonoma
Cabernet Sauvignon
Dry Creek Vineyard
150831
150831
US
A rich, creamy wine, loaded with personality. ...
Dutton Vineyard
87
22.0
California
Russian River Valley
Sonoma
Chardonnay
Fritz
150832
150832
US
Enough berry and plum richness and smoky oak t...
NaN
87
17.0
California
Sonoma County
Sonoma
Merlot
Kenwood
150835
150835
US
A little earthy, with plummy aromas accompanie...
NaN
86
28.0
California
Arroyo Grande Valley
Central Coast
Pinot Noir
Talley
150836
150836
US
With this wine, Callaway takes a step away fro...
Coastal
86
10.0
California
California
California Other
Chardonnay
Callaway
150837
150837
US
If you didn't know the price and had to guess,...
NaN
86
10.0
California
Sonoma County
Sonoma
Chardonnay
Dreyer Sonoma
150847
150847
US
The nose seems lean and vaguely unripe. You ge...
NaN
85
20.0
California
Napa Valley
Napa
Merlot
Newlan
150849
150849
US
Cabernet Franc, used in Bordeaux blends and on...
NaN
85
32.0
California
Santa Cruz Mountains
Central Coast
Cabernet Franc
Clos La Chance
150852
150852
US
Aromas of sun-dried tomatoes, coffee, cinnamon...
NaN
85
21.0
California
Sonoma County
Sonoma
Merlot
Dry Creek Vineyard
150856
150856
US
White Merlot? Why not? It's actually a deep ro...
Forest Fire
84
8.0
California
California
California Other
Chardonnay
Forest Glen
150858
150858
US
With a hefty case production, the wine is ligh...
NaN
84
15.0
California
Napa Valley
Napa
Chardonnay
William Hill Estate
150859
150859
US
A blast of clean, ripe citrus, peach and pear ...
NaN
84
6.0
California
California
California Other
Chardonnay
Sutter Home
150861
150861
US
From a dependable producer and a fine vintage ...
Reserve
84
16.0
California
Sonoma County
Sonoma
Chardonnay
Clos du Bois
150865
150865
US
Starts out with Cabernet-like aromas of black ...
NaN
84
10.0
California
California
California Other
Merlot
Compass
150869
150869
US
A clean, well made wine displaying Cab Franc's...
NaN
84
24.0
California
Sonoma Valley
Sonoma
Cabernet Franc
Nelson
150873
150873
US
With a color akin to the soft pink of ripe pea...
White
83
7.0
California
Amador County
Sierra Foothills
Zinfandel
Montevina
150875
150875
US
From the folks who invented white Zinfandel, a...
NaN
83
6.0
California
California
California Other
Zinfandel
Sutter Home
150879
150879
US
A heavy wine, atypical of the appellation, whi...
NaN
83
16.0
California
Anderson Valley
Mendocino/Lake Counties
Pinot Noir
Edmeades
150883
150883
US
A coppery colored, off-dry-to-frankly-sweet wi...
Reserve White
83
7.0
California
California
California Other
Zinfandel
Glen Ellen
150884
150884
US
Here's a nice everyday drinking wine with some...
NaN
83
10.0
California
California
California Other
Chardonnay
Hawk Crest
150886
150886
US
A soft, round quaffer filled with warmth. Slig...
NaN
82
10.0
California
California
California Other
Merlot
Camelot
150889
150889
US
A bizarre style of wine. The aromas are Port-l...
Lafond Vineyard
82
35.0
California
Santa Ynez Valley
Central Coast
Pinot Noir
Lafond
150892
150892
US
A light, earthy wine, with violet, berry and t...
Coastal
82
10.0
California
California
California Other
Merlot
Callaway
150896
150896
US
Some raspberry fruit in the aroma, but things ...
NaN
82
10.0
California
California
California Other
Pinot Noir
Camelot
150914
150914
US
Old-gold in color, and thick and syrupy. The a...
Late Harvest Cluster Select
94
25.0
California
Anderson Valley
Mendocino/Lake Counties
White Riesling
Navarro
150915
150915
US
Decades ago, Beringer’s then-winemaker Myron N...
Nightingale
93
30.0
California
North Coast
North Coast
White Blend
Beringer
150916
150916
US
An impressive wine that presents a full bouque...
J. Schram
93
65.0
California
Napa Valley
Napa
Champagne Blend
Schramsberg
63126 rows × 11 columns
In [36]:
input_data.isnull().sum()
Out[36]:
Unnamed: 0 0
country 5
description 0
designation 45735
points 0
price 13695
province 5
region_1 25060
region_2 89977
variety 0
winery 0
dtype: int64
In [37]:
input_data.isnull().sum().sort_values(ascending=False).head(10)
Out[37]:
region_2 89977
designation 45735
region_1 25060
price 13695
province 5
country 5
winery 0
variety 0
points 0
description 0
dtype: int64
In [42]:
input_data.loc[input_data.country.isnull()|input_data.province.isnull()]
Out[42]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
1133
1133
NaN
Delicate white flowers and a spin of lemon pee...
Askitikos
90
17.0
NaN
NaN
NaN
Assyrtiko
Tsililis
1440
1440
NaN
A blend of 60% Syrah, 30% Cabernet Sauvignon a...
Shah
90
30.0
NaN
NaN
NaN
Red Blend
Büyülübağ
68226
68226
NaN
From first sniff to last, the nose never makes...
Piedra Feliz
81
15.0
NaN
NaN
NaN
Pinot Noir
Chilcas
113016
113016
NaN
From first sniff to last, the nose never makes...
Piedra Feliz
81
15.0
NaN
NaN
NaN
Pinot Noir
Chilcas
135696
135696
NaN
From first sniff to last, the nose never makes...
Piedra Feliz
81
15.0
NaN
NaN
NaN
Pinot Noir
Chilcas
In [41]:
input_data.count()
#input_data["country"].isnull()
#.isnull().sum().sort_values(ascending=False).head(10)
Out[41]:
Unnamed: 0 150930
country 150925
description 150930
designation 105195
points 150930
price 137235
province 150925
region_1 125870
region_2 60953
variety 150930
winery 150930
dtype: int64
In [33]:
input_data["country"].value_counts()
Out[33]:
US 62397
Italy 23478
France 21098
Spain 8268
Chile 5816
Argentina 5631
Portugal 5322
Australia 4957
New Zealand 3320
Austria 3057
Germany 2452
South Africa 2258
Greece 884
Israel 630
Hungary 231
Canada 196
Romania 139
Slovenia 94
Uruguay 92
Croatia 89
Bulgaria 77
Moldova 71
Mexico 63
Turkey 52
Georgia 43
Lebanon 37
Cyprus 31
Brazil 25
Macedonia 16
Serbia 14
Morocco 12
Luxembourg 9
England 9
Lithuania 8
India 8
Czech Republic 6
Ukraine 5
Switzerland 4
Bosnia and Herzegovina 4
South Korea 4
Slovakia 3
China 3
Egypt 3
Albania 2
Tunisia 2
Japan 2
Montenegro 2
US-France 1
Name: country, dtype: int64
In [44]:
input_data.groupby('country').count()
Out[44]:
Unnamed: 0
description
designation
points
price
province
region_1
region_2
variety
winery
country
Albania
2
2
0
2
2
2
0
0
2
2
Argentina
5631
5631
3936
5631
5587
5631
5627
0
5631
5631
Australia
4957
4957
3347
4957
4894
4957
4957
0
4957
4957
Austria
3057
3057
2654
3057
2483
3057
0
0
3057
3057
Bosnia and Herzegovina
4
4
1
4
4
4
0
0
4
4
Brazil
25
25
18
25
25
25
0
0
25
25
Bulgaria
77
77
51
77
77
77
0
0
77
77
Canada
196
196
145
196
194
196
196
0
196
196
Chile
5816
5816
4917
5816
5766
5816
0
0
5816
5816
China
3
3
1
3
3
3
0
0
3
3
Croatia
89
89
60
89
83
89
0
0
89
89
Cyprus
31
31
25
31
31
31
0
0
31
31
Czech Republic
6
6
0
6
6
6
0
0
6
6
Egypt
3
3
2
3
0
3
0
0
3
3
England
9
9
9
9
8
9
0
0
9
9
France
21098
21098
14507
21098
14785
21098
21083
0
21098
21098
Georgia
43
43
38
43
43
43
0
0
43
43
Germany
2452
2452
2299
2452
2347
2452
0
0
2452
2452
Greece
884
884
605
884
872
884
0
0
884
884
Hungary
231
231
182
231
230
231
0
0
231
231
India
8
8
4
8
8
8
0
0
8
8
Israel
630
630
568
630
610
630
0
0
630
630
Italy
23478
23478
16890
23478
18784
23478
23478
0
23478
23478
Japan
2
2
2
2
2
2
0
0
2
2
Lebanon
37
37
29
37
37
37
0
0
37
37
Lithuania
8
8
8
8
8
8
0
0
8
8
Luxembourg
9
9
9
9
9
9
0
0
9
9
Macedonia
16
16
7
16
16
16
0
0
16
16
Mexico
63
63
46
63
63
63
0
0
63
63
Moldova
71
71
58
71
71
71
0
0
71
71
Montenegro
2
2
0
2
2
2
0
0
2
2
Morocco
12
12
5
12
12
12
0
0
12
12
New Zealand
3320
3320
1585
3320
3070
3320
0
0
3320
3320
Portugal
5322
5322
4769
5322
4176
5322
0
0
5322
5322
Romania
139
139
118
139
139
139
0
0
139
139
Serbia
14
14
11
14
14
14
0
0
14
14
Slovakia
3
3
0
3
3
3
0
0
3
3
Slovenia
94
94
60
94
81
94
0
0
94
94
South Africa
2258
2258
1200
2258
2237
2258
0
0
2258
2258
South Korea
4
4
4
4
4
4
0
0
4
4
Spain
8268
8268
6554
8268
8160
8268
8268
0
8268
8268
Switzerland
4
4
3
4
4
4
0
0
4
4
Tunisia
2
2
2
2
0
2
0
0
2
2
Turkey
52
52
34
52
50
52
0
0
52
52
US
62397
62397
40345
62397
62139
62397
62261
60953
62397
62397
US-France
1
1
0
1
1
1
0
0
1
1
Ukraine
5
5
5
5
5
5
0
0
5
5
Uruguay
92
92
77
92
85
92
0
0
92
92
In [30]:
input_data.loc[input_data.country.isin(["Spain","France"])]
Out[30]:
Unnamed: 0
country
description
designation
points
price
province
region_1
region_2
variety
winery
1
1
Spain
Ripe aromas of fig, blackberry and cassis are ...
Carodorum Selección Especial Reserva
96
110.0
Northern Spain
Toro
NaN
Tinta de Toro
Bodega Carmen Rodríguez
4
4
France
This is the top wine from La Bégude, named aft...
La Brûlade
95
66.0
Provence
Bandol
NaN
Provence red blend
Domaine de la Bégude
5
5
Spain
Deep, dense and pure from the opening bell, th...
Numanthia
95
73.0
Northern Spain
Toro
NaN
Tinta de Toro
Numanthia
6
6
Spain
Slightly gritty black-fruit aromas include a s...
San Román
95
65.0
Northern Spain
Toro
NaN
Tinta de Toro
Maurodos
7
7
Spain
Lush cedary black-fruit aromas are luxe and of...
Carodorum Único Crianza
95
110.0
Northern Spain
Toro
NaN
Tinta de Toro
Bodega Carmen Rodríguez
13
13
France
This wine is in peak condition. The tannins an...
Château Montus Prestige
95
90.0
Southwest France
Madiran
NaN
Tannat
Vignobles Brumont
17
17
Spain
Nicely oaked blackberry, licorice, vanilla and...
6 Años Reserva Premium
95
80.0
Northern Spain
Ribera del Duero
NaN
Tempranillo
Valduero
18
18
France
Coming from a seven-acre vineyard named after ...
Le Pigeonnier
95
290.0
Southwest France
Cahors
NaN
Malbec
Château Lagrézette
21
21
Spain
Alluring, complex and powerful aromas of grill...
Prado Enea Gran Reserva
95
79.0
Northern Spain
Rioja
NaN
Tempranillo Blend
Muga
22
22
Spain
Tarry blackberry and cheesy oak aromas are app...
Termanthia
95
220.0
Northern Spain
Toro
NaN
Tinta de Toro
Numanthia
33
33
France
Pale in color, this is nutty in character, wit...
Nonpareil Trésor Rosé Brut
90
22.0
France Other
Vin Mousseux
NaN
Sparkling Blend
Bouvet-Ladubay
36
36
France
Gingery spice notes accent fresh pear and melo...
NaN
90
60.0
Rhône Valley
Châteauneuf-du-Pape
NaN
Rhône-style White Blend
Clos de L'Oratoire des Papes
40
40
Spain
Earthy plum and cherry aromas score points for...
Amandi
90
17.0
Galicia
Ribeira Sacra
NaN
Mencía
Don Bernardino
41
41
Spain
This comes across wide and expansive as it laz...
Alfonso Oloroso Seco
90
26.0
Andalucia
Jerez
NaN
Palomino
González Byass
44
44
France
Dark in color and in flavor profile, this medi...
Coteaux
90
69.0
Rhône Valley
Cornas
NaN
Syrah
Tardieu-Laurent
51
51
France
This structured, complex Chardonnay is packed ...
NaN
90
68.0
Burgundy
Chassagne-Montrachet
NaN
Chardonnay
Chartron et Trébuchet
52
52
France
This ripe, full-bodied wine has ripe green fru...
Les 7 Hommes
90
42.0
Loire Valley
Sancerre
NaN
Sauvignon Blanc
Cherrier Frères
53
53
France
With its light color and cool feel, this well-...
L'Inédit
90
28.0
Loire Valley
Coteaux du Giennois
NaN
Pinot Noir
Clement et Florian Berthier
56
56
France
Delicious while also young and textured, this ...
Le Pavé
90
NaN
Loire Valley
Sancerre
NaN
Sauvignon Blanc
Domaine Vacheron
63
63
France
L'Homme Mort is a northern extension of the Fo...
L'Homme Mort Premier Cru
91
45.0
Burgundy
Chablis
NaN
Chardonnay
Domaine Chenevières
66
66
France
The steely character of a young Chablis is ver...
Fourchaume Premier Cru
91
38.0
Burgundy
Chablis
NaN
Chardonnay
Louis Max
76
76
France
This wine is bone-dry, although with some age ...
Le Nombre d'Or Brut Nature
91
85.0
Champagne
Champagne
NaN
Chardonnay
Aubry
86
86
France
This delicious, refreshing wine is textured, t...
Montmains Premier Cru
91
45.0
Burgundy
Chablis
NaN
Chardonnay
Domaine Gérard Duplessis
95
95
France
This is a smooth, soft wine that is full of bl...
Château Beauvillain-Monpezat
86
14.0
Southwest France
Cahors
NaN
Malbec-Merlot
Rigal
98
98
France
Closer to Bordeaux than is Cahors, this is Mal...
Pigmentum
86
15.0
Southwest France
Buzet
NaN
Merlot-Malbec
Georges Vigouroux
99
99
France
This is a blend of 60% Ugni Blanc and 40% Colo...
Pigmentum
86
10.0
Southwest France
Côtes de Gascogne
NaN
Ugni Blanc-Colombard
Georges Vigouroux
116
116
Spain
Aromas of brandied cherry and crème de cassis ...
Dulce Tinto
86
NaN
Levante
Jumilla
NaN
Monastrell
Casa de la Ermita
117
117
France
This pale pink-grey colored wine is a blend of...
NaN
86
20.0
Southwest France
Gaillac
NaN
Rosé
Château Clément Termes
118
118
France
This softly fruity wine has the lightest of ta...
Il est des nôôôtres!
86
15.0
Southwest France
NaN
NaN
Gamay
Château Coutinel
128
128
Spain
Aromas of strawberry, currant and spice are go...
Arnegui Reserva
90
22.0
Northern Spain
Rioja
NaN
Tempranillo
Pagos del Rey
...
...
...
...
...
...
...
...
...
...
...
...
150721
150721
France
Another Cahors from the stable of Alain-Dominq...
NaN
84
11.0
Southwest France
Cahors
NaN
Red Blend
Castel Montplaisir
150725
150725
France
This well-known Burgundy négociant has branche...
Château De Domazan
84
8.0
Rhône Valley
Côtes du Rhône
NaN
Rhône-style Red Blend
Mommessin
150730
150730
France
With a nose of spicy green herbs—notably tarra...
Reserve
84
9.0
Bordeaux
Bordeaux Blanc
NaN
Bordeaux-style White Blend
Marquis de Chasse
150731
150731
France
From a vintage known for its readily-approacha...
NaN
84
20.0
Bordeaux
Saint-Émilion
NaN
Bordeaux-style Red Blend
Château Lapelletrie
150735
150735
France
Features attractive aromas of chocolate, prune...
NaN
84
20.0
Provence
Côtes de Provence
NaN
Rhône-style Red Blend
Château des Sarrins
150736
150736
France
Shows its Right Bank roots in Merlot and Cab F...
NaN
83
15.0
Bordeaux
Montagne-Saint-Émilion
NaN
Bordeaux-style Red Blend
Vieux Château Négrit
150739
150739
France
Pretty strawberries and cherries are paired wi...
NaN
83
8.0
Southwest France
Bergerac
NaN
Bordeaux-style Red Blend
Seigneurs de Bergerac
150747
150747
France
I know Bordeaux isn't known for being fruit-dr...
NaN
82
10.0
Bordeaux
Bordeaux
NaN
Bordeaux-style Red Blend
Château Ducla
150748
150748
France
This one comes from the Mouton branch of the R...
NaN
82
14.0
Bordeaux
Graves
NaN
White Blend
Baron Philippe de Rothschild
150752
150752
France
A light, toffee-and-caramel-tinged red that se...
Cru Classe
82
12.0
Provence
Côtes de Provence
NaN
Rhône-style Red Blend
Castel Roubine
150756
150756
France
A famous old brand that seems to be living off...
Mouton Cadet
81
11.0
Bordeaux
Bordeaux Blanc
NaN
Bordeaux-style White Blend
Baron Philippe de Rothschild
150759
150759
France
The nose features some plum and faint cedar ar...
NaN
81
9.0
Bordeaux
Bordeaux
NaN
Merlot
Michel Lynch
150760
150760
France
A white this age should be fresh and crisp; th...
NaN
80
8.0
Southwest France
Bergerac
NaN
White Blend
Seigneurs de Bergerac
150761
150761
France
Picture grandma standing over a pot of stewed ...
NaN
80
11.0
Languedoc-Roussillon
Fitou
NaN
Red Blend
Mont Tauch
150906
150906
France
This lovely wine, a Monopole, is already showi...
Clos des Reas
93
65.0
Burgundy
Vosne-Romanée
NaN
Pinot Noir
Michel Gros
150907
150907
France
Rion holds back on the new oak, letting the pu...
Les Beaux-Monts
92
52.0
Burgundy
Vosne-Romanée
NaN
Pinot Noir
Daniel Rion
150908
150908
France
Another premier cru from Michel Gros, this one...
Aux Brulees
90
65.0
Burgundy
Vosne-Romanée
NaN
Pinot Noir
Michel Gros
150909
150909
France
This is a lovely, fragrant Burgundy, with a sm...
Clos dea Argillieres
89
52.0
Burgundy
Nuits-St.-Georges
NaN
Pinot Noir
Daniel Rion
150910
150910
France
Scents of graham cracker and malted milk choco...
NaN
89
38.0
Burgundy
Chambolle-Musigny
NaN
Pinot Noir
Michel Gros
150911
150911
France
This needs a good bit of breathing time, then ...
Les Chaliots
87
37.0
Burgundy
Nuits-St.-Georges
NaN
Pinot Noir
Michel Gros
150912
150912
France
The nose is dominated by the attractive scents...
Les Charmes
87
65.0
Burgundy
Chambolle-Musigny
NaN
Pinot Noir
Daniel Rion
150913
150913
France
Inky and rustic, yet in a refined manner. This...
NaN
94
30.0
Rhône Valley
Châteauneuf-du-Pape
NaN
Rhône-style Red Blend
Le Vieux Donjon
150917
150917
France
Light and elegant, this spicy, lively wine is ...
Brut Mosaïque
92
30.0
Champagne
Champagne
NaN
Champagne Blend
Jacquart
150918
150918
France
Jacquart makes a full-bodied, ripe style of Ch...
Cuvée Mosaïque
92
38.0
Champagne
Champagne
NaN
Champagne Blend
Jacquart
150919
150919
France
This classy example opens with a very floral n...
Cuvée President
91
37.0
Champagne
Champagne
NaN
Champagne Blend
H.Germain
150921
150921
France
Shows some older notes: a bouquet of toasted w...
Blanc de Blancs Brut Mosaïque
91
38.0
Champagne
Champagne
NaN
Champagne Blend
Jacquart
150923
150923
France
Rich and toasty, with tiny bubbles. The bouque...
Demi-Sec
91
30.0
Champagne
Champagne
NaN
Champagne Blend
Jacquart
150924
150924
France
Really fine for a low-acid vintage, there's an...
Diamant Bleu
91
70.0
Champagne
Champagne
NaN
Champagne Blend
Heidsieck & Co Monopole
150926
150926
France
Offers an intriguing nose with ginger, lime an...
Cuvée Prestige
91
27.0
Champagne
Champagne
NaN
Champagne Blend
H.Germain
150928
150928
France
A perfect salmon shade, with scents of peaches...
Grand Brut Rosé
90
52.0
Champagne
Champagne
NaN
Champagne Blend
Gosset
29366 rows × 11 columns
In [ ]:
Content source: muxiaobai/CourseExercises
Similar notebooks: