State of the Market

Insights

Summary Statistics

52 obs. of 36 variables

summary(wine)
##     Region            Country          Vine.Area...000.ha.
##  Length:52          Length:52          Min.   :  0.000    
##  Class :character   Class :character   1st Qu.:  7.652    
##  Mode  :character   Mode  :character   Median : 43.904    
##                                        Mean   :145.981    
##                                        3rd Qu.:134.584    
##                                        Max.   :975.667    
##                                                           
##  Cropland.under.vines.... Wine.produced..ML. Wine.consumed..ML.
##  Min.   :0.00000          Min.   :   4.175   Min.   :   4.975  
##  1st Qu.:0.04458          1st Qu.:  50.177   1st Qu.:  63.407  
##  Median :0.44985          Median : 185.286   Median : 223.424  
##  Mean   :1.61673          Mean   : 721.017   Mean   : 474.247  
##  3rd Qu.:1.93985          3rd Qu.: 932.170   3rd Qu.: 432.249  
##  Max.   :9.62723          Max.   :4905.167   Max.   :3390.186  
##  NA's   :2                NA's   :12                           
##  Wine.consumed..l.capita. Wine.expenditure..US.m.2015.
##  Min.   : 0.02077         Min.   :  287.1             
##  1st Qu.: 1.42829         1st Qu.:  709.8             
##  Median :12.71207         Median : 1726.1             
##  Mean   :14.83928         Mean   : 5559.1             
##  3rd Qu.:23.23491         3rd Qu.: 4495.4             
##  Max.   :44.28439         Max.   :41822.4             
##  NA's   :1                NA's   :1                   
##  Per.capita.wine.expenditure..US..2015. Population..millions.
##  Min.   :  0.2522                       Min.   :   4.011     
##  1st Qu.: 22.5761                       1st Qu.:   9.174     
##  Median : 92.7098                       Median :  31.307     
##  Mean   :161.3629                       Mean   : 143.098     
##  3rd Qu.:284.3737                       3rd Qu.:  88.722     
##  Max.   :658.6280                       Max.   :1375.936     
##  NA's   :1                              NA's   :1            
##  GDP..billion.US..real.1990. GDP.per.capita...000.US.. Wine.export.vol...ML.
##  Min.   :   20.14            Min.   : 3.806            Min.   :   0.0751    
##  1st Qu.:  135.37            1st Qu.: 8.766            1st Qu.:   4.2882    
##  Median :  296.67            Median :13.478            Median :  21.6786    
##  Mean   : 1290.25            Mean   :16.362            Mean   : 206.3377    
##  3rd Qu.: 1101.23            3rd Qu.:24.445            3rd Qu.: 121.6054    
##  Max.   :15104.21            Max.   :34.678            Max.   :2349.9760    
##  NA's   :5                   NA's   :5                                      
##  Wine.import.vol...ML. Value.of.wine.exports..US..mill.
##  Min.   :   0.184      Min.   :   0.295                
##  1st Qu.:  12.872      1st Qu.:  13.272                
##  Median :  59.536      Median :  72.647                
##  Mean   : 216.357      Mean   : 652.259                
##  3rd Qu.: 237.077      3rd Qu.: 469.454                
##  Max.   :1946.227      Max.   :9523.901                
##                                                        
##  Value.of.wine.imports..US..mill. Bottled.still.wine.exports..ML.
##  Min.   :   1.496                 Min.   :   0.0498              
##  1st Qu.:  30.037                 1st Qu.:   1.4807              
##  Median : 235.156                 Median :   8.2760              
##  Mean   : 717.797                 Mean   : 109.3497              
##  3rd Qu.: 751.471                 3rd Qu.:  43.7488              
##  Max.   :7608.140                 Max.   :1200.1579              
##                                                                  
##  Bottled.still.wine.imports..ML. Sparkling.wine.exports..ML.
##  Min.   :  0.0591                Min.   :  0.00001          
##  1st Qu.:  6.3648                1st Qu.:  0.11089          
##  Median : 33.2673                Median :  0.56879          
##  Mean   :110.6100                Mean   : 14.32569          
##  3rd Qu.:106.6742                3rd Qu.:  3.56556          
##  Max.   :834.6370                Max.   :285.06702          
##                                                             
##  Sparkling.wine.imports..ML. Bulk.wine.exports..ML. Bulk.wine.imports..ML.
##  Min.   :  0.08576           Min.   :   0.0074      Min.   :  0.0033      
##  1st Qu.:  0.89262           1st Qu.:   0.4534      1st Qu.:  1.8300      
##  Median :  3.88270           Median :   4.3738      Median : 15.5852      
##  Mean   : 14.44846           Mean   :  78.7510      Mean   : 80.4451      
##  3rd Qu.: 14.63039           3rd Qu.:  62.8167      3rd Qu.: 82.7327      
##  Max.   :136.98977           Max.   :1332.2694      Max.   :880.7555      
##                                                     NA's   :1             
##  Unit.value.exports..US..litre. Unit.value.imports..US..litre.
##  Min.   : 0.6685                Min.   : 0.6654               
##  1st Qu.: 2.0918                1st Qu.: 2.3014               
##  Median : 3.1449                Median : 3.4949               
##  Mean   : 6.5829                Mean   : 4.7333               
##  3rd Qu.: 4.6145                3rd Qu.: 5.6191               
##  Max.   :80.7060                Max.   :22.4523               
##                                                               
##  X..of.global.prod.n.volume X..of.global.cons.n.volume
##  Min.   : 0.01533           Min.   : 0.02011          
##  1st Qu.: 0.17654           1st Qu.: 0.25799          
##  Median : 0.59992           Median : 0.90925          
##  Mean   : 2.61677           Mean   : 1.88534          
##  3rd Qu.: 2.83388           3rd Qu.: 1.75873          
##  Max.   :18.02111           Max.   :13.68243          
##  NA's   :13                                           
##  X..of..15.global.wine.expend. Wine.as...of.alcohol.cons.n.volume
##  Min.   : 0.1015               Min.   : 0.09645                  
##  1st Qu.: 0.2474               1st Qu.: 9.08242                  
##  Median : 0.6727               Median :28.10517                  
##  Mean   : 1.9339               Mean   :26.97671                  
##  3rd Qu.: 1.6358               3rd Qu.:39.83149                  
##  Max.   :14.8051               Max.   :63.67263                  
##  NA's   :1                     NA's   :1                         
##  Exports.as...of.prod.n.volume Imports.as...of.cons.n.volume
##  Min.   :  0.5173              Min.   :  0.04367            
##  1st Qu.:  5.9750              1st Qu.: 10.64343            
##  Median : 23.3076              Median : 34.42204            
##  Mean   : 37.8122              Mean   : 60.30370            
##  3rd Qu.: 46.3581              3rd Qu.:100.69859            
##  Max.   :292.6375              Max.   :287.01462            
##  NA's   :14                                                 
##  Wine.self..suff...... X..of.world.export.volume X..of.world.export.value
##  Min.   :  0.3072      Min.   : 0.000707         Min.   : 0.000884       
##  1st Qu.: 46.1797      1st Qu.: 0.037177         1st Qu.: 0.033706       
##  Median : 86.2055      Median : 0.203612         Median : 0.219578       
##  Mean   :116.1185      Mean   : 1.906453         Mean   : 1.921786       
##  3rd Qu.:134.7584      3rd Qu.: 1.021164         3rd Qu.: 1.422999       
##  Max.   :564.2857      Max.   :22.072897         Max.   :28.751303       
##  NA's   :13                                                              
##  X..of.world.import.volume X..of.world.import.value Index.of.wine.comp..advant.
##  Min.   : 0.001538         Min.   : 0.00000         Min.   : 0.000424          
##  1st Qu.: 0.099105         1st Qu.: 0.09749         1st Qu.: 0.054813          
##  Median : 0.560377         Median : 0.69552         Median : 0.348958          
##  Mean   : 1.867216         Mean   : 1.93882         Mean   : 2.881781          
##  3rd Qu.: 2.025555         3rd Qu.: 2.25483         3rd Qu.: 0.946059          
##  Max.   :14.252729         Max.   :17.07507         Max.   :27.402233          
##                                                     NA's   :4

Remove NAs

wine <- wine%>%
  na.omit()
skim(wine)
Data summary
Name wine
Number of rows 31
Number of columns 36
_______________________
Column type frequency:
character 2
numeric 34
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
Region 0 1 3 3 0 8 0
Country 0 1 3 12 0 31 0

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
Vine.Area…000.ha. 0 1 209.15 279.93 1.00 43.90 88.00 191.58 975.67 ▇▁▁▁▁
Cropland.under.vines…. 0 1 2.30 2.86 0.02 0.29 0.83 3.03 9.63 ▇▂▁▁▂
Wine.produced..ML. 0 1 859.84 1370.75 13.46 63.69 261.07 1066.29 4905.17 ▇▂▁▁▁
Wine.consumed..ML. 0 1 648.38 832.03 25.35 180.67 363.81 626.08 3390.19 ▇▁▁▁▁
Wine.consumed..l.capita. 0 1 17.35 14.10 0.02 4.03 15.13 24.49 44.28 ▇▃▆▂▃
Wine.expenditure..US.m.2015. 0 1 7605.70 11141.21 320.95 1179.92 3412.45 7292.45 41822.45 ▇▁▁▁▁
Per.capita.wine.expenditure..US..2015. 0 1 169.14 168.80 0.25 36.84 117.39 284.37 658.63 ▇▁▃▁▁
Population..millions. 0 1 144.96 330.92 4.01 11.04 39.80 93.53 1375.94 ▇▁▁▁▁
GDP..billion.US..real.1990. 0 1 1711.61 3644.43 30.38 149.22 305.55 1261.76 15104.21 ▇▁▁▁▁
GDP.per.capita…000.US.. 0 1 14.32 8.46 3.99 8.12 11.13 22.15 33.23 ▇▃▂▅▁
Wine.export.vol…ML. 0 1 317.03 603.86 0.24 4.53 37.31 327.29 2349.98 ▇▁▁▁▁
Wine.import.vol…ML. 0 1 226.93 387.04 0.18 6.09 59.46 260.77 1516.10 ▇▁▁▁▁
Value.of.wine.exports..US..mill. 0 1 956.48 2059.54 0.74 12.94 88.11 843.48 9523.90 ▇▁▁▁▁
Value.of.wine.imports..US..mill. 0 1 730.83 1478.01 1.91 19.77 139.21 829.49 7608.14 ▇▁▁▁▁
Bottled.still.wine.exports..ML. 0 1 167.37 313.27 0.19 1.51 22.34 205.03 1200.16 ▇▁▁▁▁
Bottled.still.wine.imports..ML. 0 1 104.70 187.93 0.09 2.64 22.92 106.70 834.64 ▇▁▁▁▁
Sparkling.wine.exports..ML. 0 1 22.72 64.28 0.00 0.11 0.76 4.75 285.07 ▇▁▁▁▁
Sparkling.wine.imports..ML. 0 1 14.22 24.75 0.09 0.70 3.88 15.65 120.36 ▇▁▁▁▁
Bulk.wine.exports..ML. 0 1 121.19 265.25 0.02 0.56 5.87 69.64 1332.27 ▇▁▁▁▁
Bulk.wine.imports..ML. 0 1 92.48 187.77 0.00 2.14 15.65 100.19 880.76 ▇▁▁▁▁
Unit.value.exports..US..litre. 0 1 6.86 15.88 0.67 1.93 3.06 3.60 80.71 ▇▁▁▁▁
Unit.value.imports..US..litre. 0 1 3.93 2.72 0.67 1.80 3.54 5.36 11.19 ▇▇▃▁▂
X..of.global.prod.n.volume 0 1 3.16 5.04 0.05 0.23 0.95 3.92 18.02 ▇▂▁▁▁
X..of.global.cons.n.volume 0 1 2.62 3.38 0.10 0.74 1.47 2.55 13.68 ▇▁▁▁▁
X..of..15.global.wine.expend. 0 1 2.54 3.85 0.12 0.40 1.10 2.23 14.81 ▇▁▁▁▁
Wine.as…of.alcohol.cons.n.volume 0 1 30.22 19.10 0.10 13.77 30.84 46.63 63.67 ▇▃▇▃▅
Exports.as…of.prod.n.volume 0 1 35.33 55.84 0.52 4.04 21.80 42.09 292.64 ▇▁▁▁▁
Imports.as…of.cons.n.volume 0 1 26.45 27.02 0.04 7.60 13.85 32.95 93.77 ▇▂▁▁▁
Wine.self..suff…… 0 1 126.74 131.03 4.15 49.59 89.98 147.94 564.29 ▇▃▁▁▁
X..of.world.export.volume 0 1 2.93 5.66 0.00 0.04 0.35 3.08 22.07 ▇▁▁▁▁
X..of.world.export.value 0 1 2.83 6.19 0.00 0.03 0.26 2.55 28.75 ▇▁▁▁▁
X..of.world.import.volume 0 1 2.00 3.30 0.00 0.05 0.56 2.39 14.25 ▇▁▁▁▁
X..of.world.import.value 0 1 1.97 3.56 0.01 0.06 0.42 2.48 17.08 ▇▁▁▁▁
Index.of.wine.comp..advant. 0 1 3.01 5.74 0.00 0.07 0.44 4.49 27.40 ▇▂▁▁▁
names(wine)
##  [1] "Region"                                
##  [2] "Country"                               
##  [3] "Vine.Area...000.ha."                   
##  [4] "Cropland.under.vines...."              
##  [5] "Wine.produced..ML."                    
##  [6] "Wine.consumed..ML."                    
##  [7] "Wine.consumed..l.capita."              
##  [8] "Wine.expenditure..US.m.2015."          
##  [9] "Per.capita.wine.expenditure..US..2015."
## [10] "Population..millions."                 
## [11] "GDP..billion.US..real.1990."           
## [12] "GDP.per.capita...000.US.."             
## [13] "Wine.export.vol...ML."                 
## [14] "Wine.import.vol...ML."                 
## [15] "Value.of.wine.exports..US..mill."      
## [16] "Value.of.wine.imports..US..mill."      
## [17] "Bottled.still.wine.exports..ML."       
## [18] "Bottled.still.wine.imports..ML."       
## [19] "Sparkling.wine.exports..ML."           
## [20] "Sparkling.wine.imports..ML."           
## [21] "Bulk.wine.exports..ML."                
## [22] "Bulk.wine.imports..ML."                
## [23] "Unit.value.exports..US..litre."        
## [24] "Unit.value.imports..US..litre."        
## [25] "X..of.global.prod.n.volume"            
## [26] "X..of.global.cons.n.volume"            
## [27] "X..of..15.global.wine.expend."         
## [28] "Wine.as...of.alcohol.cons.n.volume"    
## [29] "Exports.as...of.prod.n.volume"         
## [30] "Imports.as...of.cons.n.volume"         
## [31] "Wine.self..suff......"                 
## [32] "X..of.world.export.volume"             
## [33] "X..of.world.export.value"              
## [34] "X..of.world.import.volume"             
## [35] "X..of.world.import.value"              
## [36] "Index.of.wine.comp..advant."

Visualization