Tidyverse
Victor Torres
2024-04-17
Introduction
For this assignment, we have to collaborate around a project in GitHub.Create an example using one or more TidyVerse packages, and any dataset from fivethirtyeight.com or Kaggle, create a programming sample “vignette” that demonstrates how to use one or more of the capabilities of the selected TidyVerse package with your selected dataset.
I selected to work with a club soccer predictions dataset from the fivethirtyeight.com website, and I will use dplyr, tidyr, ggplot2, and kable libraries to tidy the data in this dataset.
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorslibrary(kableExtra)## Warning: package 'kableExtra' was built under R version 4.3.3##
## Attaching package: 'kableExtra'
##
## The following object is masked from 'package:dplyr':
##
## group_rowsImport files into R
soccer_data <- read.csv("https://raw.githubusercontent.com/vitugo23/DATA607/main/tidyverse_project/soccer-spi/spi_global_rankings_intl.csv")
head(soccer_data)## rank name confed off def spi
## 1 1 Brazil CONMEBOL 3.13 0.29 93.08
## 2 2 Argentina CONMEBOL 2.90 0.39 90.22
## 3 3 Germany UEFA 3.44 0.69 89.75
## 4 4 France UEFA 2.98 0.53 88.66
## 5 5 England UEFA 2.74 0.43 88.26
## 6 6 Spain UEFA 2.56 0.36 87.87Renaming columns with dplyr:: rename().
soccer_data %>%
rename(
team = name,
zone = confed,
offense = off,
defense = def
)## rank team zone offense defense spi
## 1 1 Brazil CONMEBOL 3.13 0.29 93.08
## 2 2 Argentina CONMEBOL 2.90 0.39 90.22
## 3 3 Germany UEFA 3.44 0.69 89.75
## 4 4 France UEFA 2.98 0.53 88.66
## 5 5 England UEFA 2.74 0.43 88.26
## 6 6 Spain UEFA 2.56 0.36 87.87
## 7 7 Portugal UEFA 2.79 0.53 87.02
## 8 8 Netherlands UEFA 2.54 0.57 83.68
## 9 9 Belgium UEFA 2.51 0.63 82.32
## 10 10 Colombia CONMEBOL 2.16 0.46 81.37
## 11 11 Italy UEFA 2.29 0.59 80.35
## 12 12 Uruguay CONMEBOL 2.08 0.50 79.47
## 13 13 Croatia UEFA 2.16 0.58 78.82
## 14 14 Algeria CAF 2.12 0.58 78.21
## 15 15 Switzerland UEFA 2.22 0.67 77.65
## 16 16 Japan AFC 2.01 0.62 75.42
## 17 17 Czech Republic UEFA 2.15 0.72 75.41
## 18 18 Denmark UEFA 2.07 0.68 75.06
## 19 19 Senegal CAF 1.88 0.58 74.39
## 20 20 Canada CONCACAF 2.05 0.70 74.30
## 21 21 Serbia UEFA 2.21 0.81 74.28
## 22 22 Ecuador CONMEBOL 1.92 0.64 73.70
## 23 23 Mexico CONCACAF 1.91 0.65 73.37
## 24 24 Austria UEFA 2.15 0.84 72.83
## 25 25 Norway UEFA 2.00 0.74 72.45
## 26 26 USA CONCACAF 1.91 0.69 72.36
## 27 27 South Korea AFC 1.96 0.72 72.28
## 28 28 Morocco CAF 1.66 0.52 72.10
## 29 29 Chile CONMEBOL 1.87 0.77 69.53
## 30 30 Ukraine UEFA 1.88 0.78 69.49
## 31 31 Tunisia CAF 1.58 0.56 69.47
## 32 32 Egypt CAF 1.65 0.63 68.91
## 33 33 Sweden UEFA 2.01 0.92 68.76
## 34 34 Scotland UEFA 1.84 0.79 68.73
## 35 35 Iran AFC 1.75 0.72 68.52
## 36 36 Venezuela CONMEBOL 1.83 0.80 68.21
## 37 37 Poland UEFA 1.83 0.82 67.67
## 38 38 Peru CONMEBOL 1.76 0.79 67.17
## 39 39 Russia UEFA 1.87 0.90 66.74
## 40 40 Turkey UEFA 1.98 1.00 66.45
## 41 41 Greece UEFA 1.49 0.60 66.44
## 42 42 Ivory Coast CAF 1.62 0.76 65.04
## 43 43 Australia AFC 1.66 0.81 64.71
## 44 44 Hungary UEFA 1.69 0.84 64.46
## 45 45 Paraguay CONMEBOL 1.70 0.88 63.87
## 46 46 Nigeria CAF 1.56 0.80 62.89
## 47 47 Ireland UEFA 1.50 0.76 62.57
## 48 48 Wales UEFA 1.56 0.83 62.08
## 49 49 Cameroon CAF 1.60 0.87 62.06
## 50 50 Panama CONCACAF 1.62 0.93 60.90
## 51 51 Mali CAF 1.40 0.77 60.19
## 52 52 Basque Country UEFA 1.63 1.00 59.32
## 53 53 Bosnia and Herzegovina UEFA 1.60 0.99 58.95
## 54 54 Finland UEFA 1.56 0.97 58.64
## 55 55 Romania UEFA 1.56 1.02 57.65
## 56 56 Uzbekistan AFC 1.59 1.07 56.99
## 57 57 Georgia UEFA 1.53 1.03 56.56
## 58 58 Slovenia UEFA 1.42 0.96 55.91
## 59 59 Saudi Arabia AFC 1.53 1.06 55.91
## 60 60 New Zealand OFC 1.47 1.01 55.79
## 61 61 Bolivia CONMEBOL 1.68 1.21 55.66
## 62 62 Haiti CONCACAF 1.62 1.17 55.32
## 63 63 Ghana CAF 1.47 1.03 55.26
## 64 64 Burkina Faso CAF 1.29 0.89 54.61
## 65 65 Jamaica CONCACAF 1.48 1.07 54.44
## 66 66 Montenegro UEFA 1.30 0.91 54.18
## 67 67 Israel UEFA 1.81 1.41 54.14
## 68 68 Northern Ireland UEFA 1.38 0.99 54.06
## 69 69 Slovakia UEFA 1.41 1.02 54.01
## 70 70 Kosovo UEFA 1.60 1.23 53.44
## 71 71 North Macedonia UEFA 1.32 0.99 52.82
## 72 72 Costa Rica CONCACAF 1.37 1.04 52.71
## 73 73 Iceland UEFA 1.44 1.14 52.17
## 74 74 Oman AFC 1.25 0.95 52.01
## 75 75 Guatemala CONCACAF 1.36 1.07 51.65
## 76 76 Albania UEFA 1.17 0.91 51.00
## 77 77 Angola CAF 1.35 1.12 50.52
## 78 78 Cape Verde Islands CAF 1.13 0.89 50.50
## 79 79 Uganda CAF 1.17 0.93 50.38
## 80 80 South Africa CAF 1.25 1.03 50.19
## 81 81 Iraq AFC 1.12 0.89 50.18
## 82 82 Gabon CAF 1.20 0.99 49.75
## 83 83 Equatorial Guinea CAF 1.29 1.09 49.53
## 84 84 Congo DR CAF 1.20 1.05 48.34
## 85 85 Bahrain AFC 1.31 1.21 47.47
## 86 86 Honduras CONCACAF 1.34 1.24 47.36
## 87 87 Namibia CAF 1.12 1.03 46.96
## 88 88 Qatar AFC 1.30 1.22 46.87
## 89 89 Guinea CAF 1.22 1.15 46.75
## 90 90 Zambia CAF 1.47 1.44 46.15
## 91 91 Jordan AFC 1.12 1.07 45.92
## 92 92 El Salvador CONCACAF 1.16 1.13 45.59
## 93 93 Togo CAF 1.22 1.23 44.66
## 94 94 Bulgaria UEFA 1.23 1.30 43.51
## 95 95 United Arab Emirates AFC 1.04 1.15 42.06
## 96 96 Mauritania CAF 0.97 1.08 41.79
## 97 97 Trinidad and Tobago CONCACAF 1.03 1.17 41.37
## 98 98 Madagascar CAF 1.25 1.44 41.11
## 99 99 China AFC 1.03 1.20 40.91
## 100 100 Benin CAF 0.95 1.16 39.57
## 101 101 Estonia UEFA 1.04 1.27 39.49
## 102 102 Ethiopia CAF 1.11 1.35 39.46
## 103 103 Libya CAF 1.16 1.42 39.43
## 104 104 Vietnam AFC 0.97 1.20 39.10
## 105 105 Swaziland CAF 1.04 1.29 39.02
## 106 106 Palestine AFC 1.08 1.34 38.81
## 107 107 Curacao CONCACAF 1.12 1.41 38.67
## 108 108 Suriname CONCACAF 1.19 1.51 38.32
## 109 109 Kenya CAF 1.06 1.36 38.29
## 110 110 Luxembourg UEFA 1.06 1.35 38.24
## 111 111 Guinea-Bissau CAF 1.00 1.28 38.21
## 112 112 Zimbabwe CAF 1.08 1.40 37.94
## 113 113 Armenia UEFA 1.21 1.55 37.91
## 114 114 Azerbaijan UEFA 1.01 1.32 37.75
## 115 115 Central African Republic CAF 1.23 1.59 37.67
## 116 116 Gambia CAF 0.94 1.25 37.30
## 117 117 Cuba CONCACAF 0.91 1.23 36.83
## 118 118 Nicaragua CONCACAF 1.17 1.58 36.41
## 119 119 Tanzania CAF 0.95 1.30 36.41
## 120 120 Mozambique CAF 0.93 1.30 36.07
## 121 121 Congo CAF 0.89 1.26 35.83
## 122 122 Latvia UEFA 1.18 1.63 35.63
## 123 123 Belarus UEFA 1.04 1.45 35.61
## 124 124 Thailand AFC 1.00 1.41 35.58
## 125 125 Niger CAF 1.11 1.55 35.50
## 126 126 Botswana CAF 0.80 1.17 35.16
## 127 127 Sierra Leone CAF 1.11 1.59 34.88
## 128 128 Kuwait AFC 0.94 1.42 33.97
## 129 129 Malawi CAF 0.93 1.43 33.36
## 130 130 Rwanda CAF 0.70 1.15 32.96
## 131 131 Comoros CAF 0.98 1.56 32.41
## 132 132 Faroe Islands UEFA 0.95 1.52 32.27
## 133 133 North Korea AFC 0.81 1.39 30.99
## 134 134 Sudan CAF 0.94 1.59 30.75
## 135 135 Kazakhstan UEFA 0.92 1.57 30.73
## 136 136 Moldova UEFA 0.85 1.52 29.77
## 137 137 Tajikistan AFC 0.84 1.52 29.45
## 138 138 Syria AFC 1.03 1.79 29.40
## 139 139 Cyprus UEFA 0.91 1.64 29.31
## 140 140 Malta UEFA 0.84 1.54 29.12
## 141 141 Burundi CAF 0.81 1.56 28.12
## 142 142 Liberia CAF 0.85 1.65 27.63
## 143 143 Dominican Republic CONCACAF 0.78 1.55 27.57
## 144 144 Lithuania UEFA 0.81 1.65 26.55
## 145 145 Martinique CONCACAF 0.97 1.89 26.49
## 146 146 Kyrgyzstan AFC 0.89 1.84 25.45
## 147 147 Lebanon AFC 0.64 1.51 24.74
## 148 148 Guyana CONCACAF 1.04 2.12 24.65
## 149 149 Bermuda CONCACAF 1.08 2.21 24.24
## 150 150 Puerto Rico CONCACAF 0.90 1.97 23.80
## 151 151 India AFC 0.70 1.67 23.65
## 152 152 Chad CAF 0.82 1.87 23.52
## 153 153 Solomon Islands OFC 0.79 1.91 22.28
## 154 154 Lesotho CAF 0.69 1.76 22.01
## 155 155 South Sudan CAF 0.71 1.80 21.83
## 156 156 Zanzibar CAF 0.49 1.47 21.39
## 157 157 St. Kitts and Nevis CONCACAF 0.88 2.11 21.37
## 158 158 Indonesia AFC 0.96 2.26 21.20
## 159 159 Turkmenistan AFC 0.84 2.07 21.05
## 160 160 Malaysia AFC 0.78 2.04 20.25
## 161 161 Eritrea CAF 0.79 2.10 19.77
## 162 162 Fiji OFC 0.62 1.89 18.72
## 163 163 New Caledonia OFC 0.70 2.12 17.82
## 164 164 Tahiti OFC 0.74 2.23 17.25
## 165 165 French Guiana CONCACAF 0.80 2.36 16.83
## 166 166 Montserrat CONCACAF 0.83 2.44 16.59
## 167 167 Antigua and Barbuda CONCACAF 0.74 2.31 16.35
## 168 168 Andorra UEFA 0.45 1.79 16.22
## 169 169 Grenada CONCACAF 0.67 2.21 15.99
## 170 170 Vanuatu OFC 0.65 2.21 15.71
## 171 171 St. Lucia CONCACAF 0.58 2.11 15.45
## 172 172 Sao Tome and Principe CAF 0.80 2.61 14.51
## 173 173 Hong Kong AFC 0.37 1.90 13.20
## 174 174 Belize CONCACAF 0.51 2.19 13.13
## 175 175 Barbados CONCACAF 0.49 2.17 13.05
## 176 176 Mauritius CAF 0.54 2.31 12.60
## 177 177 Guadeloupe CONCACAF 0.54 2.32 12.53
## 178 178 Singapore AFC 0.55 2.38 12.27
## 179 179 Papua New Guinea OFC 0.69 2.65 12.25
## 180 180 Gibraltar UEFA 0.52 2.38 11.70
## 181 181 Afghanistan AFC 0.59 2.59 11.12
## 182 182 Dominica CONCACAF 0.44 2.30 11.03
## 183 183 Philippines AFC 0.51 2.46 10.86
## 184 184 St. Vincent and the Grenadines CONCACAF 0.61 2.75 10.30
## 185 185 Yemen AFC 0.44 2.54 9.10
## 186 186 Somalia CAF 0.52 2.74 8.96
## 187 187 Djibouti CAF 0.75 3.33 8.45
## 188 188 Nepal AFC 0.50 2.81 8.23
## 189 189 Aruba CONCACAF 0.52 2.96 7.64
## 190 190 Seychelles CAF 0.32 2.55 7.20
## 191 191 Liechtenstein UEFA 0.33 2.69 6.56
## 192 192 Mongolia AFC 0.27 2.65 6.00
## 193 193 Maldives AFC 0.37 2.92 5.94
## 194 194 Chinese Taipei AFC 0.53 3.37 5.75
## 195 195 Myanmar AFC 0.45 3.29 5.24
## 196 196 San Marino UEFA 0.23 2.72 5.12
## 197 197 Bahamas CONCACAF 0.31 2.99 4.99
## 198 198 Bangladesh AFC 0.21 2.71 4.97
## 199 199 Cambodia AFC 0.39 3.45 4.10
## 200 200 Guam AFC 0.52 3.82 4.07
## 201 201 Cayman Islands CONCACAF 0.31 3.32 3.80
## 202 202 Bonaire CONCACAF 0.38 4.04 2.54
## 203 203 Northern Mariana Islands AFC 0.43 4.27 2.40
## 204 204 St. Martin CONCACAF 0.26 3.83 2.22
## 205 205 Sri Lanka AFC 0.24 3.84 2.05
## 206 206 Pakistan AFC 0.20 3.78 1.93
## 207 207 Anguilla CONCACAF 0.24 3.93 1.88
## 208 208 US Virgin Islands CONCACAF 0.20 4.06 1.50
## 209 209 Sint Maarten CONCACAF 0.43 4.94 1.41
## 210 210 Laos AFC 0.20 4.18 1.36
## 211 211 British Virgin Islands CONCACAF 0.26 4.51 1.26
## 212 212 Bhutan AFC 0.23 4.41 1.24
## 213 213 Brunei AFC 0.20 4.38 1.14
## 214 214 Cook Islands OFC 0.20 4.72 0.85
## 215 215 Turks and Caicos Islands CONCACAF 0.40 5.52 0.82
## 216 216 Macau AFC 0.20 4.92 0.71
## 217 217 Tuvalu OFC 0.38 5.62 0.70
## 218 218 Timor-Leste AFC 0.27 5.25 0.69
## 219 219 Samoa OFC 0.20 5.78 0.34
## 220 220 Tonga OFC 0.20 6.08 0.26soccer_data## rank name confed off def spi
## 1 1 Brazil CONMEBOL 3.13 0.29 93.08
## 2 2 Argentina CONMEBOL 2.90 0.39 90.22
## 3 3 Germany UEFA 3.44 0.69 89.75
## 4 4 France UEFA 2.98 0.53 88.66
## 5 5 England UEFA 2.74 0.43 88.26
## 6 6 Spain UEFA 2.56 0.36 87.87
## 7 7 Portugal UEFA 2.79 0.53 87.02
## 8 8 Netherlands UEFA 2.54 0.57 83.68
## 9 9 Belgium UEFA 2.51 0.63 82.32
## 10 10 Colombia CONMEBOL 2.16 0.46 81.37
## 11 11 Italy UEFA 2.29 0.59 80.35
## 12 12 Uruguay CONMEBOL 2.08 0.50 79.47
## 13 13 Croatia UEFA 2.16 0.58 78.82
## 14 14 Algeria CAF 2.12 0.58 78.21
## 15 15 Switzerland UEFA 2.22 0.67 77.65
## 16 16 Japan AFC 2.01 0.62 75.42
## 17 17 Czech Republic UEFA 2.15 0.72 75.41
## 18 18 Denmark UEFA 2.07 0.68 75.06
## 19 19 Senegal CAF 1.88 0.58 74.39
## 20 20 Canada CONCACAF 2.05 0.70 74.30
## 21 21 Serbia UEFA 2.21 0.81 74.28
## 22 22 Ecuador CONMEBOL 1.92 0.64 73.70
## 23 23 Mexico CONCACAF 1.91 0.65 73.37
## 24 24 Austria UEFA 2.15 0.84 72.83
## 25 25 Norway UEFA 2.00 0.74 72.45
## 26 26 USA CONCACAF 1.91 0.69 72.36
## 27 27 South Korea AFC 1.96 0.72 72.28
## 28 28 Morocco CAF 1.66 0.52 72.10
## 29 29 Chile CONMEBOL 1.87 0.77 69.53
## 30 30 Ukraine UEFA 1.88 0.78 69.49
## 31 31 Tunisia CAF 1.58 0.56 69.47
## 32 32 Egypt CAF 1.65 0.63 68.91
## 33 33 Sweden UEFA 2.01 0.92 68.76
## 34 34 Scotland UEFA 1.84 0.79 68.73
## 35 35 Iran AFC 1.75 0.72 68.52
## 36 36 Venezuela CONMEBOL 1.83 0.80 68.21
## 37 37 Poland UEFA 1.83 0.82 67.67
## 38 38 Peru CONMEBOL 1.76 0.79 67.17
## 39 39 Russia UEFA 1.87 0.90 66.74
## 40 40 Turkey UEFA 1.98 1.00 66.45
## 41 41 Greece UEFA 1.49 0.60 66.44
## 42 42 Ivory Coast CAF 1.62 0.76 65.04
## 43 43 Australia AFC 1.66 0.81 64.71
## 44 44 Hungary UEFA 1.69 0.84 64.46
## 45 45 Paraguay CONMEBOL 1.70 0.88 63.87
## 46 46 Nigeria CAF 1.56 0.80 62.89
## 47 47 Ireland UEFA 1.50 0.76 62.57
## 48 48 Wales UEFA 1.56 0.83 62.08
## 49 49 Cameroon CAF 1.60 0.87 62.06
## 50 50 Panama CONCACAF 1.62 0.93 60.90
## 51 51 Mali CAF 1.40 0.77 60.19
## 52 52 Basque Country UEFA 1.63 1.00 59.32
## 53 53 Bosnia and Herzegovina UEFA 1.60 0.99 58.95
## 54 54 Finland UEFA 1.56 0.97 58.64
## 55 55 Romania UEFA 1.56 1.02 57.65
## 56 56 Uzbekistan AFC 1.59 1.07 56.99
## 57 57 Georgia UEFA 1.53 1.03 56.56
## 58 58 Slovenia UEFA 1.42 0.96 55.91
## 59 59 Saudi Arabia AFC 1.53 1.06 55.91
## 60 60 New Zealand OFC 1.47 1.01 55.79
## 61 61 Bolivia CONMEBOL 1.68 1.21 55.66
## 62 62 Haiti CONCACAF 1.62 1.17 55.32
## 63 63 Ghana CAF 1.47 1.03 55.26
## 64 64 Burkina Faso CAF 1.29 0.89 54.61
## 65 65 Jamaica CONCACAF 1.48 1.07 54.44
## 66 66 Montenegro UEFA 1.30 0.91 54.18
## 67 67 Israel UEFA 1.81 1.41 54.14
## 68 68 Northern Ireland UEFA 1.38 0.99 54.06
## 69 69 Slovakia UEFA 1.41 1.02 54.01
## 70 70 Kosovo UEFA 1.60 1.23 53.44
## 71 71 North Macedonia UEFA 1.32 0.99 52.82
## 72 72 Costa Rica CONCACAF 1.37 1.04 52.71
## 73 73 Iceland UEFA 1.44 1.14 52.17
## 74 74 Oman AFC 1.25 0.95 52.01
## 75 75 Guatemala CONCACAF 1.36 1.07 51.65
## 76 76 Albania UEFA 1.17 0.91 51.00
## 77 77 Angola CAF 1.35 1.12 50.52
## 78 78 Cape Verde Islands CAF 1.13 0.89 50.50
## 79 79 Uganda CAF 1.17 0.93 50.38
## 80 80 South Africa CAF 1.25 1.03 50.19
## 81 81 Iraq AFC 1.12 0.89 50.18
## 82 82 Gabon CAF 1.20 0.99 49.75
## 83 83 Equatorial Guinea CAF 1.29 1.09 49.53
## 84 84 Congo DR CAF 1.20 1.05 48.34
## 85 85 Bahrain AFC 1.31 1.21 47.47
## 86 86 Honduras CONCACAF 1.34 1.24 47.36
## 87 87 Namibia CAF 1.12 1.03 46.96
## 88 88 Qatar AFC 1.30 1.22 46.87
## 89 89 Guinea CAF 1.22 1.15 46.75
## 90 90 Zambia CAF 1.47 1.44 46.15
## 91 91 Jordan AFC 1.12 1.07 45.92
## 92 92 El Salvador CONCACAF 1.16 1.13 45.59
## 93 93 Togo CAF 1.22 1.23 44.66
## 94 94 Bulgaria UEFA 1.23 1.30 43.51
## 95 95 United Arab Emirates AFC 1.04 1.15 42.06
## 96 96 Mauritania CAF 0.97 1.08 41.79
## 97 97 Trinidad and Tobago CONCACAF 1.03 1.17 41.37
## 98 98 Madagascar CAF 1.25 1.44 41.11
## 99 99 China AFC 1.03 1.20 40.91
## 100 100 Benin CAF 0.95 1.16 39.57
## 101 101 Estonia UEFA 1.04 1.27 39.49
## 102 102 Ethiopia CAF 1.11 1.35 39.46
## 103 103 Libya CAF 1.16 1.42 39.43
## 104 104 Vietnam AFC 0.97 1.20 39.10
## 105 105 Swaziland CAF 1.04 1.29 39.02
## 106 106 Palestine AFC 1.08 1.34 38.81
## 107 107 Curacao CONCACAF 1.12 1.41 38.67
## 108 108 Suriname CONCACAF 1.19 1.51 38.32
## 109 109 Kenya CAF 1.06 1.36 38.29
## 110 110 Luxembourg UEFA 1.06 1.35 38.24
## 111 111 Guinea-Bissau CAF 1.00 1.28 38.21
## 112 112 Zimbabwe CAF 1.08 1.40 37.94
## 113 113 Armenia UEFA 1.21 1.55 37.91
## 114 114 Azerbaijan UEFA 1.01 1.32 37.75
## 115 115 Central African Republic CAF 1.23 1.59 37.67
## 116 116 Gambia CAF 0.94 1.25 37.30
## 117 117 Cuba CONCACAF 0.91 1.23 36.83
## 118 118 Nicaragua CONCACAF 1.17 1.58 36.41
## 119 119 Tanzania CAF 0.95 1.30 36.41
## 120 120 Mozambique CAF 0.93 1.30 36.07
## 121 121 Congo CAF 0.89 1.26 35.83
## 122 122 Latvia UEFA 1.18 1.63 35.63
## 123 123 Belarus UEFA 1.04 1.45 35.61
## 124 124 Thailand AFC 1.00 1.41 35.58
## 125 125 Niger CAF 1.11 1.55 35.50
## 126 126 Botswana CAF 0.80 1.17 35.16
## 127 127 Sierra Leone CAF 1.11 1.59 34.88
## 128 128 Kuwait AFC 0.94 1.42 33.97
## 129 129 Malawi CAF 0.93 1.43 33.36
## 130 130 Rwanda CAF 0.70 1.15 32.96
## 131 131 Comoros CAF 0.98 1.56 32.41
## 132 132 Faroe Islands UEFA 0.95 1.52 32.27
## 133 133 North Korea AFC 0.81 1.39 30.99
## 134 134 Sudan CAF 0.94 1.59 30.75
## 135 135 Kazakhstan UEFA 0.92 1.57 30.73
## 136 136 Moldova UEFA 0.85 1.52 29.77
## 137 137 Tajikistan AFC 0.84 1.52 29.45
## 138 138 Syria AFC 1.03 1.79 29.40
## 139 139 Cyprus UEFA 0.91 1.64 29.31
## 140 140 Malta UEFA 0.84 1.54 29.12
## 141 141 Burundi CAF 0.81 1.56 28.12
## 142 142 Liberia CAF 0.85 1.65 27.63
## 143 143 Dominican Republic CONCACAF 0.78 1.55 27.57
## 144 144 Lithuania UEFA 0.81 1.65 26.55
## 145 145 Martinique CONCACAF 0.97 1.89 26.49
## 146 146 Kyrgyzstan AFC 0.89 1.84 25.45
## 147 147 Lebanon AFC 0.64 1.51 24.74
## 148 148 Guyana CONCACAF 1.04 2.12 24.65
## 149 149 Bermuda CONCACAF 1.08 2.21 24.24
## 150 150 Puerto Rico CONCACAF 0.90 1.97 23.80
## 151 151 India AFC 0.70 1.67 23.65
## 152 152 Chad CAF 0.82 1.87 23.52
## 153 153 Solomon Islands OFC 0.79 1.91 22.28
## 154 154 Lesotho CAF 0.69 1.76 22.01
## 155 155 South Sudan CAF 0.71 1.80 21.83
## 156 156 Zanzibar CAF 0.49 1.47 21.39
## 157 157 St. Kitts and Nevis CONCACAF 0.88 2.11 21.37
## 158 158 Indonesia AFC 0.96 2.26 21.20
## 159 159 Turkmenistan AFC 0.84 2.07 21.05
## 160 160 Malaysia AFC 0.78 2.04 20.25
## 161 161 Eritrea CAF 0.79 2.10 19.77
## 162 162 Fiji OFC 0.62 1.89 18.72
## 163 163 New Caledonia OFC 0.70 2.12 17.82
## 164 164 Tahiti OFC 0.74 2.23 17.25
## 165 165 French Guiana CONCACAF 0.80 2.36 16.83
## 166 166 Montserrat CONCACAF 0.83 2.44 16.59
## 167 167 Antigua and Barbuda CONCACAF 0.74 2.31 16.35
## 168 168 Andorra UEFA 0.45 1.79 16.22
## 169 169 Grenada CONCACAF 0.67 2.21 15.99
## 170 170 Vanuatu OFC 0.65 2.21 15.71
## 171 171 St. Lucia CONCACAF 0.58 2.11 15.45
## 172 172 Sao Tome and Principe CAF 0.80 2.61 14.51
## 173 173 Hong Kong AFC 0.37 1.90 13.20
## 174 174 Belize CONCACAF 0.51 2.19 13.13
## 175 175 Barbados CONCACAF 0.49 2.17 13.05
## 176 176 Mauritius CAF 0.54 2.31 12.60
## 177 177 Guadeloupe CONCACAF 0.54 2.32 12.53
## 178 178 Singapore AFC 0.55 2.38 12.27
## 179 179 Papua New Guinea OFC 0.69 2.65 12.25
## 180 180 Gibraltar UEFA 0.52 2.38 11.70
## 181 181 Afghanistan AFC 0.59 2.59 11.12
## 182 182 Dominica CONCACAF 0.44 2.30 11.03
## 183 183 Philippines AFC 0.51 2.46 10.86
## 184 184 St. Vincent and the Grenadines CONCACAF 0.61 2.75 10.30
## 185 185 Yemen AFC 0.44 2.54 9.10
## 186 186 Somalia CAF 0.52 2.74 8.96
## 187 187 Djibouti CAF 0.75 3.33 8.45
## 188 188 Nepal AFC 0.50 2.81 8.23
## 189 189 Aruba CONCACAF 0.52 2.96 7.64
## 190 190 Seychelles CAF 0.32 2.55 7.20
## 191 191 Liechtenstein UEFA 0.33 2.69 6.56
## 192 192 Mongolia AFC 0.27 2.65 6.00
## 193 193 Maldives AFC 0.37 2.92 5.94
## 194 194 Chinese Taipei AFC 0.53 3.37 5.75
## 195 195 Myanmar AFC 0.45 3.29 5.24
## 196 196 San Marino UEFA 0.23 2.72 5.12
## 197 197 Bahamas CONCACAF 0.31 2.99 4.99
## 198 198 Bangladesh AFC 0.21 2.71 4.97
## 199 199 Cambodia AFC 0.39 3.45 4.10
## 200 200 Guam AFC 0.52 3.82 4.07
## 201 201 Cayman Islands CONCACAF 0.31 3.32 3.80
## 202 202 Bonaire CONCACAF 0.38 4.04 2.54
## 203 203 Northern Mariana Islands AFC 0.43 4.27 2.40
## 204 204 St. Martin CONCACAF 0.26 3.83 2.22
## 205 205 Sri Lanka AFC 0.24 3.84 2.05
## 206 206 Pakistan AFC 0.20 3.78 1.93
## 207 207 Anguilla CONCACAF 0.24 3.93 1.88
## 208 208 US Virgin Islands CONCACAF 0.20 4.06 1.50
## 209 209 Sint Maarten CONCACAF 0.43 4.94 1.41
## 210 210 Laos AFC 0.20 4.18 1.36
## 211 211 British Virgin Islands CONCACAF 0.26 4.51 1.26
## 212 212 Bhutan AFC 0.23 4.41 1.24
## 213 213 Brunei AFC 0.20 4.38 1.14
## 214 214 Cook Islands OFC 0.20 4.72 0.85
## 215 215 Turks and Caicos Islands CONCACAF 0.40 5.52 0.82
## 216 216 Macau AFC 0.20 4.92 0.71
## 217 217 Tuvalu OFC 0.38 5.62 0.70
## 218 218 Timor-Leste AFC 0.27 5.25 0.69
## 219 219 Samoa OFC 0.20 5.78 0.34
## 220 220 Tonga OFC 0.20 6.08 0.26Display countries with highest scores using slice function in dplyr, and display results using a kable extra table
top_10 <- soccer_data |>
slice_max(spi, n = 10)
kable(top_10)| rank | name | confed | off | def | spi |
|---|---|---|---|---|---|
| 1 | Brazil | CONMEBOL | 3.13 | 0.29 | 93.08 |
| 2 | Argentina | CONMEBOL | 2.90 | 0.39 | 90.22 |
| 3 | Germany | UEFA | 3.44 | 0.69 | 89.75 |
| 4 | France | UEFA | 2.98 | 0.53 | 88.66 |
| 5 | England | UEFA | 2.74 | 0.43 | 88.26 |
| 6 | Spain | UEFA | 2.56 | 0.36 | 87.87 |
| 7 | Portugal | UEFA | 2.79 | 0.53 | 87.02 |
| 8 | Netherlands | UEFA | 2.54 | 0.57 | 83.68 |
| 9 | Belgium | UEFA | 2.51 | 0.63 | 82.32 |
| 10 | Colombia | CONMEBOL | 2.16 | 0.46 | 81.37 |
Remove NA’s values from rows using the drop_na function from tidyr
soccer_data <- soccer_data %>% drop_na()
print(soccer_data)## rank name confed off def spi
## 1 1 Brazil CONMEBOL 3.13 0.29 93.08
## 2 2 Argentina CONMEBOL 2.90 0.39 90.22
## 3 3 Germany UEFA 3.44 0.69 89.75
## 4 4 France UEFA 2.98 0.53 88.66
## 5 5 England UEFA 2.74 0.43 88.26
## 6 6 Spain UEFA 2.56 0.36 87.87
## 7 7 Portugal UEFA 2.79 0.53 87.02
## 8 8 Netherlands UEFA 2.54 0.57 83.68
## 9 9 Belgium UEFA 2.51 0.63 82.32
## 10 10 Colombia CONMEBOL 2.16 0.46 81.37
## 11 11 Italy UEFA 2.29 0.59 80.35
## 12 12 Uruguay CONMEBOL 2.08 0.50 79.47
## 13 13 Croatia UEFA 2.16 0.58 78.82
## 14 14 Algeria CAF 2.12 0.58 78.21
## 15 15 Switzerland UEFA 2.22 0.67 77.65
## 16 16 Japan AFC 2.01 0.62 75.42
## 17 17 Czech Republic UEFA 2.15 0.72 75.41
## 18 18 Denmark UEFA 2.07 0.68 75.06
## 19 19 Senegal CAF 1.88 0.58 74.39
## 20 20 Canada CONCACAF 2.05 0.70 74.30
## 21 21 Serbia UEFA 2.21 0.81 74.28
## 22 22 Ecuador CONMEBOL 1.92 0.64 73.70
## 23 23 Mexico CONCACAF 1.91 0.65 73.37
## 24 24 Austria UEFA 2.15 0.84 72.83
## 25 25 Norway UEFA 2.00 0.74 72.45
## 26 26 USA CONCACAF 1.91 0.69 72.36
## 27 27 South Korea AFC 1.96 0.72 72.28
## 28 28 Morocco CAF 1.66 0.52 72.10
## 29 29 Chile CONMEBOL 1.87 0.77 69.53
## 30 30 Ukraine UEFA 1.88 0.78 69.49
## 31 31 Tunisia CAF 1.58 0.56 69.47
## 32 32 Egypt CAF 1.65 0.63 68.91
## 33 33 Sweden UEFA 2.01 0.92 68.76
## 34 34 Scotland UEFA 1.84 0.79 68.73
## 35 35 Iran AFC 1.75 0.72 68.52
## 36 36 Venezuela CONMEBOL 1.83 0.80 68.21
## 37 37 Poland UEFA 1.83 0.82 67.67
## 38 38 Peru CONMEBOL 1.76 0.79 67.17
## 39 39 Russia UEFA 1.87 0.90 66.74
## 40 40 Turkey UEFA 1.98 1.00 66.45
## 41 41 Greece UEFA 1.49 0.60 66.44
## 42 42 Ivory Coast CAF 1.62 0.76 65.04
## 43 43 Australia AFC 1.66 0.81 64.71
## 44 44 Hungary UEFA 1.69 0.84 64.46
## 45 45 Paraguay CONMEBOL 1.70 0.88 63.87
## 46 46 Nigeria CAF 1.56 0.80 62.89
## 47 47 Ireland UEFA 1.50 0.76 62.57
## 48 48 Wales UEFA 1.56 0.83 62.08
## 49 49 Cameroon CAF 1.60 0.87 62.06
## 50 50 Panama CONCACAF 1.62 0.93 60.90
## 51 51 Mali CAF 1.40 0.77 60.19
## 52 52 Basque Country UEFA 1.63 1.00 59.32
## 53 53 Bosnia and Herzegovina UEFA 1.60 0.99 58.95
## 54 54 Finland UEFA 1.56 0.97 58.64
## 55 55 Romania UEFA 1.56 1.02 57.65
## 56 56 Uzbekistan AFC 1.59 1.07 56.99
## 57 57 Georgia UEFA 1.53 1.03 56.56
## 58 58 Slovenia UEFA 1.42 0.96 55.91
## 59 59 Saudi Arabia AFC 1.53 1.06 55.91
## 60 60 New Zealand OFC 1.47 1.01 55.79
## 61 61 Bolivia CONMEBOL 1.68 1.21 55.66
## 62 62 Haiti CONCACAF 1.62 1.17 55.32
## 63 63 Ghana CAF 1.47 1.03 55.26
## 64 64 Burkina Faso CAF 1.29 0.89 54.61
## 65 65 Jamaica CONCACAF 1.48 1.07 54.44
## 66 66 Montenegro UEFA 1.30 0.91 54.18
## 67 67 Israel UEFA 1.81 1.41 54.14
## 68 68 Northern Ireland UEFA 1.38 0.99 54.06
## 69 69 Slovakia UEFA 1.41 1.02 54.01
## 70 70 Kosovo UEFA 1.60 1.23 53.44
## 71 71 North Macedonia UEFA 1.32 0.99 52.82
## 72 72 Costa Rica CONCACAF 1.37 1.04 52.71
## 73 73 Iceland UEFA 1.44 1.14 52.17
## 74 74 Oman AFC 1.25 0.95 52.01
## 75 75 Guatemala CONCACAF 1.36 1.07 51.65
## 76 76 Albania UEFA 1.17 0.91 51.00
## 77 77 Angola CAF 1.35 1.12 50.52
## 78 78 Cape Verde Islands CAF 1.13 0.89 50.50
## 79 79 Uganda CAF 1.17 0.93 50.38
## 80 80 South Africa CAF 1.25 1.03 50.19
## 81 81 Iraq AFC 1.12 0.89 50.18
## 82 82 Gabon CAF 1.20 0.99 49.75
## 83 83 Equatorial Guinea CAF 1.29 1.09 49.53
## 84 84 Congo DR CAF 1.20 1.05 48.34
## 85 85 Bahrain AFC 1.31 1.21 47.47
## 86 86 Honduras CONCACAF 1.34 1.24 47.36
## 87 87 Namibia CAF 1.12 1.03 46.96
## 88 88 Qatar AFC 1.30 1.22 46.87
## 89 89 Guinea CAF 1.22 1.15 46.75
## 90 90 Zambia CAF 1.47 1.44 46.15
## 91 91 Jordan AFC 1.12 1.07 45.92
## 92 92 El Salvador CONCACAF 1.16 1.13 45.59
## 93 93 Togo CAF 1.22 1.23 44.66
## 94 94 Bulgaria UEFA 1.23 1.30 43.51
## 95 95 United Arab Emirates AFC 1.04 1.15 42.06
## 96 96 Mauritania CAF 0.97 1.08 41.79
## 97 97 Trinidad and Tobago CONCACAF 1.03 1.17 41.37
## 98 98 Madagascar CAF 1.25 1.44 41.11
## 99 99 China AFC 1.03 1.20 40.91
## 100 100 Benin CAF 0.95 1.16 39.57
## 101 101 Estonia UEFA 1.04 1.27 39.49
## 102 102 Ethiopia CAF 1.11 1.35 39.46
## 103 103 Libya CAF 1.16 1.42 39.43
## 104 104 Vietnam AFC 0.97 1.20 39.10
## 105 105 Swaziland CAF 1.04 1.29 39.02
## 106 106 Palestine AFC 1.08 1.34 38.81
## 107 107 Curacao CONCACAF 1.12 1.41 38.67
## 108 108 Suriname CONCACAF 1.19 1.51 38.32
## 109 109 Kenya CAF 1.06 1.36 38.29
## 110 110 Luxembourg UEFA 1.06 1.35 38.24
## 111 111 Guinea-Bissau CAF 1.00 1.28 38.21
## 112 112 Zimbabwe CAF 1.08 1.40 37.94
## 113 113 Armenia UEFA 1.21 1.55 37.91
## 114 114 Azerbaijan UEFA 1.01 1.32 37.75
## 115 115 Central African Republic CAF 1.23 1.59 37.67
## 116 116 Gambia CAF 0.94 1.25 37.30
## 117 117 Cuba CONCACAF 0.91 1.23 36.83
## 118 118 Nicaragua CONCACAF 1.17 1.58 36.41
## 119 119 Tanzania CAF 0.95 1.30 36.41
## 120 120 Mozambique CAF 0.93 1.30 36.07
## 121 121 Congo CAF 0.89 1.26 35.83
## 122 122 Latvia UEFA 1.18 1.63 35.63
## 123 123 Belarus UEFA 1.04 1.45 35.61
## 124 124 Thailand AFC 1.00 1.41 35.58
## 125 125 Niger CAF 1.11 1.55 35.50
## 126 126 Botswana CAF 0.80 1.17 35.16
## 127 127 Sierra Leone CAF 1.11 1.59 34.88
## 128 128 Kuwait AFC 0.94 1.42 33.97
## 129 129 Malawi CAF 0.93 1.43 33.36
## 130 130 Rwanda CAF 0.70 1.15 32.96
## 131 131 Comoros CAF 0.98 1.56 32.41
## 132 132 Faroe Islands UEFA 0.95 1.52 32.27
## 133 133 North Korea AFC 0.81 1.39 30.99
## 134 134 Sudan CAF 0.94 1.59 30.75
## 135 135 Kazakhstan UEFA 0.92 1.57 30.73
## 136 136 Moldova UEFA 0.85 1.52 29.77
## 137 137 Tajikistan AFC 0.84 1.52 29.45
## 138 138 Syria AFC 1.03 1.79 29.40
## 139 139 Cyprus UEFA 0.91 1.64 29.31
## 140 140 Malta UEFA 0.84 1.54 29.12
## 141 141 Burundi CAF 0.81 1.56 28.12
## 142 142 Liberia CAF 0.85 1.65 27.63
## 143 143 Dominican Republic CONCACAF 0.78 1.55 27.57
## 144 144 Lithuania UEFA 0.81 1.65 26.55
## 145 145 Martinique CONCACAF 0.97 1.89 26.49
## 146 146 Kyrgyzstan AFC 0.89 1.84 25.45
## 147 147 Lebanon AFC 0.64 1.51 24.74
## 148 148 Guyana CONCACAF 1.04 2.12 24.65
## 149 149 Bermuda CONCACAF 1.08 2.21 24.24
## 150 150 Puerto Rico CONCACAF 0.90 1.97 23.80
## 151 151 India AFC 0.70 1.67 23.65
## 152 152 Chad CAF 0.82 1.87 23.52
## 153 153 Solomon Islands OFC 0.79 1.91 22.28
## 154 154 Lesotho CAF 0.69 1.76 22.01
## 155 155 South Sudan CAF 0.71 1.80 21.83
## 156 156 Zanzibar CAF 0.49 1.47 21.39
## 157 157 St. Kitts and Nevis CONCACAF 0.88 2.11 21.37
## 158 158 Indonesia AFC 0.96 2.26 21.20
## 159 159 Turkmenistan AFC 0.84 2.07 21.05
## 160 160 Malaysia AFC 0.78 2.04 20.25
## 161 161 Eritrea CAF 0.79 2.10 19.77
## 162 162 Fiji OFC 0.62 1.89 18.72
## 163 163 New Caledonia OFC 0.70 2.12 17.82
## 164 164 Tahiti OFC 0.74 2.23 17.25
## 165 165 French Guiana CONCACAF 0.80 2.36 16.83
## 166 166 Montserrat CONCACAF 0.83 2.44 16.59
## 167 167 Antigua and Barbuda CONCACAF 0.74 2.31 16.35
## 168 168 Andorra UEFA 0.45 1.79 16.22
## 169 169 Grenada CONCACAF 0.67 2.21 15.99
## 170 170 Vanuatu OFC 0.65 2.21 15.71
## 171 171 St. Lucia CONCACAF 0.58 2.11 15.45
## 172 172 Sao Tome and Principe CAF 0.80 2.61 14.51
## 173 173 Hong Kong AFC 0.37 1.90 13.20
## 174 174 Belize CONCACAF 0.51 2.19 13.13
## 175 175 Barbados CONCACAF 0.49 2.17 13.05
## 176 176 Mauritius CAF 0.54 2.31 12.60
## 177 177 Guadeloupe CONCACAF 0.54 2.32 12.53
## 178 178 Singapore AFC 0.55 2.38 12.27
## 179 179 Papua New Guinea OFC 0.69 2.65 12.25
## 180 180 Gibraltar UEFA 0.52 2.38 11.70
## 181 181 Afghanistan AFC 0.59 2.59 11.12
## 182 182 Dominica CONCACAF 0.44 2.30 11.03
## 183 183 Philippines AFC 0.51 2.46 10.86
## 184 184 St. Vincent and the Grenadines CONCACAF 0.61 2.75 10.30
## 185 185 Yemen AFC 0.44 2.54 9.10
## 186 186 Somalia CAF 0.52 2.74 8.96
## 187 187 Djibouti CAF 0.75 3.33 8.45
## 188 188 Nepal AFC 0.50 2.81 8.23
## 189 189 Aruba CONCACAF 0.52 2.96 7.64
## 190 190 Seychelles CAF 0.32 2.55 7.20
## 191 191 Liechtenstein UEFA 0.33 2.69 6.56
## 192 192 Mongolia AFC 0.27 2.65 6.00
## 193 193 Maldives AFC 0.37 2.92 5.94
## 194 194 Chinese Taipei AFC 0.53 3.37 5.75
## 195 195 Myanmar AFC 0.45 3.29 5.24
## 196 196 San Marino UEFA 0.23 2.72 5.12
## 197 197 Bahamas CONCACAF 0.31 2.99 4.99
## 198 198 Bangladesh AFC 0.21 2.71 4.97
## 199 199 Cambodia AFC 0.39 3.45 4.10
## 200 200 Guam AFC 0.52 3.82 4.07
## 201 201 Cayman Islands CONCACAF 0.31 3.32 3.80
## 202 202 Bonaire CONCACAF 0.38 4.04 2.54
## 203 203 Northern Mariana Islands AFC 0.43 4.27 2.40
## 204 204 St. Martin CONCACAF 0.26 3.83 2.22
## 205 205 Sri Lanka AFC 0.24 3.84 2.05
## 206 206 Pakistan AFC 0.20 3.78 1.93
## 207 207 Anguilla CONCACAF 0.24 3.93 1.88
## 208 208 US Virgin Islands CONCACAF 0.20 4.06 1.50
## 209 209 Sint Maarten CONCACAF 0.43 4.94 1.41
## 210 210 Laos AFC 0.20 4.18 1.36
## 211 211 British Virgin Islands CONCACAF 0.26 4.51 1.26
## 212 212 Bhutan AFC 0.23 4.41 1.24
## 213 213 Brunei AFC 0.20 4.38 1.14
## 214 214 Cook Islands OFC 0.20 4.72 0.85
## 215 215 Turks and Caicos Islands CONCACAF 0.40 5.52 0.82
## 216 216 Macau AFC 0.20 4.92 0.71
## 217 217 Tuvalu OFC 0.38 5.62 0.70
## 218 218 Timor-Leste AFC 0.27 5.25 0.69
## 219 219 Samoa OFC 0.20 5.78 0.34
## 220 220 Tonga OFC 0.20 6.08 0.26Get the dimensions of dataframe using the dim function
dim(soccer_data)## [1] 220 6Get the mean, median and quantile of the columns.
soccer_data %>%
summarise (Mean = mean(soccer_data$off), Median = median(soccer_data$def), Quant = quantile(soccer_data$spi))## Warning: Returning more (or less) than 1 row per `summarise()` group was deprecated in
## dplyr 1.1.0.
## ℹ Please use `reframe()` instead.
## ℹ When switching from `summarise()` to `reframe()`, remember that `reframe()`
## always returns an ungrouped data frame and adjust accordingly.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.## Mean Median Quant
## 1 1.147 1.345 0.260
## 2 1.147 1.345 16.770
## 3 1.147 1.345 38.225
## 4 1.147 1.345 57.155
## 5 1.147 1.345 93.080Use ggplot to visualize some stats,
plot(soccer_data$def, soccer_data$off, main="defense vs offense")
Use ggplot to create a boxplot
boxplot(off~def,data = soccer_data,
main="Boxplot of soccer table",
xlab="offense",ylab="defense")
Conclussion
I was able to obtain the data from a fivethirtyeight.com and create a vignette to demostrate how to use a few capabilities of tidyverse packages, I use some functions of dplyr, tidyr, ggplot, and kable.