Input files :“Summer Olympic Games Medals.csv” and “Winter Olympic Games Medals.csv” from https://github.com/ZIXIANNOW/DATA607project2/tree/main
txturl <- "https://raw.githubusercontent.com/ZIXIANNOW/DATA607project2/main/Summer%20Olympic%20Games%20Medals.csv"
rawdata3 <- read.csv(txturl, header = TRUE)
summerdata <- rawdata3[-1]
summerdata## Team Summer.Olympic.Games
## 1 Afghanistan (AFG) 15
## 2 Algeria (ALG) 14
## 3 Argentina (ARG) 25
## 4 Armenia (ARM) 7
## 5 Australasia (ANZ) [ANZ] 2
## 6 Australia (AUS) [AUS][Z] 27
## 7 Austria (AUT) 28
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 17
## 10 Bahrain (BRN) 10
## 11 Barbados (BAR) [BAR] 13
## 12 Belarus (BLR) 7
## 13 Belgium (BEL) 27
## 14 Bermuda (BER) 19
## 15 Bohemia (BOH) [BOH][Z] 3
## 16 Botswana (BOT) 11
## 17 Brazil (BRA) 23
## 18 British West Indies (BWI) [BWI] 1
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 10
## 21 Burundi (BDI) 7
## 22 Cameroon (CMR) 15
## 23 Canada (CAN) 27
## 24 Chile (CHI) [I] 24
## 25 China (CHN) [CHN] 11
## 26 Colombia (COL) 20
## 27 Costa Rica (CRC) 16
## 28 Ivory Coast (CIV) [CIV] 14
## 29 Croatia (CRO) 8
## 30 Cuba (CUB) [Z] 21
## 31 Cyprus (CYP) 11
## 32 Czech Republic (CZE) [CZE] 7
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 28
## 35 Djibouti (DJI) [B] 9
## 36 Dominican Republic (DOM) 15
## 37 Ecuador (ECU) 15
## 38 Egypt (EGY) [EGY][Z] 23
## 39 Eritrea (ERI) 6
## 40 Estonia (EST) 13
## 41 Ethiopia (ETH) 14
## 42 Fiji (FIJ) 15
## 43 Finland (FIN) 26
## 44 France (FRA) [O][P][Z] 29
## 45 Gabon (GAB) 11
## 46 Georgia (GEO) 7
## 47 Germany (GER) [GER][Z] 17
## 48 United Team of Germany (EUA) [EUA] 3
## 49 East Germany (GDR) [GDR] 5
## 50 West Germany (FRG) [FRG] 5
## 51 Ghana (GHA) [GHA] 15
## 52 Great Britain (GBR) [GBR][Z] 29
## 53 Greece (GRE) 29
## 54 Grenada (GRN) 10
## 55 Guatemala (GUA) 15
## 56 Guyana (GUY) [GUY] 18
## 57 Haiti (HAI) [J] 16
## 58 Hong Kong (HKG) [HKG] 17
## 59 Hungary (HUN) 27
## 60 Iceland (ISL) 21
## 61 India (IND) [F] 25
## 62 Indonesia (INA) 16
## 63 Iran (IRI) [K] 17
## 64 Iraq (IRQ) 15
## 65 Ireland (IRL) 22
## 66 Israel (ISR) 17
## 67 Italy (ITA) [M][S] 28
## 68 Jamaica (JAM) [JAM] 18
## 69 Japan (JPN) 23
## 70 Jordan (JOR) 11
## 71 Kazakhstan (KAZ) 7
## 72 Kenya (KEN) 15
## 73 Kosovo (KOS) 2
## 74 North Korea (PRK) 10
## 75 South Korea (KOR) 18
## 76 Kuwait (KUW) 13
## 77 Kyrgyzstan (KGZ) 7
## 78 Latvia (LAT) 12
## 79 Lebanon (LBN) 18
## 80 Liechtenstein (LIE) 18
## 81 Lithuania (LTU) 10
## 82 Luxembourg (LUX) [O] 25
## 83 Malaysia (MAS) [MAS] 14
## 84 Mauritius (MRI) 10
## 85 Mexico (MEX) 24
## 86 Moldova (MDA) 7
## 87 Mongolia (MGL) 14
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 15
## 90 Mozambique (MOZ) 11
## 91 Namibia (NAM) 8
## 92 Netherlands (NED) [Z] 27
## 93 Netherlands Antilles (AHO) [AHO][I] 13
## 94 New Zealand (NZL) [NZL] 24
## 95 Niger (NIG) 13
## 96 Nigeria (NGR) 17
## 97 North Macedonia (MKD) 7
## 98 Norway (NOR) [Q] 27
## 99 Pakistan (PAK) 18
## 100 Panama (PAN) 18
## 101 Paraguay (PAR) 13
## 102 Peru (PER) [L] 19
## 103 Philippines (PHI) 22
## 104 Poland (POL) 22
## 105 Portugal (POR) 25
## 106 Puerto Rico (PUR) 19
## 107 Qatar (QAT) 10
## 108 Romania (ROU) 22
## 109 Russia (RUS) [RUS] 6
## 110 Russian Empire (RU1) [RU1] 3
## 111 Soviet Union (URS) [URS] 9
## 112 Unified Team (EUN) [EUN] 1
## 113 Olympic Athletes from Russia (OAR) [OAR] 0
## 114 ROC (ROC) [ROC] 1
## 115 San Marino (SMR) 15
## 116 Saudi Arabia (KSA) 12
## 117 Samoa (SAM) 10
## 118 Senegal (SEN) 15
## 119 Serbia (SRB) [SRB] 5
## 120 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 121 Singapore (SGP) 17
## 122 Slovakia (SVK) [SVK] 7
## 123 Slovenia (SLO) 8
## 124 South Africa (RSA) 20
## 125 Spain (ESP) [Z] 24
## 126 Sri Lanka (SRI) [SRI] 18
## 127 Sudan (SUD) 13
## 128 Suriname (SUR) [E] 13
## 129 Sweden (SWE) [Z] 28
## 130 Switzerland (SUI) 29
## 131 Syria (SYR) 14
## 132 Chinese Taipei (TPE) [TPE][TPE2] 15
## 133 Tajikistan (TJK) 7
## 134 Tanzania (TAN) [TAN] 14
## 135 Thailand (THA) 17
## 136 Togo (TOG) 11
## 137 Tonga (TGA) 10
## 138 Trinidad and Tobago (TTO) [TTO] 18
## 139 Tunisia (TUN) 15
## 140 Turkey (TUR) 23
## 141 Turkmenistan (TKM) 7
## 142 Uganda (UGA) 16
## 143 Ukraine (UKR) 7
## 144 United Arab Emirates (UAE) 10
## 145 United States (USA) [P][Q][R][Z][F] 28
## 146 Uruguay (URU) 22
## 147 Uzbekistan (UZB) 7
## 148 Venezuela (VEN) 19
## 149 Vietnam (VIE) 16
## 150 Virgin Islands (ISV) 13
## 151 Yugoslavia (YUG) [YUG to 1992] 16
## 152 Zambia (ZAM) [ZAM] 14
## 153 Zimbabwe (ZIM) [ZIM] 14
## 154 Independent Olympic Athletes (IOA) [IOA] 3
## 155 Independent Olympic Participants (IOP) [IOP] 1
## 156 Mixed team (ZZX) [ZZX] 3
## Summer.Olympic.Games.1 Summer.Olympic.Games.2 Summer.Olympic.Games.3
## 1 0 0 2
## 2 5 4 8
## 3 21 26 30
## 4 2 8 8
## 5 3 4 5
## 6 164 173 210
## 7 20 35 41
## 8 7 14 28
## 9 8 2 6
## 10 2 2 0
## 11 0 0 1
## 12 13 30 42
## 13 44 56 57
## 14 1 0 1
## 15 0 1 3
## 16 0 1 1
## 17 37 42 71
## 18 0 0 2
## 19 54 88 82
## 20 0 0 1
## 21 1 1 0
## 22 3 1 2
## 23 71 110 145
## 24 2 7 4
## 25 263 199 174
## 26 5 13 16
## 27 1 1 2
## 28 1 1 2
## 29 14 13 14
## 30 84 69 82
## 31 0 1 0
## 32 19 22 26
## 33 49 49 45
## 34 48 78 79
## 35 0 0 1
## 36 3 5 4
## 37 3 2 0
## 38 8 11 19
## 39 0 0 1
## 40 10 9 17
## 41 23 12 23
## 42 2 0 1
## 43 101 85 119
## 44 223 251 277
## 45 0 1 0
## 46 10 12 18
## 47 201 207 247
## 48 28 54 36
## 49 153 129 127
## 50 56 67 81
## 51 0 1 4
## 52 284 318 314
## 53 35 45 41
## 54 1 1 1
## 55 0 1 0
## 56 0 0 1
## 57 0 1 1
## 58 2 3 4
## 59 181 154 176
## 60 0 2 2
## 61 10 9 16
## 62 8 14 15
## 63 24 23 29
## 64 0 0 1
## 65 11 10 14
## 66 3 1 9
## 67 217 188 213
## 68 26 36 26
## 69 169 150 178
## 70 1 1 1
## 71 14 22 35
## 72 35 42 36
## 73 3 0 0
## 74 16 16 23
## 75 96 91 100
## 76 0 0 3
## 77 0 3 4
## 78 4 11 6
## 79 0 2 2
## 80 0 0 0
## 81 6 7 13
## 82 2 1 0
## 83 0 8 5
## 84 0 0 1
## 85 13 24 35
## 86 0 2 4
## 87 2 11 17
## 88 0 1 0
## 89 7 5 12
## 90 1 0 1
## 91 0 5 0
## 92 95 105 122
## 93 0 1 0
## 94 53 33 51
## 95 0 1 1
## 96 3 11 13
## 97 0 1 1
## 98 61 52 50
## 99 3 3 4
## 100 1 0 2
## 101 0 1 0
## 102 1 3 0
## 103 1 5 8
## 104 72 89 137
## 105 5 9 14
## 106 2 2 6
## 107 2 2 4
## 108 90 97 121
## 109 147 126 151
## 110 1 4 3
## 111 395 319 296
## 112 45 38 29
## 113 0 0 0
## 114 20 28 23
## 115 0 1 2
## 116 0 2 2
## 117 0 1 0
## 118 0 1 0
## 119 6 7 11
## 120 2 4 3
## 121 1 2 2
## 122 10 14 8
## 123 8 9 11
## 124 27 33 29
## 125 48 72 49
## 126 0 2 0
## 127 0 1 0
## 128 1 0 1
## 129 147 177 179
## 130 53 79 74
## 131 1 1 2
## 132 7 11 18
## 133 1 1 2
## 134 0 2 0
## 135 10 8 17
## 136 0 0 1
## 137 0 1 0
## 138 3 5 11
## 139 5 3 7
## 140 41 26 36
## 141 0 1 0
## 142 4 4 3
## 143 35 36 68
## 144 1 0 1
## 145 1,061 830 738
## 146 2 2 6
## 147 10 6 20
## 148 3 7 9
## 149 1 3 1
## 150 0 1 0
## 151 26 29 28
## 152 0 1 1
## 153 3 4 1
## 154 1 0 1
## 155 0 1 2
## 156 11 6 8
## Summer.Olympic.Games.4
## 1 2
## 2 17
## 3 77
## 4 18
## 5 12
## 6 547
## 7 96
## 8 49
## 9 16
## 10 4
## 11 1
## 12 85
## 13 157
## 14 2
## 15 4
## 16 2
## 17 150
## 18 2
## 19 224
## 20 1
## 21 2
## 22 6
## 23 326
## 24 13
## 25 636
## 26 34
## 27 4
## 28 4
## 29 41
## 30 235
## 31 1
## 32 67
## 33 143
## 34 205
## 35 1
## 36 12
## 37 5
## 38 38
## 39 1
## 40 36
## 41 58
## 42 3
## 43 305
## 44 751
## 45 1
## 46 40
## 47 655
## 48 118
## 49 409
## 50 204
## 51 5
## 52 916
## 53 121
## 54 3
## 55 1
## 56 1
## 57 2
## 58 9
## 59 511
## 60 4
## 61 35
## 62 37
## 63 76
## 64 1
## 65 35
## 66 13
## 67 618
## 68 88
## 69 497
## 70 3
## 71 71
## 72 113
## 73 3
## 74 55
## 75 287
## 76 3
## 77 7
## 78 21
## 79 4
## 80 0
## 81 26
## 82 3
## 83 13
## 84 1
## 85 72
## 86 6
## 87 30
## 88 1
## 89 24
## 90 2
## 91 5
## 92 322
## 93 1
## 94 137
## 95 2
## 96 27
## 97 2
## 98 163
## 99 10
## 100 3
## 101 1
## 102 4
## 103 14
## 104 298
## 105 28
## 106 10
## 107 8
## 108 308
## 109 424
## 110 8
## 111 1,010
## 112 112
## 113 0
## 114 71
## 115 3
## 116 4
## 117 1
## 118 1
## 119 24
## 120 9
## 121 5
## 122 32
## 123 28
## 124 89
## 125 169
## 126 2
## 127 1
## 128 2
## 129 503
## 130 206
## 131 4
## 132 36
## 133 4
## 134 2
## 135 35
## 136 1
## 137 1
## 138 19
## 139 15
## 140 103
## 141 1
## 142 11
## 143 139
## 144 2
## 145 2,629
## 146 10
## 147 36
## 148 19
## 149 5
## 150 1
## 151 83
## 152 2
## 153 8
## 154 2
## 155 3
## 156 25txturl1 <- "https://raw.githubusercontent.com/ZIXIANNOW/DATA607project2/main/Winter%20Olympic%20Games%20Medals.csv"
rawdata4 <- read.csv(txturl1, header = TRUE)
winterdata <- rawdata4[-1]
winterdata## Team Winter.Olympic.Games
## 1 Afghanistan (AFG) 0
## 2 Algeria (ALG) 3
## 3 Argentina (ARG) 20
## 4 Armenia (ARM) 8
## 5 Australasia (ANZ) [ANZ] 0
## 6 Australia (AUS) [AUS][Z] 20
## 7 Austria (AUT) 24
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 0
## 10 Bahrain (BRN) 0
## 11 Barbados (BAR) [BAR] 0
## 12 Belarus (BLR) 8
## 13 Belgium (BEL) 22
## 14 Bermuda (BER) 8
## 15 Bohemia (BOH) [BOH][Z] 0
## 16 Botswana (BOT) 0
## 17 Brazil (BRA) 9
## 18 British West Indies (BWI) [BWI] 0
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 0
## 21 Burundi (BDI) 0
## 22 Cameroon (CMR) 1
## 23 Canada (CAN) 24
## 24 Chile (CHI) [I] 18
## 25 China (CHN) [CHN] 12
## 26 Colombia (COL) 3
## 27 Costa Rica (CRC) 6
## 28 Ivory Coast (CIV) [CIV] 0
## 29 Croatia (CRO) 9
## 30 Cuba (CUB) [Z] 0
## 31 Cyprus (CYP) 12
## 32 Czech Republic (CZE) [CZE] 8
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 15
## 35 Djibouti (DJI) [B] 0
## 36 Dominican Republic (DOM) 0
## 37 Ecuador (ECU) 2
## 38 Egypt (EGY) [EGY][Z] 1
## 39 Eritrea (ERI) 2
## 40 Estonia (EST) 11
## 41 Ethiopia (ETH) 2
## 42 Fiji (FIJ) 3
## 43 Finland (FIN) 24
## 44 France (FRA) [O][P][Z] 24
## 45 Gabon (GAB) 0
## 46 Georgia (GEO) 8
## 47 Germany (GER) [GER][Z] 13
## 48 United Team of Germany (EUA) [EUA] 3
## 49 East Germany (GDR) [GDR] 6
## 50 West Germany (FRG) [FRG] 6
## 51 Ghana (GHA) [GHA] 3
## 52 Great Britain (GBR) [GBR][Z] 24
## 53 Greece (GRE) 20
## 54 Grenada (GRN) 0
## 55 Guatemala (GUA) 1
## 56 Guyana (GUY) [GUY] 0
## 57 Haiti (HAI) [J] 1
## 58 Hong Kong (HKG) [HKG] 6
## 59 Hungary (HUN) 24
## 60 Iceland (ISL) 19
## 61 India (IND) [F] 11
## 62 Indonesia (INA) 0
## 63 Iran (IRI) [K] 12
## 64 Iraq (IRQ) 0
## 65 Ireland (IRL) 8
## 66 Israel (ISR) 8
## 67 Italy (ITA) [M][S] 24
## 68 Jamaica (JAM) [JAM] 9
## 69 Japan (JPN) 22
## 70 Jordan (JOR) 0
## 71 Kazakhstan (KAZ) 8
## 72 Kenya (KEN) 4
## 73 Kosovo (KOS) 2
## 74 North Korea (PRK) 9
## 75 South Korea (KOR) 19
## 76 Kuwait (KUW) 0
## 77 Kyrgyzstan (KGZ) 8
## 78 Latvia (LAT) 12
## 79 Lebanon (LBN) 18
## 80 Liechtenstein (LIE) 20
## 81 Lithuania (LTU) 10
## 82 Luxembourg (LUX) [O] 10
## 83 Malaysia (MAS) [MAS] 2
## 84 Mauritius (MRI) 0
## 85 Mexico (MEX) 10
## 86 Moldova (MDA) 8
## 87 Mongolia (MGL) 15
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 8
## 90 Mozambique (MOZ) 0
## 91 Namibia (NAM) 0
## 92 Netherlands (NED) [Z] 22
## 93 Netherlands Antilles (AHO) [AHO][I] 2
## 94 New Zealand (NZL) [NZL] 17
## 95 Niger (NIG) 0
## 96 Nigeria (NGR) 2
## 97 North Macedonia (MKD) 7
## 98 Norway (NOR) [Q] 24
## 99 Pakistan (PAK) 4
## 100 Panama (PAN) 0
## 101 Paraguay (PAR) 1
## 102 Peru (PER) [L] 3
## 103 Philippines (PHI) 6
## 104 Poland (POL) 24
## 105 Portugal (POR) 9
## 106 Puerto Rico (PUR) 8
## 107 Qatar (QAT) 0
## 108 Romania (ROU) 22
## 109 Russia (RUS) [RUS] 6
## 110 Russian Empire (RU1) [RU1] 0
## 111 Soviet Union (URS) [URS] 9
## 112 Unified Team (EUN) [EUN] 1
## 113 Olympic Athletes from Russia (OAR) [OAR] 1
## 114 ROC (ROC) [ROC] 1
## 115 San Marino (SMR) 11
## 116 Saudi Arabia (KSA) 1
## 117 Samoa (SAM) 0
## 118 Senegal (SEN) 5
## 119 Serbia (SRB) [SRB] 4
## 120 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 121 Singapore (SGP) 1
## 122 Slovakia (SVK) [SVK] 8
## 123 Slovenia (SLO) 9
## 124 South Africa (RSA) 7
## 125 Spain (ESP) [Z] 21
## 126 Sri Lanka (SRI) [SRI] 0
## 127 Sudan (SUD) 0
## 128 Suriname (SUR) [E] 0
## 129 Sweden (SWE) [Z] 24
## 130 Switzerland (SUI) 24
## 131 Syria (SYR) 0
## 132 Chinese Taipei (TPE) [TPE][TPE2] 13
## 133 Tajikistan (TJK) 4
## 134 Tanzania (TAN) [TAN] 0
## 135 Thailand (THA) 5
## 136 Togo (TOG) 2
## 137 Tonga (TGA) 2
## 138 Trinidad and Tobago (TTO) [TTO] 4
## 139 Tunisia (TUN) 0
## 140 Turkey (TUR) 18
## 141 Turkmenistan (TKM) 0
## 142 Uganda (UGA) 0
## 143 Ukraine (UKR) 8
## 144 United Arab Emirates (UAE) 0
## 145 United States (USA) [P][Q][R][Z][F] 24
## 146 Uruguay (URU) 1
## 147 Uzbekistan (UZB) 8
## 148 Venezuela (VEN) 4
## 149 Vietnam (VIE) 0
## 150 Virgin Islands (ISV) 8
## 151 Yugoslavia (YUG) [YUG to 1992] 14
## 152 Zambia (ZAM) [ZAM] 0
## 153 Zimbabwe (ZIM) [ZIM] 1
## 154 Independent Olympic Athletes (IOA) [IOA] 0
## 155 Independent Olympic Participants (IOP) [IOP] 0
## 156 Mixed team (ZZX) [ZZX] 0
## Winter.Olympic.Games.1 Winter.Olympic.Games.2 Winter.Olympic.Games.3
## 1 0 0 0
## 2 0 0 0
## 3 0 0 0
## 4 0 0 0
## 5 0 0 0
## 6 6 7 6
## 7 71 88 91
## 8 0 0 0
## 9 0 0 0
## 10 0 0 0
## 11 0 0 0
## 12 8 7 5
## 13 2 2 4
## 14 0 0 0
## 15 0 0 0
## 16 0 0 0
## 17 0 0 0
## 18 0 0 0
## 19 1 2 3
## 20 0 0 0
## 21 0 0 0
## 22 0 0 0
## 23 77 72 76
## 24 0 0 0
## 25 22 32 23
## 26 0 0 0
## 27 0 0 0
## 28 0 0 0
## 29 4 6 1
## 30 0 0 0
## 31 0 0 0
## 32 10 11 13
## 33 2 8 15
## 34 0 1 0
## 35 0 0 0
## 36 0 0 0
## 37 0 0 0
## 38 0 0 0
## 39 0 0 0
## 40 4 2 2
## 41 0 0 0
## 42 0 0 0
## 43 45 65 65
## 44 41 42 55
## 45 0 0 0
## 46 0 0 0
## 47 104 98 65
## 48 8 6 5
## 49 39 36 35
## 50 11 15 13
## 51 0 0 0
## 52 12 5 17
## 53 0 0 0
## 54 0 0 0
## 55 0 0 0
## 56 0 0 0
## 57 0 0 0
## 58 0 0 0
## 59 2 2 6
## 60 0 0 0
## 61 0 0 0
## 62 0 0 0
## 63 0 0 0
## 64 0 0 0
## 65 0 0 0
## 66 0 0 0
## 67 42 43 56
## 68 0 0 0
## 69 17 28 31
## 70 0 0 0
## 71 1 3 4
## 72 0 0 0
## 73 0 0 0
## 74 0 1 1
## 75 33 30 16
## 76 0 0 0
## 77 0 0 0
## 78 1 3 6
## 79 0 0 0
## 80 2 2 6
## 81 0 0 0
## 82 0 2 0
## 83 0 0 0
## 84 0 0 0
## 85 0 0 0
## 86 0 0 0
## 87 0 0 0
## 88 0 0 0
## 89 0 0 0
## 90 0 0 0
## 91 0 0 0
## 92 53 49 45
## 93 0 0 0
## 94 2 2 2
## 95 0 0 0
## 96 0 0 0
## 97 0 0 0
## 98 148 134 123
## 99 0 0 0
## 100 0 0 0
## 101 0 0 0
## 102 0 0 0
## 103 0 0 0
## 104 7 7 9
## 105 0 0 0
## 106 0 0 0
## 107 0 0 0
## 108 0 0 1
## 109 47 39 35
## 110 0 0 0
## 111 78 57 59
## 112 9 6 8
## 113 2 6 9
## 114 6 12 14
## 115 0 0 0
## 116 0 0 0
## 117 0 0 0
## 118 0 0 0
## 119 0 0 0
## 120 0 0 0
## 121 0 0 0
## 122 4 4 2
## 123 4 8 12
## 124 0 0 0
## 125 1 1 3
## 126 0 0 0
## 127 0 0 0
## 128 0 0 0
## 129 65 51 60
## 130 63 47 58
## 131 0 0 0
## 132 0 0 0
## 133 0 0 0
## 134 0 0 0
## 135 0 0 0
## 136 0 0 0
## 137 0 0 0
## 138 0 0 0
## 139 0 0 0
## 140 0 0 0
## 141 0 0 0
## 142 0 0 0
## 143 3 2 4
## 144 0 0 0
## 145 113 122 95
## 146 0 0 0
## 147 1 0 0
## 148 0 0 0
## 149 0 0 0
## 150 0 0 0
## 151 0 3 1
## 152 0 0 0
## 153 0 0 0
## 154 0 0 0
## 155 0 0 0
## 156 0 0 0
## Winter.Olympic.Games.4
## 1 0
## 2 0
## 3 0
## 4 0
## 5 0
## 6 19
## 7 250
## 8 0
## 9 0
## 10 0
## 11 0
## 12 20
## 13 8
## 14 0
## 15 0
## 16 0
## 17 0
## 18 0
## 19 6
## 20 0
## 21 0
## 22 0
## 23 225
## 24 0
## 25 77
## 26 0
## 27 0
## 28 0
## 29 11
## 30 0
## 31 0
## 32 34
## 33 25
## 34 1
## 35 0
## 36 0
## 37 0
## 38 0
## 39 0
## 40 8
## 41 0
## 42 0
## 43 175
## 44 138
## 45 0
## 46 0
## 47 267
## 48 19
## 49 110
## 50 39
## 51 0
## 52 34
## 53 0
## 54 0
## 55 0
## 56 0
## 57 0
## 58 0
## 59 10
## 60 0
## 61 0
## 62 0
## 63 0
## 64 0
## 65 0
## 66 0
## 67 141
## 68 0
## 69 76
## 70 0
## 71 8
## 72 0
## 73 0
## 74 2
## 75 79
## 76 0
## 77 0
## 78 10
## 79 0
## 80 10
## 81 0
## 82 2
## 83 0
## 84 0
## 85 0
## 86 0
## 87 0
## 88 0
## 89 0
## 90 0
## 91 0
## 92 147
## 93 0
## 94 6
## 95 0
## 96 0
## 97 0
## 98 405
## 99 0
## 100 0
## 101 0
## 102 0
## 103 0
## 104 23
## 105 0
## 106 0
## 107 0
## 108 1
## 109 121
## 110 0
## 111 194
## 112 23
## 113 17
## 114 32
## 115 0
## 116 0
## 117 0
## 118 0
## 119 0
## 120 0
## 121 0
## 122 10
## 123 24
## 124 0
## 125 5
## 126 0
## 127 0
## 128 0
## 129 176
## 130 168
## 131 0
## 132 0
## 133 0
## 134 0
## 135 0
## 136 0
## 137 0
## 138 0
## 139 0
## 140 0
## 141 0
## 142 0
## 143 9
## 144 0
## 145 330
## 146 0
## 147 1
## 148 0
## 149 0
## 150 0
## 151 4
## 152 0
## 153 0
## 154 0
## 155 0
## 156 0Since the Medals of the Summer Olympic Games and Winter Olympic Games are stored in separate data frames, it is necessary to merge them in order to facilitate comprehensive statistical analysis.
merged_data <- merge(summerdata, winterdata, by = "Team")
merged_data## Team Summer.Olympic.Games
## 1 Afghanistan (AFG) 15
## 2 Algeria (ALG) 14
## 3 Argentina (ARG) 25
## 4 Armenia (ARM) 7
## 5 Australasia (ANZ) [ANZ] 2
## 6 Australia (AUS) [AUS][Z] 27
## 7 Austria (AUT) 28
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 17
## 10 Bahrain (BRN) 10
## 11 Barbados (BAR) [BAR] 13
## 12 Belarus (BLR) 7
## 13 Belgium (BEL) 27
## 14 Bermuda (BER) 19
## 15 Bohemia (BOH) [BOH][Z] 3
## 16 Botswana (BOT) 11
## 17 Brazil (BRA) 23
## 18 British West Indies (BWI) [BWI] 1
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 10
## 21 Burundi (BDI) 7
## 22 Cameroon (CMR) 15
## 23 Canada (CAN) 27
## 24 Chile (CHI) [I] 24
## 25 China (CHN) [CHN] 11
## 26 Chinese Taipei (TPE) [TPE][TPE2] 15
## 27 Colombia (COL) 20
## 28 Costa Rica (CRC) 16
## 29 Croatia (CRO) 8
## 30 Cuba (CUB) [Z] 21
## 31 Cyprus (CYP) 11
## 32 Czech Republic (CZE) [CZE] 7
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 28
## 35 Djibouti (DJI) [B] 9
## 36 Dominican Republic (DOM) 15
## 37 East Germany (GDR) [GDR] 5
## 38 Ecuador (ECU) 15
## 39 Egypt (EGY) [EGY][Z] 23
## 40 Eritrea (ERI) 6
## 41 Estonia (EST) 13
## 42 Ethiopia (ETH) 14
## 43 Fiji (FIJ) 15
## 44 Finland (FIN) 26
## 45 France (FRA) [O][P][Z] 29
## 46 Gabon (GAB) 11
## 47 Georgia (GEO) 7
## 48 Germany (GER) [GER][Z] 17
## 49 Ghana (GHA) [GHA] 15
## 50 Great Britain (GBR) [GBR][Z] 29
## 51 Greece (GRE) 29
## 52 Grenada (GRN) 10
## 53 Guatemala (GUA) 15
## 54 Guyana (GUY) [GUY] 18
## 55 Haiti (HAI) [J] 16
## 56 Hong Kong (HKG) [HKG] 17
## 57 Hungary (HUN) 27
## 58 Iceland (ISL) 21
## 59 Independent Olympic Athletes (IOA) [IOA] 3
## 60 Independent Olympic Participants (IOP) [IOP] 1
## 61 India (IND) [F] 25
## 62 Indonesia (INA) 16
## 63 Iran (IRI) [K] 17
## 64 Iraq (IRQ) 15
## 65 Ireland (IRL) 22
## 66 Israel (ISR) 17
## 67 Italy (ITA) [M][S] 28
## 68 Ivory Coast (CIV) [CIV] 14
## 69 Jamaica (JAM) [JAM] 18
## 70 Japan (JPN) 23
## 71 Jordan (JOR) 11
## 72 Kazakhstan (KAZ) 7
## 73 Kenya (KEN) 15
## 74 Kosovo (KOS) 2
## 75 Kuwait (KUW) 13
## 76 Kyrgyzstan (KGZ) 7
## 77 Latvia (LAT) 12
## 78 Lebanon (LBN) 18
## 79 Liechtenstein (LIE) 18
## 80 Lithuania (LTU) 10
## 81 Luxembourg (LUX) [O] 25
## 82 Malaysia (MAS) [MAS] 14
## 83 Mauritius (MRI) 10
## 84 Mexico (MEX) 24
## 85 Mixed team (ZZX) [ZZX] 3
## 86 Moldova (MDA) 7
## 87 Mongolia (MGL) 14
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 15
## 90 Mozambique (MOZ) 11
## 91 Namibia (NAM) 8
## 92 Netherlands Antilles (AHO) [AHO][I] 13
## 93 Netherlands (NED) [Z] 27
## 94 New Zealand (NZL) [NZL] 24
## 95 Niger (NIG) 13
## 96 Nigeria (NGR) 17
## 97 North Korea (PRK) 10
## 98 North Macedonia (MKD) 7
## 99 Norway (NOR) [Q] 27
## 100 Olympic Athletes from Russia (OAR) [OAR] 0
## 101 Pakistan (PAK) 18
## 102 Panama (PAN) 18
## 103 Paraguay (PAR) 13
## 104 Peru (PER) [L] 19
## 105 Philippines (PHI) 22
## 106 Poland (POL) 22
## 107 Portugal (POR) 25
## 108 Puerto Rico (PUR) 19
## 109 Qatar (QAT) 10
## 110 ROC (ROC) [ROC] 1
## 111 Romania (ROU) 22
## 112 Russia (RUS) [RUS] 6
## 113 Russian Empire (RU1) [RU1] 3
## 114 Samoa (SAM) 10
## 115 San Marino (SMR) 15
## 116 Saudi Arabia (KSA) 12
## 117 Senegal (SEN) 15
## 118 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 119 Serbia (SRB) [SRB] 5
## 120 Singapore (SGP) 17
## 121 Slovakia (SVK) [SVK] 7
## 122 Slovenia (SLO) 8
## 123 South Africa (RSA) 20
## 124 South Korea (KOR) 18
## 125 Soviet Union (URS) [URS] 9
## 126 Spain (ESP) [Z] 24
## 127 Sri Lanka (SRI) [SRI] 18
## 128 Sudan (SUD) 13
## 129 Suriname (SUR) [E] 13
## 130 Sweden (SWE) [Z] 28
## 131 Switzerland (SUI) 29
## 132 Syria (SYR) 14
## 133 Tajikistan (TJK) 7
## 134 Tanzania (TAN) [TAN] 14
## 135 Thailand (THA) 17
## 136 Togo (TOG) 11
## 137 Tonga (TGA) 10
## 138 Trinidad and Tobago (TTO) [TTO] 18
## 139 Tunisia (TUN) 15
## 140 Turkey (TUR) 23
## 141 Turkmenistan (TKM) 7
## 142 Uganda (UGA) 16
## 143 Ukraine (UKR) 7
## 144 Unified Team (EUN) [EUN] 1
## 145 United Arab Emirates (UAE) 10
## 146 United States (USA) [P][Q][R][Z][F] 28
## 147 United Team of Germany (EUA) [EUA] 3
## 148 Uruguay (URU) 22
## 149 Uzbekistan (UZB) 7
## 150 Venezuela (VEN) 19
## 151 Vietnam (VIE) 16
## 152 Virgin Islands (ISV) 13
## 153 West Germany (FRG) [FRG] 5
## 154 Yugoslavia (YUG) [YUG to 1992] 16
## 155 Zambia (ZAM) [ZAM] 14
## 156 Zimbabwe (ZIM) [ZIM] 14
## Summer.Olympic.Games.1 Summer.Olympic.Games.2 Summer.Olympic.Games.3
## 1 0 0 2
## 2 5 4 8
## 3 21 26 30
## 4 2 8 8
## 5 3 4 5
## 6 164 173 210
## 7 20 35 41
## 8 7 14 28
## 9 8 2 6
## 10 2 2 0
## 11 0 0 1
## 12 13 30 42
## 13 44 56 57
## 14 1 0 1
## 15 0 1 3
## 16 0 1 1
## 17 37 42 71
## 18 0 0 2
## 19 54 88 82
## 20 0 0 1
## 21 1 1 0
## 22 3 1 2
## 23 71 110 145
## 24 2 7 4
## 25 263 199 174
## 26 7 11 18
## 27 5 13 16
## 28 1 1 2
## 29 14 13 14
## 30 84 69 82
## 31 0 1 0
## 32 19 22 26
## 33 49 49 45
## 34 48 78 79
## 35 0 0 1
## 36 3 5 4
## 37 153 129 127
## 38 3 2 0
## 39 8 11 19
## 40 0 0 1
## 41 10 9 17
## 42 23 12 23
## 43 2 0 1
## 44 101 85 119
## 45 223 251 277
## 46 0 1 0
## 47 10 12 18
## 48 201 207 247
## 49 0 1 4
## 50 284 318 314
## 51 35 45 41
## 52 1 1 1
## 53 0 1 0
## 54 0 0 1
## 55 0 1 1
## 56 2 3 4
## 57 181 154 176
## 58 0 2 2
## 59 1 0 1
## 60 0 1 2
## 61 10 9 16
## 62 8 14 15
## 63 24 23 29
## 64 0 0 1
## 65 11 10 14
## 66 3 1 9
## 67 217 188 213
## 68 1 1 2
## 69 26 36 26
## 70 169 150 178
## 71 1 1 1
## 72 14 22 35
## 73 35 42 36
## 74 3 0 0
## 75 0 0 3
## 76 0 3 4
## 77 4 11 6
## 78 0 2 2
## 79 0 0 0
## 80 6 7 13
## 81 2 1 0
## 82 0 8 5
## 83 0 0 1
## 84 13 24 35
## 85 11 6 8
## 86 0 2 4
## 87 2 11 17
## 88 0 1 0
## 89 7 5 12
## 90 1 0 1
## 91 0 5 0
## 92 0 1 0
## 93 95 105 122
## 94 53 33 51
## 95 0 1 1
## 96 3 11 13
## 97 16 16 23
## 98 0 1 1
## 99 61 52 50
## 100 0 0 0
## 101 3 3 4
## 102 1 0 2
## 103 0 1 0
## 104 1 3 0
## 105 1 5 8
## 106 72 89 137
## 107 5 9 14
## 108 2 2 6
## 109 2 2 4
## 110 20 28 23
## 111 90 97 121
## 112 147 126 151
## 113 1 4 3
## 114 0 1 0
## 115 0 1 2
## 116 0 2 2
## 117 0 1 0
## 118 2 4 3
## 119 6 7 11
## 120 1 2 2
## 121 10 14 8
## 122 8 9 11
## 123 27 33 29
## 124 96 91 100
## 125 395 319 296
## 126 48 72 49
## 127 0 2 0
## 128 0 1 0
## 129 1 0 1
## 130 147 177 179
## 131 53 79 74
## 132 1 1 2
## 133 1 1 2
## 134 0 2 0
## 135 10 8 17
## 136 0 0 1
## 137 0 1 0
## 138 3 5 11
## 139 5 3 7
## 140 41 26 36
## 141 0 1 0
## 142 4 4 3
## 143 35 36 68
## 144 45 38 29
## 145 1 0 1
## 146 1,061 830 738
## 147 28 54 36
## 148 2 2 6
## 149 10 6 20
## 150 3 7 9
## 151 1 3 1
## 152 0 1 0
## 153 56 67 81
## 154 26 29 28
## 155 0 1 1
## 156 3 4 1
## Summer.Olympic.Games.4 Winter.Olympic.Games Winter.Olympic.Games.1
## 1 2 0 0
## 2 17 3 0
## 3 77 20 0
## 4 18 8 0
## 5 12 0 0
## 6 547 20 6
## 7 96 24 71
## 8 49 7 0
## 9 16 0 0
## 10 4 0 0
## 11 1 0 0
## 12 85 8 8
## 13 157 22 2
## 14 2 8 0
## 15 4 0 0
## 16 2 0 0
## 17 150 9 0
## 18 2 0 0
## 19 224 21 1
## 20 1 0 0
## 21 2 0 0
## 22 6 1 0
## 23 326 24 77
## 24 13 18 0
## 25 636 12 22
## 26 36 13 0
## 27 34 3 0
## 28 4 6 0
## 29 41 9 4
## 30 235 0 0
## 31 1 12 0
## 32 67 8 10
## 33 143 16 2
## 34 205 15 0
## 35 1 0 0
## 36 12 0 0
## 37 409 6 39
## 38 5 2 0
## 39 38 1 0
## 40 1 2 0
## 41 36 11 4
## 42 58 2 0
## 43 3 3 0
## 44 305 24 45
## 45 751 24 41
## 46 1 0 0
## 47 40 8 0
## 48 655 13 104
## 49 5 3 0
## 50 916 24 12
## 51 121 20 0
## 52 3 0 0
## 53 1 1 0
## 54 1 0 0
## 55 2 1 0
## 56 9 6 0
## 57 511 24 2
## 58 4 19 0
## 59 2 0 0
## 60 3 0 0
## 61 35 11 0
## 62 37 0 0
## 63 76 12 0
## 64 1 0 0
## 65 35 8 0
## 66 13 8 0
## 67 618 24 42
## 68 4 0 0
## 69 88 9 0
## 70 497 22 17
## 71 3 0 0
## 72 71 8 1
## 73 113 4 0
## 74 3 2 0
## 75 3 0 0
## 76 7 8 0
## 77 21 12 1
## 78 4 18 0
## 79 0 20 2
## 80 26 10 0
## 81 3 10 0
## 82 13 2 0
## 83 1 0 0
## 84 72 10 0
## 85 25 0 0
## 86 6 8 0
## 87 30 15 0
## 88 1 4 0
## 89 24 8 0
## 90 2 0 0
## 91 5 0 0
## 92 1 2 0
## 93 322 22 53
## 94 137 17 2
## 95 2 0 0
## 96 27 2 0
## 97 55 9 0
## 98 2 7 0
## 99 163 24 148
## 100 0 1 2
## 101 10 4 0
## 102 3 0 0
## 103 1 1 0
## 104 4 3 0
## 105 14 6 0
## 106 298 24 7
## 107 28 9 0
## 108 10 8 0
## 109 8 0 0
## 110 71 1 6
## 111 308 22 0
## 112 424 6 47
## 113 8 0 0
## 114 1 0 0
## 115 3 11 0
## 116 4 1 0
## 117 1 5 0
## 118 9 3 0
## 119 24 4 0
## 120 5 1 0
## 121 32 8 4
## 122 28 9 4
## 123 89 7 0
## 124 287 19 33
## 125 1,010 9 78
## 126 169 21 1
## 127 2 0 0
## 128 1 0 0
## 129 2 0 0
## 130 503 24 65
## 131 206 24 63
## 132 4 0 0
## 133 4 4 0
## 134 2 0 0
## 135 35 5 0
## 136 1 2 0
## 137 1 2 0
## 138 19 4 0
## 139 15 0 0
## 140 103 18 0
## 141 1 0 0
## 142 11 0 0
## 143 139 8 3
## 144 112 1 9
## 145 2 0 0
## 146 2,629 24 113
## 147 118 3 8
## 148 10 1 0
## 149 36 8 1
## 150 19 4 0
## 151 5 0 0
## 152 1 8 0
## 153 204 6 11
## 154 83 14 0
## 155 2 0 0
## 156 8 1 0
## Winter.Olympic.Games.2 Winter.Olympic.Games.3 Winter.Olympic.Games.4
## 1 0 0 0
## 2 0 0 0
## 3 0 0 0
## 4 0 0 0
## 5 0 0 0
## 6 7 6 19
## 7 88 91 250
## 8 0 0 0
## 9 0 0 0
## 10 0 0 0
## 11 0 0 0
## 12 7 5 20
## 13 2 4 8
## 14 0 0 0
## 15 0 0 0
## 16 0 0 0
## 17 0 0 0
## 18 0 0 0
## 19 2 3 6
## 20 0 0 0
## 21 0 0 0
## 22 0 0 0
## 23 72 76 225
## 24 0 0 0
## 25 32 23 77
## 26 0 0 0
## 27 0 0 0
## 28 0 0 0
## 29 6 1 11
## 30 0 0 0
## 31 0 0 0
## 32 11 13 34
## 33 8 15 25
## 34 1 0 1
## 35 0 0 0
## 36 0 0 0
## 37 36 35 110
## 38 0 0 0
## 39 0 0 0
## 40 0 0 0
## 41 2 2 8
## 42 0 0 0
## 43 0 0 0
## 44 65 65 175
## 45 42 55 138
## 46 0 0 0
## 47 0 0 0
## 48 98 65 267
## 49 0 0 0
## 50 5 17 34
## 51 0 0 0
## 52 0 0 0
## 53 0 0 0
## 54 0 0 0
## 55 0 0 0
## 56 0 0 0
## 57 2 6 10
## 58 0 0 0
## 59 0 0 0
## 60 0 0 0
## 61 0 0 0
## 62 0 0 0
## 63 0 0 0
## 64 0 0 0
## 65 0 0 0
## 66 0 0 0
## 67 43 56 141
## 68 0 0 0
## 69 0 0 0
## 70 28 31 76
## 71 0 0 0
## 72 3 4 8
## 73 0 0 0
## 74 0 0 0
## 75 0 0 0
## 76 0 0 0
## 77 3 6 10
## 78 0 0 0
## 79 2 6 10
## 80 0 0 0
## 81 2 0 2
## 82 0 0 0
## 83 0 0 0
## 84 0 0 0
## 85 0 0 0
## 86 0 0 0
## 87 0 0 0
## 88 0 0 0
## 89 0 0 0
## 90 0 0 0
## 91 0 0 0
## 92 0 0 0
## 93 49 45 147
## 94 2 2 6
## 95 0 0 0
## 96 0 0 0
## 97 1 1 2
## 98 0 0 0
## 99 134 123 405
## 100 6 9 17
## 101 0 0 0
## 102 0 0 0
## 103 0 0 0
## 104 0 0 0
## 105 0 0 0
## 106 7 9 23
## 107 0 0 0
## 108 0 0 0
## 109 0 0 0
## 110 12 14 32
## 111 0 1 1
## 112 39 35 121
## 113 0 0 0
## 114 0 0 0
## 115 0 0 0
## 116 0 0 0
## 117 0 0 0
## 118 0 0 0
## 119 0 0 0
## 120 0 0 0
## 121 4 2 10
## 122 8 12 24
## 123 0 0 0
## 124 30 16 79
## 125 57 59 194
## 126 1 3 5
## 127 0 0 0
## 128 0 0 0
## 129 0 0 0
## 130 51 60 176
## 131 47 58 168
## 132 0 0 0
## 133 0 0 0
## 134 0 0 0
## 135 0 0 0
## 136 0 0 0
## 137 0 0 0
## 138 0 0 0
## 139 0 0 0
## 140 0 0 0
## 141 0 0 0
## 142 0 0 0
## 143 2 4 9
## 144 6 8 23
## 145 0 0 0
## 146 122 95 330
## 147 6 5 19
## 148 0 0 0
## 149 0 0 1
## 150 0 0 0
## 151 0 0 0
## 152 0 0 0
## 153 15 13 39
## 154 3 1 4
## 155 0 0 0
## 156 0 0 0col_names <- colnames(merged_data)
col_names[2] <- paste0(col_names[2], ".Total")
col_names[3] <- "Summer.Olympic.Games.Gold.Metals"
col_names[4] <- "Summer.Olympic.Games.Silver.Metals"
col_names[5] <- "Summer.Olympic.Games.Bronze.Metals"
col_names[6] <- "Summer.Olympic.Games.Metal.Total"
col_names[7] <- paste0(col_names[7], ".Total")
col_names[8] <- "Winter.Olympic.Games.Gold.Metals"
col_names[9] <- "Winter.Olympic.Games.Silver.Metals"
col_names[10] <- "Winter.Olympic.Games.Bronze.Metals"
col_names[11] <- "Winter.Olympic.Games.Metal.Total"
colnames(merged_data) <- col_names
merged_data## Team Summer.Olympic.Games.Total
## 1 Afghanistan (AFG) 15
## 2 Algeria (ALG) 14
## 3 Argentina (ARG) 25
## 4 Armenia (ARM) 7
## 5 Australasia (ANZ) [ANZ] 2
## 6 Australia (AUS) [AUS][Z] 27
## 7 Austria (AUT) 28
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 17
## 10 Bahrain (BRN) 10
## 11 Barbados (BAR) [BAR] 13
## 12 Belarus (BLR) 7
## 13 Belgium (BEL) 27
## 14 Bermuda (BER) 19
## 15 Bohemia (BOH) [BOH][Z] 3
## 16 Botswana (BOT) 11
## 17 Brazil (BRA) 23
## 18 British West Indies (BWI) [BWI] 1
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 10
## 21 Burundi (BDI) 7
## 22 Cameroon (CMR) 15
## 23 Canada (CAN) 27
## 24 Chile (CHI) [I] 24
## 25 China (CHN) [CHN] 11
## 26 Chinese Taipei (TPE) [TPE][TPE2] 15
## 27 Colombia (COL) 20
## 28 Costa Rica (CRC) 16
## 29 Croatia (CRO) 8
## 30 Cuba (CUB) [Z] 21
## 31 Cyprus (CYP) 11
## 32 Czech Republic (CZE) [CZE] 7
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 28
## 35 Djibouti (DJI) [B] 9
## 36 Dominican Republic (DOM) 15
## 37 East Germany (GDR) [GDR] 5
## 38 Ecuador (ECU) 15
## 39 Egypt (EGY) [EGY][Z] 23
## 40 Eritrea (ERI) 6
## 41 Estonia (EST) 13
## 42 Ethiopia (ETH) 14
## 43 Fiji (FIJ) 15
## 44 Finland (FIN) 26
## 45 France (FRA) [O][P][Z] 29
## 46 Gabon (GAB) 11
## 47 Georgia (GEO) 7
## 48 Germany (GER) [GER][Z] 17
## 49 Ghana (GHA) [GHA] 15
## 50 Great Britain (GBR) [GBR][Z] 29
## 51 Greece (GRE) 29
## 52 Grenada (GRN) 10
## 53 Guatemala (GUA) 15
## 54 Guyana (GUY) [GUY] 18
## 55 Haiti (HAI) [J] 16
## 56 Hong Kong (HKG) [HKG] 17
## 57 Hungary (HUN) 27
## 58 Iceland (ISL) 21
## 59 Independent Olympic Athletes (IOA) [IOA] 3
## 60 Independent Olympic Participants (IOP) [IOP] 1
## 61 India (IND) [F] 25
## 62 Indonesia (INA) 16
## 63 Iran (IRI) [K] 17
## 64 Iraq (IRQ) 15
## 65 Ireland (IRL) 22
## 66 Israel (ISR) 17
## 67 Italy (ITA) [M][S] 28
## 68 Ivory Coast (CIV) [CIV] 14
## 69 Jamaica (JAM) [JAM] 18
## 70 Japan (JPN) 23
## 71 Jordan (JOR) 11
## 72 Kazakhstan (KAZ) 7
## 73 Kenya (KEN) 15
## 74 Kosovo (KOS) 2
## 75 Kuwait (KUW) 13
## 76 Kyrgyzstan (KGZ) 7
## 77 Latvia (LAT) 12
## 78 Lebanon (LBN) 18
## 79 Liechtenstein (LIE) 18
## 80 Lithuania (LTU) 10
## 81 Luxembourg (LUX) [O] 25
## 82 Malaysia (MAS) [MAS] 14
## 83 Mauritius (MRI) 10
## 84 Mexico (MEX) 24
## 85 Mixed team (ZZX) [ZZX] 3
## 86 Moldova (MDA) 7
## 87 Mongolia (MGL) 14
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 15
## 90 Mozambique (MOZ) 11
## 91 Namibia (NAM) 8
## 92 Netherlands Antilles (AHO) [AHO][I] 13
## 93 Netherlands (NED) [Z] 27
## 94 New Zealand (NZL) [NZL] 24
## 95 Niger (NIG) 13
## 96 Nigeria (NGR) 17
## 97 North Korea (PRK) 10
## 98 North Macedonia (MKD) 7
## 99 Norway (NOR) [Q] 27
## 100 Olympic Athletes from Russia (OAR) [OAR] 0
## 101 Pakistan (PAK) 18
## 102 Panama (PAN) 18
## 103 Paraguay (PAR) 13
## 104 Peru (PER) [L] 19
## 105 Philippines (PHI) 22
## 106 Poland (POL) 22
## 107 Portugal (POR) 25
## 108 Puerto Rico (PUR) 19
## 109 Qatar (QAT) 10
## 110 ROC (ROC) [ROC] 1
## 111 Romania (ROU) 22
## 112 Russia (RUS) [RUS] 6
## 113 Russian Empire (RU1) [RU1] 3
## 114 Samoa (SAM) 10
## 115 San Marino (SMR) 15
## 116 Saudi Arabia (KSA) 12
## 117 Senegal (SEN) 15
## 118 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 119 Serbia (SRB) [SRB] 5
## 120 Singapore (SGP) 17
## 121 Slovakia (SVK) [SVK] 7
## 122 Slovenia (SLO) 8
## 123 South Africa (RSA) 20
## 124 South Korea (KOR) 18
## 125 Soviet Union (URS) [URS] 9
## 126 Spain (ESP) [Z] 24
## 127 Sri Lanka (SRI) [SRI] 18
## 128 Sudan (SUD) 13
## 129 Suriname (SUR) [E] 13
## 130 Sweden (SWE) [Z] 28
## 131 Switzerland (SUI) 29
## 132 Syria (SYR) 14
## 133 Tajikistan (TJK) 7
## 134 Tanzania (TAN) [TAN] 14
## 135 Thailand (THA) 17
## 136 Togo (TOG) 11
## 137 Tonga (TGA) 10
## 138 Trinidad and Tobago (TTO) [TTO] 18
## 139 Tunisia (TUN) 15
## 140 Turkey (TUR) 23
## 141 Turkmenistan (TKM) 7
## 142 Uganda (UGA) 16
## 143 Ukraine (UKR) 7
## 144 Unified Team (EUN) [EUN] 1
## 145 United Arab Emirates (UAE) 10
## 146 United States (USA) [P][Q][R][Z][F] 28
## 147 United Team of Germany (EUA) [EUA] 3
## 148 Uruguay (URU) 22
## 149 Uzbekistan (UZB) 7
## 150 Venezuela (VEN) 19
## 151 Vietnam (VIE) 16
## 152 Virgin Islands (ISV) 13
## 153 West Germany (FRG) [FRG] 5
## 154 Yugoslavia (YUG) [YUG to 1992] 16
## 155 Zambia (ZAM) [ZAM] 14
## 156 Zimbabwe (ZIM) [ZIM] 14
## Summer.Olympic.Games.Gold.Metals Summer.Olympic.Games.Silver.Metals
## 1 0 0
## 2 5 4
## 3 21 26
## 4 2 8
## 5 3 4
## 6 164 173
## 7 20 35
## 8 7 14
## 9 8 2
## 10 2 2
## 11 0 0
## 12 13 30
## 13 44 56
## 14 1 0
## 15 0 1
## 16 0 1
## 17 37 42
## 18 0 0
## 19 54 88
## 20 0 0
## 21 1 1
## 22 3 1
## 23 71 110
## 24 2 7
## 25 263 199
## 26 7 11
## 27 5 13
## 28 1 1
## 29 14 13
## 30 84 69
## 31 0 1
## 32 19 22
## 33 49 49
## 34 48 78
## 35 0 0
## 36 3 5
## 37 153 129
## 38 3 2
## 39 8 11
## 40 0 0
## 41 10 9
## 42 23 12
## 43 2 0
## 44 101 85
## 45 223 251
## 46 0 1
## 47 10 12
## 48 201 207
## 49 0 1
## 50 284 318
## 51 35 45
## 52 1 1
## 53 0 1
## 54 0 0
## 55 0 1
## 56 2 3
## 57 181 154
## 58 0 2
## 59 1 0
## 60 0 1
## 61 10 9
## 62 8 14
## 63 24 23
## 64 0 0
## 65 11 10
## 66 3 1
## 67 217 188
## 68 1 1
## 69 26 36
## 70 169 150
## 71 1 1
## 72 14 22
## 73 35 42
## 74 3 0
## 75 0 0
## 76 0 3
## 77 4 11
## 78 0 2
## 79 0 0
## 80 6 7
## 81 2 1
## 82 0 8
## 83 0 0
## 84 13 24
## 85 11 6
## 86 0 2
## 87 2 11
## 88 0 1
## 89 7 5
## 90 1 0
## 91 0 5
## 92 0 1
## 93 95 105
## 94 53 33
## 95 0 1
## 96 3 11
## 97 16 16
## 98 0 1
## 99 61 52
## 100 0 0
## 101 3 3
## 102 1 0
## 103 0 1
## 104 1 3
## 105 1 5
## 106 72 89
## 107 5 9
## 108 2 2
## 109 2 2
## 110 20 28
## 111 90 97
## 112 147 126
## 113 1 4
## 114 0 1
## 115 0 1
## 116 0 2
## 117 0 1
## 118 2 4
## 119 6 7
## 120 1 2
## 121 10 14
## 122 8 9
## 123 27 33
## 124 96 91
## 125 395 319
## 126 48 72
## 127 0 2
## 128 0 1
## 129 1 0
## 130 147 177
## 131 53 79
## 132 1 1
## 133 1 1
## 134 0 2
## 135 10 8
## 136 0 0
## 137 0 1
## 138 3 5
## 139 5 3
## 140 41 26
## 141 0 1
## 142 4 4
## 143 35 36
## 144 45 38
## 145 1 0
## 146 1,061 830
## 147 28 54
## 148 2 2
## 149 10 6
## 150 3 7
## 151 1 3
## 152 0 1
## 153 56 67
## 154 26 29
## 155 0 1
## 156 3 4
## Summer.Olympic.Games.Bronze.Metals Summer.Olympic.Games.Metal.Total
## 1 2 2
## 2 8 17
## 3 30 77
## 4 8 18
## 5 5 12
## 6 210 547
## 7 41 96
## 8 28 49
## 9 6 16
## 10 0 4
## 11 1 1
## 12 42 85
## 13 57 157
## 14 1 2
## 15 3 4
## 16 1 2
## 17 71 150
## 18 2 2
## 19 82 224
## 20 1 1
## 21 0 2
## 22 2 6
## 23 145 326
## 24 4 13
## 25 174 636
## 26 18 36
## 27 16 34
## 28 2 4
## 29 14 41
## 30 82 235
## 31 0 1
## 32 26 67
## 33 45 143
## 34 79 205
## 35 1 1
## 36 4 12
## 37 127 409
## 38 0 5
## 39 19 38
## 40 1 1
## 41 17 36
## 42 23 58
## 43 1 3
## 44 119 305
## 45 277 751
## 46 0 1
## 47 18 40
## 48 247 655
## 49 4 5
## 50 314 916
## 51 41 121
## 52 1 3
## 53 0 1
## 54 1 1
## 55 1 2
## 56 4 9
## 57 176 511
## 58 2 4
## 59 1 2
## 60 2 3
## 61 16 35
## 62 15 37
## 63 29 76
## 64 1 1
## 65 14 35
## 66 9 13
## 67 213 618
## 68 2 4
## 69 26 88
## 70 178 497
## 71 1 3
## 72 35 71
## 73 36 113
## 74 0 3
## 75 3 3
## 76 4 7
## 77 6 21
## 78 2 4
## 79 0 0
## 80 13 26
## 81 0 3
## 82 5 13
## 83 1 1
## 84 35 72
## 85 8 25
## 86 4 6
## 87 17 30
## 88 0 1
## 89 12 24
## 90 1 2
## 91 0 5
## 92 0 1
## 93 122 322
## 94 51 137
## 95 1 2
## 96 13 27
## 97 23 55
## 98 1 2
## 99 50 163
## 100 0 0
## 101 4 10
## 102 2 3
## 103 0 1
## 104 0 4
## 105 8 14
## 106 137 298
## 107 14 28
## 108 6 10
## 109 4 8
## 110 23 71
## 111 121 308
## 112 151 424
## 113 3 8
## 114 0 1
## 115 2 3
## 116 2 4
## 117 0 1
## 118 3 9
## 119 11 24
## 120 2 5
## 121 8 32
## 122 11 28
## 123 29 89
## 124 100 287
## 125 296 1,010
## 126 49 169
## 127 0 2
## 128 0 1
## 129 1 2
## 130 179 503
## 131 74 206
## 132 2 4
## 133 2 4
## 134 0 2
## 135 17 35
## 136 1 1
## 137 0 1
## 138 11 19
## 139 7 15
## 140 36 103
## 141 0 1
## 142 3 11
## 143 68 139
## 144 29 112
## 145 1 2
## 146 738 2,629
## 147 36 118
## 148 6 10
## 149 20 36
## 150 9 19
## 151 1 5
## 152 0 1
## 153 81 204
## 154 28 83
## 155 1 2
## 156 1 8
## Winter.Olympic.Games.Total Winter.Olympic.Games.Gold.Metals
## 1 0 0
## 2 3 0
## 3 20 0
## 4 8 0
## 5 0 0
## 6 20 6
## 7 24 71
## 8 7 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 8 8
## 13 22 2
## 14 8 0
## 15 0 0
## 16 0 0
## 17 9 0
## 18 0 0
## 19 21 1
## 20 0 0
## 21 0 0
## 22 1 0
## 23 24 77
## 24 18 0
## 25 12 22
## 26 13 0
## 27 3 0
## 28 6 0
## 29 9 4
## 30 0 0
## 31 12 0
## 32 8 10
## 33 16 2
## 34 15 0
## 35 0 0
## 36 0 0
## 37 6 39
## 38 2 0
## 39 1 0
## 40 2 0
## 41 11 4
## 42 2 0
## 43 3 0
## 44 24 45
## 45 24 41
## 46 0 0
## 47 8 0
## 48 13 104
## 49 3 0
## 50 24 12
## 51 20 0
## 52 0 0
## 53 1 0
## 54 0 0
## 55 1 0
## 56 6 0
## 57 24 2
## 58 19 0
## 59 0 0
## 60 0 0
## 61 11 0
## 62 0 0
## 63 12 0
## 64 0 0
## 65 8 0
## 66 8 0
## 67 24 42
## 68 0 0
## 69 9 0
## 70 22 17
## 71 0 0
## 72 8 1
## 73 4 0
## 74 2 0
## 75 0 0
## 76 8 0
## 77 12 1
## 78 18 0
## 79 20 2
## 80 10 0
## 81 10 0
## 82 2 0
## 83 0 0
## 84 10 0
## 85 0 0
## 86 8 0
## 87 15 0
## 88 4 0
## 89 8 0
## 90 0 0
## 91 0 0
## 92 2 0
## 93 22 53
## 94 17 2
## 95 0 0
## 96 2 0
## 97 9 0
## 98 7 0
## 99 24 148
## 100 1 2
## 101 4 0
## 102 0 0
## 103 1 0
## 104 3 0
## 105 6 0
## 106 24 7
## 107 9 0
## 108 8 0
## 109 0 0
## 110 1 6
## 111 22 0
## 112 6 47
## 113 0 0
## 114 0 0
## 115 11 0
## 116 1 0
## 117 5 0
## 118 3 0
## 119 4 0
## 120 1 0
## 121 8 4
## 122 9 4
## 123 7 0
## 124 19 33
## 125 9 78
## 126 21 1
## 127 0 0
## 128 0 0
## 129 0 0
## 130 24 65
## 131 24 63
## 132 0 0
## 133 4 0
## 134 0 0
## 135 5 0
## 136 2 0
## 137 2 0
## 138 4 0
## 139 0 0
## 140 18 0
## 141 0 0
## 142 0 0
## 143 8 3
## 144 1 9
## 145 0 0
## 146 24 113
## 147 3 8
## 148 1 0
## 149 8 1
## 150 4 0
## 151 0 0
## 152 8 0
## 153 6 11
## 154 14 0
## 155 0 0
## 156 1 0
## Winter.Olympic.Games.Silver.Metals Winter.Olympic.Games.Bronze.Metals
## 1 0 0
## 2 0 0
## 3 0 0
## 4 0 0
## 5 0 0
## 6 7 6
## 7 88 91
## 8 0 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 7 5
## 13 2 4
## 14 0 0
## 15 0 0
## 16 0 0
## 17 0 0
## 18 0 0
## 19 2 3
## 20 0 0
## 21 0 0
## 22 0 0
## 23 72 76
## 24 0 0
## 25 32 23
## 26 0 0
## 27 0 0
## 28 0 0
## 29 6 1
## 30 0 0
## 31 0 0
## 32 11 13
## 33 8 15
## 34 1 0
## 35 0 0
## 36 0 0
## 37 36 35
## 38 0 0
## 39 0 0
## 40 0 0
## 41 2 2
## 42 0 0
## 43 0 0
## 44 65 65
## 45 42 55
## 46 0 0
## 47 0 0
## 48 98 65
## 49 0 0
## 50 5 17
## 51 0 0
## 52 0 0
## 53 0 0
## 54 0 0
## 55 0 0
## 56 0 0
## 57 2 6
## 58 0 0
## 59 0 0
## 60 0 0
## 61 0 0
## 62 0 0
## 63 0 0
## 64 0 0
## 65 0 0
## 66 0 0
## 67 43 56
## 68 0 0
## 69 0 0
## 70 28 31
## 71 0 0
## 72 3 4
## 73 0 0
## 74 0 0
## 75 0 0
## 76 0 0
## 77 3 6
## 78 0 0
## 79 2 6
## 80 0 0
## 81 2 0
## 82 0 0
## 83 0 0
## 84 0 0
## 85 0 0
## 86 0 0
## 87 0 0
## 88 0 0
## 89 0 0
## 90 0 0
## 91 0 0
## 92 0 0
## 93 49 45
## 94 2 2
## 95 0 0
## 96 0 0
## 97 1 1
## 98 0 0
## 99 134 123
## 100 6 9
## 101 0 0
## 102 0 0
## 103 0 0
## 104 0 0
## 105 0 0
## 106 7 9
## 107 0 0
## 108 0 0
## 109 0 0
## 110 12 14
## 111 0 1
## 112 39 35
## 113 0 0
## 114 0 0
## 115 0 0
## 116 0 0
## 117 0 0
## 118 0 0
## 119 0 0
## 120 0 0
## 121 4 2
## 122 8 12
## 123 0 0
## 124 30 16
## 125 57 59
## 126 1 3
## 127 0 0
## 128 0 0
## 129 0 0
## 130 51 60
## 131 47 58
## 132 0 0
## 133 0 0
## 134 0 0
## 135 0 0
## 136 0 0
## 137 0 0
## 138 0 0
## 139 0 0
## 140 0 0
## 141 0 0
## 142 0 0
## 143 2 4
## 144 6 8
## 145 0 0
## 146 122 95
## 147 6 5
## 148 0 0
## 149 0 0
## 150 0 0
## 151 0 0
## 152 0 0
## 153 15 13
## 154 3 1
## 155 0 0
## 156 0 0
## Winter.Olympic.Games.Metal.Total
## 1 0
## 2 0
## 3 0
## 4 0
## 5 0
## 6 19
## 7 250
## 8 0
## 9 0
## 10 0
## 11 0
## 12 20
## 13 8
## 14 0
## 15 0
## 16 0
## 17 0
## 18 0
## 19 6
## 20 0
## 21 0
## 22 0
## 23 225
## 24 0
## 25 77
## 26 0
## 27 0
## 28 0
## 29 11
## 30 0
## 31 0
## 32 34
## 33 25
## 34 1
## 35 0
## 36 0
## 37 110
## 38 0
## 39 0
## 40 0
## 41 8
## 42 0
## 43 0
## 44 175
## 45 138
## 46 0
## 47 0
## 48 267
## 49 0
## 50 34
## 51 0
## 52 0
## 53 0
## 54 0
## 55 0
## 56 0
## 57 10
## 58 0
## 59 0
## 60 0
## 61 0
## 62 0
## 63 0
## 64 0
## 65 0
## 66 0
## 67 141
## 68 0
## 69 0
## 70 76
## 71 0
## 72 8
## 73 0
## 74 0
## 75 0
## 76 0
## 77 10
## 78 0
## 79 10
## 80 0
## 81 2
## 82 0
## 83 0
## 84 0
## 85 0
## 86 0
## 87 0
## 88 0
## 89 0
## 90 0
## 91 0
## 92 0
## 93 147
## 94 6
## 95 0
## 96 0
## 97 2
## 98 0
## 99 405
## 100 17
## 101 0
## 102 0
## 103 0
## 104 0
## 105 0
## 106 23
## 107 0
## 108 0
## 109 0
## 110 32
## 111 1
## 112 121
## 113 0
## 114 0
## 115 0
## 116 0
## 117 0
## 118 0
## 119 0
## 120 0
## 121 10
## 122 24
## 123 0
## 124 79
## 125 194
## 126 5
## 127 0
## 128 0
## 129 0
## 130 176
## 131 168
## 132 0
## 133 0
## 134 0
## 135 0
## 136 0
## 137 0
## 138 0
## 139 0
## 140 0
## 141 0
## 142 0
## 143 9
## 144 23
## 145 0
## 146 330
## 147 19
## 148 0
## 149 1
## 150 0
## 151 0
## 152 0
## 153 39
## 154 4
## 155 0
## 156 0result_data <- merged_data
for (i in 2:6) {
merged_data[, i] <- as.numeric(gsub(",", "", as.character(merged_data[, i])))
merged_data[, i + 5] <- as.numeric(gsub(",", "", as.character(merged_data[, i + 5])))
result_data[, paste0("Sum_", i)] <- merged_data[, i] + merged_data[, i + 5]
}
result_data## Team Summer.Olympic.Games.Total
## 1 Afghanistan (AFG) 15
## 2 Algeria (ALG) 14
## 3 Argentina (ARG) 25
## 4 Armenia (ARM) 7
## 5 Australasia (ANZ) [ANZ] 2
## 6 Australia (AUS) [AUS][Z] 27
## 7 Austria (AUT) 28
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 17
## 10 Bahrain (BRN) 10
## 11 Barbados (BAR) [BAR] 13
## 12 Belarus (BLR) 7
## 13 Belgium (BEL) 27
## 14 Bermuda (BER) 19
## 15 Bohemia (BOH) [BOH][Z] 3
## 16 Botswana (BOT) 11
## 17 Brazil (BRA) 23
## 18 British West Indies (BWI) [BWI] 1
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 10
## 21 Burundi (BDI) 7
## 22 Cameroon (CMR) 15
## 23 Canada (CAN) 27
## 24 Chile (CHI) [I] 24
## 25 China (CHN) [CHN] 11
## 26 Chinese Taipei (TPE) [TPE][TPE2] 15
## 27 Colombia (COL) 20
## 28 Costa Rica (CRC) 16
## 29 Croatia (CRO) 8
## 30 Cuba (CUB) [Z] 21
## 31 Cyprus (CYP) 11
## 32 Czech Republic (CZE) [CZE] 7
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 28
## 35 Djibouti (DJI) [B] 9
## 36 Dominican Republic (DOM) 15
## 37 East Germany (GDR) [GDR] 5
## 38 Ecuador (ECU) 15
## 39 Egypt (EGY) [EGY][Z] 23
## 40 Eritrea (ERI) 6
## 41 Estonia (EST) 13
## 42 Ethiopia (ETH) 14
## 43 Fiji (FIJ) 15
## 44 Finland (FIN) 26
## 45 France (FRA) [O][P][Z] 29
## 46 Gabon (GAB) 11
## 47 Georgia (GEO) 7
## 48 Germany (GER) [GER][Z] 17
## 49 Ghana (GHA) [GHA] 15
## 50 Great Britain (GBR) [GBR][Z] 29
## 51 Greece (GRE) 29
## 52 Grenada (GRN) 10
## 53 Guatemala (GUA) 15
## 54 Guyana (GUY) [GUY] 18
## 55 Haiti (HAI) [J] 16
## 56 Hong Kong (HKG) [HKG] 17
## 57 Hungary (HUN) 27
## 58 Iceland (ISL) 21
## 59 Independent Olympic Athletes (IOA) [IOA] 3
## 60 Independent Olympic Participants (IOP) [IOP] 1
## 61 India (IND) [F] 25
## 62 Indonesia (INA) 16
## 63 Iran (IRI) [K] 17
## 64 Iraq (IRQ) 15
## 65 Ireland (IRL) 22
## 66 Israel (ISR) 17
## 67 Italy (ITA) [M][S] 28
## 68 Ivory Coast (CIV) [CIV] 14
## 69 Jamaica (JAM) [JAM] 18
## 70 Japan (JPN) 23
## 71 Jordan (JOR) 11
## 72 Kazakhstan (KAZ) 7
## 73 Kenya (KEN) 15
## 74 Kosovo (KOS) 2
## 75 Kuwait (KUW) 13
## 76 Kyrgyzstan (KGZ) 7
## 77 Latvia (LAT) 12
## 78 Lebanon (LBN) 18
## 79 Liechtenstein (LIE) 18
## 80 Lithuania (LTU) 10
## 81 Luxembourg (LUX) [O] 25
## 82 Malaysia (MAS) [MAS] 14
## 83 Mauritius (MRI) 10
## 84 Mexico (MEX) 24
## 85 Mixed team (ZZX) [ZZX] 3
## 86 Moldova (MDA) 7
## 87 Mongolia (MGL) 14
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 15
## 90 Mozambique (MOZ) 11
## 91 Namibia (NAM) 8
## 92 Netherlands Antilles (AHO) [AHO][I] 13
## 93 Netherlands (NED) [Z] 27
## 94 New Zealand (NZL) [NZL] 24
## 95 Niger (NIG) 13
## 96 Nigeria (NGR) 17
## 97 North Korea (PRK) 10
## 98 North Macedonia (MKD) 7
## 99 Norway (NOR) [Q] 27
## 100 Olympic Athletes from Russia (OAR) [OAR] 0
## 101 Pakistan (PAK) 18
## 102 Panama (PAN) 18
## 103 Paraguay (PAR) 13
## 104 Peru (PER) [L] 19
## 105 Philippines (PHI) 22
## 106 Poland (POL) 22
## 107 Portugal (POR) 25
## 108 Puerto Rico (PUR) 19
## 109 Qatar (QAT) 10
## 110 ROC (ROC) [ROC] 1
## 111 Romania (ROU) 22
## 112 Russia (RUS) [RUS] 6
## 113 Russian Empire (RU1) [RU1] 3
## 114 Samoa (SAM) 10
## 115 San Marino (SMR) 15
## 116 Saudi Arabia (KSA) 12
## 117 Senegal (SEN) 15
## 118 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 119 Serbia (SRB) [SRB] 5
## 120 Singapore (SGP) 17
## 121 Slovakia (SVK) [SVK] 7
## 122 Slovenia (SLO) 8
## 123 South Africa (RSA) 20
## 124 South Korea (KOR) 18
## 125 Soviet Union (URS) [URS] 9
## 126 Spain (ESP) [Z] 24
## 127 Sri Lanka (SRI) [SRI] 18
## 128 Sudan (SUD) 13
## 129 Suriname (SUR) [E] 13
## 130 Sweden (SWE) [Z] 28
## 131 Switzerland (SUI) 29
## 132 Syria (SYR) 14
## 133 Tajikistan (TJK) 7
## 134 Tanzania (TAN) [TAN] 14
## 135 Thailand (THA) 17
## 136 Togo (TOG) 11
## 137 Tonga (TGA) 10
## 138 Trinidad and Tobago (TTO) [TTO] 18
## 139 Tunisia (TUN) 15
## 140 Turkey (TUR) 23
## 141 Turkmenistan (TKM) 7
## 142 Uganda (UGA) 16
## 143 Ukraine (UKR) 7
## 144 Unified Team (EUN) [EUN] 1
## 145 United Arab Emirates (UAE) 10
## 146 United States (USA) [P][Q][R][Z][F] 28
## 147 United Team of Germany (EUA) [EUA] 3
## 148 Uruguay (URU) 22
## 149 Uzbekistan (UZB) 7
## 150 Venezuela (VEN) 19
## 151 Vietnam (VIE) 16
## 152 Virgin Islands (ISV) 13
## 153 West Germany (FRG) [FRG] 5
## 154 Yugoslavia (YUG) [YUG to 1992] 16
## 155 Zambia (ZAM) [ZAM] 14
## 156 Zimbabwe (ZIM) [ZIM] 14
## Summer.Olympic.Games.Gold.Metals Summer.Olympic.Games.Silver.Metals
## 1 0 0
## 2 5 4
## 3 21 26
## 4 2 8
## 5 3 4
## 6 164 173
## 7 20 35
## 8 7 14
## 9 8 2
## 10 2 2
## 11 0 0
## 12 13 30
## 13 44 56
## 14 1 0
## 15 0 1
## 16 0 1
## 17 37 42
## 18 0 0
## 19 54 88
## 20 0 0
## 21 1 1
## 22 3 1
## 23 71 110
## 24 2 7
## 25 263 199
## 26 7 11
## 27 5 13
## 28 1 1
## 29 14 13
## 30 84 69
## 31 0 1
## 32 19 22
## 33 49 49
## 34 48 78
## 35 0 0
## 36 3 5
## 37 153 129
## 38 3 2
## 39 8 11
## 40 0 0
## 41 10 9
## 42 23 12
## 43 2 0
## 44 101 85
## 45 223 251
## 46 0 1
## 47 10 12
## 48 201 207
## 49 0 1
## 50 284 318
## 51 35 45
## 52 1 1
## 53 0 1
## 54 0 0
## 55 0 1
## 56 2 3
## 57 181 154
## 58 0 2
## 59 1 0
## 60 0 1
## 61 10 9
## 62 8 14
## 63 24 23
## 64 0 0
## 65 11 10
## 66 3 1
## 67 217 188
## 68 1 1
## 69 26 36
## 70 169 150
## 71 1 1
## 72 14 22
## 73 35 42
## 74 3 0
## 75 0 0
## 76 0 3
## 77 4 11
## 78 0 2
## 79 0 0
## 80 6 7
## 81 2 1
## 82 0 8
## 83 0 0
## 84 13 24
## 85 11 6
## 86 0 2
## 87 2 11
## 88 0 1
## 89 7 5
## 90 1 0
## 91 0 5
## 92 0 1
## 93 95 105
## 94 53 33
## 95 0 1
## 96 3 11
## 97 16 16
## 98 0 1
## 99 61 52
## 100 0 0
## 101 3 3
## 102 1 0
## 103 0 1
## 104 1 3
## 105 1 5
## 106 72 89
## 107 5 9
## 108 2 2
## 109 2 2
## 110 20 28
## 111 90 97
## 112 147 126
## 113 1 4
## 114 0 1
## 115 0 1
## 116 0 2
## 117 0 1
## 118 2 4
## 119 6 7
## 120 1 2
## 121 10 14
## 122 8 9
## 123 27 33
## 124 96 91
## 125 395 319
## 126 48 72
## 127 0 2
## 128 0 1
## 129 1 0
## 130 147 177
## 131 53 79
## 132 1 1
## 133 1 1
## 134 0 2
## 135 10 8
## 136 0 0
## 137 0 1
## 138 3 5
## 139 5 3
## 140 41 26
## 141 0 1
## 142 4 4
## 143 35 36
## 144 45 38
## 145 1 0
## 146 1,061 830
## 147 28 54
## 148 2 2
## 149 10 6
## 150 3 7
## 151 1 3
## 152 0 1
## 153 56 67
## 154 26 29
## 155 0 1
## 156 3 4
## Summer.Olympic.Games.Bronze.Metals Summer.Olympic.Games.Metal.Total
## 1 2 2
## 2 8 17
## 3 30 77
## 4 8 18
## 5 5 12
## 6 210 547
## 7 41 96
## 8 28 49
## 9 6 16
## 10 0 4
## 11 1 1
## 12 42 85
## 13 57 157
## 14 1 2
## 15 3 4
## 16 1 2
## 17 71 150
## 18 2 2
## 19 82 224
## 20 1 1
## 21 0 2
## 22 2 6
## 23 145 326
## 24 4 13
## 25 174 636
## 26 18 36
## 27 16 34
## 28 2 4
## 29 14 41
## 30 82 235
## 31 0 1
## 32 26 67
## 33 45 143
## 34 79 205
## 35 1 1
## 36 4 12
## 37 127 409
## 38 0 5
## 39 19 38
## 40 1 1
## 41 17 36
## 42 23 58
## 43 1 3
## 44 119 305
## 45 277 751
## 46 0 1
## 47 18 40
## 48 247 655
## 49 4 5
## 50 314 916
## 51 41 121
## 52 1 3
## 53 0 1
## 54 1 1
## 55 1 2
## 56 4 9
## 57 176 511
## 58 2 4
## 59 1 2
## 60 2 3
## 61 16 35
## 62 15 37
## 63 29 76
## 64 1 1
## 65 14 35
## 66 9 13
## 67 213 618
## 68 2 4
## 69 26 88
## 70 178 497
## 71 1 3
## 72 35 71
## 73 36 113
## 74 0 3
## 75 3 3
## 76 4 7
## 77 6 21
## 78 2 4
## 79 0 0
## 80 13 26
## 81 0 3
## 82 5 13
## 83 1 1
## 84 35 72
## 85 8 25
## 86 4 6
## 87 17 30
## 88 0 1
## 89 12 24
## 90 1 2
## 91 0 5
## 92 0 1
## 93 122 322
## 94 51 137
## 95 1 2
## 96 13 27
## 97 23 55
## 98 1 2
## 99 50 163
## 100 0 0
## 101 4 10
## 102 2 3
## 103 0 1
## 104 0 4
## 105 8 14
## 106 137 298
## 107 14 28
## 108 6 10
## 109 4 8
## 110 23 71
## 111 121 308
## 112 151 424
## 113 3 8
## 114 0 1
## 115 2 3
## 116 2 4
## 117 0 1
## 118 3 9
## 119 11 24
## 120 2 5
## 121 8 32
## 122 11 28
## 123 29 89
## 124 100 287
## 125 296 1,010
## 126 49 169
## 127 0 2
## 128 0 1
## 129 1 2
## 130 179 503
## 131 74 206
## 132 2 4
## 133 2 4
## 134 0 2
## 135 17 35
## 136 1 1
## 137 0 1
## 138 11 19
## 139 7 15
## 140 36 103
## 141 0 1
## 142 3 11
## 143 68 139
## 144 29 112
## 145 1 2
## 146 738 2,629
## 147 36 118
## 148 6 10
## 149 20 36
## 150 9 19
## 151 1 5
## 152 0 1
## 153 81 204
## 154 28 83
## 155 1 2
## 156 1 8
## Winter.Olympic.Games.Total Winter.Olympic.Games.Gold.Metals
## 1 0 0
## 2 3 0
## 3 20 0
## 4 8 0
## 5 0 0
## 6 20 6
## 7 24 71
## 8 7 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 8 8
## 13 22 2
## 14 8 0
## 15 0 0
## 16 0 0
## 17 9 0
## 18 0 0
## 19 21 1
## 20 0 0
## 21 0 0
## 22 1 0
## 23 24 77
## 24 18 0
## 25 12 22
## 26 13 0
## 27 3 0
## 28 6 0
## 29 9 4
## 30 0 0
## 31 12 0
## 32 8 10
## 33 16 2
## 34 15 0
## 35 0 0
## 36 0 0
## 37 6 39
## 38 2 0
## 39 1 0
## 40 2 0
## 41 11 4
## 42 2 0
## 43 3 0
## 44 24 45
## 45 24 41
## 46 0 0
## 47 8 0
## 48 13 104
## 49 3 0
## 50 24 12
## 51 20 0
## 52 0 0
## 53 1 0
## 54 0 0
## 55 1 0
## 56 6 0
## 57 24 2
## 58 19 0
## 59 0 0
## 60 0 0
## 61 11 0
## 62 0 0
## 63 12 0
## 64 0 0
## 65 8 0
## 66 8 0
## 67 24 42
## 68 0 0
## 69 9 0
## 70 22 17
## 71 0 0
## 72 8 1
## 73 4 0
## 74 2 0
## 75 0 0
## 76 8 0
## 77 12 1
## 78 18 0
## 79 20 2
## 80 10 0
## 81 10 0
## 82 2 0
## 83 0 0
## 84 10 0
## 85 0 0
## 86 8 0
## 87 15 0
## 88 4 0
## 89 8 0
## 90 0 0
## 91 0 0
## 92 2 0
## 93 22 53
## 94 17 2
## 95 0 0
## 96 2 0
## 97 9 0
## 98 7 0
## 99 24 148
## 100 1 2
## 101 4 0
## 102 0 0
## 103 1 0
## 104 3 0
## 105 6 0
## 106 24 7
## 107 9 0
## 108 8 0
## 109 0 0
## 110 1 6
## 111 22 0
## 112 6 47
## 113 0 0
## 114 0 0
## 115 11 0
## 116 1 0
## 117 5 0
## 118 3 0
## 119 4 0
## 120 1 0
## 121 8 4
## 122 9 4
## 123 7 0
## 124 19 33
## 125 9 78
## 126 21 1
## 127 0 0
## 128 0 0
## 129 0 0
## 130 24 65
## 131 24 63
## 132 0 0
## 133 4 0
## 134 0 0
## 135 5 0
## 136 2 0
## 137 2 0
## 138 4 0
## 139 0 0
## 140 18 0
## 141 0 0
## 142 0 0
## 143 8 3
## 144 1 9
## 145 0 0
## 146 24 113
## 147 3 8
## 148 1 0
## 149 8 1
## 150 4 0
## 151 0 0
## 152 8 0
## 153 6 11
## 154 14 0
## 155 0 0
## 156 1 0
## Winter.Olympic.Games.Silver.Metals Winter.Olympic.Games.Bronze.Metals
## 1 0 0
## 2 0 0
## 3 0 0
## 4 0 0
## 5 0 0
## 6 7 6
## 7 88 91
## 8 0 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 7 5
## 13 2 4
## 14 0 0
## 15 0 0
## 16 0 0
## 17 0 0
## 18 0 0
## 19 2 3
## 20 0 0
## 21 0 0
## 22 0 0
## 23 72 76
## 24 0 0
## 25 32 23
## 26 0 0
## 27 0 0
## 28 0 0
## 29 6 1
## 30 0 0
## 31 0 0
## 32 11 13
## 33 8 15
## 34 1 0
## 35 0 0
## 36 0 0
## 37 36 35
## 38 0 0
## 39 0 0
## 40 0 0
## 41 2 2
## 42 0 0
## 43 0 0
## 44 65 65
## 45 42 55
## 46 0 0
## 47 0 0
## 48 98 65
## 49 0 0
## 50 5 17
## 51 0 0
## 52 0 0
## 53 0 0
## 54 0 0
## 55 0 0
## 56 0 0
## 57 2 6
## 58 0 0
## 59 0 0
## 60 0 0
## 61 0 0
## 62 0 0
## 63 0 0
## 64 0 0
## 65 0 0
## 66 0 0
## 67 43 56
## 68 0 0
## 69 0 0
## 70 28 31
## 71 0 0
## 72 3 4
## 73 0 0
## 74 0 0
## 75 0 0
## 76 0 0
## 77 3 6
## 78 0 0
## 79 2 6
## 80 0 0
## 81 2 0
## 82 0 0
## 83 0 0
## 84 0 0
## 85 0 0
## 86 0 0
## 87 0 0
## 88 0 0
## 89 0 0
## 90 0 0
## 91 0 0
## 92 0 0
## 93 49 45
## 94 2 2
## 95 0 0
## 96 0 0
## 97 1 1
## 98 0 0
## 99 134 123
## 100 6 9
## 101 0 0
## 102 0 0
## 103 0 0
## 104 0 0
## 105 0 0
## 106 7 9
## 107 0 0
## 108 0 0
## 109 0 0
## 110 12 14
## 111 0 1
## 112 39 35
## 113 0 0
## 114 0 0
## 115 0 0
## 116 0 0
## 117 0 0
## 118 0 0
## 119 0 0
## 120 0 0
## 121 4 2
## 122 8 12
## 123 0 0
## 124 30 16
## 125 57 59
## 126 1 3
## 127 0 0
## 128 0 0
## 129 0 0
## 130 51 60
## 131 47 58
## 132 0 0
## 133 0 0
## 134 0 0
## 135 0 0
## 136 0 0
## 137 0 0
## 138 0 0
## 139 0 0
## 140 0 0
## 141 0 0
## 142 0 0
## 143 2 4
## 144 6 8
## 145 0 0
## 146 122 95
## 147 6 5
## 148 0 0
## 149 0 0
## 150 0 0
## 151 0 0
## 152 0 0
## 153 15 13
## 154 3 1
## 155 0 0
## 156 0 0
## Winter.Olympic.Games.Metal.Total Sum_2 Sum_3 Sum_4 Sum_5 Sum_6
## 1 0 15 0 0 2 2
## 2 0 17 5 4 8 17
## 3 0 45 21 26 30 77
## 4 0 15 2 8 8 18
## 5 0 2 3 4 5 12
## 6 19 47 170 180 216 566
## 7 250 52 91 123 132 346
## 8 0 14 7 14 28 49
## 9 0 17 8 2 6 16
## 10 0 10 2 2 0 4
## 11 0 13 0 0 1 1
## 12 20 15 21 37 47 105
## 13 8 49 46 58 61 165
## 14 0 27 1 0 1 2
## 15 0 3 0 1 3 4
## 16 0 11 0 1 1 2
## 17 0 32 37 42 71 150
## 18 0 1 0 0 2 2
## 19 6 42 55 90 85 230
## 20 0 10 0 0 1 1
## 21 0 7 1 1 0 2
## 22 0 16 3 1 2 6
## 23 225 51 148 182 221 551
## 24 0 42 2 7 4 13
## 25 77 23 285 231 197 713
## 26 0 28 7 11 18 36
## 27 0 23 5 13 16 34
## 28 0 22 1 1 2 4
## 29 11 17 18 19 15 52
## 30 0 21 84 69 82 235
## 31 0 23 0 1 0 1
## 32 34 15 29 33 39 101
## 33 25 32 51 57 60 168
## 34 1 43 48 79 79 206
## 35 0 9 0 0 1 1
## 36 0 15 3 5 4 12
## 37 110 11 192 165 162 519
## 38 0 17 3 2 0 5
## 39 0 24 8 11 19 38
## 40 0 8 0 0 1 1
## 41 8 24 14 11 19 44
## 42 0 16 23 12 23 58
## 43 0 18 2 0 1 3
## 44 175 50 146 150 184 480
## 45 138 53 264 293 332 889
## 46 0 11 0 1 0 1
## 47 0 15 10 12 18 40
## 48 267 30 305 305 312 922
## 49 0 18 0 1 4 5
## 50 34 53 296 323 331 950
## 51 0 49 35 45 41 121
## 52 0 10 1 1 1 3
## 53 0 16 0 1 0 1
## 54 0 18 0 0 1 1
## 55 0 17 0 1 1 2
## 56 0 23 2 3 4 9
## 57 10 51 183 156 182 521
## 58 0 40 0 2 2 4
## 59 0 3 1 0 1 2
## 60 0 1 0 1 2 3
## 61 0 36 10 9 16 35
## 62 0 16 8 14 15 37
## 63 0 29 24 23 29 76
## 64 0 15 0 0 1 1
## 65 0 30 11 10 14 35
## 66 0 25 3 1 9 13
## 67 141 52 259 231 269 759
## 68 0 14 1 1 2 4
## 69 0 27 26 36 26 88
## 70 76 45 186 178 209 573
## 71 0 11 1 1 1 3
## 72 8 15 15 25 39 79
## 73 0 19 35 42 36 113
## 74 0 4 3 0 0 3
## 75 0 13 0 0 3 3
## 76 0 15 0 3 4 7
## 77 10 24 5 14 12 31
## 78 0 36 0 2 2 4
## 79 10 38 2 2 6 10
## 80 0 20 6 7 13 26
## 81 2 35 2 3 0 5
## 82 0 16 0 8 5 13
## 83 0 10 0 0 1 1
## 84 0 34 13 24 35 72
## 85 0 3 11 6 8 25
## 86 0 15 0 2 4 6
## 87 0 29 2 11 17 30
## 88 0 8 0 1 0 1
## 89 0 23 7 5 12 24
## 90 0 11 1 0 1 2
## 91 0 8 0 5 0 5
## 92 0 15 0 1 0 1
## 93 147 49 148 154 167 469
## 94 6 41 55 35 53 143
## 95 0 13 0 1 1 2
## 96 0 19 3 11 13 27
## 97 2 19 16 17 24 57
## 98 0 14 0 1 1 2
## 99 405 51 209 186 173 568
## 100 17 1 2 6 9 17
## 101 0 22 3 3 4 10
## 102 0 18 1 0 2 3
## 103 0 14 0 1 0 1
## 104 0 22 1 3 0 4
## 105 0 28 1 5 8 14
## 106 23 46 79 96 146 321
## 107 0 34 5 9 14 28
## 108 0 27 2 2 6 10
## 109 0 10 2 2 4 8
## 110 32 2 26 40 37 103
## 111 1 44 90 97 122 309
## 112 121 12 194 165 186 545
## 113 0 3 1 4 3 8
## 114 0 10 0 1 0 1
## 115 0 26 0 1 2 3
## 116 0 13 0 2 2 4
## 117 0 20 0 1 0 1
## 118 0 6 2 4 3 9
## 119 0 9 6 7 11 24
## 120 0 18 1 2 2 5
## 121 10 15 14 18 10 42
## 122 24 17 12 17 23 52
## 123 0 27 27 33 29 89
## 124 79 37 129 121 116 366
## 125 194 18 473 376 355 1204
## 126 5 45 49 73 52 174
## 127 0 18 0 2 0 2
## 128 0 13 0 1 0 1
## 129 0 13 1 0 1 2
## 130 176 52 212 228 239 679
## 131 168 53 116 126 132 374
## 132 0 14 1 1 2 4
## 133 0 11 1 1 2 4
## 134 0 14 0 2 0 2
## 135 0 22 10 8 17 35
## 136 0 13 0 0 1 1
## 137 0 12 0 1 0 1
## 138 0 22 3 5 11 19
## 139 0 15 5 3 7 15
## 140 0 41 41 26 36 103
## 141 0 7 0 1 0 1
## 142 0 16 4 4 3 11
## 143 9 15 38 38 72 148
## 144 23 2 54 44 37 135
## 145 0 10 1 0 1 2
## 146 330 52 1174 952 833 2959
## 147 19 6 36 60 41 137
## 148 0 23 2 2 6 10
## 149 1 15 11 6 20 37
## 150 0 23 3 7 9 19
## 151 0 16 1 3 1 5
## 152 0 21 0 1 0 1
## 153 39 11 67 82 94 243
## 154 4 30 26 32 29 87
## 155 0 14 0 1 1 2
## 156 0 15 3 4 1 8col_names <- colnames(result_data)
col_names[12] <- "Combined.Olympic.Games.Total"
col_names[13] <- "Combined.Olympic.Games.Gold.Metals"
col_names[14] <- "Combined.Olympic.Games.Silver.Metals"
col_names[15] <- "Combined.Olympic.Games.Bronze.Metals"
col_names[16] <- "Combined.Olympic.Games.Metal.Total"
colnames(result_data) <- col_names
result_data## Team Summer.Olympic.Games.Total
## 1 Afghanistan (AFG) 15
## 2 Algeria (ALG) 14
## 3 Argentina (ARG) 25
## 4 Armenia (ARM) 7
## 5 Australasia (ANZ) [ANZ] 2
## 6 Australia (AUS) [AUS][Z] 27
## 7 Austria (AUT) 28
## 8 Azerbaijan (AZE) 7
## 9 Bahamas (BAH) 17
## 10 Bahrain (BRN) 10
## 11 Barbados (BAR) [BAR] 13
## 12 Belarus (BLR) 7
## 13 Belgium (BEL) 27
## 14 Bermuda (BER) 19
## 15 Bohemia (BOH) [BOH][Z] 3
## 16 Botswana (BOT) 11
## 17 Brazil (BRA) 23
## 18 British West Indies (BWI) [BWI] 1
## 19 Bulgaria (BUL) [H] 21
## 20 Burkina Faso (BUR) 10
## 21 Burundi (BDI) 7
## 22 Cameroon (CMR) 15
## 23 Canada (CAN) 27
## 24 Chile (CHI) [I] 24
## 25 China (CHN) [CHN] 11
## 26 Chinese Taipei (TPE) [TPE][TPE2] 15
## 27 Colombia (COL) 20
## 28 Costa Rica (CRC) 16
## 29 Croatia (CRO) 8
## 30 Cuba (CUB) [Z] 21
## 31 Cyprus (CYP) 11
## 32 Czech Republic (CZE) [CZE] 7
## 33 Czechoslovakia (TCH) [TCH] 16
## 34 Denmark (DEN) [Z] 28
## 35 Djibouti (DJI) [B] 9
## 36 Dominican Republic (DOM) 15
## 37 East Germany (GDR) [GDR] 5
## 38 Ecuador (ECU) 15
## 39 Egypt (EGY) [EGY][Z] 23
## 40 Eritrea (ERI) 6
## 41 Estonia (EST) 13
## 42 Ethiopia (ETH) 14
## 43 Fiji (FIJ) 15
## 44 Finland (FIN) 26
## 45 France (FRA) [O][P][Z] 29
## 46 Gabon (GAB) 11
## 47 Georgia (GEO) 7
## 48 Germany (GER) [GER][Z] 17
## 49 Ghana (GHA) [GHA] 15
## 50 Great Britain (GBR) [GBR][Z] 29
## 51 Greece (GRE) 29
## 52 Grenada (GRN) 10
## 53 Guatemala (GUA) 15
## 54 Guyana (GUY) [GUY] 18
## 55 Haiti (HAI) [J] 16
## 56 Hong Kong (HKG) [HKG] 17
## 57 Hungary (HUN) 27
## 58 Iceland (ISL) 21
## 59 Independent Olympic Athletes (IOA) [IOA] 3
## 60 Independent Olympic Participants (IOP) [IOP] 1
## 61 India (IND) [F] 25
## 62 Indonesia (INA) 16
## 63 Iran (IRI) [K] 17
## 64 Iraq (IRQ) 15
## 65 Ireland (IRL) 22
## 66 Israel (ISR) 17
## 67 Italy (ITA) [M][S] 28
## 68 Ivory Coast (CIV) [CIV] 14
## 69 Jamaica (JAM) [JAM] 18
## 70 Japan (JPN) 23
## 71 Jordan (JOR) 11
## 72 Kazakhstan (KAZ) 7
## 73 Kenya (KEN) 15
## 74 Kosovo (KOS) 2
## 75 Kuwait (KUW) 13
## 76 Kyrgyzstan (KGZ) 7
## 77 Latvia (LAT) 12
## 78 Lebanon (LBN) 18
## 79 Liechtenstein (LIE) 18
## 80 Lithuania (LTU) 10
## 81 Luxembourg (LUX) [O] 25
## 82 Malaysia (MAS) [MAS] 14
## 83 Mauritius (MRI) 10
## 84 Mexico (MEX) 24
## 85 Mixed team (ZZX) [ZZX] 3
## 86 Moldova (MDA) 7
## 87 Mongolia (MGL) 14
## 88 Montenegro (MNE) 4
## 89 Morocco (MAR) 15
## 90 Mozambique (MOZ) 11
## 91 Namibia (NAM) 8
## 92 Netherlands Antilles (AHO) [AHO][I] 13
## 93 Netherlands (NED) [Z] 27
## 94 New Zealand (NZL) [NZL] 24
## 95 Niger (NIG) 13
## 96 Nigeria (NGR) 17
## 97 North Korea (PRK) 10
## 98 North Macedonia (MKD) 7
## 99 Norway (NOR) [Q] 27
## 100 Olympic Athletes from Russia (OAR) [OAR] 0
## 101 Pakistan (PAK) 18
## 102 Panama (PAN) 18
## 103 Paraguay (PAR) 13
## 104 Peru (PER) [L] 19
## 105 Philippines (PHI) 22
## 106 Poland (POL) 22
## 107 Portugal (POR) 25
## 108 Puerto Rico (PUR) 19
## 109 Qatar (QAT) 10
## 110 ROC (ROC) [ROC] 1
## 111 Romania (ROU) 22
## 112 Russia (RUS) [RUS] 6
## 113 Russian Empire (RU1) [RU1] 3
## 114 Samoa (SAM) 10
## 115 San Marino (SMR) 15
## 116 Saudi Arabia (KSA) 12
## 117 Senegal (SEN) 15
## 118 Serbia and Montenegro (SCG) [YUG/SCG] 3
## 119 Serbia (SRB) [SRB] 5
## 120 Singapore (SGP) 17
## 121 Slovakia (SVK) [SVK] 7
## 122 Slovenia (SLO) 8
## 123 South Africa (RSA) 20
## 124 South Korea (KOR) 18
## 125 Soviet Union (URS) [URS] 9
## 126 Spain (ESP) [Z] 24
## 127 Sri Lanka (SRI) [SRI] 18
## 128 Sudan (SUD) 13
## 129 Suriname (SUR) [E] 13
## 130 Sweden (SWE) [Z] 28
## 131 Switzerland (SUI) 29
## 132 Syria (SYR) 14
## 133 Tajikistan (TJK) 7
## 134 Tanzania (TAN) [TAN] 14
## 135 Thailand (THA) 17
## 136 Togo (TOG) 11
## 137 Tonga (TGA) 10
## 138 Trinidad and Tobago (TTO) [TTO] 18
## 139 Tunisia (TUN) 15
## 140 Turkey (TUR) 23
## 141 Turkmenistan (TKM) 7
## 142 Uganda (UGA) 16
## 143 Ukraine (UKR) 7
## 144 Unified Team (EUN) [EUN] 1
## 145 United Arab Emirates (UAE) 10
## 146 United States (USA) [P][Q][R][Z][F] 28
## 147 United Team of Germany (EUA) [EUA] 3
## 148 Uruguay (URU) 22
## 149 Uzbekistan (UZB) 7
## 150 Venezuela (VEN) 19
## 151 Vietnam (VIE) 16
## 152 Virgin Islands (ISV) 13
## 153 West Germany (FRG) [FRG] 5
## 154 Yugoslavia (YUG) [YUG to 1992] 16
## 155 Zambia (ZAM) [ZAM] 14
## 156 Zimbabwe (ZIM) [ZIM] 14
## Summer.Olympic.Games.Gold.Metals Summer.Olympic.Games.Silver.Metals
## 1 0 0
## 2 5 4
## 3 21 26
## 4 2 8
## 5 3 4
## 6 164 173
## 7 20 35
## 8 7 14
## 9 8 2
## 10 2 2
## 11 0 0
## 12 13 30
## 13 44 56
## 14 1 0
## 15 0 1
## 16 0 1
## 17 37 42
## 18 0 0
## 19 54 88
## 20 0 0
## 21 1 1
## 22 3 1
## 23 71 110
## 24 2 7
## 25 263 199
## 26 7 11
## 27 5 13
## 28 1 1
## 29 14 13
## 30 84 69
## 31 0 1
## 32 19 22
## 33 49 49
## 34 48 78
## 35 0 0
## 36 3 5
## 37 153 129
## 38 3 2
## 39 8 11
## 40 0 0
## 41 10 9
## 42 23 12
## 43 2 0
## 44 101 85
## 45 223 251
## 46 0 1
## 47 10 12
## 48 201 207
## 49 0 1
## 50 284 318
## 51 35 45
## 52 1 1
## 53 0 1
## 54 0 0
## 55 0 1
## 56 2 3
## 57 181 154
## 58 0 2
## 59 1 0
## 60 0 1
## 61 10 9
## 62 8 14
## 63 24 23
## 64 0 0
## 65 11 10
## 66 3 1
## 67 217 188
## 68 1 1
## 69 26 36
## 70 169 150
## 71 1 1
## 72 14 22
## 73 35 42
## 74 3 0
## 75 0 0
## 76 0 3
## 77 4 11
## 78 0 2
## 79 0 0
## 80 6 7
## 81 2 1
## 82 0 8
## 83 0 0
## 84 13 24
## 85 11 6
## 86 0 2
## 87 2 11
## 88 0 1
## 89 7 5
## 90 1 0
## 91 0 5
## 92 0 1
## 93 95 105
## 94 53 33
## 95 0 1
## 96 3 11
## 97 16 16
## 98 0 1
## 99 61 52
## 100 0 0
## 101 3 3
## 102 1 0
## 103 0 1
## 104 1 3
## 105 1 5
## 106 72 89
## 107 5 9
## 108 2 2
## 109 2 2
## 110 20 28
## 111 90 97
## 112 147 126
## 113 1 4
## 114 0 1
## 115 0 1
## 116 0 2
## 117 0 1
## 118 2 4
## 119 6 7
## 120 1 2
## 121 10 14
## 122 8 9
## 123 27 33
## 124 96 91
## 125 395 319
## 126 48 72
## 127 0 2
## 128 0 1
## 129 1 0
## 130 147 177
## 131 53 79
## 132 1 1
## 133 1 1
## 134 0 2
## 135 10 8
## 136 0 0
## 137 0 1
## 138 3 5
## 139 5 3
## 140 41 26
## 141 0 1
## 142 4 4
## 143 35 36
## 144 45 38
## 145 1 0
## 146 1,061 830
## 147 28 54
## 148 2 2
## 149 10 6
## 150 3 7
## 151 1 3
## 152 0 1
## 153 56 67
## 154 26 29
## 155 0 1
## 156 3 4
## Summer.Olympic.Games.Bronze.Metals Summer.Olympic.Games.Metal.Total
## 1 2 2
## 2 8 17
## 3 30 77
## 4 8 18
## 5 5 12
## 6 210 547
## 7 41 96
## 8 28 49
## 9 6 16
## 10 0 4
## 11 1 1
## 12 42 85
## 13 57 157
## 14 1 2
## 15 3 4
## 16 1 2
## 17 71 150
## 18 2 2
## 19 82 224
## 20 1 1
## 21 0 2
## 22 2 6
## 23 145 326
## 24 4 13
## 25 174 636
## 26 18 36
## 27 16 34
## 28 2 4
## 29 14 41
## 30 82 235
## 31 0 1
## 32 26 67
## 33 45 143
## 34 79 205
## 35 1 1
## 36 4 12
## 37 127 409
## 38 0 5
## 39 19 38
## 40 1 1
## 41 17 36
## 42 23 58
## 43 1 3
## 44 119 305
## 45 277 751
## 46 0 1
## 47 18 40
## 48 247 655
## 49 4 5
## 50 314 916
## 51 41 121
## 52 1 3
## 53 0 1
## 54 1 1
## 55 1 2
## 56 4 9
## 57 176 511
## 58 2 4
## 59 1 2
## 60 2 3
## 61 16 35
## 62 15 37
## 63 29 76
## 64 1 1
## 65 14 35
## 66 9 13
## 67 213 618
## 68 2 4
## 69 26 88
## 70 178 497
## 71 1 3
## 72 35 71
## 73 36 113
## 74 0 3
## 75 3 3
## 76 4 7
## 77 6 21
## 78 2 4
## 79 0 0
## 80 13 26
## 81 0 3
## 82 5 13
## 83 1 1
## 84 35 72
## 85 8 25
## 86 4 6
## 87 17 30
## 88 0 1
## 89 12 24
## 90 1 2
## 91 0 5
## 92 0 1
## 93 122 322
## 94 51 137
## 95 1 2
## 96 13 27
## 97 23 55
## 98 1 2
## 99 50 163
## 100 0 0
## 101 4 10
## 102 2 3
## 103 0 1
## 104 0 4
## 105 8 14
## 106 137 298
## 107 14 28
## 108 6 10
## 109 4 8
## 110 23 71
## 111 121 308
## 112 151 424
## 113 3 8
## 114 0 1
## 115 2 3
## 116 2 4
## 117 0 1
## 118 3 9
## 119 11 24
## 120 2 5
## 121 8 32
## 122 11 28
## 123 29 89
## 124 100 287
## 125 296 1,010
## 126 49 169
## 127 0 2
## 128 0 1
## 129 1 2
## 130 179 503
## 131 74 206
## 132 2 4
## 133 2 4
## 134 0 2
## 135 17 35
## 136 1 1
## 137 0 1
## 138 11 19
## 139 7 15
## 140 36 103
## 141 0 1
## 142 3 11
## 143 68 139
## 144 29 112
## 145 1 2
## 146 738 2,629
## 147 36 118
## 148 6 10
## 149 20 36
## 150 9 19
## 151 1 5
## 152 0 1
## 153 81 204
## 154 28 83
## 155 1 2
## 156 1 8
## Winter.Olympic.Games.Total Winter.Olympic.Games.Gold.Metals
## 1 0 0
## 2 3 0
## 3 20 0
## 4 8 0
## 5 0 0
## 6 20 6
## 7 24 71
## 8 7 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 8 8
## 13 22 2
## 14 8 0
## 15 0 0
## 16 0 0
## 17 9 0
## 18 0 0
## 19 21 1
## 20 0 0
## 21 0 0
## 22 1 0
## 23 24 77
## 24 18 0
## 25 12 22
## 26 13 0
## 27 3 0
## 28 6 0
## 29 9 4
## 30 0 0
## 31 12 0
## 32 8 10
## 33 16 2
## 34 15 0
## 35 0 0
## 36 0 0
## 37 6 39
## 38 2 0
## 39 1 0
## 40 2 0
## 41 11 4
## 42 2 0
## 43 3 0
## 44 24 45
## 45 24 41
## 46 0 0
## 47 8 0
## 48 13 104
## 49 3 0
## 50 24 12
## 51 20 0
## 52 0 0
## 53 1 0
## 54 0 0
## 55 1 0
## 56 6 0
## 57 24 2
## 58 19 0
## 59 0 0
## 60 0 0
## 61 11 0
## 62 0 0
## 63 12 0
## 64 0 0
## 65 8 0
## 66 8 0
## 67 24 42
## 68 0 0
## 69 9 0
## 70 22 17
## 71 0 0
## 72 8 1
## 73 4 0
## 74 2 0
## 75 0 0
## 76 8 0
## 77 12 1
## 78 18 0
## 79 20 2
## 80 10 0
## 81 10 0
## 82 2 0
## 83 0 0
## 84 10 0
## 85 0 0
## 86 8 0
## 87 15 0
## 88 4 0
## 89 8 0
## 90 0 0
## 91 0 0
## 92 2 0
## 93 22 53
## 94 17 2
## 95 0 0
## 96 2 0
## 97 9 0
## 98 7 0
## 99 24 148
## 100 1 2
## 101 4 0
## 102 0 0
## 103 1 0
## 104 3 0
## 105 6 0
## 106 24 7
## 107 9 0
## 108 8 0
## 109 0 0
## 110 1 6
## 111 22 0
## 112 6 47
## 113 0 0
## 114 0 0
## 115 11 0
## 116 1 0
## 117 5 0
## 118 3 0
## 119 4 0
## 120 1 0
## 121 8 4
## 122 9 4
## 123 7 0
## 124 19 33
## 125 9 78
## 126 21 1
## 127 0 0
## 128 0 0
## 129 0 0
## 130 24 65
## 131 24 63
## 132 0 0
## 133 4 0
## 134 0 0
## 135 5 0
## 136 2 0
## 137 2 0
## 138 4 0
## 139 0 0
## 140 18 0
## 141 0 0
## 142 0 0
## 143 8 3
## 144 1 9
## 145 0 0
## 146 24 113
## 147 3 8
## 148 1 0
## 149 8 1
## 150 4 0
## 151 0 0
## 152 8 0
## 153 6 11
## 154 14 0
## 155 0 0
## 156 1 0
## Winter.Olympic.Games.Silver.Metals Winter.Olympic.Games.Bronze.Metals
## 1 0 0
## 2 0 0
## 3 0 0
## 4 0 0
## 5 0 0
## 6 7 6
## 7 88 91
## 8 0 0
## 9 0 0
## 10 0 0
## 11 0 0
## 12 7 5
## 13 2 4
## 14 0 0
## 15 0 0
## 16 0 0
## 17 0 0
## 18 0 0
## 19 2 3
## 20 0 0
## 21 0 0
## 22 0 0
## 23 72 76
## 24 0 0
## 25 32 23
## 26 0 0
## 27 0 0
## 28 0 0
## 29 6 1
## 30 0 0
## 31 0 0
## 32 11 13
## 33 8 15
## 34 1 0
## 35 0 0
## 36 0 0
## 37 36 35
## 38 0 0
## 39 0 0
## 40 0 0
## 41 2 2
## 42 0 0
## 43 0 0
## 44 65 65
## 45 42 55
## 46 0 0
## 47 0 0
## 48 98 65
## 49 0 0
## 50 5 17
## 51 0 0
## 52 0 0
## 53 0 0
## 54 0 0
## 55 0 0
## 56 0 0
## 57 2 6
## 58 0 0
## 59 0 0
## 60 0 0
## 61 0 0
## 62 0 0
## 63 0 0
## 64 0 0
## 65 0 0
## 66 0 0
## 67 43 56
## 68 0 0
## 69 0 0
## 70 28 31
## 71 0 0
## 72 3 4
## 73 0 0
## 74 0 0
## 75 0 0
## 76 0 0
## 77 3 6
## 78 0 0
## 79 2 6
## 80 0 0
## 81 2 0
## 82 0 0
## 83 0 0
## 84 0 0
## 85 0 0
## 86 0 0
## 87 0 0
## 88 0 0
## 89 0 0
## 90 0 0
## 91 0 0
## 92 0 0
## 93 49 45
## 94 2 2
## 95 0 0
## 96 0 0
## 97 1 1
## 98 0 0
## 99 134 123
## 100 6 9
## 101 0 0
## 102 0 0
## 103 0 0
## 104 0 0
## 105 0 0
## 106 7 9
## 107 0 0
## 108 0 0
## 109 0 0
## 110 12 14
## 111 0 1
## 112 39 35
## 113 0 0
## 114 0 0
## 115 0 0
## 116 0 0
## 117 0 0
## 118 0 0
## 119 0 0
## 120 0 0
## 121 4 2
## 122 8 12
## 123 0 0
## 124 30 16
## 125 57 59
## 126 1 3
## 127 0 0
## 128 0 0
## 129 0 0
## 130 51 60
## 131 47 58
## 132 0 0
## 133 0 0
## 134 0 0
## 135 0 0
## 136 0 0
## 137 0 0
## 138 0 0
## 139 0 0
## 140 0 0
## 141 0 0
## 142 0 0
## 143 2 4
## 144 6 8
## 145 0 0
## 146 122 95
## 147 6 5
## 148 0 0
## 149 0 0
## 150 0 0
## 151 0 0
## 152 0 0
## 153 15 13
## 154 3 1
## 155 0 0
## 156 0 0
## Winter.Olympic.Games.Metal.Total Combined.Olympic.Games.Total
## 1 0 15
## 2 0 17
## 3 0 45
## 4 0 15
## 5 0 2
## 6 19 47
## 7 250 52
## 8 0 14
## 9 0 17
## 10 0 10
## 11 0 13
## 12 20 15
## 13 8 49
## 14 0 27
## 15 0 3
## 16 0 11
## 17 0 32
## 18 0 1
## 19 6 42
## 20 0 10
## 21 0 7
## 22 0 16
## 23 225 51
## 24 0 42
## 25 77 23
## 26 0 28
## 27 0 23
## 28 0 22
## 29 11 17
## 30 0 21
## 31 0 23
## 32 34 15
## 33 25 32
## 34 1 43
## 35 0 9
## 36 0 15
## 37 110 11
## 38 0 17
## 39 0 24
## 40 0 8
## 41 8 24
## 42 0 16
## 43 0 18
## 44 175 50
## 45 138 53
## 46 0 11
## 47 0 15
## 48 267 30
## 49 0 18
## 50 34 53
## 51 0 49
## 52 0 10
## 53 0 16
## 54 0 18
## 55 0 17
## 56 0 23
## 57 10 51
## 58 0 40
## 59 0 3
## 60 0 1
## 61 0 36
## 62 0 16
## 63 0 29
## 64 0 15
## 65 0 30
## 66 0 25
## 67 141 52
## 68 0 14
## 69 0 27
## 70 76 45
## 71 0 11
## 72 8 15
## 73 0 19
## 74 0 4
## 75 0 13
## 76 0 15
## 77 10 24
## 78 0 36
## 79 10 38
## 80 0 20
## 81 2 35
## 82 0 16
## 83 0 10
## 84 0 34
## 85 0 3
## 86 0 15
## 87 0 29
## 88 0 8
## 89 0 23
## 90 0 11
## 91 0 8
## 92 0 15
## 93 147 49
## 94 6 41
## 95 0 13
## 96 0 19
## 97 2 19
## 98 0 14
## 99 405 51
## 100 17 1
## 101 0 22
## 102 0 18
## 103 0 14
## 104 0 22
## 105 0 28
## 106 23 46
## 107 0 34
## 108 0 27
## 109 0 10
## 110 32 2
## 111 1 44
## 112 121 12
## 113 0 3
## 114 0 10
## 115 0 26
## 116 0 13
## 117 0 20
## 118 0 6
## 119 0 9
## 120 0 18
## 121 10 15
## 122 24 17
## 123 0 27
## 124 79 37
## 125 194 18
## 126 5 45
## 127 0 18
## 128 0 13
## 129 0 13
## 130 176 52
## 131 168 53
## 132 0 14
## 133 0 11
## 134 0 14
## 135 0 22
## 136 0 13
## 137 0 12
## 138 0 22
## 139 0 15
## 140 0 41
## 141 0 7
## 142 0 16
## 143 9 15
## 144 23 2
## 145 0 10
## 146 330 52
## 147 19 6
## 148 0 23
## 149 1 15
## 150 0 23
## 151 0 16
## 152 0 21
## 153 39 11
## 154 4 30
## 155 0 14
## 156 0 15
## Combined.Olympic.Games.Gold.Metals Combined.Olympic.Games.Silver.Metals
## 1 0 0
## 2 5 4
## 3 21 26
## 4 2 8
## 5 3 4
## 6 170 180
## 7 91 123
## 8 7 14
## 9 8 2
## 10 2 2
## 11 0 0
## 12 21 37
## 13 46 58
## 14 1 0
## 15 0 1
## 16 0 1
## 17 37 42
## 18 0 0
## 19 55 90
## 20 0 0
## 21 1 1
## 22 3 1
## 23 148 182
## 24 2 7
## 25 285 231
## 26 7 11
## 27 5 13
## 28 1 1
## 29 18 19
## 30 84 69
## 31 0 1
## 32 29 33
## 33 51 57
## 34 48 79
## 35 0 0
## 36 3 5
## 37 192 165
## 38 3 2
## 39 8 11
## 40 0 0
## 41 14 11
## 42 23 12
## 43 2 0
## 44 146 150
## 45 264 293
## 46 0 1
## 47 10 12
## 48 305 305
## 49 0 1
## 50 296 323
## 51 35 45
## 52 1 1
## 53 0 1
## 54 0 0
## 55 0 1
## 56 2 3
## 57 183 156
## 58 0 2
## 59 1 0
## 60 0 1
## 61 10 9
## 62 8 14
## 63 24 23
## 64 0 0
## 65 11 10
## 66 3 1
## 67 259 231
## 68 1 1
## 69 26 36
## 70 186 178
## 71 1 1
## 72 15 25
## 73 35 42
## 74 3 0
## 75 0 0
## 76 0 3
## 77 5 14
## 78 0 2
## 79 2 2
## 80 6 7
## 81 2 3
## 82 0 8
## 83 0 0
## 84 13 24
## 85 11 6
## 86 0 2
## 87 2 11
## 88 0 1
## 89 7 5
## 90 1 0
## 91 0 5
## 92 0 1
## 93 148 154
## 94 55 35
## 95 0 1
## 96 3 11
## 97 16 17
## 98 0 1
## 99 209 186
## 100 2 6
## 101 3 3
## 102 1 0
## 103 0 1
## 104 1 3
## 105 1 5
## 106 79 96
## 107 5 9
## 108 2 2
## 109 2 2
## 110 26 40
## 111 90 97
## 112 194 165
## 113 1 4
## 114 0 1
## 115 0 1
## 116 0 2
## 117 0 1
## 118 2 4
## 119 6 7
## 120 1 2
## 121 14 18
## 122 12 17
## 123 27 33
## 124 129 121
## 125 473 376
## 126 49 73
## 127 0 2
## 128 0 1
## 129 1 0
## 130 212 228
## 131 116 126
## 132 1 1
## 133 1 1
## 134 0 2
## 135 10 8
## 136 0 0
## 137 0 1
## 138 3 5
## 139 5 3
## 140 41 26
## 141 0 1
## 142 4 4
## 143 38 38
## 144 54 44
## 145 1 0
## 146 1174 952
## 147 36 60
## 148 2 2
## 149 11 6
## 150 3 7
## 151 1 3
## 152 0 1
## 153 67 82
## 154 26 32
## 155 0 1
## 156 3 4
## Combined.Olympic.Games.Bronze.Metals Combined.Olympic.Games.Metal.Total
## 1 2 2
## 2 8 17
## 3 30 77
## 4 8 18
## 5 5 12
## 6 216 566
## 7 132 346
## 8 28 49
## 9 6 16
## 10 0 4
## 11 1 1
## 12 47 105
## 13 61 165
## 14 1 2
## 15 3 4
## 16 1 2
## 17 71 150
## 18 2 2
## 19 85 230
## 20 1 1
## 21 0 2
## 22 2 6
## 23 221 551
## 24 4 13
## 25 197 713
## 26 18 36
## 27 16 34
## 28 2 4
## 29 15 52
## 30 82 235
## 31 0 1
## 32 39 101
## 33 60 168
## 34 79 206
## 35 1 1
## 36 4 12
## 37 162 519
## 38 0 5
## 39 19 38
## 40 1 1
## 41 19 44
## 42 23 58
## 43 1 3
## 44 184 480
## 45 332 889
## 46 0 1
## 47 18 40
## 48 312 922
## 49 4 5
## 50 331 950
## 51 41 121
## 52 1 3
## 53 0 1
## 54 1 1
## 55 1 2
## 56 4 9
## 57 182 521
## 58 2 4
## 59 1 2
## 60 2 3
## 61 16 35
## 62 15 37
## 63 29 76
## 64 1 1
## 65 14 35
## 66 9 13
## 67 269 759
## 68 2 4
## 69 26 88
## 70 209 573
## 71 1 3
## 72 39 79
## 73 36 113
## 74 0 3
## 75 3 3
## 76 4 7
## 77 12 31
## 78 2 4
## 79 6 10
## 80 13 26
## 81 0 5
## 82 5 13
## 83 1 1
## 84 35 72
## 85 8 25
## 86 4 6
## 87 17 30
## 88 0 1
## 89 12 24
## 90 1 2
## 91 0 5
## 92 0 1
## 93 167 469
## 94 53 143
## 95 1 2
## 96 13 27
## 97 24 57
## 98 1 2
## 99 173 568
## 100 9 17
## 101 4 10
## 102 2 3
## 103 0 1
## 104 0 4
## 105 8 14
## 106 146 321
## 107 14 28
## 108 6 10
## 109 4 8
## 110 37 103
## 111 122 309
## 112 186 545
## 113 3 8
## 114 0 1
## 115 2 3
## 116 2 4
## 117 0 1
## 118 3 9
## 119 11 24
## 120 2 5
## 121 10 42
## 122 23 52
## 123 29 89
## 124 116 366
## 125 355 1204
## 126 52 174
## 127 0 2
## 128 0 1
## 129 1 2
## 130 239 679
## 131 132 374
## 132 2 4
## 133 2 4
## 134 0 2
## 135 17 35
## 136 1 1
## 137 0 1
## 138 11 19
## 139 7 15
## 140 36 103
## 141 0 1
## 142 3 11
## 143 72 148
## 144 37 135
## 145 1 2
## 146 833 2959
## 147 41 137
## 148 6 10
## 149 20 37
## 150 9 19
## 151 1 5
## 152 0 1
## 153 94 243
## 154 29 87
## 155 1 2
## 156 1 8max_row_index <- which.max(result_data[, "Combined.Olympic.Games.Metal.Total"])
totalmetalresult <- result_data[max_row_index, c("Team", "Combined.Olympic.Games.Metal.Total")]
totalmetalresult## Team Combined.Olympic.Games.Metal.Total
## 146 United States (USA) [P][Q][R][Z][F] 2959max_row_index <- which.max(result_data[, "Combined.Olympic.Games.Gold.Metals"])
goldresult <- result_data[max_row_index, c("Team", "Combined.Olympic.Games.Gold.Metals")]
goldresult## Team Combined.Olympic.Games.Gold.Metals
## 146 United States (USA) [P][Q][R][Z][F] 1174max_row_indices <- which(result_data$Combined.Olympic.Games.Total == max(result_data$Combined.Olympic.Games.Total))
gameresult <- result_data[max_row_indices, c("Team", "Combined.Olympic.Games.Total")]
gameresult## Team Combined.Olympic.Games.Total
## 45 France (FRA) [O][P][Z] 53
## 50 Great Britain (GBR) [GBR][Z] 53
## 131 Switzerland (SUI) 53Overall, the United States has historically amassed a total of 2,959 medals across all Olympic Games, making it the country with the highest number of Olympic medals. Among these, 1,174 are gold medals, establishing the United States as the leader in gold medal performance. Another interesting fact is that, when combining both the Summer and Winter Games, France, Great Britain, and Switzerland have each participated in a total of 53 Olympic Games, the highest number among all countries.