Import data
# csv file
map <- read.csv("../00_data/Worldmap - Sheet1.csv")
map
## X. Country Population Continents Land.Area.Km2
## 1 1 India 1,463,865,525 Asia 2,973,190
## 2 2 China 1,416,096,094 Asia 9,388,211
## 3 3 United States 347,275,807 North America 9,147,420
## 4 4 Indonesia 285,721,236 Asia 1,811,570
## 5 5 Pakistan 255,219,554 Asia 770,880
## 6 6 Nigeria 237,527,782 Africa 910,770
## 7 7 Brazil 212,812,405 South America 8,358,140
## 8 8 Bangladesh 175,686,899 Asia 130,170
## 9 9 Russia 143,997,393 Europe/Asia 16,376,870
## 10 10 Ethiopia 135,472,051 Africa 1,000,000
## 11 11 Mexico 131,946,900 North America 1,943,950
## 12 12 Japan 123,103,479 Asia 364,555
## 13 13 Egypt 118,365,995 Africa 995,450
## 14 14 Philippines 116,786,962 Asia 298,170
## 15 15 DR Congo 112,832,473 Africa 2,267,050
## 16 16 Vietnam 101,598,527 Asia 310,070
## 17 17 Iran 92,417,681 Asia 1,628,550
## 18 18 Turkey 87,685,426 Europe/Asia 769,630
## 19 19 Germany 84,075,075 Europe 348,560
## 20 20 Thailand 71,619,863 Asia 510,890
## 21 21 Tanzania 70,545,865 Africa 885,800
## 22 22 United Kingdom 69,551,332 Europe 241,930
## 23 23 France 66,650,804 Europe 547,557
## 24 24 South Africa 64,747,319 Africa 1,213,090
## 25 25 Italy 59,146,260 Europe 294,140
## 26 26 Kenya 57,532,493 Africa 569,140
## 27 27 Myanmar 54,850,648 Asia 653,290
## 28 28 Colombia 53,425,635 South America 1,109,500
## 29 29 South Korea 51,667,029 Asia 97,230
## 30 30 Sudan 51,662,147 Africa 1,765,048
## 31 31 Uganda 51,384,894 Africa 199,810
## 32 32 Spain 47,889,958 Europe 498,800
## 33 33 Algeria 47,435,312 Africa 2,381,740
## 34 34 Iraq 47,020,774 Asia 434,320
## 35 35 Argentina 45,851,378 South America 2,736,690
## 36 36 Afghanistan 43,844,111 Asia 652,860
## 37 37 Yemen 41,773,878 Asia 527,970
## 38 38 Canada 40,126,723 North America 9,093,510
## 39 39 Angola 39,040,039 Africa 1,246,700
## 40 40 Ukraine 38,980,376 Europe 579,320
## 41 41 Morocco 38,430,770 Africa 446,300
## 42 42 Poland 38,140,910 Europe 306,230
## 43 43 Uzbekistan 37,053,428 Asia 425,400
## 44 44 Malaysia 35,977,838 Asia 328,550
## 45 45 Mozambique 35,631,653 Africa 786,380
## 46 46 Ghana 35,064,272 Africa 227,540
## 47 47 Peru 34,576,665 South America 1,280,000
## 48 48 Saudi Arabia 34,566,328 Asia 2,149,690
## 49 49 Madagascar 32,740,678 Africa 581,795
## 50 50 Côte d'Ivoire 32,711,547 Africa 318,000
## 51 51 Cameroon 29,879,337 Africa 472,710
## 52 52 Nepal 29,618,118 Asia 143,350
## 53 53 Venezuela 28,516,896 South America 882,050
## 54 54 Niger 27,917,831 Africa 1,266,700
## 55 55 Australia 26,974,026 Oceania 7,682,300
## 56 56 North Korea 26,571,036 Asia 120,410
## 57 57 Syria 25,620,427 Asia 183,630
## 58 58 Mali 25,198,821 Africa 1,220,190
## 59 59 Burkina Faso 24,074,580 Africa 273,600
## 60 60 Sri Lanka 23,229,470 Asia 62,710
## 61 61 Taiwan 23,112,793 Asia 35,410
## 62 62 Malawi 22,216,120 Africa 94,280
## 63 63 Zambia 21,913,874 Africa 743,390
## 64 64 Chad 21,003,705 Africa 1,259,200
## 65 65 Kazakhstan 20,843,754 Africa 2,699,700
## 66 66 Chile 19,859,921 Asia 743,532
## 67 67 Somalia 19,654,739 South America 627,340
## 68 68 Senegal 18,931,966 Africa 192,530
## 69 69 Romania 18,908,650 Africa 230,170
## 70 70 Guatemala 18,687,881 Africa 107,160
## 71 71 Netherlands 18,346,819 Africa 33,720
## 72 72 Ecuador 18,289,896 Europe 248,360
## 73 73 Cambodia 17,847,982 North America 176,520
## 74 74 Zimbabwe 16,950,795 Europe 386,850
## 75 75 Guinea 15,099,727 South America 245,720
## 76 76 Benin 14,814,460 Asia 112,760
## 77 77 Rwanda 14,569,341 Africa 24,670
## 78 78 Burundi 14,390,003 Africa 25,680
## 79 79 Bolivia 12,581,843 Africa 1,083,300
## 80 80 Tunisia 12,348,573 Africa 155,360
## 81 81 South Sudan 12,188,788 South America 610,952
## 82 82 Haiti 11,906,095 Africa 27,560
## 83 83 Belgium 11,758,603 Africa 30,280
## 84 84 Jordan 11,520,684 North America 88,780
## 85 85 Dominican Republic 11,520,487 Europe 48,320
## 86 86 United Arab Emirates 11,346,000 Asia 83,600
## 87 87 Honduras 11,005,850 North America 111,890
## 88 88 Cuba 10,937,203 Asia 106,440
## 89 89 Tajikistan 10,786,734 North America 139,960
## 90 90 Papua New Guinea 10,762,817 North America 452,860
## 91 91 Sweden 10,656,633 Asia 410,340
## 92 92 Czech Republic (Czechia) 10,609,239 Oceania 77,240
## 93 93 Portugal 10,411,834 Europe 91,590
## 94 94 Azerbaijan 10,397,713 Europe 82,658
## 95 95 Greece 9,938,844 Europe 128,900
## 96 96 Togo 9,721,608 Asia 54,390
## 97 97 Hungary 9,632,287 Europe 90,530
## 98 98 Israel 9,517,181 Africa 21,640
## 99 99 Austria 9,113,574 Europe 82,409
## 100 100 Belarus 8,997,603 Asia 202,910
## 101 101 Switzerland 8,967,407 Asia 39,516
## 102 102 Sierra Leone 8,819,794 Africa 72,180
## 103 103 Laos 7,873,046 Asia 230,800
## 104 104 Turkmenistan 7,618,847 Asia 469,930
## 105 105 Libya 7,458,555 Africa 1,759,540
## 106 106 Hong Kong 7,396,076 North America 1,050
## 107 107 Kyrgyzstan 7,295,034 North America 191,800
## 108 108 Paraguay 7,013,078 Europe 397,300
## 109 109 Nicaragua 7,007,502 Europe 120,340
## 110 110 Bulgaria 6,714,560 Europe 108,560
## 111 111 Serbia 6,689,039 Africa 87,460
## 112 112 Congo 6,484,437 Asia 341,500
## 113 113 El Salvador 6,365,503 Europe 20,720
## 114 114 Denmark 6,002,507 Asia 42,430
## 115 115 Singapore 5,870,750 Africa 700
## 116 116 Lebanon 5,849,421 Asia 10,230
## 117 117 Liberia 5,731,206 Europe 96,320
## 118 118 Finland 5,623,329 Europe 303,890
## 119 119 Norway 5,623,071 Asia 365,268
## 120 120 State of Palestine 5,589,623 Europe 6,020
## 121 121 Central African Republic 5,513,282 Europe 622,980
## 122 122 Oman 5,494,691 South America 309,500
## 123 123 Slovakia 5,474,881 North America 48,088
## 124 124 Mauritania 5,315,065 North America 1,030,700
## 125 125 Ireland 5,308,039 North America 68,890
## 126 126 New Zealand 5,251,899 Asia 263,310
## 127 127 Costa Rica 5,152,950 Europe 51,060
## 128 128 Kuwait 5,026,078 Europe 17,820
## 129 129 Panama 4,571,189 Africa 74,340
## 130 130 Croatia 3,848,160 Africa 55,960
## 131 131 Georgia 3,806,671 Europe 69,490
## 132 132 Eritrea 3,607,003 Europe 101,000
## 133 133 Mongolia 3,517,100 North America 1,553,560
## 134 134 Uruguay 3,384,688 Asia 175,020
## 135 135 Puerto Rico 3,235,289 Europe 8,870
## 136 136 Bosnia and Herzegovina 3,140,095 Africa 51,000
## 137 137 Qatar 3,115,889 Asia 11,610
## 138 138 Namibia 3,092,816 Europe 823,290
## 139 139 Moldova 2,996,106 Africa 32,850
## 140 140 Armenia 2,952,365 Europe 28,470
## 141 141 Jamaica 2,837,077 Europe 10,830
## 142 142 Lithuania 2,830,144 Africa 62,674
## 143 143 Gambia 2,822,093 Europe 10,120
## 144 144 Albania 2,771,508 Europe 27,400
## 145 145 Gabon 2,593,130 Asia 257,670
## 146 146 Botswana 2,562,122 North America 566,730
## 147 147 Lesotho 2,363,325 Asia 30,360
## 148 148 Guinea-Bissau 2,249,515 Asia 28,120
## 149 149 Slovenia 2,117,072 Africa 20,140
## 150 150 Equatorial Guinea 1,938,431 Africa 28,050
## 151 151 Latvia 1,853,559 Africa 62,200
## 152 152 North Macedonia 1,813,791 Oceania 25,220
## 153 153 Bahrain 1,643,332 Africa 760
## 154 154 Trinidad and Tobago 1,511,155 Oceania 5,130
## 155 155 Timor-Leste 1,418,517 South America 14,870
## 156 156 Cyprus 1,370,754 Oceania 9,240
## 157 157 Estonia 1,344,232 North America 42,390
## 158 158 Mauritius 1,268,280 Africa 2,030
## 159 159 Eswatini 1,256,174 Oceania 17,200
## 160 160 Djibouti 1,184,076 South America 23,180
## 161 161 Fiji 933,154 Oceania 18,270
## 162 162 Comoros 882,847 North America 1,861
## 163 163 Réunion 882,405 Oceania 2,500
## 164 164 Solomon Islands 838,645 Africa 27,990
## 165 165 Guyana 835,986 North America 196,850
## 166 166 Bhutan 796,682 North America 38,117
## 167 167 Macao 722,007 Oceania 30
## 168 168 Luxembourg 680,453 Oceania 2,590
## 169 169 Suriname 639,850 Africa 156,000
## 170 170 Montenegro 632,729 North America 13,450
## 171 171 Western Sahara 600,904 Oceania 266,000
## 172 172 Malta 545,405 North America 320
## 173 173 Maldives 529,676 Oceania 300
## 174 174 Cabo Verde 527,326 Oceania 4,030
## 175 175 Brunei 466,330 Oceania 5,270
## 176 176 Belize 422,924 Europe 22,810
## 177 177 Bahamas 403,033 North America 10,010
## 178 178 Iceland 398,266 North America 100,250
## 179 179 Guadeloupe 373,791 Europe 1,690
## 180 180 Martinique 340,439 North America 1,060
## 181 181 Mayotte 337,011 North America 375
## 182 182 Vanuatu 335,169 Europe 12,190
## 183 183 French Guiana 313,666 Europe 82,200
## 184 184 New Caledonia 295,333 North America 18,280
## 185 185 Barbados 282,623 Europe 430
## 186 186 French Polynesia 282,465 Oceania 3,660
## 187 187 Sao Tome & Principe 240,254 Europe 960
## 188 188 Samoa 219,306 Europe 2,830
## 189 189 Curaçao 185,487 North America 444
## 190 190 Saint Lucia 180,149 Oceania 610
## 191 191 Guam 168,999 North America 540
## 192 192 Kiribati 136,488 Oceania 810
## 193 193 Seychelles 132,779 Oceania 460
## 194 194 Grenada 117,303 North America 340
## 195 195 Micronesia 113,683 Africa 700
## 196 196 Aruba 108,147 North America 180
## 197 197 Tonga 103,742 South America 720
## 198 198 St. Vincent & Grenadines 99,924 Oceania 390
## 199 199 Antigua and Barbuda 94,209 Oceania 440
## 200 200 U.S. Virgin Islands 84,138 Oceania 350
## 201 201 Isle of Man 84,118 Europe 570
## 202 202 Andorra 82,904 Other 470
## 203 203 Cayman Islands 75,844 Other 240
## 204 204 Dominica 65,871 Other 750
## 205 205 Bermuda 64,555 Other 50
## 206 206 Faeroe Islands 56,002 Other 1,396
## 207 207 Greenland 55,745 Other 410,450
## 208 208 Saint Kitts & Nevis 46,922 Other 260
## 209 209 Turks and Caicos 46,855 Other 950
## 210 210 American Samoa 46,029 Other 200
## 211 211 Sint Maarten 43,923 Other 34
## 212 212 Northern Mariana Islands 43,541 Other 460
## 213 213 Liechtenstein 40,128 Other 160
## 214 214 Gibraltar 40,126 Other 10
## 215 215 British Virgin Islands 39,732 Other 150
## 216 216 Monaco 38,341 Other 1
## 217 217 Marshall Islands 36,282 Other 180
## 218 218 San Marino 33,572 Other 60
## 219 219 Caribbean Netherlands 31,338 Other 328
## 220 220 Palau 17,663 Other 460
## 221 221 Anguilla 14,728 Other 90
## 222 222 Cook Islands 13,263 Other 240
## 223 223 Nauru 12,025 Other 20
## 224 224 Saint Barthelemy 11,414 Other 21
## 225 225 Wallis & Futuna 11,194 Other 140
## 226 226 Tuvalu 9,492 Other 30
## 227 227 Saint Pierre & Miquelon 5,574 Other 230
## 228 228 Saint Helena 5,197 Other 390
## 229 229 Montserrat 4,359 Other 100
## 230 230 Falkland Islands 3,469 Other 12,170
## 231 231 Tokelau 2,608 Other 10
## 232 232 Niue 1,821 Other 260
## 233 233 Holy See 501 Other 0
## World.
## 1 17.78%
## 2 17.20%
## 3 4.22%
## 4 3.47%
## 5 3.10%
## 6 2.89%
## 7 2.59%
## 8 2.13%
## 9 1.75%
## 10 1.65%
## 11 1.60%
## 12 1.50%
## 13 1.44%
## 14 1.42%
## 15 1.37%
## 16 1.23%
## 17 1.12%
## 18 1.07%
## 19 1.02%
## 20 0.87%
## 21 0.86%
## 22 0.84%
## 23 0.81%
## 24 0.79%
## 25 0.72%
## 26 0.70%
## 27 0.67%
## 28 0.65%
## 29 0.63%
## 30 0.63%
## 31 0.62%
## 32 0.58%
## 33 0.58%
## 34 0.57%
## 35 0.56%
## 36 0.53%
## 37 0.51%
## 38 0.49%
## 39 0.47%
## 40 0.47%
## 41 0.47%
## 42 0.46%
## 43 0.45%
## 44 0.44%
## 45 0.43%
## 46 0.43%
## 47 0.42%
## 48 0.42%
## 49 0.40%
## 50 0.40%
## 51 0.36%
## 52 0.36%
## 53 0.35%
## 54 0.34%
## 55 0.33%
## 56 0.32%
## 57 0.31%
## 58 0.31%
## 59 0.29%
## 60 0.28%
## 61 0.28%
## 62 0.27%
## 63 0.27%
## 64 0.26%
## 65 0.25%
## 66 0.24%
## 67 0.24%
## 68 0.23%
## 69 0.23%
## 70 0.23%
## 71 0.22%
## 72 0.22%
## 73 0.22%
## 74 0.21%
## 75 0.18%
## 76 0.18%
## 77 0.18%
## 78 0.17%
## 79 0.15%
## 80 0.15%
## 81 0.15%
## 82 0.14%
## 83 0.14%
## 84 0.14%
## 85 0.14%
## 86 0.14%
## 87 0.13%
## 88 0.13%
## 89 0.13%
## 90 0.13%
## 91 0.13%
## 92 0.13%
## 93 0.13%
## 94 0.13%
## 95 0.12%
## 96 0.12%
## 97 0.12%
## 98 0.12%
## 99 0.11%
## 100 0.11%
## 101 0.11%
## 102 0.11%
## 103 0.10%
## 104 0.09%
## 105 0.09%
## 106 0.09%
## 107 0.09%
## 108 0.09%
## 109 0.09%
## 110 0.08%
## 111 0.08%
## 112 0.08%
## 113 0.08%
## 114 0.07%
## 115 0.07%
## 116 0.07%
## 117 0.07%
## 118 0.07%
## 119 0.07%
## 120 0.07%
## 121 0.07%
## 122 0.07%
## 123 0.07%
## 124 0.07%
## 125 0.06%
## 126 0.06%
## 127 0.06%
## 128 0.06%
## 129 0.06%
## 130 0.05%
## 131 0.05%
## 132 0.04%
## 133 0.04%
## 134 0.04%
## 135 0.04%
## 136 0.04%
## 137 0.04%
## 138 0.04%
## 139 0.04%
## 140 0.04%
## 141 0.03%
## 142 0.03%
## 143 0.03%
## 144 0.03%
## 145 0.03%
## 146 0.03%
## 147 0.03%
## 148 0.03%
## 149 0.03%
## 150 0.02%
## 151 0.02%
## 152 0.02%
## 153 0.02%
## 154 0.02%
## 155 0.02%
## 156 0.02%
## 157 0.02%
## 158 0.02%
## 159 0.02%
## 160 0.01%
## 161 0.01%
## 162 0.01%
## 163 0.01%
## 164 0.01%
## 165 0.01%
## 166 0.01%
## 167 0.01%
## 168 0.01%
## 169 0.01%
## 170 0.01%
## 171 0.01%
## 172 0.01%
## 173 0.01%
## 174 0.01%
## 175 0.01%
## 176 0.01%
## 177 0.00%
## 178 0.00%
## 179 0.00%
## 180 0.00%
## 181 0.00%
## 182 0.00%
## 183 0.00%
## 184 0.00%
## 185 0.00%
## 186 0.00%
## 187 0.00%
## 188 0.00%
## 189 0.00%
## 190 0.00%
## 191 0.00%
## 192 0.00%
## 193 0.00%
## 194 0.00%
## 195 0.00%
## 196 0.00%
## 197 0.00%
## 198 0.00%
## 199 0.00%
## 200 0.00%
## 201 0.00%
## 202 0.00%
## 203 0.00%
## 204 0.00%
## 205 0.00%
## 206 0.00%
## 207 0.00%
## 208 0.00%
## 209 0.00%
## 210 0.00%
## 211 0.00%
## 212 0.00%
## 213 0.00%
## 214 0.00%
## 215 0.00%
## 216 0.00%
## 217 0.00%
## 218 0.00%
## 219 0.00%
## 220 0.00%
## 221 0.00%
## 222 0.00%
## 223 0.00%
## 224 0.00%
## 225 0.00%
## 226 0.00%
## 227 0.00%
## 228 0.00%
## 229 0.00%
## 230 0.00%
## 231 0.00%
## 232 0.00%
## 233 0.00%
Filter rows
filter(map, Land.Area.Km2<= 1000)
## X. Country Population Continents Land.Area.Km2 World.
## 1 4 Indonesia 285,721,236 Asia 1,811,570 3.47%
## 2 10 Ethiopia 135,472,051 Africa 1,000,000 1.65%
## 3 11 Mexico 131,946,900 North America 1,943,950 1.60%
## 4 17 Iran 92,417,681 Asia 1,628,550 1.12%
## 5 24 South Africa 64,747,319 Africa 1,213,090 0.79%
## 6 28 Colombia 53,425,635 South America 1,109,500 0.65%
## 7 30 Sudan 51,662,147 Africa 1,765,048 0.63%
## 8 39 Angola 39,040,039 Africa 1,246,700 0.47%
## 9 47 Peru 34,576,665 South America 1,280,000 0.42%
## 10 54 Niger 27,917,831 Africa 1,266,700 0.34%
## 11 58 Mali 25,198,821 Africa 1,220,190 0.31%
## 12 64 Chad 21,003,705 Africa 1,259,200 0.26%
## 13 79 Bolivia 12,581,843 Africa 1,083,300 0.15%
## 14 105 Libya 7,458,555 Africa 1,759,540 0.09%
## 15 106 Hong Kong 7,396,076 North America 1,050 0.09%
## 16 116 Lebanon 5,849,421 Asia 10,230 0.07%
## 17 124 Mauritania 5,315,065 North America 1,030,700 0.07%
## 18 133 Mongolia 3,517,100 North America 1,553,560 0.04%
## 19 141 Jamaica 2,837,077 Europe 10,830 0.03%
## 20 143 Gambia 2,822,093 Europe 10,120 0.03%
## 21 162 Comoros 882,847 North America 1,861 0.01%
## 22 177 Bahamas 403,033 North America 10,010 0.00%
## 23 178 Iceland 398,266 North America 100,250 0.00%
## 24 179 Guadeloupe 373,791 Europe 1,690 0.00%
## 25 180 Martinique 340,439 North America 1,060 0.00%
## 26 206 Faeroe Islands 56,002 Other 1,396 0.00%
## 27 214 Gibraltar 40,126 Other 10 0.00%
## 28 216 Monaco 38,341 Other 1 0.00%
## 29 229 Montserrat 4,359 Other 100 0.00%
## 30 231 Tokelau 2,608 Other 10 0.00%
## 31 233 Holy See 501 Other 0 0.00%
filter(map, Land.Area.Km2>10000)
## X. Country Population Continents Land.Area.Km2
## 1 1 India 1,463,865,525 Asia 2,973,190
## 2 2 China 1,416,096,094 Asia 9,388,211
## 3 3 United States 347,275,807 North America 9,147,420
## 4 5 Pakistan 255,219,554 Asia 770,880
## 5 6 Nigeria 237,527,782 Africa 910,770
## 6 7 Brazil 212,812,405 South America 8,358,140
## 7 8 Bangladesh 175,686,899 Asia 130,170
## 8 9 Russia 143,997,393 Europe/Asia 16,376,870
## 9 12 Japan 123,103,479 Asia 364,555
## 10 13 Egypt 118,365,995 Africa 995,450
## 11 14 Philippines 116,786,962 Asia 298,170
## 12 15 DR Congo 112,832,473 Africa 2,267,050
## 13 16 Vietnam 101,598,527 Asia 310,070
## 14 18 Turkey 87,685,426 Europe/Asia 769,630
## 15 19 Germany 84,075,075 Europe 348,560
## 16 20 Thailand 71,619,863 Asia 510,890
## 17 21 Tanzania 70,545,865 Africa 885,800
## 18 22 United Kingdom 69,551,332 Europe 241,930
## 19 23 France 66,650,804 Europe 547,557
## 20 25 Italy 59,146,260 Europe 294,140
## 21 26 Kenya 57,532,493 Africa 569,140
## 22 27 Myanmar 54,850,648 Asia 653,290
## 23 29 South Korea 51,667,029 Asia 97,230
## 24 31 Uganda 51,384,894 Africa 199,810
## 25 32 Spain 47,889,958 Europe 498,800
## 26 33 Algeria 47,435,312 Africa 2,381,740
## 27 34 Iraq 47,020,774 Asia 434,320
## 28 35 Argentina 45,851,378 South America 2,736,690
## 29 36 Afghanistan 43,844,111 Asia 652,860
## 30 37 Yemen 41,773,878 Asia 527,970
## 31 38 Canada 40,126,723 North America 9,093,510
## 32 40 Ukraine 38,980,376 Europe 579,320
## 33 41 Morocco 38,430,770 Africa 446,300
## 34 42 Poland 38,140,910 Europe 306,230
## 35 43 Uzbekistan 37,053,428 Asia 425,400
## 36 44 Malaysia 35,977,838 Asia 328,550
## 37 45 Mozambique 35,631,653 Africa 786,380
## 38 46 Ghana 35,064,272 Africa 227,540
## 39 48 Saudi Arabia 34,566,328 Asia 2,149,690
## 40 49 Madagascar 32,740,678 Africa 581,795
## 41 50 Côte d'Ivoire 32,711,547 Africa 318,000
## 42 51 Cameroon 29,879,337 Africa 472,710
## 43 52 Nepal 29,618,118 Asia 143,350
## 44 53 Venezuela 28,516,896 South America 882,050
## 45 55 Australia 26,974,026 Oceania 7,682,300
## 46 56 North Korea 26,571,036 Asia 120,410
## 47 57 Syria 25,620,427 Asia 183,630
## 48 59 Burkina Faso 24,074,580 Africa 273,600
## 49 60 Sri Lanka 23,229,470 Asia 62,710
## 50 61 Taiwan 23,112,793 Asia 35,410
## 51 62 Malawi 22,216,120 Africa 94,280
## 52 63 Zambia 21,913,874 Africa 743,390
## 53 65 Kazakhstan 20,843,754 Africa 2,699,700
## 54 66 Chile 19,859,921 Asia 743,532
## 55 67 Somalia 19,654,739 South America 627,340
## 56 68 Senegal 18,931,966 Africa 192,530
## 57 69 Romania 18,908,650 Africa 230,170
## 58 70 Guatemala 18,687,881 Africa 107,160
## 59 71 Netherlands 18,346,819 Africa 33,720
## 60 72 Ecuador 18,289,896 Europe 248,360
## 61 73 Cambodia 17,847,982 North America 176,520
## 62 74 Zimbabwe 16,950,795 Europe 386,850
## 63 75 Guinea 15,099,727 South America 245,720
## 64 76 Benin 14,814,460 Asia 112,760
## 65 77 Rwanda 14,569,341 Africa 24,670
## 66 78 Burundi 14,390,003 Africa 25,680
## 67 80 Tunisia 12,348,573 Africa 155,360
## 68 81 South Sudan 12,188,788 South America 610,952
## 69 82 Haiti 11,906,095 Africa 27,560
## 70 83 Belgium 11,758,603 Africa 30,280
## 71 84 Jordan 11,520,684 North America 88,780
## 72 85 Dominican Republic 11,520,487 Europe 48,320
## 73 86 United Arab Emirates 11,346,000 Asia 83,600
## 74 87 Honduras 11,005,850 North America 111,890
## 75 88 Cuba 10,937,203 Asia 106,440
## 76 89 Tajikistan 10,786,734 North America 139,960
## 77 90 Papua New Guinea 10,762,817 North America 452,860
## 78 91 Sweden 10,656,633 Asia 410,340
## 79 92 Czech Republic (Czechia) 10,609,239 Oceania 77,240
## 80 93 Portugal 10,411,834 Europe 91,590
## 81 94 Azerbaijan 10,397,713 Europe 82,658
## 82 95 Greece 9,938,844 Europe 128,900
## 83 96 Togo 9,721,608 Asia 54,390
## 84 97 Hungary 9,632,287 Europe 90,530
## 85 98 Israel 9,517,181 Africa 21,640
## 86 99 Austria 9,113,574 Europe 82,409
## 87 100 Belarus 8,997,603 Asia 202,910
## 88 101 Switzerland 8,967,407 Asia 39,516
## 89 102 Sierra Leone 8,819,794 Africa 72,180
## 90 103 Laos 7,873,046 Asia 230,800
## 91 104 Turkmenistan 7,618,847 Asia 469,930
## 92 107 Kyrgyzstan 7,295,034 North America 191,800
## 93 108 Paraguay 7,013,078 Europe 397,300
## 94 109 Nicaragua 7,007,502 Europe 120,340
## 95 110 Bulgaria 6,714,560 Europe 108,560
## 96 111 Serbia 6,689,039 Africa 87,460
## 97 112 Congo 6,484,437 Asia 341,500
## 98 113 El Salvador 6,365,503 Europe 20,720
## 99 114 Denmark 6,002,507 Asia 42,430
## 100 115 Singapore 5,870,750 Africa 700
## 101 117 Liberia 5,731,206 Europe 96,320
## 102 118 Finland 5,623,329 Europe 303,890
## 103 119 Norway 5,623,071 Asia 365,268
## 104 120 State of Palestine 5,589,623 Europe 6,020
## 105 121 Central African Republic 5,513,282 Europe 622,980
## 106 122 Oman 5,494,691 South America 309,500
## 107 123 Slovakia 5,474,881 North America 48,088
## 108 125 Ireland 5,308,039 North America 68,890
## 109 126 New Zealand 5,251,899 Asia 263,310
## 110 127 Costa Rica 5,152,950 Europe 51,060
## 111 128 Kuwait 5,026,078 Europe 17,820
## 112 129 Panama 4,571,189 Africa 74,340
## 113 130 Croatia 3,848,160 Africa 55,960
## 114 131 Georgia 3,806,671 Europe 69,490
## 115 132 Eritrea 3,607,003 Europe 101,000
## 116 134 Uruguay 3,384,688 Asia 175,020
## 117 135 Puerto Rico 3,235,289 Europe 8,870
## 118 136 Bosnia and Herzegovina 3,140,095 Africa 51,000
## 119 137 Qatar 3,115,889 Asia 11,610
## 120 138 Namibia 3,092,816 Europe 823,290
## 121 139 Moldova 2,996,106 Africa 32,850
## 122 140 Armenia 2,952,365 Europe 28,470
## 123 142 Lithuania 2,830,144 Africa 62,674
## 124 144 Albania 2,771,508 Europe 27,400
## 125 145 Gabon 2,593,130 Asia 257,670
## 126 146 Botswana 2,562,122 North America 566,730
## 127 147 Lesotho 2,363,325 Asia 30,360
## 128 148 Guinea-Bissau 2,249,515 Asia 28,120
## 129 149 Slovenia 2,117,072 Africa 20,140
## 130 150 Equatorial Guinea 1,938,431 Africa 28,050
## 131 151 Latvia 1,853,559 Africa 62,200
## 132 152 North Macedonia 1,813,791 Oceania 25,220
## 133 153 Bahrain 1,643,332 Africa 760
## 134 154 Trinidad and Tobago 1,511,155 Oceania 5,130
## 135 155 Timor-Leste 1,418,517 South America 14,870
## 136 156 Cyprus 1,370,754 Oceania 9,240
## 137 157 Estonia 1,344,232 North America 42,390
## 138 158 Mauritius 1,268,280 Africa 2,030
## 139 159 Eswatini 1,256,174 Oceania 17,200
## 140 160 Djibouti 1,184,076 South America 23,180
## 141 161 Fiji 933,154 Oceania 18,270
## 142 163 Réunion 882,405 Oceania 2,500
## 143 164 Solomon Islands 838,645 Africa 27,990
## 144 165 Guyana 835,986 North America 196,850
## 145 166 Bhutan 796,682 North America 38,117
## 146 167 Macao 722,007 Oceania 30
## 147 168 Luxembourg 680,453 Oceania 2,590
## 148 169 Suriname 639,850 Africa 156,000
## 149 170 Montenegro 632,729 North America 13,450
## 150 171 Western Sahara 600,904 Oceania 266,000
## 151 172 Malta 545,405 North America 320
## 152 173 Maldives 529,676 Oceania 300
## 153 174 Cabo Verde 527,326 Oceania 4,030
## 154 175 Brunei 466,330 Oceania 5,270
## 155 176 Belize 422,924 Europe 22,810
## 156 181 Mayotte 337,011 North America 375
## 157 182 Vanuatu 335,169 Europe 12,190
## 158 183 French Guiana 313,666 Europe 82,200
## 159 184 New Caledonia 295,333 North America 18,280
## 160 185 Barbados 282,623 Europe 430
## 161 186 French Polynesia 282,465 Oceania 3,660
## 162 187 Sao Tome & Principe 240,254 Europe 960
## 163 188 Samoa 219,306 Europe 2,830
## 164 189 Curaçao 185,487 North America 444
## 165 190 Saint Lucia 180,149 Oceania 610
## 166 191 Guam 168,999 North America 540
## 167 192 Kiribati 136,488 Oceania 810
## 168 193 Seychelles 132,779 Oceania 460
## 169 194 Grenada 117,303 North America 340
## 170 195 Micronesia 113,683 Africa 700
## 171 196 Aruba 108,147 North America 180
## 172 197 Tonga 103,742 South America 720
## 173 198 St. Vincent & Grenadines 99,924 Oceania 390
## 174 199 Antigua and Barbuda 94,209 Oceania 440
## 175 200 U.S. Virgin Islands 84,138 Oceania 350
## 176 201 Isle of Man 84,118 Europe 570
## 177 202 Andorra 82,904 Other 470
## 178 203 Cayman Islands 75,844 Other 240
## 179 204 Dominica 65,871 Other 750
## 180 205 Bermuda 64,555 Other 50
## 181 207 Greenland 55,745 Other 410,450
## 182 208 Saint Kitts & Nevis 46,922 Other 260
## 183 209 Turks and Caicos 46,855 Other 950
## 184 210 American Samoa 46,029 Other 200
## 185 211 Sint Maarten 43,923 Other 34
## 186 212 Northern Mariana Islands 43,541 Other 460
## 187 213 Liechtenstein 40,128 Other 160
## 188 215 British Virgin Islands 39,732 Other 150
## 189 217 Marshall Islands 36,282 Other 180
## 190 218 San Marino 33,572 Other 60
## 191 219 Caribbean Netherlands 31,338 Other 328
## 192 220 Palau 17,663 Other 460
## 193 221 Anguilla 14,728 Other 90
## 194 222 Cook Islands 13,263 Other 240
## 195 223 Nauru 12,025 Other 20
## 196 224 Saint Barthelemy 11,414 Other 21
## 197 225 Wallis & Futuna 11,194 Other 140
## 198 226 Tuvalu 9,492 Other 30
## 199 227 Saint Pierre & Miquelon 5,574 Other 230
## 200 228 Saint Helena 5,197 Other 390
## 201 230 Falkland Islands 3,469 Other 12,170
## 202 232 Niue 1,821 Other 260
## World.
## 1 17.78%
## 2 17.20%
## 3 4.22%
## 4 3.10%
## 5 2.89%
## 6 2.59%
## 7 2.13%
## 8 1.75%
## 9 1.50%
## 10 1.44%
## 11 1.42%
## 12 1.37%
## 13 1.23%
## 14 1.07%
## 15 1.02%
## 16 0.87%
## 17 0.86%
## 18 0.84%
## 19 0.81%
## 20 0.72%
## 21 0.70%
## 22 0.67%
## 23 0.63%
## 24 0.62%
## 25 0.58%
## 26 0.58%
## 27 0.57%
## 28 0.56%
## 29 0.53%
## 30 0.51%
## 31 0.49%
## 32 0.47%
## 33 0.47%
## 34 0.46%
## 35 0.45%
## 36 0.44%
## 37 0.43%
## 38 0.43%
## 39 0.42%
## 40 0.40%
## 41 0.40%
## 42 0.36%
## 43 0.36%
## 44 0.35%
## 45 0.33%
## 46 0.32%
## 47 0.31%
## 48 0.29%
## 49 0.28%
## 50 0.28%
## 51 0.27%
## 52 0.27%
## 53 0.25%
## 54 0.24%
## 55 0.24%
## 56 0.23%
## 57 0.23%
## 58 0.23%
## 59 0.22%
## 60 0.22%
## 61 0.22%
## 62 0.21%
## 63 0.18%
## 64 0.18%
## 65 0.18%
## 66 0.17%
## 67 0.15%
## 68 0.15%
## 69 0.14%
## 70 0.14%
## 71 0.14%
## 72 0.14%
## 73 0.14%
## 74 0.13%
## 75 0.13%
## 76 0.13%
## 77 0.13%
## 78 0.13%
## 79 0.13%
## 80 0.13%
## 81 0.13%
## 82 0.12%
## 83 0.12%
## 84 0.12%
## 85 0.12%
## 86 0.11%
## 87 0.11%
## 88 0.11%
## 89 0.11%
## 90 0.10%
## 91 0.09%
## 92 0.09%
## 93 0.09%
## 94 0.09%
## 95 0.08%
## 96 0.08%
## 97 0.08%
## 98 0.08%
## 99 0.07%
## 100 0.07%
## 101 0.07%
## 102 0.07%
## 103 0.07%
## 104 0.07%
## 105 0.07%
## 106 0.07%
## 107 0.07%
## 108 0.06%
## 109 0.06%
## 110 0.06%
## 111 0.06%
## 112 0.06%
## 113 0.05%
## 114 0.05%
## 115 0.04%
## 116 0.04%
## 117 0.04%
## 118 0.04%
## 119 0.04%
## 120 0.04%
## 121 0.04%
## 122 0.04%
## 123 0.03%
## 124 0.03%
## 125 0.03%
## 126 0.03%
## 127 0.03%
## 128 0.03%
## 129 0.03%
## 130 0.02%
## 131 0.02%
## 132 0.02%
## 133 0.02%
## 134 0.02%
## 135 0.02%
## 136 0.02%
## 137 0.02%
## 138 0.02%
## 139 0.02%
## 140 0.01%
## 141 0.01%
## 142 0.01%
## 143 0.01%
## 144 0.01%
## 145 0.01%
## 146 0.01%
## 147 0.01%
## 148 0.01%
## 149 0.01%
## 150 0.01%
## 151 0.01%
## 152 0.01%
## 153 0.01%
## 154 0.01%
## 155 0.01%
## 156 0.00%
## 157 0.00%
## 158 0.00%
## 159 0.00%
## 160 0.00%
## 161 0.00%
## 162 0.00%
## 163 0.00%
## 164 0.00%
## 165 0.00%
## 166 0.00%
## 167 0.00%
## 168 0.00%
## 169 0.00%
## 170 0.00%
## 171 0.00%
## 172 0.00%
## 173 0.00%
## 174 0.00%
## 175 0.00%
## 176 0.00%
## 177 0.00%
## 178 0.00%
## 179 0.00%
## 180 0.00%
## 181 0.00%
## 182 0.00%
## 183 0.00%
## 184 0.00%
## 185 0.00%
## 186 0.00%
## 187 0.00%
## 188 0.00%
## 189 0.00%
## 190 0.00%
## 191 0.00%
## 192 0.00%
## 193 0.00%
## 194 0.00%
## 195 0.00%
## 196 0.00%
## 197 0.00%
## 198 0.00%
## 199 0.00%
## 200 0.00%
## 201 0.00%
## 202 0.00%
Arrange rows
Select columns
select(map, Asia = Continents)
## Asia
## 1 Asia
## 2 Asia
## 3 North America
## 4 Asia
## 5 Asia
## 6 Africa
## 7 South America
## 8 Asia
## 9 Europe/Asia
## 10 Africa
## 11 North America
## 12 Asia
## 13 Africa
## 14 Asia
## 15 Africa
## 16 Asia
## 17 Asia
## 18 Europe/Asia
## 19 Europe
## 20 Asia
## 21 Africa
## 22 Europe
## 23 Europe
## 24 Africa
## 25 Europe
## 26 Africa
## 27 Asia
## 28 South America
## 29 Asia
## 30 Africa
## 31 Africa
## 32 Europe
## 33 Africa
## 34 Asia
## 35 South America
## 36 Asia
## 37 Asia
## 38 North America
## 39 Africa
## 40 Europe
## 41 Africa
## 42 Europe
## 43 Asia
## 44 Asia
## 45 Africa
## 46 Africa
## 47 South America
## 48 Asia
## 49 Africa
## 50 Africa
## 51 Africa
## 52 Asia
## 53 South America
## 54 Africa
## 55 Oceania
## 56 Asia
## 57 Asia
## 58 Africa
## 59 Africa
## 60 Asia
## 61 Asia
## 62 Africa
## 63 Africa
## 64 Africa
## 65 Africa
## 66 Asia
## 67 South America
## 68 Africa
## 69 Africa
## 70 Africa
## 71 Africa
## 72 Europe
## 73 North America
## 74 Europe
## 75 South America
## 76 Asia
## 77 Africa
## 78 Africa
## 79 Africa
## 80 Africa
## 81 South America
## 82 Africa
## 83 Africa
## 84 North America
## 85 Europe
## 86 Asia
## 87 North America
## 88 Asia
## 89 North America
## 90 North America
## 91 Asia
## 92 Oceania
## 93 Europe
## 94 Europe
## 95 Europe
## 96 Asia
## 97 Europe
## 98 Africa
## 99 Europe
## 100 Asia
## 101 Asia
## 102 Africa
## 103 Asia
## 104 Asia
## 105 Africa
## 106 North America
## 107 North America
## 108 Europe
## 109 Europe
## 110 Europe
## 111 Africa
## 112 Asia
## 113 Europe
## 114 Asia
## 115 Africa
## 116 Asia
## 117 Europe
## 118 Europe
## 119 Asia
## 120 Europe
## 121 Europe
## 122 South America
## 123 North America
## 124 North America
## 125 North America
## 126 Asia
## 127 Europe
## 128 Europe
## 129 Africa
## 130 Africa
## 131 Europe
## 132 Europe
## 133 North America
## 134 Asia
## 135 Europe
## 136 Africa
## 137 Asia
## 138 Europe
## 139 Africa
## 140 Europe
## 141 Europe
## 142 Africa
## 143 Europe
## 144 Europe
## 145 Asia
## 146 North America
## 147 Asia
## 148 Asia
## 149 Africa
## 150 Africa
## 151 Africa
## 152 Oceania
## 153 Africa
## 154 Oceania
## 155 South America
## 156 Oceania
## 157 North America
## 158 Africa
## 159 Oceania
## 160 South America
## 161 Oceania
## 162 North America
## 163 Oceania
## 164 Africa
## 165 North America
## 166 North America
## 167 Oceania
## 168 Oceania
## 169 Africa
## 170 North America
## 171 Oceania
## 172 North America
## 173 Oceania
## 174 Oceania
## 175 Oceania
## 176 Europe
## 177 North America
## 178 North America
## 179 Europe
## 180 North America
## 181 North America
## 182 Europe
## 183 Europe
## 184 North America
## 185 Europe
## 186 Oceania
## 187 Europe
## 188 Europe
## 189 North America
## 190 Oceania
## 191 North America
## 192 Oceania
## 193 Oceania
## 194 North America
## 195 Africa
## 196 North America
## 197 South America
## 198 Oceania
## 199 Oceania
## 200 Oceania
## 201 Europe
## 202 Other
## 203 Other
## 204 Other
## 205 Other
## 206 Other
## 207 Other
## 208 Other
## 209 Other
## 210 Other
## 211 Other
## 212 Other
## 213 Other
## 214 Other
## 215 Other
## 216 Other
## 217 Other
## 218 Other
## 219 Other
## 220 Other
## 221 Other
## 222 Other
## 223 Other
## 224 Other
## 225 Other
## 226 Other
## 227 Other
## 228 Other
## 229 Other
## 230 Other
## 231 Other
## 232 Other
## 233 Other
Add columns
Summarize by groups