library(rio)
library(knitr)
BRB=import("BRB.csv")
CO2M=import("CO2M.csv")
DBEX=import("DBEX.csv")
DBPB=import("DBPB.csv")
ELEC=import("ELEC.csv")
ENGY=import("ENGY.csv")
IFRT=import("IFRT.csv")
TLMB=import("TLMB.csv")
TLPH=import("TLPH.csv")
YEPR=import("YEPR.csv")
library(dplyr)
##
## Adjuntando el paquete: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
nuevos_nombres <- c("name","slug","TRABjuv","date_of_information","ranking","region")
colnames(YEPR) <- nuevos_nombres
df_dplyr_full <- full_join(BRB, CO2M, by = "name")
df_dplyr_full2 <- full_join(df_dplyr_full, DBEX, by = "name")
df_dplyr_full3 <- full_join(df_dplyr_full2, DBPB, by = "name")
df_dplyr_full4 <- full_join(df_dplyr_full3, ELEC, by = "name")
df_dplyr_full5 <- full_join(df_dplyr_full4, ENGY, by = "name")
df_dplyr_full6 <- full_join(df_dplyr_full5, IFRT, by = "name")
df_dplyr_full7 <- full_join(df_dplyr_full6, TLMB, by = "name")
df_dplyr_full8 <- full_join(df_dplyr_full7, TLPH, by = "name")
df_dplyr_full9 <- full_join(df_dplyr_full8, YEPR, by = "name")
DATAMOD <- df_dplyr_full9 %>%
select(-ranking.x,-ranking.y,-ranking.x.x,-ranking.y.y,-ranking.x.x.x,-ranking.y.y.y,-ranking.x.x.x.x,-ranking.y.y.y.y,-region.x,-region.y,-region.x.x,-region.y.y,-region.x.x.x,-region.y.y.y,-region.x.x.x.x,-region.y.y.y.y,-slug.x,-slug.y,-slug.x.x,-slug.y.y,-slug.x.x.x,-slug.y.y.y,-slug.x.x.x.x,-slug.y.y.y.y,-date_of_information.x,-date_of_information.y,-date_of_information.x.x,-date_of_information.y.y,-date_of_information.x.x.x,-date_of_information.y.y.y,-date_of_information.x.x.x.x,-date_of_information.y.y.y.y,-slug.x.x.x.x.x,-slug.y.y.y.y.y,-region.x.x.x.x.x,-region.y.y.y.y.y,-date_of_information.x.x.x.x.x,-date_of_information.y.y.y.y.y,-ranking.x.x.x.x.x,-ranking.y.y.y.y.y)
nuevos_nombres <- c("name","bandancha", "EmisiónC02", "DeudaEX", "DeudaPUB","kWH","ConsENper","Inflacion","TEL","MOB","TRABjuv")
colnames(DATAMOD) <- nuevos_nombres
print(DATAMOD)
## name bandancha EmisiónC02
## 1 China 636,000,000 12,196,000,000
## 2 United States 131,000,000 4,795,000,000
## 3 Brazil 48,400,000 437,769,000
## 4 Japan 47,900,000 960,230,000
## 5 India 39,300,000 2,821,000,000
## 6 Germany 38,400,000 600,192,000
## 7 Russia 35,900,000 1,844,000,000
## 8 France 32,300,000 303,779,000
## 9 United Kingdom 28,200,000 340,940,000
## 10 Mexico 26,600,000 441,049,000
## 11 Korea, South 24,100,000 644,231,000
## 12 Vietnam 22,800,000 305,404,000
## 13 Italy 20,100,000 307,442,000
## 14 Turkey (Turkiye) 19,600,000 399,173,000
## 15 Spain 18,200,000 254,823,000
## 16 Canada 17,000,000 585,853,000
## 17 Saudi Arabia 14,500,000 656,511,000
## 18 Egypt 13,600,000 236,618,000
## 19 Indonesia 13,500,000 829,655,000
## 20 Bangladesh 12,900,000 125,956,000
## 21 Argentina 11,500,000 198,141,000
## 22 Thailand 11,500,000 336,693,000
## 23 Iran 10,900,000 823,364,000
## 24 Uzbekistan 10,800,000 110,992,000
## 25 Poland 10,100,000 264,031,000
## 26 Australia 9,630,000 394,653,000
## 27 Colombia 8,910,000 85,878,000
## 28 Ukraine 8,070,000 106,847,000
## 29 Netherlands 7,830,000 188,191,000
## 30 Iraq 7,770,000 190,815,000
## 31 Philippines 7,510,000 156,228,000
## 32 Romania 6,630,000 61,416,000
## 33 Taiwan 5,831,470 289,109,000
## 34 Algeria 5,540,000 163,661,000
## 35 Belgium 5,120,000 112,083,000
## 36 Portugal 4,600,000 38,272,000
## 37 Malaysia 4,580,000 260,005,000
## 38 Chile 4,520,000 83,058,000
## 39 Greece 4,480,000 62,060,000
## 40 Switzerland 4,330,000 33,306,000
## 41 Sweden 4,300,000 43,960,000
## 42 Czechia 4,100,000 79,901,000
## 43 United Arab Emirates 3,950,000 271,703,000
## 44 Kazakhstan 3,590,000 269,830,000
## 45 Hungary 3,560,000 40,161,000
## 46 Peru 3,530,000 58,903,000
## 47 Pakistan 3,360,000 212,655,000
## 48 Belarus 3,200,000 46,709,000
## 49 Hong Kong 2,970,000 58,433,000
## 50 Ecuador 2,890,000 38,286,000
## 51 Israel 2,760,000 64,401,000
## 52 Austria 2,710,000 56,959,000
## 53 Venezuela 2,700,000 76,730,000
## 54 Denmark 2,650,000 29,915,000
## 55 Norway 2,490,000 38,535,000
## 56 Bulgaria 2,450,000 33,465,000
## 57 Morocco 2,420,000 64,173,000
## 58 South Africa 2,150,000 446,704,000
## 59 Azerbaijan 2,150,000 38,892,000
## 60 Serbia 2,080,000 44,782,000
## 61 Sri Lanka 2,010,000 19,153,000
## 62 Finland 1,980,000 33,594,000
## 63 New Zealand 1,930,000 33,506,000
## 64 Slovakia 1,830,000 30,087,000
## 65 Tunisia 1,730,000 24,645,000
## 66 Tanzania 1,660,000 17,707,000
## 67 Ireland 1,650,000 35,486,000
## 68 Syria 1,620,000 20,243,000
## 69 Singapore 1,570,000 238,962,000
## 70 Burma 1,510,000 27,005,000
## 71 Nepal 1,440,000 11,357,000
## 72 Bolivia 1,330,000 21,552,000
## 73 Kenya 1,320,000 19,023,000
## 74 Dominican Republic 1,260,000 29,713,000
## 75 Costa Rica 1,150,000 7,910,000
## 76 Croatia 1,110,000 16,467,000
## 77 Georgia 1,100,000 10,700,000
## 78 Uruguay 1,100,000 6,896,000
## 79 Guatemala 921,000 18,546,000
## 80 Bosnia and Herzegovina 908,000 24,513,000
## 81 Paraguay 878,000 7,509,000
## 82 Moldova 841,000 7,093,000
## 83 Panama 809,000 23,458,000
## 84 Lithuania 806,000 12,877,000
## 85 Jordan 805,000 22,434,000
## 86 Puerto Rico 751,000 18,833,000
## 87 Slovenia 683,000 10,772,000
## 88 El Salvador 671,000 8,694,000
## 89 Albania 632,000 3,392,000
## 90 Cameroon 603,000 6,707,000
## 91 Ethiopia 566,000 18,519,000
## 92 Oman 562,000 84,073,000
## 93 Armenia 546,000 7,144,000
## 94 Estonia 516,000 4,607,000
## 95 North Macedonia 515,000 7,369,000
## 96 Cambodia 510,000 18,779,000
## 97 Mongolia 499,000 19,203,000
## 98 Latvia 489,000 6,427,000
## 99 Yemen 486,000 8,193,000
## 100 Honduras 476,000 10,534,000
## 101 Kyrgyzstan 456,000 11,389,000
## 102 Jamaica 448,000 7,890,000
## 103 Gaza Strip 431,000 3,913,000
## 104 West Bank 431,000 3,913,000
## 105 Cote d'Ivoire 425,000 16,280,000
## 106 Lebanon 419,000 17,484,000
## 107 Trinidad and Tobago 404,000 33,629,000
## 108 Turkmenistan 377,000 106,215,000
## 109 Nicaragua 371,000 3,806,000
## 110 Cyprus 357,000 6,837,000
## 111 Senegal 357,000 10,373,000
## 112 Qatar 347,000 127,783,000
## 113 Mauritius 343,000 5,551,000
## 114 Cuba 327,000 19,716,000
## 115 Libya 326,000 46,479,000
## 116 Zimbabwe 269,000 12,578,000
## 117 Bahrain 268,000 47,818,000
## 118 Luxembourg 250,000 8,715,000
## 119 Malta 236,000 8,965,000
## 120 Ghana 223,000 20,822,000
## 121 Macau 212,000 1,595,000
## 122 Montenegro 203,000 2,808,000
## 123 Laos 183,000 23,412,000
## 124 Mali 179,000 6,858,000
## 125 Iceland 145,000 3,101,000
## 126 Angola 137,000 19,660,000
## 127 Suriname 125,000 2,521,000
## 128 Somalia 119,000 838,000
## 129 Nigeria 117,000 114,397,000
## 130 Togo 114,000 2,656,000
## 131 Barbados 106,000 1,348,000
## 132 Guyana 106,000 2,639,000
## 133 Namibia 104,000 3,460,000
## 134 Zambia 99,000 9,877,000
## 135 Maldives 98,000 1,908,000
## 136 Bahamas, The 95,000 2,990,000
## 137 Brunei 93,000 10,823,000
## 138 Botswana 85,000 5,897,000
## 139 Gabon 80,000 3,144,000
## 140 Congo, Republic of the 78,000 2,660,000
## 141 French Polynesia 78,000 1,010,000
## 142 Mozambique 65,000 9,549,000
## 143 Rwanda 62,000 1,645,000
## 144 Curacao 61,000 <NA>
## 145 New Caledonia 56,000 4,887,000
## 146 Kuwait 49,000 100,459,000
## 147 Uganda 44,000 6,354,000
## 148 Andorra 42,000 <NA>
## 149 Cayman Islands 40,000 737,000
## 150 Jersey 39,699 <NA>
## 151 Seychelles 39,000 893,000
## 152 Belize 39,000 662,000
## 153 Cabo Verde 38,000 714,000
## 154 Haiti 35,000 2,854,000
## 155 Grenada 35,000 348,000
## 156 Madagascar 34,000 3,936,000
## 157 Eswatini 34,000 1,326,000
## 158 Congo, Democratic Republic of the 33,000 5,883,000
## 159 Afghanistan 33,000 7,757,000
## 160 Saint Vincent and the Grenadines 31,000 268,000
## 161 Sudan 30,000 18,242,000
## 162 Guernsey 25,336 <NA>
## 163 Benin 24,000 5,948,000
## 164 Saint Lucia 24,000 605,000
## 165 Gibraltar 23,000 15,608,000
## 166 Fiji 23,000 1,432,000
## 167 Bermuda 23,000 577,000
## 168 Monaco 22,000 <NA>
## 169 Saint Kitts and Nevis 22,000 269,000
## 170 Papua New Guinea 22,000 5,798,000
## 171 Liechtenstein 20,000 <NA>
## 172 Aruba 19,000 1,163,000
## 173 Faroe Islands 19,000 742,000
## 174 Greenland 18,000 527,000
## 175 Djibouti 17,000 685,000
## 176 Malawi 17,000 2,265,000
## 177 Burkina Faso 15,000 5,243,000
## 178 Liberia 15,000 671,000
## 179 Dominica 14,000 168,000
## 180 Niger 14,000 3,132,000
## 181 Mauritania 14,000 4,860,000
## 182 San Marino 12,000 <NA>
## 183 Bhutan 10,000 733,000
## 184 Antigua and Barbuda 10,000 725,000
## 185 Virgin Islands 9,000 2,378,000
## 186 Lesotho 9,000 1,148,000
## 187 Tonga 9,000 174,000
## 188 Micronesia, Federated States of 7,000 121,000
## 189 Guinea-Bissau 7,000 366,000
## 190 British Virgin Islands 7,000 188,000
## 191 Tajikistan 6,000 8,616,000
## 192 Sao Tome and Principe 6,000 146,000
## 193 Gambia, The 6,000 537,000
## 194 Eritrea 6,000 733,000
## 195 Anguilla 5,000 <NA>
## 196 Vanuatu 4,000 292,000
## 197 Guam 3,000 1,819,000
## 198 Burundi 3,000 838,000
## 199 Comoros 3,000 436,000
## 200 Cook Islands 2,700 103,000
## 201 Montserrat 2,700 24,000
## 202 Equatorial Guinea 2,000 5,471,000
## 203 Samoa 2,000 335,000
## 204 Palau 1,000 <NA>
## 205 Guinea 1,000 4,505,000
## 206 Central African Republic 1,000 313,000
## 207 Nauru 1,000 86,000
## 208 Saint Helena, Ascension, and Tristan da Cunha 1,000 12,000
## 209 Solomon Islands 1,000 318,000
## 210 Marshall Islands 1,000 293,700
## 211 Falkland Islands (Islas Malvinas) 1,000 36,000
## 212 Timor-Leste 0 660,000
## 213 Chad 0 2,054,000
## 214 Tuvalu 0 <NA>
## 215 South Sudan 0 1,725,000
## 216 Sierra Leone 0 1,342,000
## 217 Kiribati 0 81,000
## 218 Korea, North <NA> 55,744,000
## 219 Kosovo <NA> 7,444,000
## 220 Wake Island <NA> 1,214,000
## 221 Turks and Caicos Islands <NA> 447,000
## 222 American Samoa <NA> 389,000
## 223 United States Pacific Island Wildlife Refuges <NA> 294,000
## 224 Saint Pierre and Miquelon <NA> 57,000
## 225 Antarctica <NA> 15,000
## 226 Niue <NA> 9,000
## 227 Northern Mariana Islands <NA> <NA>
## 228 Wallis and Futuna <NA> <NA>
## 229 Sint Maarten <NA> <NA>
## 230 Tokelau <NA> <NA>
## 231 Isle of Man <NA> <NA>
## 232 Saint Martin <NA> <NA>
## DeudaEX DeudaPUB kWH ConsENper Inflacion TEL
## 1 $488,114,000,000 47.00 2,949,000,000 113,805,000 0.2 1,810,000,000
## 2 <NA> 114.80 1,235,000,000 278,474,000 2.9 386,000,000
## 3 $198,582,000,000 83.70 240,251,000 48,889,000 4.4 213,000,000
## 4 <NA> 216.20 361,617,000 129,504,000 2.7 219,000,000
## 5 $212,728,000,000 46.50 499,136,000 25,179,000 5 1,140,000,000
## 6 <NA> 63.90 275,658,000 120,457,000 2.3 105,000,000
## 7 $135,301,000,000 19.00 301,926,000 224,858,000 6.7 245,000,000
## 8 <NA> 98.50 151,463,000 123,526,000 2 77,400,000
## 9 <NA> 138.20 114,749,000 94,280,000 3.3 84,300,000
## 10 $306,308,000,000 45.30 105,586,000 57,539,000 4.7 140,000,000
## 11 <NA> 52.30 151,139,000 234,668,000 2.3 83,900,000
## 12 $34,426,000,000 58.50 85,725,000 40,263,000 3.6 131,000,000
## 13 <NA> 131.80 128,692,000 96,797,000 1 78,500,000
## 14 $149,654,000,000 33.10 106,281,000 70,521,000 58.5 92,200,000
## 15 <NA> 107.30 130,366,000 101,120,000 2.8 61,200,000
## 16 <NA> 62.20 161,988,000 311,599,000 2.4 36,500,000
## 17 <NA> 17.20 119,620,000 349,692,000 1.7 52,500,000
## 18 $117,272,000,000 103.00 59,680,000 34,975,000 33.9 106,000,000
## 19 $225,273,000,000 45.34 70,826,000 37,390,000 3.7 352,000,000
## 20 $58,020,000,000 33.10 22,699,000 11,472,000 10.5 191,000,000
## 21 $74,362,000,000 57.60 47,631,000 78,496,000 25.7 62,700,000
## 22 $37,065,000,000 61.20 55,971,000 80,602,000 1.2 121,000,000
## 23 $6,759,000,000 39.50 86,058,000 160,779,000 44.6 151,000,000
## 24 $25,714,000,000 24.30 17,901,000 55,305,000 9.6 37,500,000
## 25 <NA> 50.60 64,806,000 103,651,000 3.8 52,400,000
## 26 <NA> 58.00 108,193,000 223,158,000 3.2 29,100,000
## 27 $108,027,000,000 71.90 21,053,000 29,305,000 6.6 87,400,000
## 28 $90,003,000,000 58.70 60,297,000 57,856,000 6.5 50,300,000
## 29 <NA> 56.50 59,982,000 185,536,000 3.3 21,200,000
## 30 $15,580,000,000 27.40 31,339,000 64,311,000 4.4 45,700,000
## 31 $63,241,000,000 39.90 29,174,000 17,654,000 3.2 135,000,000
## 32 <NA> 50.90 19,748,000 59,377,000 -4.5 23,200,000
## 33 <NA> 35.70 64,535,000 206,102,000 2.2 30,000,000
## 34 $4,764,000,000 27.50 22,591,000 61,843,000 4 51,500,000
## 35 <NA> 92.50 28,248,000 190,416,000 3.1 12,100,000
## 36 <NA> 125.70 25,409,000 73,285,000 2.4 12,800,000
## 37 <NA> 64.30 37,220,000 113,163,000 1.8 50,100,000
## 38 <NA> 23.60 39,238,000 71,420,000 4.3 26,700,000
## 39 <NA> 190.60 24,169,000 92,693,000 2.7 11,300,000
## 40 <NA> 20.10 26,502,000 99,578,000 1.1 10,900,000
## 41 <NA> 36.90 55,307,000 142,102,000 2.8 14,800,000
## 42 <NA> 34.70 21,802,000 136,306,000 2.4 13,600,000
## 43 <NA> 19.70 44,462,000 450,432,000 1.6 21,200,000
## 44 $25,765,000,000 20.80 27,624,000 172,936,000 4.9 25,800,000
## 45 <NA> 75.50 14,829,000 96,152,000 3.7 10,200,000
## 46 $38,102,000,000 35.20 16,164,000 30,923,000 2 41,300,000
## 47 $89,148,000,000 67.00 43,512,000 14,076,000 12.6 189,000,000
## 48 $18,010,000,000 33.20 12,653,000 104,821,000 5.8 11,800,000
## 49 <NA> 0.10 13,300,000 116,811,000 1.7 23,800,000
## 50 $39,658,000,000 45.40 8,438,000 35,700,000 1.5 18,200,000
## 51 <NA> 72.60 22,612,000 112,437,000 3.1 13,800,000
## 52 <NA> 78.30 33,371,000 120,211,000 2.9 11,100,000
## 53 <NA> 38.90 33,493,000 54,474,000 146,101.7 18,800,000
## 54 <NA> 35.30 20,794,000 98,513,000 1.4 7,500,000
## 55 <NA> 36.50 41,100,000 206,961,000 3.1 6,090,000
## 56 $14,277,000,000 30.10 12,939,000 102,171,000 2.4 8,010,000
## 57 $42,262,000,000 65.10 14,615,000 23,520,000 1 55,900,000
## 58 $93,879,000,000 76.20 65,989,000 86,197,000 4.4 108,000,000
## 59 $12,378,000,000 16.80 8,383,000 66,467,000 2.2 11,000,000
## 60 $21,726,000,000 62.50 8,202,000 91,884,000 4.7 8,530,000
## 61 $42,198,000,000 79.10 5,326,000 12,372,000 -0.4 30,000,000
## 62 <NA> 61.30 26,782,000 183,540,000 1.6 7,140,000
## 63 <NA> 54.60 10,643,000 121,647,000 2.9 6,560,000
## 64 <NA> 64.30 8,138,000 127,582,000 2.8 7,630,000
## 65 $21,212,000,000 70.30 6,639,000 33,754,000 7.2 16,400,000
## 66 $17,513,000,000 37.00 1,818,000 4,091,000 3.1 70,200,000
## 67 <NA> 45.40 12,321,000 113,837,000 2.1 5,760,000
## 68 $4,573,000,000 94.80 9,636,000 13,569,000 13.4 15,100,000
## 69 <NA> 177.00 13,134,000 643,259,000 2.4 9,650,000
## 70 $8,748,000,000 33.60 7,419,000 8,384,000 8.8 65,500,000
## 71 $5,719,000,000 39.90 2,853,000 6,604,000 7.1 38,200,000
## 72 $11,174,000,000 49.00 4,375,000 29,340,000 5.1 12,000,000
## 73 $31,451,000,000 54.20 3,824,000 5,486,000 4.5 66,700,000
## 74 $35,044,000,000 37.20 6,581,000 39,329,000 3.3 10,400,000
## 75 $15,574,000,000 71.11 3,751,000 30,725,000 -0.4 7,440,000
## 76 <NA> 75.60 5,518,000 79,907,000 7.9 4,560,000
## 77 $9,085,000,000 43.40 4,526,000 56,076,000 1.1 5,910,000
## 78 <NA> 63.00 5,682,000 45,755,000 4.8 4,800,000
## 79 $11,862,000,000 31.56 4,995,000 17,096,000 2.9 20,600,000
## 80 $5,359,000,000 40.40 4,682,000 91,227,000 1.7 3,870,000
## 81 $13,783,000,000 19.50 8,928,000 25,733,000 3.8 8,670,000
## 82 $2,637,000,000 34.60 779,000 35,686,000 4.7 4,010,000
## 83 <NA> 37.80 4,485,000 78,010,000 0.7 6,980,000
## 84 <NA> 36.90 5,426,000 83,700,000 0.7 3,920,000
## 85 $21,058,000,000 103.10 6,891,000 32,909,000 2.1 7,730,000
## 86 <NA> 51.60 6,898,000 86,286,000 1.8 4,040,000
## 87 <NA> 73.60 4,739,000 104,502,000 2 2,730,000
## 88 $12,668,000,000 101.70 2,803,000 24,421,000 0.9 11,500,000
## 89 $5,363,000,000 81.90 2,857,000 27,407,000 2.2 2,610,000
## 90 $11,112,000,000 36.90 1,798,000 4,271,000 7.4 26,200,000
## 91 $25,426,000,000 31.40 5,690,000 2,366,000 30.2 71,400,000
## 92 <NA> 46.90 11,589,000 296,586,000 1 6,980,000
## 93 $6,002,000,000 48.30 4,265,000 54,689,000 0.3 3,960,000
## 94 <NA> 28.30 3,225,000 73,679,000 3.5 2,050,000
## 95 $5,637,000,000 39.30 2,467,000 56,104,000 3.5 1,920,000
## 96 $8,019,000,000 30.40 3,673,000 15,664,000 2.1 19,500,000
## 97 $8,379,000,000 67.60 1,510,000 67,132,000 6.8 4,840,000
## 98 <NA> 36.30 3,428,000 65,908,000 1.3 2,260,000
## 99 $6,492,000,000 74.50 1,790,000 2,987,000 24.7 20,000,000
## 100 $7,785,000,000 39.50 3,334,000 16,642,000 4.6 7,920,000
## 101 $3,617,000,000 44.00 3,944,000 27,580,000 10.8 7,680,000
## 102 $9,636,000,000 106.30 1,242,000 42,095,000 5.4 3,270,000
## 103 <NA> NA 352,000 14,991,000 5.9 4,150,000
## 104 <NA> 24.40 352,000 14,991,000 5.9 4,150,000
## 105 $26,576,000,000 47.00 2,315,000 8,489,000 3.5 53,600,000
## 106 $41,936,000,000 146.80 5,161,000 43,105,000 221.3 4,290,000
## 107 <NA> 41.80 2,139,000 <NA> 0.5 2,020,000
## 108 $3,696,000,000 28.80 6,512,000 261,142,000 8 6,250,000
## 109 $6,753,000,000 33.30 1,849,000 10,660,000 4.6 7,220,000
## 110 <NA> 97.50 2,288,000 107,188,000 1.8 1,430,000
## 111 $14,985,000,000 48.30 1,772,000 8,303,000 5.9 22,400,000
## 112 <NA> 53.80 11,400,000 814,308,000 1.3 4,700,000
## 113 $3,632,000,000 58.00 955,000 60,188,000 4.1 2,100,000
## 114 <NA> 47.70 7,264,000 26,070,000 5.5 7,670,000
## 115 <NA> 4.70 10,519,000 100,844,000 2.1 13,900,000
## 116 $6,671,000,000 82.30 2,491,000 10,855,000 104.7 15,000,000
## 117 <NA> 111.60 7,031,000 554,202,000 0.9 2,420,000
## 118 <NA> 23.00 2,212,000 224,651,000 2.1 961,000
## 119 <NA> 50.70 829,000 234,698,000 5.1 749,000
## 120 $29,241,000,000 71.80 5,519,000 10,493,000 22.8 33,400,000
## 121 <NA> 0.00 427,000 64,641,000 0.5 1,370,000
## 122 $3,643,000,000 67.20 1,082,000 63,407,000 3.3 1,310,000
## 123 $9,619,000,000 63.60 12,738,000 34,463,000 23.1 4,820,000
## 124 $4,085,000,000 35.40 1,222,000 4,307,000 3.2 25,900,000
## 125 <NA> 81.10 3,005,000 <NA> 5.9 478,000
## 126 $45,299,000,000 65.00 7,600,000 9,146,000 28.2 25,700,000
## 127 $2,645,000,000 69.30 537,000 60,896,000 16.2 989,000
## 128 $2,563,000,000 76.70 156,000 649,000 1.5 8,840,000
## 129 $45,009,000,000 21.80 4,094,000 7,993,000 24.7 224,000,000
## 130 $1,923,000,000 75.70 326,000 4,538,000 5.5 7,050,000
## 131 <NA> 133.20 320,000 68,293,000 9.8 323,000
## 132 $1,805,000,000 52.20 259,000 46,045,000 2.9 856,000
## 133 <NA> 4.64 646,000 21,734,000 4.2 2,600,000
## 134 $16,597,000,000 71.40 3,986,000 8,265,000 10.9 21,200,000
## 135 $3,113,000,000 63.90 432,000 50,886,000 1.4 745,000
## 136 <NA> 78.50 608,000 104,409,000 3.1 400,000
## 137 <NA> 2.80 904,000 403,365,000 -0.4 541,000
## 138 $1,761,000,000 19.60 758,000 32,443,000 2.8 4,440,000
## 139 $6,442,000,000 62.70 785,000 22,101,000 1.2 3,000,000
## 140 $6,360,000,000 130.80 842,000 7,351,000 4.3 5,870,000
## 141 <NA> NA 345,000 <NA> <NA> 328,000
## 142 $8,274,000,000 76.60 2,860,000 5,789,000 7.1 15,000,000
## 143 $5,531,000,000 40.50 294,000 1,808,000 1.8 12,800,000
## 144 <NA> NA <NA> <NA> 2.6 172,000
## 145 <NA> 6.50 1,174,000 <NA> 1.4 260,000
## 146 <NA> 20.60 20,294,000 389,848,000 2.9 8,110,000
## 147 $10,469,000,000 53.10 1,452,000 2,252,000 3.3 42,100,000
## 148 <NA> 41.00 <NA> <NA> <NA> 126,000
## 149 <NA> NA 176,000 143,149,000 2 100,000
## 150 <NA> NA <NA> <NA> <NA> 124,083
## 151 <NA> 63.60 156,000 98,847,000 0.3 165,000
## 152 $1,235,000,000 99.00 220,000 30,752,000 3.3 264,000
## 153 $1,385,000,000 125.80 200,000 19,999,000 3.7 590,000
## 154 $1,865,000,000 31.10 472,000 3,486,000 36.8 7,320,000
## 155 $501,371,000 70.40 60,000 41,703,000 2.7 112,000
## 156 $3,548,000,000 36.00 759,000 1,816,000 9.9 25,400,000
## 157 $923,266,000 36.20 285,000 18,823,000 2.6 1,520,000
## 158 $7,926,000,000 16.00 3,229,000 1,305,000 41.5 49,800,000
## 159 $2,717,000,000 7.00 627,000 3,380,000 -6.6 23,000,000
## 160 $456,971,000 73.80 55,000 37,253,000 3.6 103,000
## 161 $21,650,000,000 121.60 3,815,000 6,145,000 138.8 34,700,000
## 162 <NA> NA <NA> <NA> <NA> 71,485
## 163 $6,309,000,000 54.60 505,000 6,472,000 2.7 16,400,000
## 164 $901,317,000 70.70 93,000 47,522,000 4.1 176,000
## 165 <NA> NA 50,000 <NA> <NA> 37,000
## 166 $1,397,000,000 48.90 427,000 25,375,000 2.1 992,000
## 167 <NA> 43.00 172,000 122,737,000 1.9 68,000
## 168 <NA> NA <NA> <NA> <NA> 41,000
## 169 <NA> 62.90 72,000 81,454,000 3.6 56,000
## 170 $7,011,000,000 52.40 1,148,000 8,781,000 0.6 4,820,000
## 171 <NA> NA <NA> <NA> -0.4 50,000
## 172 <NA> 86.00 305,000 153,952,000 4.3 141,000
## 173 <NA> 35.00 180,000 <NA> -0.3 59,000
## 174 <NA> 13.00 190,000 <NA> 0.3 67,000
## 175 $2,531,000,000 31.80 210,000 10,428,000 1.5 574,000
## 176 $2,269,000,000 55.60 731,000 1,792,000 32.2 12,900,000
## 177 $3,565,000,000 62.50 749,000 3,481,000 4.2 24,700,000
## 178 $1,335,000,000 34.40 199,000 1,822,000 10.1 1,650,000
## 179 $301,191,000 82.70 41,000 36,395,000 4.2 57,000
## 180 $3,793,000,000 45.30 377,000 1,772,000 9.1 14,200,000
## 181 $3,072,000,000 96.60 812,000 14,135,000 5 5,360,000
## 182 <NA> 103.20 <NA> <NA> 1.2 41,000
## 183 $2,827,000,000 111.00 2,344,000 64,082,000 2.8 752,000
## 184 <NA> 86.80 148,000 110,114,000 5.1 184,000
## 185 <NA> 53.30 326,000 <NA> 1 80,000
## 186 $928,019,000 3.00 104,000 8,117,000 6.1 1,600,000
## 187 $159,276,000 51.80 34,000 23,272,000 3.2 64,000
## 188 <NA> 27.90 <NA> <NA> 5.4 22,000
## 189 $896,812,000 53.90 29,000 2,351,000 9.4 2,760,000
## 190 <NA> NA 63,000 66,998,000 4.2 38,000
## 191 $3,024,000,000 50.40 6,481,000 16,192,000 7.7 11,600,000
## 192 $327,248,000 88.40 29,000 8,875,000 21.3 152,000
## 193 $902,421,000 88.00 162,000 2,731,000 17 2,680,000
## 194 $461,376,000 131.20 243,000 2,977,000 9 1,800,000
## 195 <NA> 20.10 <NA> <NA> 1.3 26,000
## 196 $299,746,000 71.70 39,000 12,934,000 11.2 256,000
## 197 <NA> 22.10 525,000 150,555,000 1 98,000
## 198 $805,174,000 51.70 131,000 946,000 20.2 8,650,000
## 199 $267,652,000 32.40 32,000 7,139,000 1 934,000
## 200 <NA> NA 17,000 <NA> <NA> 17,000
## 201 <NA> NA 6,000 <NA> 1.2 5,000
## 202 <NA> 37.40 349,000 54,509,000 4.8 893,000
## 203 $269,974,000 49.10 54,000 23,476,000 2.2 134,000
## 204 <NA> 85.20 <NA> <NA> 2.2 24,000
## 205 $3,764,000,000 37.90 1,060,000 5,235,000 8.1 13,800,000
## 206 $724,179,000 52.90 63,000 954,000 3 1,830,000
## 207 <NA> 62.00 19,000 <NA> 5.1 10,000
## 208 <NA> NA 5,000 <NA> <NA> 4,000
## 209 $184,191,000 15.40 37,000 5,655,000 5.9 474,000
## 210 <NA> 41.60 <NA> <NA> 0 16,000
## 211 <NA> 0.00 10,000 <NA> <NA> 6,000
## 212 $238,042,000 3.80 277,000 6,825,000 2.1 1,560,000
## 213 $2,286,000,000 52.50 167,000 1,502,000 8.9 12,100,000
## 214 <NA> 37.00 <NA> <NA> 4.1 9,000
## 215 <NA> 62.70 136,000 2,092,000 2.4 6,170,000
## 216 $1,451,000,000 63.90 149,000 2,301,000 28.6 8,230,000
## 217 <NA> 26.30 12,000 8,578,000 9.3 70,000
## 218 <NA> NA 8,357,000 23,830,000 <NA> 6,000,000
## 219 $785,739,000 21.20 1,555,000 52,085,000 1.6 1,777,859
## 220 <NA> NA <NA> <NA> <NA> <NA>
## 221 <NA> NA 94,000 <NA> 4 25,085
## 222 <NA> 12.20 50,000 89,105,000 <NA> 2,250
## 223 <NA> NA <NA> <NA> <NA> <NA>
## 224 <NA> NA 26,000 <NA> 1.5 <NA>
## 225 <NA> NA <NA> <NA> <NA> <NA>
## 226 <NA> NA 3,000 <NA> <NA> <NA>
## 227 <NA> 7.10 <NA> <NA> 0.3 20,474
## 228 <NA> NA <NA> <NA> 0.9 0
## 229 <NA> NA <NA> <NA> 2.2 68,840
## 230 <NA> NA <NA> <NA> 4 <NA>
## 231 <NA> NA <NA> <NA> 4.1 <NA>
## 232 <NA> NA <NA> <NA> <NA> 68,840
## MOB TRABjuv
## 1 173,326,000 15.2
## 2 87,987,000 9.4
## 3 25,574,000 18.0
## 4 59,758,000 3.9
## 5 27,455,000 16.0
## 6 38,800,000 6.7
## 7 21,988,000 9.3
## 8 37,220,000 16.6
## 9 26,627,000 12.4
## 10 25,637,000 5.5
## 11 22,155,000 5.9
## 12 2,316,000 6.8
## 13 20,107,000 21.8
## 14 9,926,000 15.6
## 15 18,431,000 27.0
## 16 10,897,000 13.0
## 17 6,788,000 13.8
## 18 12,475,000 18.7
## 19 9,160,000 13.1
## 20 302,000 11.5
## 21 7,034,000 21.2
## 22 4,087,000 4.3
## 23 29,020,000 22.8
## 24 6,147,000 10.9
## 25 4,987,000 9.9
## 26 6,458,000 9.5
## 27 7,277,000 19.8
## 28 1,434,000 19.1
## 29 4,262,000 8.2
## 30 1,977,000 32.1
## 31 4,627,000 6.6
## 32 1,960,000 21.3
## 33 10,000,000 NA
## 34 6,324,000 29.8
## 35 2,667,000 16.8
## 36 5,505,000 21.2
## 37 8,402,000 12.3
## 38 1,978,000 22.3
## 39 4,962,000 24.7
## 40 3,003,000 7.9
## 41 898,000 23.8
## 42 1,197,000 8.4
## 43 2,259,000 6.4
## 44 2,574,000 3.8
## 45 2,693,000 14.1
## 46 1,504,000 8.8
## 47 2,573,000 9.9
## 48 4,173,000 10.1
## 49 3,487,000 8.4
## 50 1,434,000 10.1
## 51 2,905,000 6.1
## 52 3,604,000 11.7
## 53 2,683,000 10.6
## 54 755,000 12.1
## 55 145,000 11.6
## 56 619,000 12.1
## 57 2,874,000 22.1
## 58 1,353,000 60.9
## 59 1,635,000 13.7
## 60 2,485,000 22.7
## 61 1,707,000 22.3
## 62 158,000 19.2
## 63 660,000 14.3
## 64 505,000 18.2
## 65 1,863,000 40.1
## 66 76,000 3.3
## 67 1,176,000 11.1
## 68 2,816,000 31.5
## 69 1,912,000 7.8
## 70 588,000 10.0
## 71 726,000 20.8
## 72 550,000 5.2
## 73 68,000 11.9
## 74 1,144,000 11.7
## 75 678,000 23.0
## 76 1,203,000 16.6
## 77 278,000 29.9
## 78 1,205,000 26.4
## 79 1,940,000 4.2
## 80 614,000 27.3
## 81 206,000 14.1
## 82 847,000 3.3
## 83 811,000 16.8
## 84 224,000 14.1
## 85 451,000 41.7
## 86 758,000 12.5
## 87 647,000 9.4
## 88 863,000 6.7
## 89 173,000 25.1
## 90 896,000 6.2
## 91 862,000 5.4
## 92 579,000 13.9
## 93 331,000 26.2
## 94 238,000 20.9
## 95 439,000 30.3
## 96 38,000 0.8
## 97 524,000 13.8
## 98 142,000 12.5
## 99 728,000 32.4
## 100 444,000 10.5
## 101 185,000 6.8
## 102 459,000 14.5
## 103 384,000 36.1
## 104 384,000 36.1
## 105 244,000 3.9
## 106 875,000 23.6
## 107 311,000 11.1
## 108 802,000 9.6
## 109 234,000 9.0
## 110 270,000 15.6
## 111 399,000 4.1
## 112 526,000 0.4
## 113 464,000 16.6
## 114 1,589,000 3.9
## 115 1,218,000 49.5
## 116 310,000 14.0
## 117 246,000 5.2
## 118 260,000 20.2
## 119 259,000 7.8
## 120 320,000 5.4
## 121 87,000 7.2
## 122 190,000 25.9
## 123 1,300,000 2.2
## 124 307,000 4.0
## 125 82,000 7.6
## 126 87,000 27.9
## 127 129,000 24.2
## 128 91,000 33.9
## 129 112,000 5.1
## 130 67,000 3.4
## 131 121,000 23.7
## 132 125,000 22.3
## 133 81,000 37.3
## 134 81,000 9.9
## 135 13,000 16.1
## 136 97,000 17.8
## 137 122,000 18.5
## 138 90,000 43.9
## 139 43,000 36.0
## 140 17,000 40.0
## 141 139,000 36.9
## 142 29,000 7.4
## 143 8,000 17.5
## 144 51,000 42.2
## 145 46,000 32.7
## 146 573,000 15.4
## 147 116,000 4.5
## 148 52,000 NA
## 149 36,000 NA
## 150 48,122 14.1
## 151 18,000 16.5
## 152 19,000 16.3
## 153 60,000 28.2
## 154 6,000 37.5
## 155 17,000 NA
## 156 3,000 5.4
## 157 42,000 58.2
## 158 0 8.5
## 159 182,000 16.7
## 160 10,000 41.4
## 161 156,000 12.0
## 162 33,930 14.1
## 163 1,000 3.3
## 164 31,000 29.0
## 165 17,000 NA
## 166 49,000 15.5
## 167 25,000 NA
## 168 43,000 26.6
## 169 16,000 NA
## 170 166,000 3.8
## 171 10,000 NA
## 172 35,000 NA
## 173 15,000 NA
## 174 6,000 NA
## 175 29,000 76.3
## 176 5,000 6.8
## 177 81,000 8.1
## 178 6,000 2.1
## 179 7,000 NA
## 180 58,000 0.3
## 181 48,000 23.2
## 182 16,000 27.4
## 183 18,000 13.8
## 184 27,000 NA
## 185 76,000 25.3
## 186 7,000 24.2
## 187 11,000 6.3
## 188 7,000 NA
## 189 0 2.8
## 190 23,000 NA
## 191 502,000 27.1
## 192 2,000 8.6
## 193 60,000 10.9
## 194 66,000 9.4
## 195 6,000 NA
## 196 3,000 11.6
## 197 70,000 13.7
## 198 14,000 1.6
## 199 9,000 8.9
## 200 7,000 NA
## 201 3,000 NA
## 202 11,000 14.7
## 203 5,000 11.9
## 204 8,000 NA
## 205 0 7.1
## 206 2,000 9.5
## 207 0 NA
## 208 4,000 NA
## 209 7,000 3.0
## 210 2,000 26.0
## 211 2,000 NA
## 212 2,000 3.4
## 213 5,000 1.5
## 214 2,000 20.6
## 215 0 18.5
## 216 0 3.6
## 217 0 22.5
## 218 1,180,000 6.8
## 219 383,763 48.8
## 220 <NA> NA
## 221 4,000 NA
## 222 10,000 NA
## 223 <NA> NA
## 224 4,800 NA
## 225 <NA> NA
## 226 1,000 NA
## 227 20,000 NA
## 228 3,000 NA
## 229 <NA> NA
## 230 300 NA
## 231 <NA> NA
## 232 <NA> NA
THEDATA <- na.omit(DATAMOD)