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)
| 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."