In [1]:
install.packages('readxl')
Installing package into ‘/home/duyetdev/R/x86_64-pc-linux-gnu-library/3.3’
(as ‘lib’ is unspecified)
In [2]:
library(readxl)
Sử dụng package readxl để đọc file urbanpop.xlsx
excel_sheets(): liệt kê danh sách sheet read_excel(): import excel to data.frame.
In [4]:
# Liệt kê danh sách các sheet với hàm excel_sheets()
sheets <- excel_sheets("urbanpop.xlsx")
sheets
- '1960-1966'
- '1967-1974'
- '1975-2011'
In [7]:
data <- read_excel("urbanpop.xlsx", sheet = '1960-1966')
head(data)
country 1960 1961 1962 1963 1964 1965 1966 Afghanistan 769308 814923.049 858521.698 903913.86 951225.94 1000582.35 1058743.47 Albania 494443 511802.780 529438.851 547376.75 565571.75 583982.89 602512.17 Algeria 3293999 3515147.548 3739963.007 3973289.13 4220987.01 4488175.64 4649105.24 American Samoa NA 13660.298 14165.797 14758.93 15396.42 16044.82 16693.11 Andorra NA 8723.921 9700.346 10748.38 11865.86 13052.75 14216.81 Angola 521205 548265.046 579695.370 612086.70 645261.59 679109.12 717833.40
In [8]:
data <- read_excel("urbanpop.xlsx", sheet = 2) # Đọc sheet 2
head(data)
country 1967 1968 1969 1970 1971 1972 1973 1974 Afghanistan 1119067.20 1182159.06 1248900.79 1319848.78 1409001.09 1502401.79 1598835.45 1696444.83 Albania 621179.85 639964.46 658853.12 677839.12 698932.25 720206.57 741681.04 763385.45 Algeria 4826104.22 5017298.60 5219331.87 5429743.08 5619041.53 5815734.49 6020647.35 6235114.38 American Samoa 17348.66 17995.51 18618.68 19206.39 19752.02 20262.67 20741.97 21194.38 Andorra 15439.62 16726.99 18088.32 19528.96 20928.73 22405.84 23937.05 25481.98 Angola 757496.32 798459.26 841261.96 886401.63 955010.09 1027397.35 1103829.78 1184486.23
In [9]:
my_workbook <- lapply(excel_sheets("urbanpop.xlsx"),
read_excel,
path = "urbanpop.xlsx")
In [15]:
my_workbook
country 1960 1961 1962 1963 1964 1965 1966 Afghanistan 769308 814923.049 858521.698 903913.86 951225.94 1000582.35 1058743.47 Albania 494443 511802.780 529438.851 547376.75 565571.75 583982.89 602512.17 Algeria 3293999 3515147.548 3739963.007 3973289.13 4220987.01 4488175.64 4649105.24 American Samoa NA 13660.298 14165.797 14758.93 15396.42 16044.82 16693.11 Andorra NA 8723.921 9700.346 10748.38 11865.86 13052.75 14216.81 Angola 521205 548265.046 579695.370 612086.70 645261.59 679109.12 717833.40 Antigua and Barbuda 21699 21635.051 21664.200 21740.74 21830.18 21908.89 22003.13 Argentina 15224096 15545222.586 15912120.018 16282345.35 16654412.49 17027711.84 17389812.09 Armenia 957974 1008597.321 1061426.399 1115612.32 1170683.41 1226270.42 1281581.61 Aruba 24996 28139.757 28532.729 28763.12 28923.39 29082.53 29252.23 Australia 8375329 8587694.566 8841890.588 9055934.70 9279084.65 9507271.80 9768314.91 Austria 4560057 4590376.939 4622747.142 4656713.85 4692061.02 4726877.65 4763765.43 Azerbaijan 1857673 2108328.321 2167604.472 2227265.03 2285368.41 2340495.65 2395326.80 Bahamas 65457 69503.935 73991.802 78734.58 83642.47 88633.27 93638.35 Bahrain 128480 137681.937 141956.472 146037.69 149946.77 153739.58 157841.92 Bangladesh 2761049 2757034.996 2948396.094 3148940.98 3361909.81 3589447.33 3871757.26 Barbados 84884 85334.556 85841.353 86382.78 86908.25 87382.00 87807.86 Belarus 2656152 2774678.662 2897400.750 3023617.08 3152411.47 3282734.70 3418036.00 Belgium 8435075 8503913.386 8550315.744 8627056.39 8721795.14 8814175.53 8887366.87 Belize 49165 50625.448 52165.151 53733.42 55216.17 56540.93 57730.91 Benin 211033 243244.544 262755.330 282994.96 303998.43 325805.72 353372.36 Bermuda 44400 45500.000 46600.000 47700.00 48900.00 50100.00 51000.00 Bhutan 8064 8848.944 9605.217 10399.22 11235.41 12118.66 13216.86 Bolivia 1233398 1271251.598 1310367.629 1350754.52 1392515.04 1435743.89 1480638.70 Bosnia and Herzegovina 604204 638479.050 672131.382 706263.67 740609.02 774957.04 813330.20 Botswana 16240 17254.053 18542.215 19904.31 21344.81 22868.81 28426.44 Brazil 32662018 35327479.448 37170219.218 39086646.50 41058008.04 43069605.25 45112172.57 Brunei 35501 37761.240 41059.236 44574.28 48338.18 52380.82 56683.17 Bulgaria 2918659 3084392.151 3250211.157 3416489.86 3585464.24 3753817.07 3886571.95 Burkina Faso 221872 237912.380 246591.238 255551.25 264885.54 274670.32 285488.43 ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ Sweden 5423001 5.519919e+06 5.619500e+06 5.720706e+06 5.833569e+06 5.959398e+06 6.078495e+06 Switzerland 2734617 2.807280e+06 2.915005e+06 3.014409e+06 3.101718e+06 3.175203e+06 3.245858e+06 Syria 1700442 1.764470e+06 1.854339e+06 1.948573e+06 2.047558e+06 2.151637e+06 2.262021e+06 Tajikistan 691390 7.251198e+05 7.624712e+05 8.020010e+05 8.425317e+05 8.831915e+05 9.222331e+05 Tanzania 523790 5.604472e+05 5.939675e+05 6.291167e+05 6.659337e+05 7.044750e+05 7.697677e+05 Thailand 5445488 5.568508e+06 5.771934e+06 5.983165e+06 6.202160e+06 6.428811e+06 6.670537e+06 Timor-Leste 50551 5.259609e+04 5.485424e+04 5.720082e+04 5.964108e+04 6.217822e+04 6.507339e+04 Togo 158206 1.763923e+05 1.935520e+05 2.114636e+05 2.312856e+05 2.540814e+05 2.859419e+05 Tonga 12031 1.143603e+04 1.214544e+04 1.291713e+04 1.371267e+04 1.450024e+04 1.507836e+04 Trinidad and Tobago 145840 1.434164e+05 1.399983e+05 1.360562e+05 1.320485e+05 1.282510e+05 1.256920e+05 Tunisia 1582763 1.623416e+06 1.670546e+06 1.723139e+06 1.779775e+06 1.839221e+06 1.915061e+06 Turkey 8893395 9.262783e+06 9.660491e+06 1.006659e+07 1.047922e+07 1.089719e+07 1.140395e+07 Turkmenistan 739384 7.681571e+05 7.980159e+05 8.287484e+05 8.598405e+05 8.909271e+05 9.214386e+05 Turks and Caicos Islands NA 2.766044e+03 2.786745e+03 2.796257e+03 2.798268e+03 2.800032e+03 2.799572e+03 Tuvalu NA 1.028345e+03 1.089934e+03 1.153603e+03 1.217930e+03 1.281495e+03 1.348899e+03 Uganda 298643 3.247943e+05 3.514522e+05 3.798249e+05 4.098621e+05 4.415107e+05 4.758940e+05 Ukraine 20022449 2.060258e+07 2.119345e+07 2.178761e+07 2.237941e+07 2.296451e+07 2.356974e+07 United Arab Emirates 66322 7.240624e+04 8.100291e+04 9.101101e+04 1.011662e+05 1.107579e+05 1.193781e+05 United Kingdom 41060432 4.135264e+07 4.163873e+07 4.188466e+07 4.209062e+07 4.229420e+07 4.245106e+07 United States 126469700 1.292681e+08 1.319741e+08 1.345999e+08 1.372052e+08 1.396631e+08 1.419627e+08 Uruguay 2035321 2.068693e+06 2.100247e+06 2.131162e+06 2.161415e+06 2.190900e+06 2.219599e+06 Uzbekistan 2909890 3.037532e+06 3.174627e+06 3.317511e+06 3.463670e+06 3.611301e+06 3.761709e+06 Vanuatu 6638 6.957926e+03 7.305418e+03 7.667136e+03 8.038279e+03 8.415974e+03 8.808698e+03 Venezuela 4668605 4.923222e+06 5.198139e+06 5.482987e+06 5.776289e+06 6.077210e+06 6.374314e+06 Vietnam 5107221 5.329816e+06 5.558755e+06 5.795308e+06 6.040677e+06 6.295976e+06 6.574580e+06 Virgin Islands (U.S.) 18080 1.972255e+04 2.148880e+04 2.343602e+04 2.557238e+04 2.784276e+04 3.052818e+04 Yemen 475203 4.946236e+05 5.248185e+05 5.560704e+05 5.881864e+05 6.210070e+05 6.586535e+05 Zambia 551011 6.015866e+05 6.534806e+05 7.082517e+05 7.659692e+05 8.267296e+05 9.033981e+05 Zimbabwe 472675 5.043632e+05 5.373484e+05 5.720561e+05 6.084456e+05 6.465091e+05 6.929329e+05 South Sudan NA 2.877958e+05 2.921209e+05 2.965942e+05 3.011961e+05 3.059156e+05 3.107629e+05
country 1967 1968 1969 1970 1971 1972 1973 1974 Afghanistan 1119067.20 1182159.06 1248900.79 1319848.78 1409001.09 1502401.79 1598835.45 1696444.83 Albania 621179.85 639964.46 658853.12 677839.12 698932.25 720206.57 741681.04 763385.45 Algeria 4826104.22 5017298.60 5219331.87 5429743.08 5619041.53 5815734.49 6020647.35 6235114.38 American Samoa 17348.66 17995.51 18618.68 19206.39 19752.02 20262.67 20741.97 21194.38 Andorra 15439.62 16726.99 18088.32 19528.96 20928.73 22405.84 23937.05 25481.98 Angola 757496.32 798459.26 841261.96 886401.63 955010.09 1027397.35 1103829.78 1184486.23 Antigua and Barbuda 22086.25 22149.39 22182.92 22180.87 22560.87 22907.76 23221.29 23502.92 Argentina 17753280.98 18124103.64 18510462.30 18918072.79 19329718.16 19763078.00 20211424.85 20664728.90 Armenia 1337032.09 1392892.13 1449641.49 1507619.77 1564367.60 1622103.53 1680497.75 1739063.02 Aruba 29414.72 29576.09 29737.87 29901.57 30081.36 30279.76 30467.42 30602.87 Australia 9934404.03 10153969.77 10412390.67 10664093.55 11047706.39 11269945.50 11461120.68 11772934.25 Austria 4803148.64 4831817.27 4852207.79 4872870.98 4895909.62 4925699.36 4954324.81 4964025.98 Azerbaijan 2446990.03 2495724.94 2542062.32 2586413.26 2660993.01 2734824.99 2807955.39 2880446.72 Bahamas 98683.90 103669.73 108473.04 113010.13 117156.63 120998.86 124664.39 128349.87 Bahrain 161961.64 166378.46 171459.04 177500.79 184439.81 192316.25 201493.54 212416.24 Bangladesh 4173452.97 4484841.63 4790505.36 5078286.33 5456170.27 5812547.90 6161814.92 6530579.50 Barbados 88193.71 88580.41 89024.89 89565.43 90552.45 91642.08 92776.39 93871.56 Belarus 3556447.88 3696854.38 3838002.85 3978504.00 4132163.53 4286800.60 4440935.55 4592935.32 Belgium 8950504.31 8999365.83 9038505.61 9061056.85 9089909.02 9137945.57 9179155.15 9220531.41 Belize 58790.24 59711.73 60492.20 61141.33 61839.91 62403.29 62943.38 63626.71 Benin 382022.12 411859.45 443013.11 475611.38 515819.53 557937.60 602093.16 648409.65 Bermuda 52000.00 53000.00 54000.00 55000.00 54600.00 54200.00 53800.00 53400.00 Bhutan 14378.97 15616.89 16946.42 18381.41 20172.66 22099.76 24159.74 26342.54 Bolivia 1527064.75 1575177.18 1625172.71 1677183.68 1731436.76 1787719.36 1845894.07 1905748.66 Bosnia and Herzegovina 851692.43 890269.65 929449.59 969549.45 1008630.18 1048737.86 1089647.76 1130965.68 Botswana 34319.76 40576.16 47222.23 54286.41 61869.00 69929.63 78529.97 87753.92 Brazil 47193516.86 49316879.46 51489096.39 53716418.98 56000512.77 58340475.01 60744727.95 63224380.03 Brunei 61289.05 66222.18 71502.76 77148.02 80884.00 84781.42 88807.98 92919.45 Bulgaria 4019905.62 4158186.16 4300668.64 4440047.20 4554371.61 4665864.46 4780946.91 4904324.08 Burkina Faso 296823.83 308661.11 320960.74 333698.49 347510.70 361836.15 376724.28 392240.95 ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ Sweden 6.187907e+06 6.285731e+06 6.393453e+06 6517403.36 6.589874e+06 6.636926e+06 6.675974e+06 6.723052e+06 Switzerland 3.324087e+06 3.404449e+06 3.481651e+06 3545845.52 3.564515e+06 3.591810e+06 3.618437e+06 3.637988e+06 Syria 2.377889e+06 2.499429e+06 2.626816e+06 2760216.97 2.878588e+06 3.002034e+06 3.130344e+06 3.263171e+06 Tajikistan 9.611929e+05 1.000669e+06 1.041608e+06 1084707.91 1.111673e+06 1.139645e+06 1.168044e+06 1.196054e+06 Tanzania 8.384494e+05 9.108258e+05 9.872961e+05 1068227.15 1.195298e+06 1.330036e+06 1.472583e+06 1.622882e+06 Thailand 6.919690e+06 7.176231e+06 7.440174e+06 7711257.28 8.156822e+06 8.618420e+06 9.093762e+06 9.579568e+06 Timor-Leste 6.802067e+04 7.108209e+04 7.435281e+04 77880.66 8.202655e+04 8.651331e+04 9.088243e+04 9.445747e+04 Togo 3.221940e+05 3.621139e+05 4.040164e+05 446299.69 4.679159e+05 4.881497e+05 5.073627e+05 5.262916e+05 Tonga 1.563131e+04 1.614767e+04 1.661674e+04 17031.57 1.728917e+04 1.748268e+04 1.763734e+04 1.779015e+04 Trinidad and Tobago 1.232921e+05 1.208498e+05 1.181071e+05 114919.06 1.151237e+05 1.150568e+05 1.148504e+05 1.146878e+05 Tunisia 1.992479e+06 2.070869e+06 2.149857e+06 2229322.14 2.307379e+06 2.389032e+06 2.475875e+06 2.569238e+06 Turkey 1.191986e+07 1.244807e+07 1.299329e+07 13559380.70 1.410119e+07 1.466411e+07 1.524684e+07 1.584676e+07 Turkmenistan 9.517698e+05 9.822601e+05 1.013434e+06 1045664.82 1.075185e+06 1.105506e+06 1.136380e+06 1.167443e+06 Turks and Caicos Islands 2.798837e+03 2.804887e+03 2.829033e+03 2878.29 2.961101e+03 3.073893e+03 3.205822e+03 3.342540e+03 Tuvalu 1.415014e+03 1.480186e+03 1.545270e+03 1611.03 1.683666e+03 1.756818e+03 1.830905e+03 1.905153e+03 Uganda 5.120829e+05 5.499091e+05 5.891064e+05 629476.91 6.557359e+05 6.822662e+05 7.093838e+05 7.375558e+05 Ukraine 2.416635e+07 2.475757e+07 2.534887e+07 25944110.66 2.648578e+07 2.703029e+07 2.757233e+07 2.810411e+07 United Arab Emirates 1.280378e+05 1.390527e+05 1.555970e+05 180075.18 2.128010e+05 2.533435e+05 3.021131e+05 3.593418e+05 United Kingdom 4.260294e+07 4.273308e+07 4.283308e+07 42925828.50 4.316876e+07 4.337887e+07 4.352637e+07 4.361748e+07 United States 1.442017e+08 1.463404e+08 1.484759e+08 150922373.04 1.528638e+08 1.545305e+08 1.560341e+08 1.574881e+08 Uruguay 2.247503e+06 2.273438e+06 2.295858e+06 2313813.49 2.326524e+06 2.334879e+06 2.341153e+06 2.348533e+06 Uzbekistan 3.913188e+06 4.067599e+06 4.227790e+06 4395765.02 4.595966e+06 4.805551e+06 5.022305e+06 5.242853e+06 Vanuatu 9.208354e+03 9.621427e+03 1.005774e+04 10524.69 1.103796e+04 1.158368e+04 1.215890e+04 1.275908e+04 Venezuela 6.678933e+06 6.994264e+06 7.324840e+06 7674280.76 8.023652e+06 8.391094e+06 8.777606e+06 9.184011e+06 Vietnam 6.865532e+06 7.169607e+06 7.487421e+06 7819407.00 8.043735e+06 8.277023e+06 8.518466e+06 8.766839e+06 Virgin Islands (U.S.) 3.342853e+04 3.661847e+04 4.004103e+04 43842.96 5.021305e+04 5.460843e+04 6.130639e+04 6.670296e+04 Yemen 6.973814e+05 7.369436e+05 7.769681e+05 817283.94 8.485446e+05 8.800627e+05 9.133326e+05 9.504883e+05 Zambia 9.841980e+05 1.069557e+06 1.160044e+06 1256178.42 1.337898e+06 1.424498e+06 1.515871e+06 1.611725e+06 Zimbabwe 7.416051e+05 7.927728e+05 8.467739e+05 903905.48 9.620288e+05 1.023588e+06 1.088377e+06 1.155992e+06 South Sudan 3.157901e+05 3.210970e+05 3.268101e+05 333013.31 3.396491e+05 3.466912e+05 3.542318e+05 3.623528e+05
country 1975 1976 1977 1978 1979 1980 1981 1982 1983 ⋯ 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Afghanistan 1793266.13 1905032.58 2021307.69 2142247.68 2268014.57 2398775.03 2493264.95 2590846.40 2691611.83 ⋯ 5795939.88 6036099.72 6285280.78 6543803.78 6812538.47 7091244.93 7380272.24 7679981.65 7990745.95 8316975.83 Albania 785350.02 807989.83 830959.17 854262.38 877898.15 901884.31 927223.82 952447.41 978476.39 ⋯ 1352278.42 1391143.43 1430917.60 1470488.07 1512254.66 1553490.85 1594350.74 1635261.64 1676545.47 1716842.33 Algeria 6460138.04 6774099.23 7102902.29 7447728.39 7810072.95 8190772.27 8637724.15 9105820.40 9591900.05 ⋯ 19854835.29 20529355.66 21222197.50 21932977.75 22625052.35 23335542.76 24061748.77 24799590.71 25545622.13 26216967.63 American Samoa 21631.68 22046.65 22452.41 22899.50 23457.29 24176.58 25173.25 26342.30 27655.18 ⋯ 53582.69 54864.46 56166.25 57473.60 58679.31 59894.20 61118.29 62357.16 63615.55 64816.72 Andorra 27019.33 28366.22 29677.15 31036.73 32571.56 34365.65 36355.83 38617.70 40983.37 ⋯ 63212.32 65802.20 68301.14 70328.97 71726.37 72684.36 73335.15 73897.33 74525.02 75207.40 Angola 1269605.51 1372800.34 1481597.86 1597267.29 1721589.74 1855983.29 2015833.04 2188350.51 2371047.45 ⋯ 7589585.25 8012294.90 8449762.30 8894672.60 9326817.70 9764678.83 10210317.37 10667669.61 11139829.41 11602850.76 Antigua and Barbuda 23753.44 23977.17 24167.66 24303.98 24357.78 24311.53 24163.76 23929.13 23632.16 ⋯ 25383.37 25520.40 25623.28 25705.99 25895.75 26066.32 26222.77 26368.87 26508.32 26771.23 Argentina 21115687.70 21552513.28 21986365.11 22421169.82 22863183.80 23316975.12 23796692.90 24287633.72 24788596.92 ⋯ 34128018.78 34535232.90 34940181.04 35347630.42 35736246.73 36127601.75 36522142.16 36919809.60 37320425.11 37705099.17 Armenia 1797424.22 1847860.08 1897671.21 1946996.11 1996083.14 2045104.83 2084400.48 2122177.63 2159712.21 ⋯ 1973567.85 1970286.73 1968659.24 1967851.92 1969624.19 1971681.32 1974101.21 1977150.70 1980966.85 1987710.11 Aruba 30659.38 30617.32 30495.45 30355.98 30282.22 30333.17 30561.56 30944.16 31368.88 ⋯ 44140.20 45183.66 46175.84 47064.14 47899.69 48642.64 49287.18 49832.15 50279.66 50687.20 Australia 11937004.53 12052775.30 12184768.67 12322667.35 12451879.91 12599859.20 12792439.00 12998439.20 13152790.20 ⋯ 17209084.71 17463227.14 17707804.74 17984542.54 18287588.15 18654978.51 19069255.49 19509178.24 19857079.91 20175675.07 Austria 4952131.01 4944146.24 4946801.53 4943554.40 4935889.56 4936649.73 4951904.20 4958107.79 4952748.57 ⋯ 5341656.33 5379663.08 5425139.41 5474303.75 5516671.90 5553393.19 5592910.18 5627320.49 5659236.13 5696918.41 Azerbaijan 2952419.29 3013402.02 3073516.08 3133316.43 3195510.75 3254229.82 3315513.18 3376020.75 3437872.26 ⋯ 4232024.09 4280727.44 4335029.45 4396406.30 4462143.63 4530394.36 4644268.99 4759808.01 4835103.83 4918155.26 Bahamas 132207.11 136214.62 140407.31 144780.83 149304.44 153952.81 158948.85 164107.88 169364.15 ⋯ 252127.42 256396.02 260797.14 265284.30 269840.68 274488.44 279159.48 283763.26 288236.12 292515.92 Bahrain 225319.71 240473.30 257607.98 275581.66 292819.30 308204.56 321143.77 332060.76 341871.84 ⋯ 567530.81 572094.27 593900.33 640867.10 717763.55 819260.74 931741.82 1035991.14 1118212.94 1173806.13 Bangladesh 6942462.04 7809924.71 8753099.92 9770721.63 10848902.08 11973533.06 12747500.14 13547531.04 14376642.25 ⋯ 32772286.81 33879689.06 34972770.80 36041119.68 37136611.93 38204984.39 39265757.00 40348600.51 41476183.02 42725450.49 Barbados 94868.49 95681.49 96391.78 97047.96 97725.99 98478.43 97041.14 95656.55 94299.22 ⋯ 106130.06 107884.91 109638.97 111398.55 113096.28 114798.80 116509.92 118230.58 119962.24 121621.60 Belarus 4741013.38 4874032.19 5012323.99 5157254.10 5301983.81 5448102.14 5589561.50 5731864.32 5876172.57 ⋯ 7039345.95 7050171.14 7061612.18 7073031.11 7085863.42 7107529.97 7077691.81 7050657.40 7080963.50 7106796.17 Belgium 9259701.36 9293953.31 9323150.85 9349584.24 9375738.45 9403843.61 9414420.78 9422684.81 9432757.61 ⋯ 10042185.75 10087925.53 10135306.05 10194856.05 10265779.03 10344926.50 10430485.54 10518288.97 10618596.23 10731192.83 Belize 64556.53 65721.19 67139.31 68743.96 70417.74 72086.04 73721.79 75373.42 76610.74 ⋯ 124968.07 128233.38 131639.04 135135.50 138762.33 142579.16 146562.59 150715.02 154987.46 159672.64 Benin 697013.76 749487.75 804594.78 862473.50 923261.05 987095.92 1039556.44 1094681.43 1152391.82 ⋯ 2733635.47 2861333.17 2993890.55 3130069.38 3278880.83 3432024.01 3589394.77 3750974.28 3916785.20 4086647.57 Bermuda 53000.00 53200.00 53400.00 53600.00 53800.00 54000.00 54400.00 54800.00 55200.00 ⋯ 62800.00 63000.00 63300.00 63600.00 63800.00 64000.00 64200.00 64400.00 64237.00 64700.00 Bhutan 28637.37 31399.21 34300.02 37322.19 40439.99 43631.74 47335.89 51077.12 54930.94 ⋯ 167485.64 179500.18 191792.37 204150.08 214080.33 223762.66 233285.96 242841.64 252576.30 262577.95 Bolivia 1967101.66 2055351.97 2146365.47 2239857.67 2335431.44 2432832.50 2542089.88 2653672.92 2768195.62 ⋯ 5428026.65 5575799.23 5723735.05 5871146.38 6014987.42 6158181.40 6301538.00 6446268.48 6593320.44 6740006.19 Bosnia and Herzegovina 1172395.46 1215033.86 1257762.55 1300959.38 1345216.30 1390988.10 1419935.37 1448732.35 1478762.77 ⋯ 1658239.43 1678179.70 1694509.71 1711281.05 1730250.46 1747772.99 1764187.67 1779793.17 1794831.92 1811313.02 Botswana 97679.59 109308.69 121812.39 135170.69 149311.27 164165.61 191373.67 220113.61 250425.02 ⋯ 991914.46 1019007.39 1046513.59 1075135.76 1103501.97 1133061.98 1163396.67 1193812.35 1223774.85 1251235.16 Brazil 65788335.99 68394051.07 71083504.27 73859909.47 76726123.85 79682323.12 82660437.80 85722504.01 88848334.86 ⋯ 146746080.83 149260974.49 151705832.93 154060441.76 156257555.05 158356880.92 160387963.33 162394402.22 164408105.47 166376434.80 Brunei 97079.50 100492.39 103876.52 107183.99 110360.32 113371.77 117944.51 122461.06 126980.70 ⋯ 246301.91 253125.44 260006.40 266960.77 273789.43 280679.41 287618.76 294587.76 301571.55 308352.94 Bulgaria 5019833.51 5121117.80 5227677.35 5313521.56 5400804.51 5503013.24 5565661.42 5626558.67 5685136.98 ⋯ 5461582.32 5450437.46 5440821.21 5431784.42 5439203.65 5447394.36 5457283.54 5465466.14 5464167.75 5463580.42 Burkina Faso 408446.84 449809.05 493030.42 538226.35 585516.84 635024.35 702702.89 773639.98 848002.90 ⋯ 2514738.23 2687130.37 2868044.45 3057922.98 3269963.03 3492524.74 3725989.21 3970704.43 4227024.82 4498006.03 ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋱ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ Sweden 6.777603e+06 6.808168e+06 6.838282e+06 6.864129e+06 6.885047e+06 6.904971e+06 6.913473e+06 6.917644e+06 6.920993e+06 ⋯ 7.509745e+06 7.542990e+06 7.577985e+06 7.613645e+06 7.669976e+06 7.740548e+06 7.814675e+06 7.895239e+06 7.976659e+06 8.054504e+06 Switzerland 3.636410e+06 3.612091e+06 3.596286e+06 3.593029e+06 3.596663e+06 3.607371e+06 3.730426e+06 3.856158e+06 3.977046e+06 ⋯ 5.345260e+06 5.387047e+06 5.426202e+06 5.463082e+06 5.500183e+06 5.552291e+06 5.626058e+06 5.699599e+06 5.763023e+06 5.828234e+06 Syria 3.400366e+06 3.540520e+06 3.685014e+06 3.835250e+06 3.993160e+06 4.160068e+06 4.328147e+06 4.504716e+06 4.688022e+06 ⋯ 8.936303e+06 9.278255e+06 9.617406e+06 9.941315e+06 1.021527e+07 1.049627e+07 1.078448e+07 1.108007e+07 1.138324e+07 1.167366e+07 Tajikistan 1.223146e+06 1.249829e+06 1.275808e+06 1.301602e+06 1.327936e+06 1.355338e+06 1.385167e+06 1.415766e+06 1.447683e+06 ⋯ 1.663464e+06 1.676203e+06 1.689850e+06 1.705527e+06 1.725322e+06 1.747359e+06 1.771325e+06 1.796635e+06 1.822839e+06 1.852661e+06 Tanzania 1.780907e+06 1.950575e+06 2.128706e+06 2.315810e+06 2.512589e+06 2.719717e+06 2.891676e+06 3.072068e+06 3.260895e+06 ⋯ 8.263761e+06 8.622732e+06 8.999112e+06 9.394001e+06 9.824961e+06 1.027805e+07 1.075467e+07 1.125619e+07 1.178383e+07 1.235993e+07 Thailand 1.007314e+07 1.058720e+07 1.110812e+07 1.163647e+07 1.217372e+07 1.272107e+07 1.310938e+07 1.349857e+07 1.389142e+07 ⋯ 2.041566e+07 2.078892e+07 2.115346e+07 2.150426e+07 2.189093e+07 2.226205e+07 2.262019e+07 2.296997e+07 2.331493e+07 2.371306e+07 Timor-Leste 9.674604e+04 9.762170e+04 9.702625e+04 9.573701e+04 9.497827e+04 9.571793e+04 9.865028e+04 1.033822e+05 1.094618e+05 ⋯ 2.219342e+05 2.361204e+05 2.504859e+05 2.563990e+05 2.683800e+05 2.806708e+05 2.932780e+05 3.062020e+05 3.194436e+05 3.332985e+05 Togo 5.455821e+05 5.655910e+05 5.858795e+05 6.072975e+05 6.309741e+05 6.577427e+05 6.889652e+05 7.236047e+05 7.609848e+05 ⋯ 1.708130e+06 1.772042e+06 1.836585e+06 1.902820e+06 1.971667e+06 2.042033e+06 2.113964e+06 2.187430e+06 2.262413e+06 2.340060e+06 Tonga 1.796632e+04 1.829702e+04 1.865735e+04 1.902648e+04 1.937264e+04 1.967301e+04 1.997512e+04 2.023299e+04 2.046199e+04 ⋯ 2.285073e+04 2.301904e+04 2.319254e+04 2.336942e+04 2.356505e+04 2.376403e+04 2.396033e+04 2.414622e+04 2.431627e+04 2.452429e+04 Trinidad and Tobago 1.146999e+05 1.148888e+05 1.152237e+05 1.157124e+05 1.163519e+05 1.171249e+05 1.163966e+05 1.157310e+05 1.149773e+05 ⋯ 1.477107e+05 1.515871e+05 1.554948e+05 1.594511e+05 1.635523e+05 1.677081e+05 1.719065e+05 1.761255e+05 1.803466e+05 1.846061e+05 Tunisia 2.670163e+06 2.766900e+06 2.873016e+06 2.987057e+06 3.106154e+06 3.228325e+06 3.357762e+06 3.490896e+06 3.627337e+06 ⋯ 6.271215e+06 6.341712e+06 6.435083e+06 6.531687e+06 6.615747e+06 6.699077e+06 6.787120e+06 6.880114e+06 6.972744e+06 7.078245e+06 Turkey 1.646216e+07 1.699766e+07 1.754439e+07 1.810747e+07 1.869419e+07 1.930926e+07 2.054029e+07 2.182727e+07 2.316093e+07 ⋯ 4.292025e+07 4.378469e+07 4.465878e+07 4.554759e+07 4.666637e+07 4.780463e+07 4.895766e+07 5.011834e+07 5.128093e+07 5.258559e+07 Turkmenistan 1.198437e+06 1.228019e+06 1.257568e+06 1.287154e+06 1.316892e+06 1.346902e+06 1.373557e+06 1.400415e+06 1.427719e+06 ⋯ 2.132925e+06 2.165648e+06 2.199075e+06 2.233763e+06 2.272253e+06 2.312459e+06 2.354200e+06 2.397095e+06 2.440830e+06 2.488405e+06 Turks and Caicos Islands 3.473504e+03 3.596953e+03 3.714405e+03 3.837639e+03 3.981014e+03 4.158240e+03 4.500522e+03 4.891248e+03 5.320519e+03 ⋯ 1.995435e+04 2.245099e+04 2.498704e+04 2.737287e+04 2.945367e+04 3.134094e+04 3.301747e+04 3.448969e+04 3.576817e+04 3.670201e+04 Tuvalu 1.979733e+03 2.059954e+03 2.140443e+03 2.222817e+03 2.308890e+03 2.400969e+03 2.505756e+03 2.617214e+03 2.732492e+03 ⋯ 4.464119e+03 4.531774e+03 4.598017e+03 4.660875e+03 4.719397e+03 4.774321e+03 4.826533e+03 4.876955e+03 4.928044e+03 4.978801e+03 Uganda 7.671584e+05 8.010624e+05 8.367921e+05 8.742823e+05 9.133634e+05 9.539649e+05 1.025339e+06 1.100189e+06 1.179300e+06 ⋯ 3.236784e+06 3.405226e+06 3.581885e+06 3.766566e+06 4.003165e+06 4.251226e+06 4.510992e+06 4.782682e+06 5.066513e+06 5.376189e+06 Ukraine 2.861995e+07 2.909206e+07 2.954734e+07 2.999096e+07 3.043094e+07 3.087337e+07 3.128296e+07 3.168559e+07 3.210096e+07 ⋯ 3.248993e+07 3.228904e+07 3.210623e+07 3.193258e+07 3.180117e+07 3.169519e+07 3.160684e+07 3.154927e+07 3.150629e+07 3.148419e+07 United Arab Emirates 4.247890e+05 4.984755e+05 5.801313e+05 6.649556e+05 7.464832e+05 8.201976e+05 8.794977e+05 9.298917e+05 9.756419e+05 ⋯ 2.637810e+06 2.770136e+06 2.994356e+06 3.347528e+06 3.852253e+06 4.485194e+06 5.171979e+06 5.806817e+06 6.312975e+06 6.654542e+06 United Kingdom 4.367789e+07 4.375686e+07 4.383216e+07 4.392420e+07 4.405340e+07 4.419596e+07 4.420110e+07 4.417501e+07 4.417982e+07 ⋯ 4.674482e+07 4.697669e+07 4.725718e+07 4.758142e+07 4.793551e+07 4.830594e+07 4.868973e+07 4.908278e+07 4.947889e+07 4.988454e+07 United States 1.590706e+08 1.606264e+08 1.622875e+08 1.640540e+08 1.659128e+08 1.675512e+08 1.695506e+08 1.715250e+08 1.734540e+08 ⋯ 2.293690e+08 2.323016e+08 2.354231e+08 2.385735e+08 2.417277e+08 2.448883e+08 2.480744e+08 2.511250e+08 2.541091e+08 2.567019e+08 Uruguay 2.359344e+06 2.380094e+06 2.404634e+06 2.431995e+06 2.460521e+06 2.488964e+06 2.515940e+06 2.543048e+06 2.570253e+06 ⋯ 3.029452e+06 3.028850e+06 3.031155e+06 3.038786e+06 3.050323e+06 3.062521e+06 3.075390e+06 3.088963e+06 3.103263e+06 3.117433e+06 Uzbekistan 5.464752e+06 5.667381e+06 5.870162e+06 6.075328e+06 6.286266e+06 6.505503e+06 6.676398e+06 6.852624e+06 7.033147e+06 ⋯ 9.382863e+06 9.454220e+06 9.524979e+06 9.597009e+06 9.689807e+06 9.803381e+06 9.936217e+06 1.007912e+07 1.034073e+07 1.063560e+07 Vanuatu 1.337973e+04 1.407816e+04 1.480117e+04 1.554210e+04 1.629246e+04 1.704548e+04 1.794935e+04 1.886272e+04 1.979235e+04 ⋯ 4.327565e+04 4.504999e+04 4.689628e+04 4.877816e+04 5.071534e+04 5.269223e+04 5.471388e+04 5.678993e+04 5.892778e+04 6.116453e+04 Venezuela 9.610436e+06 1.004443e+07 1.049794e+07 1.096479e+07 1.143639e+07 1.190647e+07 1.241461e+07 1.288322e+07 1.335471e+07 ⋯ 2.287399e+07 2.338958e+07 2.390793e+07 2.442719e+07 2.492031e+07 2.541413e+07 2.591049e+07 2.640660e+07 2.690616e+07 2.737634e+07 Vietnam 9.020995e+06 9.278505e+06 9.539988e+06 9.804242e+06 1.006994e+07 1.033564e+07 1.056677e+07 1.078800e+07 1.101109e+07 ⋯ 2.031164e+07 2.101690e+07 2.174354e+07 2.247777e+07 2.324716e+07 2.402474e+07 2.481162e+07 2.561016e+07 2.641994e+07 2.726167e+07 Virgin Islands (U.S.) 7.073030e+04 7.317638e+04 7.180139e+04 7.505875e+04 7.599994e+04 7.774259e+04 7.935413e+04 8.343620e+04 8.593187e+04 ⋯ 1.015792e+05 1.021344e+05 1.026722e+05 1.032499e+05 1.036402e+05 1.039280e+05 1.041772e+05 1.043912e+05 1.045709e+05 1.046499e+05 Yemen 9.932751e+05 1.044616e+06 1.102662e+06 1.167253e+06 1.237752e+06 1.313656e+06 1.397894e+06 1.488660e+06 1.585326e+06 ⋯ 5.147602e+06 5.411962e+06 5.687858e+06 5.974891e+06 6.279385e+06 6.596914e+06 6.928173e+06 7.273924e+06 7.634749e+06 8.016512e+06 Zambia 1.711855e+06 1.819215e+06 1.931194e+06 2.048188e+06 2.170767e+06 2.299382e+06 2.374055e+06 2.450872e+06 2.529521e+06 ⋯ 3.798963e+06 3.925523e+06 4.057253e+06 4.196601e+06 4.351604e+06 4.515609e+06 4.689372e+06 4.873500e+06 5.005752e+06 5.277522e+06 Zimbabwe 1.226216e+06 1.298590e+06 1.373668e+06 1.452814e+06 1.537997e+06 1.630726e+06 1.739888e+06 1.857486e+06 1.982735e+06 ⋯ 4.362144e+06 4.416956e+06 4.464637e+06 4.507848e+06 4.550019e+06 4.589104e+06 4.634713e+06 4.699701e+06 4.793495e+06 4.925817e+06 South Sudan 3.711720e+05 3.805809e+05 3.904271e+05 4.008145e+05 4.118852e+05 4.237103e+05 4.506834e+05 4.793847e+05 5.091723e+05 ⋯ 1.175120e+06 1.216075e+06 1.260108e+06 1.309323e+06 1.378153e+06 1.471365e+06 1.577806e+06 1.684450e+06 1.776568e+06 1.862114e+06
In [ ]:
Content source: duyetdev/datascience-R
Similar notebooks: