Đọc dữ liệu từ file csv
qh<-read.csv("D:\\Downloads\\population-and-demography.csv", header = T)population-and-demograph là bộ dữ liệu phân tích dân số của 254 quốc gia từ năm 1950 đến 2021
Bộ dữ liệu gồm có 24 đối tượng và 18288 quan sát
Giải thích các đối tượng:
Country: Nước
Year: Năm
Population: Tổng dân số
Population.of.children.under.the.age.of.1: Dân số trẻ em dưới 1 tuổi
Population.of.children.under.the.age.of.5: Dân số trẻ em dưới 5 tuổi
Population.of.children.under.the.age.of.15: Dân số trẻ em dưới 15 tuổi
Population.under.the.age.of.25: Dân số dưới 25 tuổi
Population.aged.15.to.64.years: Dân số từ 15 đến 64 tuổi
Population.older.than.15.years: Dân số lớn hơn 15 tuổi
Population.older.than.18.years: Dân số lớn hơn 18 tuổi
Population.at.age.1: Dân số 1 tuổi
Population.aged.1.to.4.years: Dân số từ 1 đến 4 tuổi
Population.aged.5.to.9.years: Dân số từ 5 đến 9 tuổi
Population.aged.10.to.14.years: Dân số từ 10 đến 14 tuổi
Population.aged.15.to.19.years: Dân số từ 15 đến 19 tuổi
Population.aged.20.to.29.years: Dân số từ 20 đến 29 tuổi
Population.aged.30.to.39.years: Dân số từ 30 đến 39 tuổi
Population.aged.40.to.49.years: Dân số từ 40 đến 49 tuổi
Population.aged.50.to.59.years: Dân số từ 50 đến 59 tuổi
Population.aged.60.to.69.years: Dân số từ 60 đến 69 tuổi
Population.aged.70.to.79.years: Dân số từ 70 đến 79 tuổi
Population.aged.80.to.89.years: Dân số từ 80 đến 89 tuổi
Population.aged.90.to.99.years: Dân số từ 90 đến 99 tuổi
Population.older.than.100.years: Dân số lớn hơn 100 tuổi
Đổi tên các biến của dữ liệu bằng lệnh
names(qh) <- c('c','y','p','u1','u5','u15','u25','15to64','o15','o18','1','1to4','5to9','10to14','15to19','20to29','30to39','40to49','50to59','60to69','70to79','80to89','90to99','o100')Thực hiện sau câu lệnh ta thấy tên các cột đã được thay đổi: country thành c, year thành y,…
Lọc 5 quốc gia cần phân tích(Vietnam, Laos, Cambodia, Thailand, Indonesia) và 5 độ tuổi cần phân tích (dưới 1, dưới 5, dưới 15, dưới 25 và trên 100) bằng lệnh
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionqh1 <- qh %>% filter(c=='Vietnam'|c=='Laos'|c=='Cambodia'|c=='Thailand'|c=='Indonesia') %>% select(c, y,u1, u5, u15, u25, o100)
table <- knitr::kable(qh1, format = "markdown")
table | c | y | u1 | u5 | u15 | u25 | o100 |
|---|---|---|---|---|---|---|
| Cambodia | 1950 | 182915 | 756813 | 1865760 | 2710160 | 2.000 |
| Cambodia | 1951 | 187020 | 786106 | 1915585 | 2778003 | 2.000 |
| Cambodia | 1952 | 191505 | 816730 | 1966918 | 2847686 | 2.000 |
| Cambodia | 1953 | 196556 | 847016 | 2020374 | 2919233 | 2.000 |
| Cambodia | 1954 | 201835 | 872994 | 2076826 | 2993439 | 2.000 |
| Cambodia | 1955 | 207399 | 896649 | 2136902 | 3071111 | 2.000 |
| Cambodia | 1956 | 212963 | 921749 | 2200334 | 3151894 | 1.000 |
| Cambodia | 1957 | 218143 | 947682 | 2266675 | 3235486 | 1.000 |
| Cambodia | 1958 | 220113 | 970598 | 2332281 | 3317890 | 1.000 |
| Cambodia | 1959 | 219326 | 987914 | 2394722 | 3397785 | 1.000 |
| Cambodia | 1960 | 218630 | 999917 | 2454759 | 3476898 | 1.000 |
| Cambodia | 1961 | 218455 | 1006945 | 2512735 | 3554668 | 1.000 |
| Cambodia | 1962 | 218999 | 1009982 | 2569307 | 3631584 | 1.000 |
| Cambodia | 1963 | 219310 | 1011480 | 2622302 | 3707415 | 1.000 |
| Cambodia | 1964 | 222128 | 1016284 | 2670198 | 3784719 | 1.000 |
| Cambodia | 1965 | 226899 | 1026121 | 2715998 | 3864917 | 1.000 |
| Cambodia | 1966 | 230535 | 1039130 | 2761608 | 3945490 | 1.000 |
| Cambodia | 1967 | 233811 | 1054379 | 2806456 | 4026286 | 1.000 |
| Cambodia | 1968 | 236930 | 1072045 | 2849849 | 4107454 | 1.000 |
| Cambodia | 1969 | 239613 | 1089581 | 2891146 | 4188815 | 1.000 |
| Cambodia | 1970 | 245810 | 1105026 | 2925328 | 4234369 | 2.000 |
| Cambodia | 1971 | 251256 | 1121630 | 2957572 | 4270680 | 2.000 |
| Cambodia | 1972 | 255665 | 1143853 | 2997720 | 4347200 | 2.000 |
| Cambodia | 1973 | 253006 | 1161109 | 3033786 | 4427125 | 2.000 |
| Cambodia | 1974 | 232686 | 1154897 | 3047455 | 4478408 | 3.000 |
| Cambodia | 1975 | 195752 | 1066808 | 2959596 | 4385856 | 3.000 |
| Cambodia | 1976 | 163274 | 929984 | 2767952 | 4145010 | 2.000 |
| Cambodia | 1977 | 140256 | 818694 | 2610515 | 3966712 | 2.000 |
| Cambodia | 1978 | 140433 | 741203 | 2533109 | 3901450 | 2.000 |
| Cambodia | 1979 | 182981 | 737877 | 2525148 | 3937859 | 2.000 |
| Cambodia | 1980 | 243809 | 814628 | 2574356 | 4026059 | 2.000 |
| Cambodia | 1981 | 282440 | 937729 | 2654633 | 4135606 | 2.000 |
| Cambodia | 1982 | 298961 | 1093893 | 2755331 | 4284487 | 3.000 |
| Cambodia | 1983 | 317550 | 1263470 | 2870534 | 4439543 | 3.000 |
| Cambodia | 1984 | 333640 | 1407108 | 2997133 | 4594628 | 3.000 |
| Cambodia | 1985 | 344982 | 1504322 | 3128002 | 4748687 | 4.000 |
| Cambodia | 1986 | 352048 | 1573274 | 3264706 | 4921606 | 4.000 |
| Cambodia | 1987 | 359310 | 1634560 | 3408109 | 5106372 | 4.000 |
| Cambodia | 1988 | 365690 | 1683794 | 3561484 | 5283431 | 5.000 |
| Cambodia | 1989 | 367229 | 1719338 | 3735855 | 5460685 | 5.000 |
| Cambodia | 1990 | 370316 | 1747803 | 3934593 | 5650610 | 6.000 |
| Cambodia | 1991 | 377447 | 1775815 | 4150863 | 5843411 | 6.000 |
| Cambodia | 1992 | 382598 | 1803991 | 4392965 | 6077643 | 6.000 |
| Cambodia | 1993 | 387810 | 1831034 | 4639850 | 6332515 | 6.000 |
| Cambodia | 1994 | 388312 | 1850235 | 4837512 | 6525769 | 7.000 |
| Cambodia | 1995 | 378229 | 1852162 | 4963571 | 6662613 | 9.000 |
| Cambodia | 1996 | 362335 | 1831631 | 5038924 | 6779748 | 9.000 |
| Cambodia | 1997 | 346689 | 1792673 | 5084388 | 6883094 | 10.000 |
| Cambodia | 1998 | 331972 | 1679192 | 5000919 | 6909667 | 11.000 |
| Cambodia | 1999 | 322585 | 1569993 | 4893634 | 6946669 | 12.000 |
| Cambodia | 2000 | 317767 | 1537449 | 4869765 | 7067775 | 13.000 |
| Cambodia | 2001 | 314523 | 1521868 | 4839432 | 7201291 | 14.000 |
| Cambodia | 2002 | 314791 | 1531865 | 4807232 | 7354616 | 15.000 |
| Cambodia | 2003 | 315386 | 1542507 | 4773122 | 7509039 | 17.000 |
| Cambodia | 2004 | 316390 | 1542412 | 4741686 | 7631375 | 19.000 |
| Cambodia | 2005 | 318721 | 1548395 | 4712917 | 7705544 | 21.000 |
| Cambodia | 2006 | 321310 | 1558941 | 4683338 | 7749053 | 23.000 |
| Cambodia | 2007 | 325791 | 1572976 | 4658685 | 7785986 | 25.000 |
| Cambodia | 2008 | 329293 | 1588346 | 4635173 | 7801073 | 27.000 |
| Cambodia | 2009 | 329863 | 1602530 | 4615105 | 7787602 | 30.000 |
| Cambodia | 2010 | 330041 | 1615169 | 4609820 | 7763937 | 33.000 |
| Cambodia | 2011 | 330487 | 1625791 | 4623794 | 7741108 | 36.000 |
| Cambodia | 2012 | 333288 | 1634928 | 4663378 | 7719562 | 39.000 |
| Cambodia | 2013 | 336233 | 1643330 | 4703917 | 7698564 | 42.000 |
| Cambodia | 2014 | 337637 | 1652055 | 4732419 | 7680385 | 45.000 |
| Cambodia | 2015 | 337529 | 1660203 | 4762926 | 7662736 | 48.000 |
| Cambodia | 2016 | 335469 | 1665895 | 4792943 | 7646327 | 53.000 |
| Cambodia | 2017 | 332545 | 1665943 | 4818464 | 7632136 | 58.000 |
| Cambodia | 2018 | 328817 | 1659062 | 4837527 | 7611894 | 62.000 |
| Cambodia | 2019 | 324534 | 1646250 | 4849865 | 7587802 | 66.000 |
| Cambodia | 2020 | 320805 | 1630328 | 4857657 | 7585089 | 70.000 |
| Cambodia | 2021 | 316916 | 1613064 | 4860476 | 7615851 | 74.000 |
| Indonesia | 1950 | 2436714 | 10591064 | 28713374 | 43200884 | 30.000 |
| Indonesia | 1951 | 2501780 | 10695802 | 28928030 | 43807016 | 58.000 |
| Indonesia | 1952 | 2600443 | 10904529 | 29219846 | 44473868 | 84.000 |
| Indonesia | 1953 | 2705999 | 11227549 | 29601248 | 45204132 | 101.000 |
| Indonesia | 1954 | 2812759 | 11639427 | 30075548 | 45998740 | 105.000 |
| Indonesia | 1955 | 2916759 | 12120773 | 30646676 | 46866990 | 104.000 |
| Indonesia | 1956 | 3023501 | 12641290 | 31322220 | 47814610 | 104.000 |
| Indonesia | 1957 | 3135515 | 13176442 | 32109492 | 48846600 | 103.000 |
| Indonesia | 1958 | 3245983 | 13717983 | 33007226 | 49957336 | 104.000 |
| Indonesia | 1959 | 3355184 | 14262777 | 34014256 | 51145264 | 106.000 |
| Indonesia | 1960 | 3467526 | 14815799 | 35130644 | 52412590 | 107.000 |
| Indonesia | 1961 | 3575932 | 15370260 | 36341184 | 53754870 | 109.000 |
| Indonesia | 1962 | 3674295 | 15912027 | 37646628 | 55168490 | 112.000 |
| Indonesia | 1963 | 3767829 | 16438324 | 39047004 | 56655012 | 115.000 |
| Indonesia | 1964 | 3857812 | 16948076 | 40520292 | 58222090 | 123.000 |
| Indonesia | 1965 | 3923703 | 17365228 | 41949284 | 59720212 | 114.000 |
| Indonesia | 1966 | 3985724 | 17737152 | 43350676 | 61223280 | 82.000 |
| Indonesia | 1967 | 4052698 | 18141172 | 44805140 | 62909076 | 51.000 |
| Indonesia | 1968 | 4101467 | 18524678 | 46243020 | 64713110 | 44.000 |
| Indonesia | 1969 | 4153618 | 18886972 | 47645944 | 66610270 | 62.000 |
| Indonesia | 1970 | 4207486 | 19226632 | 49011508 | 68570500 | 89.000 |
| Indonesia | 1971 | 4250621 | 19528572 | 50324430 | 70564420 | 115.000 |
| Indonesia | 1972 | 4293216 | 19803112 | 51580024 | 72600140 | 137.000 |
| Indonesia | 1973 | 4346583 | 20080420 | 52790730 | 74692460 | 153.000 |
| Indonesia | 1974 | 4384277 | 20342898 | 53941944 | 76805870 | 164.000 |
| Indonesia | 1975 | 4422788 | 20590340 | 55031976 | 78926800 | 171.000 |
| Indonesia | 1976 | 4471771 | 20842698 | 56074244 | 81033980 | 175.000 |
| Indonesia | 1977 | 4511466 | 21090700 | 57068640 | 83092000 | 177.000 |
| Indonesia | 1978 | 4564557 | 21338206 | 58035270 | 85110184 | 179.000 |
| Indonesia | 1979 | 4620764 | 21601812 | 58978596 | 87089380 | 183.000 |
| Indonesia | 1980 | 4663058 | 21866646 | 59884424 | 89018300 | 187.000 |
| Indonesia | 1981 | 4692695 | 22111268 | 60737190 | 90881520 | 193.000 |
| Indonesia | 1982 | 4726801 | 22349784 | 61552410 | 92680500 | 200.000 |
| Indonesia | 1983 | 4743492 | 22553208 | 62332250 | 94400184 | 207.000 |
| Indonesia | 1984 | 4727903 | 22687012 | 63042490 | 96006870 | 217.000 |
| Indonesia | 1985 | 4650975 | 22703840 | 63621790 | 97436776 | 227.000 |
| Indonesia | 1986 | 4540068 | 22583812 | 64048284 | 98661304 | 235.000 |
| Indonesia | 1987 | 4497124 | 22393006 | 64391850 | 99757410 | 242.000 |
| Indonesia | 1988 | 4503783 | 22197488 | 64692304 | 100781050 | 249.000 |
| Indonesia | 1989 | 4497115 | 22013560 | 64950956 | 101723230 | 258.000 |
| Indonesia | 1990 | 4459122 | 21867476 | 65136416 | 102552780 | 268.000 |
| Indonesia | 1991 | 4462556 | 21832220 | 65280508 | 103306770 | 277.000 |
| Indonesia | 1992 | 4466627 | 21841486 | 65391640 | 103996390 | 287.000 |
| Indonesia | 1993 | 4448658 | 21825060 | 65436416 | 104620320 | 299.000 |
| Indonesia | 1994 | 4472754 | 21838028 | 65453296 | 105217180 | 314.000 |
| Indonesia | 1995 | 4508608 | 21921408 | 65465064 | 105795736 | 332.000 |
| Indonesia | 1996 | 4553700 | 22044140 | 65491680 | 106372860 | 354.000 |
| Indonesia | 1997 | 4599479 | 22205748 | 65528490 | 106948264 | 378.000 |
| Indonesia | 1998 | 4596552 | 22378360 | 65542404 | 107462856 | 400.000 |
| Indonesia | 1999 | 4546999 | 22475104 | 65516590 | 107881230 | 423.000 |
| Indonesia | 2000 | 4521298 | 22509048 | 65532012 | 108226130 | 443.000 |
| Indonesia | 2001 | 4524714 | 22500384 | 65648480 | 108517520 | 461.000 |
| Indonesia | 2002 | 4520666 | 22440900 | 65793476 | 108756980 | 481.000 |
| Indonesia | 2003 | 4514962 | 22376916 | 65918240 | 108933060 | 502.000 |
| Indonesia | 2004 | 4524471 | 22359428 | 66025444 | 109024290 | 526.000 |
| Indonesia | 2005 | 4571989 | 22415892 | 66209610 | 109118800 | 555.000 |
| Indonesia | 2006 | 4648239 | 22556644 | 66485456 | 109293950 | 588.000 |
| Indonesia | 2007 | 4738892 | 22791540 | 66841216 | 109524060 | 628.000 |
| Indonesia | 2008 | 4795722 | 23088384 | 67264140 | 109788310 | 676.000 |
| Indonesia | 2009 | 4795030 | 23370922 | 67657016 | 110060830 | 729.000 |
| Indonesia | 2010 | 4795766 | 23603716 | 68012100 | 110405176 | 790.000 |
| Indonesia | 2011 | 4856565 | 23821878 | 68381510 | 110912780 | 864.000 |
| Indonesia | 2012 | 4913668 | 24006944 | 68760780 | 111513704 | 944.000 |
| Indonesia | 2013 | 4863145 | 24084022 | 69089020 | 112049864 | 1024.000 |
| Indonesia | 2014 | 4782831 | 24080194 | 69381944 | 112501290 | 1103.000 |
| Indonesia | 2015 | 4718817 | 24010696 | 69632940 | 112912536 | 1179.000 |
| Indonesia | 2016 | 4654031 | 23815582 | 69813150 | 113243740 | 1250.000 |
| Indonesia | 2017 | 4585510 | 23495150 | 69926740 | 113491230 | 1322.000 |
| Indonesia | 2018 | 4524618 | 23163588 | 69982900 | 113685544 | 1399.000 |
| Indonesia | 2019 | 4490630 | 22877436 | 69990360 | 113815300 | 1483.000 |
| Indonesia | 2020 | 4463186 | 22627598 | 69918980 | 113878620 | 1542.000 |
| Indonesia | 2021 | 4435250 | 22414316 | 69742696 | 113864904 | 1551.000 |
| Laos | 1950 | 66020 | 275009 | 681112 | 1003426 | 1.000 |
| Laos | 1951 | 71076 | 284849 | 701064 | 1027772 | 1.000 |
| Laos | 1952 | 72191 | 293769 | 720607 | 1052084 | 0.000 |
| Laos | 1953 | 73494 | 302786 | 740388 | 1077010 | 0.000 |
| Laos | 1954 | 74713 | 313473 | 760634 | 1102663 | 0.000 |
| Laos | 1955 | 75978 | 322522 | 781469 | 1129168 | 0.000 |
| Laos | 1956 | 77411 | 328741 | 802871 | 1156682 | 0.000 |
| Laos | 1957 | 78817 | 335219 | 824594 | 1185144 | 0.000 |
| Laos | 1958 | 80275 | 341837 | 846514 | 1214515 | 0.000 |
| Laos | 1959 | 81877 | 348825 | 868614 | 1244670 | 0.000 |
| Laos | 1960 | 83511 | 356174 | 890780 | 1275608 | 0.000 |
| Laos | 1961 | 85282 | 363857 | 913080 | 1307496 | 0.000 |
| Laos | 1962 | 87160 | 371974 | 935732 | 1340410 | 0.000 |
| Laos | 1963 | 89078 | 380535 | 959251 | 1374275 | 0.000 |
| Laos | 1964 | 91049 | 389455 | 985177 | 1409209 | 0.000 |
| Laos | 1965 | 93127 | 398788 | 1010350 | 1445580 | 0.000 |
| Laos | 1966 | 95264 | 408394 | 1033396 | 1483104 | 0.000 |
| Laos | 1967 | 97517 | 418368 | 1057485 | 1521790 | 0.000 |
| Laos | 1968 | 99919 | 428896 | 1082720 | 1561749 | 0.000 |
| Laos | 1969 | 102428 | 439952 | 1109139 | 1602750 | 0.000 |
| Laos | 1970 | 105198 | 451693 | 1136952 | 1644895 | 0.000 |
| Laos | 1971 | 107936 | 463977 | 1166015 | 1688145 | 0.000 |
| Laos | 1972 | 110609 | 476624 | 1196252 | 1732514 | 0.000 |
| Laos | 1973 | 113478 | 489686 | 1227718 | 1778381 | 0.000 |
| Laos | 1974 | 116524 | 503107 | 1260196 | 1826504 | 0.000 |
| Laos | 1975 | 119359 | 516337 | 1293154 | 1872357 | 0.000 |
| Laos | 1976 | 121632 | 528774 | 1325707 | 1913428 | 0.000 |
| Laos | 1977 | 123397 | 540168 | 1357490 | 1952914 | 0.000 |
| Laos | 1978 | 124831 | 550407 | 1388744 | 1992382 | 0.000 |
| Laos | 1979 | 126456 | 559958 | 1420290 | 2034257 | 0.000 |
| Laos | 1980 | 128673 | 569881 | 1453218 | 2080653 | 0.000 |
| Laos | 1981 | 131511 | 581066 | 1488042 | 2132149 | 0.000 |
| Laos | 1982 | 135020 | 594210 | 1525047 | 2188589 | 0.000 |
| Laos | 1983 | 139039 | 609735 | 1564360 | 2249184 | 0.000 |
| Laos | 1984 | 143392 | 627562 | 1605998 | 2313130 | 0.000 |
| Laos | 1985 | 147786 | 647208 | 1649733 | 2380101 | 0.000 |
| Laos | 1986 | 152015 | 668043 | 1695435 | 2449630 | 0.000 |
| Laos | 1987 | 156142 | 689418 | 1743016 | 2521272 | 0.000 |
| Laos | 1988 | 160192 | 710843 | 1792231 | 2594752 | 1.000 |
| Laos | 1989 | 164329 | 732095 | 1842948 | 2669891 | 1.000 |
| Laos | 1990 | 168427 | 753082 | 1895137 | 2746319 | 1.000 |
| Laos | 1991 | 172269 | 773778 | 1948933 | 2823815 | 1.000 |
| Laos | 1992 | 175393 | 793591 | 2003879 | 2901721 | 2.000 |
| Laos | 1993 | 177777 | 811863 | 2059320 | 2979365 | 1.000 |
| Laos | 1994 | 178609 | 826957 | 2113452 | 3055175 | 0.000 |
| Laos | 1995 | 177770 | 837346 | 2164339 | 3127505 | 0.000 |
| Laos | 1996 | 176668 | 843169 | 2211507 | 3196517 | 1.000 |
| Laos | 1997 | 176490 | 842408 | 2248780 | 3253797 | 1.000 |
| Laos | 1998 | 175786 | 835268 | 2275407 | 3299158 | 1.000 |
| Laos | 1999 | 173835 | 826392 | 2297050 | 3341664 | 1.000 |
| Laos | 2000 | 172279 | 818984 | 2314497 | 3382468 | 1.000 |
| Laos | 2001 | 170493 | 813660 | 2327603 | 3421836 | 82.000 |
| Laos | 2002 | 167891 | 808501 | 2335499 | 3458969 | 227.000 |
| Laos | 2003 | 164633 | 801332 | 2337247 | 3492720 | 356.000 |
| Laos | 2004 | 161370 | 791722 | 2332557 | 3522535 | 480.000 |
| Laos | 2005 | 161834 | 783333 | 2322931 | 3551451 | 533.000 |
| Laos | 2006 | 163895 | 778524 | 2310813 | 3579396 | 476.000 |
| Laos | 2007 | 163620 | 776392 | 2298502 | 3602994 | 371.000 |
| Laos | 2008 | 162835 | 776934 | 2287632 | 3622001 | 270.000 |
| Laos | 2009 | 161905 | 778946 | 2279329 | 3636594 | 194.000 |
| Laos | 2010 | 160803 | 779370 | 2273197 | 3646802 | 142.000 |
| Laos | 2011 | 159660 | 776917 | 2268101 | 3652654 | 112.000 |
| Laos | 2012 | 158776 | 773319 | 2263588 | 3654747 | 116.000 |
| Laos | 2013 | 158186 | 769673 | 2258167 | 3653794 | 190.000 |
| Laos | 2014 | 157216 | 765974 | 2250480 | 3650424 | 388.000 |
| Laos | 2015 | 158287 | 766893 | 2248627 | 3656563 | 550.000 |
| Laos | 2016 | 160335 | 773080 | 2255328 | 3673257 | 536.000 |
| Laos | 2017 | 160525 | 779599 | 2265060 | 3689525 | 445.000 |
| Laos | 2018 | 160108 | 785249 | 2276319 | 3704602 | 342.000 |
| Laos | 2019 | 159474 | 789310 | 2287092 | 3718439 | 254.000 |
| Laos | 2020 | 159244 | 790760 | 2296412 | 3731393 | 189.000 |
| Laos | 2021 | 158809 | 789704 | 2303010 | 3743066 | 138.000 |
| Thailand | 1950 | 791526 | 3347839 | 8605014 | 12717464 | 806.000 |
| Thailand | 1951 | 822697 | 3501172 | 8824841 | 13053160 | 774.000 |
| Thailand | 1952 | 851130 | 3659715 | 9055251 | 13400662 | 750.000 |
| Thailand | 1953 | 880945 | 3823991 | 9301239 | 13759175 | 718.000 |
| Thailand | 1954 | 908497 | 3981356 | 9573581 | 14133156 | 678.000 |
| Thailand | 1955 | 933665 | 4123724 | 9876674 | 14525890 | 636.000 |
| Thailand | 1956 | 959506 | 4261718 | 10206145 | 14936928 | 616.000 |
| Thailand | 1957 | 985080 | 4397528 | 10558718 | 15366313 | 621.000 |
| Thailand | 1958 | 1010933 | 4528508 | 10929353 | 15806675 | 624.000 |
| Thailand | 1959 | 1038838 | 4661119 | 11324153 | 16265950 | 617.000 |
| Thailand | 1960 | 1067458 | 4800290 | 11745401 | 16754818 | 614.000 |
| Thailand | 1961 | 1097593 | 4944630 | 12184977 | 17266758 | 631.000 |
| Thailand | 1962 | 1129840 | 5095330 | 12637076 | 17797768 | 659.000 |
| Thailand | 1963 | 1162222 | 5251204 | 13100009 | 18351082 | 683.000 |
| Thailand | 1964 | 1190363 | 5406315 | 13558731 | 18933160 | 696.000 |
| Thailand | 1965 | 1213101 | 5556049 | 14002136 | 19543924 | 707.000 |
| Thailand | 1966 | 1232332 | 5694977 | 14433577 | 20172032 | 716.000 |
| Thailand | 1967 | 1248588 | 5818173 | 14852824 | 20812098 | 718.000 |
| Thailand | 1968 | 1261780 | 5922706 | 15255486 | 21461232 | 734.000 |
| Thailand | 1969 | 1269297 | 6007260 | 15637382 | 22112636 | 792.000 |
| Thailand | 1970 | 1271376 | 6073540 | 15999598 | 22764262 | 899.000 |
| Thailand | 1971 | 1269642 | 6120676 | 16337278 | 23403602 | 1049.000 |
| Thailand | 1972 | 1265803 | 6149502 | 16648972 | 24024056 | 1232.000 |
| Thailand | 1973 | 1257604 | 6158815 | 16930358 | 24623810 | 1420.000 |
| Thailand | 1974 | 1243388 | 6146670 | 17171832 | 25178048 | 1585.000 |
| Thailand | 1975 | 1227081 | 6115682 | 17370712 | 25674792 | 1727.000 |
| Thailand | 1976 | 1206168 | 6064229 | 17520288 | 26115148 | 1851.000 |
| Thailand | 1977 | 1182851 | 5993225 | 17618368 | 26510686 | 1942.000 |
| Thailand | 1978 | 1166267 | 5914203 | 17671568 | 26869592 | 2030.000 |
| Thailand | 1979 | 1160411 | 5842582 | 17691980 | 27194408 | 2164.000 |
| Thailand | 1980 | 1169853 | 5796204 | 17701400 | 27509384 | 2357.000 |
| Thailand | 1981 | 1173734 | 5773056 | 17695996 | 27804680 | 2602.000 |
| Thailand | 1982 | 1154889 | 5752698 | 17654888 | 28055790 | 2886.000 |
| Thailand | 1983 | 1128874 | 5722859 | 17575762 | 28263492 | 3191.000 |
| Thailand | 1984 | 1108260 | 5678027 | 17468032 | 28427152 | 3498.000 |
| Thailand | 1985 | 1093834 | 5609034 | 17341684 | 28548128 | 3807.000 |
| Thailand | 1986 | 1083559 | 5525165 | 17203542 | 28626652 | 4136.000 |
| Thailand | 1987 | 1072415 | 5447825 | 17054796 | 28660086 | 4502.000 |
| Thailand | 1988 | 1059874 | 5383491 | 16899384 | 28650852 | 4885.000 |
| Thailand | 1989 | 1060299 | 5339173 | 16753852 | 28606512 | 5255.000 |
| Thailand | 1990 | 1068680 | 5308797 | 16570684 | 28392068 | 5613.000 |
| Thailand | 1991 | 1059009 | 5270611 | 16376987 | 28048764 | 5950.000 |
| Thailand | 1992 | 1022587 | 5205157 | 16211480 | 27655560 | 6258.000 |
| Thailand | 1993 | 993247 | 5125154 | 16062758 | 27195158 | 6571.000 |
| Thailand | 1994 | 986095 | 5059209 | 15958526 | 26754896 | 6955.000 |
| Thailand | 1995 | 993111 | 5010584 | 15887403 | 26396482 | 7416.000 |
| Thailand | 1996 | 988973 | 4971269 | 15817361 | 26123652 | 7819.000 |
| Thailand | 1997 | 960229 | 4940489 | 15716457 | 25894696 | 8054.000 |
| Thailand | 1998 | 929509 | 4899994 | 15586118 | 25715348 | 8090.999 |
| Thailand | 1999 | 886774 | 4807245 | 15412407 | 25548920 | 7872.000 |
| Thailand | 2000 | 855626 | 4659042 | 15171294 | 25411652 | 7548.000 |
| Thailand | 2001 | 852249 | 4508292 | 14903942 | 25313320 | 7356.000 |
| Thailand | 2002 | 850179 | 4389942 | 14664060 | 25202780 | 7297.000 |
| Thailand | 2003 | 841850 | 4298837 | 14447709 | 25052336 | 7277.000 |
| Thailand | 2004 | 833040 | 4239108 | 14248844 | 24851840 | 7244.000 |
| Thailand | 2005 | 827105 | 4196117 | 14051881 | 24611004 | 7200.000 |
| Thailand | 2006 | 824324 | 4152500 | 13850250 | 24335994 | 7724.000 |
| Thailand | 2007 | 824505 | 4117210 | 13669938 | 24030148 | 8722.000 |
| Thailand | 2008 | 823108 | 4096838 | 13513340 | 23724764 | 9677.000 |
| Thailand | 2009 | 818262 | 4085647 | 13361752 | 23447268 | 10780.000 |
| Thailand | 2010 | 810606 | 4076776 | 13168815 | 23213238 | 11911.000 |
| Thailand | 2011 | 810136 | 4071738 | 12937849 | 23021590 | 13008.000 |
| Thailand | 2012 | 809984 | 4064313 | 12720798 | 22842044 | 14220.000 |
| Thailand | 2013 | 795584 | 4042265 | 12534297 | 22645824 | 15606.000 |
| Thailand | 2014 | 774460 | 4000829 | 12379351 | 22425364 | 17154.000 |
| Thailand | 2015 | 751912 | 3941600 | 12232957 | 22166186 | 18788.000 |
| Thailand | 2016 | 729782 | 3861302 | 12083166 | 21876328 | 20474.000 |
| Thailand | 2017 | 711214 | 3763051 | 11936831 | 21582544 | 22173.000 |
| Thailand | 2018 | 692644 | 3659288 | 11792333 | 21276720 | 23800.000 |
| Thailand | 2019 | 673328 | 3556747 | 11641699 | 20949746 | 25381.000 |
| Thailand | 2020 | 658324 | 3462603 | 11483264 | 20588424 | 27053.000 |
| Thailand | 2021 | 646441 | 3379029 | 11313246 | 20188312 | 28840.000 |
| Vietnam | 1950 | 904341 | 3406207 | 8236495 | 12939915 | 175.000 |
| Vietnam | 1951 | 872254 | 3658999 | 8518370 | 13255227 | 157.000 |
| Vietnam | 1952 | 916499 | 3933555 | 8857408 | 13620701 | 143.000 |
| Vietnam | 1953 | 987067 | 4239036 | 9276998 | 14056521 | 128.000 |
| Vietnam | 1954 | 1033108 | 4469899 | 9743695 | 14526850 | 107.000 |
| Vietnam | 1955 | 1074295 | 4646879 | 10254732 | 15031625 | 89.000 |
| Vietnam | 1956 | 1074354 | 4853964 | 10770431 | 15527478 | 80.000 |
| Vietnam | 1957 | 1150260 | 5094240 | 11360715 | 16082264 | 81.000 |
| Vietnam | 1958 | 1223770 | 5339792 | 12017473 | 16699967 | 81.000 |
| Vietnam | 1959 | 1251278 | 5564662 | 12690551 | 17350838 | 78.000 |
| Vietnam | 1960 | 1273669 | 5769543 | 13372094 | 18038516 | 74.000 |
| Vietnam | 1961 | 1209390 | 5907424 | 13972092 | 18674658 | 74.000 |
| Vietnam | 1962 | 1222085 | 5985114 | 14564295 | 19335976 | 78.000 |
| Vietnam | 1963 | 1325018 | 6091700 | 15216631 | 20103120 | 80.000 |
| Vietnam | 1964 | 1337453 | 6179591 | 15760867 | 20878040 | 77.000 |
| Vietnam | 1965 | 1324564 | 6230985 | 16194742 | 21636756 | 73.000 |
| Vietnam | 1966 | 1302531 | 6318906 | 16628004 | 22369852 | 70.000 |
| Vietnam | 1967 | 1287368 | 6378912 | 16999532 | 23081304 | 67.000 |
| Vietnam | 1968 | 1308943 | 6354927 | 17311382 | 23787154 | 67.000 |
| Vietnam | 1969 | 1343891 | 6351816 | 17604120 | 24507490 | 74.000 |
| Vietnam | 1970 | 1371061 | 6394558 | 17887090 | 25248128 | 86.000 |
| Vietnam | 1971 | 1411902 | 6503486 | 18210916 | 26026550 | 100.000 |
| Vietnam | 1972 | 1463216 | 6672287 | 18500428 | 26812640 | 114.000 |
| Vietnam | 1973 | 1517283 | 6870924 | 18767206 | 27590598 | 127.000 |
| Vietnam | 1974 | 1535351 | 7056383 | 19030136 | 28280518 | 139.000 |
| Vietnam | 1975 | 1535793 | 7227690 | 19289618 | 28910036 | 153.000 |
| Vietnam | 1976 | 1557453 | 7399217 | 19656850 | 29629264 | 167.000 |
| Vietnam | 1977 | 1581537 | 7544465 | 20043754 | 30345182 | 181.000 |
| Vietnam | 1978 | 1615355 | 7662825 | 20370234 | 31026592 | 198.000 |
| Vietnam | 1979 | 1654524 | 7811401 | 20697166 | 31559350 | 214.000 |
| Vietnam | 1980 | 1687834 | 7982865 | 21081220 | 32066740 | 229.000 |
| Vietnam | 1981 | 1727824 | 8148518 | 21563076 | 32720200 | 247.000 |
| Vietnam | 1982 | 1770878 | 8332010 | 22103176 | 33346562 | 266.000 |
| Vietnam | 1983 | 1803160 | 8514784 | 22652416 | 33940660 | 287.000 |
| Vietnam | 1984 | 1825995 | 8684736 | 23186152 | 34536810 | 312.000 |
| Vietnam | 1985 | 1839951 | 8838227 | 23703104 | 35132708 | 339.000 |
| Vietnam | 1986 | 1849091 | 8961830 | 24186690 | 35800612 | 369.000 |
| Vietnam | 1987 | 1849813 | 9044322 | 24616420 | 36465010 | 404.000 |
| Vietnam | 1988 | 1845650 | 9090792 | 24981472 | 37044270 | 441.000 |
| Vietnam | 1989 | 1845054 | 9111796 | 25319184 | 37638690 | 482.000 |
| Vietnam | 1990 | 1846332 | 9119439 | 25647418 | 38267852 | 528.000 |
| Vietnam | 1991 | 1844494 | 9118764 | 25945640 | 38920040 | 583.000 |
| Vietnam | 1992 | 1827762 | 9102739 | 26200188 | 39571170 | 646.000 |
| Vietnam | 1993 | 1789109 | 9053587 | 26382816 | 40159570 | 717.000 |
| Vietnam | 1994 | 1725679 | 8942274 | 26467350 | 40646210 | 797.000 |
| Vietnam | 1995 | 1636148 | 8741097 | 26435028 | 41020410 | 886.000 |
| Vietnam | 1996 | 1540415 | 8446859 | 26271008 | 41263800 | 984.000 |
| Vietnam | 1997 | 1467157 | 8095657 | 25992636 | 41374828 | 1086.000 |
| Vietnam | 1998 | 1418011 | 7733584 | 25636004 | 41373850 | 1199.000 |
| Vietnam | 1999 | 1389736 | 7404283 | 25227684 | 41291184 | 1341.000 |
| Vietnam | 2000 | 1389900 | 7161361 | 24785584 | 41078796 | 1510.000 |
| Vietnam | 2001 | 1402236 | 7025184 | 24335702 | 40753684 | 1715.000 |
| Vietnam | 2002 | 1421677 | 6981135 | 23916988 | 40422490 | 1958.000 |
| Vietnam | 2003 | 1433495 | 6998144 | 23524634 | 40085696 | 2213.000 |
| Vietnam | 2004 | 1437726 | 7047756 | 23142328 | 39737364 | 2449.000 |
| Vietnam | 2005 | 1436024 | 7095286 | 22758324 | 39380230 | 2654.000 |
| Vietnam | 2006 | 1414986 | 7109273 | 22354948 | 38994796 | 2832.000 |
| Vietnam | 2007 | 1413046 | 7101911 | 21965246 | 38602828 | 2983.000 |
| Vietnam | 2008 | 1433516 | 7103258 | 21633178 | 38239836 | 3133.000 |
| Vietnam | 2009 | 1445612 | 7112803 | 21383252 | 37950040 | 3321.000 |
| Vietnam | 2010 | 1450747 | 7129394 | 21230458 | 37728160 | 3548.000 |
| Vietnam | 2011 | 1462871 | 7178658 | 21175292 | 37525296 | 3813.000 |
| Vietnam | 2012 | 1486438 | 7252917 | 21208004 | 37344696 | 4119.000 |
| Vietnam | 2013 | 1512565 | 7332431 | 21310790 | 37186532 | 4423.000 |
| Vietnam | 2014 | 1524609 | 7411583 | 21451364 | 37026736 | 4675.000 |
| Vietnam | 2015 | 1524401 | 7485260 | 21590510 | 36846110 | 4880.000 |
| Vietnam | 2016 | 1515441 | 7537840 | 21707980 | 36636264 | 5066.000 |
| Vietnam | 2017 | 1498956 | 7550472 | 21789420 | 36404380 | 5236.000 |
| Vietnam | 2018 | 1487172 | 7525360 | 21847120 | 36178590 | 5414.000 |
| Vietnam | 2019 | 1480585 | 7481736 | 21893514 | 35990370 | 5660.000 |
| Vietnam | 2020 | 1471822 | 7429597 | 21932616 | 35867816 | 6021.000 |
| Vietnam | 2021 | 1453563 | 7368156 | 21974312 | 35811056 | 6395.000 |
lập bảng tần số cho bảng vừa lọc ra ở cột ‘c’ bằng lệnh
table(qh1$c)##
## Cambodia Indonesia Laos Thailand Vietnam
## 72 72 72 72 72Ta thấy mỗi quốc gia xuất hiện 72 lần (đây là điều hiển nhiên)
Tạo 1 cột mới tên “Density’ để đánh giá mức dân số bằng lệnh
qh1$Density <- ifelse(qh1$u25 > 5000000, 'Dong', 'Khong dong')
table <- knitr::kable(qh1, format = "markdown")
table| c | y | u1 | u5 | u15 | u25 | o100 | Density |
|---|---|---|---|---|---|---|---|
| Cambodia | 1950 | 182915 | 756813 | 1865760 | 2710160 | 2.000 | Khong dong |
| Cambodia | 1951 | 187020 | 786106 | 1915585 | 2778003 | 2.000 | Khong dong |
| Cambodia | 1952 | 191505 | 816730 | 1966918 | 2847686 | 2.000 | Khong dong |
| Cambodia | 1953 | 196556 | 847016 | 2020374 | 2919233 | 2.000 | Khong dong |
| Cambodia | 1954 | 201835 | 872994 | 2076826 | 2993439 | 2.000 | Khong dong |
| Cambodia | 1955 | 207399 | 896649 | 2136902 | 3071111 | 2.000 | Khong dong |
| Cambodia | 1956 | 212963 | 921749 | 2200334 | 3151894 | 1.000 | Khong dong |
| Cambodia | 1957 | 218143 | 947682 | 2266675 | 3235486 | 1.000 | Khong dong |
| Cambodia | 1958 | 220113 | 970598 | 2332281 | 3317890 | 1.000 | Khong dong |
| Cambodia | 1959 | 219326 | 987914 | 2394722 | 3397785 | 1.000 | Khong dong |
| Cambodia | 1960 | 218630 | 999917 | 2454759 | 3476898 | 1.000 | Khong dong |
| Cambodia | 1961 | 218455 | 1006945 | 2512735 | 3554668 | 1.000 | Khong dong |
| Cambodia | 1962 | 218999 | 1009982 | 2569307 | 3631584 | 1.000 | Khong dong |
| Cambodia | 1963 | 219310 | 1011480 | 2622302 | 3707415 | 1.000 | Khong dong |
| Cambodia | 1964 | 222128 | 1016284 | 2670198 | 3784719 | 1.000 | Khong dong |
| Cambodia | 1965 | 226899 | 1026121 | 2715998 | 3864917 | 1.000 | Khong dong |
| Cambodia | 1966 | 230535 | 1039130 | 2761608 | 3945490 | 1.000 | Khong dong |
| Cambodia | 1967 | 233811 | 1054379 | 2806456 | 4026286 | 1.000 | Khong dong |
| Cambodia | 1968 | 236930 | 1072045 | 2849849 | 4107454 | 1.000 | Khong dong |
| Cambodia | 1969 | 239613 | 1089581 | 2891146 | 4188815 | 1.000 | Khong dong |
| Cambodia | 1970 | 245810 | 1105026 | 2925328 | 4234369 | 2.000 | Khong dong |
| Cambodia | 1971 | 251256 | 1121630 | 2957572 | 4270680 | 2.000 | Khong dong |
| Cambodia | 1972 | 255665 | 1143853 | 2997720 | 4347200 | 2.000 | Khong dong |
| Cambodia | 1973 | 253006 | 1161109 | 3033786 | 4427125 | 2.000 | Khong dong |
| Cambodia | 1974 | 232686 | 1154897 | 3047455 | 4478408 | 3.000 | Khong dong |
| Cambodia | 1975 | 195752 | 1066808 | 2959596 | 4385856 | 3.000 | Khong dong |
| Cambodia | 1976 | 163274 | 929984 | 2767952 | 4145010 | 2.000 | Khong dong |
| Cambodia | 1977 | 140256 | 818694 | 2610515 | 3966712 | 2.000 | Khong dong |
| Cambodia | 1978 | 140433 | 741203 | 2533109 | 3901450 | 2.000 | Khong dong |
| Cambodia | 1979 | 182981 | 737877 | 2525148 | 3937859 | 2.000 | Khong dong |
| Cambodia | 1980 | 243809 | 814628 | 2574356 | 4026059 | 2.000 | Khong dong |
| Cambodia | 1981 | 282440 | 937729 | 2654633 | 4135606 | 2.000 | Khong dong |
| Cambodia | 1982 | 298961 | 1093893 | 2755331 | 4284487 | 3.000 | Khong dong |
| Cambodia | 1983 | 317550 | 1263470 | 2870534 | 4439543 | 3.000 | Khong dong |
| Cambodia | 1984 | 333640 | 1407108 | 2997133 | 4594628 | 3.000 | Khong dong |
| Cambodia | 1985 | 344982 | 1504322 | 3128002 | 4748687 | 4.000 | Khong dong |
| Cambodia | 1986 | 352048 | 1573274 | 3264706 | 4921606 | 4.000 | Khong dong |
| Cambodia | 1987 | 359310 | 1634560 | 3408109 | 5106372 | 4.000 | Dong |
| Cambodia | 1988 | 365690 | 1683794 | 3561484 | 5283431 | 5.000 | Dong |
| Cambodia | 1989 | 367229 | 1719338 | 3735855 | 5460685 | 5.000 | Dong |
| Cambodia | 1990 | 370316 | 1747803 | 3934593 | 5650610 | 6.000 | Dong |
| Cambodia | 1991 | 377447 | 1775815 | 4150863 | 5843411 | 6.000 | Dong |
| Cambodia | 1992 | 382598 | 1803991 | 4392965 | 6077643 | 6.000 | Dong |
| Cambodia | 1993 | 387810 | 1831034 | 4639850 | 6332515 | 6.000 | Dong |
| Cambodia | 1994 | 388312 | 1850235 | 4837512 | 6525769 | 7.000 | Dong |
| Cambodia | 1995 | 378229 | 1852162 | 4963571 | 6662613 | 9.000 | Dong |
| Cambodia | 1996 | 362335 | 1831631 | 5038924 | 6779748 | 9.000 | Dong |
| Cambodia | 1997 | 346689 | 1792673 | 5084388 | 6883094 | 10.000 | Dong |
| Cambodia | 1998 | 331972 | 1679192 | 5000919 | 6909667 | 11.000 | Dong |
| Cambodia | 1999 | 322585 | 1569993 | 4893634 | 6946669 | 12.000 | Dong |
| Cambodia | 2000 | 317767 | 1537449 | 4869765 | 7067775 | 13.000 | Dong |
| Cambodia | 2001 | 314523 | 1521868 | 4839432 | 7201291 | 14.000 | Dong |
| Cambodia | 2002 | 314791 | 1531865 | 4807232 | 7354616 | 15.000 | Dong |
| Cambodia | 2003 | 315386 | 1542507 | 4773122 | 7509039 | 17.000 | Dong |
| Cambodia | 2004 | 316390 | 1542412 | 4741686 | 7631375 | 19.000 | Dong |
| Cambodia | 2005 | 318721 | 1548395 | 4712917 | 7705544 | 21.000 | Dong |
| Cambodia | 2006 | 321310 | 1558941 | 4683338 | 7749053 | 23.000 | Dong |
| Cambodia | 2007 | 325791 | 1572976 | 4658685 | 7785986 | 25.000 | Dong |
| Cambodia | 2008 | 329293 | 1588346 | 4635173 | 7801073 | 27.000 | Dong |
| Cambodia | 2009 | 329863 | 1602530 | 4615105 | 7787602 | 30.000 | Dong |
| Cambodia | 2010 | 330041 | 1615169 | 4609820 | 7763937 | 33.000 | Dong |
| Cambodia | 2011 | 330487 | 1625791 | 4623794 | 7741108 | 36.000 | Dong |
| Cambodia | 2012 | 333288 | 1634928 | 4663378 | 7719562 | 39.000 | Dong |
| Cambodia | 2013 | 336233 | 1643330 | 4703917 | 7698564 | 42.000 | Dong |
| Cambodia | 2014 | 337637 | 1652055 | 4732419 | 7680385 | 45.000 | Dong |
| Cambodia | 2015 | 337529 | 1660203 | 4762926 | 7662736 | 48.000 | Dong |
| Cambodia | 2016 | 335469 | 1665895 | 4792943 | 7646327 | 53.000 | Dong |
| Cambodia | 2017 | 332545 | 1665943 | 4818464 | 7632136 | 58.000 | Dong |
| Cambodia | 2018 | 328817 | 1659062 | 4837527 | 7611894 | 62.000 | Dong |
| Cambodia | 2019 | 324534 | 1646250 | 4849865 | 7587802 | 66.000 | Dong |
| Cambodia | 2020 | 320805 | 1630328 | 4857657 | 7585089 | 70.000 | Dong |
| Cambodia | 2021 | 316916 | 1613064 | 4860476 | 7615851 | 74.000 | Dong |
| Indonesia | 1950 | 2436714 | 10591064 | 28713374 | 43200884 | 30.000 | Dong |
| Indonesia | 1951 | 2501780 | 10695802 | 28928030 | 43807016 | 58.000 | Dong |
| Indonesia | 1952 | 2600443 | 10904529 | 29219846 | 44473868 | 84.000 | Dong |
| Indonesia | 1953 | 2705999 | 11227549 | 29601248 | 45204132 | 101.000 | Dong |
| Indonesia | 1954 | 2812759 | 11639427 | 30075548 | 45998740 | 105.000 | Dong |
| Indonesia | 1955 | 2916759 | 12120773 | 30646676 | 46866990 | 104.000 | Dong |
| Indonesia | 1956 | 3023501 | 12641290 | 31322220 | 47814610 | 104.000 | Dong |
| Indonesia | 1957 | 3135515 | 13176442 | 32109492 | 48846600 | 103.000 | Dong |
| Indonesia | 1958 | 3245983 | 13717983 | 33007226 | 49957336 | 104.000 | Dong |
| Indonesia | 1959 | 3355184 | 14262777 | 34014256 | 51145264 | 106.000 | Dong |
| Indonesia | 1960 | 3467526 | 14815799 | 35130644 | 52412590 | 107.000 | Dong |
| Indonesia | 1961 | 3575932 | 15370260 | 36341184 | 53754870 | 109.000 | Dong |
| Indonesia | 1962 | 3674295 | 15912027 | 37646628 | 55168490 | 112.000 | Dong |
| Indonesia | 1963 | 3767829 | 16438324 | 39047004 | 56655012 | 115.000 | Dong |
| Indonesia | 1964 | 3857812 | 16948076 | 40520292 | 58222090 | 123.000 | Dong |
| Indonesia | 1965 | 3923703 | 17365228 | 41949284 | 59720212 | 114.000 | Dong |
| Indonesia | 1966 | 3985724 | 17737152 | 43350676 | 61223280 | 82.000 | Dong |
| Indonesia | 1967 | 4052698 | 18141172 | 44805140 | 62909076 | 51.000 | Dong |
| Indonesia | 1968 | 4101467 | 18524678 | 46243020 | 64713110 | 44.000 | Dong |
| Indonesia | 1969 | 4153618 | 18886972 | 47645944 | 66610270 | 62.000 | Dong |
| Indonesia | 1970 | 4207486 | 19226632 | 49011508 | 68570500 | 89.000 | Dong |
| Indonesia | 1971 | 4250621 | 19528572 | 50324430 | 70564420 | 115.000 | Dong |
| Indonesia | 1972 | 4293216 | 19803112 | 51580024 | 72600140 | 137.000 | Dong |
| Indonesia | 1973 | 4346583 | 20080420 | 52790730 | 74692460 | 153.000 | Dong |
| Indonesia | 1974 | 4384277 | 20342898 | 53941944 | 76805870 | 164.000 | Dong |
| Indonesia | 1975 | 4422788 | 20590340 | 55031976 | 78926800 | 171.000 | Dong |
| Indonesia | 1976 | 4471771 | 20842698 | 56074244 | 81033980 | 175.000 | Dong |
| Indonesia | 1977 | 4511466 | 21090700 | 57068640 | 83092000 | 177.000 | Dong |
| Indonesia | 1978 | 4564557 | 21338206 | 58035270 | 85110184 | 179.000 | Dong |
| Indonesia | 1979 | 4620764 | 21601812 | 58978596 | 87089380 | 183.000 | Dong |
| Indonesia | 1980 | 4663058 | 21866646 | 59884424 | 89018300 | 187.000 | Dong |
| Indonesia | 1981 | 4692695 | 22111268 | 60737190 | 90881520 | 193.000 | Dong |
| Indonesia | 1982 | 4726801 | 22349784 | 61552410 | 92680500 | 200.000 | Dong |
| Indonesia | 1983 | 4743492 | 22553208 | 62332250 | 94400184 | 207.000 | Dong |
| Indonesia | 1984 | 4727903 | 22687012 | 63042490 | 96006870 | 217.000 | Dong |
| Indonesia | 1985 | 4650975 | 22703840 | 63621790 | 97436776 | 227.000 | Dong |
| Indonesia | 1986 | 4540068 | 22583812 | 64048284 | 98661304 | 235.000 | Dong |
| Indonesia | 1987 | 4497124 | 22393006 | 64391850 | 99757410 | 242.000 | Dong |
| Indonesia | 1988 | 4503783 | 22197488 | 64692304 | 100781050 | 249.000 | Dong |
| Indonesia | 1989 | 4497115 | 22013560 | 64950956 | 101723230 | 258.000 | Dong |
| Indonesia | 1990 | 4459122 | 21867476 | 65136416 | 102552780 | 268.000 | Dong |
| Indonesia | 1991 | 4462556 | 21832220 | 65280508 | 103306770 | 277.000 | Dong |
| Indonesia | 1992 | 4466627 | 21841486 | 65391640 | 103996390 | 287.000 | Dong |
| Indonesia | 1993 | 4448658 | 21825060 | 65436416 | 104620320 | 299.000 | Dong |
| Indonesia | 1994 | 4472754 | 21838028 | 65453296 | 105217180 | 314.000 | Dong |
| Indonesia | 1995 | 4508608 | 21921408 | 65465064 | 105795736 | 332.000 | Dong |
| Indonesia | 1996 | 4553700 | 22044140 | 65491680 | 106372860 | 354.000 | Dong |
| Indonesia | 1997 | 4599479 | 22205748 | 65528490 | 106948264 | 378.000 | Dong |
| Indonesia | 1998 | 4596552 | 22378360 | 65542404 | 107462856 | 400.000 | Dong |
| Indonesia | 1999 | 4546999 | 22475104 | 65516590 | 107881230 | 423.000 | Dong |
| Indonesia | 2000 | 4521298 | 22509048 | 65532012 | 108226130 | 443.000 | Dong |
| Indonesia | 2001 | 4524714 | 22500384 | 65648480 | 108517520 | 461.000 | Dong |
| Indonesia | 2002 | 4520666 | 22440900 | 65793476 | 108756980 | 481.000 | Dong |
| Indonesia | 2003 | 4514962 | 22376916 | 65918240 | 108933060 | 502.000 | Dong |
| Indonesia | 2004 | 4524471 | 22359428 | 66025444 | 109024290 | 526.000 | Dong |
| Indonesia | 2005 | 4571989 | 22415892 | 66209610 | 109118800 | 555.000 | Dong |
| Indonesia | 2006 | 4648239 | 22556644 | 66485456 | 109293950 | 588.000 | Dong |
| Indonesia | 2007 | 4738892 | 22791540 | 66841216 | 109524060 | 628.000 | Dong |
| Indonesia | 2008 | 4795722 | 23088384 | 67264140 | 109788310 | 676.000 | Dong |
| Indonesia | 2009 | 4795030 | 23370922 | 67657016 | 110060830 | 729.000 | Dong |
| Indonesia | 2010 | 4795766 | 23603716 | 68012100 | 110405176 | 790.000 | Dong |
| Indonesia | 2011 | 4856565 | 23821878 | 68381510 | 110912780 | 864.000 | Dong |
| Indonesia | 2012 | 4913668 | 24006944 | 68760780 | 111513704 | 944.000 | Dong |
| Indonesia | 2013 | 4863145 | 24084022 | 69089020 | 112049864 | 1024.000 | Dong |
| Indonesia | 2014 | 4782831 | 24080194 | 69381944 | 112501290 | 1103.000 | Dong |
| Indonesia | 2015 | 4718817 | 24010696 | 69632940 | 112912536 | 1179.000 | Dong |
| Indonesia | 2016 | 4654031 | 23815582 | 69813150 | 113243740 | 1250.000 | Dong |
| Indonesia | 2017 | 4585510 | 23495150 | 69926740 | 113491230 | 1322.000 | Dong |
| Indonesia | 2018 | 4524618 | 23163588 | 69982900 | 113685544 | 1399.000 | Dong |
| Indonesia | 2019 | 4490630 | 22877436 | 69990360 | 113815300 | 1483.000 | Dong |
| Indonesia | 2020 | 4463186 | 22627598 | 69918980 | 113878620 | 1542.000 | Dong |
| Indonesia | 2021 | 4435250 | 22414316 | 69742696 | 113864904 | 1551.000 | Dong |
| Laos | 1950 | 66020 | 275009 | 681112 | 1003426 | 1.000 | Khong dong |
| Laos | 1951 | 71076 | 284849 | 701064 | 1027772 | 1.000 | Khong dong |
| Laos | 1952 | 72191 | 293769 | 720607 | 1052084 | 0.000 | Khong dong |
| Laos | 1953 | 73494 | 302786 | 740388 | 1077010 | 0.000 | Khong dong |
| Laos | 1954 | 74713 | 313473 | 760634 | 1102663 | 0.000 | Khong dong |
| Laos | 1955 | 75978 | 322522 | 781469 | 1129168 | 0.000 | Khong dong |
| Laos | 1956 | 77411 | 328741 | 802871 | 1156682 | 0.000 | Khong dong |
| Laos | 1957 | 78817 | 335219 | 824594 | 1185144 | 0.000 | Khong dong |
| Laos | 1958 | 80275 | 341837 | 846514 | 1214515 | 0.000 | Khong dong |
| Laos | 1959 | 81877 | 348825 | 868614 | 1244670 | 0.000 | Khong dong |
| Laos | 1960 | 83511 | 356174 | 890780 | 1275608 | 0.000 | Khong dong |
| Laos | 1961 | 85282 | 363857 | 913080 | 1307496 | 0.000 | Khong dong |
| Laos | 1962 | 87160 | 371974 | 935732 | 1340410 | 0.000 | Khong dong |
| Laos | 1963 | 89078 | 380535 | 959251 | 1374275 | 0.000 | Khong dong |
| Laos | 1964 | 91049 | 389455 | 985177 | 1409209 | 0.000 | Khong dong |
| Laos | 1965 | 93127 | 398788 | 1010350 | 1445580 | 0.000 | Khong dong |
| Laos | 1966 | 95264 | 408394 | 1033396 | 1483104 | 0.000 | Khong dong |
| Laos | 1967 | 97517 | 418368 | 1057485 | 1521790 | 0.000 | Khong dong |
| Laos | 1968 | 99919 | 428896 | 1082720 | 1561749 | 0.000 | Khong dong |
| Laos | 1969 | 102428 | 439952 | 1109139 | 1602750 | 0.000 | Khong dong |
| Laos | 1970 | 105198 | 451693 | 1136952 | 1644895 | 0.000 | Khong dong |
| Laos | 1971 | 107936 | 463977 | 1166015 | 1688145 | 0.000 | Khong dong |
| Laos | 1972 | 110609 | 476624 | 1196252 | 1732514 | 0.000 | Khong dong |
| Laos | 1973 | 113478 | 489686 | 1227718 | 1778381 | 0.000 | Khong dong |
| Laos | 1974 | 116524 | 503107 | 1260196 | 1826504 | 0.000 | Khong dong |
| Laos | 1975 | 119359 | 516337 | 1293154 | 1872357 | 0.000 | Khong dong |
| Laos | 1976 | 121632 | 528774 | 1325707 | 1913428 | 0.000 | Khong dong |
| Laos | 1977 | 123397 | 540168 | 1357490 | 1952914 | 0.000 | Khong dong |
| Laos | 1978 | 124831 | 550407 | 1388744 | 1992382 | 0.000 | Khong dong |
| Laos | 1979 | 126456 | 559958 | 1420290 | 2034257 | 0.000 | Khong dong |
| Laos | 1980 | 128673 | 569881 | 1453218 | 2080653 | 0.000 | Khong dong |
| Laos | 1981 | 131511 | 581066 | 1488042 | 2132149 | 0.000 | Khong dong |
| Laos | 1982 | 135020 | 594210 | 1525047 | 2188589 | 0.000 | Khong dong |
| Laos | 1983 | 139039 | 609735 | 1564360 | 2249184 | 0.000 | Khong dong |
| Laos | 1984 | 143392 | 627562 | 1605998 | 2313130 | 0.000 | Khong dong |
| Laos | 1985 | 147786 | 647208 | 1649733 | 2380101 | 0.000 | Khong dong |
| Laos | 1986 | 152015 | 668043 | 1695435 | 2449630 | 0.000 | Khong dong |
| Laos | 1987 | 156142 | 689418 | 1743016 | 2521272 | 0.000 | Khong dong |
| Laos | 1988 | 160192 | 710843 | 1792231 | 2594752 | 1.000 | Khong dong |
| Laos | 1989 | 164329 | 732095 | 1842948 | 2669891 | 1.000 | Khong dong |
| Laos | 1990 | 168427 | 753082 | 1895137 | 2746319 | 1.000 | Khong dong |
| Laos | 1991 | 172269 | 773778 | 1948933 | 2823815 | 1.000 | Khong dong |
| Laos | 1992 | 175393 | 793591 | 2003879 | 2901721 | 2.000 | Khong dong |
| Laos | 1993 | 177777 | 811863 | 2059320 | 2979365 | 1.000 | Khong dong |
| Laos | 1994 | 178609 | 826957 | 2113452 | 3055175 | 0.000 | Khong dong |
| Laos | 1995 | 177770 | 837346 | 2164339 | 3127505 | 0.000 | Khong dong |
| Laos | 1996 | 176668 | 843169 | 2211507 | 3196517 | 1.000 | Khong dong |
| Laos | 1997 | 176490 | 842408 | 2248780 | 3253797 | 1.000 | Khong dong |
| Laos | 1998 | 175786 | 835268 | 2275407 | 3299158 | 1.000 | Khong dong |
| Laos | 1999 | 173835 | 826392 | 2297050 | 3341664 | 1.000 | Khong dong |
| Laos | 2000 | 172279 | 818984 | 2314497 | 3382468 | 1.000 | Khong dong |
| Laos | 2001 | 170493 | 813660 | 2327603 | 3421836 | 82.000 | Khong dong |
| Laos | 2002 | 167891 | 808501 | 2335499 | 3458969 | 227.000 | Khong dong |
| Laos | 2003 | 164633 | 801332 | 2337247 | 3492720 | 356.000 | Khong dong |
| Laos | 2004 | 161370 | 791722 | 2332557 | 3522535 | 480.000 | Khong dong |
| Laos | 2005 | 161834 | 783333 | 2322931 | 3551451 | 533.000 | Khong dong |
| Laos | 2006 | 163895 | 778524 | 2310813 | 3579396 | 476.000 | Khong dong |
| Laos | 2007 | 163620 | 776392 | 2298502 | 3602994 | 371.000 | Khong dong |
| Laos | 2008 | 162835 | 776934 | 2287632 | 3622001 | 270.000 | Khong dong |
| Laos | 2009 | 161905 | 778946 | 2279329 | 3636594 | 194.000 | Khong dong |
| Laos | 2010 | 160803 | 779370 | 2273197 | 3646802 | 142.000 | Khong dong |
| Laos | 2011 | 159660 | 776917 | 2268101 | 3652654 | 112.000 | Khong dong |
| Laos | 2012 | 158776 | 773319 | 2263588 | 3654747 | 116.000 | Khong dong |
| Laos | 2013 | 158186 | 769673 | 2258167 | 3653794 | 190.000 | Khong dong |
| Laos | 2014 | 157216 | 765974 | 2250480 | 3650424 | 388.000 | Khong dong |
| Laos | 2015 | 158287 | 766893 | 2248627 | 3656563 | 550.000 | Khong dong |
| Laos | 2016 | 160335 | 773080 | 2255328 | 3673257 | 536.000 | Khong dong |
| Laos | 2017 | 160525 | 779599 | 2265060 | 3689525 | 445.000 | Khong dong |
| Laos | 2018 | 160108 | 785249 | 2276319 | 3704602 | 342.000 | Khong dong |
| Laos | 2019 | 159474 | 789310 | 2287092 | 3718439 | 254.000 | Khong dong |
| Laos | 2020 | 159244 | 790760 | 2296412 | 3731393 | 189.000 | Khong dong |
| Laos | 2021 | 158809 | 789704 | 2303010 | 3743066 | 138.000 | Khong dong |
| Thailand | 1950 | 791526 | 3347839 | 8605014 | 12717464 | 806.000 | Dong |
| Thailand | 1951 | 822697 | 3501172 | 8824841 | 13053160 | 774.000 | Dong |
| Thailand | 1952 | 851130 | 3659715 | 9055251 | 13400662 | 750.000 | Dong |
| Thailand | 1953 | 880945 | 3823991 | 9301239 | 13759175 | 718.000 | Dong |
| Thailand | 1954 | 908497 | 3981356 | 9573581 | 14133156 | 678.000 | Dong |
| Thailand | 1955 | 933665 | 4123724 | 9876674 | 14525890 | 636.000 | Dong |
| Thailand | 1956 | 959506 | 4261718 | 10206145 | 14936928 | 616.000 | Dong |
| Thailand | 1957 | 985080 | 4397528 | 10558718 | 15366313 | 621.000 | Dong |
| Thailand | 1958 | 1010933 | 4528508 | 10929353 | 15806675 | 624.000 | Dong |
| Thailand | 1959 | 1038838 | 4661119 | 11324153 | 16265950 | 617.000 | Dong |
| Thailand | 1960 | 1067458 | 4800290 | 11745401 | 16754818 | 614.000 | Dong |
| Thailand | 1961 | 1097593 | 4944630 | 12184977 | 17266758 | 631.000 | Dong |
| Thailand | 1962 | 1129840 | 5095330 | 12637076 | 17797768 | 659.000 | Dong |
| Thailand | 1963 | 1162222 | 5251204 | 13100009 | 18351082 | 683.000 | Dong |
| Thailand | 1964 | 1190363 | 5406315 | 13558731 | 18933160 | 696.000 | Dong |
| Thailand | 1965 | 1213101 | 5556049 | 14002136 | 19543924 | 707.000 | Dong |
| Thailand | 1966 | 1232332 | 5694977 | 14433577 | 20172032 | 716.000 | Dong |
| Thailand | 1967 | 1248588 | 5818173 | 14852824 | 20812098 | 718.000 | Dong |
| Thailand | 1968 | 1261780 | 5922706 | 15255486 | 21461232 | 734.000 | Dong |
| Thailand | 1969 | 1269297 | 6007260 | 15637382 | 22112636 | 792.000 | Dong |
| Thailand | 1970 | 1271376 | 6073540 | 15999598 | 22764262 | 899.000 | Dong |
| Thailand | 1971 | 1269642 | 6120676 | 16337278 | 23403602 | 1049.000 | Dong |
| Thailand | 1972 | 1265803 | 6149502 | 16648972 | 24024056 | 1232.000 | Dong |
| Thailand | 1973 | 1257604 | 6158815 | 16930358 | 24623810 | 1420.000 | Dong |
| Thailand | 1974 | 1243388 | 6146670 | 17171832 | 25178048 | 1585.000 | Dong |
| Thailand | 1975 | 1227081 | 6115682 | 17370712 | 25674792 | 1727.000 | Dong |
| Thailand | 1976 | 1206168 | 6064229 | 17520288 | 26115148 | 1851.000 | Dong |
| Thailand | 1977 | 1182851 | 5993225 | 17618368 | 26510686 | 1942.000 | Dong |
| Thailand | 1978 | 1166267 | 5914203 | 17671568 | 26869592 | 2030.000 | Dong |
| Thailand | 1979 | 1160411 | 5842582 | 17691980 | 27194408 | 2164.000 | Dong |
| Thailand | 1980 | 1169853 | 5796204 | 17701400 | 27509384 | 2357.000 | Dong |
| Thailand | 1981 | 1173734 | 5773056 | 17695996 | 27804680 | 2602.000 | Dong |
| Thailand | 1982 | 1154889 | 5752698 | 17654888 | 28055790 | 2886.000 | Dong |
| Thailand | 1983 | 1128874 | 5722859 | 17575762 | 28263492 | 3191.000 | Dong |
| Thailand | 1984 | 1108260 | 5678027 | 17468032 | 28427152 | 3498.000 | Dong |
| Thailand | 1985 | 1093834 | 5609034 | 17341684 | 28548128 | 3807.000 | Dong |
| Thailand | 1986 | 1083559 | 5525165 | 17203542 | 28626652 | 4136.000 | Dong |
| Thailand | 1987 | 1072415 | 5447825 | 17054796 | 28660086 | 4502.000 | Dong |
| Thailand | 1988 | 1059874 | 5383491 | 16899384 | 28650852 | 4885.000 | Dong |
| Thailand | 1989 | 1060299 | 5339173 | 16753852 | 28606512 | 5255.000 | Dong |
| Thailand | 1990 | 1068680 | 5308797 | 16570684 | 28392068 | 5613.000 | Dong |
| Thailand | 1991 | 1059009 | 5270611 | 16376987 | 28048764 | 5950.000 | Dong |
| Thailand | 1992 | 1022587 | 5205157 | 16211480 | 27655560 | 6258.000 | Dong |
| Thailand | 1993 | 993247 | 5125154 | 16062758 | 27195158 | 6571.000 | Dong |
| Thailand | 1994 | 986095 | 5059209 | 15958526 | 26754896 | 6955.000 | Dong |
| Thailand | 1995 | 993111 | 5010584 | 15887403 | 26396482 | 7416.000 | Dong |
| Thailand | 1996 | 988973 | 4971269 | 15817361 | 26123652 | 7819.000 | Dong |
| Thailand | 1997 | 960229 | 4940489 | 15716457 | 25894696 | 8054.000 | Dong |
| Thailand | 1998 | 929509 | 4899994 | 15586118 | 25715348 | 8090.999 | Dong |
| Thailand | 1999 | 886774 | 4807245 | 15412407 | 25548920 | 7872.000 | Dong |
| Thailand | 2000 | 855626 | 4659042 | 15171294 | 25411652 | 7548.000 | Dong |
| Thailand | 2001 | 852249 | 4508292 | 14903942 | 25313320 | 7356.000 | Dong |
| Thailand | 2002 | 850179 | 4389942 | 14664060 | 25202780 | 7297.000 | Dong |
| Thailand | 2003 | 841850 | 4298837 | 14447709 | 25052336 | 7277.000 | Dong |
| Thailand | 2004 | 833040 | 4239108 | 14248844 | 24851840 | 7244.000 | Dong |
| Thailand | 2005 | 827105 | 4196117 | 14051881 | 24611004 | 7200.000 | Dong |
| Thailand | 2006 | 824324 | 4152500 | 13850250 | 24335994 | 7724.000 | Dong |
| Thailand | 2007 | 824505 | 4117210 | 13669938 | 24030148 | 8722.000 | Dong |
| Thailand | 2008 | 823108 | 4096838 | 13513340 | 23724764 | 9677.000 | Dong |
| Thailand | 2009 | 818262 | 4085647 | 13361752 | 23447268 | 10780.000 | Dong |
| Thailand | 2010 | 810606 | 4076776 | 13168815 | 23213238 | 11911.000 | Dong |
| Thailand | 2011 | 810136 | 4071738 | 12937849 | 23021590 | 13008.000 | Dong |
| Thailand | 2012 | 809984 | 4064313 | 12720798 | 22842044 | 14220.000 | Dong |
| Thailand | 2013 | 795584 | 4042265 | 12534297 | 22645824 | 15606.000 | Dong |
| Thailand | 2014 | 774460 | 4000829 | 12379351 | 22425364 | 17154.000 | Dong |
| Thailand | 2015 | 751912 | 3941600 | 12232957 | 22166186 | 18788.000 | Dong |
| Thailand | 2016 | 729782 | 3861302 | 12083166 | 21876328 | 20474.000 | Dong |
| Thailand | 2017 | 711214 | 3763051 | 11936831 | 21582544 | 22173.000 | Dong |
| Thailand | 2018 | 692644 | 3659288 | 11792333 | 21276720 | 23800.000 | Dong |
| Thailand | 2019 | 673328 | 3556747 | 11641699 | 20949746 | 25381.000 | Dong |
| Thailand | 2020 | 658324 | 3462603 | 11483264 | 20588424 | 27053.000 | Dong |
| Thailand | 2021 | 646441 | 3379029 | 11313246 | 20188312 | 28840.000 | Dong |
| Vietnam | 1950 | 904341 | 3406207 | 8236495 | 12939915 | 175.000 | Dong |
| Vietnam | 1951 | 872254 | 3658999 | 8518370 | 13255227 | 157.000 | Dong |
| Vietnam | 1952 | 916499 | 3933555 | 8857408 | 13620701 | 143.000 | Dong |
| Vietnam | 1953 | 987067 | 4239036 | 9276998 | 14056521 | 128.000 | Dong |
| Vietnam | 1954 | 1033108 | 4469899 | 9743695 | 14526850 | 107.000 | Dong |
| Vietnam | 1955 | 1074295 | 4646879 | 10254732 | 15031625 | 89.000 | Dong |
| Vietnam | 1956 | 1074354 | 4853964 | 10770431 | 15527478 | 80.000 | Dong |
| Vietnam | 1957 | 1150260 | 5094240 | 11360715 | 16082264 | 81.000 | Dong |
| Vietnam | 1958 | 1223770 | 5339792 | 12017473 | 16699967 | 81.000 | Dong |
| Vietnam | 1959 | 1251278 | 5564662 | 12690551 | 17350838 | 78.000 | Dong |
| Vietnam | 1960 | 1273669 | 5769543 | 13372094 | 18038516 | 74.000 | Dong |
| Vietnam | 1961 | 1209390 | 5907424 | 13972092 | 18674658 | 74.000 | Dong |
| Vietnam | 1962 | 1222085 | 5985114 | 14564295 | 19335976 | 78.000 | Dong |
| Vietnam | 1963 | 1325018 | 6091700 | 15216631 | 20103120 | 80.000 | Dong |
| Vietnam | 1964 | 1337453 | 6179591 | 15760867 | 20878040 | 77.000 | Dong |
| Vietnam | 1965 | 1324564 | 6230985 | 16194742 | 21636756 | 73.000 | Dong |
| Vietnam | 1966 | 1302531 | 6318906 | 16628004 | 22369852 | 70.000 | Dong |
| Vietnam | 1967 | 1287368 | 6378912 | 16999532 | 23081304 | 67.000 | Dong |
| Vietnam | 1968 | 1308943 | 6354927 | 17311382 | 23787154 | 67.000 | Dong |
| Vietnam | 1969 | 1343891 | 6351816 | 17604120 | 24507490 | 74.000 | Dong |
| Vietnam | 1970 | 1371061 | 6394558 | 17887090 | 25248128 | 86.000 | Dong |
| Vietnam | 1971 | 1411902 | 6503486 | 18210916 | 26026550 | 100.000 | Dong |
| Vietnam | 1972 | 1463216 | 6672287 | 18500428 | 26812640 | 114.000 | Dong |
| Vietnam | 1973 | 1517283 | 6870924 | 18767206 | 27590598 | 127.000 | Dong |
| Vietnam | 1974 | 1535351 | 7056383 | 19030136 | 28280518 | 139.000 | Dong |
| Vietnam | 1975 | 1535793 | 7227690 | 19289618 | 28910036 | 153.000 | Dong |
| Vietnam | 1976 | 1557453 | 7399217 | 19656850 | 29629264 | 167.000 | Dong |
| Vietnam | 1977 | 1581537 | 7544465 | 20043754 | 30345182 | 181.000 | Dong |
| Vietnam | 1978 | 1615355 | 7662825 | 20370234 | 31026592 | 198.000 | Dong |
| Vietnam | 1979 | 1654524 | 7811401 | 20697166 | 31559350 | 214.000 | Dong |
| Vietnam | 1980 | 1687834 | 7982865 | 21081220 | 32066740 | 229.000 | Dong |
| Vietnam | 1981 | 1727824 | 8148518 | 21563076 | 32720200 | 247.000 | Dong |
| Vietnam | 1982 | 1770878 | 8332010 | 22103176 | 33346562 | 266.000 | Dong |
| Vietnam | 1983 | 1803160 | 8514784 | 22652416 | 33940660 | 287.000 | Dong |
| Vietnam | 1984 | 1825995 | 8684736 | 23186152 | 34536810 | 312.000 | Dong |
| Vietnam | 1985 | 1839951 | 8838227 | 23703104 | 35132708 | 339.000 | Dong |
| Vietnam | 1986 | 1849091 | 8961830 | 24186690 | 35800612 | 369.000 | Dong |
| Vietnam | 1987 | 1849813 | 9044322 | 24616420 | 36465010 | 404.000 | Dong |
| Vietnam | 1988 | 1845650 | 9090792 | 24981472 | 37044270 | 441.000 | Dong |
| Vietnam | 1989 | 1845054 | 9111796 | 25319184 | 37638690 | 482.000 | Dong |
| Vietnam | 1990 | 1846332 | 9119439 | 25647418 | 38267852 | 528.000 | Dong |
| Vietnam | 1991 | 1844494 | 9118764 | 25945640 | 38920040 | 583.000 | Dong |
| Vietnam | 1992 | 1827762 | 9102739 | 26200188 | 39571170 | 646.000 | Dong |
| Vietnam | 1993 | 1789109 | 9053587 | 26382816 | 40159570 | 717.000 | Dong |
| Vietnam | 1994 | 1725679 | 8942274 | 26467350 | 40646210 | 797.000 | Dong |
| Vietnam | 1995 | 1636148 | 8741097 | 26435028 | 41020410 | 886.000 | Dong |
| Vietnam | 1996 | 1540415 | 8446859 | 26271008 | 41263800 | 984.000 | Dong |
| Vietnam | 1997 | 1467157 | 8095657 | 25992636 | 41374828 | 1086.000 | Dong |
| Vietnam | 1998 | 1418011 | 7733584 | 25636004 | 41373850 | 1199.000 | Dong |
| Vietnam | 1999 | 1389736 | 7404283 | 25227684 | 41291184 | 1341.000 | Dong |
| Vietnam | 2000 | 1389900 | 7161361 | 24785584 | 41078796 | 1510.000 | Dong |
| Vietnam | 2001 | 1402236 | 7025184 | 24335702 | 40753684 | 1715.000 | Dong |
| Vietnam | 2002 | 1421677 | 6981135 | 23916988 | 40422490 | 1958.000 | Dong |
| Vietnam | 2003 | 1433495 | 6998144 | 23524634 | 40085696 | 2213.000 | Dong |
| Vietnam | 2004 | 1437726 | 7047756 | 23142328 | 39737364 | 2449.000 | Dong |
| Vietnam | 2005 | 1436024 | 7095286 | 22758324 | 39380230 | 2654.000 | Dong |
| Vietnam | 2006 | 1414986 | 7109273 | 22354948 | 38994796 | 2832.000 | Dong |
| Vietnam | 2007 | 1413046 | 7101911 | 21965246 | 38602828 | 2983.000 | Dong |
| Vietnam | 2008 | 1433516 | 7103258 | 21633178 | 38239836 | 3133.000 | Dong |
| Vietnam | 2009 | 1445612 | 7112803 | 21383252 | 37950040 | 3321.000 | Dong |
| Vietnam | 2010 | 1450747 | 7129394 | 21230458 | 37728160 | 3548.000 | Dong |
| Vietnam | 2011 | 1462871 | 7178658 | 21175292 | 37525296 | 3813.000 | Dong |
| Vietnam | 2012 | 1486438 | 7252917 | 21208004 | 37344696 | 4119.000 | Dong |
| Vietnam | 2013 | 1512565 | 7332431 | 21310790 | 37186532 | 4423.000 | Dong |
| Vietnam | 2014 | 1524609 | 7411583 | 21451364 | 37026736 | 4675.000 | Dong |
| Vietnam | 2015 | 1524401 | 7485260 | 21590510 | 36846110 | 4880.000 | Dong |
| Vietnam | 2016 | 1515441 | 7537840 | 21707980 | 36636264 | 5066.000 | Dong |
| Vietnam | 2017 | 1498956 | 7550472 | 21789420 | 36404380 | 5236.000 | Dong |
| Vietnam | 2018 | 1487172 | 7525360 | 21847120 | 36178590 | 5414.000 | Dong |
| Vietnam | 2019 | 1480585 | 7481736 | 21893514 | 35990370 | 5660.000 | Dong |
| Vietnam | 2020 | 1471822 | 7429597 | 21932616 | 35867816 | 6021.000 | Dong |
| Vietnam | 2021 | 1453563 | 7368156 | 21974312 | 35811056 | 6395.000 | Dong |
Ta thấy nếu ở cột u25 có số lượng lớn hơn 5000000 thì ở cột Density là ‘Dong’, nếu nhỏ hơn thì ‘Khong dong’
Lấy dữ liệu trong giai đoạn từ 2017 đến 2021 bằng lệnh
qh2 <-filter (qh1, y==2017|y==2018|y==2019|y==2020|y==2021)
table <- knitr::kable(qh2, format = "markdown")
table| c | y | u1 | u5 | u15 | u25 | o100 | Density |
|---|---|---|---|---|---|---|---|
| Cambodia | 2017 | 332545 | 1665943 | 4818464 | 7632136 | 58 | Dong |
| Cambodia | 2018 | 328817 | 1659062 | 4837527 | 7611894 | 62 | Dong |
| Cambodia | 2019 | 324534 | 1646250 | 4849865 | 7587802 | 66 | Dong |
| Cambodia | 2020 | 320805 | 1630328 | 4857657 | 7585089 | 70 | Dong |
| Cambodia | 2021 | 316916 | 1613064 | 4860476 | 7615851 | 74 | Dong |
| Indonesia | 2017 | 4585510 | 23495150 | 69926740 | 113491230 | 1322 | Dong |
| Indonesia | 2018 | 4524618 | 23163588 | 69982900 | 113685544 | 1399 | Dong |
| Indonesia | 2019 | 4490630 | 22877436 | 69990360 | 113815300 | 1483 | Dong |
| Indonesia | 2020 | 4463186 | 22627598 | 69918980 | 113878620 | 1542 | Dong |
| Indonesia | 2021 | 4435250 | 22414316 | 69742696 | 113864904 | 1551 | Dong |
| Laos | 2017 | 160525 | 779599 | 2265060 | 3689525 | 445 | Khong dong |
| Laos | 2018 | 160108 | 785249 | 2276319 | 3704602 | 342 | Khong dong |
| Laos | 2019 | 159474 | 789310 | 2287092 | 3718439 | 254 | Khong dong |
| Laos | 2020 | 159244 | 790760 | 2296412 | 3731393 | 189 | Khong dong |
| Laos | 2021 | 158809 | 789704 | 2303010 | 3743066 | 138 | Khong dong |
| Thailand | 2017 | 711214 | 3763051 | 11936831 | 21582544 | 22173 | Dong |
| Thailand | 2018 | 692644 | 3659288 | 11792333 | 21276720 | 23800 | Dong |
| Thailand | 2019 | 673328 | 3556747 | 11641699 | 20949746 | 25381 | Dong |
| Thailand | 2020 | 658324 | 3462603 | 11483264 | 20588424 | 27053 | Dong |
| Thailand | 2021 | 646441 | 3379029 | 11313246 | 20188312 | 28840 | Dong |
| Vietnam | 2017 | 1498956 | 7550472 | 21789420 | 36404380 | 5236 | Dong |
| Vietnam | 2018 | 1487172 | 7525360 | 21847120 | 36178590 | 5414 | Dong |
| Vietnam | 2019 | 1480585 | 7481736 | 21893514 | 35990370 | 5660 | Dong |
| Vietnam | 2020 | 1471822 | 7429597 | 21932616 | 35867816 | 6021 | Dong |
| Vietnam | 2021 | 1453563 | 7368156 | 21974312 | 35811056 | 6395 | Dong |
Tung bình
ta nhóm các năm lại và tính trung bình bằng lệnh
qh3 <- qh2 %>% group_by(y) %>% summarise(mean_of_u25 = mean(u25))
table <- knitr::kable(qh3, format = "markdown")
table| y | mean_of_u25 |
|---|---|
| 2017 | 36559963 |
| 2018 | 36491470 |
| 2019 | 36412331 |
| 2020 | 36330268 |
| 2021 | 36244638 |
Kết quả trả về ta thấy dân số dưới 25 tuổi trung bình của 5 quốc gia năm 2017 là 36559963, năm 2018 là 36491470,…
Trung vị
qh4<-qh2%>% group_by(y) %>% summarise(med_of_u15 = median(u15))
table <- knitr::kable(qh4, format = "markdown")
table| y | med_of_u15 |
|---|---|
| 2017 | 11936831 |
| 2018 | 11792333 |
| 2019 | 11641699 |
| 2020 | 11483264 |
| 2021 | 11313246 |
Kết quả trả về ta thấy trung vị dân số dưới 15 tuổi của 5 quốc gia năm 2017 là 11936831, năm 2018 là 11792333,…
Min, max, tứ phân vị
summary(qh2$u5)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 779599 1630328 3556747 7276136 7525360 23495150Kết quả trả về ta thấy được giá trị nhỏ nhất là 779599, lớn nhất là 23495150, tứ phân vị thứ nhất là 1630328, tứ phân vị thứ 2 (trung vị) là 3556747, tứ phân vị thứ 3 là 7525360
library(xlsx)
mt<-read.xlsx("D:\\Downloads\\air pollution.xlsx", sheetIndex = 1, header = T)Bộ dữ liệu air pollution cung cấp dữ liệu về ô nhiễm không khí tại 1 số thành phố từ 2017 đến 2023
Bộ dữ liệu gồm có 9 đối tượng và 233 quan sát
Giải thích đối tượng:
city: thành phố
country: nước
2017, 2018,…: năm 2017, năm 2018,…
Lọc dữ liệu của các nước Austria, Belgium, Brazil bằng lệnh
mt1<-filter(mt,country=='Austria'|country=='Belgium'|country=='Brazil')
table <- knitr::kable(mt1, format = "markdown")
table| city | country | X2017 | X2018 | X2019 | X2020 | X2021 | X2022 | X2023 |
|---|---|---|---|---|---|---|---|---|
| Stoessing | Austria | 0.0 | 0.0 | 15.1 | 13.5 | 14.1 | 14.2 | 14.3 |
| Traun | Austria | 14.6 | 14.9 | 12.9 | 11.9 | 12.0 | 12.0 | 12.0 |
| Tulln | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 11.1 | 10.5 | 10.5 |
| Viehofen | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 9.7 | 9.6 |
| Vienna | Austria | 13.0 | 15.2 | 12.3 | 11.0 | 11.8 | 10.5 | 10.5 |
| Voelkermarkter Vorstadt | Austria | 0.0 | 0.0 | 12.5 | 11.8 | 10.9 | 12.2 | 12.0 |
| Voitsberg | Austria | 12.6 | 14.7 | 10.6 | 11.2 | 11.6 | 11.2 | 11.0 |
| Wels | Austria | 13.5 | 15.3 | 12.2 | 11.1 | 10.9 | 10.5 | 10.5 |
| Wiener Neudorf | Austria | 12.4 | 14.0 | 11.5 | 11.0 | 11.6 | 10.1 | 10.0 |
| Wolfsberg | Austria | 0.0 | 0.0 | 13.9 | 12.8 | 13.0 | 13.1 | 13.2 |
| Zell am See | Austria | 0.0 | 0.0 | 0.0 | 8.8 | 8.3 | 7.2 | 7.0 |
| Zellerndorf | Austria | 0.0 | 0.0 | 0.0 | 8.7 | 9.8 | 8.7 | 8.7 |
| Ziersdorf | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 9.2 | 9.8 | 9.7 |
| Aarschot | Belgium | 12.7 | 13.7 | 11.6 | 10.1 | 12.1 | 10.5 | 10.5 |
| Andenne | Belgium | 9.7 | 11.7 | 10.3 | 6.2 | 8.7 | 7.5 | 7.5 |
| Antwerpen | Belgium | 14.0 | 14.4 | 12.9 | 10.7 | 12.7 | 11.4 | 11.3 |
| Baelen | Belgium | 8.4 | 8.6 | 8.9 | 5.3 | 7.6 | 5.5 | 5.7 |
| Bertrix | Belgium | 8.0 | 9.1 | 7.9 | 6.6 | 6.1 | 5.6 | 5.6 |
| Beveren | Belgium | 14.4 | 14.9 | 13.3 | 11.6 | 13.0 | 11.4 | 11.4 |
| Bocholt | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 17.9 | 16.9 | 16.8 |
| Boom | Belgium | 12.6 | 13.2 | 11.5 | 10.5 | 11.9 | 11.2 | 11.0 |
| Brugge | Belgium | 0.0 | 0.0 | 0.0 | 14.2 | 12.4 | 13.3 | 11.7 |
| Brussels | Belgium | 14.9 | 14.1 | 14.1 | 9.3 | 11.0 | 10.6 | 10.5 |
| Charleroi | Belgium | 11.4 | 12.0 | 10.6 | 7.9 | 9.5 | 8.4 | 8.4 |
| Chatelet | Belgium | 10.6 | 11.7 | 11.2 | 7.3 | 9.8 | 8.4 | 8.4 |
| Damme | Belgium | 12.8 | 13.1 | 12.2 | 10.5 | 11.9 | 11.2 | 11.2 |
| Deinze | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 18.7 | 17.4 | 17.4 |
| Dessel | Belgium | 13.8 | 13.2 | 12.3 | 10.7 | 11.9 | 11.0 | 11.0 |
| Destelbergen | Belgium | 13.6 | 14.2 | 12.5 | 10.9 | 12.3 | 11.9 | 11.9 |
| Deurne | Belgium | 0.0 | 0.0 | 11.4 | 11.4 | 12.7 | 12.3 | 12.2 |
| Engis | Belgium | 12.7 | 11.9 | 12.2 | 7.4 | 9.4 | 7.8 | 7.7 |
| Evergem | Belgium | 14.2 | 15.3 | 14.2 | 13.0 | 14.4 | 13.9 | 13.8 |
| Genk | Belgium | 0.0 | 0.0 | 0.0 | 11.6 | 13.9 | 11.8 | 11.8 |
| Gent | Belgium | 14.0 | 14.9 | 13.0 | 10.8 | 12.7 | 11.6 | 11.6 |
| Gistel | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 11.4 | 11.2 |
| Habay | Belgium | 7.8 | 8.4 | 8.2 | 5.2 | 5.0 | 5.5 | 5.4 |
| Hasselt | Belgium | 0.0 | 0.0 | 0.0 | 10.0 | 11.2 | 11.4 | 11.4 |
| Heist-op-den-Berg | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 18.8 | 16.7 | 16.6 |
| Herstal | Belgium | 10.1 | 11.0 | 10.4 | 7.1 | 8.8 | 8.0 | 8.0 |
| Houthalen | Belgium | 0.0 | 0.0 | 10.7 | 10.8 | 12.9 | 11.1 | 11.1 |
| Kapellen | Belgium | 0.0 | 0.0 | 13.2 | 11.4 | 12.3 | 11.0 | 11.0 |
| Landen | Belgium | 12.5 | 12.8 | 10.9 | 9.1 | 11.3 | 9.6 | 9.4 |
| Leuven | Belgium | 0.0 | 0.0 | 14.6 | 12.5 | 14.4 | 9.6 | 9.5 |
| Liège | Belgium | 10.0 | 10.8 | 9.2 | 6.5 | 8.7 | 7.7 | 7.7 |
| Mechelen | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 11.9 | 12.0 | 11.9 |
| Menen | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 14.1 | 13.5 | 13.4 |
| Mons | Belgium | 11.4 | 11.3 | 12.1 | 7.9 | 10.6 | 9.3 | 9.2 |
| Mortsel | Belgium | 0.0 | 0.0 | 9.4 | 10.7 | 11.5 | 11.2 | 11.1 |
| Oostrozebeke | Belgium | 17.3 | 17.2 | 15.1 | 13.9 | 15.2 | 14.1 | 14.1 |
| Oupeye | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 9.9 | 9.7 | 8.7 |
| Roeselare | Belgium | 14.1 | 15.3 | 13.3 | 12.1 | 13.3 | 14.0 | 13.9 |
| Saint-Nicolas | Belgium | 9.4 | 10.8 | 10.1 | 7.2 | 8.6 | 7.8 | 7.8 |
| Sainte-Ode | Belgium | 7.0 | 8.7 | 7.5 | 5.6 | 5.4 | 4.8 | 4.6 |
| Schoten | Belgium | 14.3 | 14.5 | 12.8 | 11.4 | 12.7 | 11.4 | 11.3 |
| Seraing | Belgium | 11.4 | 12.5 | 10.5 | 10.9 | 12.7 | 11.6 | 11.5 |
| Somme-Leuze | Belgium | 8.0 | 9.1 | 8.4 | 5.5 | 6.7 | 6.1 | 6.0 |
| Stabroek | Belgium | 13.6 | 13.6 | 11.7 | 11.9 | 12.9 | 11.8 | 11.8 |
| Terkoest | Belgium | 0.0 | 0.0 | 0.0 | 10.0 | 11.0 | 10.7 | 10.6 |
| Tournai | Belgium | 10.9 | 11.1 | 11.0 | 7.2 | 8.9 | 8.8 | 8.6 |
| Veurne | Belgium | 11.7 | 12.8 | 11.3 | 9.8 | 10.8 | 10.5 | 10.5 |
| Vielsalm | Belgium | 5.6 | 7.3 | 6.4 | 4.2 | 5.0 | 4.8 | 4.6 |
| Vilvoorde | Belgium | 14.2 | 14.9 | 12.6 | 10.6 | 12.0 | 10.7 | 10.6 |
| Viroinval | Belgium | 7.6 | 8.9 | 8.5 | 4.8 | 6.7 | 5.2 | 5.2 |
| Wielsbeke | Belgium | 14.9 | 16.5 | 14.8 | 13.9 | 15.0 | 13.8 | 13.7 |
| Zelzate | Belgium | 15.0 | 15.6 | 14.7 | 11.9 | 12.8 | 11.9 | 12.2 |
| Zulte | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 17.3 | 16.3 | 16.2 |
| Zwevegem | Belgium | 13.9 | 15.4 | 13.3 | 11.7 | 14.0 | 12.2 | 12.1 |
| Zwijndrecht | Belgium | 0.0 | 0.0 | 9.2 | 10.1 | 11.7 | 11.0 | 10.9 |
| Acrelandia | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 28.0 | 23.3 | 20.8 |
| Barra Mansa | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 17.2 | 17.2 |
| Boa Vista | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 5.6 | 4.5 | 4.4 |
| Brasileia | Brazil | 0.0 | 0.0 | 0.0 | 18.6 | 15.4 | 17.6 | 17.6 |
| Campinas | Brazil | 0.0 | 16.0 | 20.0 | 0.0 | 16.4 | 15.5 | 15.6 |
| Colombo | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.5 | 15.2 | 16.6 |
| Cruzeiro do Sul | Brazil | 0.0 | 0.0 | 9.3 | 12.6 | 10.3 | 11.8 | 11.7 |
| Cubatao | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 17.0 | 17.1 | 16.9 |
| Curitiba | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.0 | 12.0 | 13.5 |
| Diadema | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 13.7 | 13.4 |
| Feijo | Brazil | 0.0 | 0.0 | 0.0 | 14.2 | 11.7 | 15.7 | 15.8 |
| Fortaleza | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 4.3 | 4.1 | 4.1 |
| Guarulhos | Brazil | 17.3 | 21.6 | 18.7 | 16.4 | 16.1 | 15.0 | 15.0 |
| Jundiai | Brazil | 0.0 | 0.0 | 0.0 | 14.0 | 13.1 | 12.5 | 12.4 |
| Macapa | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 7.5 | 4.4 | 4.6 |
| Manaus | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 10.3 | 12.7 | 12.1 |
| Mancio Lima | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 9.2 | 6.5 | 8.0 |
| Marituba | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.2 | 11.6 | 11.6 |
| Maua | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.7 | 13.6 | 14.2 |
| Osasco | Brazil | 0.0 | 22.1 | 19.8 | 16.7 | 16.8 | 15.1 | 15.0 |
| Palmas | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 6.3 | 10.6 | 10.4 |
| Pianco | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 4.6 | 4.0 | 4.0 |
| Piracicaba | Brazil | 12.5 | 13.6 | 13.4 | 13.7 | 13.3 | 11.6 | 11.3 |
| Porto Velho | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 22.1 | 20.2 | 20.2 |
| Ribeirao Preto | Brazil | 5.9 | 11.3 | 8.2 | 7.2 | 11.8 | 13.0 | 13.1 |
| Rio Branco | Brazil | 0.0 | 0.0 | 16.0 | 14.7 | 12.6 | 18.2 | 18.4 |
| Rio Claro | Brazil | 0.0 | 0.0 | 0.0 | 17.8 | 16.7 | 14.9 | 15.1 |
| Rio de Janeiro | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.0 | 10.6 | 10.6 |
| Santa Branca | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 10.0 | 8.1 | 8.1 |
| Santa Gertrudes | Brazil | 0.0 | 0.0 | 18.8 | 15.9 | 18.1 | 16.9 | 16.8 |
| Santos | Brazil | 15.9 | 14.8 | 15.4 | 13.7 | 12.0 | 12.1 | 12.1 |
| Sao Bernardo do Campo | Brazil | 0.0 | 16.4 | 16.7 | 15.9 | 15.2 | 13.9 | 13.9 |
| Sao Caetano do Sul | Brazil | 0.0 | 18.1 | 17.2 | 15.0 | 15.5 | 13.9 | 13.8 |
| Sao Jose do Rio Preto | Brazil | 0.0 | 15.4 | 15.2 | 16.6 | 15.7 | 10.4 | 10.4 |
| Sao Jose dos Campos | Brazil | 0.0 | 0.0 | 11.8 | 11.5 | 15.0 | 10.2 | 10.2 |
| Sao Paulo | Brazil | 16.0 | 16.2 | 15.3 | 14.2 | 14.8 | 13.5 | 13.5 |
| Senador Guiomard | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.9 | 18.7 | 18.7 |
| Taubate | Brazil | 0.0 | 11.4 | 11.5 | 11.7 | 11.6 | 10.9 | 10.8 |
| Timoteo | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 13.9 | 13.7 |
Lập bảng tần số cho dữ liệu vừa lọc ra ở cột country bằng lệnh
table(mt1$country)##
## Austria Belgium Brazil
## 13 55 39Kết quả trả về cho ta biết có 13 thành phố của Austria, 55 thành phố của Belgium, 39 thành phố của Brazil
mt1$tinhtrang <- ifelse(mt1$X2023> 20,'o nhiem nang','binh thuong')
table <- knitr::kable(mt1, format = "markdown")
table| city | country | X2017 | X2018 | X2019 | X2020 | X2021 | X2022 | X2023 | tinhtrang |
|---|---|---|---|---|---|---|---|---|---|
| Stoessing | Austria | 0.0 | 0.0 | 15.1 | 13.5 | 14.1 | 14.2 | 14.3 | binh thuong |
| Traun | Austria | 14.6 | 14.9 | 12.9 | 11.9 | 12.0 | 12.0 | 12.0 | binh thuong |
| Tulln | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 11.1 | 10.5 | 10.5 | binh thuong |
| Viehofen | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 9.7 | 9.6 | binh thuong |
| Vienna | Austria | 13.0 | 15.2 | 12.3 | 11.0 | 11.8 | 10.5 | 10.5 | binh thuong |
| Voelkermarkter Vorstadt | Austria | 0.0 | 0.0 | 12.5 | 11.8 | 10.9 | 12.2 | 12.0 | binh thuong |
| Voitsberg | Austria | 12.6 | 14.7 | 10.6 | 11.2 | 11.6 | 11.2 | 11.0 | binh thuong |
| Wels | Austria | 13.5 | 15.3 | 12.2 | 11.1 | 10.9 | 10.5 | 10.5 | binh thuong |
| Wiener Neudorf | Austria | 12.4 | 14.0 | 11.5 | 11.0 | 11.6 | 10.1 | 10.0 | binh thuong |
| Wolfsberg | Austria | 0.0 | 0.0 | 13.9 | 12.8 | 13.0 | 13.1 | 13.2 | binh thuong |
| Zell am See | Austria | 0.0 | 0.0 | 0.0 | 8.8 | 8.3 | 7.2 | 7.0 | binh thuong |
| Zellerndorf | Austria | 0.0 | 0.0 | 0.0 | 8.7 | 9.8 | 8.7 | 8.7 | binh thuong |
| Ziersdorf | Austria | 0.0 | 0.0 | 0.0 | 0.0 | 9.2 | 9.8 | 9.7 | binh thuong |
| Aarschot | Belgium | 12.7 | 13.7 | 11.6 | 10.1 | 12.1 | 10.5 | 10.5 | binh thuong |
| Andenne | Belgium | 9.7 | 11.7 | 10.3 | 6.2 | 8.7 | 7.5 | 7.5 | binh thuong |
| Antwerpen | Belgium | 14.0 | 14.4 | 12.9 | 10.7 | 12.7 | 11.4 | 11.3 | binh thuong |
| Baelen | Belgium | 8.4 | 8.6 | 8.9 | 5.3 | 7.6 | 5.5 | 5.7 | binh thuong |
| Bertrix | Belgium | 8.0 | 9.1 | 7.9 | 6.6 | 6.1 | 5.6 | 5.6 | binh thuong |
| Beveren | Belgium | 14.4 | 14.9 | 13.3 | 11.6 | 13.0 | 11.4 | 11.4 | binh thuong |
| Bocholt | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 17.9 | 16.9 | 16.8 | binh thuong |
| Boom | Belgium | 12.6 | 13.2 | 11.5 | 10.5 | 11.9 | 11.2 | 11.0 | binh thuong |
| Brugge | Belgium | 0.0 | 0.0 | 0.0 | 14.2 | 12.4 | 13.3 | 11.7 | binh thuong |
| Brussels | Belgium | 14.9 | 14.1 | 14.1 | 9.3 | 11.0 | 10.6 | 10.5 | binh thuong |
| Charleroi | Belgium | 11.4 | 12.0 | 10.6 | 7.9 | 9.5 | 8.4 | 8.4 | binh thuong |
| Chatelet | Belgium | 10.6 | 11.7 | 11.2 | 7.3 | 9.8 | 8.4 | 8.4 | binh thuong |
| Damme | Belgium | 12.8 | 13.1 | 12.2 | 10.5 | 11.9 | 11.2 | 11.2 | binh thuong |
| Deinze | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 18.7 | 17.4 | 17.4 | binh thuong |
| Dessel | Belgium | 13.8 | 13.2 | 12.3 | 10.7 | 11.9 | 11.0 | 11.0 | binh thuong |
| Destelbergen | Belgium | 13.6 | 14.2 | 12.5 | 10.9 | 12.3 | 11.9 | 11.9 | binh thuong |
| Deurne | Belgium | 0.0 | 0.0 | 11.4 | 11.4 | 12.7 | 12.3 | 12.2 | binh thuong |
| Engis | Belgium | 12.7 | 11.9 | 12.2 | 7.4 | 9.4 | 7.8 | 7.7 | binh thuong |
| Evergem | Belgium | 14.2 | 15.3 | 14.2 | 13.0 | 14.4 | 13.9 | 13.8 | binh thuong |
| Genk | Belgium | 0.0 | 0.0 | 0.0 | 11.6 | 13.9 | 11.8 | 11.8 | binh thuong |
| Gent | Belgium | 14.0 | 14.9 | 13.0 | 10.8 | 12.7 | 11.6 | 11.6 | binh thuong |
| Gistel | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 11.4 | 11.2 | binh thuong |
| Habay | Belgium | 7.8 | 8.4 | 8.2 | 5.2 | 5.0 | 5.5 | 5.4 | binh thuong |
| Hasselt | Belgium | 0.0 | 0.0 | 0.0 | 10.0 | 11.2 | 11.4 | 11.4 | binh thuong |
| Heist-op-den-Berg | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 18.8 | 16.7 | 16.6 | binh thuong |
| Herstal | Belgium | 10.1 | 11.0 | 10.4 | 7.1 | 8.8 | 8.0 | 8.0 | binh thuong |
| Houthalen | Belgium | 0.0 | 0.0 | 10.7 | 10.8 | 12.9 | 11.1 | 11.1 | binh thuong |
| Kapellen | Belgium | 0.0 | 0.0 | 13.2 | 11.4 | 12.3 | 11.0 | 11.0 | binh thuong |
| Landen | Belgium | 12.5 | 12.8 | 10.9 | 9.1 | 11.3 | 9.6 | 9.4 | binh thuong |
| Leuven | Belgium | 0.0 | 0.0 | 14.6 | 12.5 | 14.4 | 9.6 | 9.5 | binh thuong |
| Liège | Belgium | 10.0 | 10.8 | 9.2 | 6.5 | 8.7 | 7.7 | 7.7 | binh thuong |
| Mechelen | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 11.9 | 12.0 | 11.9 | binh thuong |
| Menen | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 14.1 | 13.5 | 13.4 | binh thuong |
| Mons | Belgium | 11.4 | 11.3 | 12.1 | 7.9 | 10.6 | 9.3 | 9.2 | binh thuong |
| Mortsel | Belgium | 0.0 | 0.0 | 9.4 | 10.7 | 11.5 | 11.2 | 11.1 | binh thuong |
| Oostrozebeke | Belgium | 17.3 | 17.2 | 15.1 | 13.9 | 15.2 | 14.1 | 14.1 | binh thuong |
| Oupeye | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 9.9 | 9.7 | 8.7 | binh thuong |
| Roeselare | Belgium | 14.1 | 15.3 | 13.3 | 12.1 | 13.3 | 14.0 | 13.9 | binh thuong |
| Saint-Nicolas | Belgium | 9.4 | 10.8 | 10.1 | 7.2 | 8.6 | 7.8 | 7.8 | binh thuong |
| Sainte-Ode | Belgium | 7.0 | 8.7 | 7.5 | 5.6 | 5.4 | 4.8 | 4.6 | binh thuong |
| Schoten | Belgium | 14.3 | 14.5 | 12.8 | 11.4 | 12.7 | 11.4 | 11.3 | binh thuong |
| Seraing | Belgium | 11.4 | 12.5 | 10.5 | 10.9 | 12.7 | 11.6 | 11.5 | binh thuong |
| Somme-Leuze | Belgium | 8.0 | 9.1 | 8.4 | 5.5 | 6.7 | 6.1 | 6.0 | binh thuong |
| Stabroek | Belgium | 13.6 | 13.6 | 11.7 | 11.9 | 12.9 | 11.8 | 11.8 | binh thuong |
| Terkoest | Belgium | 0.0 | 0.0 | 0.0 | 10.0 | 11.0 | 10.7 | 10.6 | binh thuong |
| Tournai | Belgium | 10.9 | 11.1 | 11.0 | 7.2 | 8.9 | 8.8 | 8.6 | binh thuong |
| Veurne | Belgium | 11.7 | 12.8 | 11.3 | 9.8 | 10.8 | 10.5 | 10.5 | binh thuong |
| Vielsalm | Belgium | 5.6 | 7.3 | 6.4 | 4.2 | 5.0 | 4.8 | 4.6 | binh thuong |
| Vilvoorde | Belgium | 14.2 | 14.9 | 12.6 | 10.6 | 12.0 | 10.7 | 10.6 | binh thuong |
| Viroinval | Belgium | 7.6 | 8.9 | 8.5 | 4.8 | 6.7 | 5.2 | 5.2 | binh thuong |
| Wielsbeke | Belgium | 14.9 | 16.5 | 14.8 | 13.9 | 15.0 | 13.8 | 13.7 | binh thuong |
| Zelzate | Belgium | 15.0 | 15.6 | 14.7 | 11.9 | 12.8 | 11.9 | 12.2 | binh thuong |
| Zulte | Belgium | 0.0 | 0.0 | 0.0 | 0.0 | 17.3 | 16.3 | 16.2 | binh thuong |
| Zwevegem | Belgium | 13.9 | 15.4 | 13.3 | 11.7 | 14.0 | 12.2 | 12.1 | binh thuong |
| Zwijndrecht | Belgium | 0.0 | 0.0 | 9.2 | 10.1 | 11.7 | 11.0 | 10.9 | binh thuong |
| Acrelandia | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 28.0 | 23.3 | 20.8 | o nhiem nang |
| Barra Mansa | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 17.2 | 17.2 | binh thuong |
| Boa Vista | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 5.6 | 4.5 | 4.4 | binh thuong |
| Brasileia | Brazil | 0.0 | 0.0 | 0.0 | 18.6 | 15.4 | 17.6 | 17.6 | binh thuong |
| Campinas | Brazil | 0.0 | 16.0 | 20.0 | 0.0 | 16.4 | 15.5 | 15.6 | binh thuong |
| Colombo | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.5 | 15.2 | 16.6 | binh thuong |
| Cruzeiro do Sul | Brazil | 0.0 | 0.0 | 9.3 | 12.6 | 10.3 | 11.8 | 11.7 | binh thuong |
| Cubatao | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 17.0 | 17.1 | 16.9 | binh thuong |
| Curitiba | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.0 | 12.0 | 13.5 | binh thuong |
| Diadema | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 13.7 | 13.4 | binh thuong |
| Feijo | Brazil | 0.0 | 0.0 | 0.0 | 14.2 | 11.7 | 15.7 | 15.8 | binh thuong |
| Fortaleza | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 4.3 | 4.1 | 4.1 | binh thuong |
| Guarulhos | Brazil | 17.3 | 21.6 | 18.7 | 16.4 | 16.1 | 15.0 | 15.0 | binh thuong |
| Jundiai | Brazil | 0.0 | 0.0 | 0.0 | 14.0 | 13.1 | 12.5 | 12.4 | binh thuong |
| Macapa | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 7.5 | 4.4 | 4.6 | binh thuong |
| Manaus | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 10.3 | 12.7 | 12.1 | binh thuong |
| Mancio Lima | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 9.2 | 6.5 | 8.0 | binh thuong |
| Marituba | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.2 | 11.6 | 11.6 | binh thuong |
| Maua | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.7 | 13.6 | 14.2 | binh thuong |
| Osasco | Brazil | 0.0 | 22.1 | 19.8 | 16.7 | 16.8 | 15.1 | 15.0 | binh thuong |
| Palmas | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 6.3 | 10.6 | 10.4 | binh thuong |
| Pianco | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 4.6 | 4.0 | 4.0 | binh thuong |
| Piracicaba | Brazil | 12.5 | 13.6 | 13.4 | 13.7 | 13.3 | 11.6 | 11.3 | binh thuong |
| Porto Velho | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 22.1 | 20.2 | 20.2 | o nhiem nang |
| Ribeirao Preto | Brazil | 5.9 | 11.3 | 8.2 | 7.2 | 11.8 | 13.0 | 13.1 | binh thuong |
| Rio Branco | Brazil | 0.0 | 0.0 | 16.0 | 14.7 | 12.6 | 18.2 | 18.4 | binh thuong |
| Rio Claro | Brazil | 0.0 | 0.0 | 0.0 | 17.8 | 16.7 | 14.9 | 15.1 | binh thuong |
| Rio de Janeiro | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 13.0 | 10.6 | 10.6 | binh thuong |
| Santa Branca | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 10.0 | 8.1 | 8.1 | binh thuong |
| Santa Gertrudes | Brazil | 0.0 | 0.0 | 18.8 | 15.9 | 18.1 | 16.9 | 16.8 | binh thuong |
| Santos | Brazil | 15.9 | 14.8 | 15.4 | 13.7 | 12.0 | 12.1 | 12.1 | binh thuong |
| Sao Bernardo do Campo | Brazil | 0.0 | 16.4 | 16.7 | 15.9 | 15.2 | 13.9 | 13.9 | binh thuong |
| Sao Caetano do Sul | Brazil | 0.0 | 18.1 | 17.2 | 15.0 | 15.5 | 13.9 | 13.8 | binh thuong |
| Sao Jose do Rio Preto | Brazil | 0.0 | 15.4 | 15.2 | 16.6 | 15.7 | 10.4 | 10.4 | binh thuong |
| Sao Jose dos Campos | Brazil | 0.0 | 0.0 | 11.8 | 11.5 | 15.0 | 10.2 | 10.2 | binh thuong |
| Sao Paulo | Brazil | 16.0 | 16.2 | 15.3 | 14.2 | 14.8 | 13.5 | 13.5 | binh thuong |
| Senador Guiomard | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 12.9 | 18.7 | 18.7 | binh thuong |
| Taubate | Brazil | 0.0 | 11.4 | 11.5 | 11.7 | 11.6 | 10.9 | 10.8 | binh thuong |
| Timoteo | Brazil | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 13.9 | 13.7 | binh thuong |
Kết quả trả về ta thấy những thành phố nào có mức ô nhiễm dưới 20 được ghi ‘binh thuong’ còn trên 20 là ‘o nhiem nang’
summary(mt1$X2022)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 4.00 9.70 11.40 11.49 13.65 23.30Ta thấy được mức ô nhiễm thấp nhất trong năm 2022 ở 3 nước là 4, cao nhất là 23.3, tứ phân vị thứ nhất là 9.7, tứ phân vị thứ 2 (trung vị) là 11.4, tứ phân vị thứ 3 là 13.65, trung bình là 11.49