setwd("C:/Clase 1206")
library(rio)
data1= import("Youth unemployment rate (ages 15-24).csv")
data1
##                                  name                             slug    %
## 1                            Djibouti                         djibouti 79.9
## 2                        South Africa                     south-africa 64.2
## 3                            Eswatini                         eswatini 50.9
## 4                               Libya                            libya 50.5
## 5                              Kosovo                           kosovo 48.8
## 6                          Costa Rica                       costa-rica 45.4
## 7              Congo, Republic of the            congo-republic-of-the 42.3
## 8                             Curacao                          curacao 42.2
## 9                            Botswana                         botswana 41.2
## 10   Saint Vincent and the Grenadines saint-vincent-and-the-grenadines 41.1
## 11                      New Caledonia                    new-caledonia 41.0
## 12                             Jordan                           jordan 40.5
## 13                            Namibia                          namibia 40.4
## 14                          West Bank                        west-bank 39.6
## 15                         Gaza Strip                       gaza-strip 39.6
## 16                   French Polynesia                 french-polynesia 38.9
## 17                        Saint Lucia                      saint-lucia 38.7
## 18                              Gabon                            gabon 38.4
## 19                            Tunisia                          tunisia 38.3
## 20                            Lesotho                          lesotho 37.4
## 21                             Greece                           greece 36.9
## 22                              Spain                            spain 36.9
## 23                            Armenia                          armenia 36.1
## 24                              Haiti                            haiti 35.7
## 25                              Sudan                            sudan 35.6
## 26                            Somalia                          somalia 34.7
## 27                         Cabo Verde                       cabo-verde 34.3
## 28                    North Macedonia                  north-macedonia 34.1
## 29                            Uruguay                          uruguay 32.9
## 30             Bosnia and Herzegovina           bosnia-and-herzegovina 32.9
## 31                            Algeria                          algeria 31.9
## 32                             Brazil                           brazil 31.9
## 33                         Montenegro                       montenegro 31.6
## 34                              Italy                            italy 30.9
## 35                       Bahamas, The                      bahamas-the 30.8
## 36                           Barbados                         barbados 30.6
## 37                           Suriname                         suriname 30.5
## 38                             Serbia                           serbia 30.4
## 39                             Panama                           panama 30.0
## 40                             Guyana                           guyana 29.9
## 41                          Argentina                        argentina 29.9
## 42                            Lebanon                          lebanon 29.6
## 43                            Bermuda                          bermuda 29.3
## 44                       Saudi Arabia                     saudi-arabia 28.8
## 45                            Georgia                          georgia 28.3
## 46                              India                            india 28.3
## 47                            Albania                          albania 27.8
## 48                         San Marino                       san-marino 27.4
## 49                            Morocco                          morocco 27.2
## 50                               Iraq                             iraq 27.2
## 51                               Iran                             iran 27.2
## 52                     Virgin Islands                   virgin-islands 27.0
## 53                              Nauru                            nauru 26.6
## 54                             Monaco                           monaco 26.6
## 55                           Colombia                         colombia 26.4
## 56                              Syria                            syria 26.2
## 57                          Sri Lanka                        sri-lanka 26.1
## 58                            Jamaica                          jamaica 26.1
## 59                             Zambia                           zambia 26.1
## 60                   Marshall Islands                 marshall-islands 26.0
## 61                              Yemen                            yemen 25.5
## 62                             Kuwait                           kuwait 25.5
## 63                          Mauritius                        mauritius 25.3
## 64                             Sweden                           sweden 24.5
## 65                   Turkey (Turkiye)                   turkey-turkiye 24.3
## 66                              Egypt                            egypt 24.3
## 67                            Croatia                          croatia 23.6
## 68                             Brunei                           brunei 23.4
## 69                           Portugal                         portugal 23.1
## 70                         Mauritania                       mauritania 23.0
## 71              Sao Tome and Principe            sao-tome-and-principe 22.9
## 72                           Kiribati                         kiribati 22.5
## 73                            Comoros                          comoros 21.7
## 74                           Slovakia                         slovakia 21.5
## 75                              Chile                            chile 21.4
## 76                        South Sudan                      south-sudan 21.0
## 77                           Mongolia                         mongolia 21.0
## 78                 Dominican Republic               dominican-republic 20.6
## 79                             Tuvalu                           tuvalu 20.6
## 80                            Romania                          romania 20.6
## 81                        Afghanistan                      afghanistan 20.2
## 82                             France                           france 20.1
## 83                              Samoa                            samoa 19.7
## 84                            Nigeria                          nigeria 19.6
## 85                            Belgium                          belgium 19.6
## 86                             Belize                           belize 19.3
## 87                         Kyrgyzstan                       kyrgyzstan 19.3
## 88                          Lithuania                        lithuania 19.0
## 89    Micronesia, Federated States of   micronesia-federated-states-of 18.9
## 90                             Bhutan                           bhutan 18.8
## 91                             Angola                           angola 18.5
## 92                        Puerto Rico                      puerto-rico 18.5
## 93                  Equatorial Guinea                equatorial-guinea 18.3
## 94                            Finland                          finland 18.1
## 95                               Fiji                             fiji 18.1
## 96                           Maldives                         maldives 17.7
## 97                         Tajikistan                       tajikistan 17.4
## 98                            Ireland                          ireland 17.4
## 99                            Bolivia                          bolivia 17.4
## 100                              Mali                             mali 17.3
## 101                           Estonia                          estonia 17.1
## 102                            Russia                           russia 16.9
## 103                           Ukraine                          ukraine 16.5
## 104                        Seychelles                       seychelles 16.5
## 105                        Azerbaijan                       azerbaijan 16.5
## 106                          Paraguay                         paraguay 16.3
## 107                         Indonesia                        indonesia 16.1
## 108                        Uzbekistan                       uzbekistan 16.0
## 109                            Jersey                           jersey 15.8
## 110                          Guernsey                         guernsey 15.8
## 111                          Malaysia                         malaysia 15.6
## 112                          Honduras                         honduras 15.5
## 113                            Latvia                           latvia 15.5
## 114                       Gambia, The                       gambia-the 15.5
## 115                              Guam                             guam 15.3
## 116                        Luxembourg                       luxembourg 15.2
## 117                         Hong Kong                        hong-kong 15.0
## 118                         Venezuela                        venezuela 14.9
## 119                        Bangladesh                       bangladesh 14.7
## 120                              Oman                             oman 14.6
## 121                           Eritrea                          eritrea 14.6
## 122                          Bulgaria                         bulgaria 14.2
## 123                           Ecuador                          ecuador 14.2
## 124                            Canada                           canada 14.0
## 125                          Slovenia                         slovenia 13.9
## 126                    Cayman Islands                   cayman-islands 13.8
## 127                       Timor-Leste                      timor-leste 13.8
## 128                             Kenya                            kenya 13.8
## 129                       El Salvador                      el-salvador 13.7
## 130                           Hungary                          hungary 13.5
## 131                            Poland                           poland 13.4
## 132                           Iceland                          iceland 13.4
## 133                    United Kingdom                   united-kingdom 13.2
## 134                            Norway                           norway 13.0
## 135                     Guinea-Bissau                    guinea-bissau 12.8
## 136               Trinidad and Tobago              trinidad-and-tobago 12.7
## 137          Central African Republic         central-african-republic 11.8
## 138                            Cyprus                           cyprus 11.8
## 139                         Nicaragua                        nicaragua 11.6
## 140                       New Zealand                      new-zealand 11.4
## 141                           Austria                          austria 11.4
## 142                             China                            china 11.4
## 143                           Belarus                          belarus 11.3
## 144                              Peru                             peru 11.2
## 145                             Tonga                            tonga 11.1
## 146                      Turkmenistan                     turkmenistan 11.0
## 147                      Sierra Leone                     sierra-leone 10.8
## 148                         Australia                        australia 10.8
## 149              United Arab Emirates             united-arab-emirates 10.7
## 150                       Isle of Man                      isle-of-man 10.1
## 151                           Denmark                          denmark 10.1
## 152 Congo, Democratic Republic of the congo-democratic-republic-of-the 10.1
## 153                            Malawi                           malawi  9.9
## 154                           Bahrain                          bahrain  9.9
## 155                             Malta                            malta  9.8
## 156                              Togo                             togo  9.7
## 157                       Netherlands                      netherlands  9.6
## 158                             Ghana                            ghana  9.6
## 159                     United States                    united-states  9.6
## 160                             Nepal                            nepal  9.5
## 161                          Pakistan                         pakistan  9.4
## 162                             Macau                            macau  9.2
## 163                       Switzerland                      switzerland  9.1
## 164                         Singapore                        singapore  9.1
## 165                            Israel                           israel  8.8
## 166                           Moldova                          moldova  8.6
## 167                            Guinea                           guinea  8.2
## 168                        Mozambique                       mozambique  8.1
## 169                            Mexico                           mexico  8.1
## 170                      Korea, South                      korea-south  7.8
## 171                      Burkina Faso                     burkina-faso  7.7
## 172                           Czechia                          czechia  7.6
## 173                              Cuba                             cuba  7.4
## 174                          Zimbabwe                         zimbabwe  7.3
## 175                       Philippines                      philippines  7.3
## 176                         Guatemala                        guatemala  7.2
## 177                           Vietnam                          vietnam  7.2
## 178                           Germany                          germany  7.0
## 179                          Thailand                         thailand  7.0
## 180                          Cameroon                         cameroon  6.6
## 181                             Burma                            burma  6.4
## 182                      Korea, North                      korea-north  6.1
## 183                          Ethiopia                         ethiopia  5.7
## 184                     Cote d'Ivoire                     cote-divoire  5.7
## 185                             Palau                            palau  5.6
## 186                           Vanuatu                          vanuatu  5.4
## 187                  Papua New Guinea                 papua-new-guinea  5.3
## 188                           Senegal                          senegal  5.0
## 189                        Madagascar                       madagascar  4.8
## 190                          Tanzania                         tanzania  4.6
## 191                             Japan                            japan  4.4
## 192                            Uganda                           uganda  4.3
## 193                             Benin                            benin  3.9
## 194                        Kazakhstan                       kazakhstan  3.7
## 195                           Burundi                          burundi  3.4
## 196                              Laos                             laos  3.3
## 197                           Liberia                          liberia  3.2
## 198                            Rwanda                           rwanda  2.9
## 199                              Chad                             chad  2.4
## 200                   Solomon Islands                  solomon-islands  1.9
## 201                          Cambodia                         cambodia  1.8
## 202                             Qatar                            qatar  1.1
## 203                             Niger                            niger  1.0
##     date_of_information ranking                            region
## 1                  2021       1                            Africa
## 2                  2021       2                            Africa
## 3                  2021       3                            Africa
## 4                  2021       4                            Africa
## 5                  2020       5                            Europe
## 6                  2021       6 Central America and the Caribbean
## 7                  2021       7                            Africa
## 8                  2020       8 Central America and the Caribbean
## 9                  2021       9                            Africa
## 10                 2021      10 Central America and the Caribbean
## 11                 2021      11             Australia and Oceania
## 12                 2021      12                       Middle East
## 13                 2021      13                            Africa
## 14                 2021      14                       Middle East
## 15                 2021      15                       Middle East
## 16                 2021      16             Australia and Oceania
## 17                 2021      17 Central America and the Caribbean
## 18                 2021      18                            Africa
## 19                 2021      19                            Africa
## 20                 2021      20                            Africa
## 21                 2021      21                            Europe
## 22                 2021      22                            Europe
## 23                 2021      23                       Middle East
## 24                 2021      24 Central America and the Caribbean
## 25                 2021      25                            Africa
## 26                 2021      26                            Africa
## 27                 2021      27                            Africa
## 28                 2021      28                            Europe
## 29                 2021      29                     South America
## 30                 2021      30                            Europe
## 31                 2021      31                            Africa
## 32                 2021      32                     South America
## 33                 2021      33                            Europe
## 34                 2021      34                            Europe
## 35                 2021      35 Central America and the Caribbean
## 36                 2021      36 Central America and the Caribbean
## 37                 2021      37                     South America
## 38                 2021      38                            Europe
## 39                 2021      39 Central America and the Caribbean
## 40                 2021      40                     South America
## 41                 2021      41                     South America
## 42                 2021      42                       Middle East
## 43                 2014      43                     North America
## 44                 2021      44                       Middle East
## 45                 2021      45                       Middle East
## 46                 2021      46                        South Asia
## 47                 2021      47                            Europe
## 48                 2016      48                            Europe
## 49                 2021      49                            Africa
## 50                 2021      50                       Middle East
## 51                 2021      51                       Middle East
## 52                 2021      52 Central America and the Caribbean
## 53                 2013      53             Australia and Oceania
## 54                 2016      54                            Europe
## 55                 2021      55                     South America
## 56                 2021      56                       Middle East
## 57                 2021      57                        South Asia
## 58                 2021      58 Central America and the Caribbean
## 59                 2021      59                            Africa
## 60                 2019      60             Australia and Oceania
## 61                 2021      61                       Middle East
## 62                 2021      62                       Middle East
## 63                 2021      63                            Africa
## 64                 2021      64                            Europe
## 65                 2021      65                       Middle East
## 66                 2021      66                            Africa
## 67                 2021      67                            Europe
## 68                 2021      68           East and Southeast Asia
## 69                 2021      69                            Europe
## 70                 2021      70                            Africa
## 71                 2021      71                            Africa
## 72                 2019      72             Australia and Oceania
## 73                 2021      73                            Africa
## 74                 2021      74                            Europe
## 75                 2021      75                     South America
## 76                 2021      76                            Africa
## 77                 2021      77           East and Southeast Asia
## 78                 2021      78 Central America and the Caribbean
## 79                 2016      79             Australia and Oceania
## 80                 2021      80                            Europe
## 81                 2021      81                        South Asia
## 82                 2021      82                            Europe
## 83                 2021      83             Australia and Oceania
## 84                 2021      84                            Africa
## 85                 2021      85                            Europe
## 86                 2021      86 Central America and the Caribbean
## 87                 2021      87                      Central Asia
## 88                 2021      88                            Europe
## 89                 2014      89             Australia and Oceania
## 90                 2021      90                        South Asia
## 91                 2021      91                            Africa
## 92                 2021      92 Central America and the Caribbean
## 93                 2021      93                            Africa
## 94                 2021      94                            Europe
## 95                 2021      95             Australia and Oceania
## 96                 2021      96                        South Asia
## 97                 2021      97                      Central Asia
## 98                 2021      98                            Europe
## 99                 2021      99                     South America
## 100                2021     100                            Africa
## 101                2021     101                            Europe
## 102                2021     102                      Central Asia
## 103                2021     103                            Europe
## 104                2020     104                            Africa
## 105                2021     105                       Middle East
## 106                2021     106                     South America
## 107                2021     107           East and Southeast Asia
## 108                2021     108                      Central Asia
## 109                2021     109                            Europe
## 110                2021     110                            Europe
## 111                2021     111           East and Southeast Asia
## 112                2021     112 Central America and the Caribbean
## 113                2021     113                            Europe
## 114                2021     114                            Africa
## 115                2021     115             Australia and Oceania
## 116                2021     116                            Europe
## 117                2021     117           East and Southeast Asia
## 118                2021     118                     South America
## 119                2021     119                        South Asia
## 120                2021     120                       Middle East
## 121                2021     121                            Africa
## 122                2021     122                            Europe
## 123                2021     123                     South America
## 124                2021     124                     North America
## 125                2021     125                            Europe
## 126                2015     126 Central America and the Caribbean
## 127                2021     127           East and Southeast Asia
## 128                2021     128                            Africa
## 129                2021     129 Central America and the Caribbean
## 130                2021     130                            Europe
## 131                2021     131                            Europe
## 132                2021     132                            Europe
## 133                2021     133                            Europe
## 134                2021     134                            Europe
## 135                2021     135                            Africa
## 136                2021     136 Central America and the Caribbean
## 137                2021     137                            Africa
## 138                2021     138                            Europe
## 139                2021     139 Central America and the Caribbean
## 140                2021     140             Australia and Oceania
## 141                2021     141                            Europe
## 142                2021     142           East and Southeast Asia
## 143                2021     143                            Europe
## 144                2021     144                     South America
## 145                2021     145             Australia and Oceania
## 146                2021     146                      Central Asia
## 147                2021     147                            Africa
## 148                2021     148             Australia and Oceania
## 149                2021     149                       Middle East
## 150                2011     150                            Europe
## 151                2021     151                            Europe
## 152                2021     152                            Africa
## 153                2021     153                            Africa
## 154                2021     154                       Middle East
## 155                2021     155                            Europe
## 156                2021     156                            Africa
## 157                2021     157                            Europe
## 158                2021     158                            Africa
## 159                2021     159                     North America
## 160                2021     160                        South Asia
## 161                2021     161                        South Asia
## 162                2021     162           East and Southeast Asia
## 163                2021     163                            Europe
## 164                2021     164           East and Southeast Asia
## 165                2021     165                       Middle East
## 166                2021     166                            Europe
## 167                2021     167                            Africa
## 168                2021     168                            Africa
## 169                2021     169                     North America
## 170                2021     170           East and Southeast Asia
## 171                2021     171                            Africa
## 172                2021     172                            Europe
## 173                2021     173 Central America and the Caribbean
## 174                2021     174                            Africa
## 175                2021     175           East and Southeast Asia
## 176                2021     176 Central America and the Caribbean
## 177                2021     177           East and Southeast Asia
## 178                2021     178                            Europe
## 179                2021     179           East and Southeast Asia
## 180                2021     180                            Africa
## 181                2021     181           East and Southeast Asia
## 182                2021     182           East and Southeast Asia
## 183                2021     183                            Africa
## 184                2021     184                            Africa
## 185                2014     185             Australia and Oceania
## 186                2021     186             Australia and Oceania
## 187                2021     187           East and Southeast Asia
## 188                2021     188                            Africa
## 189                2021     189                            Africa
## 190                2021     190                            Africa
## 191                2021     191           East and Southeast Asia
## 192                2021     192                            Africa
## 193                2021     193                            Africa
## 194                2021     194                      Central Asia
## 195                2021     195                            Africa
## 196                2021     196           East and Southeast Asia
## 197                2021     197                            Africa
## 198                2021     198                            Africa
## 199                2021     199                            Africa
## 200                2021     200             Australia and Oceania
## 201                2021     201           East and Southeast Asia
## 202                2021     202                       Middle East
## 203                2021     203                            Africa
data12 <- data1[, c('%', 'region')]

head(data12)
##      %                            region
## 1 79.9                            Africa
## 2 64.2                            Africa
## 3 50.9                            Africa
## 4 50.5                            Africa
## 5 48.8                            Europe
## 6 45.4 Central America and the Caribbean
library(rio)
data2= import("Telephones - mobile cellular.csv")
data2
##                                              name
## 1                                           China
## 2                                           India
## 3                                   United States
## 4                                       Indonesia
## 5                                          Russia
## 6                                         Nigeria
## 7                                          Brazil
## 8                                           Japan
## 9                                        Pakistan
## 10                                     Bangladesh
## 11                                    Philippines
## 12                                           Iran
## 13                                        Vietnam
## 14                                         Mexico
## 15                                       Thailand
## 16                                        Germany
## 17                                          Egypt
## 18                                   South Africa
## 19                               Turkey (Turkiye)
## 20                                 United Kingdom
## 21                                       Colombia
## 22                                          Italy
## 23                                   Korea, South
## 24                                         France
## 25                                       Ethiopia
## 26                                          Kenya
## 27                                      Argentina
## 28                                       Tanzania
## 29                                          Spain
## 30                                          Burma
## 31                                        Morocco
## 32                                         Poland
## 33              Congo, Democratic Republic of the
## 34                                        Ukraine
## 35                                        Algeria
## 36                                  Cote d'Ivoire
## 37                                   Saudi Arabia
## 38                                       Malaysia
## 39                                           Iraq
## 40                                           Peru
## 41                                          Ghana
## 42                                          Nepal
## 43                                     Uzbekistan
## 44                                         Canada
## 45                                          Sudan
## 46                                         Uganda
## 47                                      Sri Lanka
## 48                                         Taiwan
## 49                                      Australia
## 50                                          Chile
## 51                                           Mali
## 52                                     Kazakhstan
## 53                                   Burkina Faso
## 54                                         Angola
## 55                                        Romania
## 56                                       Cameroon
## 57                                    Afghanistan
## 58                                      Hong Kong
## 59                                        Senegal
## 60                                     Madagascar
## 61                                    Netherlands
## 62                                      Guatemala
## 63                           United Arab Emirates
## 64                                         Zambia
## 65                                       Cambodia
## 66                                      Venezuela
## 67                                        Ecuador
## 68                                          Syria
## 69                                        Tunisia
## 70                                          Yemen
## 71                                          Benin
## 72                                       Zimbabwe
## 73                                          Niger
## 74                                          Libya
## 75                                     Mozambique
## 76                                         Guinea
## 77                                         Israel
## 78                                        Czechia
## 79                                         Sweden
## 80                                       Portugal
## 81                                         Malawi
## 82                                           Chad
## 83                                        Bolivia
## 84                                        Belgium
## 85                                        Belarus
## 86                                     Tajikistan
## 87                                    El Salvador
## 88                                         Greece
## 89                                     Azerbaijan
## 90                                        Austria
## 91                                         Rwanda
## 92                                    Switzerland
## 93                                        Hungary
## 94                             Dominican Republic
## 95                                      Singapore
## 96                                        Somalia
## 97                                       Paraguay
## 98                                         Serbia
## 99                                     Kyrgyzstan
## 100                                  Sierra Leone
## 101                                      Bulgaria
## 102                                      Honduras
## 103                                    Costa Rica
## 104                                        Kuwait
## 105                                        Jordan
## 106                                          Cuba
## 107                                       Burundi
## 108                                      Slovakia
## 109                                       Denmark
## 110                                         Haiti
## 111                                       Finland
## 112                                        Panama
## 113                                          Oman
## 114                                     Nicaragua
## 115                                          Togo
## 116                                  Turkmenistan
## 117                                        Norway
## 118                                  Korea, North
## 119                                   New Zealand
## 120                                       Georgia
## 121                                       Ireland
## 122                        Congo, Republic of the
## 123                                    Mauritania
## 124                                      Mongolia
## 125                                          Laos
## 126                              Papua New Guinea
## 127                                       Uruguay
## 128                                         Qatar
## 129                                       Croatia
## 130                                     West Bank
## 131                                    Gaza Strip
## 132                                      Botswana
## 133                                       Lebanon
## 134                                       Moldova
## 135                                   Puerto Rico
## 136                                     Lithuania
## 137                        Bosnia and Herzegovina
## 138                                       Armenia
## 139                                   South Sudan
## 140                                       Jamaica
## 141                                         Gabon
## 142                                       Namibia
## 143                                       Albania
## 144                                   Gambia, The
## 145                                      Slovenia
## 146                                 Guinea-Bissau
## 147                                        Latvia
## 148                                       Bahrain
## 149                                     Mauritius
## 150                                       Estonia
## 151                               North Macedonia
## 152                           Trinidad and Tobago
## 153                      Central African Republic
## 154                                       Eritrea
## 155                                        Kosovo
## 156                                       Liberia
## 157                                       Lesotho
## 158                                   Timor-Leste
## 159                                      Eswatini
## 160                                        Cyprus
## 161                                    Montenegro
## 162                                         Macau
## 163                                          Fiji
## 164                                      Suriname
## 165                             Equatorial Guinea
## 166                                    Luxembourg
## 167                                        Guyana
## 168                                       Comoros
## 169                                        Bhutan
## 170                                      Maldives
## 171                                         Malta
## 172                                    Cabo Verde
## 173                                        Brunei
## 174                                      Djibouti
## 175                               Solomon Islands
## 176                                       Iceland
## 177                                  Bahamas, The
## 178                              French Polynesia
## 179                                      Barbados
## 180                                        Belize
## 181                                 New Caledonia
## 182                                       Vanuatu
## 183                                    Seychelles
## 184                         Sao Tome and Principe
## 185                           Antigua and Barbuda
## 186                                   Saint Lucia
## 187                                       Curacao
## 188                                         Aruba
## 189                                         Samoa
## 190                                        Jersey
## 191                                       Andorra
## 192              Saint Vincent and the Grenadines
## 193                                       Grenada
## 194                                Cayman Islands
## 195                                          Guam
## 196                                Virgin Islands
## 197                                      Guernsey
## 198                                  Saint Martin
## 199                                  Sint Maarten
## 200                                       Bermuda
## 201                                     Greenland
## 202                                      Kiribati
## 203                                         Tonga
## 204                                      Dominica
## 205                                 Faroe Islands
## 206                         Saint Kitts and Nevis
## 207                                 Liechtenstein
## 208                                    San Marino
## 209                                        Monaco
## 210                        British Virgin Islands
## 211                                     Gibraltar
## 212                                      Anguilla
## 213                      Turks and Caicos Islands
## 214                                         Palau
## 215               Micronesia, Federated States of
## 216                      Northern Mariana Islands
## 217                                  Cook Islands
## 218                              Marshall Islands
## 219                                         Nauru
## 220                                        Tuvalu
## 221             Falkland Islands (Islas Malvinas)
## 222                                    Montserrat
## 223 Saint Helena, Ascension, and Tristan da Cunha
## 224                                American Samoa
## 225                             Wallis and Futuna
##                                            slug         value
## 1                                         china 1,781,000,000
## 2                                         india 1,143,000,000
## 3                                 united-states   372,682,000
## 4                                     indonesia   316,553,000
## 5                                        russia   245,267,000
## 6                                       nigeria   222,225,000
## 7                                        brazil   212,926,000
## 8                                         japan   207,648,000
## 9                                      pakistan   192,780,000
## 10                                   bangladesh   180,198,000
## 11                                  philippines   166,454,000
## 12                                         iran   145,668,000
## 13                                      vietnam   137,412,000
## 14                                       mexico   127,872,000
## 15                                     thailand   126,414,000
## 16                                      germany   104,400,000
## 17                                        egypt   103,450,000
## 18                                 south-africa   100,260,000
## 19                               turkey-turkiye    90,298,000
## 20                               united-kingdom    81,564,000
## 21                                     colombia    80,812,000
## 22                                        italy    78,503,000
## 23                                  korea-south    76,992,000
## 24                                       france    76,807,000
## 25                                     ethiopia    69,123,000
## 26                                        kenya    65,737,000
## 27                                    argentina    60,236,000
## 28                                     tanzania    60,192,000
## 29                                        spain    59,020,000
## 30                                        burma    57,807,000
## 31                                      morocco    52,959,000
## 32                                       poland    52,589,000
## 33             congo-democratic-republic-of-the    49,844,000
## 34                                      ukraine    49,304,000
## 35                                      algeria    49,019,000
## 36                                 cote-divoire    49,006,000
## 37                                 saudi-arabia    48,198,000
## 38                                     malaysia    47,952,000
## 39                                         iraq    43,688,000
## 40                                         peru    41,549,000
## 41                                        ghana    40,045,000
## 42                                        nepal    38,213,000
## 43                                   uzbekistan    35,690,000
## 44                                       canada    35,082,000
## 45                                        sudan    34,671,000
## 46                                       uganda    33,068,000
## 47                                    sri-lanka    31,237,000
## 48                                       taiwan    30,000,000
## 49                                    australia    28,018,000
## 50                                        chile    26,415,000
## 51                                         mali    25,869,000
## 52                                   kazakhstan    25,299,000
## 53                                 burkina-faso    24,678,000
## 54                                       angola    23,978,000
## 55                                      romania    23,219,000
## 56                                     cameroon    23,107,000
## 57                                  afghanistan    22,678,000
## 58                                    hong-kong    21,861,000
## 59                                      senegal    20,855,000
## 60                                   madagascar    20,783,000
## 61                                  netherlands    20,737,000
## 62                                    guatemala    20,553,000
## 63                         united-arab-emirates    20,036,000
## 64                                       zambia    19,838,000
## 65                                     cambodia    19,505,000
## 66                                    venezuela    17,949,000
## 67                                      ecuador    17,491,000
## 68                                        syria    16,991,000
## 69                                      tunisia    15,971,000
## 70                                        yemen    15,178,000
## 71                                        benin    14,550,000
## 72                                     zimbabwe    14,301,000
## 73                                        niger    14,239,000
## 74                                        libya    13,940,000
## 75                                   mozambique    13,871,000
## 76                                       guinea    13,795,000
## 77                                       israel    13,758,000
## 78                                      czechia    13,475,000
## 79                                       sweden    13,194,000
## 80                                     portugal    12,792,000
## 81                                       malawi    12,269,000
## 82                                         chad    12,087,000
## 83                                      bolivia    12,034,000
## 84                                      belgium    11,874,000
## 85                                      belarus    11,771,000
## 86                                   tajikistan    11,584,000
## 87                                  el-salvador    11,509,000
## 88                                       greece    11,326,000
## 89                                   azerbaijan    11,068,000
## 90                                      austria    11,035,000
## 91                                       rwanda    11,002,000
## 92                                  switzerland    10,450,000
## 93                                      hungary    10,372,000
## 94                           dominican-republic    10,150,000
## 95                                    singapore     9,351,000
## 96                                      somalia     8,844,000
## 97                                     paraguay     8,659,000
## 98                                       serbia     8,621,000
## 99                                   kyrgyzstan     8,511,000
## 100                                sierra-leone     8,227,000
## 101                                    bulgaria     7,964,000
## 102                                    honduras     7,937,000
## 103                                  costa-rica     7,876,000
## 104                                      kuwait     7,726,000
## 105                                      jordan     7,626,000
## 106                                        cuba     7,600,000
## 107                                     burundi     7,471,000
## 108                                    slovakia     7,445,000
## 109                                     denmark     7,444,000
## 110                                       haiti     7,319,000
## 111                                     finland     7,130,000
## 112                                      panama     6,891,000
## 113                                        oman     6,750,000
## 114                                   nicaragua     6,652,000
## 115                                        togo     6,564,000
## 116                                turkmenistan     6,255,000
## 117                                      norway     6,015,000
## 118                                 korea-north     6,000,000
## 119                                 new-zealand     5,947,000
## 120                                     georgia     5,844,000
## 121                                     ireland     5,690,000
## 122                       congo-republic-of-the     5,648,000
## 123                                  mauritania     5,358,000
## 124                                    mongolia     4,836,000
## 125                                        laos     4,823,000
## 126                            papua-new-guinea     4,818,000
## 127                                     uruguay     4,741,000
## 128                                       qatar     4,693,000
## 129                                     croatia     4,480,000
## 130                                   west-bank     4,388,000
## 131                                  gaza-strip     4,388,000
## 132                                    botswana     4,348,000
## 133                                     lebanon     4,288,000
## 134                                     moldova     4,170,000
## 135                                 puerto-rico     3,896,000
## 136                                   lithuania     3,826,000
## 137                      bosnia-and-herzegovina     3,812,000
## 138                                     armenia     3,761,000
## 139                                 south-sudan     3,276,000
## 140                                     jamaica     3,003,000
## 141                                       gabon     2,995,000
## 142                                     namibia     2,906,000
## 143                                     albania     2,782,000
## 144                                  gambia-the     2,678,000
## 145                                    slovenia     2,675,000
## 146                               guinea-bissau     2,652,000
## 147                                      latvia     2,167,000
## 148                                     bahrain     2,141,000
## 149                                   mauritius     2,097,000
## 150                                     estonia     2,056,000
## 151                             north-macedonia     2,048,000
## 152                         trinidad-and-tobago     1,999,000
## 153                    central-african-republic     1,831,000
## 154                                     eritrea     1,801,000
## 155                                      kosovo     1,777,859
## 156                                     liberia     1,653,000
## 157                                     lesotho     1,557,000
## 158                                 timor-leste     1,481,000
## 159                                    eswatini     1,468,000
## 160                                      cyprus     1,392,000
## 161                                  montenegro     1,274,000
## 162                                       macau     1,213,000
## 163                                        fiji       992,000
## 164                                    suriname       929,000
## 165                           equatorial-guinea       893,000
## 166                                  luxembourg       876,000
## 167                                      guyana       856,000
## 168                                     comoros       839,000
## 169                                      bhutan       742,000
## 170                                    maldives       715,000
## 171                                       malta       702,000
## 172                                  cabo-verde       589,000
## 173                                      brunei       529,000
## 174                                    djibouti       519,000
## 175                             solomon-islands       474,000
## 176                                     iceland       457,000
## 177                                 bahamas-the       404,000
## 178                            french-polynesia       328,000
## 179                                    barbados       323,000
## 180                                      belize       264,000
## 181                               new-caledonia       260,000
## 182                                     vanuatu       256,000
## 183                                  seychelles       205,000
## 184                       sao-tome-and-principe       197,000
## 185                         antigua-and-barbuda       184,000
## 186                                 saint-lucia       172,000
## 187                                     curacao       168,000
## 188                                       aruba       141,000
## 189                                       samoa       134,000
## 190                                      jersey       124,083
## 191                                     andorra       114,000
## 192            saint-vincent-and-the-grenadines       104,000
## 193                                     grenada       101,000
## 194                              cayman-islands       100,000
## 195                                        guam        98,000
## 196                              virgin-islands        80,000
## 197                                    guernsey        71,485
## 198                                saint-martin        68,840
## 199                                sint-maarten        68,840
## 200                                     bermuda        68,000
## 201                                   greenland        67,000
## 202                                    kiribati        64,000
## 203                                       tonga        64,000
## 204                                    dominica        62,000
## 205                               faroe-islands        59,000
## 206                       saint-kitts-and-nevis        57,000
## 207                               liechtenstein        50,000
## 208                                  san-marino        41,000
## 209                                      monaco        39,000
## 210                      british-virgin-islands        38,000
## 211                                   gibraltar        37,000
## 212                                    anguilla        26,000
## 213                    turks-and-caicos-islands        25,085
## 214                                       palau        24,000
## 215              micronesia-federated-states-of        22,000
## 216                    northern-mariana-islands        20,474
## 217                                cook-islands        17,000
## 218                            marshall-islands        16,000
## 219                                       nauru        10,000
## 220                                      tuvalu         9,000
## 221             falkland-islands-islas-malvinas         6,000
## 222                                  montserrat         5,000
## 223 saint-helena-ascension-and-tristan-da-cunha         4,000
## 224                              american-samoa         2,250
## 225                           wallis-and-futuna             0
##     date_of_information ranking                            region
## 1                  2022       1           East and Southeast Asia
## 2                  2022       2                        South Asia
## 3                  2022       3                     North America
## 4                  2022       4           East and Southeast Asia
## 5                  2022       5                      Central Asia
## 6                  2022       6                            Africa
## 7                  2022       7                     South America
## 8                  2022       8           East and Southeast Asia
## 9                  2022       9                        South Asia
## 10                 2022      10                        South Asia
## 11                 2022      11           East and Southeast Asia
## 12                 2022      12                       Middle East
## 13                 2022      13           East and Southeast Asia
## 14                 2022      14                     North America
## 15                 2022      15           East and Southeast Asia
## 16                 2022      16                            Europe
## 17                 2022      17                            Africa
## 18                 2022      18                            Africa
## 19                 2022      19                       Middle East
## 20                 2022      20                            Europe
## 21                 2022      21                     South America
## 22                 2022      22                            Europe
## 23                 2022      23           East and Southeast Asia
## 24                 2022      24                            Europe
## 25                 2022      25                            Africa
## 26                 2022      26                            Africa
## 27                 2022      27                     South America
## 28                 2022      28                            Africa
## 29                 2022      29                            Europe
## 30                 2022      30           East and Southeast Asia
## 31                 2022      31                            Africa
## 32                 2022      32                            Europe
## 33                 2022      33                            Africa
## 34                 2022      34                            Europe
## 35                 2022      35                            Africa
## 36                 2022      36                            Africa
## 37                 2022      37                       Middle East
## 38                 2022      38           East and Southeast Asia
## 39                 2022      39                       Middle East
## 40                 2022      40                     South America
## 41                 2022      41                            Africa
## 42                 2021      42                        South Asia
## 43                 2022      43                      Central Asia
## 44                 2022      44                     North America
## 45                 2022      45                            Africa
## 46                 2022      46                            Africa
## 47                 2022      47                        South Asia
## 48                 2023      48           East and Southeast Asia
## 49                 2022      49             Australia and Oceania
## 50                 2022      50                     South America
## 51                 2022      51                            Africa
## 52                 2022      52                      Central Asia
## 53                 2021      53                            Africa
## 54                 2022      54                            Africa
## 55                 2022      55                            Europe
## 56                 2022      56                            Africa
## 57                 2021      57                        South Asia
## 58                 2022      58           East and Southeast Asia
## 59                 2022      59                            Africa
## 60                 2022      60                            Africa
## 61                 2022      61                            Europe
## 62                 2022      62 Central America and the Caribbean
## 63                 2022      63                       Middle East
## 64                 2022      64                            Africa
## 65                 2022      65           East and Southeast Asia
## 66                 2022      66                     South America
## 67                 2022      67                     South America
## 68                 2021      68                       Middle East
## 69                 2022      69                            Africa
## 70                 2021      70                       Middle East
## 71                 2022      71                            Africa
## 72                 2022      72                            Africa
## 73                 2021      73                            Africa
## 74                 2022      74                            Africa
## 75                 2022      75                            Africa
## 76                 2021      76                            Africa
## 77                 2022      77                       Middle East
## 78                 2022      78                            Europe
## 79                 2022      79                            Europe
## 80                 2022      80                            Europe
## 81                 2022      81                            Africa
## 82                 2022      82                            Africa
## 83                 2021      83                     South America
## 84                 2022      84                            Europe
## 85                 2022      85                            Europe
## 86                 2021      86                      Central Asia
## 87                 2022      87 Central America and the Caribbean
## 88                 2022      88                            Europe
## 89                 2022      89                       Middle East
## 90                 2022      90                            Europe
## 91                 2022      91                            Africa
## 92                 2022      92                            Europe
## 93                 2022      93                            Europe
## 94                 2022      94 Central America and the Caribbean
## 95                 2022      95           East and Southeast Asia
## 96                 2022      96                            Africa
## 97                 2022      97                     South America
## 98                 2022      98                            Europe
## 99                 2021      99                      Central Asia
## 100                2021     100                            Africa
## 101                2022     101                            Europe
## 102                2022     102 Central America and the Caribbean
## 103                2022     103 Central America and the Caribbean
## 104                2022     104                       Middle East
## 105                2022     105                       Middle East
## 106                2022     106 Central America and the Caribbean
## 107                2022     107                            Africa
## 108                2022     108                            Europe
## 109                2022     109                            Europe
## 110                2021     110 Central America and the Caribbean
## 111                2022     111                            Europe
## 112                2022     112 Central America and the Caribbean
## 113                2022     113                       Middle East
## 114                2021     114 Central America and the Caribbean
## 115                2022     115                            Africa
## 116                2021     116                      Central Asia
## 117                2022     117                            Europe
## 118                2021     118           East and Southeast Asia
## 119                2022     119             Australia and Oceania
## 120                2022     120                       Middle East
## 121                2022     121                            Europe
## 122                2021     122                            Africa
## 123                2022     123                            Africa
## 124                2022     124           East and Southeast Asia
## 125                2021     125           East and Southeast Asia
## 126                2021     126           East and Southeast Asia
## 127                2022     127                     South America
## 128                2022     128                       Middle East
## 129                2022     129                            Europe
## 130                2022     130                       Middle East
## 131                2022     131                       Middle East
## 132                2022     132                            Africa
## 133                2021     133                       Middle East
## 134                2022     134                            Europe
## 135                2022     135 Central America and the Caribbean
## 136                2022     136                            Europe
## 137                2022     137                            Europe
## 138                2022     138                       Middle East
## 139                2022     139                            Africa
## 140                2022     140 Central America and the Caribbean
## 141                2022     141                            Africa
## 142                2022     142                            Africa
## 143                2022     143                            Europe
## 144                2021     144                            Africa
## 145                2022     145                            Europe
## 146                2022     146                            Africa
## 147                2022     147                            Europe
## 148                2022     148                       Middle East
## 149                2022     149                            Africa
## 150                2022     150                            Europe
## 151                2022     151                            Europe
## 152                2022     152 Central America and the Caribbean
## 153                2021     153                            Africa
## 154                2021     154                            Africa
## 155                2022     155                            Europe
## 156                2021     156                            Africa
## 157                2022     157                            Africa
## 158                2022     158           East and Southeast Asia
## 159                2022     159                            Africa
## 160                2022     160                            Europe
## 161                2022     161                            Europe
## 162                2022     162           East and Southeast Asia
## 163                2021     163             Australia and Oceania
## 164                2022     164                     South America
## 165                2022     165                            Africa
## 166                2021     166                            Europe
## 167                2021     167                     South America
## 168                2022     168                            Africa
## 169                2022     169                        South Asia
## 170                2022     170                        South Asia
## 171                2022     171                            Europe
## 172                2022     172                            Africa
## 173                2022     173           East and Southeast Asia
## 174                2022     174                            Africa
## 175                2021     175             Australia and Oceania
## 176                2022     176                            Europe
## 177                2022     177 Central America and the Caribbean
## 178                2022     178             Australia and Oceania
## 179                2022     179 Central America and the Caribbean
## 180                2021     180 Central America and the Caribbean
## 181                2021     181             Australia and Oceania
## 182                2022     182             Australia and Oceania
## 183                2022     183                            Africa
## 184                2022     184                            Africa
## 185                2021     185 Central America and the Caribbean
## 186                2021     186 Central America and the Caribbean
## 187                2021     187 Central America and the Caribbean
## 188                2021     188 Central America and the Caribbean
## 189                2022     189             Australia and Oceania
## 190                2021     190                            Europe
## 191                2022     191                            Europe
## 192                2022     192 Central America and the Caribbean
## 193                2021     193 Central America and the Caribbean
## 194                2021     194 Central America and the Caribbean
## 195                2009     195             Australia and Oceania
## 196                2021     196 Central America and the Caribbean
## 197                2021     197                            Europe
## 198                2012     198 Central America and the Caribbean
## 199                2012     199 Central America and the Caribbean
## 200                2021     200                     North America
## 201                2021     201                     North America
## 202                2022     202             Australia and Oceania
## 203                2021     203             Australia and Oceania
## 204                2021     204 Central America and the Caribbean
## 205                2021     205                            Europe
## 206                2021     206 Central America and the Caribbean
## 207                2022     207                            Europe
## 208                2022     208                            Europe
## 209                2022     209                            Europe
## 210                2021     210 Central America and the Caribbean
## 211                2022     211                            Europe
## 212                2021     212 Central America and the Caribbean
## 213                2004     213 Central America and the Caribbean
## 214                2022     214             Australia and Oceania
## 215                2021     215             Australia and Oceania
## 216                2004     216             Australia and Oceania
## 217                2021     217             Australia and Oceania
## 218                2021     218             Australia and Oceania
## 219                2021     219             Australia and Oceania
## 220                2021     220             Australia and Oceania
## 221                2021     221                     South America
## 222                2020     222 Central America and the Caribbean
## 223                2021     223                            Africa
## 224                2009     224             Australia and Oceania
## 225                2018     225             Australia and Oceania
data22 <- data2[, c('value', 'region')]

head(data22)
##           value                  region
## 1 1,781,000,000 East and Southeast Asia
## 2 1,143,000,000              South Asia
## 3   372,682,000           North America
## 4   316,553,000 East and Southeast Asia
## 5   245,267,000            Central Asia
## 6   222,225,000                  Africa
library(rio)
data3= import("Telephones - fixed lines.csv")
data3
##                                              name
## 1                                           China
## 2                                   United States
## 3                                           Japan
## 4                                         Germany
## 5                                          France
## 6                                  United Kingdom
## 7                                            Iran
## 8                                           India
## 9                                          Brazil
## 10                                         Mexico
## 11                                         Russia
## 12                                   Korea, South
## 13                                          Italy
## 14                                          Spain
## 15                                          Egypt
## 16                                         Canada
## 17                               Turkey (Turkiye)
## 18                                         Taiwan
## 19                                       Malaysia
## 20                                      Indonesia
## 21                                      Argentina
## 22                                       Colombia
## 23                                   Saudi Arabia
## 24                                      Australia
## 25                                     Uzbekistan
## 26                                        Algeria
## 27                                       Portugal
## 28                                         Poland
## 29                                         Greece
## 30                                    Philippines
## 31                                    Netherlands
## 32                                       Thailand
## 33                                        Belarus
## 34                                      Hong Kong
## 35                                         Israel
## 36                                        Austria
## 37                                      Venezuela
## 38                                        Belgium
## 39                                    Switzerland
## 40                                     Kazakhstan
## 41                                        Hungary
## 42                                          Syria
## 43                                       Pakistan
## 44                                        Morocco
## 45                                      Sri Lanka
## 46                                         Serbia
## 47                                           Iraq
## 48                                        Vietnam
## 49                           United Arab Emirates
## 50                                        Romania
## 51                                          Chile
## 52                                      Guatemala
## 53                                      Singapore
## 54                                           Peru
## 55                                        Tunisia
## 56                                        Ukraine
## 57                                        Ecuador
## 58                                     Azerbaijan
## 59                                           Cuba
## 60                                        Ireland
## 61                                   South Africa
## 62                                           Laos
## 63                                         Sweden
## 64                                        Uruguay
## 65                                          Yemen
## 66                                        Croatia
## 67                                          Libya
## 68                                        Czechia
## 69                                   Korea, North
## 70                             Dominican Republic
## 71                                        Moldova
## 72                                       Cameroon
## 73                                        Lebanon
## 74                                    El Salvador
## 75                                       Ethiopia
## 76                                         Panama
## 77                                   Turkmenistan
## 78                                    New Zealand
## 79                                    Puerto Rico
## 80                                          Nepal
## 81                                        Denmark
## 82                                       Bulgaria
## 83                                       Slovenia
## 84                         Bosnia and Herzegovina
## 85                                         Kuwait
## 86                                           Oman
## 87                                        Bolivia
## 88                                       Slovakia
## 89                                          Burma
## 90                                          Qatar
## 91                                     Tajikistan
## 92                                     Costa Rica
## 93                                       Mongolia
## 94                                         Jordan
## 95                                      Mauritius
## 96                                      West Bank
## 97                                     Gaza Strip
## 98                                        Jamaica
## 99                                North Macedonia
## 100                                      Honduras
## 101                                        Kosovo
## 102                                       Armenia
## 103                                         Ghana
## 104                           Trinidad and Tobago
## 105                                          Mali
## 106                                       Georgia
## 107                                    Kyrgyzstan
## 108                                       Senegal
## 109                                        Cyprus
## 110                                      Zimbabwe
## 111                                    Bangladesh
## 112                                       Estonia
## 113                                 Cote d'Ivoire
## 114                                    Luxembourg
## 115                                         Malta
## 116                                       Bahrain
## 117                                     Lithuania
## 118                                     Nicaragua
## 119                                    Montenegro
## 120                                       Finland
## 121                                       Albania
## 122                                        Latvia
## 123                                      Paraguay
## 124                              Papua New Guinea
## 125                                         Sudan
## 126                                   Afghanistan
## 127                                        Norway
## 128                              French Polynesia
## 129                                        Guyana
## 130                                        Brunei
## 131                                      Barbados
## 132                                        Uganda
## 133                                      Suriname
## 134                                       Nigeria
## 135                                        Zambia
## 136                                        Angola
## 137                                       Iceland
## 138                                      Botswana
## 139                                         Macau
## 140                                       Somalia
## 141                                       Namibia
## 142                                  Bahamas, The
## 143                                      Tanzania
## 144                                  Burkina Faso
## 145                                Virgin Islands
## 146                                          Guam
## 147                                          Togo
## 148                                       Eritrea
## 149                                         Kenya
## 150                                   Gambia, The
## 151                                         Niger
## 152                                    Cabo Verde
## 153                                       Curacao
## 154                                       Andorra
## 155                                          Fiji
## 156                                        Jersey
## 157                                    Mauritania
## 158                                 New Caledonia
## 159                                        Monaco
## 160                                         Gabon
## 161                                      Eswatini
## 162                                      Cambodia
## 163                                Cayman Islands
## 164                                         Aruba
## 165                                      Guernsey
## 166                                    Mozambique
## 167                                      Djibouti
## 168                           Antigua and Barbuda
## 169                                       Grenada
## 170                                    Madagascar
## 171                                       Bermuda
## 172                        British Virgin Islands
## 173                                        Bhutan
## 174                      Northern Mariana Islands
## 175                                    Seychelles
## 176                                        Belize
## 177                        Congo, Republic of the
## 178                                     Gibraltar
## 179                                    San Marino
## 180                         Saint Kitts and Nevis
## 181                                 Faroe Islands
## 182                                       Burundi
## 183                                   Saint Lucia
## 184                                      Maldives
## 185                             Equatorial Guinea
## 186              Saint Vincent and the Grenadines
## 187                                         Tonga
## 188                                 Liechtenstein
## 189                                        Rwanda
## 190                                American Samoa
## 191                                        Malawi
## 192                                         Palau
## 193                                  Cook Islands
## 194                                       Lesotho
## 195                               Solomon Islands
## 196                                      Dominica
## 197               Micronesia, Federated States of
## 198                                       Comoros
## 199                                     Greenland
## 200                                      Anguilla
## 201                                       Liberia
## 202                                         Haiti
## 203                                         Samoa
## 204                                          Chad
## 205                                 Guinea-Bissau
## 206                     Saint Pierre and Miquelon
## 207 Saint Helena, Ascension, and Tristan da Cunha
## 208                      Turks and Caicos Islands
## 209                             Wallis and Futuna
## 210                                       Vanuatu
## 211                                    Montserrat
## 212                         Sao Tome and Principe
## 213                                   Timor-Leste
## 214                              Marshall Islands
## 215                      Central African Republic
## 216                                        Tuvalu
## 217                                         Benin
## 218             Falkland Islands (Islas Malvinas)
## 219                                          Niue
## 220                                       Tokelau
## 221                                  Sierra Leone
## 222                                        Guinea
## 223                                      Kiribati
## 224             Congo, Democratic Republic of the
##                                            slug       value date_of_information
## 1                                         china 179,414,000                2022
## 2                                 united-states  91,623,000                2022
## 3                                         japan  60,721,000                2022
## 4                                       germany  38,580,000                2022
## 5                                        france  37,740,000                2022
## 6                                united-kingdom  29,798,000                2022
## 7                                          iran  29,342,000                2022
## 8                                         india  27,450,000                2022
## 9                                        brazil  27,258,000                2022
## 10                                       mexico  27,185,000                2022
## 11                                       russia  23,864,000                2021
## 12                                  korea-south  22,810,000                2022
## 13                                        italy  19,982,000                2022
## 14                                        spain  18,687,000                2022
## 15                                        egypt  11,600,000                2022
## 16                                       canada  11,312,000                2022
## 17                               turkey-turkiye  11,198,000                2022
## 18                                       taiwan  10,000,000                2023
## 19                                     malaysia   8,453,000                2022
## 20                                    indonesia   8,424,000                2022
## 21                                    argentina   7,615,000                2022
## 22                                     colombia   7,588,000                2022
## 23                                 saudi-arabia   6,773,000                2022
## 24                                    australia   6,409,000                2022
## 25                                   uzbekistan   5,686,000                2022
## 26                                      algeria   5,576,000                2022
## 27                                     portugal   5,437,000                2022
## 28                                       poland   5,277,000                2022
## 29                                       greece   4,907,000                2022
## 30                                  philippines   4,885,000                2022
## 31                                  netherlands   4,570,000                2022
## 32                                     thailand   4,368,000                2022
## 33                                      belarus   4,230,000                2022
## 34                                    hong-kong   3,673,000                2022
## 35                                       israel   3,574,000                2022
## 36                                      austria   3,544,000                2022
## 37                                    venezuela   3,147,000                2022
## 38                                      belgium   2,953,000                2022
## 39                                  switzerland   2,919,000                2022
## 40                                   kazakhstan   2,888,000                2022
## 41                                      hungary   2,845,000                2022
## 42                                        syria   2,821,000                2021
## 43                                     pakistan   2,799,000                2022
## 44                                      morocco   2,645,000                2022
## 45                                    sri-lanka   2,582,000                2022
## 46                                       serbia   2,539,000                2022
## 47                                         iraq   2,392,000                2022
## 48                                      vietnam   2,391,000                2022
## 49                         united-arab-emirates   2,286,000                2022
## 50                                      romania   2,222,000                2022
## 51                                        chile   2,217,000                2022
## 52                                    guatemala   1,918,000                2022
## 53                                    singapore   1,906,000                2022
## 54                                         peru   1,798,000                2022
## 55                                      tunisia   1,790,000                2022
## 56                                      ukraine   1,739,000                2022
## 57                                      ecuador   1,644,000                2022
## 58                                   azerbaijan   1,641,000                2022
## 59                                         cuba   1,574,000                2022
## 60                                      ireland   1,498,000                2022
## 61                                 south-africa   1,310,000                2022
## 62                                         laos   1,300,000                2021
## 63                                       sweden   1,261,000                2021
## 64                                      uruguay   1,259,000                2022
## 65                                        yemen   1,240,000                2021
## 66                                      croatia   1,235,000                2022
## 67                                        libya   1,218,000                2022
## 68                                      czechia   1,214,000                2022
## 69                                  korea-north   1,180,000                2021
## 70                           dominican-republic   1,144,000                2022
## 71                                      moldova     951,000                2022
## 72                                     cameroon     929,000                2022
## 73                                      lebanon     875,000                2021
## 74                                  el-salvador     863,000                2022
## 75                                     ethiopia     862,000                2022
## 76                                       panama     811,000                2022
## 77                                 turkmenistan     802,000                2021
## 78                                  new-zealand     757,000                2022
## 79                                  puerto-rico     739,000                2022
## 80                                        nepal     726,000                2021
## 81                                      denmark     712,000                2022
## 82                                     bulgaria     691,000                2022
## 83                                     slovenia     676,000                2022
## 84                       bosnia-and-herzegovina     651,000                2022
## 85                                       kuwait     573,000                2022
## 86                                         oman     563,000                2022
## 87                                      bolivia     550,000                2021
## 88                                     slovakia     541,000                2022
## 89                                        burma     535,000                2022
## 90                                        qatar     524,000                2022
## 91                                   tajikistan     502,000                2021
## 92                                   costa-rica     492,000                2022
## 93                                     mongolia     475,000                2022
## 94                                       jordan     466,000                2022
## 95                                    mauritius     462,000                2022
## 96                                    west-bank     458,000                2022
## 97                                   gaza-strip     458,000                2022
## 98                                      jamaica     447,000                2022
## 99                              north-macedonia     436,000                2022
## 100                                    honduras     414,000                2022
## 101                                      kosovo     383,763                2022
## 102                                     armenia     366,000                2022
## 103                                       ghana     330,000                2022
## 104                         trinidad-and-tobago     326,000                2022
## 105                                        mali     307,000                2022
## 106                                     georgia     301,000                2022
## 107                                  kyrgyzstan     299,000                2021
## 108                                     senegal     297,000                2022
## 109                                      cyprus     297,000                2022
## 110                                    zimbabwe     291,000                2022
## 111                                  bangladesh     274,000                2022
## 112                                     estonia     266,000                2022
## 113                                cote-divoire     263,000                2022
## 114                                  luxembourg     261,000                2022
## 115                                       malta     259,000                2022
## 116                                     bahrain     253,000                2022
## 117                                   lithuania     250,000                2022
## 118                                   nicaragua     216,000                2022
## 119                                  montenegro     191,000                2022
## 120                                     finland     186,000                2022
## 121                                     albania     177,000                2022
## 122                                      latvia     174,000                2022
## 123                                    paraguay     169,000                2022
## 124                            papua-new-guinea     166,000                2021
## 125                                       sudan     156,000                2022
## 126                                 afghanistan     146,000                2021
## 127                                      norway     140,000                2022
## 128                            french-polynesia     139,000                2022
## 129                                      guyana     125,000                2021
## 130                                      brunei     122,000                2022
## 131                                    barbados     121,000                2022
## 132                                      uganda     117,000                2022
## 133                                    suriname     108,000                2022
## 134                                     nigeria      97,000                2022
## 135                                      zambia      96,000                2022
## 136                                      angola      94,000                2022
## 137                                     iceland      93,000                2022
## 138                                    botswana      92,000                2022
## 139                                       macau      92,000                2022
## 140                                     somalia      91,000                2022
## 141                                     namibia      86,000                2022
## 142                                 bahamas-the      86,000                2022
## 143                                    tanzania      85,000                2022
## 144                                burkina-faso      81,000                2021
## 145                              virgin-islands      76,000                2021
## 146                                        guam      70,000                2021
## 147                                        togo      66,000                2022
## 148                                     eritrea      66,000                2021
## 149                                       kenya      63,000                2022
## 150                                  gambia-the      60,000                2021
## 151                                       niger      58,000                2021
## 152                                  cabo-verde      57,000                2022
## 153                                     curacao      53,000                2021
## 154                                     andorra      51,000                2022
## 155                                        fiji      49,000                2021
## 156                                      jersey      48,122                2021
## 157                                  mauritania      48,000                2022
## 158                               new-caledonia      46,000                2021
## 159                                      monaco      45,000                2022
## 160                                       gabon      43,000                2022
## 161                                    eswatini      38,000                2022
## 162                                    cambodia      38,000                2022
## 163                              cayman-islands      36,000                2021
## 164                                       aruba      35,000                2021
## 165                                    guernsey      33,930                2021
## 166                                  mozambique      29,000                2022
## 167                                    djibouti      28,000                2022
## 168                         antigua-and-barbuda      27,000                2021
## 169                                     grenada      26,000                2021
## 170                                  madagascar      26,000                2022
## 171                                     bermuda      25,000                2021
## 172                      british-virgin-islands      23,000                2021
## 173                                      bhutan      20,000                2022
## 174                    northern-mariana-islands      20,000                2021
## 175                                  seychelles      19,000                2022
## 176                                      belize      19,000                2021
## 177                       congo-republic-of-the      17,000                2020
## 178                                   gibraltar      17,000                2022
## 179                                  san-marino      16,000                2022
## 180                       saint-kitts-and-nevis      16,000                2021
## 181                               faroe-islands      15,000                2021
## 182                                     burundi      15,000                2022
## 183                                 saint-lucia      14,000                2021
## 184                                    maldives      13,000                2022
## 185                           equatorial-guinea      11,000                2022
## 186            saint-vincent-and-the-grenadines      11,000                2022
## 187                                       tonga      11,000                2021
## 188                               liechtenstein      11,000                2022
## 189                                      rwanda      10,000                2022
## 190                              american-samoa      10,000                2021
## 191                                      malawi       9,000                2022
## 192                                       palau       8,000                2022
## 193                                cook-islands       7,000                2021
## 194                                     lesotho       7,000                2022
## 195                             solomon-islands       7,000                2021
## 196                                    dominica       7,000                2021
## 197              micronesia-federated-states-of       7,000                2021
## 198                                     comoros       7,000                2022
## 199                                   greenland       6,000                2020
## 200                                    anguilla       6,000                2021
## 201                                     liberia       6,000                2021
## 202                                       haiti       6,000                2021
## 203                                       samoa       5,000                2022
## 204                                        chad       5,000                2022
## 205                               guinea-bissau       4,800                2009
## 206                   saint-pierre-and-miquelon       4,800                2015
## 207 saint-helena-ascension-and-tristan-da-cunha       4,000                2021
## 208                    turks-and-caicos-islands       4,000                2021
## 209                           wallis-and-futuna       3,000                2021
## 210                                     vanuatu       3,000                2022
## 211                                  montserrat       3,000                2020
## 212                       sao-tome-and-principe       3,000                2022
## 213                                 timor-leste       2,000                2022
## 214                            marshall-islands       2,000                2014
## 215                    central-african-republic       2,000                2021
## 216                                      tuvalu       2,000                2021
## 217                                       benin       2,000                2022
## 218             falkland-islands-islas-malvinas       2,000                2021
## 219                                        niue       1,000                2021
## 220                                     tokelau         300                2010
## 221                                sierra-leone         269                2021
## 222                                      guinea           0                2021
## 223                                    kiribati           0                2022
## 224            congo-democratic-republic-of-the           0                2021
##     ranking                            region
## 1         1           East and Southeast Asia
## 2         2                     North America
## 3         3           East and Southeast Asia
## 4         4                            Europe
## 5         5                            Europe
## 6         6                            Europe
## 7         7                       Middle East
## 8         8                        South Asia
## 9         9                     South America
## 10       10                     North America
## 11       11                      Central Asia
## 12       12           East and Southeast Asia
## 13       13                            Europe
## 14       14                            Europe
## 15       15                            Africa
## 16       16                     North America
## 17       17                       Middle East
## 18       18           East and Southeast Asia
## 19       19           East and Southeast Asia
## 20       20           East and Southeast Asia
## 21       21                     South America
## 22       22                     South America
## 23       23                       Middle East
## 24       24             Australia and Oceania
## 25       25                      Central Asia
## 26       26                            Africa
## 27       27                            Europe
## 28       28                            Europe
## 29       29                            Europe
## 30       30           East and Southeast Asia
## 31       31                            Europe
## 32       32           East and Southeast Asia
## 33       33                            Europe
## 34       34           East and Southeast Asia
## 35       35                       Middle East
## 36       36                            Europe
## 37       37                     South America
## 38       38                            Europe
## 39       39                            Europe
## 40       40                      Central Asia
## 41       41                            Europe
## 42       42                       Middle East
## 43       43                        South Asia
## 44       44                            Africa
## 45       45                        South Asia
## 46       46                            Europe
## 47       47                       Middle East
## 48       48           East and Southeast Asia
## 49       49                       Middle East
## 50       50                            Europe
## 51       51                     South America
## 52       52 Central America and the Caribbean
## 53       53           East and Southeast Asia
## 54       54                     South America
## 55       55                            Africa
## 56       56                            Europe
## 57       57                     South America
## 58       58                       Middle East
## 59       59 Central America and the Caribbean
## 60       60                            Europe
## 61       61                            Africa
## 62       62           East and Southeast Asia
## 63       63                            Europe
## 64       64                     South America
## 65       65                       Middle East
## 66       66                            Europe
## 67       67                            Africa
## 68       68                            Europe
## 69       69           East and Southeast Asia
## 70       70 Central America and the Caribbean
## 71       71                            Europe
## 72       72                            Africa
## 73       73                       Middle East
## 74       74 Central America and the Caribbean
## 75       75                            Africa
## 76       76 Central America and the Caribbean
## 77       77                      Central Asia
## 78       78             Australia and Oceania
## 79       79 Central America and the Caribbean
## 80       80                        South Asia
## 81       81                            Europe
## 82       82                            Europe
## 83       83                            Europe
## 84       84                            Europe
## 85       85                       Middle East
## 86       86                       Middle East
## 87       87                     South America
## 88       88                            Europe
## 89       89           East and Southeast Asia
## 90       90                       Middle East
## 91       91                      Central Asia
## 92       92 Central America and the Caribbean
## 93       93           East and Southeast Asia
## 94       94                       Middle East
## 95       95                            Africa
## 96       96                       Middle East
## 97       97                       Middle East
## 98       98 Central America and the Caribbean
## 99       99                            Europe
## 100     100 Central America and the Caribbean
## 101     101                            Europe
## 102     102                       Middle East
## 103     103                            Africa
## 104     104 Central America and the Caribbean
## 105     105                            Africa
## 106     106                       Middle East
## 107     107                      Central Asia
## 108     108                            Africa
## 109     109                            Europe
## 110     110                            Africa
## 111     111                        South Asia
## 112     112                            Europe
## 113     113                            Africa
## 114     114                            Europe
## 115     115                            Europe
## 116     116                       Middle East
## 117     117                            Europe
## 118     118 Central America and the Caribbean
## 119     119                            Europe
## 120     120                            Europe
## 121     121                            Europe
## 122     122                            Europe
## 123     123                     South America
## 124     124           East and Southeast Asia
## 125     125                            Africa
## 126     126                        South Asia
## 127     127                            Europe
## 128     128             Australia and Oceania
## 129     129                     South America
## 130     130           East and Southeast Asia
## 131     131 Central America and the Caribbean
## 132     132                            Africa
## 133     133                     South America
## 134     134                            Africa
## 135     135                            Africa
## 136     136                            Africa
## 137     137                            Europe
## 138     138                            Africa
## 139     139           East and Southeast Asia
## 140     140                            Africa
## 141     141                            Africa
## 142     142 Central America and the Caribbean
## 143     143                            Africa
## 144     144                            Africa
## 145     145 Central America and the Caribbean
## 146     146             Australia and Oceania
## 147     147                            Africa
## 148     148                            Africa
## 149     149                            Africa
## 150     150                            Africa
## 151     151                            Africa
## 152     152                            Africa
## 153     153 Central America and the Caribbean
## 154     154                            Europe
## 155     155             Australia and Oceania
## 156     156                            Europe
## 157     157                            Africa
## 158     158             Australia and Oceania
## 159     159                            Europe
## 160     160                            Africa
## 161     161                            Africa
## 162     162           East and Southeast Asia
## 163     163 Central America and the Caribbean
## 164     164 Central America and the Caribbean
## 165     165                            Europe
## 166     166                            Africa
## 167     167                            Africa
## 168     168 Central America and the Caribbean
## 169     169 Central America and the Caribbean
## 170     170                            Africa
## 171     171                     North America
## 172     172 Central America and the Caribbean
## 173     173                        South Asia
## 174     174             Australia and Oceania
## 175     175                            Africa
## 176     176 Central America and the Caribbean
## 177     177                            Africa
## 178     178                            Europe
## 179     179                            Europe
## 180     180 Central America and the Caribbean
## 181     181                            Europe
## 182     182                            Africa
## 183     183 Central America and the Caribbean
## 184     184                        South Asia
## 185     185                            Africa
## 186     186 Central America and the Caribbean
## 187     187             Australia and Oceania
## 188     188                            Europe
## 189     189                            Africa
## 190     190             Australia and Oceania
## 191     191                            Africa
## 192     192             Australia and Oceania
## 193     193             Australia and Oceania
## 194     194                            Africa
## 195     195             Australia and Oceania
## 196     196 Central America and the Caribbean
## 197     197             Australia and Oceania
## 198     198                            Africa
## 199     199                     North America
## 200     200 Central America and the Caribbean
## 201     201                            Africa
## 202     202 Central America and the Caribbean
## 203     203             Australia and Oceania
## 204     204                            Africa
## 205     205                            Africa
## 206     206                     North America
## 207     207                            Africa
## 208     208 Central America and the Caribbean
## 209     209             Australia and Oceania
## 210     210             Australia and Oceania
## 211     211 Central America and the Caribbean
## 212     212                            Africa
## 213     213           East and Southeast Asia
## 214     214             Australia and Oceania
## 215     215                            Africa
## 216     216             Australia and Oceania
## 217     217                            Africa
## 218     218                     South America
## 219     219             Australia and Oceania
## 220     220             Australia and Oceania
## 221     221                            Africa
## 222     222                            Africa
## 223     223             Australia and Oceania
## 224     224                            Africa
data31 <- data3[, c('value', 'region')]

head(data31)
##         value                  region
## 1 179,414,000 East and Southeast Asia
## 2  91,623,000           North America
## 3  60,721,000 East and Southeast Asia
## 4  38,580,000                  Europe
## 5  37,740,000                  Europe
## 6  29,798,000                  Europe
library(rio)
data4= import("Public_debt_clean.csv")
data4
##                                  name                             slug % of GDP
## 1                              Greece                           greece   237.35
## 2                               Japan                            japan   216.36
## 3                      United Kingdom                   united-kingdom   185.35
## 4                           Singapore                        singapore   153.80
## 5                             Lebanon                          lebanon   146.80
## 6                            Barbados                         barbados   146.61
## 7                               Spain                            spain   134.10
## 8                               Italy                            italy   131.80
## 9                             Eritrea                          eritrea   131.20
## 10             Congo, Republic of the            congo-republic-of-the   130.80
## 11                         Cabo Verde                       cabo-verde   125.80
## 12                           Portugal                         portugal   125.70
## 13                              Sudan                            sudan   121.60
## 14                             France                           france   116.49
## 15                      United States                    united-states   115.70
## 16                             Bhutan                           bhutan   111.01
## 17                            Belgium                          belgium   108.06
## 18                            Jamaica                          jamaica   106.28
## 19                              Egypt                            egypt   103.00
## 20                             Belize                           belize    99.00
## 21                             Cyprus                           cyprus    97.50
## 22                         Mauritania                       mauritania    96.60
## 23                         San Marino                       san-marino    95.12
## 24                              Syria                            syria    94.80
## 25                            Austria                          austria    94.53
## 26                            Croatia                          croatia    91.00
## 27                            Bahrain                          bahrain    88.50
## 28                            Iceland                          iceland    88.46
## 29              Sao Tome and Principe            sao-tome-and-principe    88.40
## 30                        Gambia, The                       gambia-the    88.00
## 31                            Hungary                          hungary    87.00
## 32                Antigua and Barbuda              antigua-and-barbuda    86.80
## 33                              Aruba                            aruba    86.00
## 34                              Palau                            palau    85.19
## 35                         Mozambique                       mozambique    84.16
## 36                       Bahamas, The                      bahamas-the    83.68
## 37                           Dominica                         dominica    82.70
## 38                            Albania                          albania    82.38
## 39                           Zimbabwe                         zimbabwe    82.30
## 40                             Brazil                           brazil    80.41
## 41                           Slovakia                         slovakia    79.31
## 42                          Sri Lanka                        sri-lanka    79.10
## 43                            Somalia                          somalia    76.70
## 44                             Jordan                           jordan    75.97
## 45                               Togo                             togo    75.70
## 46                       South Africa                     south-africa    75.42
## 47                              Yemen                            yemen    74.50
## 48   Saint Vincent and the Grenadines saint-vincent-and-the-grenadines    73.80
## 49                           Slovenia                         slovenia    73.60
## 50                             Israel                           israel    72.60
## 51                              Ghana                            ghana    71.80
## 52                             Zambia                           zambia    71.41
## 53                        Saint Lucia                      saint-lucia    70.70
## 54                           Colombia                         colombia    70.49
## 55                            Grenada                          grenada    70.40
## 56                            Tunisia                          tunisia    70.30
## 57                           Suriname                         suriname    69.30
## 58                           Mongolia                         mongolia    67.57
## 59                         Montenegro                       montenegro    67.20
## 60                           Pakistan                         pakistan    67.00
## 61                        El Salvador                      el-salvador    65.55
## 62                            Morocco                          morocco    65.10
## 63                             Angola                           angola    65.00
## 64                            Ireland                          ireland    64.23
## 65                            Germany                          germany    63.90
## 66                       Sierra Leone                     sierra-leone    63.90
## 67                           Maldives                         maldives    63.90
## 68                               Laos                             laos    63.60
## 69                         Seychelles                       seychelles    63.60
## 70                           Malaysia                         malaysia    63.26
## 71              Saint Kitts and Nevis            saint-kitts-and-nevis    62.90
## 72                              Gabon                            gabon    62.70
## 73                        South Sudan                      south-sudan    62.70
## 74                             Serbia                           serbia    62.50
## 75                              Nauru                            nauru    62.00
## 76                             Canada                           canada    61.42
## 77                            Finland                          finland    61.30
## 78                            Uruguay                          uruguay    60.28
## 79                            Armenia                          armenia    60.08
## 80                            Ukraine                          ukraine    58.72
## 81                           Thailand                         thailand    58.56
## 82                            Vietnam                          vietnam    58.50
## 83                          Australia                        australia    57.97
## 84                          Mauritius                        mauritius    57.96
## 85                          Argentina                        argentina    57.60
## 86                        Netherlands                      netherlands    56.50
## 87                         Kyrgyzstan                       kyrgyzstan    56.36
## 88                       Burkina Faso                     burkina-faso    55.74
## 89                            Romania                          romania    55.57
## 90                              Benin                            benin    54.60
## 91                        New Zealand                      new-zealand    54.27
## 92                              Kenya                            kenya    54.20
## 93                      Guinea-Bissau                    guinea-bissau    53.90
## 94                              Qatar                            qatar    53.80
## 95                     Virgin Islands                   virgin-islands    53.30
## 96           Central African Republic         central-african-republic    52.90
## 97                               Chad                             chad    52.50
## 98                             Guyana                           guyana    52.20
## 99                              Tonga                            tonga    51.80
## 100                           Burundi                          burundi    51.70
## 101                       Puerto Rico                      puerto-rico    51.60
## 102                            Uganda                           uganda    51.30
## 103                             Malta                            malta    50.70
## 104                            Poland                           poland    50.60
## 105                        Tajikistan                       tajikistan    50.40
## 106                             Samoa                            samoa    49.10
## 107                           Bolivia                          bolivia    49.00
## 108                      Korea, South                      korea-south    48.96
## 109                              Fiji                             fiji    48.90
## 110                        Costa Rica                       costa-rica    48.90
## 111                  Papua New Guinea                 papua-new-guinea    48.68
## 112                         Lithuania                        lithuania    48.63
## 113                           Vanuatu                          vanuatu    48.40
## 114                           Senegal                          senegal    48.30
## 115                              Cuba                             cuba    47.70
## 116                             China                            china    47.00
## 117                     Cote d'Ivoire                     cote-divoire    47.00
## 118                              Oman                             oman    46.90
## 119                             India                            india    46.52
## 120                           Ecuador                          ecuador    45.40
## 121                             Niger                            niger    45.30
## 122                            Malawi                           malawi    44.89
## 123                            Mexico                           mexico    44.89
## 124                         Indonesia                        indonesia    44.40
## 125                           Georgia                          georgia    43.32
## 126                           Bermuda                          bermuda    43.00
## 127            Bosnia and Herzegovina           bosnia-and-herzegovina    41.85
## 128               Trinidad and Tobago              trinidad-and-tobago    41.80
## 129                  Marshall Islands                 marshall-islands    41.73
## 130                           Andorra                          andorra    41.00
## 131                            Rwanda                           rwanda    40.50
## 132                            Sweden                           sweden    40.48
## 133                             Nepal                            nepal    39.92
## 134                       Philippines                      philippines    39.90
## 135                          Honduras                         honduras    39.50
## 136                              Iran                             iran    39.50
## 137                   North Macedonia                  north-macedonia    39.30
## 138                         Venezuela                        venezuela    38.90
## 139                            Guinea                           guinea    37.90
## 140                            Panama                           panama    37.80
## 141                 Equatorial Guinea                equatorial-guinea    37.40
## 142                Dominican Republic               dominican-republic    37.20
## 143                            Tuvalu                           tuvalu    37.00
## 144                          Tanzania                         tanzania    37.00
## 145                          Cameroon                         cameroon    36.90
## 146                            Norway                           norway    36.50
## 147                            Latvia                           latvia    36.30
## 148                        Madagascar                       madagascar    36.00
## 149                            Taiwan                           taiwan    35.70
## 150                              Peru                             peru    35.66
## 151                              Mali                             mali    35.40
## 152                           Denmark                          denmark    35.30
## 153                  Turkey (Turkiye)                   turkey-turkiye    35.25
## 154                     Faroe Islands                    faroe-islands    35.00
## 155                           Czechia                          czechia    34.70
## 156                           Moldova                          moldova    34.52
## 157                           Liberia                          liberia    34.40
## 158                             Burma                            burma    33.60
## 159                         Nicaragua                        nicaragua    33.30
## 160                           Belarus                          belarus    33.24
## 161                           Curacao                          curacao    33.20
## 162                        Bangladesh                       bangladesh    33.10
## 163                          Bulgaria                         bulgaria    32.82
## 164                           Comoros                          comoros    32.40
## 165                          Djibouti                         djibouti    31.80
## 166                         Guatemala                        guatemala    31.56
## 167                          Ethiopia                         ethiopia    31.45
## 168                             Haiti                            haiti    31.10
## 169                          Cambodia                         cambodia    30.40
## 170                      Turkmenistan                     turkmenistan    28.80
## 171                          Eswatini                         eswatini    28.40
## 172                           Algeria                          algeria    27.50
## 173                              Iraq                             iraq    27.44
## 174                          Kiribati                         kiribati    26.30
## 175   Micronesia, Federated States of   micronesia-federated-states-of    25.40
## 176                         West Bank                        west-bank    24.40
## 177                        Uzbekistan                       uzbekistan    24.30
## 178                           Estonia                          estonia    23.67
## 179                             Chile                            chile    23.60
## 180                        Luxembourg                       luxembourg    23.00
## 181                        Kazakhstan                       kazakhstan    22.41
## 182                              Guam                             guam    22.10
## 183                           Nigeria                          nigeria    21.80
## 184                            Kosovo                           kosovo    21.20
## 185                            Russia                           russia    20.94
## 186                            Kuwait                           kuwait    20.60
## 187                          Anguilla                         anguilla    20.10
## 188                       Switzerland                      switzerland    19.99
## 189              United Arab Emirates             united-arab-emirates    19.70
## 190                          Botswana                         botswana    19.62
## 191                          Paraguay                         paraguay    19.50
## 192 Congo, Democratic Republic of the congo-democratic-republic-of-the    18.10
## 193                      Saudi Arabia                     saudi-arabia    17.20
## 194                        Azerbaijan                       azerbaijan    16.82
## 195                         Greenland                        greenland    13.00
## 196                    American Samoa                   american-samoa    12.20
## 197                   Solomon Islands                  solomon-islands    11.46
## 198                         Gibraltar                        gibraltar     7.50
## 199          Northern Mariana Islands         northern-mariana-islands     7.10
## 200                       Afghanistan                      afghanistan     7.00
## 201                     New Caledonia                    new-caledonia     6.50
## 202                 Wallis and Futuna                wallis-and-futuna     5.60
## 203                             Libya                            libya     4.70
## 204                           Namibia                          namibia     4.64
## 205                       Timor-Leste                      timor-leste     3.80
## 206                           Lesotho                          lesotho     2.97
## 207                            Brunei                           brunei     2.80
## 208                         Hong Kong                        hong-kong     0.10
## 209 Falkland Islands (Islas Malvinas)  falkland-islands-islas-malvinas     0.00
## 210                             Macau                            macau     0.00
##     date_of_information ranking                            region
## 1                  2021       1                            Europe
## 2                  2021       2           East and Southeast Asia
## 3                  2021       3                            Europe
## 4                  2021       4           East and Southeast Asia
## 5                  2017       5                       Middle East
## 6                  2016       6 Central America and the Caribbean
## 7                  2021       7                            Europe
## 8                  2017       8                            Europe
## 9                  2017       9                            Africa
## 10                 2017      10                            Africa
## 11                 2017      11                            Africa
## 12                 2017      12                            Europe
## 13                 2017      13                            Africa
## 14                 2021      14                            Europe
## 15                 2022      15                     North America
## 16                 2020      16                        South Asia
## 17                 2021      17                            Europe
## 18                 2020      18 Central America and the Caribbean
## 19                 2017      19                            Africa
## 20                 2017      20 Central America and the Caribbean
## 21                 2017      21                            Europe
## 22                 2017      22                            Africa
## 23                 2021      23                            Europe
## 24                 2017      24                       Middle East
## 25                 2021      25                            Europe
## 26                 2021      26                            Europe
## 27                 2017      27                       Middle East
## 28                 2022      28                            Europe
## 29                 2017      29                            Africa
## 30                 2017      30                            Africa
## 31                 2021      31                            Europe
## 32                 2017      32 Central America and the Caribbean
## 33                 2017      33 Central America and the Caribbean
## 34                 2019      34             Australia and Oceania
## 35                 2021      35                            Africa
## 36                 2022      36 Central America and the Caribbean
## 37                 2017      37 Central America and the Caribbean
## 38                 2021      38                            Europe
## 39                 2017      39                            Africa
## 40                 2022      40                     South America
## 41                 2021      41                            Europe
## 42                 2017      42                        South Asia
## 43                 2017      43                            Africa
## 44                 2020      44                       Middle East
## 45                 2017      45                            Africa
## 46                 2021      46                            Africa
## 47                 2017      47                       Middle East
## 48                 2017      48 Central America and the Caribbean
## 49                 2017      49                            Europe
## 50                 2020      50                       Middle East
## 51                 2017      51                            Africa
## 52                 2021      52                            Africa
## 53                 2017      53 Central America and the Caribbean
## 54                 2022      54                     South America
## 55                 2017      55 Central America and the Caribbean
## 56                 2017      56                            Africa
## 57                 2017      57                     South America
## 58                 2021      58           East and Southeast Asia
## 59                 2017      59                            Europe
## 60                 2017      60                        South Asia
## 61                 2021      61 Central America and the Caribbean
## 62                 2017      62                            Africa
## 63                 2017      63                            Africa
## 64                 2021      64                            Europe
## 65                 2017      65                            Europe
## 66                 2017      66                            Africa
## 67                 2017      67                        South Asia
## 68                 2017      68           East and Southeast Asia
## 69                 2017      69                            Africa
## 70                 2021      70           East and Southeast Asia
## 71                 2017      71 Central America and the Caribbean
## 72                 2017      72                            Africa
## 73                 2017      73                            Africa
## 74                 2017      74                            Europe
## 75                 2017      75             Australia and Oceania
## 76                 2022      76                     North America
## 77                 2017      77                            Europe
## 78                 2020      78                     South America
## 79                 2021      79                       Middle East
## 80                 2020      80                            Europe
## 81                 2021      81           East and Southeast Asia
## 82                 2017      82           East and Southeast Asia
## 83                 2022      83             Australia and Oceania
## 84                 2019      84                            Africa
## 85                 2017      85                     South America
## 86                 2017      86                            Europe
## 87                 2021      87                      Central Asia
## 88                 2021      88                            Africa
## 89                 2021      89                            Europe
## 90                 2017      90                            Africa
## 91                 2022      91             Australia and Oceania
## 92                 2017      92                            Africa
## 93                 2017      93                            Africa
## 94                 2017      94                       Middle East
## 95                 2016      95 Central America and the Caribbean
## 96                 2017      96                            Africa
## 97                 2017      97                            Africa
## 98                 2017      98                     South America
## 99                 2016      99             Australia and Oceania
## 100                2017     100                            Africa
## 101                2017     101 Central America and the Caribbean
## 102                2021     102                            Africa
## 103                2017     103                            Europe
## 104                2017     104                            Europe
## 105                2017     105                      Central Asia
## 106                2017     106             Australia and Oceania
## 107                2017     107                     South America
## 108                2021     108           East and Southeast Asia
## 109                2017     109             Australia and Oceania
## 110                2017     110 Central America and the Caribbean
## 111                2020     111           East and Southeast Asia
## 112                2021     112                            Europe
## 113                2017     113             Australia and Oceania
## 114                2017     114                            Africa
## 115                2017     115 Central America and the Caribbean
## 116                2017     116           East and Southeast Asia
## 117                2017     117                            Africa
## 118                2017     118                       Middle East
## 119                2018     119                        South Asia
## 120                2017     120                     South America
## 121                2017     121                            Africa
## 122                2019     122                            Africa
## 123                2021     123                     North America
## 124                2021     124           East and Southeast Asia
## 125                2022     125                       Middle East
## 126                1415     126                     North America
## 127                2022     127                            Europe
## 128                2017     128 Central America and the Caribbean
## 129                2019     129             Australia and Oceania
## 130                2014     130                            Europe
## 131                2017     131                            Africa
## 132                2021     132                            Europe
## 133                2021     133                        South Asia
## 134                2017     134           East and Southeast Asia
## 135                2017     135 Central America and the Caribbean
## 136                2017     136                       Middle East
## 137                2017     137                            Europe
## 138                2017     138                     South America
## 139                2017     139                            Africa
## 140                2017     140 Central America and the Caribbean
## 141                2017     141                            Africa
## 142                2017     142 Central America and the Caribbean
## 143                2017     143             Australia and Oceania
## 144                2017     144                            Africa
## 145                2017     145                            Africa
## 146                2017     146                            Europe
## 147                2017     147                            Europe
## 148                2017     148                            Africa
## 149                2017     149           East and Southeast Asia
## 150                2021     150                     South America
## 151                2017     151                            Africa
## 152                2017     152                            Europe
## 153                2022     153                       Middle East
## 154                2014     154                            Europe
## 155                2017     155                            Europe
## 156                2022     156                            Europe
## 157                2017     157                            Africa
## 158                2017     158           East and Southeast Asia
## 159                2017     159 Central America and the Caribbean
## 160                2019     160                            Europe
## 161                2012     161 Central America and the Caribbean
## 162                2017     162                        South Asia
## 163                2021     163                            Europe
## 164                2017     164                            Africa
## 165                2017     165                            Africa
## 166                2020     166 Central America and the Caribbean
## 167                2019     167                            Africa
## 168                2017     168 Central America and the Caribbean
## 169                2017     169           East and Southeast Asia
## 170                2017     170                      Central Asia
## 171                2017     171                            Africa
## 172                2017     172                            Africa
## 173                2018     173                       Middle East
## 174                2017     174             Australia and Oceania
## 175                2020     175             Australia and Oceania
## 176                2014     176                       Middle East
## 177                2017     177                      Central Asia
## 178                2021     178                            Europe
## 179                2017     179                     South America
## 180                2017     180                            Europe
## 181                2021     181                      Central Asia
## 182                2016     182             Australia and Oceania
## 183                2017     183                            Africa
## 184                2017     184                            Europe
## 185                2021     185                      Central Asia
## 186                2017     186                       Middle East
## 187                2015     187 Central America and the Caribbean
## 188                2021     188                            Europe
## 189                2017     189                       Middle East
## 190                2020     190                            Africa
## 191                2017     191                     South America
## 192                2017     192                            Africa
## 193                2017     193                       Middle East
## 194                2021     194                       Middle East
## 195                2015     195                     North America
## 196                2016     196             Australia and Oceania
## 197                2020     197             Australia and Oceania
## 198                2008     198                            Europe
## 199                2017     199             Australia and Oceania
## 200                2017     200                        South Asia
## 201                2015     201             Australia and Oceania
## 202                2004     202             Australia and Oceania
## 203                2017     203                            Africa
## 204                2019     204                            Africa
## 205                2017     205           East and Southeast Asia
## 206                2020     206                            Africa
## 207                2017     207           East and Southeast Asia
## 208                2017     208           East and Southeast Asia
## 209                2015     209                     South America
## 210                2017     210           East and Southeast Asia
data41 <- data4[, c('% of GDP', 'region')]

head(data41)
##   % of GDP                            region
## 1   237.35                            Europe
## 2   216.36           East and Southeast Asia
## 3   185.35                            Europe
## 4   153.80           East and Southeast Asia
## 5   146.80                       Middle East
## 6   146.61 Central America and the Caribbean
library(rio)
data5= import("Refined petroleum products - production.csv")
data5
##                                              name
## 1                                   United States
## 2                                           China
## 3                                          Russia
## 4                                           India
## 5                                           Japan
## 6                                    Korea, South
## 7                                          Brazil
## 8                                    Saudi Arabia
## 9                                         Germany
## 10                                         Canada
## 11                                           Iran
## 12                                          Italy
## 13                                          Spain
## 14                                       Thailand
## 15                                         France
## 16                                 United Kingdom
## 17                                    Netherlands
## 18                                      Indonesia
## 19                           United Arab Emirates
## 20                                      Venezuela
## 21                                         Taiwan
## 22                                         Kuwait
## 23                                         Mexico
## 24                                      Singapore
## 25                                        Belgium
## 26                                      Argentina
## 27                               Turkey (Turkiye)
## 28                                         Greece
## 29                                        Algeria
## 30                                         Poland
## 31                                          Egypt
## 32                                       Malaysia
## 33                                   South Africa
## 34                                        Belarus
## 35                                      Australia
## 36                                         Sweden
## 37                                           Iraq
## 38                                         Norway
## 39                                       Portugal
## 40                                        Finland
## 41                                       Colombia
## 42                                         Israel
## 43                                       Pakistan
## 44                                     Kazakhstan
## 45                                        Bahrain
## 46                                          Qatar
## 47                                        Romania
## 48                                           Oman
## 49                                          Chile
## 50                                    Philippines
## 51                                      Lithuania
## 52                                   Turkmenistan
## 53                                        Curacao
## 54                                        Austria
## 55                                        Denmark
## 56                                        Czechia
## 57                                           Peru
## 58                                        Vietnam
## 59                                        Hungary
## 60                                       Bulgaria
## 61                                     Azerbaijan
## 62                                        Ecuador
## 63                            Trinidad and Tobago
## 64                                       Slovakia
## 65                                    New Zealand
## 66                                          Syria
## 67                                           Cuba
## 68                                          Sudan
## 69                                          Libya
## 70                                        Croatia
## 71                                         Serbia
## 72                                  Cote d'Ivoire
## 73                                         Jordan
## 74                                        Morocco
## 75                                        Bolivia
## 76                                        Ireland
## 77                                        Ukraine
## 78                                     Uzbekistan
## 79                                    Switzerland
## 80                                         Angola
## 81                                        Uruguay
## 82                                       Cameroon
## 83                                        Nigeria
## 84                                      Sri Lanka
## 85                                        Tunisia
## 86                                     Bangladesh
## 87                                        Jamaica
## 88                               Papua New Guinea
## 89                                          Yemen
## 90                                        Senegal
## 91                                          Gabon
## 92                             Dominican Republic
## 93                         Congo, Republic of the
## 94                                          Niger
## 95                                      Nicaragua
## 96                                          Kenya
## 97                                          Burma
## 98                                         Zambia
## 99                                   Korea, North
## 100                                        Brunei
## 101                                      Suriname
## 102                                    Kyrgyzstan
## 103                                       Albania
## 104                                         Ghana
## 105                                     Guatemala
## 106                                       Georgia
## 107                                       Moldova
## 108                                    Tajikistan
## 109                                        Belize
## 110                                 New Caledonia
## 111                                          Laos
## 112                                  Sint Maarten
## 113                                        Panama
## 114                                         Tonga
## 115                                       Andorra
## 116                                    Madagascar
## 117                                       Bermuda
## 118                                   Timor-Leste
## 119                                         Nauru
## 120                                       Iceland
## 121                                       Grenada
## 122 Saint Helena, Ascension, and Tristan da Cunha
## 123                                         Samoa
## 124                         Sao Tome and Principe
## 125                                     Gibraltar
## 126                                  Sierra Leone
## 127             Congo, Democratic Republic of the
## 128                             Equatorial Guinea
## 129                                    Luxembourg
## 130                                   Afghanistan
## 131                                         Macau
## 132                                  Cook Islands
## 133                                        Cyprus
## 134                              Marshall Islands
## 135                                        Tuvalu
## 136                                          Chad
## 137                                       Somalia
## 138                                      Kiribati
## 139                                       Liberia
## 140                                       Comoros
## 141                                    Montserrat
## 142                                      Ethiopia
## 143                                         Malta
## 144                                        Rwanda
## 145                                     West Bank
## 146                                        Guinea
## 147             Falkland Islands (Islas Malvinas)
## 148              Saint Vincent and the Grenadines
## 149                                          Togo
## 150                                Cayman Islands
## 151                                   Puerto Rico
## 152                     Saint Pierre and Miquelon
## 153                                         Haiti
## 154                                   Saint Lucia
## 155                                     Mauritius
## 156                                         Benin
## 157                                      Zimbabwe
## 158                                     Hong Kong
## 159                                      Cambodia
## 160                                  Burkina Faso
## 161                        British Virgin Islands
## 162                                       Lesotho
## 163                               North Macedonia
## 164                                        Kosovo
## 165                                        Latvia
## 166                                         Aruba
## 167                                      Dominica
## 168                                      Slovenia
## 169                                     Greenland
## 170                                   El Salvador
## 171                                    Costa Rica
## 172                                 Faroe Islands
## 173                                        Uganda
## 174                         Saint Kitts and Nevis
## 175                                      Barbados
## 176                                    Cabo Verde
## 177                                 Guinea-Bissau
## 178                                      Botswana
## 179                                      Tanzania
## 180                           Antigua and Barbuda
## 181                                    Montenegro
## 182                                          Guam
## 183                                      Djibouti
## 184                                      Mongolia
## 185                                        Bhutan
## 186                                   South Sudan
## 187                                       Burundi
## 188                                        Malawi
## 189                                       Namibia
## 190               Micronesia, Federated States of
## 191                                          Fiji
## 192                                   Gambia, The
## 193                                       Armenia
## 194                                American Samoa
## 195                                          Mali
## 196                                          Niue
## 197                      Central African Republic
## 198                                    Mozambique
## 199                               Solomon Islands
## 200                                      Eswatini
## 201                                       Eritrea
## 202                      Turks and Caicos Islands
## 203                              French Polynesia
## 204                                        Guyana
## 205                                Virgin Islands
## 206                                      Maldives
## 207                                       Vanuatu
## 208                                      Honduras
## 209                                  Bahamas, The
## 210                                      Paraguay
## 211                                    Mauritania
## 212                                         Nepal
## 213                        Bosnia and Herzegovina
## 214                                       Lebanon
## 215                                    Seychelles
## 216                                       Estonia
##                                            slug    bbl/day date_of_information
## 1                                 united-states 20,300,000                2017
## 2                                         china 11,510,000                2015
## 3                                        russia  6,076,000                2015
## 4                                         india  4,897,000                2015
## 5                                         japan  3,467,000                2017
## 6                                   korea-south  3,302,000                2017
## 7                                        brazil  2,811,000                2015
## 8                                  saudi-arabia  2,476,000                2015
## 9                                       germany  2,158,000                2017
## 10                                       canada  2,009,000                2017
## 11                                         iran  1,764,000                2015
## 12                                        italy  1,607,000                2017
## 13                                        spain  1,361,000                2017
## 14                                     thailand  1,328,000                2015
## 15                                       france  1,311,000                2017
## 16                               united-kingdom  1,290,000                2017
## 17                                  netherlands  1,282,000                2017
## 18                                    indonesia    950,000                2015
## 19                         united-arab-emirates    943,500                2017
## 20                                    venezuela    926,300                2015
## 21                                       taiwan    924,000                2015
## 22                                       kuwait    915,800                2015
## 23                                       mexico    844,600                2017
## 24                                    singapore    755,000                2015
## 25                                      belgium    731,700                2017
## 26                                    argentina    669,800                2015
## 27                               turkey-turkiye    657,900                2017
## 28                                       greece    655,400                2017
## 29                                      algeria    627,900                2015
## 30                                       poland    554,200                2017
## 31                                        egypt    547,500                2015
## 32                                     malaysia    528,300                2015
## 33                                 south-africa    487,100                2015
## 34                                      belarus    477,200                2015
## 35                                    australia    462,500                2017
## 36                                       sweden    413,200                2017
## 37                                         iraq    398,000                2015
## 38                                       norway    371,600                2017
## 39                                     portugal    323,000                2017
## 40                                      finland    310,600                2017
## 41                                     colombia    303,600                2015
## 42                                       israel    294,300                2017
## 43                                     pakistan    291,200                2015
## 44                                   kazakhstan    290,700                2015
## 45                                      bahrain    274,500                2015
## 46                                        qatar    273,800                2015
## 47                                      romania    232,600                2015
## 48                                         oman    229,600                2015
## 49                                        chile    216,200                2017
## 50                                  philippines    215,500                2015
## 51                                    lithuania    196,500                2015
## 52                                 turkmenistan    191,100                2015
## 53                                      curacao    189,800                2015
## 54                                      austria    186,500                2017
## 55                                      denmark    183,900                2017
## 56                                      czechia    177,500                2017
## 57                                         peru    166,600                2015
## 58                                      vietnam    153,800                2015
## 59                                      hungary    152,400                2017
## 60                                     bulgaria    144,300                2015
## 61                                   azerbaijan    138,900                2015
## 62                                      ecuador    137,400                2015
## 63                          trinidad-and-tobago    134,700                2015
## 64                                     slovakia    131,300                2017
## 65                                  new-zealand    115,100                2017
## 66                                        syria    111,600                2015
## 67                                         cuba    104,100                2015
## 68                                        sudan     94,830                2015
## 69                                        libya     89,620                2015
## 70                                      croatia     74,620                2015
## 71                                       serbia     74,350                2015
## 72                                 cote-divoire     69,360                2017
## 73                                       jordan     67,240                2015
## 74                                      morocco     66,230                2017
## 75                                      bolivia     65,960                2015
## 76                                      ireland     64,970                2017
## 77                                      ukraine     63,670                2017
## 78                                   uzbekistan     61,740                2015
## 79                                  switzerland     61,550                2017
## 80                                       angola     53,480                2015
## 81                                      uruguay     42,220                2015
## 82                                     cameroon     39,080                2015
## 83                                      nigeria     35,010                2017
## 84                                    sri-lanka     34,210                2017
## 85                                      tunisia     27,770                2015
## 86                                   bangladesh     26,280                2015
## 87                                      jamaica     24,250                2017
## 88                             papua-new-guinea     22,170                2015
## 89                                        yemen     20,180                2015
## 90                                      senegal     17,590                2015
## 91                                        gabon     16,580                2017
## 92                           dominican-republic     16,060                2015
## 93                        congo-republic-of-the     15,760                2015
## 94                                        niger     15,280                2015
## 95                                    nicaragua     14,720                2015
## 96                                        kenya     13,960                2015
## 97                                        burma     13,330                2017
## 98                                       zambia     13,120                2015
## 99                                  korea-north     11,270                2015
## 100                                      brunei     10,310                2015
## 101                                    suriname      7,571                2015
## 102                                  kyrgyzstan      6,996                2015
## 103                                     albania      5,638                2015
## 104                                       ghana      2,073                2015
## 105                                   guatemala      1,162                2015
## 106                                     georgia        247                2017
## 107                                     moldova        232                2015
## 108                                  tajikistan        172                2015
## 109                                      belize         36                2015
## 110                               new-caledonia          0                2015
## 111                                        laos          0                2015
## 112                                sint-maarten          0                2015
## 113                                      panama          0                2015
## 114                                       tonga          0                2017
## 115                                     andorra          0                2016
## 116                                  madagascar          0                2015
## 117                                     bermuda          0                2017
## 118                                 timor-leste          0                2015
## 119                                       nauru          0                2015
## 120                                     iceland          0                2017
## 121                                     grenada          0                2015
## 122 saint-helena-ascension-and-tristan-da-cunha          0                2015
## 123                                       samoa          0                2017
## 124                       sao-tome-and-principe          0                2017
## 125                                   gibraltar          0                2017
## 126                                sierra-leone          0                2017
## 127            congo-democratic-republic-of-the          0                2017
## 128                           equatorial-guinea          0                2015
## 129                                  luxembourg          0                2017
## 130                                 afghanistan          0                2015
## 131                                       macau          0                2015
## 132                                cook-islands          0                2015
## 133                                      cyprus          0                2015
## 134                            marshall-islands          0                2015
## 135                                      tuvalu          0                2014
## 136                                        chad          0                2015
## 137                                     somalia          0                2015
## 138                                    kiribati          0                2015
## 139                                     liberia          0                2017
## 140                                     comoros          0                2015
## 141                                  montserrat          0                2015
## 142                                    ethiopia          0                2017
## 143                                       malta          0                2017
## 144                                      rwanda          0                2015
## 145                                   west-bank          0                2015
## 146                                      guinea          0                2017
## 147             falkland-islands-islas-malvinas          0                2017
## 148            saint-vincent-and-the-grenadines          0                2015
## 149                                        togo          0                2015
## 150                              cayman-islands          0                2017
## 151                                 puerto-rico          0                2015
## 152                   saint-pierre-and-miquelon          0                2015
## 153                                       haiti          0                2015
## 154                                 saint-lucia          0                2015
## 155                                   mauritius          0                2017
## 156                                       benin          0                2015
## 157                                    zimbabwe          0                2015
## 158                                   hong-kong          0                2015
## 159                                    cambodia          0                2015
## 160                                burkina-faso          0                2015
## 161                      british-virgin-islands          0                2015
## 162                                     lesotho          0                2015
## 163                             north-macedonia          0                2015
## 164                                      kosovo          0                2015
## 165                                      latvia          0                2017
## 166                                       aruba          0                2015
## 167                                    dominica          0                2015
## 168                                    slovenia          0                2017
## 169                                   greenland          0                2015
## 170                                 el-salvador          0                2015
## 171                                  costa-rica          0                2015
## 172                               faroe-islands          0                2015
## 173                                      uganda          0                2015
## 174                       saint-kitts-and-nevis          0                2015
## 175                                    barbados          0                2015
## 176                                  cabo-verde          0                2015
## 177                               guinea-bissau          0                2015
## 178                                    botswana          0                2015
## 179                                    tanzania          0                2015
## 180                         antigua-and-barbuda          0                2015
## 181                                  montenegro          0                2015
## 182                                        guam          0                2015
## 183                                    djibouti          0                2015
## 184                                    mongolia          0                2015
## 185                                      bhutan          0                2017
## 186                                 south-sudan          0                2017
## 187                                     burundi          0                2015
## 188                                      malawi          0                2015
## 189                                     namibia          0                2015
## 190              micronesia-federated-states-of          0                2014
## 191                                        fiji          0                2015
## 192                                  gambia-the          0                2017
## 193                                     armenia          0                2015
## 194                              american-samoa          0                2015
## 195                                        mali          0                2015
## 196                                        niue          0                2017
## 197                    central-african-republic          0                2017
## 198                                  mozambique          0                2015
## 199                             solomon-islands          0                2015
## 200                                    eswatini          0                2015
## 201                                     eritrea          0                2015
## 202                    turks-and-caicos-islands          0                2015
## 203                            french-polynesia          0                2015
## 204                                      guyana          0                2015
## 205                              virgin-islands          0                2015
## 206                                    maldives          0                2015
## 207                                     vanuatu          0                2015
## 208                                    honduras          0                2017
## 209                                 bahamas-the          0                2015
## 210                                    paraguay          0                2015
## 211                                  mauritania          0                2015
## 212                                       nepal          0                2015
## 213                      bosnia-and-herzegovina          0                2015
## 214                                     lebanon          0                2015
## 215                                  seychelles          0                2015
## 216                                     estonia          0                2017
##     ranking                            region
## 1         1                     North America
## 2         2           East and Southeast Asia
## 3         3                      Central Asia
## 4         4                        South Asia
## 5         5           East and Southeast Asia
## 6         6           East and Southeast Asia
## 7         7                     South America
## 8         8                       Middle East
## 9         9                            Europe
## 10       10                     North America
## 11       11                       Middle East
## 12       12                            Europe
## 13       13                            Europe
## 14       14           East and Southeast Asia
## 15       15                            Europe
## 16       16                            Europe
## 17       17                            Europe
## 18       18           East and Southeast Asia
## 19       19                       Middle East
## 20       20                     South America
## 21       21           East and Southeast Asia
## 22       22                       Middle East
## 23       23                     North America
## 24       24           East and Southeast Asia
## 25       25                            Europe
## 26       26                     South America
## 27       27                       Middle East
## 28       28                            Europe
## 29       29                            Africa
## 30       30                            Europe
## 31       31                            Africa
## 32       32           East and Southeast Asia
## 33       33                            Africa
## 34       34                            Europe
## 35       35             Australia and Oceania
## 36       36                            Europe
## 37       37                       Middle East
## 38       38                            Europe
## 39       39                            Europe
## 40       40                            Europe
## 41       41                     South America
## 42       42                       Middle East
## 43       43                        South Asia
## 44       44                      Central Asia
## 45       45                       Middle East
## 46       46                       Middle East
## 47       47                            Europe
## 48       48                       Middle East
## 49       49                     South America
## 50       50           East and Southeast Asia
## 51       51                            Europe
## 52       52                      Central Asia
## 53       53 Central America and the Caribbean
## 54       54                            Europe
## 55       55                            Europe
## 56       56                            Europe
## 57       57                     South America
## 58       58           East and Southeast Asia
## 59       59                            Europe
## 60       60                            Europe
## 61       61                       Middle East
## 62       62                     South America
## 63       63 Central America and the Caribbean
## 64       64                            Europe
## 65       65             Australia and Oceania
## 66       66                       Middle East
## 67       67 Central America and the Caribbean
## 68       68                            Africa
## 69       69                            Africa
## 70       70                            Europe
## 71       71                            Europe
## 72       72                            Africa
## 73       73                       Middle East
## 74       74                            Africa
## 75       75                     South America
## 76       76                            Europe
## 77       77                            Europe
## 78       78                      Central Asia
## 79       79                            Europe
## 80       80                            Africa
## 81       81                     South America
## 82       82                            Africa
## 83       83                            Africa
## 84       84                        South Asia
## 85       85                            Africa
## 86       86                        South Asia
## 87       87 Central America and the Caribbean
## 88       88           East and Southeast Asia
## 89       89                       Middle East
## 90       90                            Africa
## 91       91                            Africa
## 92       92 Central America and the Caribbean
## 93       93                            Africa
## 94       94                            Africa
## 95       95 Central America and the Caribbean
## 96       96                            Africa
## 97       97           East and Southeast Asia
## 98       98                            Africa
## 99       99           East and Southeast Asia
## 100     100           East and Southeast Asia
## 101     101                     South America
## 102     102                      Central Asia
## 103     103                            Europe
## 104     104                            Africa
## 105     105 Central America and the Caribbean
## 106     106                       Middle East
## 107     107                            Europe
## 108     108                      Central Asia
## 109     109 Central America and the Caribbean
## 110     110             Australia and Oceania
## 111     111           East and Southeast Asia
## 112     112 Central America and the Caribbean
## 113     113 Central America and the Caribbean
## 114     114             Australia and Oceania
## 115     115                            Europe
## 116     116                            Africa
## 117     117                     North America
## 118     118           East and Southeast Asia
## 119     119             Australia and Oceania
## 120     120                            Europe
## 121     121 Central America and the Caribbean
## 122     122                            Africa
## 123     123             Australia and Oceania
## 124     124                            Africa
## 125     125                            Europe
## 126     126                            Africa
## 127     127                            Africa
## 128     128                            Africa
## 129     129                            Europe
## 130     130                        South Asia
## 131     131           East and Southeast Asia
## 132     132             Australia and Oceania
## 133     133                            Europe
## 134     134             Australia and Oceania
## 135     135             Australia and Oceania
## 136     136                            Africa
## 137     137                            Africa
## 138     138             Australia and Oceania
## 139     139                            Africa
## 140     140                            Africa
## 141     141 Central America and the Caribbean
## 142     142                            Africa
## 143     143                            Europe
## 144     144                            Africa
## 145     145                       Middle East
## 146     146                            Africa
## 147     147                     South America
## 148     148 Central America and the Caribbean
## 149     149                            Africa
## 150     150 Central America and the Caribbean
## 151     151 Central America and the Caribbean
## 152     152                     North America
## 153     153 Central America and the Caribbean
## 154     154 Central America and the Caribbean
## 155     155                            Africa
## 156     156                            Africa
## 157     157                            Africa
## 158     158           East and Southeast Asia
## 159     159           East and Southeast Asia
## 160     160                            Africa
## 161     161 Central America and the Caribbean
## 162     162                            Africa
## 163     163                            Europe
## 164     164                            Europe
## 165     165                            Europe
## 166     166 Central America and the Caribbean
## 167     167 Central America and the Caribbean
## 168     168                            Europe
## 169     169                     North America
## 170     170 Central America and the Caribbean
## 171     171 Central America and the Caribbean
## 172     172                            Europe
## 173     173                            Africa
## 174     174 Central America and the Caribbean
## 175     175 Central America and the Caribbean
## 176     176                            Africa
## 177     177                            Africa
## 178     178                            Africa
## 179     179                            Africa
## 180     180 Central America and the Caribbean
## 181     181                            Europe
## 182     182             Australia and Oceania
## 183     183                            Africa
## 184     184           East and Southeast Asia
## 185     185                        South Asia
## 186     186                            Africa
## 187     187                            Africa
## 188     188                            Africa
## 189     189                            Africa
## 190     190             Australia and Oceania
## 191     191             Australia and Oceania
## 192     192                            Africa
## 193     193                       Middle East
## 194     194             Australia and Oceania
## 195     195                            Africa
## 196     196             Australia and Oceania
## 197     197                            Africa
## 198     198                            Africa
## 199     199             Australia and Oceania
## 200     200                            Africa
## 201     201                            Africa
## 202     202 Central America and the Caribbean
## 203     203             Australia and Oceania
## 204     204                     South America
## 205     205 Central America and the Caribbean
## 206     206                        South Asia
## 207     207             Australia and Oceania
## 208     208 Central America and the Caribbean
## 209     209 Central America and the Caribbean
## 210     210                     South America
## 211     211                            Africa
## 212     212                        South Asia
## 213     213                            Europe
## 214     214                       Middle East
## 215     215                            Africa
## 216     216                            Europe
data51 <- data5[, c('bbl/day', 'region')]

head(data51)
##      bbl/day                  region
## 1 20,300,000           North America
## 2 11,510,000 East and Southeast Asia
## 3  6,076,000            Central Asia
## 4  4,897,000              South Asia
## 5  3,467,000 East and Southeast Asia
## 6  3,302,000 East and Southeast Asia
library(rio)
data6= import("Inflation rate (consumer prices).csv")
data6
##                                  name                             slug
## 1                         South Sudan                      south-sudan
## 2                             Andorra                          andorra
## 3                            Dominica                         dominica
## 4                      American Samoa                   american-samoa
## 5                       Liechtenstein                    liechtenstein
## 6                       Faroe Islands                    faroe-islands
## 7                    French Polynesia                 french-polynesia
## 8                    Marshall Islands                 marshall-islands
## 9                           Greenland                        greenland
## 10           Northern Mariana Islands         northern-mariana-islands
## 11                             Taiwan                           taiwan
## 12                  Wallis and Futuna                wallis-and-futuna
## 13                        Timor-Leste                      timor-leste
## 14                            Comoros                          comoros
## 15                               Guam                             guam
## 16                     Virgin Islands                   virgin-islands
## 17                              Macau                            macau
## 18                         San Marino                       san-marino
## 19                         Montserrat                       montserrat
## 20                           Anguilla                         anguilla
## 21                              Benin                            benin
## 22  Falkland Islands (Islas Malvinas)  falkland-islands-islas-malvinas
## 23                      New Caledonia                    new-caledonia
## 24                            Somalia                          somalia
## 25          Saint Pierre and Miquelon        saint-pierre-and-miquelon
## 26                            Bolivia                          bolivia
## 27                        Puerto Rico                      puerto-rico
## 28                          Hong Kong                        hong-kong
## 29                            Bermuda                          bermuda
## 30                              China                            china
## 31             Bosnia and Herzegovina           bosnia-and-herzegovina
## 32                     Cayman Islands                   cayman-islands
## 33                           Kiribati                         kiribati
## 34                       Sint Maarten                     sint-maarten
## 35                        Afghanistan                      afghanistan
## 36                           Maldives                         maldives
## 37                       Saudi Arabia                     saudi-arabia
## 38                              Japan                            japan
## 39                          Gibraltar                        gibraltar
## 40                            Grenada                          grenada
## 41                           Eswatini                         eswatini
## 42                            Curacao                          curacao
## 43              Saint Kitts and Nevis            saint-kitts-and-nevis
## 44                               Oman                             oman
## 45                        Switzerland                      switzerland
## 46                             Panama                           panama
## 47             Congo, Republic of the            congo-republic-of-the
## 48                            Vietnam                          vietnam
## 49                           Malaysia                         malaysia
## 50                            Ecuador                          ecuador
## 51                            Bahrain                          bahrain
## 52                             Brunei                           brunei
## 53                          West Bank                        west-bank
## 54                         Gaza Strip                       gaza-strip
## 55                             Kuwait                           kuwait
## 56                            Tokelau                          tokelau
## 57           Turks and Caicos Islands         turks-and-caicos-islands
## 58                             Tuvalu                           tuvalu
## 59                           Barbados                         barbados
## 60                        Isle of Man                      isle-of-man
## 61             British Virgin Islands           british-virgin-islands
## 62                          Indonesia                        indonesia
## 63                              Gabon                            gabon
## 64                             Jordan                           jordan
## 65                              Niger                            niger
## 66                              Aruba                            aruba
## 67                           Tanzania                         tanzania
## 68                             Israel                           israel
## 69                              Libya                            libya
## 70                               Fiji                             fiji
## 71                  Equatorial Guinea                equatorial-guinea
## 72               United Arab Emirates             united-arab-emirates
## 73                               Iraq                             iraq
## 74                              Qatar                            qatar
## 75                       Korea, South                      korea-south
## 76                              Nauru                            nauru
## 77                           Djibouti                         djibouti
## 78                             France                           france
## 79                   Papua New Guinea                 papua-new-guinea
## 80                      Cote d'Ivoire                     cote-divoire
## 81                           Cambodia                         cambodia
## 82    Micronesia, Federated States of   micronesia-federated-states-of
## 83                               Cuba                             cuba
## 84                    Solomon Islands                  solomon-islands
## 85           Central African Republic         central-african-republic
## 86                       Bahamas, The                      bahamas-the
## 87                             Bhutan                           bhutan
## 88   Saint Vincent and the Grenadines saint-vincent-and-the-grenadines
## 89                             Norway                           norway
## 90                               Chad                             chad
## 91                        Philippines                      philippines
## 92                Trinidad and Tobago              trinidad-and-tobago
## 93                            Namibia                          namibia
## 94                           Thailand                         thailand
## 95                             Guyana                           guyana
## 96                          Singapore                        singapore
## 97                              Malta                            malta
## 98                           Cameroon                         cameroon
## 99                             Belize                           belize
## 100                        Luxembourg                       luxembourg
## 101                       Saint Lucia                      saint-lucia
## 102                         Australia                        australia
## 103                           Morocco                          morocco
## 104                            Russia                           russia
## 105                             India                            india
## 106                           Albania                          albania
## 107                            Canada                           canada
## 108                           Germany                          germany
## 109                         Guatemala                        guatemala
## 110                      South Africa                     south-africa
## 111                           Vanuatu                          vanuatu
## 112                           Finland                          finland
## 113                       New Zealand                      new-zealand
## 114                       El Salvador                      el-salvador
## 115                            Uganda                           uganda
## 116               Antigua and Barbuda              antigua-and-barbuda
## 117                             Nepal                            nepal
## 118                             Kenya                            kenya
## 119                        Tajikistan                       tajikistan
## 120                           Denmark                          denmark
## 121                        Bangladesh                       bangladesh
## 122                           Ireland                          ireland
## 123                          Portugal                         portugal
## 124                            Mexico                           mexico
## 125                    United Kingdom                   united-kingdom
## 126                        Cabo Verde                       cabo-verde
## 127                              Togo                             togo
## 128                     United States                    united-states
## 129                      Turkmenistan                     turkmenistan
## 130                        Kazakhstan                       kazakhstan
## 131                        Madagascar                       madagascar
## 132                             Italy                            italy
## 133                           Lesotho                          lesotho
## 134                        Costa Rica                       costa-rica
## 135                        Seychelles                       seychelles
## 136                           Tunisia                          tunisia
## 137                           Iceland                          iceland
## 138                              Peru                             peru
## 139                            Sweden                           sweden
## 140                             Spain                            spain
## 141                            Cyprus                           cyprus
## 142                           Austria                          austria
## 143                           Armenia                          armenia
## 144                Dominican Republic               dominican-republic
## 145                          Slovenia                         slovenia
## 146                             Burma                            burma
## 147                           Eritrea                          eritrea
## 148                          Honduras                         honduras
## 149                           Uruguay                          uruguay
## 150                           Algeria                          algeria
## 151                            Brazil                           brazil
## 152                     Guinea-Bissau                    guinea-bissau
## 153                        Mauritania                       mauritania
## 154                           Belgium                          belgium
## 155                              Mali                             mali
## 156                            Greece                           greece
## 157                           Senegal                          senegal
## 158                          Paraguay                         paraguay
## 159                       Netherlands                      netherlands
## 160                          Colombia                         colombia
## 161                        Mozambique                       mozambique
## 162                           Jamaica                          jamaica
## 163                         Nicaragua                        nicaragua
## 164                            Guinea                           guinea
## 165                         Mauritius                        mauritius
## 166                           Croatia                          croatia
## 167                             Samoa                            samoa
## 168                             Tonga                            tonga
## 169                            Zambia                           zambia
## 170                        Uzbekistan                       uzbekistan
## 171                       Gambia, The                       gambia-the
## 172                            Kosovo                           kosovo
## 173                             Chile                            chile
## 174                          Botswana                         botswana
## 175                           Georgia                          georgia
## 176                            Serbia                           serbia
## 177                             Palau                            palau
## 178                          Slovakia                         slovakia
## 179                        Montenegro                       montenegro
## 180                           Romania                          romania
## 181                        Azerbaijan                       azerbaijan
## 182                             Egypt                            egypt
## 183                        Kyrgyzstan                       kyrgyzstan
## 184                   North Macedonia                  north-macedonia
## 185                      Burkina Faso                     burkina-faso
## 186                            Poland                           poland
## 187                           Hungary                          hungary
## 188                           Czechia                          czechia
## 189                          Mongolia                         mongolia
## 190                           Belarus                          belarus
## 191                          Bulgaria                         bulgaria
## 192                            Latvia                           latvia
## 193                            Rwanda                           rwanda
## 194             Sao Tome and Principe            sao-tome-and-principe
## 195                           Burundi                          burundi
## 196                           Nigeria                          nigeria
## 197                           Estonia                          estonia
## 198                         Lithuania                        lithuania
## 199                          Pakistan                         pakistan
## 200                           Ukraine                          ukraine
## 201                            Malawi                           malawi
## 202                              Laos                             laos
## 203                           Liberia                          liberia
## 204                             Yemen                            yemen
## 205                         Argentina                        argentina
## 206                            Angola                           angola
## 207                      Sierra Leone                     sierra-leone
## 208                             Syria                            syria
## 209                           Moldova                          moldova
## 210                             Ghana                            ghana
## 211                          Ethiopia                         ethiopia
## 212                             Haiti                            haiti
## 213 Congo, Democratic Republic of the congo-democratic-republic-of-the
## 214                              Iran                             iran
## 215                         Sri Lanka                        sri-lanka
## 216                          Suriname                         suriname
## 217                  Turkey (Turkiye)                   turkey-turkiye
## 218                          Zimbabwe                         zimbabwe
## 219                             Sudan                            sudan
## 220                           Lebanon                          lebanon
## 221                         Venezuela                        venezuela
##             % date_of_information ranking                            region
## 1       -6.69                2022       1                            Africa
## 2        -0.9                2015       2                            Europe
## 3       -0.73                2020       3 Central America and the Caribbean
## 4        -0.5                2015       4             Australia and Oceania
## 5        -0.4                2016       5                            Europe
## 6        -0.3                2016       6                            Europe
## 7           0                2015       7             Australia and Oceania
## 8           0                2017       8             Australia and Oceania
## 9         0.3        January 2017       9                     North America
## 10        0.3                2016      10             Australia and Oceania
## 11        0.5                2019      11           East and Southeast Asia
## 12        0.9                2015      12             Australia and Oceania
## 13       0.96                2019      13           East and Southeast Asia
## 14          1                2017      14                            Africa
## 15          1                2017      15             Australia and Oceania
## 16          1                2016      16 Central America and the Caribbean
## 17       1.05                2022      17           East and Southeast Asia
## 18       1.05                2017      18                            Europe
## 19        1.2                2017      19 Central America and the Caribbean
## 20        1.3                2017      20 Central America and the Caribbean
## 21       1.35                2022      21                            Africa
## 22        1.4                2014      22                     South America
## 23        1.4                2017      23             Australia and Oceania
## 24        1.5                2017      24                            Africa
## 25        1.5                2015      25                     North America
## 26       1.75                2022      26                     South America
## 27        1.8                2017      27 Central America and the Caribbean
## 28       1.88                2022      28           East and Southeast Asia
## 29        1.9                2017      29                     North America
## 30       1.97                2022      30           East and Southeast Asia
## 31       1.98                2021      31                            Europe
## 32          2                2017      32 Central America and the Caribbean
## 33       2.05                2021      33             Australia and Oceania
## 34       2.19                2017      34 Central America and the Caribbean
## 35        2.3                2019      35                        South Asia
## 36       2.33                2022      36                        South Asia
## 37       2.47                2022      37                       Middle East
## 38        2.5                2022      38           East and Southeast Asia
## 39        2.5                2013      39                            Europe
## 40       2.56                2022      40 Central America and the Caribbean
## 41        2.6                2019      41                            Africa
## 42       2.62                2019      42 Central America and the Caribbean
## 43       2.67                2022      43 Central America and the Caribbean
## 44       2.81                2022      44                       Middle East
## 45       2.84                2022      45                            Europe
## 46       2.86                2022      46 Central America and the Caribbean
## 47       3.04                2022      47                            Africa
## 48       3.16                2022      48           East and Southeast Asia
## 49       3.38                2022      49           East and Southeast Asia
## 50       3.47                2022      50                     South America
## 51       3.63                2022      51                       Middle East
## 52       3.68                2022      52           East and Southeast Asia
## 53       3.74                2022      53                       Middle East
## 54       3.74                2022      54                       Middle East
## 55       3.98                2022      55                       Middle East
## 56          4                2020      56             Australia and Oceania
## 57          4                2017      57 Central America and the Caribbean
## 58        4.1                2017      58             Australia and Oceania
## 59        4.1                2019      59 Central America and the Caribbean
## 60        4.1                2017      60                            Europe
## 61        4.2                2022      61 Central America and the Caribbean
## 62       4.21                2022      62           East and Southeast Asia
## 63       4.23                2022      63                            Africa
## 64       4.23                2022      64                       Middle East
## 65       4.23                2022      65                            Africa
## 66       4.26                2019      66 Central America and the Caribbean
## 67       4.35                2022      67                            Africa
## 68       4.39                2022      68                       Middle East
## 69       4.51                2022      69                            Africa
## 70       4.52                2022      70             Australia and Oceania
## 71       4.79                2022      71                            Africa
## 72       4.83                2022      72                       Middle East
## 73       4.99                2022      73                       Middle East
## 74          5                2022      74                       Middle East
## 75       5.09                2022      75           East and Southeast Asia
## 76        5.1                2017      76             Australia and Oceania
## 77       5.18                2022      77                            Africa
## 78       5.22                2022      78                            Europe
## 79       5.25                2022      79           East and Southeast Asia
## 80       5.28                2022      80                            Africa
## 81       5.34                2022      81           East and Southeast Asia
## 82       5.41                2022      82             Australia and Oceania
## 83        5.5                2017      83 Central America and the Caribbean
## 84       5.52                2022      84             Australia and Oceania
## 85       5.58                2022      85                            Africa
## 86       5.61                2022      86 Central America and the Caribbean
## 87       5.64                2022      87                        South Asia
## 88       5.66                2022      88 Central America and the Caribbean
## 89       5.76                2022      89                            Europe
## 90       5.79                2022      90                            Africa
## 91       5.82                2022      91           East and Southeast Asia
## 92       5.83                2022      92 Central America and the Caribbean
## 93       6.08                2022      93                            Africa
## 94       6.08                2022      94           East and Southeast Asia
## 95       6.12                2022      95                     South America
## 96       6.12                2022      96           East and Southeast Asia
## 97       6.15                2022      97                            Europe
## 98       6.25                2022      98                            Africa
## 99       6.28                2022      99 Central America and the Caribbean
## 100      6.34                2022     100                            Europe
## 101      6.38                2022     101 Central America and the Caribbean
## 102      6.59                2022     102             Australia and Oceania
## 103      6.66                2022     103                            Africa
## 104      6.69                2021     104                      Central Asia
## 105       6.7                2022     105                        South Asia
## 106      6.73                2022     106                            Europe
## 107       6.8                2022     107                     North America
## 108      6.87                2022     108                            Europe
## 109      6.89                2022     109 Central America and the Caribbean
## 110      7.04                2022     110                            Africa
## 111       7.1                2022     111             Australia and Oceania
## 112      7.12                2022     112                            Europe
## 113      7.17                2022     113             Australia and Oceania
## 114       7.2                2022     114 Central America and the Caribbean
## 115       7.2                2022     115                            Africa
## 116      7.53                2022     116 Central America and the Caribbean
## 117      7.65                2022     117                        South Asia
## 118      7.66                2022     118                            Africa
## 119       7.7                2019     119                      Central Asia
## 120       7.7                2022     120                            Europe
## 121       7.7                2022     121                        South Asia
## 122      7.81                2022     122                            Europe
## 123      7.83                2022     123                            Europe
## 124       7.9                2022     124                     North America
## 125      7.92                2022     125                            Europe
## 126      7.93                2022     126                            Africa
## 127      7.97                2022     127                            Africa
## 128         8                2022     128                     North America
## 129         8                2017     129                      Central Asia
## 130      8.04                2021     130                      Central Asia
## 131      8.16                2022     131                            Africa
## 132       8.2                2022     132                            Europe
## 133      8.27                2022     133                            Africa
## 134      8.27                2022     134 Central America and the Caribbean
## 135      8.28                2020     135                            Africa
## 136      8.31                2022     136                            Africa
## 137      8.31                2022     137                            Europe
## 138      8.33                2022     138                     South America
## 139      8.37                2022     139                            Europe
## 140      8.39                2022     140                            Europe
## 141       8.4                2022     141                            Europe
## 142      8.55                2022     142                            Europe
## 143      8.64                2022     143                       Middle East
## 144      8.81                2022     144 Central America and the Caribbean
## 145      8.83                2022     145                            Europe
## 146      8.83                2019     146           East and Southeast Asia
## 147         9                2017     147                            Africa
## 148      9.09                2022     148 Central America and the Caribbean
## 149       9.1                2022     149                     South America
## 150      9.27                2022     150                            Africa
## 151      9.28                2022     151                     South America
## 152      9.39                2022     152                            Africa
## 153      9.53                2022     153                            Africa
## 154       9.6                2022     154                            Europe
## 155      9.62                2022     155                            Africa
## 156      9.65                2022     156                            Europe
## 157       9.7                2022     157                            Africa
## 158      9.77                2022     158                     South America
## 159        10                2022     159                            Europe
## 160     10.18                2022     160                     South America
## 161     10.28                2022     161                            Africa
## 162     10.35                2022     162 Central America and the Caribbean
## 163     10.47                2022     163 Central America and the Caribbean
## 164     10.49                2022     164                            Africa
## 165     10.77                2022     165                            Africa
## 166     10.78                2022     166                            Europe
## 167     10.96                2022     167             Australia and Oceania
## 168     10.97                2022     168             Australia and Oceania
## 169     10.99                2022     169                            Africa
## 170     11.45                2022     170                      Central Asia
## 171     11.51                2022     171                            Africa
## 172     11.58                2022     172                            Europe
## 173     11.64                2022     173                     South America
## 174     11.67                2022     174                            Africa
## 175      11.9                2022     175                       Middle East
## 176     11.98                2022     176                            Europe
## 177     12.35                2022     177             Australia and Oceania
## 178     12.77                2022     178                            Europe
## 179     13.04                2022     179                            Europe
## 180      13.8                2022     180                            Europe
## 181     13.85                2022     181                       Middle East
## 182      13.9                2022     182                            Africa
## 183     13.92                2022     183                      Central Asia
## 184      14.2                2022     184                            Europe
## 185     14.29                2022     185                            Africa
## 186     14.43                2022     186                            Europe
## 187     14.61                2022     187                            Europe
## 188      15.1                2022     188                            Europe
## 189     15.15                2022     189           East and Southeast Asia
## 190     15.21                2022     190                            Europe
## 191     15.33                2022     191                            Europe
## 192     17.31                2022     192                            Europe
## 193     17.69                2022     193                            Africa
## 194     18.01                2022     194                            Africa
## 195      18.8                2022     195                            Africa
## 196     18.85                2022     196                            Africa
## 197      19.4                2022     197                            Europe
## 198     19.71                2022     198                            Europe
## 199     19.87                2022     199                        South Asia
## 200     20.18                2022     200                            Europe
## 201     20.95                2022     201                            Africa
## 202     22.96                2022     202           East and Southeast Asia
## 203     23.56                2018     203                            Africa
## 204      24.7                2017     204                       Middle East
## 205      25.7                2017     205                     South America
## 206     25.75                2021     206                            Africa
## 207     27.21                2022     207                            Africa
## 208      28.1                2017     208                       Middle East
## 209     28.74                2022     209                            Europe
## 210     31.26                2022     210                            Africa
## 211     33.89                2022     211                            Africa
## 212     33.98                2022     212 Central America and the Caribbean
## 213      41.5                2017     213                            Africa
## 214     43.49                2022     214                       Middle East
## 215     49.72                2022     215                        South Asia
## 216     52.45                2022     216                     South America
## 217     72.31                2022     217                       Middle East
## 218    104.71                2022     218                            Africa
## 219    138.81                2022     219                            Africa
## 220    171.21                2022     220                       Middle East
## 221 146,101.7                2019     221                     South America
data61 <- data6[, c('%', 'region')]

head(data61)
##       %                            region
## 1 -6.69                            Africa
## 2  -0.9                            Europe
## 3 -0.73 Central America and the Caribbean
## 4  -0.5             Australia and Oceania
## 5  -0.4                            Europe
## 6  -0.3                            Europe
library(rio)
data7= import("Energy consumption per capita.csv")
data7
##                                              name
## 1                                           Qatar
## 2                                       Singapore
## 3                                         Bahrain
## 4                            United Arab Emirates
## 5                                          Brunei
## 6                                          Canada
## 7                                          Kuwait
## 8                                          Norway
## 9                                    Turkmenistan
## 10                                     Luxembourg
## 11                                  United States
## 12                                   Saudi Arabia
## 13                                           Oman
## 14                                          Malta
## 15                                   Korea, South
## 16                                      Australia
## 17                                        Belgium
## 18                                         Russia
## 19                                    Netherlands
## 20                                        Finland
## 21                                         Sweden
## 22                                    New Zealand
## 23                                     Kazakhstan
## 24                                        Bermuda
## 25                                 Cayman Islands
## 26                                          Aruba
## 27                                      Hong Kong
## 28                                        Austria
## 29                                     Seychelles
## 30                                        Czechia
## 31                                        Germany
## 32                                         Taiwan
## 33                                           Guam
## 34                                         France
## 35                                          Japan
## 36                                           Iran
## 37                                   Bahamas, The
## 38                                    Switzerland
## 39                                       Slovenia
## 40                                         Cyprus
## 41                                        Ireland
## 42                                       Slovakia
## 43                                        Denmark
## 44                                       Malaysia
## 45                                          Spain
## 46                                 United Kingdom
## 47                                         Israel
## 48                                         Poland
## 49                                          Italy
## 50                                        Hungary
## 51                                         Greece
## 52                            Antigua and Barbuda
## 53                                          Libya
## 54                                          China
## 55                                       Bulgaria
## 56                                        Belarus
## 57                                       Portugal
## 58                                      Lithuania
## 59                                         Bhutan
## 60                                         Panama
## 61                                   South Africa
## 62                                         Serbia
## 63                                    Puerto Rico
## 64                                        Croatia
## 65                                 American Samoa
## 66                                         Latvia
## 67                                      Venezuela
## 68                                       Barbados
## 69                                       Mongolia
## 70                                        Ukraine
## 71                                       Suriname
## 72                                          Chile
## 73                                          Macau
## 74                         British Virgin Islands
## 75                                      Mauritius
## 76                               Turkey (Turkiye)
## 77                                      Argentina
## 78                                     Montenegro
## 79                                       Thailand
## 80                                        Estonia
## 81                                           Laos
## 82                          Saint Kitts and Nevis
## 83                         Bosnia and Herzegovina
## 84                                        Romania
## 85                                        Uruguay
## 86                                     Azerbaijan
## 87                                        Georgia
## 88                                           Iraq
## 89                                       Paraguay
## 90                                         Mexico
## 91                                        Algeria
## 92                                       Maldives
## 93                                         Brazil
## 94                                     Uzbekistan
## 95                              Equatorial Guinea
## 96                                North Macedonia
## 97                                        Lebanon
## 98                                        Armenia
## 99                                         Kosovo
## 100                                   Saint Lucia
## 101                                       Jamaica
## 102                                        Guyana
## 103                                    Costa Rica
## 104                                       Ecuador
## 105                                       Moldova
## 106                                         Egypt
## 107                                       Grenada
## 108                                        Jordan
## 109                            Dominican Republic
## 110                                       Albania
## 111                                      Dominica
## 112                                          Peru
## 113                                       Vietnam
## 114                                       Tunisia
## 115                                    Kyrgyzstan
## 116                                      Colombia
## 117                                      Botswana
## 118                                          Fiji
## 119                                          Cuba
## 120                                        Belize
## 121                                       Namibia
## 122                                     Indonesia
## 123              Saint Vincent and the Grenadines
## 124                                    Tajikistan
## 125                                         Samoa
## 126                                       Bolivia
## 127                                         Gabon
## 128                                    Cabo Verde
## 129                                       Morocco
## 130                                         Syria
## 131                                   El Salvador
## 132                                         India
## 133                                         Tonga
## 134                                      Honduras
## 135                                     Guatemala
## 136                                      Eswatini
## 137                                   Philippines
## 138                                     Sri Lanka
## 139                        Congo, Republic of the
## 140                                      Pakistan
## 141                                     Nicaragua
## 142                                      Cambodia
## 143                                    Gaza Strip
## 144                                     West Bank
## 145                                    Mauritania
## 146                                  Korea, North
## 147                                        Angola
## 148                         Sao Tome and Principe
## 149                                        Zambia
## 150                                      Zimbabwe
## 151                              Papua New Guinea
## 152                                         Ghana
## 153                                       Vanuatu
## 154                                         Burma
## 155                                    Bangladesh
## 156                                      Kiribati
## 157                                       Senegal
## 158                                      Djibouti
## 159                                         Benin
## 160                                       Nigeria
## 161                                 Cote d'Ivoire
## 162                                    Mozambique
## 163                                         Sudan
## 164                                       Lesotho
## 165                               Solomon Islands
## 166                                         Kenya
## 167                                      Cameroon
## 168                                   Timor-Leste
## 169                                         Yemen
## 170                                       Comoros
## 171                                         Nepal
## 172                                          Mali
## 173                                        Guinea
## 174                                          Togo
## 175                                         Haiti
## 176                                       Liberia
## 177                                   Gambia, The
## 178                                      Tanzania
## 179                                  Burkina Faso
## 180                                   Afghanistan
## 181                                      Ethiopia
## 182                                       Eritrea
## 183                                        Uganda
## 184                                 Guinea-Bissau
## 185                                   South Sudan
## 186                                    Madagascar
## 187                                        Malawi
## 188                                  Sierra Leone
## 189                                        Rwanda
## 190                                          Chad
## 191                                         Niger
## 192             Congo, Democratic Republic of the
## 193                      Central African Republic
## 194                                       Burundi
## 195                                       Somalia
## 196                      Northern Mariana Islands
## 197                                  Cook Islands
## 198                                    Montserrat
## 199                      Turks and Caicos Islands
## 200                                   Wake Island
## 201                                         Nauru
## 202                                 New Caledonia
## 203               Micronesia, Federated States of
## 204                              French Polynesia
## 205                     Saint Pierre and Miquelon
## 206                                    Antarctica
## 207 Saint Helena, Ascension, and Tristan da Cunha
## 208                                        Tuvalu
## 209                                     Gibraltar
## 210                                          Niue
## 211             Falkland Islands (Islas Malvinas)
## 212                                 Faroe Islands
##                                            slug  Btu/person date_of_information
## 1                                         qatar 723,582,000                2019
## 2                                     singapore 639,951,000                2019
## 3                                       bahrain 547,976,000                2019
## 4                          united-arab-emirates 471,788,000                2019
## 5                                        brunei 415,184,000                2019
## 6                                        canada 403,700,000                2019
## 7                                        kuwait 381,985,000                2019
## 8                                        norway 333,833,000                2019
## 9                                  turkmenistan 330,507,000                2019
## 10                                   luxembourg 310,068,000                2019
## 11                                united-states 304,414,000                2019
## 12                                 saudi-arabia 296,949,000                2019
## 13                                         oman 292,022,000                2019
## 14                                        malta 267,739,000                2019
## 15                                  korea-south 242,346,000                2019
## 16                                    australia 241,004,000                2019
## 17                                      belgium 234,216,000                2019
## 18                                       russia 227,898,000                2019
## 19                                  netherlands 219,606,000                2019
## 20                                      finland 216,571,000                2019
## 21                                       sweden 210,882,000                2019
## 22                                  new-zealand 186,804,000                2019
## 23                                   kazakhstan 180,726,000                2019
## 24                                      bermuda 176,312,000                2019
## 25                               cayman-islands 175,578,000                2019
## 26                                        aruba 174,629,000                2019
## 27                                    hong-kong 172,009,000                2019
## 28                                      austria 171,299,000                2019
## 29                                   seychelles 163,060,000                2019
## 30                                      czechia 161,972,000                2019
## 31                                      germany 161,174,000                2019
## 32                                       taiwan 160,669,000                2019
## 33                                         guam 152,767,000                2019
## 34                                       france 151,053,000                2019
## 35                                        japan 147,107,000                2019
## 36                                         iran 145,540,000                2019
## 37                                  bahamas-the 140,505,000                2019
## 38                                  switzerland 137,918,000                2019
## 39                                     slovenia 134,836,000                2019
## 40                                       cyprus 133,920,000                2019
## 41                                      ireland 133,674,000                2019
## 42                                     slovakia 129,665,000                2019
## 43                                      denmark 124,163,000                2019
## 44                                     malaysia 123,755,000                2019
## 45                                        spain 122,673,000                2019
## 46                               united-kingdom 119,894,000                2019
## 47                                       israel 113,273,000                2019
## 48                                       poland 112,831,000                2019
## 49                                        italy 112,606,000                2019
## 50                                      hungary 108,212,000                2019
## 51                                       greece 108,022,000                2019
## 52                          antigua-and-barbuda 107,154,000                2019
## 53                                        libya 107,118,000                2019
## 54                                        china 105,687,000                2019
## 55                                     bulgaria 103,924,000                2019
## 56                                      belarus 102,558,000                2019
## 57                                     portugal 101,734,000                2019
## 58                                    lithuania 101,651,000                2019
## 59                                       bhutan 100,135,000                2019
## 60                                       panama  98,946,000                2019
## 61                                 south-africa  98,474,000                2019
## 62                                       serbia  98,195,000                2019
## 63                                  puerto-rico  94,379,000                2019
## 64                                      croatia  89,733,000                2019
## 65                               american-samoa  88,796,000                2019
## 66                                       latvia  86,645,000                2019
## 67                                    venezuela  85,829,000                2019
## 68                                     barbados  83,723,000                2019
## 69                                     mongolia  83,045,000                2019
## 70                                      ukraine  82,571,000                2019
## 71                                     suriname  82,356,000                2019
## 72                                        chile  81,953,000                2019
## 73                                        macau  81,407,000                2019
## 74                       british-virgin-islands  80,136,000                2019
## 75                                    mauritius  79,448,000                2019
## 76                               turkey-turkiye  79,126,000                2019
## 77                                    argentina  79,083,000                2019
## 78                                   montenegro  77,286,000                2019
## 79                                     thailand  76,714,000                2019
## 80                                      estonia  76,329,000                2019
## 81                                         laos  73,187,000                2019
## 82                        saint-kitts-and-nevis  71,960,000                2019
## 83                       bosnia-and-herzegovina  71,815,000                2019
## 84                                      romania  71,736,000                2019
## 85                                      uruguay  66,909,000                2019
## 86                                   azerbaijan  64,416,000                2019
## 87                                      georgia  63,286,000                2019
## 88                                         iraq  63,174,000                2019
## 89                                     paraguay  62,775,000                2019
## 90                                       mexico  61,597,000                2019
## 91                                      algeria  61,433,000                2019
## 92                                     maldives  59,690,000                2019
## 93                                       brazil  59,444,000                2019
## 94                                   uzbekistan  57,709,000                2019
## 95                            equatorial-guinea  57,596,000                2019
## 96                              north-macedonia  53,572,000                2019
## 97                                      lebanon  53,528,000                2019
## 98                                      armenia  53,019,000                2019
## 99                                       kosovo  51,462,000                2019
## 100                                 saint-lucia  50,872,000                2019
## 101                                     jamaica  49,700,000                2019
## 102                                      guyana  48,608,000                2019
## 103                                  costa-rica  44,899,000                2019
## 104                                     ecuador  42,564,000                2019
## 105                                     moldova  40,398,000                2019
## 106                                       egypt  40,063,000                2019
## 107                                     grenada  39,799,000                2019
## 108                                      jordan  39,331,000                2019
## 109                          dominican-republic  39,016,000                2019
## 110                                     albania  38,442,000                2019
## 111                                    dominica  37,513,000                2019
## 112                                        peru  36,465,000                2019
## 113                                     vietnam  36,392,000                2019
## 114                                     tunisia  35,620,000                2019
## 115                                  kyrgyzstan  35,059,000                2019
## 116                                    colombia  34,703,000                2019
## 117                                    botswana  34,095,000                2019
## 118                                        fiji  32,901,000                2019
## 119                                        cuba  32,785,000                2019
## 120                                      belize  31,552,000                2019
## 121                                     namibia  29,811,000                2019
## 122                                   indonesia  29,680,000                2019
## 123            saint-vincent-and-the-grenadines  27,821,000                2019
## 124                                  tajikistan  27,651,000                2019
## 125                                       samoa  27,111,000                2019
## 126                                     bolivia  27,094,000                2019
## 127                                       gabon  26,786,000                2019
## 128                                  cabo-verde  26,539,000                2019
## 129                                     morocco  24,590,000                2019
## 130                                       syria  24,567,000                2019
## 131                                 el-salvador  24,124,000                2019
## 132                                       india  23,231,000                2019
## 133                                       tonga  22,841,000                2019
## 134                                    honduras  19,800,000                2019
## 135                                   guatemala  19,411,000                2019
## 136                                    eswatini  19,371,000                2019
## 137                                 philippines  19,261,000                2019
## 138                                   sri-lanka  17,268,000                2019
## 139                       congo-republic-of-the  16,156,000                2019
## 140                                    pakistan  15,859,000                2019
## 141                                   nicaragua  14,916,000                2019
## 142                                    cambodia  13,629,000                2019
## 143                                  gaza-strip  13,604,000                2019
## 144                                   west-bank  13,604,000                2019
## 145                                  mauritania  13,558,000                2019
## 146                                 korea-north  12,610,000                2019
## 147                                      angola  11,693,000                2019
## 148                       sao-tome-and-principe  11,636,000                2019
## 149                                      zambia  11,595,000                2019
## 150                                    zimbabwe  11,516,000                2019
## 151                            papua-new-guinea  11,316,000                2019
## 152                                       ghana  11,239,000                2019
## 153                                     vanuatu  10,878,000                2019
## 154                                       burma  10,679,000                2019
## 155                                  bangladesh   9,917,000                2019
## 156                                    kiribati   9,335,000                2019
## 157                                     senegal   9,221,000                2019
## 158                                    djibouti   8,869,000                2019
## 159                                       benin   8,468,000                2019
## 160                                     nigeria   8,466,000                2019
## 161                                cote-divoire   8,225,000                2019
## 162                                  mozambique   8,107,000                2019
## 163                                       sudan   8,047,000                2019
## 164                                     lesotho   7,823,000                2019
## 165                             solomon-islands   6,955,000                2019
## 166                                       kenya   6,310,000                2019
## 167                                    cameroon   6,187,000                2019
## 168                                 timor-leste   5,740,000                2019
## 169                                       yemen   5,453,000                2019
## 170                                     comoros   5,346,000                2019
## 171                                       nepal   5,219,000                2019
## 172                                        mali   4,396,000                2019
## 173                                      guinea   4,133,000                2019
## 174                                        togo   4,113,000                2019
## 175                                       haiti   3,970,000                2019
## 176                                     liberia   3,790,000                2019
## 177                                  gambia-the   3,547,000                2019
## 178                                    tanzania   3,334,000                2019
## 179                                burkina-faso   3,230,000                2019
## 180                                 afghanistan   3,227,000                2019
## 181                                    ethiopia   3,219,000                2019
## 182                                     eritrea   3,217,000                2019
## 183                                      uganda   2,943,000                2019
## 184                               guinea-bissau   2,460,000                2019
## 185                                 south-sudan   2,404,000                2019
## 186                                  madagascar   2,307,000                2019
## 187                                      malawi   1,809,000                2019
## 188                                sierra-leone   1,803,000                2019
## 189                                      rwanda   1,704,000                2019
## 190                                        chad   1,575,000                2019
## 191                                       niger   1,540,000                2019
## 192            congo-democratic-republic-of-the   1,371,000                2019
## 193                    central-african-republic   1,121,000                2019
## 194                                     burundi   1,087,000                2019
## 195                                     somalia     802,000                2019
## 196                    northern-mariana-islands           0                2019
## 197                                cook-islands           0                2019
## 198                                  montserrat           0                2019
## 199                    turks-and-caicos-islands           0                2019
## 200                                 wake-island           0                2019
## 201                                       nauru           0                2019
## 202                               new-caledonia           0                2019
## 203              micronesia-federated-states-of           0                2019
## 204                            french-polynesia           0                2019
## 205                   saint-pierre-and-miquelon           0                2019
## 206                                  antarctica           0                2019
## 207 saint-helena-ascension-and-tristan-da-cunha           0                2019
## 208                                      tuvalu           0                2019
## 209                                   gibraltar           0                2019
## 210                                        niue           0                2019
## 211             falkland-islands-islas-malvinas           0                2019
## 212                               faroe-islands           0                2019
##     ranking                            region
## 1         1                       Middle East
## 2         2           East and Southeast Asia
## 3         3                       Middle East
## 4         4                       Middle East
## 5         5           East and Southeast Asia
## 6         6                     North America
## 7         7                       Middle East
## 8         8                            Europe
## 9         9                      Central Asia
## 10       10                            Europe
## 11       11                     North America
## 12       12                       Middle East
## 13       13                       Middle East
## 14       14                            Europe
## 15       15           East and Southeast Asia
## 16       16             Australia and Oceania
## 17       17                            Europe
## 18       18                      Central Asia
## 19       19                            Europe
## 20       20                            Europe
## 21       21                            Europe
## 22       22             Australia and Oceania
## 23       23                      Central Asia
## 24       24                     North America
## 25       25 Central America and the Caribbean
## 26       26 Central America and the Caribbean
## 27       27           East and Southeast Asia
## 28       28                            Europe
## 29       29                            Africa
## 30       30                            Europe
## 31       31                            Europe
## 32       32           East and Southeast Asia
## 33       33             Australia and Oceania
## 34       34                            Europe
## 35       35           East and Southeast Asia
## 36       36                       Middle East
## 37       37 Central America and the Caribbean
## 38       38                            Europe
## 39       39                            Europe
## 40       40                            Europe
## 41       41                            Europe
## 42       42                            Europe
## 43       43                            Europe
## 44       44           East and Southeast Asia
## 45       45                            Europe
## 46       46                            Europe
## 47       47                       Middle East
## 48       48                            Europe
## 49       49                            Europe
## 50       50                            Europe
## 51       51                            Europe
## 52       52 Central America and the Caribbean
## 53       53                            Africa
## 54       54           East and Southeast Asia
## 55       55                            Europe
## 56       56                            Europe
## 57       57                            Europe
## 58       58                            Europe
## 59       59                        South Asia
## 60       60 Central America and the Caribbean
## 61       61                            Africa
## 62       62                            Europe
## 63       63 Central America and the Caribbean
## 64       64                            Europe
## 65       65             Australia and Oceania
## 66       66                            Europe
## 67       67                     South America
## 68       68 Central America and the Caribbean
## 69       69           East and Southeast Asia
## 70       70                            Europe
## 71       71                     South America
## 72       72                     South America
## 73       73           East and Southeast Asia
## 74       74 Central America and the Caribbean
## 75       75                            Africa
## 76       76                       Middle East
## 77       77                     South America
## 78       78                            Europe
## 79       79           East and Southeast Asia
## 80       80                            Europe
## 81       81           East and Southeast Asia
## 82       82 Central America and the Caribbean
## 83       83                            Europe
## 84       84                            Europe
## 85       85                     South America
## 86       86                       Middle East
## 87       87                       Middle East
## 88       88                       Middle East
## 89       89                     South America
## 90       90                     North America
## 91       91                            Africa
## 92       92                        South Asia
## 93       93                     South America
## 94       94                      Central Asia
## 95       95                            Africa
## 96       96                            Europe
## 97       97                       Middle East
## 98       98                       Middle East
## 99       99                            Europe
## 100     100 Central America and the Caribbean
## 101     101 Central America and the Caribbean
## 102     102                     South America
## 103     103 Central America and the Caribbean
## 104     104                     South America
## 105     105                            Europe
## 106     106                            Africa
## 107     107 Central America and the Caribbean
## 108     108                       Middle East
## 109     109 Central America and the Caribbean
## 110     110                            Europe
## 111     111 Central America and the Caribbean
## 112     112                     South America
## 113     113           East and Southeast Asia
## 114     114                            Africa
## 115     115                      Central Asia
## 116     116                     South America
## 117     117                            Africa
## 118     118             Australia and Oceania
## 119     119 Central America and the Caribbean
## 120     120 Central America and the Caribbean
## 121     121                            Africa
## 122     122           East and Southeast Asia
## 123     123 Central America and the Caribbean
## 124     124                      Central Asia
## 125     125             Australia and Oceania
## 126     126                     South America
## 127     127                            Africa
## 128     128                            Africa
## 129     129                            Africa
## 130     130                       Middle East
## 131     131 Central America and the Caribbean
## 132     132                        South Asia
## 133     133             Australia and Oceania
## 134     134 Central America and the Caribbean
## 135     135 Central America and the Caribbean
## 136     136                            Africa
## 137     137           East and Southeast Asia
## 138     138                        South Asia
## 139     139                            Africa
## 140     140                        South Asia
## 141     141 Central America and the Caribbean
## 142     142           East and Southeast Asia
## 143     143                       Middle East
## 144     144                       Middle East
## 145     145                            Africa
## 146     146           East and Southeast Asia
## 147     147                            Africa
## 148     148                            Africa
## 149     149                            Africa
## 150     150                            Africa
## 151     151           East and Southeast Asia
## 152     152                            Africa
## 153     153             Australia and Oceania
## 154     154           East and Southeast Asia
## 155     155                        South Asia
## 156     156             Australia and Oceania
## 157     157                            Africa
## 158     158                            Africa
## 159     159                            Africa
## 160     160                            Africa
## 161     161                            Africa
## 162     162                            Africa
## 163     163                            Africa
## 164     164                            Africa
## 165     165             Australia and Oceania
## 166     166                            Africa
## 167     167                            Africa
## 168     168           East and Southeast Asia
## 169     169                       Middle East
## 170     170                            Africa
## 171     171                        South Asia
## 172     172                            Africa
## 173     173                            Africa
## 174     174                            Africa
## 175     175 Central America and the Caribbean
## 176     176                            Africa
## 177     177                            Africa
## 178     178                            Africa
## 179     179                            Africa
## 180     180                        South Asia
## 181     181                            Africa
## 182     182                            Africa
## 183     183                            Africa
## 184     184                            Africa
## 185     185                            Africa
## 186     186                            Africa
## 187     187                            Africa
## 188     188                            Africa
## 189     189                            Africa
## 190     190                            Africa
## 191     191                            Africa
## 192     192                            Africa
## 193     193                            Africa
## 194     194                            Africa
## 195     195                            Africa
## 196     196             Australia and Oceania
## 197     197             Australia and Oceania
## 198     198 Central America and the Caribbean
## 199     199 Central America and the Caribbean
## 200     200             Australia and Oceania
## 201     201             Australia and Oceania
## 202     202             Australia and Oceania
## 203     203             Australia and Oceania
## 204     204             Australia and Oceania
## 205     205                     North America
## 206     206                        Antarctica
## 207     207                            Africa
## 208     208             Australia and Oceania
## 209     209                            Europe
## 210     210             Australia and Oceania
## 211     211                     South America
## 212     212                            Europe
data71 <- data7[, c('Btu/person', 'region')]

head(data71)
##    Btu/person                  region
## 1 723,582,000             Middle East
## 2 639,951,000 East and Southeast Asia
## 3 547,976,000             Middle East
## 4 471,788,000             Middle East
## 5 415,184,000 East and Southeast Asia
## 6 403,700,000           North America
library(rio)
data8= import("Electricity - installed generating capacity.csv")
data8
##                                              name
## 1                                           China
## 2                                   United States
## 3                                           India
## 4                                           Japan
## 5                                          Russia
## 6                                         Germany
## 7                                          Brazil
## 8                                          Canada
## 9                                          France
## 10                                   Korea, South
## 11                                          Italy
## 12                                          Spain
## 13                                 United Kingdom
## 14                               Turkey (Turkiye)
## 15                                         Mexico
## 16                                      Australia
## 17                                           Iran
## 18                                   Saudi Arabia
## 19                                      Indonesia
## 20                                        Vietnam
## 21                                   South Africa
## 22                                          Egypt
## 23                                         Taiwan
## 24                                        Ukraine
## 25                                       Thailand
## 26                                         Poland
## 27                                      Argentina
## 28                                         Sweden
## 29                                    Netherlands
## 30                                       Pakistan
## 31                                         Norway
## 32                           United Arab Emirates
## 33                                       Malaysia
## 34                                      Venezuela
## 35                                          Chile
## 36                                        Austria
## 37                                           Iraq
## 38                                    Philippines
## 39                                        Belgium
## 40                                     Kazakhstan
## 41                                    Switzerland
## 42                                        Czechia
## 43                                       Portugal
## 44                                        Algeria
## 45                                         Greece
## 46                                        Romania
## 47                                        Finland
## 48                                       Colombia
## 49                                         Kuwait
## 50                                         Israel
## 51                                     Bangladesh
## 52                                        Denmark
## 53                                     Uzbekistan
## 54                                           Peru
## 55                                        Morocco
## 56                                      Hong Kong
## 57                                      Singapore
## 58                                        Nigeria
## 59                                        Ireland
## 60                                        Belarus
## 61                                       Bulgaria
## 62                                        Hungary
## 63                                          Qatar
## 64                                          Libya
## 65                                          Syria
## 66                                    New Zealand
## 67                                        Ecuador
## 68                                           Laos
## 69                                         Serbia
## 70                                       Paraguay
## 71                                           Oman
## 72                                   Korea, North
## 73                                       Slovakia
## 74                                     Azerbaijan
## 75                                           Cuba
## 76                                         Angola
## 77                                          Burma
## 78                                     Tajikistan
## 79                                        Bahrain
## 80                                    Puerto Rico
## 81                                        Tunisia
## 82                             Dominican Republic
## 83                                         Jordan
## 84                                        Uruguay
## 85                                          Ghana
## 86                                   Turkmenistan
## 87                                      Guatemala
## 88                                        Croatia
## 89                                       Ethiopia
## 90                         Bosnia and Herzegovina
## 91                                     Kyrgyzstan
## 92                                        Georgia
## 93                                      Sri Lanka
## 94                                          Sudan
## 95                                         Panama
## 96                                       Slovenia
## 97                                       Honduras
## 98                                        Bolivia
## 99                                        Lebanon
## 100                                    Costa Rica
## 101                                       Armenia
## 102                                     Lithuania
## 103                                         Haiti
## 104                                         Kenya
## 105                                        Latvia
## 106                                        Zambia
## 107                                       Estonia
## 108                                       Iceland
## 109                                      Cambodia
## 110             Congo, Democratic Republic of the
## 111                                    Mozambique
## 112                                   El Salvador
## 113                                       Albania
## 114                                      Zimbabwe
## 115                                        Uganda
## 116                                        Bhutan
## 117                                 Cote d'Ivoire
## 118                           Trinidad and Tobago
## 119                               North Macedonia
## 120                                    Luxembourg
## 121                                        Cyprus
## 122                                     Nicaragua
## 123                                         Yemen
## 124                                      Cameroon
## 125                                      Tanzania
## 126                                      Mongolia
## 127                                        Kosovo
## 128                                         Nepal
## 129                                       Senegal
## 130                                        Brunei
## 131                                       Jamaica
## 132                              Papua New Guinea
## 133                                 New Caledonia
## 134                                    Montenegro
## 135                                        Guinea
## 136                                     Mauritius
## 137                                          Mali
## 138                                         Gabon
## 139                                         Malta
## 140                                   Afghanistan
## 141                                      Botswana
## 142                                    Mauritania
## 143                                       Namibia
## 144                        Congo, Republic of the
## 145                                        Malawi
## 146                                       Moldova
## 147                                    Madagascar
## 148                                  Bahamas, The
## 149                                      Maldives
## 150                                      Suriname
## 151                                         Macau
## 152                                         Benin
## 153                                          Guam
## 154                                          Fiji
## 155                                  Burkina Faso
## 156                                        Guyana
## 157                             Equatorial Guinea
## 158                                         Niger
## 159                                Virgin Islands
## 160                                      Barbados
## 161                                         Aruba
## 162                                      Eswatini
## 163                                   Timor-Leste
## 164                              French Polynesia
## 165                                        Rwanda
## 166                                       Eritrea
## 167                                     West Bank
## 168                                    Gaza Strip
## 169                                          Togo
## 170                                    Cabo Verde
## 171                                        Belize
## 172                                       Liberia
## 173                                     Greenland
## 174                                  Sierra Leone
## 175                                Cayman Islands
## 176                                       Bermuda
## 177                                    Seychelles
## 178                                   Gambia, The
## 179                                      Djibouti
## 180                                 Faroe Islands
## 181                                   South Sudan
## 182                           Antigua and Barbuda
## 183                                       Burundi
## 184                                   Saint Lucia
## 185                                       Somalia
## 186                                          Chad
## 187                      Turks and Caicos Islands
## 188                                       Lesotho
## 189                         Saint Kitts and Nevis
## 190                                       Grenada
## 191                                         Samoa
## 192              Saint Vincent and the Grenadines
## 193                                American Samoa
## 194                                     Gibraltar
## 195                                      Dominica
## 196                               Solomon Islands
## 197                      Central African Republic
## 198                                       Vanuatu
## 199                                       Comoros
## 200                        British Virgin Islands
## 201                         Sao Tome and Principe
## 202                                 Guinea-Bissau
## 203                                         Tonga
## 204                     Saint Pierre and Miquelon
## 205                                  Cook Islands
## 206                                         Nauru
## 207                                      Kiribati
## 208             Falkland Islands (Islas Malvinas)
## 209 Saint Helena, Ascension, and Tristan da Cunha
## 210                                    Montserrat
## 211                                          Niue
## 212                                    Antarctica
## 213                                   Wake Island
##                                            slug            kW
## 1                                         china 2,217,925,000
## 2                                 united-states 1,143,266,000
## 3                                         india   432,768,000
## 4                                         japan   348,666,000
## 5                                        russia   276,463,000
## 6                                       germany   248,265,000
## 7                                        brazil   195,037,000
## 8                                        canada   153,251,000
## 9                                        france   138,611,000
## 10                                  korea-south   135,789,000
## 11                                        italy   121,442,000
## 12                                        spain   115,837,000
## 13                               united-kingdom   113,153,000
## 14                               turkey-turkiye    96,846,000
## 15                                       mexico    93,430,000
## 16                                    australia    82,517,000
## 17                                         iran    80,553,000
## 18                                 saudi-arabia    76,785,000
## 19                                    indonesia    69,065,000
## 20                                      vietnam    65,283,000
## 21                                 south-africa    62,728,000
## 22                                        egypt    59,826,000
## 23                                       taiwan    57,738,000
## 24                                      ukraine    56,816,000
## 25                                     thailand    53,130,000
## 26                                       poland    47,269,000
## 27                                    argentina    44,731,000
## 28                                       sweden    43,499,000
## 29                                  netherlands    43,409,000
## 30                                     pakistan    39,925,000
## 31                                       norway    38,360,000
## 32                         united-arab-emirates    35,173,000
## 33                                     malaysia    34,959,000
## 34                                    venezuela    32,956,000
## 35                                        chile    29,808,000
## 36                                      austria    28,376,000
## 37                                         iraq    28,369,000
## 38                                  philippines    27,885,000
## 39                                      belgium    26,929,000
## 40                                   kazakhstan    25,022,000
## 41                                  switzerland    22,921,000
## 42                                      czechia    22,485,000
## 43                                     portugal    22,364,000
## 44                                      algeria    21,694,000
## 45                                       greece    21,545,000
## 46                                      romania    20,528,000
## 47                                      finland    20,418,000
## 48                                     colombia    19,769,000
## 49                                       kuwait    19,371,000
## 50                                       israel    18,993,000
## 51                                   bangladesh    18,461,000
## 52                                      denmark    17,655,000
## 53                                   uzbekistan    16,042,000
## 54                                         peru    15,340,000
## 55                                      morocco    14,187,000
## 56                                    hong-kong    14,168,000
## 57                                    singapore    12,240,000
## 58                                      nigeria    11,691,000
## 59                                      ireland    11,430,000
## 60                                      belarus    11,360,000
## 61                                     bulgaria    11,097,000
## 62                                      hungary    10,873,000
## 63                                        qatar    10,633,000
## 64                                        libya    10,516,000
## 65                                        syria    10,082,000
## 66                                  new-zealand     9,615,000
## 67                                      ecuador     9,354,000
## 68                                         laos     9,346,000
## 69                                       serbia     8,986,000
## 70                                     paraguay     8,831,000
## 71                                         oman     8,601,000
## 72                                  korea-north     8,413,000
## 73                                     slovakia     7,868,000
## 74                                   azerbaijan     7,677,000
## 75                                         cuba     7,479,000
## 76                                       angola     7,344,000
## 77                                        burma     7,247,000
## 78                                   tajikistan     7,114,000
## 79                                      bahrain     6,982,000
## 80                                  puerto-rico     6,180,000
## 81                                      tunisia     5,777,000
## 82                           dominican-republic     5,674,000
## 83                                       jordan     5,644,000
## 84                                      uruguay     5,348,000
## 85                                        ghana     5,312,000
## 86                                 turkmenistan     5,205,000
## 87                                    guatemala     5,185,000
## 88                                      croatia     4,940,000
## 89                                     ethiopia     4,856,000
## 90                       bosnia-and-herzegovina     4,775,000
## 91                                   kyrgyzstan     4,626,000
## 92                                      georgia     4,579,000
## 93                                    sri-lanka     4,527,000
## 94                                        sudan     4,354,000
## 95                                       panama     4,106,000
## 96                                     slovenia     4,062,000
## 97                                     honduras     3,991,000
## 98                                      bolivia     3,834,000
## 99                                      lebanon     3,768,000
## 100                                  costa-rica     3,674,000
## 101                                     armenia     3,633,000
## 102                                   lithuania     3,512,000
## 103                                       haiti     3,453,000
## 104                                       kenya     3,304,000
## 105                                      latvia     3,089,000
## 106                                      zambia     3,065,000
## 107                                     estonia     3,030,000
## 108                                     iceland     2,967,000
## 109                                    cambodia     2,954,000
## 110            congo-democratic-republic-of-the     2,919,000
## 111                                  mozambique     2,765,000
## 112                                 el-salvador     2,586,000
## 113                                     albania     2,531,000
## 114                                    zimbabwe     2,473,000
## 115                                      uganda     2,397,000
## 116                                      bhutan     2,334,000
## 117                                cote-divoire     2,197,000
## 118                         trinidad-and-tobago     2,123,000
## 119                             north-macedonia     1,928,000
## 120                                  luxembourg     1,899,000
## 121                                      cyprus     1,881,000
## 122                                   nicaragua     1,837,000
## 123                                       yemen     1,772,000
## 124                                    cameroon     1,754,000
## 125                                    tanzania     1,623,000
## 126                                    mongolia     1,479,000
## 127                                      kosovo     1,424,000
## 128                                       nepal     1,392,000
## 129                                     senegal     1,312,000
## 130                                      brunei     1,261,000
## 131                                     jamaica     1,216,000
## 132                            papua-new-guinea     1,139,000
## 133                               new-caledonia     1,071,000
## 134                                  montenegro     1,007,000
## 135                                      guinea       992,000
## 136                                   mauritius       936,000
## 137                                        mali       890,000
## 138                                       gabon       784,000
## 139                                       malta       784,000
## 140                                 afghanistan       776,000
## 141                                    botswana       766,000
## 142                                  mauritania       656,000
## 143                                     namibia       640,000
## 144                       congo-republic-of-the       629,000
## 145                                      malawi       618,000
## 146                                     moldova       594,000
## 147                                  madagascar       587,000
## 148                                 bahamas-the       578,000
## 149                                    maldives       545,000
## 150                                    suriname       542,000
## 151                                       macau       478,000
## 152                                       benin       475,000
## 153                                        guam       455,000
## 154                                        fiji       393,000
## 155                                burkina-faso       392,000
## 156                                      guyana       380,000
## 157                           equatorial-guinea       349,000
## 158                                       niger       324,000
## 159                              virgin-islands       321,000
## 160                                    barbados       311,000
## 161                                       aruba       296,000
## 162                                    eswatini       286,000
## 163                                 timor-leste       284,000
## 164                            french-polynesia       272,000
## 165                                      rwanda       265,000
## 166                                     eritrea       228,000
## 167                                   west-bank       215,000
## 168                                  gaza-strip       215,000
## 169                                        togo       210,000
## 170                                  cabo-verde       205,000
## 171                                      belize       204,000
## 172                                     liberia       196,000
## 173                                   greenland       187,000
## 174                                sierra-leone       180,000
## 175                              cayman-islands       174,000
## 176                                     bermuda       172,000
## 177                                  seychelles       157,000
## 178                                  gambia-the       137,000
## 179                                    djibouti       130,000
## 180                               faroe-islands       128,000
## 181                                 south-sudan       121,000
## 182                         antigua-and-barbuda       117,000
## 183                                     burundi       100,000
## 184                                 saint-lucia        92,000
## 185                                     somalia        91,000
## 186                                        chad        87,000
## 187                    turks-and-caicos-islands        85,000
## 188                                     lesotho        74,000
## 189                       saint-kitts-and-nevis        71,000
## 190                                     grenada        55,000
## 191                                       samoa        50,000
## 192            saint-vincent-and-the-grenadines        49,000
## 193                              american-samoa        47,000
## 194                                   gibraltar        43,000
## 195                                    dominica        42,000
## 196                             solomon-islands        40,000
## 197                    central-african-republic        38,000
## 198                                     vanuatu        35,000
## 199                                     comoros        35,000
## 200                      british-virgin-islands        33,000
## 201                       sao-tome-and-principe        28,000
## 202                               guinea-bissau        28,000
## 203                                       tonga        26,000
## 204                   saint-pierre-and-miquelon        26,000
## 205                                cook-islands        18,000
## 206                                       nauru        15,000
## 207                                    kiribati        11,000
## 208             falkland-islands-islas-malvinas        11,000
## 209 saint-helena-ascension-and-tristan-da-cunha         8,000
## 210                                  montserrat         5,000
## 211                                        niue         3,000
## 212                                  antarctica             0
## 213                                 wake-island             0
##     date_of_information ranking                            region
## 1                  2020       1           East and Southeast Asia
## 2                  2020       2                     North America
## 3                  2020       3                        South Asia
## 4                  2020       4           East and Southeast Asia
## 5                  2020       5                      Central Asia
## 6                  2020       6                            Europe
## 7                  2020       7                     South America
## 8                  2020       8                     North America
## 9                  2020       9                            Europe
## 10                 2020      10           East and Southeast Asia
## 11                 2020      11                            Europe
## 12                 2020      12                            Europe
## 13                 2020      13                            Europe
## 14                 2020      14                       Middle East
## 15                 2020      15                     North America
## 16                 2020      16             Australia and Oceania
## 17                 2020      17                       Middle East
## 18                 2020      18                       Middle East
## 19                 2020      19           East and Southeast Asia
## 20                 2020      20           East and Southeast Asia
## 21                 2020      21                            Africa
## 22                 2020      22                            Africa
## 23                 2020      23           East and Southeast Asia
## 24                 2020      24                            Europe
## 25                 2020      25           East and Southeast Asia
## 26                 2020      26                            Europe
## 27                 2020      27                     South America
## 28                 2020      28                            Europe
## 29                 2020      29                            Europe
## 30                 2020      30                        South Asia
## 31                 2020      31                            Europe
## 32                 2020      32                       Middle East
## 33                 2020      33           East and Southeast Asia
## 34                 2020      34                     South America
## 35                 2020      35                     South America
## 36                 2020      36                            Europe
## 37                 2020      37                       Middle East
## 38                 2020      38           East and Southeast Asia
## 39                 2020      39                            Europe
## 40                 2020      40                      Central Asia
## 41                 2020      41                            Europe
## 42                 2020      42                            Europe
## 43                 2020      43                            Europe
## 44                 2020      44                            Africa
## 45                 2020      45                            Europe
## 46                 2020      46                            Europe
## 47                 2020      47                            Europe
## 48                 2020      48                     South America
## 49                 2020      49                       Middle East
## 50                 2020      50                       Middle East
## 51                 2020      51                        South Asia
## 52                 2020      52                            Europe
## 53                 2020      53                      Central Asia
## 54                 2020      54                     South America
## 55                 2020      55                            Africa
## 56                 2020      56           East and Southeast Asia
## 57                 2020      57           East and Southeast Asia
## 58                 2020      58                            Africa
## 59                 2020      59                            Europe
## 60                 2020      60                            Europe
## 61                 2020      61                            Europe
## 62                 2020      62                            Europe
## 63                 2020      63                       Middle East
## 64                 2020      64                            Africa
## 65                 2020      65                       Middle East
## 66                 2020      66             Australia and Oceania
## 67                 2020      67                     South America
## 68                 2020      68           East and Southeast Asia
## 69                 2020      69                            Europe
## 70                 2020      70                     South America
## 71                 2020      71                       Middle East
## 72                 2020      72           East and Southeast Asia
## 73                 2020      73                            Europe
## 74                 2020      74                       Middle East
## 75                 2020      75 Central America and the Caribbean
## 76                 2020      76                            Africa
## 77                 2020      77           East and Southeast Asia
## 78                 2020      78                      Central Asia
## 79                 2020      79                       Middle East
## 80                 2020      80 Central America and the Caribbean
## 81                 2020      81                            Africa
## 82                 2020      82 Central America and the Caribbean
## 83                 2020      83                       Middle East
## 84                 2020      84                     South America
## 85                 2020      85                            Africa
## 86                 2020      86                      Central Asia
## 87                 2020      87 Central America and the Caribbean
## 88                 2020      88                            Europe
## 89                 2020      89                            Africa
## 90                 2020      90                            Europe
## 91                 2020      91                      Central Asia
## 92                 2020      92                       Middle East
## 93                 2020      93                        South Asia
## 94                 2020      94                            Africa
## 95                 2020      95 Central America and the Caribbean
## 96                 2020      96                            Europe
## 97                 2020      97 Central America and the Caribbean
## 98                 2020      98                     South America
## 99                 2020      99                       Middle East
## 100                2020     100 Central America and the Caribbean
## 101                2020     101                       Middle East
## 102                2020     102                            Europe
## 103                2020     103 Central America and the Caribbean
## 104                2020     104                            Africa
## 105                2020     105                            Europe
## 106                2020     106                            Africa
## 107                2020     107                            Europe
## 108                2020     108                            Europe
## 109                2020     109           East and Southeast Asia
## 110                2020     110                            Africa
## 111                2020     111                            Africa
## 112                2020     112 Central America and the Caribbean
## 113                2020     113                            Europe
## 114                2020     114                            Africa
## 115                2020     115                            Africa
## 116                2020     116                        South Asia
## 117                2020     117                            Africa
## 118                2020     118 Central America and the Caribbean
## 119                2020     119                            Europe
## 120                2020     120                            Europe
## 121                2020     121                            Europe
## 122                2020     122 Central America and the Caribbean
## 123                2020     123                       Middle East
## 124                2020     124                            Africa
## 125                2020     125                            Africa
## 126                2020     126           East and Southeast Asia
## 127                2020     127                            Europe
## 128                2020     128                        South Asia
## 129                2020     129                            Africa
## 130                2020     130           East and Southeast Asia
## 131                2020     131 Central America and the Caribbean
## 132                2020     132           East and Southeast Asia
## 133                2020     133             Australia and Oceania
## 134                2020     134                            Europe
## 135                2020     135                            Africa
## 136                2020     136                            Africa
## 137                2020     137                            Africa
## 138                2020     138                            Africa
## 139                2020     139                            Europe
## 140                2020     140                        South Asia
## 141                2020     141                            Africa
## 142                2020     142                            Africa
## 143                2020     143                            Africa
## 144                2020     144                            Africa
## 145                2020     145                            Africa
## 146                2020     146                            Europe
## 147                2020     147                            Africa
## 148                2020     148 Central America and the Caribbean
## 149                2020     149                        South Asia
## 150                2020     150                     South America
## 151                2020     151           East and Southeast Asia
## 152                2020     152                            Africa
## 153                2020     153             Australia and Oceania
## 154                2020     154             Australia and Oceania
## 155                2020     155                            Africa
## 156                2020     156                     South America
## 157                2020     157                            Africa
## 158                2020     158                            Africa
## 159                2020     159 Central America and the Caribbean
## 160                2020     160 Central America and the Caribbean
## 161                2020     161 Central America and the Caribbean
## 162                2020     162                            Africa
## 163                2020     163           East and Southeast Asia
## 164                2020     164             Australia and Oceania
## 165                2020     165                            Africa
## 166                2020     166                            Africa
## 167                2020     167                       Middle East
## 168                2020     168                       Middle East
## 169                2020     169                            Africa
## 170                2020     170                            Africa
## 171                2020     171 Central America and the Caribbean
## 172                2020     172                            Africa
## 173                2020     173                     North America
## 174                2020     174                            Africa
## 175                2020     175 Central America and the Caribbean
## 176                2020     176                     North America
## 177                2020     177                            Africa
## 178                2020     178                            Africa
## 179                2020     179                            Africa
## 180                2020     180                            Europe
## 181                2020     181                            Africa
## 182                2020     182 Central America and the Caribbean
## 183                2020     183                            Africa
## 184                2020     184 Central America and the Caribbean
## 185                2020     185                            Africa
## 186                2020     186                            Africa
## 187                2020     187 Central America and the Caribbean
## 188                2020     188                            Africa
## 189                2020     189 Central America and the Caribbean
## 190                2020     190 Central America and the Caribbean
## 191                2020     191             Australia and Oceania
## 192                2020     192 Central America and the Caribbean
## 193                2020     193             Australia and Oceania
## 194                2020     194                            Europe
## 195                2020     195 Central America and the Caribbean
## 196                2020     196             Australia and Oceania
## 197                2020     197                            Africa
## 198                2020     198             Australia and Oceania
## 199                2020     199                            Africa
## 200                2020     200 Central America and the Caribbean
## 201                2020     201                            Africa
## 202                2020     202                            Africa
## 203                2020     203             Australia and Oceania
## 204                2020     204                     North America
## 205                2020     205             Australia and Oceania
## 206                2020     206             Australia and Oceania
## 207                2020     207             Australia and Oceania
## 208                2020     208                     South America
## 209                2020     209                            Africa
## 210                2020     210 Central America and the Caribbean
## 211                2020     211             Australia and Oceania
## 212                2020     212                        Antarctica
## 213                2020     213             Australia and Oceania
data81 <- data8[, c('kW', 'region')]

head(data81)
##              kW                  region
## 1 2,217,925,000 East and Southeast Asia
## 2 1,143,266,000           North America
## 3   432,768,000              South Asia
## 4   348,666,000 East and Southeast Asia
## 5   276,463,000            Central Asia
## 6   248,265,000                  Europe
library(rio)
data9= import("Debt - external.csv")
data9
##                                  name                             slug
## 1                       United States                    united-states
## 2                      United Kingdom                   united-kingdom
## 3                              France                           france
## 4                             Germany                          germany
## 5                         Netherlands                      netherlands
## 6                          Luxembourg                       luxembourg
## 7                               Japan                            japan
## 8                           Australia                        australia
## 9                             Ireland                          ireland
## 10                              Italy                            italy
## 11                              Spain                            spain
## 12                             Canada                           canada
## 13                              China                            china
## 14                        Switzerland                      switzerland
## 15                          Hong Kong                        hong-kong
## 16                          Singapore                        singapore
## 17                            Belgium                          belgium
## 18                             Sweden                           sweden
## 19                            Austria                          austria
## 20                             Brazil                           brazil
## 21                             Norway                           norway
## 22                            Finland                          finland
## 23                              India                            india
## 24                            Denmark                          denmark
## 25                             Greece                           greece
## 26                             Russia                           russia
## 27                           Portugal                         portugal
## 28                       Korea, South                      korea-south
## 29                             Mexico                           mexico
## 30                   Turkey (Turkiye)                   turkey-turkiye
## 31                          Indonesia                        indonesia
## 32                             Poland                           poland
## 33                          Argentina                        argentina
## 34               United Arab Emirates             united-arab-emirates
## 35                          Mauritius                        mauritius
## 36                           Malaysia                         malaysia
## 37                             Cyprus                           cyprus
## 38                       Saudi Arabia                     saudi-arabia
## 39                              Chile                            chile
## 40                            Czechia                          czechia
## 41                        New Zealand                      new-zealand
## 42                             Taiwan                           taiwan
## 43                       South Africa                     south-africa
## 44                           Thailand                         thailand
## 45                              Qatar                            qatar
## 46                         Kazakhstan                       kazakhstan
## 47                           Colombia                         colombia
## 48                             Israel                           israel
## 49                            Hungary                          hungary
## 50                            Romania                          romania
## 51                            Ukraine                          ukraine
## 52                           Slovakia                         slovakia
## 53                              Egypt                            egypt
## 54                           Pakistan                         pakistan
## 55                             Panama                           panama
## 56                          Venezuela                        venezuela
## 57                              Malta                            malta
## 58                            Vietnam                          vietnam
## 59                        Philippines                      philippines
## 60                               Peru                             peru
## 61                               Iraq                             iraq
## 62                        Puerto Rico                      puerto-rico
## 63                              Sudan                            sudan
## 64                          Sri Lanka                        sri-lanka
## 65                            Morocco                          morocco
## 66                            Bahrain                          bahrain
## 67                            Ecuador                          ecuador
## 68                         Bangladesh                       bangladesh
## 69                           Slovenia                         slovenia
## 70                            Croatia                          croatia
## 71                             Kuwait                           kuwait
## 72                               Oman                             oman
## 73                            Uruguay                          uruguay
## 74                             Angola                           angola
## 75                             Latvia                           latvia
## 76                            Belarus                          belarus
## 77                           Bulgaria                         bulgaria
## 78                          Lithuania                        lithuania
## 79                            Tunisia                          tunisia
## 80                            Lebanon                          lebanon
## 81                             Jordan                           jordan
## 82                             Serbia                           serbia
## 83                               Cuba                             cuba
## 84                           Mongolia                         mongolia
## 85                         Costa Rica                       costa-rica
## 86                              Kenya                            kenya
## 87                           Ethiopia                         ethiopia
## 88                            Nigeria                          nigeria
## 89                            Estonia                          estonia
## 90                 Dominican Republic               dominican-republic
## 91                          Guatemala                        guatemala
## 92                           Tanzania                         tanzania
## 93                              Ghana                            ghana
## 94                            Iceland                          iceland
## 95                              Palau                            palau
## 96                            Georgia                          georgia
## 97                   Papua New Guinea                 papua-new-guinea
## 98                       Bahamas, The                      bahamas-the
## 99                         Azerbaijan                       azerbaijan
## 100                       El Salvador                      el-salvador
## 101                        Uzbekistan                       uzbekistan
## 102                          Paraguay                         paraguay
## 103                              Laos                             laos
## 104                           Jamaica                          jamaica
## 105                     Cote d'Ivoire                     cote-divoire
## 106                           Bolivia                          bolivia
## 107                          Cambodia                         cambodia
## 108                         Nicaragua                        nicaragua
## 109                            Zambia                           zambia
## 110                           Armenia                          armenia
## 111                        Mozambique                       mozambique
## 112            Bosnia and Herzegovina           bosnia-and-herzegovina
## 113                          Cameroon                         cameroon
## 114                          Zimbabwe                         zimbabwe
## 115                           Albania                          albania
## 116                          Honduras                         honduras
## 117                   North Macedonia                  north-macedonia
## 118                           Senegal                          senegal
## 119                        Kyrgyzstan                       kyrgyzstan
## 120               Trinidad and Tobago              trinidad-and-tobago
## 121                              Iran                             iran
## 122                           Namibia                          namibia
## 123                           Moldova                          moldova
## 124                             Yemen                            yemen
## 125                             Burma                            burma
## 126                             Gabon                            gabon
## 127                        Tajikistan                       tajikistan
## 128                            Uganda                           uganda
## 129                             Nepal                            nepal
## 130                           Algeria                          algeria
## 131                           Somalia                          somalia
## 132                      Korea, North                      korea-north
## 133                             Syria                            syria
## 134 Congo, Democratic Republic of the congo-democratic-republic-of-the
## 135                        Seychelles                       seychelles
## 136            Congo, Republic of the            congo-republic-of-the
## 137                          Barbados                         barbados
## 138                              Mali                             mali
## 139                        Mauritania                       mauritania
## 140                             Niger                            niger
## 141                            Rwanda                           rwanda
## 142                        Madagascar                       madagascar
## 143                      Burkina Faso                     burkina-faso
## 144                             Libya                            libya
## 145                             Benin                            benin
## 146                             Haiti                            haiti
## 147                            Bhutan                           bhutan
## 148                        Montenegro                       montenegro
## 149                           Bermuda                          bermuda
## 150                            Kosovo                           kosovo
## 151                          Botswana                         botswana
## 152                            Malawi                           malawi
## 153                          Djibouti                         djibouti
## 154                              Chad                             chad
## 155                        Cabo Verde                       cabo-verde
## 156                          Suriname                         suriname
## 157                            Guyana                           guyana
## 158                         West Bank                        west-bank
## 159                      Sierra Leone                     sierra-leone
## 160                            Guinea                           guinea
## 161                              Togo                             togo
## 162                            Belize                           belize
## 163                 Equatorial Guinea                equatorial-guinea
## 164                     Guinea-Bissau                    guinea-bissau
## 165                              Fiji                             fiji
## 166                           Lesotho                          lesotho
## 167                          Maldives                         maldives
## 168                           Liberia                          liberia
## 169                           Grenada                          grenada
## 170                           Eritrea                          eritrea
## 171          Central African Republic         central-african-republic
## 172                   Solomon Islands                  solomon-islands
## 173                             Aruba                            aruba
## 174                           Burundi                          burundi
## 175                       Gambia, The                       gambia-the
## 176                       Saint Lucia                      saint-lucia
## 177                      Turkmenistan                     turkmenistan
## 178                          Eswatini                         eswatini
## 179               Antigua and Barbuda              antigua-and-barbuda
## 180                             Samoa                            samoa
## 181                     Faroe Islands                    faroe-islands
## 182  Saint Vincent and the Grenadines saint-vincent-and-the-grenadines
## 183                       Timor-Leste                      timor-leste
## 184             Sao Tome and Principe            sao-tome-and-principe
## 185                       Afghanistan                      afghanistan
## 186                          Dominica                         dominica
## 187             Saint Kitts and Nevis            saint-kitts-and-nevis
## 188                           Vanuatu                          vanuatu
## 189                           Comoros                          comoros
## 190                             Tonga                            tonga
## 191                      Cook Islands                     cook-islands
## 192                     New Caledonia                    new-caledonia
## 193                  Marshall Islands                 marshall-islands
## 194   Micronesia, Federated States of   micronesia-federated-states-of
## 195                          Anguilla                         anguilla
## 196                          Kiribati                         kiribati
## 197                         Greenland                        greenland
## 198            British Virgin Islands           british-virgin-islands
## 199                             Nauru                            nauru
## 200                        Montserrat                       montserrat
## 201                 Wallis and Futuna                wallis-and-futuna
## 202                              Niue                             niue
## 203                             Macau                            macau
## 204 Falkland Islands (Islas Malvinas)  falkland-islands-islas-malvinas
## 205                           Andorra                          andorra
## 206                            Brunei                           brunei
## 207                     Liechtenstein                    liechtenstein
##                   value date_of_information ranking
## 1   $20,275,951,000,000                2019       1
## 2    $8,722,000,000,000                2019       2
## 3    $6,356,000,000,000                2019       3
## 4    $5,671,463,000,000                2019       4
## 5    $4,345,413,000,000                2019       5
## 6    $4,266,792,000,000                2019       6
## 7    $4,254,271,000,000                2019       7
## 8    $3,115,913,000,000                2019       8
## 9    $2,829,000,000,000                2019       9
## 10   $2,463,208,000,000                2019      10
## 11   $2,338,000,000,000                2019      11
## 12   $2,124,887,000,000                2019      12
## 13   $2,027,950,000,000                2019      13
## 14   $1,909,000,000,000                2019      14
## 15   $1,648,409,000,000                2019      15
## 16   $1,557,646,000,000                2019      16
## 17   $1,317,513,000,000                2019      17
## 18     $911,317,000,000                2019      18
## 19     $688,434,000,000                2019      19
## 20     $681,336,000,000                2019      20
## 21     $651,040,000,000                2019      21
## 22     $631,549,000,000                2019      22
## 23     $555,388,000,000                2019      23
## 24     $504,808,000,000                2019      24
## 25     $484,888,000,000                2019      25
## 26     $479,844,000,000                2019      26
## 27     $462,431,000,000                2019      27
## 28     $457,745,000,000                2019      28
## 29     $456,713,000,000                2019      29
## 30     $438,677,000,000                2019      30
## 31     $393,252,000,000                2019      31
## 32     $351,770,000,000                2019      32
## 33     $278,524,000,000                2019      33
## 34     $237,600,000,000    31 December 2017      34
## 35     $226,799,000,000                2019      35
## 36     $224,596,000,000                2019      36
## 37     $213,190,000,000                2019      37
## 38     $205,100,000,000    31 December 2017      38
## 39     $193,298,000,000                2019      39
## 40     $191,871,000,000                2019      40
## 41     $190,621,000,000                2019      41
## 42     $189,684,000,000                2019      42
## 43     $179,871,000,000                2019      43
## 44     $167,890,000,000                2019      44
## 45     $167,800,000,000    31 December 2017      45
## 46     $159,351,000,000                2019      46
## 47     $135,644,000,000                2019      47
## 48     $132,500,000,000    31 December 2020      48
## 49     $123,256,000,000                2019      49
## 50     $117,829,000,000                2019      50
## 51     $117,410,000,000                2019      51
## 52     $115,853,000,000                2019      52
## 53     $109,238,000,000                2019      53
## 54     $107,527,000,000                2019      54
## 55     $101,393,000,000                2019      55
## 56     $100,300,000,000    31 December 2017      56
## 57      $98,179,000,000                2019      57
## 58      $96,580,000,000    31 December 2017      58
## 59      $81,995,000,000                2019      59
## 60      $81,333,000,000                2019      60
## 61      $73,020,000,000    31 December 2017      61
## 62      $56,820,000,000    31 December 2010      62
## 63      $56,050,000,000    31 December 2017      63
## 64      $55,332,000,000                2019      64
## 65      $52,957,000,000                2019      65
## 66      $52,150,000,000    31 December 2017      66
## 67      $50,667,000,000                2019      67
## 68      $50,260,000,000    31 December 2017      68
## 69      $48,656,000,000                2019      69
## 70      $48,263,000,000                2019      70
## 71      $47,240,000,000    31 December 2017      71
## 72      $46,270,000,000    31 December 2017      72
## 73      $43,705,000,000                2019      73
## 74      $42,080,000,000    31 December 2017      74
## 75      $40,164,000,000                2019      75
## 76      $39,847,000,000                2019      76
## 77      $39,059,000,000                2019      77
## 78      $37,859,000,000                2019      78
## 79      $35,911,000,000                2019      79
## 80      $33,077,000,000                2019      80
## 81      $32,088,000,000                2019      81
## 82      $30,927,000,000                2019      82
## 83      $30,060,000,000    31 December 2017      83
## 84      $29,945,000,000                2019      84
## 85      $29,589,000,000                2019      85
## 86      $29,289,000,000                2019      86
## 87      $27,270,000,000                2019      87
## 88      $26,847,000,000                2019      88
## 89      $23,944,000,000                2019      89
## 90      $23,094,000,000                2019      90
## 91      $22,920,000,000    31 December 2017      91
## 92      $22,054,000,000                2019      92
## 93      $20,467,000,000                2019      93
## 94      $19,422,000,000                2019      94
## 95      $18,380,000,000    31 December 2014      95
## 96      $18,149,000,000                2019      96
## 97      $17,940,000,000    31 December 2017      97
## 98      $17,560,000,000    31 December 2013      98
## 99      $17,410,000,000    31 December 2017      99
## 100     $17,240,000,000                2019     100
## 101     $16,900,000,000    31 December 2017     101
## 102     $16,622,000,000                2019     102
## 103     $14,900,000,000    31 December 2017     103
## 104     $13,876,000,000                2019     104
## 105     $13,070,000,000    31 December 2017     105
## 106     $12,810,000,000    31 December 2017     106
## 107     $11,870,000,000    31 December 2017     107
## 108     $11,674,000,000                2019     108
## 109     $11,660,000,000    31 December 2017     109
## 110     $11,637,000,000                2019     110
## 111     $10,910,000,000    31 December 2017     111
## 112     $10,870,000,000    31 December 2017     112
## 113      $9,375,000,000    31 December 2017     113
## 114      $9,357,000,000    31 December 2017     114
## 115      $9,311,000,000                2019     115
## 116      $9,137,000,000                2019     116
## 117      $9,065,000,000                2019     117
## 118      $8,571,000,000    31 December 2017     118
## 119      $8,372,000,000                2019     119
## 120      $8,238,000,000    31 December 2017     120
## 121      $7,995,000,000    31 December 2017     121
## 122      $7,969,000,000    31 December 2017     122
## 123      $7,232,000,000                2019     123
## 124      $7,181,000,000    31 December 2016     124
## 125      $6,594,000,000    31 December 2017     125
## 126      $6,490,000,000    31 December 2017     126
## 127      $6,470,000,000                2019     127
## 128      $6,241,000,000    31 December 2016     128
## 129      $5,849,000,000    31 December 2017     129
## 130      $5,574,000,000                2019     130
## 131      $5,300,000,000    31 December 2014     131
## 132      $5,000,000,000                2013     132
## 133      $4,989,000,000    31 December 2017     133
## 134      $4,963,000,000    31 December 2017     134
## 135      $4,802,000,000                2019     135
## 136      $4,605,000,000    31 December 2017     136
## 137      $4,490,000,000                2010     137
## 138      $4,192,000,000    31 December 2017     138
## 139      $4,150,000,000    31 December 2017     139
## 140      $3,728,000,000    31 December 2017     140
## 141      $3,258,000,000    31 December 2017     141
## 142      $3,085,000,000                2019     142
## 143      $3,056,000,000    31 December 2017     143
## 144      $3,020,000,000    31 December 2017     144
## 145      $2,804,000,000    31 December 2017     145
## 146      $2,762,000,000    31 December 2017     146
## 147      $2,671,000,000    31 December 2017     147
## 148      $2,516,000,000    31 December 2017     148
## 149      $2,515,000,000                2017     149
## 150      $2,388,000,000                2019     150
## 151      $2,187,000,000    31 December 2017     151
## 152      $2,102,000,000    31 December 2017     152
## 153      $1,954,000,000    31 December 2017     153
## 154      $1,724,000,000    31 December 2017     154
## 155      $1,713,000,000    31 December 2017     155
## 156      $1,700,000,000    31 December 2017     156
## 157      $1,690,000,000    31 December 2017     157
## 158      $1,662,000,000       31 March 2016     158
## 159      $1,615,000,000    31 December 2017     159
## 160      $1,458,000,000    31 December 2017     160
## 161      $1,442,000,000    31 December 2017     161
## 162      $1,315,000,000    31 December 2017     162
## 163      $1,211,000,000    31 December 2017     163
## 164      $1,095,000,000    31 December 2010     164
## 165      $1,022,000,000    31 December 2017     165
## 166        $868,000,000                2019     166
## 167        $848,800,000    31 December 2016     167
## 168        $826,000,000                2019     168
## 169        $793,500,000                2017     169
## 170        $792,700,000    31 December 2017     170
## 171        $779,900,000    31 December 2017     171
## 172        $757,000,000    31 December 2017     172
## 173        $693,200,000    31 December 2014     173
## 174        $610,900,000    31 December 2017     174
## 175        $586,800,000    31 December 2017     175
## 176        $570,600,000    31 December 2017     176
## 177        $539,400,000    31 December 2017     177
## 178        $535,000,000                2019     178
## 179        $458,000,000           June 2010     179
## 180        $447,200,000    31 December 2013     180
## 181        $387,600,000                2012     181
## 182        $362,200,000    31 December 2017     182
## 183        $311,500,000    31 December 2014     183
## 184        $292,900,000    31 December 2017     184
## 185        $284,000,000             FY10/11     185
## 186        $280,400,000    31 December 2017     186
## 187        $201,800,000    31 December 2017     187
## 188        $200,500,000    31 December 2017     188
## 189        $199,800,000    31 December 2017     189
## 190        $189,900,000    31 December 2017     190
## 191        $141,000,000                1996     191
## 192        $112,000,000    31 December 2013     192
## 193         $97,960,000                2013     193
## 194         $93,600,000                2013     194
## 195         $41,040,000    31 December 2013     195
## 196         $40,900,000                2016     196
## 197         $36,400,000                2010     197
## 198         $36,100,000                1997     198
## 199         $33,300,000                2004     199
## 200          $8,900,000                1997     200
## 201          $3,670,000                2004     201
## 202            $418,000                2002     202
## 203                  $0    31 December 2013     203
## 204                  $0                2017     204
## 205                  $0                2016     205
## 206                  $0                2014     206
## 207                  $0                2015     207
##                                region
## 1                       North America
## 2                              Europe
## 3                              Europe
## 4                              Europe
## 5                              Europe
## 6                              Europe
## 7             East and Southeast Asia
## 8               Australia and Oceania
## 9                              Europe
## 10                             Europe
## 11                             Europe
## 12                      North America
## 13            East and Southeast Asia
## 14                             Europe
## 15            East and Southeast Asia
## 16            East and Southeast Asia
## 17                             Europe
## 18                             Europe
## 19                             Europe
## 20                      South America
## 21                             Europe
## 22                             Europe
## 23                         South Asia
## 24                             Europe
## 25                             Europe
## 26                       Central Asia
## 27                             Europe
## 28            East and Southeast Asia
## 29                      North America
## 30                        Middle East
## 31            East and Southeast Asia
## 32                             Europe
## 33                      South America
## 34                        Middle East
## 35                             Africa
## 36            East and Southeast Asia
## 37                             Europe
## 38                        Middle East
## 39                      South America
## 40                             Europe
## 41              Australia and Oceania
## 42            East and Southeast Asia
## 43                             Africa
## 44            East and Southeast Asia
## 45                        Middle East
## 46                       Central Asia
## 47                      South America
## 48                        Middle East
## 49                             Europe
## 50                             Europe
## 51                             Europe
## 52                             Europe
## 53                             Africa
## 54                         South Asia
## 55  Central America and the Caribbean
## 56                      South America
## 57                             Europe
## 58            East and Southeast Asia
## 59            East and Southeast Asia
## 60                      South America
## 61                        Middle East
## 62  Central America and the Caribbean
## 63                             Africa
## 64                         South Asia
## 65                             Africa
## 66                        Middle East
## 67                      South America
## 68                         South Asia
## 69                             Europe
## 70                             Europe
## 71                        Middle East
## 72                        Middle East
## 73                      South America
## 74                             Africa
## 75                             Europe
## 76                             Europe
## 77                             Europe
## 78                             Europe
## 79                             Africa
## 80                        Middle East
## 81                        Middle East
## 82                             Europe
## 83  Central America and the Caribbean
## 84            East and Southeast Asia
## 85  Central America and the Caribbean
## 86                             Africa
## 87                             Africa
## 88                             Africa
## 89                             Europe
## 90  Central America and the Caribbean
## 91  Central America and the Caribbean
## 92                             Africa
## 93                             Africa
## 94                             Europe
## 95              Australia and Oceania
## 96                        Middle East
## 97            East and Southeast Asia
## 98  Central America and the Caribbean
## 99                        Middle East
## 100 Central America and the Caribbean
## 101                      Central Asia
## 102                     South America
## 103           East and Southeast Asia
## 104 Central America and the Caribbean
## 105                            Africa
## 106                     South America
## 107           East and Southeast Asia
## 108 Central America and the Caribbean
## 109                            Africa
## 110                       Middle East
## 111                            Africa
## 112                            Europe
## 113                            Africa
## 114                            Africa
## 115                            Europe
## 116 Central America and the Caribbean
## 117                            Europe
## 118                            Africa
## 119                      Central Asia
## 120 Central America and the Caribbean
## 121                       Middle East
## 122                            Africa
## 123                            Europe
## 124                       Middle East
## 125           East and Southeast Asia
## 126                            Africa
## 127                      Central Asia
## 128                            Africa
## 129                        South Asia
## 130                            Africa
## 131                            Africa
## 132           East and Southeast Asia
## 133                       Middle East
## 134                            Africa
## 135                            Africa
## 136                            Africa
## 137 Central America and the Caribbean
## 138                            Africa
## 139                            Africa
## 140                            Africa
## 141                            Africa
## 142                            Africa
## 143                            Africa
## 144                            Africa
## 145                            Africa
## 146 Central America and the Caribbean
## 147                        South Asia
## 148                            Europe
## 149                     North America
## 150                            Europe
## 151                            Africa
## 152                            Africa
## 153                            Africa
## 154                            Africa
## 155                            Africa
## 156                     South America
## 157                     South America
## 158                       Middle East
## 159                            Africa
## 160                            Africa
## 161                            Africa
## 162 Central America and the Caribbean
## 163                            Africa
## 164                            Africa
## 165             Australia and Oceania
## 166                            Africa
## 167                        South Asia
## 168                            Africa
## 169 Central America and the Caribbean
## 170                            Africa
## 171                            Africa
## 172             Australia and Oceania
## 173 Central America and the Caribbean
## 174                            Africa
## 175                            Africa
## 176 Central America and the Caribbean
## 177                      Central Asia
## 178                            Africa
## 179 Central America and the Caribbean
## 180             Australia and Oceania
## 181                            Europe
## 182 Central America and the Caribbean
## 183           East and Southeast Asia
## 184                            Africa
## 185                        South Asia
## 186 Central America and the Caribbean
## 187 Central America and the Caribbean
## 188             Australia and Oceania
## 189                            Africa
## 190             Australia and Oceania
## 191             Australia and Oceania
## 192             Australia and Oceania
## 193             Australia and Oceania
## 194             Australia and Oceania
## 195 Central America and the Caribbean
## 196             Australia and Oceania
## 197                     North America
## 198 Central America and the Caribbean
## 199             Australia and Oceania
## 200 Central America and the Caribbean
## 201             Australia and Oceania
## 202             Australia and Oceania
## 203           East and Southeast Asia
## 204                     South America
## 205                            Europe
## 206           East and Southeast Asia
## 207                            Europe
data91 <- data9[, c('value', 'region')]

head(data91)
##                 value        region
## 1 $20,275,951,000,000 North America
## 2  $8,722,000,000,000        Europe
## 3  $6,356,000,000,000        Europe
## 4  $5,671,463,000,000        Europe
## 5  $4,345,413,000,000        Europe
## 6  $4,266,792,000,000        Europe
library(rio)
data10= import("Carbon dioxide emissions.csv")
data10
##                                              name
## 1                                           China
## 2                                   United States
## 3                                           India
## 4                                          Russia
## 5                                           Japan
## 6                                         Germany
## 7                                    Korea, South
## 8                                            Iran
## 9                                          Canada
## 10                                   Saudi Arabia
## 11                                      Indonesia
## 12                                   South Africa
## 13                                         Mexico
## 14                                         Brazil
## 15                                      Australia
## 16                                 United Kingdom
## 17                               Turkey (Turkiye)
## 18                                         France
## 19                                          Italy
## 20                                       Thailand
## 21                                         Poland
## 22                                          Spain
## 23                                         Taiwan
## 24                           United Arab Emirates
## 25                                     Kazakhstan
## 26                                       Malaysia
## 27                                        Vietnam
## 28                                      Singapore
## 29                                          Egypt
## 30                                    Netherlands
## 31                                       Pakistan
## 32                                      Argentina
## 33                                        Ukraine
## 34                                        Algeria
## 35                                           Iraq
## 36                                    Philippines
## 37                                        Belgium
## 38                                          Qatar
## 39                                   Turkmenistan
## 40                                        Nigeria
## 41                                      Venezuela
## 42                                     Uzbekistan
## 43                                        Czechia
## 44                                     Bangladesh
## 45                                         Kuwait
## 46                                      Hong Kong
## 47                                          Chile
## 48                                       Colombia
## 49                                           Oman
## 50                                         Greece
## 51                                        Romania
## 52                                        Austria
## 53                                         Israel
## 54                                        Morocco
## 55                                           Peru
## 56                                        Belarus
## 57                                       Portugal
## 58                                        Hungary
## 59                                         Sweden
## 60                                         Serbia
## 61                                        Bahrain
## 62                                        Finland
## 63                                           Laos
## 64                                    New Zealand
## 65                            Trinidad and Tobago
## 66                                    Switzerland
## 67                                       Bulgaria
## 68                                          Libya
## 69                                         Norway
## 70                                        Ecuador
## 71                                        Ireland
## 72                                     Azerbaijan
## 73                                        Denmark
## 74                                       Slovakia
## 75                                          Burma
## 76                                          Syria
## 77                             Dominican Republic
## 78                                        Lebanon
## 79                                         Panama
## 80                                      Sri Lanka
## 81                                        Tunisia
## 82                                         Jordan
## 83                                       Mongolia
## 84                                         Angola
## 85                                      Guatemala
## 86                                    Puerto Rico
## 87                                   Korea, North
## 88                                          Ghana
## 89                                        Bolivia
## 90                                          Kenya
## 91                                          Sudan
## 92                                       Ethiopia
## 93                                        Croatia
## 94                                           Cuba
## 95                         Bosnia and Herzegovina
## 96                                      Lithuania
## 97                                      Gibraltar
## 98                                       Cambodia
## 99                                       Slovenia
## 100                                 Cote d'Ivoire
## 101                                      Tanzania
## 102                                    Luxembourg
## 103                                       Senegal
## 104                                       Georgia
## 105                                         Yemen
## 106                                       Jamaica
## 107                                        Brunei
## 108                                         Malta
## 109                                      Honduras
## 110                                        Latvia
## 111                                    Costa Rica
## 112                                       Moldova
## 113                                        Cyprus
## 114                                        Kosovo
## 115                                      Zimbabwe
## 116                                      Paraguay
## 117                                   Afghanistan
## 118                                    Kyrgyzstan
## 119                                    Mozambique
## 120                                         Nepal
## 121                                    Tajikistan
## 122                                   El Salvador
## 123                               North Macedonia
## 124                                     Mauritius
## 125                                      Cameroon
## 126                                         Benin
## 127                                        Zambia
## 128                              Papua New Guinea
## 129                                       Uruguay
## 130                                       Armenia
## 131                                      Botswana
## 132                                 New Caledonia
## 133                                        Uganda
## 134                                          Mali
## 135                                       Estonia
## 136                                     Nicaragua
## 137                             Equatorial Guinea
## 138                        Congo, Republic of the
## 139                                  Burkina Faso
## 140                                    Madagascar
## 141                                    Mauritania
## 142                                  Bahamas, The
## 143                                       Namibia
## 144                                       Albania
## 145                                    Gaza Strip
## 146                                     West Bank
## 147                                       Iceland
## 148                                         Haiti
## 149                                        Guinea
## 150                                        Guyana
## 151             Congo, Democratic Republic of the
## 152                                         Gabon
## 153                                    Montenegro
## 154                                Virgin Islands
## 155                                         Niger
## 156                                      Suriname
## 157                                      Maldives
## 158                                          Togo
## 159                                         Macau
## 160                                          Guam
## 161                                   South Sudan
## 162                                          Chad
## 163                                      Barbados
## 164                                          Fiji
## 165                                        Malawi
## 166                                       Liberia
## 167                                   Wake Island
## 168                                         Aruba
## 169                                      Eswatini
## 170                                        Rwanda
## 171                                    Seychelles
## 172                              French Polynesia
## 173                                    Cabo Verde
## 174                                        Bhutan
## 175                                  Sierra Leone
## 176                                       Somalia
## 177                                 Faroe Islands
## 178                                Cayman Islands
## 179                                       Eritrea
## 180                                       Bermuda
## 181                                       Lesotho
## 182                           Antigua and Barbuda
## 183                                       Burundi
## 184                                   Saint Lucia
## 185                                      Djibouti
## 186                                   Gambia, The
## 187                                     Greenland
## 188                                        Belize
## 189                                   Timor-Leste
## 190                                        Jersey
## 191                                         Samoa
## 192                                American Samoa
## 193                                 Guinea-Bissau
## 194                               Solomon Islands
## 195                                       Comoros
## 196                                       Grenada
## 197                              Marshall Islands
## 198                      Central African Republic
## 199                         Saint Kitts and Nevis
## 200                      Turks and Caicos Islands
## 201                                       Vanuatu
## 202              Saint Vincent and the Grenadines
## 203                                      Dominica
## 204               Micronesia, Federated States of
## 205                        British Virgin Islands
## 206                         Sao Tome and Principe
## 207                                         Tonga
## 208                                  Cook Islands
## 209                     Saint Pierre and Miquelon
## 210                                      Kiribati
## 211                                         Nauru
## 212             Falkland Islands (Islas Malvinas)
## 213                                    Montserrat
## 214                                    Antarctica
## 215 Saint Helena, Ascension, and Tristan da Cunha
## 216                                          Niue
## 217                      Northern Mariana Islands
## 218                                        Tuvalu
##                                            slug metric tonnes of CO2
## 1                                         china       10,773,248,000
## 2                                 united-states        5,144,361,000
## 3                                         india        2,314,738,000
## 4                                        russia        1,848,070,000
## 5                                         japan        1,103,234,000
## 6                                       germany          726,881,000
## 7                                   korea-south          686,954,000
## 8                                          iran          646,038,000
## 9                                        canada          612,084,000
## 10                                 saudi-arabia          579,925,000
## 11                                    indonesia          563,543,000
## 12                                 south-africa          470,358,000
## 13                                       mexico          463,739,000
## 14                                       brazil          456,670,000
## 15                                    australia          417,870,000
## 16                               united-kingdom          398,084,000
## 17                               turkey-turkiye          391,792,000
## 18                                       france          338,425,000
## 19                                        italy          332,041,000
## 20                                     thailand          305,273,000
## 21                                       poland          304,040,000
## 22                                        spain          280,624,000
## 23                                       taiwan          279,206,000
## 24                         united-arab-emirates          276,236,000
## 25                                   kazakhstan          263,689,000
## 26                                     malaysia          254,764,000
## 27                                      vietnam          249,929,000
## 28                                    singapore          238,983,000
## 29                                        egypt          235,137,000
## 30                                  netherlands          214,416,000
## 31                                     pakistan          193,869,000
## 32                                    argentina          193,205,000
## 33                                      ukraine          185,686,000
## 34                                      algeria          151,633,000
## 35                                         iraq          143,479,000
## 36                                  philippines          142,282,000
## 37                                      belgium          128,247,000
## 38                                        qatar          111,922,000
## 39                                 turkmenistan          109,037,000
## 40                                      nigeria          104,494,000
## 41                                    venezuela          103,708,000
## 42                                   uzbekistan          102,965,000
## 43                                      czechia           99,533,000
## 44                                   bangladesh           96,180,000
## 45                                       kuwait           92,582,000
## 46                                    hong-kong           92,493,000
## 47                                        chile           88,333,000
## 48                                     colombia           81,007,000
## 49                                         oman           76,321,000
## 50                                       greece           70,163,000
## 51                                      romania           68,746,000
## 52                                      austria           65,540,000
## 53                                       israel           61,092,000
## 54                                      morocco           60,200,000
## 55                                         peru           54,996,000
## 56                                      belarus           54,695,000
## 57                                     portugal           50,370,000
## 58                                      hungary           48,589,000
## 59                                       sweden           48,144,000
## 60                                       serbia           47,735,000
## 61                                      bahrain           43,112,000
## 62                                      finland           41,996,000
## 63                                         laos           40,726,000
## 64                                  new-zealand           40,344,000
## 65                          trinidad-and-tobago           39,652,000
## 66                                  switzerland           38,739,000
## 67                                     bulgaria           38,373,000
## 68                                        libya           38,297,000
## 69                                       norway           36,731,000
## 70                                      ecuador           36,051,000
## 71                                      ireland           35,475,000
## 72                                   azerbaijan           35,389,000
## 73                                      denmark           33,850,000
## 74                                     slovakia           32,506,000
## 75                                        burma           31,848,000
## 76                                        syria           26,893,000
## 77                           dominican-republic           26,808,000
## 78                                      lebanon           25,838,000
## 79                                       panama           25,263,000
## 80                                    sri-lanka           23,939,000
## 81                                      tunisia           23,692,000
## 82                                       jordan           23,470,000
## 83                                     mongolia           22,740,000
## 84                                       angola           19,362,000
## 85                                    guatemala           19,041,000
## 86                                  puerto-rico           18,999,000
## 87                                  korea-north           18,465,000
## 88                                        ghana           18,093,000
## 89                                      bolivia           17,786,000
## 90                                        kenya           17,709,000
## 91                                        sudan           17,319,000
## 92                                     ethiopia           16,798,000
## 93                                      croatia           16,752,000
## 94                                         cuba           16,478,000
## 95                       bosnia-and-herzegovina           16,209,000
## 96                                    lithuania           14,503,000
## 97                                    gibraltar           14,256,000
## 98                                     cambodia           13,844,000
## 99                                     slovenia           13,553,000
## 100                                cote-divoire           11,880,000
## 101                                    tanzania           11,491,000
## 102                                  luxembourg           11,308,000
## 103                                     senegal           10,696,000
## 104                                     georgia           10,299,000
## 105                                       yemen           10,158,000
## 106                                     jamaica           10,002,000
## 107                                      brunei            9,956,000
## 108                                       malta            9,576,000
## 109                                    honduras            8,523,000
## 110                                      latvia            8,450,000
## 111                                  costa-rica            8,115,000
## 112                                     moldova            8,114,000
## 113                                      cyprus            8,024,000
## 114                                      kosovo            8,009,000
## 115                                    zimbabwe            7,902,000
## 116                                    paraguay            7,896,000
## 117                                 afghanistan            7,893,000
## 118                                  kyrgyzstan            7,880,000
## 119                                  mozambique            7,753,000
## 120                                       nepal            7,708,000
## 121                                  tajikistan            7,643,000
## 122                                 el-salvador            7,632,000
## 123                             north-macedonia            7,383,000
## 124                                   mauritius            7,191,000
## 125                                    cameroon            7,105,000
## 126                                       benin            6,903,000
## 127                                      zambia            6,798,000
## 128                            papua-new-guinea            6,491,000
## 129                                     uruguay            6,450,000
## 130                                     armenia            6,354,000
## 131                                    botswana            5,965,000
## 132                               new-caledonia            5,886,000
## 133                                      uganda            5,841,000
## 134                                        mali            5,679,000
## 135                                     estonia            4,924,000
## 136                                   nicaragua            4,851,000
## 137                           equatorial-guinea            4,528,000
## 138                       congo-republic-of-the            4,523,000
## 139                                burkina-faso            4,444,000
## 140                                  madagascar            4,218,000
## 141                                  mauritania            4,041,000
## 142                                 bahamas-the            3,984,000
## 143                                     namibia            3,831,000
## 144                                     albania            3,794,000
## 145                                  gaza-strip            3,341,000
## 146                                   west-bank            3,341,000
## 147                                     iceland            3,337,000
## 148                                       haiti            3,139,000
## 149                                      guinea            2,981,000
## 150                                      guyana            2,743,000
## 151            congo-democratic-republic-of-the            2,653,000
## 152                                       gabon            2,651,000
## 153                                  montenegro            2,447,000
## 154                              virgin-islands            2,438,000
## 155                                       niger            2,374,000
## 156                                    suriname            2,372,000
## 157                                    maldives            2,286,000
## 158                                        togo            2,244,000
## 159                                       macau            2,012,000
## 160                                        guam            1,828,000
## 161                                 south-sudan            1,778,000
## 162                                        chad            1,771,000
## 163                                    barbados            1,703,000
## 164                                        fiji            1,691,000
## 165                                      malawi            1,542,000
## 166                                     liberia            1,346,000
## 167                                 wake-island            1,275,000
## 168                                       aruba            1,254,000
## 169                                    eswatini            1,224,000
## 170                                      rwanda            1,189,000
## 171                                  seychelles            1,156,000
## 172                            french-polynesia            1,030,000
## 173                                  cabo-verde            1,002,000
## 174                                      bhutan              934,000
## 175                                sierra-leone              899,000
## 176                                     somalia              882,000
## 177                               faroe-islands              870,000
## 178                              cayman-islands              808,000
## 179                                     eritrea              798,000
## 180                                     bermuda              796,000
## 181                                     lesotho              736,000
## 182                         antigua-and-barbuda              729,000
## 183                                     burundi              715,000
## 184                                 saint-lucia              659,000
## 185                                    djibouti              610,000
## 186                                  gambia-the              606,000
## 187                                   greenland              605,000
## 188                                      belize              541,000
## 189                                 timor-leste              538,000
## 190                                      jersey              450,000
## 191                                       samoa              355,000
## 192                              american-samoa              355,000
## 193                               guinea-bissau              342,000
## 194                             solomon-islands              333,000
## 195                                     comoros              326,000
## 196                                     grenada              316,000
## 197                            marshall-islands              293,700
## 198                    central-african-republic              285,000
## 199                       saint-kitts-and-nevis              268,000
## 200                    turks-and-caicos-islands              245,000
## 201                                     vanuatu              225,000
## 202            saint-vincent-and-the-grenadines              202,000
## 203                                    dominica              182,000
## 204              micronesia-federated-states-of              177,000
## 205                      british-virgin-islands              173,000
## 206                       sao-tome-and-principe              173,000
## 207                                       tonga              171,000
## 208                                cook-islands              114,000
## 209                   saint-pierre-and-miquelon               84,000
## 210                                    kiribati               76,000
## 211                                       nauru               66,000
## 212             falkland-islands-islas-malvinas               46,000
## 213                                  montserrat               33,000
## 214                                  antarctica               28,000
## 215 saint-helena-ascension-and-tristan-da-cunha               13,000
## 216                                        niue                8,000
## 217                    northern-mariana-islands                    0
## 218                                      tuvalu                    0
##     date_of_information ranking                            region
## 1                  2019       1           East and Southeast Asia
## 2                  2019       2                     North America
## 3                  2019       3                        South Asia
## 4                  2019       4                      Central Asia
## 5                  2019       5           East and Southeast Asia
## 6                  2019       6                            Europe
## 7                  2019       7           East and Southeast Asia
## 8                  2019       8                       Middle East
## 9                  2019       9                     North America
## 10                 2019      10                       Middle East
## 11                 2019      11           East and Southeast Asia
## 12                 2019      12                            Africa
## 13                 2019      13                     North America
## 14                 2019      14                     South America
## 15                 2019      15             Australia and Oceania
## 16                 2019      16                            Europe
## 17                 2019      17                       Middle East
## 18                 2019      18                            Europe
## 19                 2019      19                            Europe
## 20                 2019      20           East and Southeast Asia
## 21                 2019      21                            Europe
## 22                 2019      22                            Europe
## 23                 2019      23           East and Southeast Asia
## 24                 2019      24                       Middle East
## 25                 2019      25                      Central Asia
## 26                 2019      26           East and Southeast Asia
## 27                 2019      27           East and Southeast Asia
## 28                 2019      28           East and Southeast Asia
## 29                 2019      29                            Africa
## 30                 2019      30                            Europe
## 31                 2019      31                        South Asia
## 32                 2019      32                     South America
## 33                 2019      33                            Europe
## 34                 2019      34                            Africa
## 35                 2019      35                       Middle East
## 36                 2019      36           East and Southeast Asia
## 37                 2019      37                            Europe
## 38                 2019      38                       Middle East
## 39                 2019      39                      Central Asia
## 40                 2019      40                            Africa
## 41                 2019      41                     South America
## 42                 2019      42                      Central Asia
## 43                 2019      43                            Europe
## 44                 2019      44                        South Asia
## 45                 2019      45                       Middle East
## 46                 2019      46           East and Southeast Asia
## 47                 2019      47                     South America
## 48                 2019      48                     South America
## 49                 2019      49                       Middle East
## 50                 2019      50                            Europe
## 51                 2019      51                            Europe
## 52                 2019      52                            Europe
## 53                 2019      53                       Middle East
## 54                 2019      54                            Africa
## 55                 2019      55                     South America
## 56                 2019      56                            Europe
## 57                 2019      57                            Europe
## 58                 2019      58                            Europe
## 59                 2019      59                            Europe
## 60                 2019      60                            Europe
## 61                 2019      61                       Middle East
## 62                 2019      62                            Europe
## 63                 2019      63           East and Southeast Asia
## 64                 2019      64             Australia and Oceania
## 65                 2019      65 Central America and the Caribbean
## 66                 2019      66                            Europe
## 67                 2019      67                            Europe
## 68                 2019      68                            Africa
## 69                 2019      69                            Europe
## 70                 2019      70                     South America
## 71                 2019      71                            Europe
## 72                 2019      72                       Middle East
## 73                 2019      73                            Europe
## 74                 2019      74                            Europe
## 75                 2019      75           East and Southeast Asia
## 76                 2019      76                       Middle East
## 77                 2019      77 Central America and the Caribbean
## 78                 2019      78                       Middle East
## 79                 2019      79 Central America and the Caribbean
## 80                 2019      80                        South Asia
## 81                 2019      81                            Africa
## 82                 2019      82                       Middle East
## 83                 2019      83           East and Southeast Asia
## 84                 2019      84                            Africa
## 85                 2019      85 Central America and the Caribbean
## 86                 2019      86 Central America and the Caribbean
## 87                 2019      87           East and Southeast Asia
## 88                 2019      88                            Africa
## 89                 2019      89                     South America
## 90                 2019      90                            Africa
## 91                 2019      91                            Africa
## 92                 2019      92                            Africa
## 93                 2019      93                            Europe
## 94                 2019      94 Central America and the Caribbean
## 95                 2019      95                            Europe
## 96                 2019      96                            Europe
## 97                 2019      97                            Europe
## 98                 2019      98           East and Southeast Asia
## 99                 2019      99                            Europe
## 100                2019     100                            Africa
## 101                2019     101                            Africa
## 102                2019     102                            Europe
## 103                2019     103                            Africa
## 104                2019     104                       Middle East
## 105                2019     105                       Middle East
## 106                2019     106 Central America and the Caribbean
## 107                2019     107           East and Southeast Asia
## 108                2019     108                            Europe
## 109                2019     109 Central America and the Caribbean
## 110                2019     110                            Europe
## 111                2019     111 Central America and the Caribbean
## 112                2019     112                            Europe
## 113                2019     113                            Europe
## 114                2019     114                            Europe
## 115                2019     115                            Africa
## 116                2019     116                     South America
## 117                2019     117                        South Asia
## 118                2019     118                      Central Asia
## 119                2019     119                            Africa
## 120                2019     120                        South Asia
## 121                2019     121                      Central Asia
## 122                2019     122 Central America and the Caribbean
## 123                2019     123                            Europe
## 124                2019     124                            Africa
## 125                2019     125                            Africa
## 126                2019     126                            Africa
## 127                2019     127                            Africa
## 128                2019     128           East and Southeast Asia
## 129                2019     129                     South America
## 130                2019     130                       Middle East
## 131                2019     131                            Africa
## 132                2019     132             Australia and Oceania
## 133                2019     133                            Africa
## 134                2019     134                            Africa
## 135                2019     135                            Europe
## 136                2019     136 Central America and the Caribbean
## 137                2019     137                            Africa
## 138                2019     138                            Africa
## 139                2019     139                            Africa
## 140                2019     140                            Africa
## 141                2019     141                            Africa
## 142                2019     142 Central America and the Caribbean
## 143                2019     143                            Africa
## 144                2019     144                            Europe
## 145                2019     145                       Middle East
## 146                2019     146                       Middle East
## 147                2019     147                            Europe
## 148                2019     148 Central America and the Caribbean
## 149                2019     149                            Africa
## 150                2019     150                     South America
## 151                2019     151                            Africa
## 152                2019     152                            Africa
## 153                2019     153                            Europe
## 154                2019     154 Central America and the Caribbean
## 155                2019     155                            Africa
## 156                2019     156                     South America
## 157                2019     157                        South Asia
## 158                2019     158                            Africa
## 159                2019     159           East and Southeast Asia
## 160                2019     160             Australia and Oceania
## 161                2019     161                            Africa
## 162                2019     162                            Africa
## 163                2019     163 Central America and the Caribbean
## 164                2019     164             Australia and Oceania
## 165                2019     165                            Africa
## 166                2019     166                            Africa
## 167                2019     167             Australia and Oceania
## 168                2019     168 Central America and the Caribbean
## 169                2019     169                            Africa
## 170                2019     170                            Africa
## 171                2019     171                            Africa
## 172                2019     172             Australia and Oceania
## 173                2019     173                            Africa
## 174                2019     174                        South Asia
## 175                2019     175                            Africa
## 176                2019     176                            Africa
## 177                2019     177                            Europe
## 178                2019     178 Central America and the Caribbean
## 179                2019     179                            Africa
## 180                2019     180                     North America
## 181                2019     181                            Africa
## 182                2019     182 Central America and the Caribbean
## 183                2019     183                            Africa
## 184                2019     184 Central America and the Caribbean
## 185                2019     185                            Africa
## 186                2019     186                            Africa
## 187                2019     187                     North America
## 188                2019     188 Central America and the Caribbean
## 189                2019     189           East and Southeast Asia
## 190                2012     190                            Europe
## 191                2019     191             Australia and Oceania
## 192                2019     192             Australia and Oceania
## 193                2019     193                            Africa
## 194                2019     194             Australia and Oceania
## 195                2019     195                            Africa
## 196                2019     196 Central America and the Caribbean
## 197                2017     197             Australia and Oceania
## 198                2019     198                            Africa
## 199                2019     199 Central America and the Caribbean
## 200                2019     200 Central America and the Caribbean
## 201                2019     201             Australia and Oceania
## 202                2019     202 Central America and the Caribbean
## 203                2019     203 Central America and the Caribbean
## 204                2019     204             Australia and Oceania
## 205                2019     205 Central America and the Caribbean
## 206                2019     206                            Africa
## 207                2019     207             Australia and Oceania
## 208                2019     208             Australia and Oceania
## 209                2019     209                     North America
## 210                2019     210             Australia and Oceania
## 211                2019     211             Australia and Oceania
## 212                2019     212                     South America
## 213                2019     213 Central America and the Caribbean
## 214                2019     214                        Antarctica
## 215                2019     215                            Africa
## 216                2019     216             Australia and Oceania
## 217                2019     217             Australia and Oceania
## 218                2019     218             Australia and Oceania
data101 <- data10[, c('metric tonnes of CO2', 'region')]

head(data101)
##   metric tonnes of CO2                  region
## 1       10,773,248,000 East and Southeast Asia
## 2        5,144,361,000           North America
## 3        2,314,738,000              South Asia
## 4        1,848,070,000            Central Asia
## 5        1,103,234,000 East and Southeast Asia
## 6          726,881,000                  Europe
library(rio)
data11= import("Broadband - fixed subscriptions.csv")
data11
##                                              name
## 1                                           China
## 2                                   United States
## 3                                           Japan
## 4                                          Brazil
## 5                                         Germany
## 6                                          Russia
## 7                                          France
## 8                                  United Kingdom
## 9                                           India
## 10                                   Korea, South
## 11                                         Mexico
## 12                                          Italy
## 13                               Turkey (Turkiye)
## 14                                        Vietnam
## 15                                          Spain
## 16                                         Canada
## 17                                      Indonesia
## 18                                       Thailand
## 19                                     Bangladesh
## 20                                      Argentina
## 21                                           Iran
## 22                                          Egypt
## 23                                      Australia
## 24                                         Poland
## 25                                    Philippines
## 26                                   Saudi Arabia
## 27                                        Ukraine
## 28                                       Colombia
## 29                                    Netherlands
## 30                                           Iraq
## 31                                         Taiwan
## 32                                        Romania
## 33                                     Uzbekistan
## 34                                        Belgium
## 35                                         Greece
## 36                                         Sweden
## 37                                       Portugal
## 38                                    Switzerland
## 39                                        Czechia
## 40                                        Algeria
## 41                                          Chile
## 42                                        Hungary
## 43                                       Malaysia
## 44                                        Belarus
## 45                           United Arab Emirates
## 46                                           Peru
## 47                                      Hong Kong
## 48                                     Kazakhstan
## 49                                        Austria
## 50                                         Israel
## 51                                        Denmark
## 52                                      Venezuela
## 53                                       Pakistan
## 54                                         Norway
## 55                                        Ecuador
## 56                                       Bulgaria
## 57                                        Morocco
## 58                                     Azerbaijan
## 59                                        Finland
## 60                                      Sri Lanka
## 61                                    New Zealand
## 62                                         Serbia
## 63                                       Slovakia
## 64                                          Syria
## 65                                        Ireland
## 66                                      Singapore
## 67                                        Tunisia
## 68                                   South Africa
## 69                                          Nepal
## 70                                       Tanzania
## 71                                        Uruguay
## 72                             Dominican Republic
## 73                                        Croatia
## 74                                     Costa Rica
## 75                                        Georgia
## 76                                        Bolivia
## 77                                      Lithuania
## 78                         Bosnia and Herzegovina
## 79                                       Cameroon
## 80                                        Moldova
## 81                                          Burma
## 82                                          Kenya
## 83                                    Puerto Rico
## 84                                       Slovenia
## 85                                         Jordan
## 86                                      Guatemala
## 87                                    El Salvador
## 88                                         Panama
## 89                                       Paraguay
## 90                                           Oman
## 91                                        Albania
## 92                                         Latvia
## 93                                North Macedonia
## 94                                        Lebanon
## 95                                        Armenia
## 96                                        Estonia
## 97                                       Honduras
## 98                                          Yemen
## 99                                        Jamaica
## 100                                    Gaza Strip
## 101                           Trinidad and Tobago
## 102                                     West Bank
## 103                                        Cyprus
## 104                                         Libya
## 105                                     Mauritius
## 106                                      Mongolia
## 107                                         Qatar
## 108                                     Nicaragua
## 109                                    Kyrgyzstan
## 110                                 Cote d'Ivoire
## 111                                      Botswana
## 112                                          Mali
## 113                                    Luxembourg
## 114                                      Cambodia
## 115                                          Cuba
## 116                                        Angola
## 117                                         Malta
## 118                                      Ethiopia
## 119                                         Macau
## 120                                      Zimbabwe
## 121                                    Montenegro
## 122                                       Senegal
## 123                                       Bahrain
## 124                                       Iceland
## 125                                      Barbados
## 126                                          Laos
## 127                                       Somalia
## 128                                        Guyana
## 129                                      Suriname
## 130                                  Bahamas, The
## 131                                        Zambia
## 132                                         Ghana
## 133                                        Kuwait
## 134                                        Brunei
## 135                                       Namibia
## 136                                    Mozambique
## 137                                       Nigeria
## 138                              French Polynesia
## 139                                      Maldives
## 140                                        Uganda
## 141                                       Curacao
## 142                                 New Caledonia
## 143                                          Togo
## 144                                         Gabon
## 145                                        Jersey
## 146                                       Andorra
## 147                                        Belize
## 148                                    Seychelles
## 149                                   Saint Lucia
## 150                                       Grenada
## 151                                    Madagascar
## 152                                         Haiti
## 153             Congo, Democratic Republic of the
## 154                         Saint Kitts and Nevis
## 155                                         Benin
## 156                                         Sudan
## 157                                   Afghanistan
## 158                                      Guernsey
## 159                                      Djibouti
## 160                                    Cabo Verde
## 161              Saint Vincent and the Grenadines
## 162                                          Fiji
## 163                                       Bermuda
## 164                                     Gibraltar
## 165                              Papua New Guinea
## 166                                        Monaco
## 167                                         Aruba
## 168                                    Mauritania
## 169                                 Faroe Islands
## 170                                 Liechtenstein
## 171                                        Rwanda
## 172                                      Dominica
## 173                                     Greenland
## 174                                  Burkina Faso
## 175                                       Liberia
## 176                                        Malawi
## 177                                         Niger
## 178                                      Eswatini
## 179                                    San Marino
## 180                                  Turkmenistan
## 181                           Antigua and Barbuda
## 182                        British Virgin Islands
## 183               Micronesia, Federated States of
## 184                                    Tajikistan
## 185                                       Lesotho
## 186                                      Anguilla
## 187                                   Gambia, The
## 188                                         Tonga
## 189                                       Eritrea
## 190                                       Burundi
## 191                                Cayman Islands
## 192                                        Bhutan
## 193                                          Guam
## 194                                       Vanuatu
## 195                                  Cook Islands
## 196                                    Montserrat
## 197                         Sao Tome and Principe
## 198                                 Guinea-Bissau
## 199                                         Samoa
## 200                                         Palau
## 201                                       Comoros
## 202                             Equatorial Guinea
## 203                                        Guinea
## 204                        Congo, Republic of the
## 205 Saint Helena, Ascension, and Tristan da Cunha
## 206                               Solomon Islands
## 207                              Marshall Islands
## 208             Falkland Islands (Islas Malvinas)
## 209                                         Nauru
## 210                      Central African Republic
## 211                                        Tuvalu
## 212                                   South Sudan
## 213                                      Kiribati
## 214                                   Timor-Leste
##                                            slug       value date_of_information
## 1                                         china 483,549,500                2020
## 2                                 united-states 121,176,000                2020
## 3                                         japan  44,000,791                2020
## 4                                        brazil  36,344,670                2020
## 5                                       germany  36,215,303                2020
## 6                                        russia  33,893,305                2020
## 7                                        france  30,627,000                2020
## 8                                united-kingdom  27,330,297                2020
## 9                                         india  22,950,000                2020
## 10                                  korea-south  22,327,182                2020
## 11                                       mexico  21,936,131                2020
## 12                                        italy  18,128,787                2020
## 13                               turkey-turkiye  16,734,853                2020
## 14                                      vietnam  16,699,249                2020
## 15                                        spain  16,188,502                2020
## 16                                       canada  15,825,813                2020
## 17                                    indonesia  11,722,218                2020
## 18                                     thailand  11,478,265                2020
## 19                                   bangladesh  10,052,819                2020
## 20                                    argentina   9,571,562                2020
## 21                                         iran   9,564,195                2020
## 22                                        egypt   9,349,469                2020
## 23                                    australia   9,099,619                2020
## 24                                       poland   8,369,218                2020
## 25                                  philippines   7,936,574                2020
## 26                                 saudi-arabia   7,890,261                2020
## 27                                      ukraine   7,769,401                2020
## 28                                     colombia   7,764,772                2020
## 29                                  netherlands   7,525,016                2020
## 30                                         iraq   6,254,099                2020
## 31                                       taiwan   5,831,470                2019
## 32                                      romania   5,684,782                2020
## 33                                   uzbekistan   4,820,009                2020
## 34                                      belgium   4,734,210                2020
## 35                                       greece   4,257,026                2020
## 36                                       sweden   4,179,574                2020
## 37                                     portugal   4,160,795                2020
## 38                                  switzerland   4,028,238                2020
## 39                                      czechia   3,845,426                2020
## 40                                      algeria   3,790,459                2020
## 41                                        chile   3,763,826                2020
## 42                                      hungary   3,382,136                2021
## 43                                     malaysia   3,358,800                2020
## 44                                      belarus   3,255,552                2020
## 45                         united-arab-emirates   3,245,123                2020
## 46                                         peru   3,044,000                2020
## 47                                    hong-kong   2,885,586                2020
## 48                                   kazakhstan   2,620,400                2020
## 49                                      austria   2,606,000                2020
## 50                                       israel   2,602,079                2020
## 51                                      denmark   2,590,282                2020
## 52                                    venezuela   2,561,556                2020
## 53                                     pakistan   2,523,027                2020
## 54                                       norway   2,387,661                2020
## 55                                      ecuador   2,371,297                2020
## 56                                     bulgaria   2,115,053                2020
## 57                                      morocco   2,102,434                2020
## 58                                   azerbaijan   1,995,474                2020
## 59                                      finland   1,846,000                2020
## 60                                    sri-lanka   1,781,530                2020
## 61                                  new-zealand   1,764,984                2020
## 62                                       serbia   1,730,496                2020
## 63                                     slovakia   1,701,561                2020
## 64                                        syria   1,549,356                2020
## 65                                      ireland   1,516,473                2020
## 66                                    singapore   1,509,700                2020
## 67                                      tunisia   1,334,059                2020
## 68                                 south-africa   1,303,057                2020
## 69                                        nepal   1,270,000                2020
## 70                                     tanzania   1,135,608                2020
## 71                                      uruguay   1,063,701                2020
## 72                           dominican-republic   1,031,858                2020
## 73                                      croatia   1,030,973                2020
## 74                                   costa-rica     992,725                2020
## 75                                      georgia     986,809                2021
## 76                                      bolivia     931,918                2020
## 77                                    lithuania     796,814                2020
## 78                       bosnia-and-herzegovina     770,424                2020
## 79                                     cameroon     722,579                2020
## 80                                      moldova     719,001                2020
## 81                                        burma     688,185                2020
## 82                                        kenya     674,191                2020
## 83                                  puerto-rico     671,284                2020
## 84                                     slovenia     651,604                2020
## 85                                       jordan     630,545                2020
## 86                                    guatemala     612,000                2020
## 87                                  el-salvador     586,000                2020
## 88                                       panama     562,413                2020
## 89                                     paraguay     562,369                2020
## 90                                         oman     508,949                2020
## 91                                      albania     508,937                2020
## 92                                       latvia     490,569                2020
## 93                              north-macedonia     475,569                2020
## 94                                      lebanon     432,070                2020
## 95                                      armenia     430,407                2020
## 96                                      estonia     415,610                2020
## 97                                     honduras     396,916                2020
## 98                                        yemen     391,000                2020
## 99                                      jamaica     385,603                2020
## 100                                  gaza-strip     376,911                2020
## 101                         trinidad-and-tobago     376,771                2020
## 102                                   west-bank     373,050                2020
## 103                                      cyprus     332,080                2020
## 104                                       libya     332,000                2020
## 105                                   mauritius     323,200                2020
## 106                                    mongolia     307,166                2020
## 107                                       qatar     296,126                2020
## 108                                   nicaragua     290,351                2020
## 109                                  kyrgyzstan     289,000                2020
## 110                                cote-divoire     260,097                2020
## 111                                    botswana     259,525                2020
## 112                                        mali     243,806                2020
## 113                                  luxembourg     235,155                2020
## 114                                    cambodia     233,732                2020
## 115                                        cuba     231,654                2020
## 116                                      angola     230,610                2020
## 117                                       malta     213,419                2020
## 118                                    ethiopia     212,000                2020
## 119                                       macau     208,000                2020
## 120                                    zimbabwe     203,461                2020
## 121                                  montenegro     184,176                2020
## 122                                     senegal     153,813                2020
## 123                                     bahrain     148,928                2020
## 124                                     iceland     141,816                2020
## 125                                    barbados     128,000                2020
## 126                                        laos     128,000                2020
## 127                                     somalia     119,000                2020
## 128                                      guyana      95,000                2020
## 129                                    suriname      92,270                2020
## 130                                 bahamas-the      83,000                2020
## 131                                      zambia      82,317                2020
## 132                                       ghana      78,371                2020
## 133                                      kuwait      73,948                2020
## 134                                      brunei      71,078                2020
## 135                                     namibia      71,063                2020
## 136                                  mozambique      70,000                2020
## 137                                     nigeria      65,313                2020
## 138                            french-polynesia      64,000                2020
## 139                                    maldives      63,685                2020
## 140                                      uganda      58,594                2020
## 141                                     curacao      55,000                2020
## 142                               new-caledonia      55,000                2020
## 143                                        togo      52,706                2020
## 144                                       gabon      44,607                2020
## 145                                      jersey      39,699                2020
## 146                                     andorra      37,000                2020
## 147                                      belize      36,000                2020
## 148                                  seychelles      34,966                2020
## 149                                 saint-lucia      33,000                2020
## 150                                     grenada      32,000                2020
## 151                                  madagascar      32,000                2020
## 152                                       haiti      31,000                2020
## 153            congo-democratic-republic-of-the      31,000                2020
## 154                       saint-kitts-and-nevis      30,000                2020
## 155                                       benin      29,981                2020
## 156                                       sudan      28,782                2020
## 157                                 afghanistan      26,570                2020
## 158                                    guernsey      25,336                2020
## 159                                    djibouti      25,053                2020
## 160                                  cabo-verde      24,839                2020
## 161            saint-vincent-and-the-grenadines      24,733                2020
## 162                                        fiji      23,062                2020
## 163                                     bermuda      23,000                2020
## 164                                   gibraltar      21,009                2020
## 165                            papua-new-guinea      21,000                2020
## 166                                      monaco      20,877                2020
## 167                                       aruba      19,000                2020
## 168                                  mauritania      18,457                2020
## 169                               faroe-islands      18,443                2020
## 170                               liechtenstein      18,050                2020
## 171                                      rwanda      17,685                2020
## 172                                    dominica      16,000                2020
## 173                                   greenland      15,649                2020
## 174                                burkina-faso      13,979                2020
## 175                                     liberia      13,000                2020
## 176                                      malawi      12,255                2020
## 177                                       niger      12,000                2020
## 178                                    eswatini      12,000                2020
## 179                                  san-marino      11,000                2020
## 180                                turkmenistan      10,000                2020
## 181                         antigua-and-barbuda       8,000                2020
## 182                      british-virgin-islands       6,738                2020
## 183              micronesia-federated-states-of       6,000                2020
## 184                                  tajikistan       6,000                2020
## 185                                     lesotho       5,060                2020
## 186                                    anguilla       5,000               2018 
## 187                                  gambia-the       5,000                2020
## 188                                       tonga       5,000                2020
## 189                                     eritrea       5,000                2020
## 190                                     burundi       4,230                2020
## 191                              cayman-islands       3,200                2020
## 192                                      bhutan       3,189                2020
## 193                                        guam       3,000                2020
## 194                                     vanuatu       2,785                2020
## 195                                cook-islands       2,700                2018
## 196                                  montserrat       2,700                2018
## 197                       sao-tome-and-principe       2,512                2020
## 198                               guinea-bissau       2,383                2020
## 199                                       samoa       1,692                2020
## 200                                       palau       1,224                2015
## 201                                     comoros       1,066                2020
## 202                           equatorial-guinea       1,000                2020
## 203                                      guinea       1,000                2020
## 204                       congo-republic-of-the       1,000                2020
## 205 saint-helena-ascension-and-tristan-da-cunha       1,000                2018
## 206                             solomon-islands       1,000                2020
## 207                            marshall-islands       1,000                2020
## 208             falkland-islands-islas-malvinas       1,000                2020
## 209                                       nauru         950                2010
## 210                    central-african-republic         499                2019
## 211                                      tuvalu         450                2017
## 212                                 south-sudan         200                2019
## 213                                    kiribati         185                2020
## 214                                 timor-leste          75                2020
##     ranking                            region
## 1         1           East and Southeast Asia
## 2         2                     North America
## 3         3           East and Southeast Asia
## 4         4                     South America
## 5         5                            Europe
## 6         6                      Central Asia
## 7         7                            Europe
## 8         8                            Europe
## 9         9                        South Asia
## 10       10           East and Southeast Asia
## 11       11                     North America
## 12       12                            Europe
## 13       13                       Middle East
## 14       14           East and Southeast Asia
## 15       15                            Europe
## 16       16                     North America
## 17       17           East and Southeast Asia
## 18       18           East and Southeast Asia
## 19       19                        South Asia
## 20       20                     South America
## 21       21                       Middle East
## 22       22                            Africa
## 23       23             Australia and Oceania
## 24       24                            Europe
## 25       25           East and Southeast Asia
## 26       26                       Middle East
## 27       27                            Europe
## 28       28                     South America
## 29       29                            Europe
## 30       30                       Middle East
## 31       31           East and Southeast Asia
## 32       32                            Europe
## 33       33                      Central Asia
## 34       34                            Europe
## 35       35                            Europe
## 36       36                            Europe
## 37       37                            Europe
## 38       38                            Europe
## 39       39                            Europe
## 40       40                            Africa
## 41       41                     South America
## 42       42                            Europe
## 43       43           East and Southeast Asia
## 44       44                            Europe
## 45       45                       Middle East
## 46       46                     South America
## 47       47           East and Southeast Asia
## 48       48                      Central Asia
## 49       49                            Europe
## 50       50                       Middle East
## 51       51                            Europe
## 52       52                     South America
## 53       53                        South Asia
## 54       54                            Europe
## 55       55                     South America
## 56       56                            Europe
## 57       57                            Africa
## 58       58                       Middle East
## 59       59                            Europe
## 60       60                        South Asia
## 61       61             Australia and Oceania
## 62       62                            Europe
## 63       63                            Europe
## 64       64                       Middle East
## 65       65                            Europe
## 66       66           East and Southeast Asia
## 67       67                            Africa
## 68       68                            Africa
## 69       69                        South Asia
## 70       70                            Africa
## 71       71                     South America
## 72       72 Central America and the Caribbean
## 73       73                            Europe
## 74       74 Central America and the Caribbean
## 75       75                       Middle East
## 76       76                     South America
## 77       77                            Europe
## 78       78                            Europe
## 79       79                            Africa
## 80       80                            Europe
## 81       81           East and Southeast Asia
## 82       82                            Africa
## 83       83 Central America and the Caribbean
## 84       84                            Europe
## 85       85                       Middle East
## 86       86 Central America and the Caribbean
## 87       87 Central America and the Caribbean
## 88       88 Central America and the Caribbean
## 89       89                     South America
## 90       90                       Middle East
## 91       91                            Europe
## 92       92                            Europe
## 93       93                            Europe
## 94       94                       Middle East
## 95       95                       Middle East
## 96       96                            Europe
## 97       97 Central America and the Caribbean
## 98       98                       Middle East
## 99       99 Central America and the Caribbean
## 100     100                       Middle East
## 101     101 Central America and the Caribbean
## 102     102                       Middle East
## 103     103                            Europe
## 104     104                            Africa
## 105     105                            Africa
## 106     106           East and Southeast Asia
## 107     107                       Middle East
## 108     108 Central America and the Caribbean
## 109     109                      Central Asia
## 110     110                            Africa
## 111     111                            Africa
## 112     112                            Africa
## 113     113                            Europe
## 114     114           East and Southeast Asia
## 115     115 Central America and the Caribbean
## 116     116                            Africa
## 117     117                            Europe
## 118     118                            Africa
## 119     119           East and Southeast Asia
## 120     120                            Africa
## 121     121                            Europe
## 122     122                            Africa
## 123     123                       Middle East
## 124     124                            Europe
## 125     125 Central America and the Caribbean
## 126     126           East and Southeast Asia
## 127     127                            Africa
## 128     128                     South America
## 129     129                     South America
## 130     130 Central America and the Caribbean
## 131     131                            Africa
## 132     132                            Africa
## 133     133                       Middle East
## 134     134           East and Southeast Asia
## 135     135                            Africa
## 136     136                            Africa
## 137     137                            Africa
## 138     138             Australia and Oceania
## 139     139                        South Asia
## 140     140                            Africa
## 141     141 Central America and the Caribbean
## 142     142             Australia and Oceania
## 143     143                            Africa
## 144     144                            Africa
## 145     145                            Europe
## 146     146                            Europe
## 147     147 Central America and the Caribbean
## 148     148                            Africa
## 149     149 Central America and the Caribbean
## 150     150 Central America and the Caribbean
## 151     151                            Africa
## 152     152 Central America and the Caribbean
## 153     153                            Africa
## 154     154 Central America and the Caribbean
## 155     155                            Africa
## 156     156                            Africa
## 157     157                        South Asia
## 158     158                            Europe
## 159     159                            Africa
## 160     160                            Africa
## 161     161 Central America and the Caribbean
## 162     162             Australia and Oceania
## 163     163                     North America
## 164     164                            Europe
## 165     165           East and Southeast Asia
## 166     166                            Europe
## 167     167 Central America and the Caribbean
## 168     168                            Africa
## 169     169                            Europe
## 170     170                            Europe
## 171     171                            Africa
## 172     172 Central America and the Caribbean
## 173     173                     North America
## 174     174                            Africa
## 175     175                            Africa
## 176     176                            Africa
## 177     177                            Africa
## 178     178                            Africa
## 179     179                            Europe
## 180     180                      Central Asia
## 181     181 Central America and the Caribbean
## 182     182 Central America and the Caribbean
## 183     183             Australia and Oceania
## 184     184                      Central Asia
## 185     185                            Africa
## 186     186 Central America and the Caribbean
## 187     187                            Africa
## 188     188             Australia and Oceania
## 189     189                            Africa
## 190     190                            Africa
## 191     191 Central America and the Caribbean
## 192     192                        South Asia
## 193     193             Australia and Oceania
## 194     194             Australia and Oceania
## 195     195             Australia and Oceania
## 196     196 Central America and the Caribbean
## 197     197                            Africa
## 198     198                            Africa
## 199     199             Australia and Oceania
## 200     200             Australia and Oceania
## 201     201                            Africa
## 202     202                            Africa
## 203     203                            Africa
## 204     204                            Africa
## 205     205                            Africa
## 206     206             Australia and Oceania
## 207     207             Australia and Oceania
## 208     208                     South America
## 209     209             Australia and Oceania
## 210     210                            Africa
## 211     211             Australia and Oceania
## 212     212                            Africa
## 213     213             Australia and Oceania
## 214     214           East and Southeast Asia
data111 <- data11[, c('value', 'region')]

head(data111)
##         value                  region
## 1 483,549,500 East and Southeast Asia
## 2 121,176,000           North America
## 3  44,000,791 East and Southeast Asia
## 4  36,344,670           South America
## 5  36,215,303                  Europe
## 6  33,893,305            Central Asia