NHỮNG THÔNG TIN CƠ BẢN LIÊN QUAN TỚI BỘ DỮ
LIỆU:
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, union
library(lubridate)
##
## Attaching package: 'lubridate'
## The following objects are masked from 'package:base':
##
## date, intersect, setdiff, union
library(ggplot2)
Amazon.Sale.Report <- read.csv("C:/Users/HONG GAM/Desktop/FILE/Amazon Sale Report.csv", header=TRUE)
View(Amazon.Sale.Report)
str(Amazon.Sale.Report)
## 'data.frame': 128975 obs. of 24 variables:
## $ index : int 0 1 2 3 4 5 6 7 8 9 ...
## $ Order.ID : chr "405-8078784-5731545" "171-9198151-1101146" "404-0687676-7273146" "403-9615377-8133951" ...
## $ Date : chr "04-30-22" "04-30-22" "04-30-22" "04-30-22" ...
## $ Status : chr "Cancelled" "Shipped - Delivered to Buyer" "Shipped" "Cancelled" ...
## $ Fulfilment : chr "Merchant" "Merchant" "Amazon" "Merchant" ...
## $ Sales.Channel : chr "Amazon.in" "Amazon.in" "Amazon.in" "Amazon.in" ...
## $ ship.service.level: chr "Standard" "Standard" "Expedited" "Standard" ...
## $ Style : chr "SET389" "JNE3781" "JNE3371" "J0341" ...
## $ SKU : chr "SET389-KR-NP-S" "JNE3781-KR-XXXL" "JNE3371-KR-XL" "J0341-DR-L" ...
## $ Category : chr "Set" "kurta" "kurta" "Western Dress" ...
## $ Size : chr "S" "3XL" "XL" "L" ...
## $ ASIN : chr "B09KXVBD7Z" "B09K3WFS32" "B07WV4JV4D" "B099NRCT7B" ...
## $ Courier.Status : chr "" "Shipped" "Shipped" "" ...
## $ Qty : int 0 1 1 0 1 1 1 1 0 1 ...
## $ currency : chr "INR" "INR" "INR" "INR" ...
## $ Amount : num 648 406 329 753 574 ...
## $ ship.city : chr "MUMBAI" "BENGALURU" "NAVI MUMBAI" "PUDUCHERRY" ...
## $ ship.state : chr "MAHARASHTRA" "KARNATAKA" "MAHARASHTRA" "PUDUCHERRY" ...
## $ ship.postal.code : num 400081 560085 410210 605008 600073 ...
## $ ship.country : chr "IN" "IN" "IN" "IN" ...
## $ promotion.ids : chr "" "Amazon PLCC Free-Financing Universal Merchant AAT-WNKTBO3K27EJC,Amazon PLCC Free-Financing Universal Merchant A"| __truncated__ "IN Core Free Shipping 2015/04/08 23-48-5-108" "" ...
## $ B2B : chr "False" "False" "True" "False" ...
## $ fulfilled.by : chr "Easy Ship" "Easy Ship" "" "Easy Ship" ...
## $ Unnamed..22 : chr "" "" "" "" ...
dim(Amazon.Sale.Report)
## [1] 128975 24
Amazon.Sale.Report$Amount <- as.numeric(Amazon.Sale.Report$Amount)
colSums(is.na(Amazon.Sale.Report))
## index Order.ID Date Status
## 0 0 0 0
## Fulfilment Sales.Channel ship.service.level Style
## 0 0 0 0
## SKU Category Size ASIN
## 0 0 0 0
## Courier.Status Qty currency Amount
## 0 0 0 7795
## ship.city ship.state ship.postal.code ship.country
## 0 0 33 0
## promotion.ids B2B fulfilled.by Unnamed..22
## 0 0 0 0
sum(duplicated(Amazon.Sale.Report))
## [1] 0
Amazon.Sale.Report$`Unnamed: 22` <- NULL
PHÂN TỔ CÁC BIẾN
library(lubridate)
library(dplyr)
# Phân tổ theo tháng
amazon_sales_processed <- Amazon.Sale.Report %>% mutate(Date = mdy(Date), Month = month(Date))
monthly_revenue <- amazon_sales_processed %>% group_by(Month) %>%
summarise(Total_Revenue = sum(Amount, na.rm = TRUE), N_Orders = n(),
Avg_Amount = mean(Amount, na.rm = TRUE),.groups = 'drop' ) %>% arrange(Month)
print(monthly_revenue)
## # A tibble: 4 × 4
## Month Total_Revenue N_Orders Avg_Amount
## <dbl> <dbl> <int> <dbl>
## 1 3 101684. 171 628.
## 2 4 28838708. 49067 626.
## 3 5 26226477. 42040 663.
## 4 6 23425809. 37697 661.
# Phân tổ theo ngày và tháng
state_sales <- Amazon.Sale.Report %>%group_by(ship.state) %>%
summarise(TotalRevenue = sum(Amount, na.rm = TRUE), TotalQuantity = sum(Qty, na.rm = TRUE),
OrderCount = n()) %>% arrange(desc(TotalRevenue))
print(head(state_sales, 10))
## # A tibble: 10 × 4
## ship.state TotalRevenue TotalQuantity OrderCount
## <chr> <dbl> <int> <int>
## 1 MAHARASHTRA 13335534. 20328 22260
## 2 KARNATAKA 10481114. 15901 17326
## 3 TELANGANA 6916616. 10253 11330
## 4 UTTAR PRADESH 6816642. 9499 10638
## 5 TAMIL NADU 6515650. 10412 11483
## 6 DELHI 4235216. 6156 6782
## 7 KERALA 3830228. 5813 6585
## 8 WEST BENGAL 3507880. 5318 5963
## 9 ANDHRA PRADESH 3219832. 4819 5430
## 10 HARYANA 2882093. 4066 4415
library(dplyr)
# Phân tổ theo danh mục và kích cỡ
product_performance <- Amazon.Sale.Report %>%group_by(Category, Size) %>%
summarise( TotalQuantitySold = sum(Qty, na.rm = TRUE),
TotalRevenue = sum(Amount, na.rm = TRUE)) %>%
arrange(desc(TotalQuantitySold))
## `summarise()` has grouped output by 'Category'. You can override using the
## `.groups` argument.
print(head(product_performance, 10))
## # A tibble: 10 × 4
## # Groups: Category [2]
## Category Size TotalQuantitySold TotalRevenue
## <chr> <chr> <int> <dbl>
## 1 Set M 8357 7304158.
## 2 kurta L 8043 3729873.
## 3 kurta XL 7838 3633539.
## 4 kurta M 7713 3547070.
## 5 Set L 7399 6354714.
## 6 kurta XXL 6952 3223656.
## 7 Set XL 6873 5936974.
## 8 Set S 6708 5835237.
## 9 Set XXL 5608 4765516.
## 10 Set 3XL 5287 4530260.
# Phân tổ theo trạng thái và tính toán các chỉ số
summary_by_status <- Amazon.Sale.Report %>% group_by(Status) %>%
summarise(Total_Amount = sum(Amount, na.rm = TRUE), N_Orders = n(),
Avg_Amount = mean(Amount, na.rm = TRUE),.groups = 'drop' ) %>%
arrange(desc(N_Orders))
print(summary_by_status)
## # A tibble: 13 × 4
## Status Total_Amount N_Orders Avg_Amount
## <chr> <dbl> <int> <dbl>
## 1 Shipped 50324255 77804 649.
## 2 Shipped - Delivered to Buyer 18650815 28769 648.
## 3 Cancelled 6919284. 18332 643.
## 4 Shipped - Returned to Seller 1269644 1953 651.
## 5 Shipped - Picked Up 661252 973 680.
## 6 Pending 430271 658 656.
## 7 Pending - Waiting for Pick Up 192138 281 684.
## 8 Shipped - Returning to Seller 107620 145 742.
## 9 Shipped - Out for Delivery 26971 35 771.
## 10 Shipped - Rejected by Buyer 7295 11 663.
## 11 Shipping 0 8 NaN
## 12 Shipped - Lost in Transit 1997 5 399.
## 13 Shipped - Damaged 1136 1 1136
# Phân tổ theo trạng thái và theo tháng
amazon_sales_processed <- Amazon.Sale.Report %>%mutate(Date = mdy(Date),
Month = month(Date))
summary_status_by_month <- amazon_sales_processed %>% group_by(Month, Status) %>%
summarise(N_Orders = n(), Total_Amount = sum(Amount, na.rm = TRUE),
.groups = 'drop' ) %>% arrange(Month, desc(N_Orders))
print(summary_status_by_month)
## # A tibble: 35 × 4
## Month Status N_Orders Total_Amount
## <dbl> <chr> <int> <dbl>
## 1 3 Shipped 136 84013
## 2 3 Cancelled 18 6874.
## 3 3 Shipped - Delivered to Buyer 16 10170
## 4 3 Shipped - Returned to Seller 1 627
## 5 4 Shipped 28941 18211506
## 6 4 Shipped - Delivered to Buyer 12080 7453429
## 7 4 Cancelled 7137 2604188.
## 8 4 Shipped - Returned to Seller 893 559636
## 9 4 Shipped - Rejected by Buyer 6 3396
## 10 4 Shipped - Picked Up 4 2798
## # ℹ 25 more rows
PHÂN TÍCH CÁC BIẾN
#BIẾN AMOUNT
summary(Amazon.Sale.Report$Amount)
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.0 449.0 605.0 648.6 788.0 5584.0 7795
mean(Amazon.Sale.Report$Amount, na.rm = TRUE)
## [1] 648.5615
median(Amazon.Sale.Report$Amount, na.rm = TRUE)
## [1] 605
sd(Amazon.Sale.Report$Amount, na.rm = TRUE)
## [1] 281.2117
#Kiểm tra tổng số giá trị NA trong biến
sum(is.na(Amazon.Sale.Report$Amount))
## [1] 7795
#Kiểm tra vị trí (dòng) có giá trị NA trong
which(is.na(Amazon.Sale.Report$Amount))
## [1] 9 30 66 85 96 102 133 140 156 166
## [11] 206 216 243 250 251 272 329 364 382 414
## [21] 429 449 457 471 490 501 504 510 519 522
## [31] 536 541 548 564 573 594 603 631 632 633
## [41] 634 640 653 672 673 676 692 709 712 714
## [51] 738 749 771 819 821 835 850 857 858 865
## [61] 893 899 930 932 938 957 961 967 969 970
## [71] 1010 1011 1013 1016 1026 1027 1035 1051 1058 1107
## [81] 1113 1118 1121 1159 1162 1176 1182 1190 1208 1217
## [91] 1224 1235 1240 1248 1251 1264 1275 1283 1284 1288
## [101] 1296 1319 1359 1408 1412 1476 1505 1516 1519 1526
## [111] 1529 1552 1581 1613 1614 1616 1618 1643 1644 1658
## [121] 1659 1665 1672 1682 1683 1684 1695 1696 1723 1724
## [131] 1726 1749 1765 1774 1791 1796 1801 1818 1820 1821
## [141] 1826 1830 1857 1862 1869 1884 1894 1902 1914 1932
## [151] 1946 1959 1972 1973 1974 1990 1994 1998 2028 2034
## [161] 2035 2036 2054 2059 2070 2087 2101 2102 2134 2151
## [171] 2170 2196 2202 2204 2205 2222 2231 2233 2249 2268
## [181] 2287 2310 2311 2329 2348 2364 2381 2404 2425 2437
## [191] 2449 2459 2483 2485 2491 2498 2501 2504 2507 2520
## [201] 2538 2543 2554 2573 2577 2587 2607 2638 2665 2677
## [211] 2690 2712 2751 2786 2789 2806 2820 2831 2948 2985
## [221] 3004 3010 3057 3059 3122 3123 3134 3157 3215 3245
## [231] 3252 3362 3373 3417 3446 3449 3464 3497 3542 3574
## [241] 3604 3608 3612 3613 3620 3629 3631 3632 3633 3635
## [251] 3637 3638 3649 3706 3739 3804 3816 3817 3881 3884
## [261] 3887 3888 3889 3890 3891 3892 3893 3894 3895 3954
## [271] 3972 3973 4000 4001 4016 4068 4073 4094 4105 4115
## [281] 4127 4142 4190 4193 4267 4270 4271 4274 4292 4295
## [291] 4302 4325 4342 4366 4372 4373 4390 4409 4416 4421
## [301] 4434 4435 4457 4488 4489 4491 4497 4552 4575 4599
## [311] 4628 4630 4632 4634 4639 4642 4669 4672 4695 4724
## [321] 4729 4740 4779 4780 4851 4852 4853 4856 4879 4930
## [331] 4940 4955 4956 4963 4967 4972 4973 4992 5036 5077
## [341] 5082 5088 5089 5093 5097 5111 5123 5129 5162 5167
## [351] 5168 5183 5185 5200 5209 5248 5282 5288 5295 5317
## [361] 5318 5319 5381 5425 5436 5472 5476 5484 5514 5534
## [371] 5565 5599 5624 5642 5649 5656 5686 5711 5832 5841
## [381] 5880 5924 5942 5944 5945 5946 5950 5988 6066 6076
## [391] 6165 6166 6188 6189 6190 6200 6210 6219 6221 6224
## [401] 6265 6297 6309 6310 6311 6323 6330 6365 6380 6395
## [411] 6399 6407 6417 6430 6445 6504 6617 6635 6734 6745
## [421] 6754 6766 6767 6769 6771 6778 6779 6783 6794 6803
## [431] 6816 6824 6833 6861 6865 6873 6874 6876 6968 7050
## [441] 7058 7081 7083 7084 7085 7099 7119 7120 7127 7142
## [451] 7169 7234 7242 7301 7305 7335 7336 7351 7357 7366
## [461] 7373 7388 7389 7416 7595 7628 7629 7666 7682 7704
## [471] 7722 7737 7738 7750 7774 7777 7831 7841 7862 7872
## [481] 7873 7877 7879 7888 7891 7895 7898 7904 7906 7937
## [491] 7961 7966 7968 7972 7984 7990 8014 8051 8100 8116
## [501] 8120 8146 8151 8183 8185 8190 8201 8204 8216 8226
## [511] 8231 8240 8266 8274 8275 8276 8288 8293 8362 8378
## [521] 8396 8418 8435 8465 8491 8496 8505 8531 8555 8564
## [531] 8621 8638 8647 8671 8676 8681 8685 8691 8708 8763
## [541] 8768 8799 8848 8862 8864 8866 8872 8874 8876 8890
## [551] 8935 8959 8960 8961 8962 8963 9000 9007 9011 9018
## [561] 9025 9032 9033 9038 9046 9047 9048 9052 9058 9073
## [571] 9083 9097 9103 9109 9131 9132 9137 9146 9149 9161
## [581] 9187 9246 9256 9267 9279 9315 9332 9333 9335 9336
## [591] 9386 9415 9432 9455 9462 9463 9473 9504 9507 9540
## [601] 9545 9550 9571 9604 9655 9685 9701 9702 9706 9737
## [611] 9764 9793 9849 9881 9894 9938 9964 10014 10018 10037
## [621] 10054 10091 10128 10137 10142 10143 10148 10161 10168 10198
## [631] 10199 10200 10223 10244 10298 10306 10335 10336 10347 10348
## [641] 10407 10422 10433 10434 10439 10440 10447 10466 10467 10471
## [651] 10556 10567 10569 10571 10585 10625 10628 10629 10630 10638
## [661] 10661 10678 10679 10682 10690 10694 10715 10745 10758 10778
## [671] 10783 10794 10844 10845 10847 10858 10859 10860 10869 10961
## [681] 10986 10999 11006 11007 11015 11024 11035 11042 11054 11063
## [691] 11068 11083 11105 11146 11158 11165 11223 11256 11261 11272
## [701] 11273 11282 11291 11326 11329 11331 11342 11354 11415 11420
## [711] 11466 11476 11482 11564 11568 11570 11628 11645 11652 11655
## [721] 11656 11660 11661 11677 11682 11696 11717 11722 11730 11747
## [731] 11792 11932 11939 11975 11979 12035 12049 12066 12104 12131
## [741] 12152 12186 12191 12229 12247 12296 12307 12318 12348 12367
## [751] 12368 12382 12387 12405 12459 12468 12512 12596 12619 12633
## [761] 12637 12651 12652 12670 12689 12701 12712 12713 12723 12728
## [771] 12775 12803 12825 12830 12832 12835 12851 12864 12902 12906
## [781] 12975 13012 13016 13030 13031 13070 13109 13125 13175 13213
## [791] 13270 13279 13283 13300 13312 13325 13347 13365 13368 13371
## [801] 13378 13379 13400 13456 13461 13466 13507 13557 13558 13562
## [811] 13586 13588 13658 13691 13700 13703 13705 13711 13713 13717
## [821] 13719 13720 13722 13723 13724 13726 13730 13731 13733 13734
## [831] 13744 13765 13788 13799 13816 13820 13842 13849 13850 13855
## [841] 13859 13865 13895 13897 13901 13910 13912 13933 13947 13950
## [851] 14038 14066 14078 14079 14093 14098 14144 14229 14232 14239
## [861] 14288 14299 14337 14354 14360 14361 14362 14363 14364 14365
## [871] 14366 14367 14371 14437 14465 14493 14497 14504 14513 14546
## [881] 14575 14619 14620 14644 14645 14682 14738 14766 14787 14788
## [891] 14852 14868 14947 14965 15022 15047 15048 15054 15056 15062
## [901] 15065 15073 15081 15083 15087 15090 15125 15135 15141 15153
## [911] 15160 15161 15162 15170 15184 15187 15196 15216 15258 15267
## [921] 15271 15281 15311 15367 15374 15381 15382 15409 15417 15436
## [931] 15455 15478 15528 15533 15534 15553 15557 15564 15585 15598
## [941] 15601 15615 15637 15646 15659 15687 15703 15711 15715 15759
## [951] 15796 15810 15812 15813 15816 15834 15853 15864 15872 15882
## [961] 15886 15896 15951 15961 15962 15964 15993 16028 16038 16039
## [971] 16047 16062 16067 16088 16089 16104 16112 16158 16163 16192
## [981] 16202 16216 16223 16232 16283 16284 16320 16352 16356 16364
## [991] 16379 16401 16437 16457 16523 16589 16592 16598 16600 16632
## [1001] 16708 16711 16717 16719 16720 16727 16734 16740 16747 16748
## [1011] 16758 16759 16784 16802 16809 16823 16842 16843 16851 16890
## [1021] 16917 16918 16925 16936 16944 16979 17050 17081 17086 17089
## [1031] 17113 17119 17156 17175 17185 17189 17229 17230 17250 17292
## [1041] 17313 17344 17352 17369 17396 17436 17520 17537 17572 17574
## [1051] 17578 17622 17653 17657 17673 17674 17676 17679 17695 17708
## [1061] 17725 17766 17781 17782 17802 17806 17822 17835 17867 17897
## [1071] 17945 17980 17993 18004 18022 18040 18060 18061 18067 18101
## [1081] 18131 18137 18145 18151 18169 18215 18218 18236 18278 18288
## [1091] 18311 18337 18349 18402 18409 18436 18453 18462 18464 18472
## [1101] 18490 18491 18519 18535 18551 18567 18574 18575 18607 18610
## [1111] 18625 18627 18667 18668 18669 18671 18672 18674 18675 18676
## [1121] 18677 18679 18704 18732 18736 18774 18784 18789 18791 18839
## [1131] 18849 18860 18868 18885 18892 18895 18900 18923 18959 18966
## [1141] 18968 18971 18973 19025 19044 19054 19121 19132 19135 19164
## [1151] 19175 19185 19243 19249 19269 19291 19293 19313 19324 19326
## [1161] 19329 19349 19381 19382 19385 19386 19391 19396 19405 19424
## [1171] 19425 19428 19476 19485 19527 19586 19591 19602 19613 19654
## [1181] 19659 19664 19672 19693 19705 19709 19723 19740 19745 19781
## [1191] 19793 19794 19799 19838 19852 19875 19887 19899 19914 19918
## [1201] 19921 19929 19931 19939 19945 19949 19951 19968 19980 19994
## [1211] 20002 20013 20043 20055 20063 20065 20085 20094 20099 20212
## [1221] 20233 20273 20279 20282 20300 20316 20318 20339 20348 20352
## [1231] 20400 20403 20422 20480 20508 20525 20541 20545 20573 20581
## [1241] 20592 20606 20650 20653 20665 20671 20680 20681 20682 20714
## [1251] 20720 20726 20727 20740 20755 20756 20757 20767 20787 20793
## [1261] 20801 20808 20814 20825 20848 20868 20897 20918 20920 20924
## [1271] 20951 20956 20971 20980 20986 21044 21046 21068 21094 21132
## [1281] 21138 21150 21154 21160 21201 21215 21229 21235 21259 21329
## [1291] 21354 21357 21366 21389 21405 21455 21492 21543 21553 21568
## [1301] 21610 21626 21627 21635 21649 21661 21662 21685 21687 21712
## [1311] 21714 21784 21786 21787 21795 21798 21807 21826 21827 21829
## [1321] 21850 21915 21934 21953 21959 21970 21991 21996 22013 22032
## [1331] 22076 22084 22094 22106 22113 22123 22124 22134 22148 22201
## [1341] 22211 22224 22236 22239 22242 22267 22342 22374 22388 22508
## [1351] 22532 22539 22552 22560 22563 22570 22573 22629 22630 22643
## [1361] 22676 22693 22694 22727 22783 22784 22785 22805 22825 22826
## [1371] 22834 22835 22850 22858 22886 22888 22889 22958 22970 22973
## [1381] 23015 23023 23049 23055 23129 23161 23169 23174 23175 23179
## [1391] 23183 23205 23215 23216 23225 23226 23227 23230 23239 23246
## [1401] 23253 23254 23299 23350 23351 23352 23371 23381 23427 23455
## [1411] 23457 23471 23482 23539 23540 23542 23565 23574 23586 23587
## [1421] 23604 23608 23639 23659 23661 23679 23681 23693 23697 23791
## [1431] 23792 23857 23873 23874 23884 23889 23895 23899 23904 23905
## [1441] 23912 23943 23948 23960 23984 23990 23995 24003 24011 24019
## [1451] 24023 24033 24056 24059 24061 24085 24086 24123 24141 24185
## [1461] 24200 24271 24274 24319 24325 24368 24405 24407 24449 24450
## [1471] 24455 24463 24511 24512 24518 24537 24551 24552 24571 24581
## [1481] 24585 24587 24588 24593 24597 24606 24608 24631 24644 24655
## [1491] 24659 24660 24681 24704 24707 24786 24798 24809 24869 24870
## [1501] 24874 24893 24904 24921 24930 24953 24959 24968 24969 24970
## [1511] 24971 24972 24973 24975 24976 24997 25000 25013 25022 25028
## [1521] 25031 25034 25061 25062 25063 25073 25074 25077 25078 25091
## [1531] 25109 25130 25131 25132 25133 25137 25142 25156 25183 25185
## [1541] 25186 25187 25199 25200 25245 25250 25260 25261 25267 25276
## [1551] 25277 25291 25304 25314 25350 25352 25365 25368 25380 25383
## [1561] 25392 25395 25400 25404 25446 25459 25470 25486 25488 25503
## [1571] 25520 25546 25550 25551 25552 25579 25589 25601 25609 25634
## [1581] 25635 25702 25719 25722 25740 25774 25806 25809 25813 25815
## [1591] 25817 25819 25825 25872 25904 25905 25925 25934 25959 25970
## [1601] 25992 25998 26025 26029 26081 26082 26096 26117 26154 26157
## [1611] 26164 26188 26195 26200 26219 26223 26234 26235 26237 26240
## [1621] 26249 26253 26288 26296 26311 26331 26346 26364 26391 26392
## [1631] 26414 26418 26419 26440 26466 26494 26540 26561 26607 26620
## [1641] 26636 26675 26691 26728 26763 26770 26821 26825 26853 26880
## [1651] 26894 26916 26936 26941 26944 26947 26982 27014 27066 27086
## [1661] 27116 27151 27157 27158 27159 27160 27200 27201 27202 27229
## [1671] 27230 27242 27255 27257 27258 27305 27306 27308 27313 27316
## [1681] 27324 27341 27345 27358 27367 27394 27403 27408 27424 27430
## [1691] 27475 27477 27482 27491 27517 27518 27519 27520 27521 27532
## [1701] 27543 27564 27575 27576 27591 27594 27621 27625 27646 27655
## [1711] 27668 27707 27709 27730 27758 27765 27771 27806 27840 27847
## [1721] 27883 27884 27885 27886 27939 27949 27965 27971 27993 27995
## [1731] 28021 28038 28048 28050 28055 28119 28144 28162 28178 28197
## [1741] 28198 28291 28296 28306 28317 28338 28351 28364 28384 28385
## [1751] 28387 28392 28411 28427 28431 28432 28433 28435 28453 28457
## [1761] 28464 28476 28506 28507 28508 28509 28539 28545 28575 28583
## [1771] 28609 28615 28636 28657 28662 28680 28691 28692 28714 28736
## [1781] 28771 28779 28807 28808 28809 28810 28827 28834 28842 28848
## [1791] 28887 28889 28932 28933 28934 28935 28960 28994 28996 29019
## [1801] 29020 29090 29095 29099 29100 29126 29144 29153 29168 29183
## [1811] 29192 29230 29248 29300 29307 29309 29326 29327 29338 29372
## [1821] 29381 29427 29439 29448 29457 29470 29475 29515 29518 29583
## [1831] 29589 29604 29608 29629 29640 29657 29684 29688 29732 29736
## [1841] 29739 29743 29777 29812 29904 29922 29960 29961 29972 29988
## [1851] 29989 29990 30015 30026 30042 30128 30152 30153 30163 30179
## [1861] 30194 30221 30249 30253 30256 30282 30333 30335 30354 30355
## [1871] 30363 30393 30404 30414 30418 30462 30475 30478 30505 30507
## [1881] 30552 30574 30578 30590 30604 30605 30606 30622 30644 30650
## [1891] 30661 30662 30719 30726 30769 30806 30808 30837 30846 30849
## [1901] 30875 30878 30890 30893 30940 30941 30942 30948 30958 30979
## [1911] 30984 31003 31014 31033 31034 31053 31055 31059 31113 31127
## [1921] 31134 31136 31145 31159 31266 31295 31308 31318 31329 31339
## [1931] 31361 31367 31377 31381 31403 31426 31434 31435 31469 31475
## [1941] 31505 31513 31519 31525 31535 31614 31619 31621 31666 31673
## [1951] 31679 31686 31689 31704 31780 31784 31793 31806 31826 31830
## [1961] 31836 31857 31877 31895 31906 31911 31915 31918 31970 31989
## [1971] 32007 32014 32023 32040 32044 32049 32075 32116 32148 32168
## [1981] 32171 32172 32173 32188 32191 32207 32227 32235 32252 32260
## [1991] 32264 32289 32299 32308 32309 32314 32316 32326 32350 32351
## [2001] 32365 32381 32383 32403 32412 32447 32461 32498 32503 32506
## [2011] 32515 32536 32546 32551 32564 32597 32607 32608 32624 32645
## [2021] 32694 32695 32696 32736 32745 32777 32808 32814 32843 32858
## [2031] 32874 32876 32879 32911 32989 33002 33017 33028 33032 33046
## [2041] 33081 33083 33143 33179 33193 33257 33273 33325 33339 33359
## [2051] 33378 33379 33393 33421 33440 33456 33464 33478 33479 33499
## [2061] 33500 33548 33600 33601 33652 33657 33673 33678 33697 33705
## [2071] 33747 33753 33758 33813 33845 33846 33991 34012 34021 34120
## [2081] 34133 34148 34155 34199 34247 34264 34267 34282 34312 34322
## [2091] 34336 34343 34396 34433 34460 34462 34463 34473 34474 34494
## [2101] 34526 34536 34555 34570 34605 34617 34627 34631 34644 34682
## [2111] 34686 34687 34688 34689 34690 34693 34721 34729 34754 34758
## [2121] 34767 34812 34840 34850 34903 34942 34958 34963 34964 34982
## [2131] 35007 35030 35082 35088 35093 35120 35121 35123 35148 35157
## [2141] 35217 35244 35296 35302 35312 35337 35338 35351 35382 35398
## [2151] 35431 35443 35482 35509 35528 35549 35562 35567 35586 35587
## [2161] 35633 35657 35667 35670 35674 35678 35679 35692 35745 35755
## [2171] 35762 35764 35778 35779 35822 35876 35878 35894 35918 35935
## [2181] 35982 36003 36005 36031 36045 36063 36072 36073 36076 36097
## [2191] 36102 36103 36106 36107 36109 36110 36111 36112 36113 36130
## [2201] 36167 36220 36257 36258 36287 36289 36315 36316 36333 36342
## [2211] 36354 36355 36376 36426 36507 36514 36519 36528 36563 36590
## [2221] 36591 36596 36597 36607 36641 36664 36686 36693 36746 36747
## [2231] 36749 36756 36762 36800 36805 36822 36824 36827 36850 36864
## [2241] 36917 36918 36990 37022 37023 37025 37035 37036 37057 37075
## [2251] 37082 37096 37118 37123 37179 37183 37201 37207 37222 37227
## [2261] 37247 37260 37268 37288 37289 37291 37298 37345 37346 37352
## [2271] 37367 37376 37385 37406 37443 37462 37508 37514 37537 37544
## [2281] 37550 37605 37608 37657 37691 37715 37718 37722 37736 37832
## [2291] 37840 37862 37877 37898 37931 37942 37955 37969 37986 37987
## [2301] 37992 37993 38001 38021 38023 38030 38039 38054 38075 38116
## [2311] 38154 38213 38274 38277 38284 38330 38332 38365 38410 38435
## [2321] 38440 38447 38487 38492 38494 38495 38500 38507 38526 38537
## [2331] 38546 38551 38584 38585 38603 38612 38613 38616 38623 38656
## [2341] 38721 38723 38754 38764 38781 38797 38798 38830 38833 38845
## [2351] 38855 38863 38869 38877 38887 38906 38912 38915 38927 38930
## [2361] 38931 38942 38952 38960 38976 39008 39046 39051 39056 39057
## [2371] 39063 39074 39089 39091 39092 39096 39107 39108 39109 39146
## [2381] 39171 39172 39185 39190 39212 39235 39251 39258 39277 39278
## [2391] 39288 39378 39394 39406 39435 39465 39480 39483 39486 39506
## [2401] 39508 39536 39546 39577 39578 39584 39606 39615 39620 39626
## [2411] 39628 39650 39651 39655 39658 39662 39663 39681 39724 39768
## [2421] 39795 39803 39823 39824 39825 39908 39922 39936 39981 39986
## [2431] 40083 40157 40175 40191 40192 40208 40228 40229 40234 40267
## [2441] 40268 40269 40270 40271 40272 40300 40331 40332 40346 40363
## [2451] 40385 40400 40411 40412 40414 40415 40416 40426 40440 40449
## [2461] 40476 40506 40522 40536 40548 40587 40603 40609 40630 40655
## [2471] 40662 40671 40710 40773 40817 40865 40871 40924 40974 40984
## [2481] 41009 41059 41060 41062 41117 41135 41160 41161 41162 41164
## [2491] 41196 41287 41292 41293 41306 41314 41316 41327 41333 41380
## [2501] 41426 41470 41483 41495 41509 41510 41511 41517 41531 41542
## [2511] 41543 41581 41595 41596 41602 41611 41636 41644 41650 41666
## [2521] 41668 41691 41726 41742 41751 41757 41773 41790 41801 41830
## [2531] 41840 41844 41882 41905 41906 41910 41930 41935 41977 41978
## [2541] 41989 42012 42045 42052 42056 42057 42072 42080 42083 42094
## [2551] 42115 42146 42149 42158 42163 42171 42201 42214 42239 42256
## [2561] 42277 42280 42308 42326 42331 42386 42400 42429 42438 42464
## [2571] 42465 42475 42510 42534 42535 42537 42539 42551 42559 42578
## [2581] 42586 42589 42596 42610 42726 42732 42734 42735 42736 42739
## [2591] 42744 42745 42746 42767 42816 42867 42875 42881 42894 42934
## [2601] 42935 42951 42970 42975 42984 42999 43037 43041 43084 43085
## [2611] 43086 43098 43169 43170 43181 43186 43198 43218 43244 43259
## [2621] 43294 43308 43345 43348 43404 43414 43421 43431 43443 43473
## [2631] 43488 43525 43568 43582 43604 43656 43659 43661 43669 43706
## [2641] 43722 43723 43747 43751 43760 43764 43857 43873 43913 43937
## [2651] 43938 43944 43949 43951 43965 43968 43991 43994 43995 43996
## [2661] 44001 44010 44014 44032 44056 44058 44061 44071 44100 44127
## [2671] 44135 44141 44142 44153 44155 44187 44188 44189 44190 44191
## [2681] 44210 44211 44219 44223 44248 44249 44258 44275 44314 44402
## [2691] 44418 44431 44487 44507 44528 44530 44565 44566 44577 44581
## [2701] 44583 44592 44613 44627 44656 44657 44658 44663 44685 44701
## [2711] 44706 44739 44744 44755 44762 44790 44810 44812 44827 44846
## [2721] 44906 44933 44970 44987 45034 45039 45052 45064 45069 45076
## [2731] 45111 45113 45128 45141 45153 45163 45188 45189 45190 45196
## [2741] 45230 45241 45242 45244 45251 45256 45257 45261 45278 45303
## [2751] 45315 45322 45343 45386 45449 45483 45486 45517 45534 45547
## [2761] 45583 45607 45613 45651 45671 45688 45691 45715 45718 45735
## [2771] 45748 45823 45828 45854 45868 45879 45884 45927 45933 45935
## [2781] 45954 45956 46006 46018 46041 46062 46077 46080 46084 46181
## [2791] 46190 46198 46210 46219 46220 46246 46248 46264 46276 46285
## [2801] 46300 46327 46332 46351 46362 46395 46396 46415 46417 46419
## [2811] 46424 46428 46431 46440 46451 46461 46462 46505 46508 46557
## [2821] 46571 46572 46583 46601 46604 46610 46632 46633 46651 46666
## [2831] 46685 46738 46751 46756 46768 46773 46778 46780 46791 46836
## [2841] 46851 46853 46913 46917 46918 46928 46957 47013 47026 47031
## [2851] 47035 47040 47063 47064 47068 47095 47113 47117 47120 47137
## [2861] 47149 47150 47179 47199 47220 47230 47274 47275 47279 47280
## [2871] 47282 47380 47403 47427 47437 47450 47486 47527 47555 47599
## [2881] 47615 47626 47629 47630 47631 47635 47664 47689 47697 47725
## [2891] 47729 47754 47768 47770 47788 47794 47835 47836 47843 47844
## [2901] 47845 47855 47864 47865 47866 47871 47884 47899 47900 47909
## [2911] 47931 47937 47961 47979 47983 47984 48002 48006 48027 48030
## [2921] 48053 48054 48055 48079 48097 48103 48110 48120 48140 48146
## [2931] 48150 48151 48156 48177 48178 48183 48212 48218 48219 48231
## [2941] 48256 48279 48280 48281 48320 48322 48338 48368 48381 48396
## [2951] 48404 48409 48414 48444 48450 48453 48504 48506 48507 48518
## [2961] 48554 48574 48576 48590 48614 48628 48643 48644 48650 48651
## [2971] 48659 48686 48690 48733 48796 48802 48806 48839 48844 48850
## [2981] 48860 48893 48903 48913 48914 48933 48983 49007 49008 49049
## [2991] 49053 49107 49149 49165 49204 49205 49217 49236 49264 49298
## [3001] 49334 49337 49339 49344 49345 49348 49415 49432 49480 49489
## [3011] 49511 49524 49525 49550 49551 49582 49583 49591 49593 49617
## [3021] 49660 49667 49672 49712 49713 49743 49766 49772 49773 49831
## [3031] 49837 49838 49859 49869 49870 49890 49915 49958 49962 49968
## [3041] 50005 50008 50012 50018 50026 50029 50031 50048 50071 50074
## [3051] 50117 50156 50185 50213 50228 50234 50237 50240 50245 50270
## [3061] 50280 50299 50322 50339 50360 50374 50381 50396 50402 50420
## [3071] 50453 50464 50468 50474 50487 50491 50524 50527 50534 50556
## [3081] 50583 50592 50619 50624 50664 50688 50706 50735 50781 50799
## [3091] 50810 50817 50839 50859 50861 50866 50867 50869 50885 50899
## [3101] 50914 50946 50967 50989 51009 51039 51113 51116 51128 51147
## [3111] 51156 51181 51197 51208 51218 51227 51231 51246 51247 51251
## [3121] 51280 51286 51295 51298 51304 51313 51364 51415 51418 51419
## [3131] 51454 51465 51489 51496 51523 51561 51566 51569 51573 51577
## [3141] 51615 51616 51629 51635 51674 51689 51690 51691 51711 51742
## [3151] 51745 51797 51859 51861 51864 51877 51962 51967 51998 51999
## [3161] 52011 52059 52060 52061 52077 52100 52172 52179 52180 52186
## [3171] 52202 52207 52230 52259 52301 52315 52331 52342 52358 52389
## [3181] 52414 52420 52449 52452 52486 52503 52515 52517 52554 52581
## [3191] 52598 52606 52624 52628 52643 52644 52670 52676 52688 52689
## [3201] 52694 52727 52741 52747 52760 52770 52783 52790 52805 52853
## [3211] 52854 52858 52891 52923 52933 52938 52957 52975 52987 52988
## [3221] 53001 53012 53023 53032 53048 53102 53108 53109 53110 53121
## [3231] 53142 53146 53162 53165 53176 53184 53185 53186 53187 53226
## [3241] 53290 53291 53294 53344 53396 53440 53445 53481 53520 53534
## [3251] 53560 53585 53651 53653 53654 53675 53680 53697 53704 53749
## [3261] 53761 53780 53781 53795 53796 53797 53798 53799 53801 53803
## [3271] 53804 53806 53824 53827 53837 53839 53840 53849 53867 53870
## [3281] 53941 53978 53979 53997 54006 54008 54009 54025 54044 54125
## [3291] 54184 54194 54195 54271 54305 54340 54344 54368 54412 54427
## [3301] 54438 54447 54463 54467 54475 54488 54490 54514 54516 54520
## [3311] 54521 54526 54533 54544 54557 54578 54685 54723 54727 54729
## [3321] 54733 54754 54762 54790 54812 54822 54841 54847 54856 54857
## [3331] 54858 54880 54896 54907 54922 54949 54975 54985 54992 54993
## [3341] 55000 55011 55013 55014 55018 55019 55039 55050 55065 55070
## [3351] 55098 55104 55106 55113 55119 55157 55180 55186 55218 55226
## [3361] 55234 55247 55249 55252 55276 55277 55290 55333 55379 55388
## [3371] 55423 55435 55449 55452 55480 55536 55537 55548 55594 55606
## [3381] 55607 55609 55616 55632 55654 55670 55673 55674 55680 55685
## [3391] 55704 55732 55747 55757 55768 55804 55814 55846 55862 55870
## [3401] 55888 55916 55931 55942 55967 55968 55990 56000 56039 56058
## [3411] 56076 56096 56099 56100 56126 56144 56191 56221 56235 56236
## [3421] 56260 56270 56272 56289 56298 56319 56342 56356 56371 56394
## [3431] 56412 56420 56448 56449 56523 56526 56536 56556 56559 56582
## [3441] 56605 56630 56675 56682 56683 56692 56719 56721 56746 56821
## [3451] 56846 56849 56928 56936 56948 56964 56983 56984 56992 57003
## [3461] 57022 57125 57133 57162 57163 57201 57207 57211 57244 57252
## [3471] 57255 57271 57298 57304 57319 57320 57331 57354 57361 57362
## [3481] 57363 57364 57377 57379 57389 57401 57424 57425 57443 57444
## [3491] 57456 57469 57473 57476 57486 57513 57524 57547 57548 57605
## [3501] 57667 57668 57669 57686 57694 57740 57748 57774 57799 57850
## [3511] 57853 57922 57932 57937 57965 57976 57990 57991 58037 58091
## [3521] 58124 58128 58137 58147 58152 58161 58171 58172 58245 58280
## [3531] 58290 58317 58322 58331 58337 58367 58383 58407 58416 58440
## [3541] 58444 58458 58514 58515 58516 58555 58559 58581 58610 58611
## [3551] 58628 58634 58642 58643 58656 58657 58685 58689 58700 58701
## [3561] 58705 58710 58718 58730 58766 58784 58795 58802 58813 58816
## [3571] 58827 58840 58847 58867 58869 58902 58923 58934 58954 58963
## [3581] 58987 58991 58998 59005 59014 59015 59050 59056 59099 59139
## [3591] 59140 59148 59180 59182 59186 59208 59209 59243 59251 59255
## [3601] 59256 59260 59287 59295 59312 59334 59343 59344 59395 59424
## [3611] 59453 59455 59501 59505 59534 59547 59548 59549 59636 59660
## [3621] 59722 59737 59741 59764 59781 59801 59831 59875 59913 59917
## [3631] 59930 59978 59988 60037 60051 60059 60067 60079 60088 60090
## [3641] 60179 60193 60208 60209 60220 60225 60233 60238 60261 60276
## [3651] 60277 60278 60279 60326 60327 60333 60334 60348 60359 60365
## [3661] 60368 60371 60377 60382 60383 60392 60423 60437 60443 60448
## [3671] 60454 60474 60516 60517 60522 60559 60571 60583 60590 60629
## [3681] 60647 60697 60738 60751 60756 60791 60818 60836 60851 60888
## [3691] 60901 60924 60941 60947 60951 60972 60978 60999 61040 61063
## [3701] 61070 61071 61076 61084 61106 61122 61143 61181 61185 61190
## [3711] 61216 61217 61226 61244 61255 61273 61309 61315 61318 61319
## [3721] 61320 61321 61322 61323 61324 61325 61326 61327 61337 61340
## [3731] 61341 61355 61426 61457 61485 61509 61520 61587 61589 61628
## [3741] 61629 61648 61664 61674 61681 61692 61693 61698 61717 61729
## [3751] 61730 61735 61765 61821 61853 61897 61970 61977 62020 62023
## [3761] 62061 62069 62078 62140 62141 62148 62174 62187 62249 62316
## [3771] 62321 62322 62346 62375 62401 62411 62451 62455 62480 62488
## [3781] 62507 62546 62552 62583 62584 62585 62605 62616 62617 62620
## [3791] 62637 62673 62686 62695 62705 62706 62741 62774 62783 62792
## [3801] 62803 62851 62883 62909 62932 62971 63027 63058 63062 63115
## [3811] 63122 63126 63131 63138 63166 63177 63186 63190 63192 63196
## [3821] 63234 63272 63278 63302 63304 63309 63342 63345 63367 63375
## [3831] 63376 63413 63435 63463 63466 63511 63544 63565 63581 63601
## [3841] 63611 63614 63622 63625 63653 63669 63679 63680 63693 63750
## [3851] 63753 63765 63770 63773 63774 63786 63792 63914 63925 63930
## [3861] 63950 63968 64003 64061 64085 64099 64150 64187 64206 64219
## [3871] 64250 64256 64296 64302 64307 64308 64309 64343 64384 64400
## [3881] 64406 64467 64468 64470 64472 64479 64480 64483 64505 64513
## [3891] 64515 64538 64543 64552 64565 64569 64570 64578 64602 64615
## [3901] 64634 64644 64653 64654 64667 64672 64700 64738 64773 64786
## [3911] 64817 64823 64846 64854 65035 65036 65037 65038 65050 65141
## [3921] 65158 65173 65175 65197 65198 65199 65215 65237 65258 65259
## [3931] 65260 65275 65285 65304 65323 65338 65354 65419 65421 65424
## [3941] 65439 65440 65508 65509 65510 65542 65549 65559 65576 65580
## [3951] 65597 65610 65631 65641 65676 65694 65714 65715 65732 65740
## [3961] 65749 65753 65756 65765 65854 65871 65874 65878 65881 65887
## [3971] 65888 65908 65918 65922 65968 65972 66001 66035 66073 66095
## [3981] 66108 66119 66124 66125 66162 66163 66181 66217 66242 66251
## [3991] 66256 66257 66258 66260 66261 66274 66322 66329 66355 66371
## [4001] 66372 66373 66393 66395 66467 66481 66484 66489 66492 66493
## [4011] 66567 66573 66608 66622 66648 66652 66696 66706 66731 66831
## [4021] 66857 66872 66906 66926 66946 66948 66972 67003 67029 67060
## [4031] 67061 67079 67085 67100 67108 67110 67138 67188 67194 67208
## [4041] 67224 67227 67229 67298 67345 67352 67378 67409 67421 67437
## [4051] 67438 67445 67510 67545 67604 67620 67621 67623 67631 67653
## [4061] 67702 67718 67731 67748 67749 67757 67786 67810 67859 67879
## [4071] 67887 67888 67900 67951 68049 68056 68060 68066 68071 68072
## [4081] 68073 68088 68108 68124 68129 68130 68133 68193 68194 68226
## [4091] 68228 68239 68291 68292 68304 68316 68343 68344 68356 68398
## [4101] 68399 68422 68474 68475 68476 68539 68540 68561 68585 68630
## [4111] 68631 68644 68645 68668 68683 68684 68690 68759 68765 68766
## [4121] 68865 68885 68889 68914 68949 68955 68972 68987 69004 69015
## [4131] 69026 69046 69047 69050 69065 69070 69076 69108 69115 69144
## [4141] 69152 69158 69172 69173 69174 69259 69272 69295 69313 69314
## [4151] 69319 69329 69330 69347 69348 69353 69383 69413 69424 69427
## [4161] 69435 69444 69457 69464 69469 69523 69526 69549 69550 69601
## [4171] 69607 69644 69645 69650 69651 69655 69656 69657 69658 69659
## [4181] 69660 69661 69664 69695 69696 69697 69698 69730 69753 69770
## [4191] 69791 69818 69864 69938 69949 69971 69972 69986 69988 69989
## [4201] 70025 70109 70110 70117 70130 70223 70224 70227 70264 70287
## [4211] 70290 70306 70311 70321 70330 70357 70369 70392 70421 70517
## [4221] 70527 70550 70586 70589 70593 70611 70651 70677 70691 70729
## [4231] 70741 70816 70817 70839 70869 70888 70906 70910 70938 70946
## [4241] 70964 70970 70979 70996 71002 71013 71059 71072 71081 71082
## [4251] 71102 71118 71143 71144 71147 71152 71157 71161 71162 71164
## [4261] 71166 71178 71249 71260 71262 71293 71336 71341 71342 71348
## [4271] 71349 71416 71435 71444 71451 71452 71477 71494 71563 71593
## [4281] 71641 71672 71731 71743 71747 71767 71776 71786 71808 71837
## [4291] 71860 71868 71907 71908 71922 71933 71943 71964 71966 71969
## [4301] 72010 72087 72109 72116 72160 72161 72176 72178 72196 72264
## [4311] 72274 72290 72311 72315 72340 72373 72379 72380 72381 72386
## [4321] 72399 72411 72449 72476 72518 72542 72561 72565 72585 72600
## [4331] 72625 72631 72654 72655 72657 72673 72692 72702 72724 72733
## [4341] 72774 72778 72799 72837 72850 72856 72875 72878 72891 72895
## [4351] 72941 72965 72986 73000 73020 73040 73048 73068 73087 73092
## [4361] 73093 73097 73158 73160 73171 73179 73187 73210 73244 73263
## [4371] 73285 73291 73293 73297 73304 73317 73365 73379 73412 73415
## [4381] 73445 73446 73455 73469 73484 73487 73502 73564 73565 73598
## [4391] 73608 73621 73641 73642 73694 73751 73775 73778 73784 73810
## [4401] 73816 73817 73841 73843 73855 73858 73862 73863 73906 73912
## [4411] 73921 73939 73966 73990 73994 74025 74035 74048 74054 74067
## [4421] 74074 74076 74083 74087 74091 74122 74138 74142 74159 74206
## [4431] 74238 74242 74258 74262 74274 74275 74279 74282 74297 74305
## [4441] 74308 74350 74353 74367 74394 74395 74412 74434 74458 74489
## [4451] 74496 74501 74502 74513 74520 74529 74550 74552 74618 74620
## [4461] 74669 74726 74766 74827 74833 74842 74847 74864 74865 74879
## [4471] 74885 74926 74951 74973 75038 75068 75076 75086 75094 75096
## [4481] 75106 75108 75110 75162 75166 75172 75173 75176 75177 75205
## [4491] 75207 75208 75216 75252 75259 75268 75289 75310 75319 75323
## [4501] 75331 75340 75350 75366 75379 75398 75420 75421 75424 75425
## [4511] 75429 75451 75460 75461 75485 75493 75508 75521 75525 75535
## [4521] 75539 75558 75611 75621 75650 75704 75706 75731 75734 75776
## [4531] 75777 75778 75780 75844 75852 75879 75881 75897 75903 75908
## [4541] 75991 76058 76073 76105 76107 76136 76179 76204 76223 76225
## [4551] 76253 76271 76296 76299 76323 76339 76340 76358 76383 76395
## [4561] 76404 76416 76428 76453 76475 76515 76518 76526 76539 76546
## [4571] 76554 76557 76559 76563 76573 76574 76593 76634 76641 76653
## [4581] 76670 76672 76683 76724 76732 76762 76772 76784 76896 76907
## [4591] 76935 76995 77019 77062 77082 77107 77137 77141 77143 77225
## [4601] 77234 77254 77267 77271 77272 77282 77322 77324 77344 77357
## [4611] 77371 77376 77383 77389 77396 77427 77436 77482 77492 77535
## [4621] 77541 77556 77580 77638 77645 77669 77672 77685 77704 77737
## [4631] 77740 77744 77789 77796 77816 77819 77824 77836 77846 77905
## [4641] 77937 77986 78005 78021 78065 78066 78083 78151 78156 78178
## [4651] 78222 78223 78224 78225 78226 78227 78228 78231 78233 78237
## [4661] 78249 78277 78281 78355 78369 78372 78389 78413 78414 78435
## [4671] 78443 78483 78495 78498 78499 78505 78508 78531 78541 78547
## [4681] 78548 78550 78559 78578 78604 78619 78632 78633 78646 78720
## [4691] 78723 78724 78736 78751 78778 78783 78786 78816 78817 78876
## [4701] 78934 78988 79017 79022 79036 79057 79058 79082 79090 79091
## [4711] 79105 79126 79150 79180 79181 79185 79191 79246 79248 79260
## [4721] 79261 79309 79315 79324 79345 79425 79434 79499 79501 79518
## [4731] 79527 79558 79586 79587 79603 79640 79648 79653 79656 79665
## [4741] 79703 79705 79728 79730 79745 79753 79790 79811 79813 79845
## [4751] 79846 79862 79866 79872 79908 79909 79942 79969 80013 80021
## [4761] 80024 80031 80040 80041 80079 80080 80120 80139 80140 80185
## [4771] 80204 80205 80222 80226 80233 80300 80384 80386 80430 80470
## [4781] 80491 80501 80550 80558 80601 80605 80618 80633 80652 80761
## [4791] 80762 80770 80771 80782 80791 80797 80800 80801 80804 80896
## [4801] 80915 80916 80917 80930 80977 81025 81030 81104 81106 81115
## [4811] 81124 81131 81132 81134 81136 81179 81240 81251 81263 81265
## [4821] 81296 81322 81323 81328 81329 81345 81353 81357 81412 81441
## [4831] 81461 81491 81574 81585 81588 81592 81596 81610 81626 81633
## [4841] 81645 81648 81651 81692 81717 81724 81735 81756 81791 81797
## [4851] 81822 81834 81838 81840 81897 81922 81958 81969 81985 81988
## [4861] 82001 82032 82037 82043 82085 82086 82109 82123 82144 82151
## [4871] 82160 82172 82175 82196 82228 82244 82250 82268 82287 82289
## [4881] 82327 82330 82332 82343 82351 82395 82401 82402 82424 82462
## [4891] 82468 82481 82488 82494 82558 82576 82594 82601 82638 82644
## [4901] 82650 82670 82677 82681 82684 82718 82730 82744 82765 82768
## [4911] 82777 82789 82819 82855 82863 82867 82868 82875 82918 82923
## [4921] 82943 82979 82994 83005 83013 83020 83027 83032 83033 83035
## [4931] 83079 83093 83103 83123 83124 83165 83181 83193 83197 83255
## [4941] 83277 83286 83295 83309 83367 83373 83407 83414 83417 83424
## [4951] 83439 83449 83468 83470 83471 83475 83487 83533 83598 83608
## [4961] 83611 83617 83631 83634 83647 83651 83652 83669 83690 83714
## [4971] 83736 83740 83742 83757 83764 83788 83840 83864 83900 83915
## [4981] 83916 83923 83928 83930 83933 83947 83965 83966 83973 83994
## [4991] 83996 84001 84002 84003 84004 84050 84051 84065 84079 84086
## [5001] 84087 84105 84107 84118 84128 84140 84148 84162 84185 84194
## [5011] 84212 84226 84227 84236 84244 84254 84266 84282 84285 84290
## [5021] 84308 84345 84348 84355 84368 84376 84392 84405 84406 84409
## [5031] 84420 84434 84439 84499 84527 84549 84565 84569 84572 84603
## [5041] 84622 84630 84645 84682 84689 84690 84707 84709 84755 84756
## [5051] 84772 84803 84838 84845 84848 84857 84870 84876 84877 84880
## [5061] 84882 84888 84901 84908 84938 84946 84960 84978 84980 84986
## [5071] 84995 85001 85036 85043 85044 85064 85067 85086 85095 85137
## [5081] 85170 85192 85198 85224 85226 85238 85239 85240 85241 85242
## [5091] 85247 85282 85328 85341 85345 85363 85369 85370 85372 85373
## [5101] 85374 85375 85376 85377 85378 85379 85380 85381 85382 85383
## [5111] 85396 85397 85415 85417 85442 85463 85496 85521 85536 85537
## [5121] 85547 85579 85582 85588 85614 85618 85619 85620 85624 85631
## [5131] 85643 85668 85669 85676 85701 85713 85723 85742 85743 85745
## [5141] 85773 85808 85826 85843 85872 85888 85906 85908 85929 85931
## [5151] 85933 85937 85962 85977 85978 85993 86000 86006 86010 86011
## [5161] 86037 86088 86108 86111 86115 86119 86132 86145 86151 86159
## [5171] 86172 86173 86200 86203 86208 86234 86236 86253 86254 86258
## [5181] 86264 86266 86269 86275 86281 86286 86293 86299 86305 86331
## [5191] 86343 86413 86414 86421 86439 86446 86447 86468 86479 86579
## [5201] 86586 86599 86600 86663 86678 86680 86708 86732 86738 86787
## [5211] 86794 86796 86797 86834 86858 86859 86863 86871 86888 86903
## [5221] 86904 86912 86917 86924 86925 86932 86943 86964 86997 87016
## [5231] 87017 87027 87058 87063 87070 87110 87111 87136 87139 87148
## [5241] 87157 87162 87173 87184 87185 87186 87187 87220 87224 87228
## [5251] 87244 87247 87257 87358 87379 87450 87459 87464 87477 87483
## [5261] 87492 87493 87500 87509 87521 87531 87563 87603 87604 87612
## [5271] 87638 87642 87643 87676 87742 87789 87799 87814 87817 87828
## [5281] 87847 87880 87890 87894 87915 87920 87942 87944 87959 87978
## [5291] 88023 88035 88036 88037 88039 88040 88048 88052 88054 88055
## [5301] 88056 88070 88090 88112 88125 88128 88139 88143 88146 88153
## [5311] 88159 88176 88177 88178 88182 88184 88185 88207 88212 88248
## [5321] 88252 88259 88263 88271 88279 88298 88299 88323 88344 88389
## [5331] 88405 88410 88415 88419 88432 88438 88439 88474 88478 88506
## [5341] 88510 88515 88570 88591 88654 88682 88694 88714 88721 88723
## [5351] 88724 88725 88752 88756 88757 88762 88781 88796 88820 88853
## [5361] 88864 88869 88874 88887 88904 88930 88931 88932 88952 88967
## [5371] 89022 89023 89082 89087 89092 89124 89127 89157 89159 89164
## [5381] 89173 89181 89182 89192 89214 89215 89244 89245 89273 89275
## [5391] 89289 89302 89327 89339 89343 89347 89388 89423 89427 89438
## [5401] 89455 89458 89460 89496 89500 89515 89536 89540 89554 89556
## [5411] 89560 89561 89569 89577 89628 89642 89643 89688 89721 89738
## [5421] 89746 89780 89789 89801 89802 89813 89853 89864 89872 89873
## [5431] 89882 89887 89908 89925 89938 89973 90048 90089 90096 90120
## [5441] 90131 90135 90139 90142 90153 90155 90245 90266 90269 90295
## [5451] 90314 90348 90357 90370 90400 90418 90434 90443 90446 90468
## [5461] 90485 90510 90514 90522 90534 90543 90553 90587 90612 90619
## [5471] 90629 90646 90747 90759 90798 90880 90887 90897 90898 90921
## [5481] 90937 90938 90944 90972 90975 90978 90988 91005 91023 91045
## [5491] 91049 91052 91054 91057 91077 91094 91098 91108 91123 91149
## [5501] 91150 91154 91167 91168 91184 91210 91238 91251 91254 91255
## [5511] 91269 91307 91312 91398 91438 91439 91453 91552 91564 91604
## [5521] 91627 91635 91645 91654 91666 91668 91683 91686 91693 91696
## [5531] 91697 91768 91773 91836 91853 91868 91899 91926 91930 91933
## [5541] 91965 91969 91985 92055 92073 92127 92130 92138 92142 92152
## [5551] 92160 92161 92196 92207 92210 92211 92255 92280 92367 92406
## [5561] 92407 92431 92432 92454 92459 92472 92480 92491 92494 92500
## [5571] 92504 92528 92534 92535 92557 92560 92607 92612 92613 92617
## [5581] 92624 92636 92637 92666 92700 92705 92717 92723 92735 92753
## [5591] 92755 92782 92784 92807 92810 92822 92834 92835 92836 92837
## [5601] 92838 92889 92939 92944 92972 92975 92979 92988 92992 93011
## [5611] 93057 93072 93087 93095 93115 93121 93151 93155 93160 93192
## [5621] 93207 93250 93262 93263 93277 93291 93312 93313 93336 93340
## [5631] 93398 93483 93494 93516 93540 93546 93548 93550 93554 93613
## [5641] 93635 93670 93710 93785 93804 93811 93847 93848 93873 93880
## [5651] 93882 93904 93914 93919 93920 93925 93928 93978 93983 94030
## [5661] 94038 94064 94068 94086 94130 94149 94166 94170 94175 94176
## [5671] 94191 94197 94201 94251 94280 94332 94396 94398 94429 94451
## [5681] 94515 94548 94549 94558 94584 94588 94611 94635 94639 94653
## [5691] 94669 94676 94677 94678 94702 94724 94725 94772 94808 94830
## [5701] 94857 94862 94934 95003 95015 95053 95054 95055 95084 95097
## [5711] 95107 95139 95152 95155 95215 95281 95287 95303 95341 95367
## [5721] 95382 95383 95414 95417 95431 95475 95538 95583 95586 95598
## [5731] 95644 95651 95658 95723 95740 95755 95769 95771 95789 95800
## [5741] 95804 95807 95849 95863 95873 95876 95877 95884 95888 95898
## [5751] 95926 95946 95953 95985 95987 95995 96004 96017 96039 96068
## [5761] 96087 96109 96138 96156 96165 96178 96186 96190 96210 96213
## [5771] 96223 96270 96271 96272 96283 96292 96310 96335 96350 96365
## [5781] 96367 96379 96414 96460 96468 96486 96489 96510 96514 96541
## [5791] 96563 96592 96631 96637 96660 96672 96731 96765 96791 96795
## [5801] 96798 96800 96807 96812 96856 96857 96888 96910 96911 96927
## [5811] 96943 96985 97001 97028 97037 97076 97077 97091 97094 97096
## [5821] 97105 97142 97164 97165 97167 97193 97195 97201 97206 97219
## [5831] 97227 97228 97245 97294 97307 97322 97379 97386 97390 97403
## [5841] 97405 97406 97423 97424 97426 97431 97459 97497 97529 97570
## [5851] 97592 97596 97602 97613 97655 97657 97676 97686 97734 97763
## [5861] 97769 97786 97810 97814 97815 97824 97845 97900 97918 97926
## [5871] 97931 97936 97937 97943 97959 97971 97992 98046 98049 98055
## [5881] 98063 98067 98068 98090 98093 98098 98100 98107 98116 98125
## [5891] 98132 98140 98151 98153 98173 98181 98193 98194 98210 98213
## [5901] 98224 98241 98242 98258 98271 98293 98316 98359 98376 98383
## [5911] 98398 98419 98424 98425 98426 98427 98428 98429 98430 98438
## [5921] 98439 98445 98463 98484 98511 98512 98581 98669 98691 98710
## [5931] 98714 98716 98825 98844 98870 98902 98921 98952 98998 99009
## [5941] 99020 99036 99068 99072 99073 99081 99099 99115 99120 99123
## [5951] 99135 99140 99141 99154 99164 99173 99192 99202 99214 99216
## [5961] 99219 99224 99225 99233 99234 99235 99236 99237 99245 99250
## [5971] 99257 99274 99284 99298 99301 99302 99320 99324 99341 99368
## [5981] 99392 99394 99406 99407 99412 99426 99427 99431 99434 99443
## [5991] 99445 99450 99458 99536 99543 99555 99569 99601 99610 99611
## [6001] 99633 99638 99646 99647 99648 99649 99671 99675 99703 99704
## [6011] 99709 99717 99737 99771 99781 99786 99799 99818 99820 99831
## [6021] 99878 99879 99883 99905 99911 99914 99927 99966 99995 100000
## [6031] 100022 100027 100028 100032 100076 100082 100092 100098 100100 100108
## [6041] 100113 100115 100139 100140 100149 100160 100165 100177 100203 100211
## [6051] 100215 100216 100234 100235 100236 100238 100239 100240 100244 100262
## [6061] 100264 100336 100382 100397 100422 100449 100454 100525 100533 100547
## [6071] 100549 100561 100599 100606 100617 100632 100647 100653 100684 100687
## [6081] 100689 100695 100710 100712 100740 100745 100747 100768 100793 100853
## [6091] 100860 100862 100874 100875 100887 100893 100906 100919 100936 100952
## [6101] 100954 100964 100989 101021 101024 101055 101060 101096 101098 101142
## [6111] 101144 101165 101174 101185 101193 101206 101223 101225 101228 101233
## [6121] 101236 101250 101258 101307 101326 101458 101459 101490 101501 101526
## [6131] 101528 101565 101586 101590 101638 101663 101670 101675 101684 101697
## [6141] 101719 101740 101793 101799 101804 101816 101834 101856 101863 101869
## [6151] 101870 101877 101910 101944 101972 101975 101982 101986 101996 102002
## [6161] 102023 102057 102080 102098 102115 102119 102125 102126 102164 102166
## [6171] 102205 102247 102265 102269 102286 102292 102298 102308 102315 102341
## [6181] 102347 102362 102454 102462 102468 102474 102478 102494 102495 102514
## [6191] 102546 102547 102557 102594 102595 102640 102672 102685 102700 102725
## [6201] 102780 102790 102809 102822 102827 102857 102861 102887 102890 102897
## [6211] 102929 102930 102931 102932 102933 102949 102961 102997 103003 103022
## [6221] 103078 103082 103098 103123 103133 103136 103163 103182 103189 103202
## [6231] 103208 103209 103214 103215 103247 103248 103267 103310 103334 103336
## [6241] 103339 103340 103374 103390 103395 103415 103418 103423 103461 103482
## [6251] 103492 103496 103505 103509 103584 103587 103590 103591 103596 103597
## [6261] 103604 103608 103615 103670 103671 103692 103712 103725 103785 103805
## [6271] 103807 103843 103854 103864 103870 103876 103884 103911 103991 103997
## [6281] 104019 104063 104064 104070 104076 104109 104114 104128 104131 104158
## [6291] 104166 104169 104172 104196 104208 104211 104239 104241 104266 104336
## [6301] 104337 104341 104375 104381 104416 104417 104435 104439 104454 104479
## [6311] 104483 104498 104512 104529 104543 104550 104555 104567 104587 104635
## [6321] 104644 104645 104646 104647 104669 104707 104725 104739 104741 104763
## [6331] 104767 104769 104780 104795 104802 104804 104806 104807 104819 104857
## [6341] 104858 104867 104878 104892 104901 104915 104959 104962 104991 105048
## [6351] 105053 105109 105132 105133 105136 105144 105147 105159 105167 105168
## [6361] 105183 105184 105216 105223 105242 105246 105255 105275 105276 105281
## [6371] 105301 105312 105370 105427 105428 105452 105508 105513 105521 105545
## [6381] 105546 105549 105572 105578 105583 105584 105626 105630 105633 105651
## [6391] 105668 105725 105726 105739 105741 105742 105780 105798 105800 105807
## [6401] 105874 105898 105899 105900 105904 105907 105924 105937 105939 105960
## [6411] 105965 105972 105973 105974 105983 106042 106071 106092 106101 106124
## [6421] 106127 106128 106156 106162 106168 106170 106184 106211 106212 106377
## [6431] 106382 106397 106402 106408 106431 106459 106473 106497 106498 106499
## [6441] 106515 106556 106566 106590 106615 106645 106654 106672 106675 106683
## [6451] 106685 106689 106707 106715 106741 106744 106804 106807 106896 106971
## [6461] 106991 106996 107004 107023 107036 107044 107109 107114 107126 107161
## [6471] 107189 107193 107194 107195 107196 107200 107206 107224 107236 107241
## [6481] 107249 107270 107275 107288 107299 107316 107331 107332 107340 107366
## [6491] 107389 107396 107397 107404 107419 107447 107452 107469 107498 107507
## [6501] 107515 107521 107530 107532 107555 107581 107600 107614 107624 107655
## [6511] 107661 107682 107692 107721 107755 107767 107775 107778 107791 107801
## [6521] 107808 107812 107818 107839 107840 107850 107859 107863 107897 107899
## [6531] 107906 107909 107919 107926 107950 107951 107952 107954 107955 107956
## [6541] 107958 107960 107961 107972 107973 107986 107989 108031 108043 108063
## [6551] 108077 108107 108115 108117 108172 108206 108207 108304 108322 108328
## [6561] 108354 108356 108358 108384 108387 108389 108390 108391 108392 108393
## [6571] 108394 108434 108435 108443 108453 108476 108495 108550 108566 108579
## [6581] 108621 108623 108625 108629 108631 108645 108697 108721 108765 108815
## [6591] 108854 108872 108898 108901 108911 108926 108941 108942 108950 108969
## [6601] 108970 108987 109002 109023 109047 109048 109058 109059 109102 109105
## [6611] 109164 109168 109186 109209 109214 109217 109242 109244 109250 109252
## [6621] 109253 109257 109275 109295 109297 109342 109376 109383 109408 109409
## [6631] 109416 109417 109449 109460 109467 109489 109493 109497 109539 109557
## [6641] 109605 109637 109638 109639 109684 109730 109743 109764 109768 109785
## [6651] 109791 109792 109793 109799 109814 109876 109977 109978 109985 109994
## [6661] 110020 110031 110057 110063 110088 110115 110120 110127 110150 110157
## [6671] 110162 110163 110211 110213 110220 110225 110235 110242 110249 110259
## [6681] 110279 110280 110286 110303 110304 110331 110344 110388 110390 110396
## [6691] 110430 110485 110500 110511 110553 110567 110577 110598 110605 110612
## [6701] 110615 110644 110671 110672 110681 110714 110746 110756 110782 110788
## [6711] 110798 110825 110842 110854 110855 110882 110883 110891 110894 110919
## [6721] 110921 110926 110945 110986 111042 111065 111074 111083 111089 111148
## [6731] 111157 111159 111172 111182 111188 111189 111207 111221 111291 111301
## [6741] 111317 111351 111358 111364 111370 111386 111394 111397 111400 111402
## [6751] 111431 111469 111472 111473 111474 111475 111478 111479 111484 111488
## [6761] 111579 111591 111615 111616 111617 111618 111619 111629 111667 111679
## [6771] 111680 111681 111707 111721 111727 111757 111767 111782 111825 111843
## [6781] 111850 111885 111903 111931 111933 111955 111956 111979 111980 111981
## [6791] 111983 112006 112008 112016 112017 112045 112087 112088 112090 112124
## [6801] 112139 112173 112175 112176 112183 112184 112185 112186 112203 112209
## [6811] 112210 112232 112261 112280 112285 112289 112323 112331 112335 112350
## [6821] 112374 112376 112381 112427 112428 112430 112445 112485 112502 112511
## [6831] 112562 112571 112593 112602 112605 112616 112626 112657 112684 112685
## [6841] 112721 112747 112755 112790 112816 112818 112865 112873 112875 112886
## [6851] 112931 112940 112960 112962 112980 113000 113081 113089 113157 113164
## [6861] 113180 113202 113207 113210 113218 113232 113263 113285 113287 113322
## [6871] 113338 113339 113411 113414 113445 113457 113462 113488 113499 113527
## [6881] 113534 113558 113626 113641 113642 113657 113658 113667 113683 113690
## [6891] 113704 113753 113766 113772 113798 113812 113817 113851 113852 113855
## [6901] 113884 113907 113918 113919 113942 114031 114051 114090 114169 114173
## [6911] 114174 114194 114195 114206 114212 114228 114255 114289 114291 114345
## [6921] 114350 114387 114389 114419 114438 114439 114458 114461 114464 114471
## [6931] 114475 114486 114531 114548 114587 114624 114643 114646 114660 114669
## [6941] 114682 114683 114699 114725 114743 114786 114789 114848 114853 114861
## [6951] 114862 114888 114892 114911 114923 114935 114940 114944 114965 114972
## [6961] 114976 115002 115006 115009 115014 115043 115044 115084 115100 115125
## [6971] 115158 115164 115168 115218 115224 115225 115229 115238 115242 115250
## [6981] 115265 115316 115364 115368 115395 115397 115412 115437 115451 115462
## [6991] 115466 115476 115487 115502 115507 115515 115527 115557 115570 115585
## [7001] 115596 115607 115608 115624 115627 115655 115661 115671 115709 115753
## [7011] 115761 115790 115791 115813 115814 115897 115900 115929 115935 115955
## [7021] 115957 115959 115971 116020 116046 116052 116068 116103 116125 116139
## [7031] 116144 116154 116205 116213 116243 116253 116262 116266 116268 116274
## [7041] 116292 116296 116319 116335 116336 116354 116370 116384 116391 116392
## [7051] 116399 116402 116410 116440 116468 116525 116530 116531 116549 116555
## [7061] 116557 116559 116560 116563 116574 116575 116578 116594 116610 116612
## [7071] 116631 116640 116661 116675 116700 116708 116736 116744 116752 116779
## [7081] 116818 116823 116827 116834 116848 116891 116949 116950 116971 117001
## [7091] 117025 117026 117045 117046 117047 117075 117076 117150 117174 117179
## [7101] 117180 117207 117215 117229 117230 117231 117241 117274 117276 117293
## [7111] 117294 117310 117375 117417 117433 117449 117462 117493 117514 117538
## [7121] 117543 117556 117565 117571 117575 117576 117577 117647 117648 117657
## [7131] 117669 117672 117721 117806 117831 117835 117861 117862 117864 117890
## [7141] 117894 117902 117921 117927 117965 117966 117968 117980 117992 117999
## [7151] 118020 118025 118029 118036 118042 118057 118061 118076 118078 118079
## [7161] 118080 118081 118083 118084 118086 118087 118088 118089 118091 118092
## [7171] 118097 118098 118099 118100 118114 118142 118162 118169 118224 118227
## [7181] 118245 118259 118280 118348 118352 118356 118358 118388 118403 118418
## [7191] 118424 118469 118489 118516 118547 118582 118621 118624 118625 118631
## [7201] 118640 118661 118771 118788 118800 118853 118873 118884 118894 118931
## [7211] 118948 119033 119046 119081 119094 119113 119175 119182 119183 119187
## [7221] 119189 119194 119195 119205 119233 119234 119244 119256 119271 119273
## [7231] 119275 119277 119317 119318 119319 119331 119370 119371 119391 119423
## [7241] 119431 119435 119437 119459 119487 119495 119498 119520 119531 119543
## [7251] 119556 119579 119582 119583 119612 119613 119614 119622 119640 119659
## [7261] 119660 119684 119702 119703 119715 119754 119763 119781 119791 119829
## [7271] 119954 119976 119987 120009 120016 120030 120032 120037 120042 120046
## [7281] 120047 120059 120064 120150 120153 120204 120227 120228 120247 120255
## [7291] 120274 120290 120345 120361 120385 120398 120403 120414 120432 120451
## [7301] 120453 120471 120476 120505 120506 120527 120532 120540 120551 120612
## [7311] 120648 120649 120657 120666 120668 120673 120679 120695 120726 120747
## [7321] 120753 120755 120765 120805 120825 120865 120867 120888 120893 120901
## [7331] 120903 120914 120933 120992 121019 121038 121051 121052 121057 121078
## [7341] 121112 121120 121132 121136 121165 121168 121182 121196 121230 121241
## [7351] 121296 121303 121304 121352 121365 121397 121400 121413 121414 121425
## [7361] 121428 121431 121453 121480 121502 121524 121568 121570 121571 121594
## [7371] 121608 121672 121698 121707 121748 121751 121787 121788 121808 121815
## [7381] 121817 121821 121841 121860 121870 121879 121896 121972 121999 122041
## [7391] 122046 122074 122177 122178 122221 122265 122283 122327 122405 122406
## [7401] 122433 122437 122449 122467 122498 122525 122558 122591 122595 122596
## [7411] 122605 122623 122631 122639 122665 122672 122692 122732 122773 122776
## [7421] 122783 122790 122793 122794 122809 122829 122842 122870 122877 122888
## [7431] 122889 122890 122946 122948 122961 122965 122975 122981 122983 122995
## [7441] 123003 123007 123008 123024 123053 123056 123058 123080 123091 123092
## [7451] 123101 123141 123155 123156 123157 123158 123159 123161 123185 123211
## [7461] 123213 123294 123296 123401 123435 123499 123500 123506 123511 123533
## [7471] 123572 123592 123598 123602 123640 123647 123697 123701 123727 123743
## [7481] 123745 123765 123782 123798 123847 123848 123860 123863 123869 123887
## [7491] 123917 123927 123974 124056 124061 124088 124140 124155 124198 124204
## [7501] 124215 124224 124258 124259 124302 124304 124315 124338 124344 124394
## [7511] 124407 124414 124445 124451 124486 124508 124553 124568 124569 124572
## [7521] 124573 124607 124617 124618 124620 124622 124637 124651 124657 124660
## [7531] 124676 124696 124725 124728 124751 124801 124832 124842 124843 124844
## [7541] 124855 124883 124956 124957 124958 124964 125004 125045 125089 125096
## [7551] 125121 125130 125145 125146 125162 125163 125165 125180 125201 125202
## [7561] 125217 125226 125234 125246 125255 125261 125262 125293 125364 125377
## [7571] 125396 125421 125431 125436 125456 125457 125462 125472 125482 125501
## [7581] 125502 125504 125523 125524 125535 125567 125579 125600 125602 125612
## [7591] 125644 125645 125650 125652 125655 125660 125670 125694 125708 125719
## [7601] 125743 125769 125791 125855 125867 125874 125887 125900 125905 125906
## [7611] 125912 125953 125964 125981 125982 126000 126001 126017 126023 126051
## [7621] 126071 126073 126080 126087 126091 126092 126135 126141 126142 126157
## [7631] 126162 126163 126192 126249 126252 126359 126377 126379 126383 126384
## [7641] 126386 126423 126428 126431 126440 126441 126452 126506 126508 126520
## [7651] 126548 126553 126581 126608 126627 126628 126634 126643 126644 126647
## [7661] 126652 126657 126679 126721 126739 126752 126777 126815 126819 126827
## [7671] 126836 126847 126855 126866 126882 126897 126913 126919 126922 126936
## [7681] 126937 126973 127002 127055 127093 127103 127124 127186 127254 127281
## [7691] 127299 127316 127335 127371 127400 127405 127445 127477 127521 127561
## [7701] 127573 127584 127592 127593 127594 127604 127643 127658 127659 127700
## [7711] 127740 127770 127773 127777 127789 127806 127830 127856 127876 127877
## [7721] 127878 127960 127970 127979 127997 127998 127999 128000 128013 128016
## [7731] 128041 128049 128086 128093 128103 128113 128129 128139 128144 128173
## [7741] 128179 128181 128205 128217 128218 128246 128250 128254 128278 128281
## [7751] 128283 128289 128310 128332 128356 128357 128358 128359 128363 128378
## [7761] 128379 128384 128390 128399 128400 128461 128465 128528 128532 128540
## [7771] 128561 128572 128604 128641 128646 128665 128677 128697 128698 128732
## [7781] 128784 128792 128793 128797 128809 128813 128824 128856 128886 128903
## [7791] 128904 128908 128909 128959 128968
# Lọc ra toàn bộ các dòng có Amount bị thiếu
na_amount_rows <- Amazon.Sale.Report[is.na(Amazon.Sale.Report$Amount), ]
View(na_amount_rows)
mean(is.na(Amazon.Sale.Report$Amount)) * 100
## [1] 6.043807
# Cách xử lý giá trị NA
mean_amount <- mean(Amazon.Sale.Report$Amount, na.rm = TRUE)
Amazon.Sale.Report$Amount[is.na(Amazon.Sale.Report$Amount)] <- mean_amount
# BIẾN STATUS
# Kiểm tra kiểu dữ liệu
str(Amazon.Sale.Report$Status)
## chr [1:128975] "Cancelled" "Shipped - Delivered to Buyer" "Shipped" ...
# Kiểm tra giá trị khác nhau trong biến
unique(Amazon.Sale.Report$Status)
## [1] "Cancelled" "Shipped - Delivered to Buyer"
## [3] "Shipped" "Shipped - Returned to Seller"
## [5] "Shipped - Rejected by Buyer" "Shipped - Lost in Transit"
## [7] "Shipped - Out for Delivery" "Shipped - Returning to Seller"
## [9] "Shipped - Picked Up" "Pending"
## [11] "Pending - Waiting for Pick Up" "Shipped - Damaged"
## [13] "Shipping"
length(unique(Amazon.Sale.Report$Status))
## [1] 13
table(Amazon.Sale.Report$Status)
##
## Cancelled Pending
## 18332 658
## Pending - Waiting for Pick Up Shipped
## 281 77804
## Shipped - Damaged Shipped - Delivered to Buyer
## 1 28769
## Shipped - Lost in Transit Shipped - Out for Delivery
## 5 35
## Shipped - Picked Up Shipped - Rejected by Buyer
## 973 11
## Shipped - Returned to Seller Shipped - Returning to Seller
## 1953 145
## Shipping
## 8
library(dplyr)
# Chuẩn hóa lại viết hoa chữ cái đầu cho đẹp
Amazon.Sale.Report <- Amazon.Sale.Report %>%
mutate(Status = tools::toTitleCase(Status))
# Kiểm tra lại các giá trị khác nhau
unique(Amazon.Sale.Report$Status)
## [1] "Cancelled" "Shipped - Delivered to Buyer"
## [3] "Shipped" "Shipped - Returned to Seller"
## [5] "Shipped - Rejected by Buyer" "Shipped - Lost in Transit"
## [7] "Shipped - Out for Delivery" "Shipped - Returning to Seller"
## [9] "Shipped - Picked Up" "Pending"
## [11] "Pending - Waiting for Pick Up" "Shipped - Damaged"
## [13] "Shipping"
sum(is.na(Amazon.Sale.Report$Status) | Amazon.Sale.Report$Status == "")
## [1] 0
Amazon.Sale.Report$Status[is.na(Amazon.Sale.Report$Status) | Amazon.Sale.Report$Status == ""] <- "Unknown"
#BIẾN FULFILMENT
str(Amazon.Sale.Report$Fulfilment)
## chr [1:128975] "Merchant" "Merchant" "Amazon" "Merchant" "Amazon" "Amazon" ...
unique(Amazon.Sale.Report$Fulfilment)
## [1] "Merchant" "Amazon"
length(unique(Amazon.Sale.Report$Fulfilment))
## [1] 2
table(Amazon.Sale.Report$Fulfilment)
##
## Amazon Merchant
## 89698 39277
sum(is.na(Amazon.Sale.Report$Fulfilment) | Amazon.Sale.Report$Fulfilment == "")
## [1] 0
#Thống kê tần suất và tỷ lệ phần trăm
fulfilment_summary <- Amazon.Sale.Report %>%
count(Fulfilment, sort = TRUE) %>%
mutate(Percent = round(100 * n / sum(n), 2))
library(dplyr)
# Phân tổ theo status, amount
status_summary <- Amazon.Sale.Report %>%
group_by(Status) %>%
summarise(
Avg_Amount = mean(Amount, na.rm = TRUE),
Total_Amount = sum(Amount, na.rm = TRUE),
Orders = n()
)
status_summary
# Phân tổ theo fulfilment, amount
fulfilment_summary <- Amazon.Sale.Report %>%
group_by(Fulfilment) %>%
summarise(
Avg_Amount = mean(Amount, na.rm = TRUE),
Total_Revenue = sum(Amount, na.rm = TRUE),
Orders = n()
)
fulfilment_summary
# Phân tổ theo status, fulfilment, amount
status_fulfilment_tab <- Amazon.Sale.Report %>%
group_by(Status, Fulfilment) %>%
summarise(
Total_Orders = n(),
Total_Revenue = sum(Amount, na.rm = TRUE),
Avg_Amount = mean(Amount, na.rm = TRUE)
) %>%
arrange(Status, desc(Total_Revenue))
## `summarise()` has grouped output by 'Status'. You can override using the
## `.groups` argument.
status_fulfilment_tab