“K-means_Clustering-Supermercado”
Dana Perez - A00227041
9/20/2022
Herrmienta “El Generador de Valor de Datos”
Paso 1. Definir el área del negocio que buscamos impactar o mejorar y su KPI
En este caso se busca agrupar a los clientes conforme a dos variables: frecuencia de visita y el total que se gasta cada cliente. Con esto se busca mejorar las ventas atacando a cada segmento con una técnica diferente. KPI: Compras por Customer ID
Paso 2. Seleccionar plantilla(-s) para crear valor a partir de los datos de los clientes.
Visión / Segmentación / Personalización / Contextualización
Paso 3. Generar ideas o conceptos específicos.
¿Cuántos segmentos se generan? ¿Qué tipo de clientes se tiene en base a los datos? ¿Cómo idear estrategias para aumentar su consumo o mantener su lealtad hacia la empresa?
Paso 4. Reunir los datos requeridos.
Customer ID, compras por Customer ID, número de ticket, visitas.
Importar base de datos
#file.choose()
bd <- read.csv("/Users/dannaperez/Desktop/R/bases de datos/ventas_bien.csv")
summary(bd)## BillNo Itemname Quantity Date
## Length:522064 Length:522064 Min. :-9600.00 Length:522064
## Class :character Class :character 1st Qu.: 1.00 Class :character
## Mode :character Mode :character Median : 3.00 Mode :character
## Mean : 10.09
## 3rd Qu.: 10.00
## Max. :80995.00
##
## Hour Price CustomerID Country
## Length:522064 Min. :-11062.060 Min. :12346 Length:522064
## Class :character 1st Qu.: 1.250 1st Qu.:13950 Class :character
## Mode :character Median : 2.080 Median :15265 Mode :character
## Mean : 3.827 Mean :15317
## 3rd Qu.: 4.130 3rd Qu.:16837
## Max. : 13541.330 Max. :18287
## NA's :134041library(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, unionAgregar total
bd$total <- bd$Price * bd$Quantity
str(bd)## 'data.frame': 522064 obs. of 9 variables:
## $ BillNo : chr "536365" "536365" "536365" "536365" ...
## $ Itemname : chr "WHITE HANGING HEART T-LIGHT HOLDER" "WHITE METAL LANTERN" "CREAM CUPID HEARTS COAT HANGER" "KNITTED UNION FLAG HOT WATER BOTTLE" ...
## $ Quantity : int 6 6 8 6 6 2 6 6 6 32 ...
## $ Date : chr "12/01/2010" "12/01/2010" "12/01/2010" "12/01/2010" ...
## $ Hour : chr "08:26:00" "08:26:00" "08:26:00" "08:26:00" ...
## $ Price : num 2.55 3.39 2.75 3.39 3.39 7.65 4.25 1.85 1.85 1.69 ...
## $ CustomerID: int 17850 17850 17850 17850 17850 17850 17850 17850 17850 13047 ...
## $ Country : chr "United Kingdom" "United Kingdom" "United Kingdom" "United Kingdom" ...
## $ total : num 15.3 20.3 22 20.3 20.3 ...Obtener el total por ticket, agregando el cliente
bd1 <- bd
bd1 <- aggregate(total ~ CustomerID + BillNo, data = bd1, sum)Obtener el ticket promedio por cliente
bd2 <- bd1
bd2 <- aggregate(total ~ CustomerID, data = bd1, mean)Obtener visitas al supermercado por cliente
bd3 <- bd1
bd3 <- group_by(bd1,CustomerID) %>% summarise (Visitas = n_distinct(BillNo))Juntar base de datos
bd4 <- merge(bd2,bd3,by="CustomerID")Exportar csv
write.csv(bd4,"datos_clientes.csv", row.names = FALSE)Importar la base de datos
#file.choose()
bd5 <- read.csv("/Users/dannaperez/Desktop/R/bases de datos/datos_clientes.csv")
summary(bd5)## CustomerID total Visitas
## Min. :12346 Min. : 0.0 Min. : 1.000
## 1st Qu.:13831 1st Qu.: 178.3 1st Qu.: 1.000
## Median :15321 Median : 292.0 Median : 2.000
## Mean :15316 Mean : 415.5 Mean : 4.227
## 3rd Qu.:16790 3rd Qu.: 426.6 3rd Qu.: 5.000
## Max. :18287 Max. :84236.2 Max. :210.000Agregar le Customer ID como nombre de los renglones
bd6 <- bd5
rownames(bd6) <- bd6$CustomerID Eliminar la columna de customer id
bd7 <- bd6
bd7 <- subset(bd7, select = -c (CustomerID ))Revisar presencia de datos anormales
summary(bd7)## total Visitas
## Min. : 0.0 Min. : 1.000
## 1st Qu.: 178.3 1st Qu.: 1.000
## Median : 292.0 Median : 2.000
## Mean : 415.5 Mean : 4.227
## 3rd Qu.: 426.6 3rd Qu.: 5.000
## Max. :84236.2 Max. :210.000plot(bd7$total,bd7$Visitas)
Los datos fuera de lo normal están fuera de los siguientes límites:
límite inferior = Q1 - 1.5IQR
límite superior = Q3 + 1.5IQR
Q1 : cuartil 1, Q3 : cuartil 3, IQR : Rango intercuartil = Q3 - Q1
Calcular el límite superior del total
iqr_total <- IQR(bd7$total)
limite_superior_total <- 426.63 + 1.5*iqr_total
limite_superior_total## [1] 799.185Conservar solo los tickets promedios menores a 800
bd8 <- bd7
bd8 <- bd8[bd8$total < 800, ]
summary(bd8)## total Visitas
## Min. : 0.0 Min. : 1.000
## 1st Qu.:172.8 1st Qu.: 1.000
## Median :272.2 Median : 2.000
## Mean :298.1 Mean : 4.125
## 3rd Qu.:390.2 3rd Qu.: 5.000
## Max. :799.6 Max. :210.000Calcular el límite superior de las visitas
iqr_visitas <- IQR(bd7$Visitas)
limite_superior_visitas <- 5 + 1.5*iqr_visitas
limite_superior_visitas## [1] 11Conservar solo los tickets promedios menores a 12
bd9 <- bd8
bd9 <- bd9[bd9$Visitas < 12, ]
summary(bd9)## total Visitas
## Min. : 0.0 Min. : 1.00
## 1st Qu.:168.6 1st Qu.: 1.00
## Median :267.1 Median : 2.00
## Mean :293.9 Mean : 2.97
## 3rd Qu.:384.7 3rd Qu.: 4.00
## Max. :799.6 Max. :11.00plot(bd9$total,bd9$Visitas)
K-means clustering
Paso 1. Normalizar variables
bd10 <- bd9
bd10 <- as.data.frame(scale(bd10))
plot(bd10$total, bd10$Visitas)
Paso2. k- means clustering
segmentos <- kmeans(bd10, 3)
segmentos## K-means clustering with 3 clusters of sizes 1009, 2082, 679
##
## Cluster means:
## total Visitas
## 1 1.1988418 -0.2804572
## 2 -0.6184167 -0.4396299
## 3 0.1147455 1.7647875
##
## Clustering vector:
## 12347 12350 12352 12353 12355 12358 12361 12362 12363 12364 12370 12373 12374
## 3 2 3 2 1 1 2 3 2 2 2 1 1
## 12379 12380 12381 12383 12384 12386 12388 12390 12393 12394 12399 12401 12402
## 1 1 3 3 2 2 3 1 1 1 2 2 2
## 12407 12408 12410 12413 12414 12417 12418 12421 12422 12423 12425 12426 12427
## 3 1 1 2 2 3 1 2 2 3 1 1 2
## 12429 12430 12434 12436 12441 12442 12445 12447 12448 12450 12452 12453 12455
## 1 2 1 1 2 2 2 1 1 2 2 1 2
## 12457 12458 12461 12462 12463 12464 12465 12468 12473 12475 12476 12478 12479
## 3 1 1 1 1 3 1 1 1 1 3 1 1
## 12481 12483 12484 12488 12489 12490 12491 12492 12493 12494 12498 12500 12502
## 3 3 1 1 2 3 1 2 2 3 2 3 1
## 12504 12506 12507 12508 12509 12510 12512 12513 12515 12516 12517 12518 12519
## 2 2 1 2 2 1 2 1 1 1 1 3 2
## 12520 12521 12522 12523 12524 12526 12527 12528 12530 12531 12532 12535 12538
## 1 1 2 3 3 1 2 3 1 2 1 1 1
## 12541 12544 12545 12546 12547 12548 12551 12552 12553 12556 12558 12559 12560
## 2 1 1 1 2 2 2 2 3 2 2 2 1
## 12561 12562 12564 12565 12566 12571 12572 12573 12574 12576 12577 12579 12580
## 2 3 1 2 1 2 1 2 2 3 2 1 1
## 12581 12584 12586 12589 12591 12592 12593 12594 12596 12598 12599 12600 12601
## 2 3 2 2 1 2 2 3 2 3 3 3 2
## 12602 12603 12604 12609 12610 12612 12613 12614 12615 12616 12617 12618 12619
## 2 1 2 1 3 1 1 2 1 1 1 2 3
## 12620 12622 12623 12624 12626 12627 12628 12633 12637 12638 12639 12640 12641
## 1 2 2 2 3 3 2 1 3 1 1 1 2
## 12642 12643 12644 12645 12646 12648 12649 12650 12651 12654 12657 12658 12659
## 1 3 1 1 1 2 2 2 2 2 1 1 2
## 12660 12662 12665 12670 12672 12673 12674 12676 12679 12680 12684 12685 12686
## 2 3 2 1 2 2 1 3 2 2 3 3 2
## 12689 12690 12691 12693 12694 12695 12697 12701 12702 12703 12705 12707 12708
## 1 1 3 2 1 2 2 1 2 2 3 1 3
## 12710 12715 12716 12717 12718 12719 12721 12722 12723 12724 12725 12726 12727
## 1 1 1 1 2 2 3 2 2 2 1 3 3
## 12728 12729 12732 12733 12734 12735 12736 12738 12739 12740 12743 12747 12750
## 2 1 2 1 2 1 2 2 1 1 2 3 2
## 12756 12759 12763 12775 12778 12779 12782 12783 12784 12785 12787 12789 12790
## 2 1 2 3 3 3 1 3 2 2 2 2 2
## 12791 12792 12793 12794 12795 12797 12802 12808 12809 12811 12812 12814 12815
## 2 1 2 1 1 2 1 2 1 2 2 2 1
## 12816 12817 12820 12821 12822 12823 12824 12826 12827 12828 12829 12831 12832
## 2 2 2 2 1 3 1 3 2 3 2 2 2
## 12833 12834 12836 12837 12838 12840 12842 12843 12844 12845 12849 12851 12852
## 1 2 1 2 1 1 1 3 2 2 1 2 2
## 12853 12854 12855 12856 12857 12863 12864 12865 12866 12867 12868 12871 12872
## 3 1 2 3 1 1 2 1 1 3 3 2 2
## 12873 12875 12878 12879 12881 12882 12883 12884 12885 12886 12888 12890 12891
## 1 2 1 2 2 1 2 2 1 1 2 1 2
## 12893 12895 12897 12902 12904 12906 12908 12909 12910 12912 12913 12915 12916
## 2 2 2 2 2 1 1 1 3 3 1 2 1
## 12917 12919 12920 12922 12923 12924 12925 12928 12929 12930 12933 12935 12936
## 1 3 2 1 2 2 1 3 2 2 2 3 2
## 12937 12938 12940 12942 12944 12945 12947 12948 12949 12950 12951 12952 12953
## 1 2 1 2 2 1 3 3 3 1 3 1 2
## 12955 12956 12957 12962 12963 12965 12966 12968 12970 12974 12976 12977 12981
## 3 2 3 2 3 1 2 2 2 2 1 2 2
## 12982 12984 12985 12987 12988 12990 12991 12993 12994 12995 12997 12999 13000
## 1 2 1 2 1 2 2 2 2 2 2 2 2
## 13002 13003 13005 13006 13008 13011 13012 13014 13015 13016 13017 13021 13023
## 2 2 2 2 2 2 3 3 1 2 2 3 1
## 13026 13028 13029 13030 13032 13033 13034 13035 13037 13038 13040 13043 13044
## 3 2 1 1 1 2 2 1 2 2 2 1 1
## 13045 13046 13047 13048 13049 13052 13055 13058 13059 13060 13061 13062 13064
## 2 2 3 1 2 1 1 2 2 2 2 2 2
## 13065 13066 13067 13068 13070 13072 13077 13079 13080 13082 13083 13085 13091
## 2 2 2 2 2 2 2 2 2 3 2 2 2
## 13092 13095 13097 13099 13101 13103 13104 13106 13107 13108 13109 13110 13115
## 2 2 3 2 2 2 3 2 1 1 1 3 1
## 13116 13117 13118 13120 13121 13122 13126 13127 13130 13131 13132 13133 13134
## 1 3 3 2 2 1 3 2 2 1 2 2 1
## 13136 13137 13138 13139 13140 13141 13142 13144 13145 13146 13147 13149 13153
## 1 3 3 1 2 1 2 2 2 2 2 1 1
## 13155 13157 13158 13159 13160 13161 13162 13165 13166 13167 13168 13169 13170
## 2 1 2 1 2 2 1 1 1 2 1 1 2
## 13171 13173 13176 13177 13178 13182 13183 13184 13185 13186 13187 13188 13189
## 2 2 1 2 3 2 3 3 2 1 2 2 2
## 13192 13193 13194 13196 13198 13200 13203 13207 13208 13209 13210 13211 13212
## 1 2 2 1 1 2 2 2 3 3 1 1 2
## 13213 13216 13217 13218 13220 13221 13223 13226 13227 13228 13229 13232 13233
## 3 2 2 2 2 1 2 2 2 1 2 3 2
## 13236 13238 13239 13240 13242 13243 13244 13245 13246 13247 13248 13249 13253
## 1 2 2 2 2 1 2 1 3 2 2 2 1
## 13255 13256 13258 13259 13260 13261 13262 13265 13268 13270 13271 13272 13273
## 2 2 2 2 1 1 2 3 3 1 2 2 2
## 13276 13277 13278 13279 13280 13282 13283 13284 13285 13291 13292 13294 13295
## 2 2 1 2 2 1 2 2 1 1 2 1 2
## 13296 13297 13298 13299 13300 13301 13302 13304 13305 13307 13308 13309 13310
## 2 1 1 2 1 2 2 2 3 2 1 3 1
## 13311 13313 13314 13317 13318 13320 13321 13322 13323 13324 13325 13327 13329
## 2 3 2 3 2 1 2 2 2 3 1 3 1
## 13330 13332 13336 13338 13341 13343 13345 13347 13348 13349 13350 13351 13352
## 1 1 1 1 1 1 1 2 2 2 1 1 1
## 13354 13355 13356 13357 13358 13359 13362 13363 13364 13366 13368 13369 13370
## 1 1 1 1 1 1 1 1 2 2 2 2 1
## 13372 13375 13376 13379 13381 13382 13384 13385 13388 13389 13390 13391 13394
## 1 1 1 2 1 2 3 1 2 2 1 2 3
## 13395 13396 13397 13398 13402 13403 13404 13405 13410 13411 13414 13416 13417
## 2 1 3 1 2 2 2 2 3 2 1 1 2
## 13419 13420 13425 13426 13427 13428 13429 13430 13431 13434 13435 13436 13437
## 2 2 1 3 2 2 2 2 1 2 3 2 3
## 13439 13441 13447 13448 13449 13450 13451 13452 13453 13455 13456 13460 13461
## 2 2 1 1 2 3 1 2 2 1 3 2 1
## 13462 13464 13466 13467 13470 13471 13473 13474 13475 13476 13477 13479 13481
## 2 1 2 1 2 1 2 2 1 1 3 2 3
## 13482 13483 13484 13485 13486 13487 13489 13491 13492 13493 13494 13495 13496
## 2 2 2 1 1 2 2 3 1 2 2 3 2
## 13497 13499 13500 13502 13503 13504 13506 13507 13508 13509 13510 13512 13513
## 2 3 1 2 2 2 2 1 2 3 1 2 2
## 13514 13515 13516 13517 13518 13519 13520 13521 13522 13523 13524 13525 13527
## 2 2 1 1 1 2 1 1 2 1 2 2 3
## 13529 13531 13532 13533 13536 13538 13539 13544 13546 13548 13549 13551 13557
## 2 2 2 2 3 3 2 2 2 2 3 2 2
## 13558 13560 13561 13562 13563 13564 13565 13566 13568 13569 13570 13573 13575
## 2 2 2 1 1 1 2 1 2 2 2 2 2
## 13577 13579 13581 13583 13584 13587 13588 13589 13590 13591 13592 13593 13594
## 1 2 2 1 2 1 3 2 3 1 2 3 1
## 13596 13598 13600 13601 13602 13603 13606 13607 13610 13611 13614 13615 13617
## 1 2 2 1 1 2 2 1 3 1 1 1 2
## 13618 13621 13623 13626 13627 13629 13630 13631 13632 13634 13636 13637 13638
## 2 2 2 2 3 3 3 3 3 3 3 2 2
## 13642 13643 13644 13645 13647 13649 13650 13651 13652 13654 13655 13656 13657
## 1 2 1 2 1 2 3 2 1 3 1 2 2
## 13658 13659 13662 13663 13666 13667 13669 13670 13672 13673 13675 13678 13681
## 1 1 2 2 2 2 2 1 2 2 2 2 2
## 13682 13684 13685 13686 13690 13692 13697 13699 13700 13703 13704 13705 13706
## 2 2 3 2 2 1 2 2 3 2 3 2 2
## 13707 13708 13710 13711 13712 13715 13716 13717 13718 13719 13720 13721 13722
## 1 2 2 2 2 3 2 3 2 3 2 1 1
## 13723 13725 13726 13727 13728 13730 13731 13732 13735 13736 13737 13739 13740
## 2 3 1 2 3 1 2 1 1 1 2 2 1
## 13741 13743 13744 13745 13747 13748 13750 13751 13752 13753 13754 13755 13758
## 2 3 1 2 2 3 3 2 3 1 2 3 3
## 13759 13760 13761 13762 13764 13769 13771 13772 13774 13778 13780 13781 13782
## 2 2 1 2 1 3 1 1 2 2 2 2 3
## 13784 13786 13787 13790 13791 13792 13799 13800 13801 13803 13804 13805 13806
## 3 2 2 1 1 2 1 1 2 2 3 1 2
## 13807 13808 13810 13811 13812 13813 13814 13816 13817 13819 13821 13822 13823
## 2 3 1 2 2 1 1 2 2 1 2 2 1
## 13824 13826 13827 13828 13831 13832 13833 13835 13837 13838 13841 13842 13844
## 3 2 2 2 3 2 1 2 2 2 2 3 1
## 13845 13846 13848 13849 13856 13858 13859 13860 13862 13863 13865 13866 13867
## 2 2 1 1 2 2 2 3 3 2 2 2 1
## 13869 13870 13873 13874 13875 13876 13877 13882 13883 13884 13885 13886 13887
## 1 3 2 1 3 2 2 3 1 2 2 2 1
## 13888 13889 13890 13892 13894 13895 13897 13898 13899 13900 13901 13904 13908
## 2 1 3 2 2 1 2 2 2 2 1 2 1
## 13911 13914 13917 13918 13922 13923 13924 13925 13926 13927 13928 13929 13930
## 3 2 2 1 2 1 3 2 2 1 2 1 2
## 13931 13932 13933 13936 13937 13938 13939 13940 13946 13947 13948 13949 13950
## 1 2 2 1 2 2 2 2 2 2 2 3 2
## 13951 13953 13954 13955 13956 13959 13960 13962 13963 13967 13971 13972 13973
## 2 3 2 2 3 2 2 2 2 2 3 2 2
## 13974 13975 13976 13978 13980 13982 13984 13986 13988 13989 13990 13991 13992
## 1 3 1 2 2 1 3 2 1 1 2 3 2
## 13993 13994 13995 14000 14001 14002 14004 14005 14006 14009 14012 14013 14014
## 3 3 3 1 1 2 3 1 2 1 2 2 1
## 14019 14020 14021 14022 14023 14024 14027 14029 14030 14032 14034 14035 14036
## 1 2 2 1 2 2 2 2 3 3 2 3 1
## 14037 14038 14039 14041 14044 14045 14046 14047 14048 14050 14052 14053 14054
## 2 1 2 2 2 1 2 3 1 1 2 2 2
## 14055 14059 14064 14066 14067 14068 14071 14073 14075 14076 14077 14078 14079
## 1 2 3 2 2 2 3 2 2 2 2 3 1
## 14080 14081 14082 14083 14087 14089 14090 14093 14098 14099 14100 14102 14104
## 2 1 2 3 2 2 2 1 2 3 2 3 2
## 14107 14108 14109 14111 14112 14113 14114 14116 14117 14121 14124 14126 14127
## 3 2 2 2 3 1 2 3 2 1 1 2 2
## 14128 14129 14130 14132 14133 14138 14139 14140 14141 14142 14143 14147 14148
## 2 3 1 3 2 1 1 1 2 2 2 2 2
## 14149 14150 14152 14154 14155 14157 14158 14159 14161 14162 14163 14165 14167
## 1 2 2 1 2 2 1 3 1 2 1 2 2
## 14171 14173 14174 14176 14177 14178 14179 14184 14185 14188 14193 14195 14196
## 1 2 2 2 2 3 1 1 2 3 1 1 2
## 14198 14199 14201 14204 14205 14206 14208 14209 14210 14211 14214 14215 14216
## 2 2 3 2 2 2 2 3 3 3 3 3 1
## 14218 14219 14220 14221 14222 14223 14224 14226 14227 14229 14231 14232 14233
## 2 2 2 3 1 2 2 1 3 1 2 3 1
## 14234 14235 14236 14237 14238 14239 14240 14241 14242 14243 14246 14247 14248
## 2 1 2 2 2 3 1 2 2 3 1 2 2
## 14250 14251 14256 14257 14259 14261 14262 14264 14265 14267 14270 14271 14272
## 1 1 1 1 2 1 3 2 2 1 1 2 2
## 14273 14276 14280 14284 14285 14287 14288 14289 14290 14291 14292 14293 14295
## 2 1 2 2 1 2 1 3 1 3 3 2 2
## 14297 14299 14300 14301 14304 14305 14307 14309 14311 14312 14314 14315 14317
## 2 3 2 1 1 1 3 3 2 3 2 3 1
## 14320 14321 14323 14326 14327 14329 14331 14332 14333 14334 14335 14336 14338
## 2 3 2 2 2 1 2 2 1 3 2 1 2
## 14339 14340 14341 14342 14344 14345 14346 14348 14349 14350 14351 14352 14353
## 2 2 3 2 3 2 1 1 2 2 2 2 2
## 14354 14355 14356 14357 14359 14360 14362 14364 14368 14371 14373 14375 14377
## 2 2 1 2 2 1 2 3 2 2 2 2 2
## 14379 14381 14382 14383 14385 14386 14387 14388 14389 14390 14393 14395 14396
## 2 2 1 1 2 2 1 3 1 3 2 3 2
## 14400 14403 14404 14406 14407 14408 14409 14410 14412 14413 14414 14416 14418
## 1 1 3 2 3 3 3 3 1 2 3 2 1
## 14419 14420 14421 14422 14423 14424 14426 14427 14428 14431 14432 14434 14436
## 3 1 1 1 2 2 3 2 3 1 3 3 2
## 14437 14438 14440 14441 14443 14446 14447 14448 14449 14450 14451 14452 14453
## 2 2 1 1 1 2 3 2 2 2 2 2 2
## 14456 14457 14460 14461 14462 14463 14465 14466 14467 14470 14472 14473 14474
## 3 2 2 1 3 2 1 3 2 2 3 2 1
## 14475 14476 14477 14479 14480 14481 14482 14483 14484 14485 14487 14489 14491
## 2 2 2 2 2 2 3 2 2 2 3 1 2
## 14493 14494 14495 14496 14497 14498 14499 14500 14501 14502 14503 14504 14505
## 1 2 2 2 1 3 2 2 2 3 1 2 3
## 14506 14507 14508 14511 14512 14513 14514 14515 14517 14518 14520 14522 14523
## 3 3 2 3 2 2 1 3 2 2 2 2 2
## 14524 14525 14528 14529 14530 14532 14533 14536 14537 14538 14539 14540 14541
## 3 3 1 2 3 2 3 2 1 2 2 2 3
## 14542 14546 14547 14548 14549 14550 14551 14552 14553 14554 14555 14557 14561
## 2 1 3 2 2 1 2 2 3 1 2 1 1
## 14565 14567 14569 14570 14572 14573 14576 14577 14578 14581 14582 14583 14584
## 1 1 2 2 3 3 2 2 2 2 2 3 2
## 14585 14586 14587 14589 14591 14592 14593 14594 14595 14597 14598 14600 14601
## 2 2 3 2 1 2 2 2 3 1 2 1 2
## 14603 14608 14609 14616 14618 14619 14620 14621 14622 14623 14624 14625 14626
## 1 1 2 2 2 1 2 3 2 3 2 1 1
## 14628 14629 14631 14632 14633 14636 14638 14639 14640 14641 14642 14643 14644
## 2 1 1 2 2 2 1 3 3 2 2 1 1
## 14645 14647 14649 14651 14652 14653 14655 14656 14657 14658 14659 14660 14661
## 2 2 1 2 2 3 1 2 2 2 3 2 2
## 14662 14664 14665 14666 14669 14670 14672 14673 14675 14676 14681 14682 14684
## 2 2 3 2 1 2 1 3 1 3 2 2 3
## 14687 14689 14690 14691 14692 14693 14696 14697 14698 14699 14700 14701 14703
## 1 2 2 3 2 2 3 2 3 2 1 3 2
## 14704 14705 14708 14710 14711 14712 14713 14714 14715 14716 14719 14720 14722
## 3 2 1 2 3 2 3 2 2 2 3 2 2
## 14723 14725 14727 14729 14730 14731 14732 14737 14738 14739 14740 14741 14744
## 3 1 2 2 3 2 3 1 3 3 1 3 3
## 14745 14747 14748 14752 14753 14754 14755 14756 14757 14758 14759 14760 14761
## 3 2 3 1 1 2 3 1 1 1 1 2 2
## 14762 14764 14765 14766 14768 14770 14772 14775 14776 14778 14779 14780 14782
## 2 2 2 3 2 1 2 1 3 1 2 2 2
## 14784 14785 14788 14789 14790 14792 14793 14794 14795 14798 14799 14801 14803
## 2 2 2 2 2 2 2 3 2 2 2 2 2
## 14804 14805 14806 14808 14810 14813 14815 14816 14817 14818 14819 14820 14821
## 1 2 2 3 3 2 1 2 1 2 2 2 2
## 14823 14824 14828 14829 14830 14834 14836 14837 14840 14841 14842 14844 14847
## 2 2 1 2 2 3 2 1 2 3 1 1 2
## 14850 14851 14852 14853 14854 14855 14856 14857 14859 14860 14861 14862 14863
## 2 2 3 2 3 2 1 1 1 2 2 1 2
## 14865 14867 14868 14869 14870 14871 14873 14875 14878 14880 14881 14882 14883
## 2 2 3 1 2 2 1 1 3 2 2 2 3
## 14885 14886 14888 14889 14890 14891 14893 14894 14896 14897 14898 14901 14902
## 1 1 1 2 2 2 1 1 2 1 3 3 2
## 14903 14904 14905 14907 14908 14910 14912 14913 14915 14916 14920 14921 14923
## 1 1 2 3 2 2 1 2 2 2 1 1 1
## 14924 14929 14946 14947 14948 14950 14951 14952 14953 14954 14957 14958 14959
## 2 2 2 2 3 1 2 3 2 2 2 2 2
## 14960 14961 14962 14963 14964 14965 14966 14967 14968 14970 14971 14972 14973
## 2 3 2 3 2 2 2 1 2 1 1 2 1
## 14974 14975 14976 14978 14981 14984 14985 14987 14988 14995 14997 14998 15000
## 2 2 3 3 2 2 2 2 2 2 2 2 1
## 15002 15006 15007 15009 15010 15012 15014 15016 15017 15018 15019 15021 15022
## 1 1 2 1 2 2 2 2 2 2 2 3 2
## 15023 15024 15025 15026 15027 15028 15030 15031 15033 15034 15035 15036 15038
## 3 3 1 2 2 2 2 2 3 3 2 2 3
## 15041 15042 15043 15045 15047 15048 15049 15050 15051 15052 15053 15054 15057
## 2 2 1 1 2 2 2 1 1 2 2 2 1
## 15058 15059 15060 15062 15063 15065 15067 15068 15070 15071 15073 15074 15075
## 3 3 2 2 1 1 1 2 2 1 1 1 1
## 15079 15081 15083 15087 15088 15089 15090 15091 15092 15093 15095 15096 15097
## 2 2 2 2 1 3 1 1 2 1 1 2 2
## 15099 15100 15101 15103 15104 15105 15106 15107 15109 15110 15111 15114 15115
## 1 2 2 1 1 3 3 3 1 2 1 3 2
## 15116 15117 15118 15119 15120 15121 15122 15124 15127 15128 15129 15130 15132
## 1 3 2 2 1 2 1 2 1 1 3 2 3
## 15133 15134 15135 15136 15139 15140 15142 15143 15145 15146 15147 15148 15149
## 2 3 2 2 2 3 1 2 2 1 1 2 1
## 15150 15153 15154 15156 15157 15158 15160 15163 15164 15165 15167 15168 15172
## 3 2 2 2 1 1 2 2 2 1 2 2 3
## 15174 15175 15178 15179 15180 15181 15182 15184 15185 15186 15192 15193 15197
## 2 2 2 1 2 2 2 2 2 2 1 1 1
## 15198 15199 15201 15203 15204 15205 15206 15208 15210 15211 15212 15213 15214
## 2 2 3 3 2 2 2 3 2 1 2 2 3
## 15215 15216 15218 15219 15220 15221 15222 15223 15224 15225 15226 15227 15230
## 2 2 3 2 3 1 1 1 2 1 2 3 2
## 15232 15234 15236 15237 15238 15239 15240 15241 15243 15244 15246 15247 15252
## 2 2 2 1 1 1 3 3 2 2 2 1 1
## 15253 15254 15256 15257 15258 15260 15261 15262 15263 15264 15265 15266 15267
## 3 2 2 2 2 3 2 2 2 1 1 2 3
## 15269 15270 15272 15274 15275 15276 15277 15279 15280 15281 15286 15287 15288
## 1 3 1 1 1 2 2 2 2 3 2 2 1
## 15289 15292 15296 15297 15299 15300 15303 15304 15306 15307 15308 15312 15313
## 2 2 1 2 3 1 1 3 1 2 2 2 2
## 15314 15315 15316 15318 15319 15320 15322 15325 15326 15327 15329 15330 15332
## 2 2 2 2 2 2 1 2 2 2 1 1 1
## 15334 15335 15339 15342 15343 15344 15345 15346 15347 15348 15349 15350 15351
## 2 2 2 1 1 2 1 2 2 2 2 2 3
## 15353 15355 15356 15360 15361 15363 15364 15365 15366 15367 15368 15370 15374
## 1 2 3 1 1 2 1 3 2 1 1 3 2
## 15376 15379 15380 15381 15384 15385 15386 15389 15392 15393 15394 15395 15396
## 1 3 3 2 2 2 1 1 1 2 1 2 2
## 15397 15398 15399 15400 15402 15405 15406 15407 15408 15410 15411 15412 15414
## 2 1 2 2 2 1 2 2 2 3 1 2 2
## 15415 15417 15419 15421 15422 15423 15424 15426 15427 15428 15429 15432 15433
## 1 1 2 2 2 2 2 3 1 2 2 2 2
## 15434 15435 15436 15437 15438 15440 15442 15443 15444 15445 15447 15448 15449
## 3 2 1 2 2 2 1 3 1 2 2 1 2
## 15450 15452 15453 15454 15456 15457 15458 15460 15462 15463 15466 15467 15468
## 1 2 3 2 2 2 2 2 2 2 2 2 2
## 15469 15471 15472 15473 15475 15478 15483 15488 15489 15491 15492 15493 15494
## 2 1 1 3 1 1 2 2 1 3 2 3 1
## 15497 15500 15503 15504 15505 15506 15507 15508 15510 15511 15512 15514 15516
## 1 2 2 2 1 2 1 3 2 3 2 3 2
## 15517 15518 15520 15521 15522 15523 15524 15525 15526 15527 15528 15529 15530
## 2 3 2 3 2 1 1 2 2 3 2 3 1
## 15532 15533 15535 15537 15539 15540 15541 15543 15544 15545 15549 15550 15551
## 1 2 2 2 1 2 2 2 3 2 1 2 1
## 15552 15553 15554 15556 15557 15561 15562 15563 15565 15567 15568 15569 15571
## 2 1 2 2 1 2 2 1 2 2 2 3 2
## 15572 15573 15574 15577 15578 15579 15582 15584 15585 15587 15589 15592 15593
## 3 2 2 2 2 2 2 2 1 2 2 1 2
## 15594 15596 15597 15598 15599 15602 15603 15604 15605 15606 15607 15608 15609
## 3 3 2 2 1 3 2 2 3 3 2 2 2
## 15610 15612 15618 15619 15620 15621 15622 15623 15624 15625 15626 15628 15630
## 2 2 2 2 1 2 3 2 2 1 2 3 1
## 15632 15634 15636 15637 15639 15641 15643 15644 15645 15646 15648 15649 15651
## 3 2 1 2 1 1 2 2 1 2 2 1 2
## 15652 15653 15654 15655 15656 15657 15658 15659 15660 15661 15663 15664 15667
## 2 1 1 1 2 2 3 2 3 2 2 1 2
## 15668 15669 15670 15671 15673 15674 15675 15677 15678 15679 15680 15681 15683
## 2 2 2 3 1 1 2 1 1 2 1 3 2
## 15687 15689 15690 15691 15692 15695 15696 15699 15700 15701 15703 15704 15705
## 3 2 2 2 2 2 3 2 1 1 2 1 2
## 15706 15707 15708 15709 15712 15713 15714 15716 15717 15720 15721 15722 15723
## 2 2 3 2 3 2 2 2 2 1 1 1 2
## 15724 15725 15727 15729 15730 15732 15733 15734 15737 15739 15740 15743 15744
## 2 1 1 2 1 2 2 1 3 1 2 2 2
## 15745 15746 15747 15748 15750 15752 15753 15754 15755 15756 15757 15758 15759
## 2 2 2 2 3 3 2 2 3 2 1 2 2
## 15762 15763 15764 15766 15768 15773 15774 15775 15776 15777 15780 15781 15783
## 2 1 3 2 2 1 2 2 2 2 2 2 2
## 15785 15787 15789 15790 15793 15795 15796 15797 15799 15800 15801 15802 15803
## 1 2 1 2 2 1 3 1 2 1 1 1 1
## 15806 15807 15809 15810 15811 15812 15813 15814 15815 15819 15820 15821 15822
## 2 2 2 1 3 3 1 1 3 1 2 2 1
## 15823 15825 15826 15829 15830 15831 15834 15835 15836 15837 15839 15840 15841
## 2 1 1 2 1 2 1 2 2 1 1 2 2
## 15843 15844 15845 15847 15850 15852 15853 15855 15857 15858 15860 15861 15862
## 2 2 3 2 2 2 2 2 2 3 3 3 2
## 15863 15864 15865 15866 15869 15870 15872 15874 15877 15880 15881 15882 15883
## 2 3 2 2 2 1 2 3 2 2 2 2 2
## 15885 15886 15888 15889 15891 15894 15895 15897 15898 15899 15900 15901 15903
## 2 2 2 2 1 2 2 2 3 2 1 2 1
## 15904 15906 15907 15909 15910 15912 15916 15917 15918 15919 15920 15921 15922
## 2 3 2 2 3 2 3 2 2 2 2 2 1
## 15923 15925 15930 15932 15933 15935 15937 15938 15940 15942 15944 15945 15948
## 2 2 1 3 1 2 2 2 2 2 2 2 1
## 15949 15950 15951 15952 15953 15957 15958 15963 15965 15967 15969 15970 15973
## 2 1 1 2 3 1 2 2 2 2 2 2 2
## 15974 15975 15976 15977 15980 15981 15983 15984 15985 15986 15987 15988 15990
## 3 1 2 1 1 3 1 3 1 2 3 2 1
## 15992 15993 15994 15996 15998 16003 16005 16006 16007 16008 16009 16010 16012
## 2 3 1 3 1 1 2 2 1 2 2 2 1
## 16014 16015 16016 16017 16018 16019 16020 16022 16023 16024 16025 16026 16027
## 2 2 3 2 2 3 2 1 2 2 1 2 3
## 16030 16031 16034 16036 16037 16038 16040 16042 16043 16045 16048 16049 16050
## 2 2 2 1 2 2 1 3 2 1 2 1 2
## 16052 16053 16054 16055 16056 16057 16059 16062 16063 16065 16066 16070 16071
## 1 1 1 2 1 3 3 2 2 1 3 1 2
## 16072 16073 16076 16078 16079 16080 16081 16083 16084 16085 16086 16091 16092
## 1 2 3 2 1 2 1 1 1 3 3 2 2
## 16093 16094 16096 16097 16098 16099 16102 16103 16104 16105 16106 16107 16109
## 2 2 2 2 3 2 1 3 2 2 2 3 2
## 16110 16112 16113 16114 16115 16116 16117 16119 16120 16121 16122 16123 16124
## 1 2 2 2 3 1 2 2 2 1 2 2 2
## 16125 16127 16128 16131 16134 16135 16136 16139 16140 16141 16142 16143 16144
## 2 1 3 1 2 1 2 2 1 1 1 3 2
## 16145 16146 16147 16148 16149 16150 16153 16156 16157 16159 16160 16162 16163
## 3 2 1 2 2 3 3 3 2 1 1 2 1
## 16164 16169 16170 16171 16172 16173 16174 16175 16177 16178 16179 16181 16183
## 2 1 3 2 3 3 1 2 2 2 2 2 2
## 16184 16185 16188 16189 16190 16193 16198 16200 16201 16202 16203 16204 16205
## 3 2 2 2 2 2 1 1 1 1 2 1 2
## 16206 16207 16208 16209 16211 16212 16213 16214 16215 16217 16218 16221 16224
## 2 1 2 1 1 1 2 1 2 2 3 2 2
## 16225 16226 16227 16229 16230 16232 16233 16235 16236 16239 16242 16243 16244
## 3 2 2 1 2 2 2 3 1 2 3 2 1
## 16245 16247 16248 16249 16250 16255 16256 16257 16261 16265 16266 16268 16271
## 1 2 2 3 2 3 1 2 2 3 3 2 3
## 16272 16274 16275 16278 16279 16282 16283 16284 16287 16292 16293 16295 16297
## 1 1 1 1 1 2 3 1 2 2 3 1 2
## 16298 16302 16305 16306 16308 16309 16311 16313 16315 16316 16317 16318 16319
## 2 2 1 3 1 1 2 2 2 3 1 2 1
## 16320 16321 16322 16323 16324 16325 16327 16330 16332 16337 16338 16339 16340
## 1 2 2 2 2 2 1 2 3 2 2 2 1
## 16341 16342 16343 16344 16345 16347 16348 16349 16350 16351 16352 16354 16356
## 1 2 2 2 1 1 3 2 2 2 2 2 2
## 16357 16358 16359 16360 16361 16362 16363 16364 16365 16366 16367 16368 16369
## 2 1 3 1 2 2 2 1 3 2 1 2 1
## 16370 16372 16374 16376 16377 16378 16379 16383 16384 16385 16386 16387 16389
## 1 2 2 1 1 2 1 2 2 2 2 2 1
## 16392 16394 16395 16399 16400 16402 16403 16404 16405 16406 16407 16409 16411
## 2 3 3 2 2 2 2 1 2 2 3 3 2
## 16412 16413 16414 16415 16416 16418 16419 16423 16424 16425 16426 16427 16429
## 2 2 2 2 1 2 3 2 2 2 3 2 2
## 16430 16431 16432 16433 16434 16438 16440 16441 16442 16444 16445 16447 16448
## 2 2 2 2 3 2 1 2 2 2 2 2 2
## 16449 16450 16451 16454 16455 16456 16457 16460 16461 16462 16463 16464 16466
## 1 2 2 2 3 3 2 2 2 2 1 1 3
## 16468 16469 16470 16471 16473 16474 16475 16477 16478 16479 16480 16482 16483
## 2 2 2 2 2 3 2 3 2 2 1 2 2
## 16484 16485 16488 16491 16493 16495 16496 16497 16498 16499 16500 16503 16504
## 2 1 2 1 1 2 1 3 2 2 3 1 1
## 16505 16506 16509 16510 16511 16513 16515 16516 16517 16518 16519 16520 16526
## 1 2 1 2 2 2 3 2 2 2 2 1 2
## 16527 16528 16529 16531 16533 16535 16536 16539 16542 16545 16546 16549 16550
## 2 2 1 3 1 1 1 1 2 2 1 3 1
## 16551 16552 16554 16555 16556 16557 16560 16561 16565 16566 16567 16569 16570
## 2 2 2 2 3 2 1 2 2 2 1 2 3
## 16571 16572 16573 16574 16581 16582 16583 16584 16586 16587 16589 16591 16593
## 1 1 2 1 2 2 2 1 1 2 2 2 2
## 16594 16595 16596 16597 16598 16600 16601 16602 16603 16609 16610 16611 16612
## 2 1 2 2 2 3 2 1 2 1 2 2 2
## 16613 16614 16616 16617 16618 16619 16620 16621 16623 16624 16625 16627 16628
## 1 1 2 2 1 2 2 2 2 1 2 2 1
## 16629 16633 16634 16637 16638 16639 16641 16642 16643 16644 16647 16648 16650
## 2 3 2 2 3 1 2 1 1 1 2 2 1
## 16653 16654 16655 16657 16658 16659 16660 16665 16666 16667 16668 16669 16670
## 1 2 1 2 2 2 2 2 2 2 3 1 3
## 16671 16674 16676 16679 16680 16681 16682 16685 16686 16688 16689 16690 16692
## 1 2 1 2 2 3 3 2 3 2 2 2 1
## 16693 16696 16697 16706 16708 16709 16710 16711 16712 16714 16715 16716 16717
## 2 2 2 2 1 1 3 3 3 1 2 1 1
## 16718 16719 16720 16721 16723 16725 16726 16727 16728 16730 16732 16734 16735
## 1 3 2 2 2 3 3 2 2 2 1 2 1
## 16737 16738 16739 16742 16743 16744 16747 16748 16750 16752 16753 16755 16756
## 1 2 2 1 3 3 1 3 2 2 2 1 2
## 16757 16758 16759 16761 16762 16763 16765 16766 16767 16768 16769 16770 16771
## 2 1 2 2 1 1 2 1 3 2 1 2 1
## 16773 16774 16775 16776 16777 16778 16780 16781 16784 16788 16789 16790 16791
## 2 2 3 1 2 2 2 2 2 2 2 3 3
## 16792 16793 16794 16795 16796 16801 16803 16804 16805 16806 16807 16808 16809
## 2 2 3 1 2 1 2 2 2 2 1 2 3
## 16810 16811 16812 16813 16816 16817 16818 16820 16823 16824 16825 16826 16828
## 2 2 1 3 2 3 3 1 1 2 1 2 2
## 16829 16830 16832 16833 16834 16835 16836 16837 16838 16841 16842 16846 16847
## 2 2 2 2 1 2 2 3 2 3 1 2 2
## 16848 16849 16850 16851 16852 16855 16856 16858 16859 16861 16863 16866 16869
## 2 2 2 2 2 2 2 1 1 2 2 2 2
## 16871 16872 16875 16877 16878 16880 16881 16882 16883 16884 16885 16887 16889
## 3 2 3 3 2 3 1 2 2 2 2 2 1
## 16891 16892 16893 16895 16897 16898 16899 16900 16903 16905 16906 16907 16909
## 3 2 2 2 2 2 3 2 1 3 2 3 1
## 16910 16912 16913 16914 16915 16916 16917 16918 16919 16921 16924 16926 16927
## 3 3 2 2 3 2 1 3 3 2 2 2 2
## 16929 16930 16932 16933 16934 16936 16938 16942 16943 16947 16948 16949 16950
## 3 2 2 2 1 2 1 3 2 1 2 3 1
## 16951 16952 16953 16954 16955 16956 16957 16959 16960 16961 16963 16965 16966
## 1 2 2 3 2 2 2 2 2 2 2 2 3
## 16967 16968 16969 16971 16976 16978 16979 16980 16982 16983 16985 16987 16988
## 2 2 2 1 2 2 3 1 1 3 3 3 2
## 16989 16990 16992 16996 16997 16998 16999 17001 17002 17004 17006 17007 17010
## 3 2 3 3 2 2 2 3 1 1 2 3 2
## 17011 17014 17015 17018 17019 17022 17024 17025 17026 17027 17029 17030 17031
## 2 2 1 1 2 2 2 2 2 3 1 2 2
## 17033 17034 17035 17038 17040 17041 17042 17043 17045 17046 17047 17048 17049
## 1 2 2 2 1 1 3 1 2 1 1 2 3
## 17050 17051 17052 17053 17054 17058 17059 17060 17061 17062 17063 17064 17069
## 3 2 1 1 3 1 1 2 3 2 3 2 3
## 17070 17071 17073 17075 17076 17078 17079 17080 17081 17083 17085 17086 17088
## 2 3 1 2 2 2 2 2 2 1 3 3 1
## 17090 17091 17092 17094 17095 17096 17097 17100 17101 17102 17105 17109 17110
## 3 3 1 2 1 2 3 1 1 2 2 3 2
## 17111 17114 17115 17117 17118 17119 17120 17122 17123 17124 17125 17126 17128
## 2 3 2 2 2 2 2 2 2 2 2 3 2
## 17131 17133 17134 17135 17138 17140 17142 17144 17146 17147 17148 17152 17153
## 1 1 2 3 1 1 1 1 2 1 2 1 2
## 17154 17155 17157 17158 17159 17160 17162 17163 17164 17165 17166 17169 17171
## 2 2 2 1 1 1 3 2 3 2 2 1 2
## 17172 17173 17174 17175 17176 17179 17180 17181 17183 17186 17187 17188 17189
## 2 3 2 1 2 2 2 2 3 2 2 3 2
## 17190 17191 17193 17194 17198 17201 17203 17204 17205 17206 17211 17212 17213
## 2 3 3 2 2 2 1 1 1 2 3 2 3
## 17214 17217 17218 17219 17221 17222 17223 17226 17227 17228 17229 17230 17231
## 3 2 3 2 2 1 2 1 3 3 2 3 3
## 17232 17233 17234 17235 17236 17237 17239 17242 17245 17247 17248 17250 17251
## 2 2 2 2 3 2 1 1 2 2 2 2 2
## 17252 17253 17254 17255 17256 17259 17262 17263 17265 17266 17267 17268 17272
## 2 2 2 2 2 2 3 2 2 2 2 2 1
## 17274 17277 17278 17279 17282 17284 17286 17287 17288 17289 17290 17291 17293
## 2 1 2 2 1 3 2 3 3 2 2 1 3
## 17295 17297 17298 17299 17301 17302 17303 17309 17311 17312 17314 17320 17321
## 2 2 2 2 2 3 2 2 1 2 3 1 1
## 17323 17324 17325 17329 17330 17331 17333 17334 17337 17339 17341 17343 17344
## 3 2 2 2 2 2 1 2 1 2 2 2 2
## 17345 17347 17348 17349 17350 17351 17356 17357 17358 17359 17360 17361 17362
## 2 2 3 2 2 2 2 2 2 2 2 2 2
## 17364 17365 17367 17368 17370 17371 17372 17373 17374 17375 17376 17379 17382
## 3 3 2 3 2 2 3 2 2 2 2 1 2
## 17383 17384 17385 17386 17387 17388 17391 17392 17394 17397 17398 17400 17403
## 2 2 2 3 1 2 2 2 2 1 2 3 2
## 17405 17406 17408 17409 17410 17411 17412 17414 17415 17418 17420 17422 17423
## 1 1 2 1 3 2 3 1 1 2 2 3 1
## 17425 17427 17429 17430 17431 17432 17433 17434 17436 17438 17440 17442 17446
## 1 2 2 2 1 2 2 3 2 1 2 3 2
## 17447 17449 17451 17453 17454 17455 17456 17457 17458 17459 17460 17461 17462
## 2 3 3 2 2 2 2 3 2 2 3 2 2
## 17463 17464 17466 17468 17469 17470 17472 17475 17480 17481 17483 17486 17489
## 3 2 1 2 3 3 2 2 1 2 2 1 2
## 17490 17491 17492 17495 17496 17498 17499 17500 17501 17502 17503 17504 17505
## 3 3 1 2 2 2 1 1 2 2 2 3 1
## 17506 17507 17508 17509 17510 17512 17513 17514 17515 17516 17517 17519 17520
## 2 2 1 3 2 3 1 2 2 2 2 3 1
## 17521 17522 17523 17524 17525 17526 17527 17528 17530 17531 17534 17535 17536
## 2 3 2 2 1 2 2 3 3 2 2 2 2
## 17537 17538 17540 17542 17545 17548 17549 17550 17551 17552 17554 17555 17556
## 1 2 2 2 2 2 2 2 2 2 3 2 2
## 17557 17560 17561 17562 17564 17566 17567 17569 17571 17572 17573 17574 17578
## 2 3 2 3 2 1 3 2 1 2 2 2 2
## 17579 17580 17582 17584 17585 17588 17589 17590 17591 17593 17594 17595 17596
## 2 2 2 1 2 1 1 1 3 1 1 2 3
## 17600 17601 17603 17604 17608 17609 17612 17614 17615 17616 17618 17619 17620
## 2 2 1 2 2 3 3 1 2 2 2 2 2
## 17621 17623 17624 17625 17628 17629 17630 17631 17633 17634 17636 17637 17639
## 1 1 1 1 2 3 2 2 1 3 2 2 2
## 17640 17642 17643 17644 17646 17647 17648 17650 17651 17653 17654 17655 17656
## 1 1 2 3 1 2 1 2 3 2 2 3 3
## 17658 17660 17663 17664 17666 17667 17668 17669 17670 17671 17673 17674 17676
## 2 2 3 2 1 3 2 3 2 1 3 2 3
## 17678 17680 17682 17684 17685 17691 17692 17693 17694 17695 17696 17697 17698
## 2 2 3 2 3 2 2 2 2 1 3 2 2
## 17700 17701 17702 17703 17704 17705 17707 17708 17709 17711 17712 17714 17715
## 1 1 1 2 1 3 2 2 2 2 1 2 2
## 17716 17718 17720 17722 17723 17724 17725 17731 17732 17733 17734 17736 17737
## 3 2 2 1 3 1 3 2 2 1 2 2 2
## 17738 17739 17742 17744 17746 17747 17749 17750 17752 17754 17758 17759 17760
## 1 3 2 3 2 2 2 3 2 3 3 2 2
## 17761 17763 17764 17765 17767 17768 17769 17770 17771 17772 17774 17775 17777
## 1 2 1 2 2 1 3 3 2 2 2 2 2
## 17779 17781 17783 17785 17786 17787 17788 17789 17791 17793 17795 17796 17797
## 2 2 2 2 2 1 1 2 2 2 2 2 2
## 17799 17800 17802 17805 17806 17812 17813 17816 17817 17819 17824 17827 17828
## 3 3 1 1 1 2 3 2 2 3 2 3 1
## 17830 17831 17832 17835 17836 17837 17838 17839 17843 17848 17849 17852 17854
## 2 2 2 2 2 3 1 2 2 3 2 2 2
## 17855 17856 17859 17860 17861 17862 17863 17864 17866 17867 17869 17871 17873
## 2 1 2 2 3 2 3 2 2 3 2 2 3
## 17874 17877 17878 17879 17880 17881 17883 17884 17885 17886 17887 17888 17889
## 3 2 1 2 1 2 2 2 2 2 2 3 2
## 17890 17891 17892 17893 17894 17895 17896 17897 17898 17899 17900 17901 17904
## 2 2 2 2 3 2 2 2 2 2 2 2 2
## 17905 17906 17908 17911 17912 17913 17914 17917 17921 17923 17924 17925 17926
## 2 2 2 1 2 2 2 2 2 2 3 2 2
## 17928 17929 17930 17931 17932 17934 17935 17936 17937 17939 17940 17941 17942
## 2 2 3 2 1 1 2 1 3 2 3 2 2
## 17946 17947 17948 17950 17951 17955 17956 17957 17958 17960 17962 17964 17966
## 2 2 1 2 1 2 2 2 1 2 2 2 3
## 17967 17968 17969 17970 17972 17973 17974 17976 17977 17978 17979 17980 17984
## 2 2 2 1 2 2 2 1 2 2 2 2 2
## 17985 17986 17987 17988 17990 17991 17994 17995 17997 17999 18001 18004 18005
## 1 2 2 3 2 2 2 2 3 2 2 2 2
## 18006 18008 18009 18010 18011 18013 18014 18015 18016 18017 18018 18019 18022
## 1 3 2 2 2 2 2 2 3 2 2 2 1
## 18024 18027 18030 18032 18033 18034 18035 18036 18037 18040 18042 18043 18044
## 2 2 2 2 2 2 2 2 3 2 2 2 3
## 18045 18048 18050 18053 18055 18056 18058 18059 18061 18062 18064 18066 18067
## 2 2 2 2 3 1 2 2 3 2 1 2 1
## 18068 18069 18071 18072 18074 18075 18077 18078 18080 18081 18082 18084 18085
## 2 3 2 2 1 3 3 2 1 2 1 2 1
## 18086 18088 18093 18094 18095 18096 18097 18099 18101 18104 18105 18106 18108
## 2 2 1 3 2 2 3 2 2 1 2 1 2
## 18110 18112 18113 18114 18116 18117 18119 18120 18121 18122 18123 18125 18126
## 2 2 2 2 3 2 2 2 2 3 2 2 2
## 18127 18129 18130 18135 18136 18138 18142 18143 18145 18146 18147 18149 18150
## 2 2 1 2 2 2 1 1 1 2 2 2 2
## 18151 18154 18155 18156 18158 18159 18160 18161 18164 18165 18167 18168 18169
## 2 2 2 1 2 1 2 3 1 2 1 3 2
## 18170 18171 18173 18174 18176 18177 18178 18179 18180 18181 18183 18184 18185
## 2 3 1 2 1 3 1 3 3 1 2 2 2
## 18188 18189 18190 18191 18193 18196 18200 18202 18203 18204 18205 18209 18210
## 1 1 2 2 2 1 2 1 2 1 2 2 3
## 18211 18212 18213 18215 18216 18217 18218 18219 18220 18221 18222 18224 18226
## 2 2 2 2 1 2 2 3 2 3 1 2 3
## 18227 18228 18230 18231 18232 18233 18235 18236 18237 18239 18240 18242 18245
## 2 1 3 3 2 1 1 3 3 3 1 1 3
## 18246 18248 18249 18250 18252 18255 18257 18259 18260 18261 18262 18263 18265
## 2 1 2 1 2 2 3 1 3 2 2 1 1
## 18268 18269 18270 18272 18273 18274 18276 18277 18278 18280 18281 18282 18287
## 2 2 2 3 2 2 2 2 2 2 2 2 1
##
## Within cluster sum of squares by cluster:
## [1] 894.5541 945.5242 846.0966
## (between_SS / total_SS = 64.4 %)
##
## Available components:
##
## [1] "cluster" "centers" "totss" "withinss" "tot.withinss"
## [6] "betweenss" "size" "iter" "ifault"asignacion <- cbind(bd9, cluster = segmentos$cluster)
head(asignacion,10)## total Visitas cluster
## 12347 615.7143 7 3
## 12350 334.4000 1 2
## 12352 313.2550 8 3
## 12353 89.0000 1 2
## 12355 459.4000 1 1
## 12358 584.0300 2 1
## 12361 189.9000 1 2
## 12362 522.6230 10 3
## 12363 276.0000 2 2
## 12364 328.2750 4 2Paso 3. Exportar csv
write.csv(asignacion, "clientes_segementados.csv")Paso 4. Visualizar segmentos
#install.packages("factoextra")
library(factoextra)## Loading required package: ggplot2## Welcome! Want to learn more? See two factoextra-related books at https://goo.gl/ve3WBafviz_cluster(segmentos, data = bd10,
palette=c("red", "blue", "black", "darkgreen"),
ellise.type = "euclid",
star.plot = T,
repel = T,
ggtheme = theme())## Warning: ggrepel: 3735 unlabeled data points (too many overlaps). Consider
## increasing max.overlaps
library("cluster")Paso 5. Optimizar k
set.seed(123)
optimizacion <- clusGap(bd10, FUN = kmeans, nstart = 25, K.max = 10, B = 50)## Warning: did not converge in 10 iterations
## Warning: did not converge in 10 iterations
## Warning: did not converge in 10 iterations
## Warning: did not converge in 10 iterations
## Warning: did not converge in 10 iterationsplot(optimizacion, xlab = "Numero de clusters k")
Paso 6. Clusters optimizados
segmentos <- kmeans(bd10, 4)
segmentos## K-means clustering with 4 clusters of sizes 836, 449, 874, 1611
##
## Cluster means:
## total Visitas
## 1 -0.4282581 0.4358264
## 2 0.2891711 2.1574818
## 3 1.3319923 -0.2767066
## 4 -0.5809903 -0.6773548
##
## Clustering vector:
## 12347 12350 12352 12353 12355 12358 12361 12362 12363 12364 12370 12373 12374
## 2 4 2 4 3 3 4 2 4 1 4 4 3
## 12379 12380 12381 12383 12384 12386 12388 12390 12393 12394 12399 12401 12402
## 3 3 1 1 4 4 2 3 3 3 1 4 4
## 12407 12408 12410 12413 12414 12417 12418 12421 12422 12423 12425 12426 12427
## 1 3 4 1 1 2 3 1 1 2 3 3 1
## 12429 12430 12434 12436 12441 12442 12445 12447 12448 12450 12452 12453 12455
## 3 4 3 3 4 4 4 3 3 4 4 3 1
## 12457 12458 12461 12462 12463 12464 12465 12468 12473 12475 12476 12478 12479
## 1 3 3 3 1 2 3 3 3 3 2 3 3
## 12481 12483 12484 12488 12489 12490 12491 12492 12493 12494 12498 12500 12502
## 2 2 3 3 4 2 3 4 4 2 1 2 3
## 12504 12506 12507 12508 12509 12510 12512 12513 12515 12516 12517 12518 12519
## 4 4 3 4 4 3 4 3 3 3 3 1 4
## 12520 12521 12522 12523 12524 12526 12527 12528 12530 12531 12532 12535 12538
## 3 3 4 2 2 3 1 2 3 4 4 3 4
## 12541 12544 12545 12546 12547 12548 12551 12552 12553 12556 12558 12559 12560
## 1 3 3 3 4 4 4 4 2 4 4 4 3
## 12561 12562 12564 12565 12566 12571 12572 12573 12574 12576 12577 12579 12580
## 4 2 3 4 4 4 3 4 4 1 1 3 3
## 12581 12584 12586 12589 12591 12592 12593 12594 12596 12598 12599 12600 12601
## 4 2 4 4 3 4 1 2 4 2 2 2 1
## 12602 12603 12604 12609 12610 12612 12613 12614 12615 12616 12617 12618 12619
## 4 3 4 3 3 3 3 4 3 3 4 4 2
## 12620 12622 12623 12624 12626 12627 12628 12633 12637 12638 12639 12640 12641
## 3 4 4 4 2 2 1 3 2 3 3 3 4
## 12642 12643 12644 12645 12646 12648 12649 12650 12651 12654 12657 12658 12659
## 1 3 3 3 3 4 1 4 4 1 3 3 4
## 12660 12662 12665 12670 12672 12673 12674 12676 12679 12680 12684 12685 12686
## 4 2 4 3 4 4 3 1 1 1 2 2 4
## 12689 12690 12691 12693 12694 12695 12697 12701 12702 12703 12705 12707 12708
## 3 3 1 1 3 1 1 3 4 4 2 3 2
## 12710 12715 12716 12717 12718 12719 12721 12722 12723 12724 12725 12726 12727
## 3 4 3 3 4 4 2 1 1 1 3 2 2
## 12728 12729 12732 12733 12734 12735 12736 12738 12739 12740 12743 12747 12750
## 1 3 4 3 4 3 4 4 3 3 4 2 4
## 12756 12759 12763 12775 12778 12779 12782 12783 12784 12785 12787 12789 12790
## 4 3 4 1 1 2 3 2 4 4 1 4 4
## 12791 12792 12793 12794 12795 12797 12802 12808 12809 12811 12812 12814 12815
## 4 3 4 3 3 4 3 1 3 1 4 4 3
## 12816 12817 12820 12821 12822 12823 12824 12826 12827 12828 12829 12831 12832
## 4 4 1 4 3 1 3 2 1 1 4 4 4
## 12833 12834 12836 12837 12838 12840 12842 12843 12844 12845 12849 12851 12852
## 3 4 3 4 4 3 3 2 4 1 3 4 4
## 12853 12854 12855 12856 12857 12863 12864 12865 12866 12867 12868 12871 12872
## 2 3 4 2 3 3 4 3 3 2 1 4 4
## 12873 12875 12878 12879 12881 12882 12883 12884 12885 12886 12888 12890 12891
## 3 4 3 1 4 3 1 4 3 3 4 3 1
## 12893 12895 12897 12902 12904 12906 12908 12909 12910 12912 12913 12915 12916
## 4 4 4 4 4 3 3 3 2 1 3 4 3
## 12917 12919 12920 12922 12923 12924 12925 12928 12929 12930 12933 12935 12936
## 3 1 4 3 4 1 4 1 4 4 1 2 1
## 12937 12938 12940 12942 12944 12945 12947 12948 12949 12950 12951 12952 12953
## 1 4 3 1 4 3 1 2 2 3 1 1 4
## 12955 12956 12957 12962 12963 12965 12966 12968 12970 12974 12976 12977 12981
## 2 4 2 4 2 3 4 4 1 4 3 4 4
## 12982 12984 12985 12987 12988 12990 12991 12993 12994 12995 12997 12999 13000
## 3 4 3 4 3 1 4 1 1 4 1 1 1
## 13002 13003 13005 13006 13008 13011 13012 13014 13015 13016 13017 13021 13023
## 4 4 4 4 4 4 2 2 3 1 4 2 4
## 13026 13028 13029 13030 13032 13033 13034 13035 13037 13038 13040 13043 13044
## 1 4 3 3 3 4 4 3 1 1 4 3 3
## 13045 13046 13047 13048 13049 13052 13055 13058 13059 13060 13061 13062 13064
## 4 4 2 3 4 4 3 1 4 4 4 4 1
## 13065 13066 13067 13068 13070 13072 13077 13079 13080 13082 13083 13085 13091
## 4 4 4 4 4 4 1 1 4 2 4 4 4
## 13092 13095 13097 13099 13101 13103 13104 13106 13107 13108 13109 13110 13115
## 1 4 2 4 4 4 1 4 1 4 3 2 3
## 13116 13117 13118 13120 13121 13122 13126 13127 13130 13131 13132 13133 13134
## 3 2 1 4 4 3 2 4 4 1 4 4 3
## 13136 13137 13138 13139 13140 13141 13142 13144 13145 13146 13147 13149 13153
## 3 2 1 3 1 3 4 4 1 4 1 3 3
## 13155 13157 13158 13159 13160 13161 13162 13165 13166 13167 13168 13169 13170
## 1 3 1 1 4 4 3 3 3 1 1 3 4
## 13171 13173 13176 13177 13178 13182 13183 13184 13185 13186 13187 13188 13189
## 1 4 3 4 2 4 2 2 4 3 4 4 4
## 13192 13193 13194 13196 13198 13200 13203 13207 13208 13209 13210 13211 13212
## 3 4 4 3 3 1 1 4 1 2 4 3 1
## 13213 13216 13217 13218 13220 13221 13223 13226 13227 13228 13229 13232 13233
## 1 4 1 4 1 3 4 4 4 4 4 2 4
## 13236 13238 13239 13240 13242 13243 13244 13245 13246 13247 13248 13249 13253
## 3 1 4 1 1 3 4 3 2 1 4 1 3
## 13255 13256 13258 13259 13260 13261 13262 13265 13268 13270 13271 13272 13273
## 4 4 1 4 3 3 4 3 2 3 4 4 4
## 13276 13277 13278 13279 13280 13282 13283 13284 13285 13291 13292 13294 13295
## 4 1 3 4 1 3 4 4 3 4 4 3 4
## 13296 13297 13298 13299 13300 13301 13302 13304 13305 13307 13308 13309 13310
## 4 3 4 4 3 1 4 4 2 4 3 1 3
## 13311 13313 13314 13317 13318 13320 13321 13322 13323 13324 13325 13327 13329
## 4 1 1 2 1 1 4 4 1 2 3 2 3
## 13330 13332 13336 13338 13341 13343 13345 13347 13348 13349 13350 13351 13352
## 3 4 3 3 3 4 3 4 4 4 3 3 3
## 13354 13355 13356 13357 13358 13359 13362 13363 13364 13366 13368 13369 13370
## 3 3 3 3 3 3 3 3 4 4 4 4 3
## 13372 13375 13376 13379 13381 13382 13384 13385 13388 13389 13390 13391 13394
## 3 3 1 1 3 4 2 3 4 1 3 4 2
## 13395 13396 13397 13398 13402 13403 13404 13405 13410 13411 13414 13416 13417
## 4 3 1 3 4 4 4 1 1 4 3 3 4
## 13419 13420 13425 13426 13427 13428 13429 13430 13431 13434 13435 13436 13437
## 4 4 3 2 1 4 1 4 3 4 2 4 2
## 13439 13441 13447 13448 13449 13450 13451 13452 13453 13455 13456 13460 13461
## 4 4 3 3 4 2 3 4 4 3 2 4 3
## 13462 13464 13466 13467 13470 13471 13473 13474 13475 13476 13477 13479 13481
## 4 3 4 3 4 3 4 4 1 3 1 4 1
## 13482 13483 13484 13485 13486 13487 13489 13491 13492 13493 13494 13495 13496
## 4 4 4 3 3 1 1 2 3 4 4 1 4
## 13497 13499 13500 13502 13503 13504 13506 13507 13508 13509 13510 13512 13513
## 4 1 3 1 4 4 4 3 4 2 3 4 4
## 13514 13515 13516 13517 13518 13519 13520 13521 13522 13523 13524 13525 13527
## 4 1 3 3 3 4 3 3 4 3 1 4 2
## 13529 13531 13532 13533 13536 13538 13539 13544 13546 13548 13549 13551 13557
## 4 4 4 1 2 2 1 4 1 4 2 4 4
## 13558 13560 13561 13562 13563 13564 13565 13566 13568 13569 13570 13573 13575
## 1 4 4 3 3 3 4 3 4 4 4 4 1
## 13577 13579 13581 13583 13584 13587 13588 13589 13590 13591 13592 13593 13594
## 3 4 4 3 4 3 2 4 2 3 1 1 3
## 13596 13598 13600 13601 13602 13603 13606 13607 13610 13611 13614 13615 13617
## 4 4 4 4 3 4 1 3 2 3 3 3 1
## 13618 13621 13623 13626 13627 13629 13630 13631 13632 13634 13636 13637 13638
## 4 4 1 4 1 2 2 2 3 1 1 1 4
## 13642 13643 13644 13645 13647 13649 13650 13651 13652 13654 13655 13656 13657
## 4 1 3 4 3 4 2 4 3 2 3 4 4
## 13658 13659 13662 13663 13666 13667 13669 13670 13672 13673 13675 13678 13681
## 3 3 1 4 4 4 4 4 4 4 4 4 1
## 13682 13684 13685 13686 13690 13692 13697 13699 13700 13703 13704 13705 13706
## 4 4 2 4 4 3 4 4 2 4 2 1 4
## 13707 13708 13710 13711 13712 13715 13716 13717 13718 13719 13720 13721 13722
## 3 4 4 4 4 1 4 1 4 1 1 3 3
## 13723 13725 13726 13727 13728 13730 13731 13732 13735 13736 13737 13739 13740
## 4 2 3 4 1 3 4 3 3 3 4 4 4
## 13741 13743 13744 13745 13747 13748 13750 13751 13752 13753 13754 13755 13758
## 1 2 3 4 4 1 1 4 1 3 4 2 2
## 13759 13760 13761 13762 13764 13769 13771 13772 13774 13778 13780 13781 13782
## 4 4 3 4 3 2 3 3 4 4 4 4 1
## 13784 13786 13787 13790 13791 13792 13799 13800 13801 13803 13804 13805 13806
## 2 4 4 4 3 4 4 3 4 4 2 3 4
## 13807 13808 13810 13811 13812 13813 13814 13816 13817 13819 13821 13822 13823
## 4 1 3 1 1 1 3 4 4 3 4 4 3
## 13824 13826 13827 13828 13831 13832 13833 13835 13837 13838 13841 13842 13844
## 1 4 1 4 2 4 3 1 4 1 4 2 4
## 13845 13846 13848 13849 13856 13858 13859 13860 13862 13863 13865 13866 13867
## 4 1 3 3 1 4 4 1 2 4 1 4 1
## 13869 13870 13873 13874 13875 13876 13877 13882 13883 13884 13885 13886 13887
## 3 2 1 3 1 4 4 1 3 1 4 4 4
## 13888 13889 13890 13892 13894 13895 13897 13898 13899 13900 13901 13904 13908
## 4 3 2 1 1 3 4 4 4 1 3 4 3
## 13911 13914 13917 13918 13922 13923 13924 13925 13926 13927 13928 13929 13930
## 2 4 4 3 4 4 2 1 4 4 1 3 4
## 13931 13932 13933 13936 13937 13938 13939 13940 13946 13947 13948 13949 13950
## 3 4 4 3 4 4 1 1 1 4 4 2 1
## 13951 13953 13954 13955 13956 13959 13960 13962 13963 13967 13971 13972 13973
## 1 2 4 4 1 1 4 4 1 4 2 4 4
## 13974 13975 13976 13978 13980 13982 13984 13986 13988 13989 13990 13991 13992
## 3 2 4 4 4 3 1 4 3 3 4 1 4
## 13993 13994 13995 14000 14001 14002 14004 14005 14006 14009 14012 14013 14014
## 2 2 1 3 3 4 2 3 1 4 4 1 3
## 14019 14020 14021 14022 14023 14024 14027 14029 14030 14032 14034 14035 14036
## 3 4 1 3 4 4 4 4 2 2 1 1 3
## 14037 14038 14039 14041 14044 14045 14046 14047 14048 14050 14052 14053 14054
## 4 3 4 4 1 3 4 1 3 3 4 4 4
## 14055 14059 14064 14066 14067 14068 14071 14073 14075 14076 14077 14078 14079
## 3 4 1 4 4 4 2 4 1 4 1 1 3
## 14080 14081 14082 14083 14087 14089 14090 14093 14098 14099 14100 14102 14104
## 4 3 4 2 4 4 4 3 4 2 4 1 4
## 14107 14108 14109 14111 14112 14113 14114 14116 14117 14121 14124 14126 14127
## 2 4 4 1 2 3 4 1 4 3 3 1 1
## 14128 14129 14130 14132 14133 14138 14139 14140 14141 14142 14143 14147 14148
## 4 1 3 2 1 3 3 3 1 4 4 4 4
## 14149 14150 14152 14154 14155 14157 14158 14159 14161 14162 14163 14165 14167
## 3 4 4 3 4 4 3 2 3 4 3 4 1
## 14171 14173 14174 14176 14177 14178 14179 14184 14185 14188 14193 14195 14196
## 4 1 4 1 1 2 3 3 4 2 3 3 4
## 14198 14199 14201 14204 14205 14206 14208 14209 14210 14211 14214 14215 14216
## 1 4 1 4 4 4 4 2 2 2 1 2 3
## 14218 14219 14220 14221 14222 14223 14224 14226 14227 14229 14231 14232 14233
## 4 4 4 2 3 1 1 3 2 3 1 1 1
## 14234 14235 14236 14237 14238 14239 14240 14241 14242 14243 14246 14247 14248
## 1 3 4 4 4 2 3 4 4 2 3 4 4
## 14250 14251 14256 14257 14259 14261 14262 14264 14265 14267 14270 14271 14272
## 3 3 3 3 4 3 2 4 4 3 3 4 4
## 14273 14276 14280 14284 14285 14287 14288 14289 14290 14291 14292 14293 14295
## 1 3 4 4 3 1 3 1 3 2 2 1 4
## 14297 14299 14300 14301 14304 14305 14307 14309 14311 14312 14314 14315 14317
## 1 2 4 3 3 3 2 2 4 1 4 2 3
## 14320 14321 14323 14326 14327 14329 14331 14332 14333 14334 14335 14336 14338
## 4 1 4 4 4 3 4 1 3 2 4 3 4
## 14339 14340 14341 14342 14344 14345 14346 14348 14349 14350 14351 14352 14353
## 4 4 2 1 2 4 3 3 4 4 4 1 4
## 14354 14355 14356 14357 14359 14360 14362 14364 14368 14371 14373 14375 14377
## 4 4 4 4 1 3 4 2 4 4 4 4 4
## 14379 14381 14382 14383 14385 14386 14387 14388 14389 14390 14393 14395 14396
## 4 4 3 3 1 4 3 2 3 2 4 2 4
## 14400 14403 14404 14406 14407 14408 14409 14410 14412 14413 14414 14416 14418
## 3 1 1 4 2 2 2 2 3 4 2 4 3
## 14419 14420 14421 14422 14423 14424 14426 14427 14428 14431 14432 14434 14436
## 1 3 3 3 4 4 2 4 1 3 2 1 4
## 14437 14438 14440 14441 14443 14446 14447 14448 14449 14450 14451 14452 14453
## 4 4 3 3 1 1 1 4 1 1 4 4 4
## 14456 14457 14460 14461 14462 14463 14465 14466 14467 14470 14472 14473 14474
## 2 4 1 3 2 1 1 2 1 4 2 4 3
## 14475 14476 14477 14479 14480 14481 14482 14483 14484 14485 14487 14489 14491
## 1 4 1 4 4 4 2 4 4 4 1 3 4
## 14493 14494 14495 14496 14497 14498 14499 14500 14501 14502 14503 14504 14505
## 3 4 4 4 3 1 1 1 4 2 3 1 2
## 14506 14507 14508 14511 14512 14513 14514 14515 14517 14518 14520 14522 14523
## 1 1 4 1 4 1 1 2 4 4 4 1 4
## 14524 14525 14528 14529 14530 14532 14533 14536 14537 14538 14539 14540 14541
## 2 2 4 1 2 1 2 4 4 4 4 1 2
## 14542 14546 14547 14548 14549 14550 14551 14552 14553 14554 14555 14557 14561
## 4 3 2 4 4 3 4 4 1 3 4 3 1
## 14565 14567 14569 14570 14572 14573 14576 14577 14578 14581 14582 14583 14584
## 3 3 4 4 2 2 4 1 4 4 4 1 1
## 14585 14586 14587 14589 14591 14592 14593 14594 14595 14597 14598 14600 14601
## 4 4 2 4 1 1 1 4 1 3 4 3 4
## 14603 14608 14609 14616 14618 14619 14620 14621 14622 14623 14624 14625 14626
## 3 3 1 1 1 3 4 1 4 1 4 3 3
## 14628 14629 14631 14632 14633 14636 14638 14639 14640 14641 14642 14643 14644
## 4 3 1 4 4 4 3 2 2 4 4 4 3
## 14645 14647 14649 14651 14652 14653 14655 14656 14657 14658 14659 14660 14661
## 4 4 1 4 4 2 3 4 1 4 2 4 4
## 14662 14664 14665 14666 14669 14670 14672 14673 14675 14676 14681 14682 14684
## 1 4 1 4 3 4 3 1 3 2 1 4 1
## 14687 14689 14690 14691 14692 14693 14696 14697 14698 14699 14700 14701 14703
## 3 4 4 3 1 4 2 4 1 4 3 2 4
## 14704 14705 14708 14710 14711 14712 14713 14714 14715 14716 14719 14720 14722
## 2 4 3 1 2 1 2 4 1 4 1 1 4
## 14723 14725 14727 14729 14730 14731 14732 14737 14738 14739 14740 14741 14744
## 1 3 4 4 2 1 2 3 2 2 3 1 2
## 14745 14747 14748 14752 14753 14754 14755 14756 14757 14758 14759 14760 14761
## 1 4 1 3 3 4 2 3 3 1 3 4 4
## 14762 14764 14765 14766 14768 14770 14772 14775 14776 14778 14779 14780 14782
## 4 4 1 2 4 3 4 1 2 3 1 4 4
## 14784 14785 14788 14789 14790 14792 14793 14794 14795 14798 14799 14801 14803
## 4 4 4 4 1 4 4 2 4 1 4 4 1
## 14804 14805 14806 14808 14810 14813 14815 14816 14817 14818 14819 14820 14821
## 4 1 4 2 2 4 3 4 3 1 4 1 4
## 14823 14824 14828 14829 14830 14834 14836 14837 14840 14841 14842 14844 14847
## 1 1 3 1 4 1 4 3 4 2 3 3 4
## 14850 14851 14852 14853 14854 14855 14856 14857 14859 14860 14861 14862 14863
## 4 4 2 4 2 4 3 3 1 4 4 3 4
## 14865 14867 14868 14869 14870 14871 14873 14875 14878 14880 14881 14882 14883
## 4 1 2 3 4 1 3 3 2 1 4 4 1
## 14885 14886 14888 14889 14890 14891 14893 14894 14896 14897 14898 14901 14902
## 3 4 3 4 4 4 3 3 4 1 1 2 4
## 14903 14904 14905 14907 14908 14910 14912 14913 14915 14916 14920 14921 14923
## 3 3 4 2 4 1 3 1 4 1 3 3 3
## 14924 14929 14946 14947 14948 14950 14951 14952 14953 14954 14957 14958 14959
## 4 4 4 4 1 3 4 2 4 4 4 1 1
## 14960 14961 14962 14963 14964 14965 14966 14967 14968 14970 14971 14972 14973
## 4 2 4 1 4 4 4 3 4 3 3 4 3
## 14974 14975 14976 14978 14981 14984 14985 14987 14988 14995 14997 14998 15000
## 4 4 1 1 4 4 4 4 4 4 1 4 3
## 15002 15006 15007 15009 15010 15012 15014 15016 15017 15018 15019 15021 15022
## 3 3 4 3 4 4 4 4 4 1 4 2 1
## 15023 15024 15025 15026 15027 15028 15030 15031 15033 15034 15035 15036 15038
## 2 2 3 1 1 1 4 1 2 2 4 1 1
## 15041 15042 15043 15045 15047 15048 15049 15050 15051 15052 15053 15054 15057
## 4 4 3 3 4 1 4 3 3 4 1 4 3
## 15058 15059 15060 15062 15063 15065 15067 15068 15070 15071 15073 15074 15075
## 2 2 1 1 3 3 3 4 4 3 1 3 3
## 15079 15081 15083 15087 15088 15089 15090 15091 15092 15093 15095 15096 15097
## 1 1 4 4 3 2 3 3 4 3 1 4 4
## 15099 15100 15101 15103 15104 15105 15106 15107 15109 15110 15111 15114 15115
## 3 1 4 4 3 2 1 1 3 1 3 2 4
## 15116 15117 15118 15119 15120 15121 15122 15124 15127 15128 15129 15130 15132
## 1 1 4 4 4 4 3 4 3 1 2 4 1
## 15133 15134 15135 15136 15139 15140 15142 15143 15145 15146 15147 15148 15149
## 1 2 4 1 4 2 3 4 1 3 3 4 3
## 15150 15153 15154 15156 15157 15158 15160 15163 15164 15165 15167 15168 15172
## 2 4 4 1 3 3 4 4 1 3 4 4 1
## 15174 15175 15178 15179 15180 15181 15182 15184 15185 15186 15192 15193 15197
## 4 4 4 3 4 1 4 4 4 4 1 3 1
## 15198 15199 15201 15203 15204 15205 15206 15208 15210 15211 15212 15213 15214
## 4 1 1 2 4 4 1 1 4 3 4 4 2
## 15215 15216 15218 15219 15220 15221 15222 15223 15224 15225 15226 15227 15230
## 1 4 2 4 2 3 3 3 4 3 4 1 4
## 15232 15234 15236 15237 15238 15239 15240 15241 15243 15244 15246 15247 15252
## 4 4 4 1 1 3 1 2 4 4 4 4 3
## 15253 15254 15256 15257 15258 15260 15261 15262 15263 15264 15265 15266 15267
## 1 4 4 4 4 2 4 4 4 3 3 4 1
## 15269 15270 15272 15274 15275 15276 15277 15279 15280 15281 15286 15287 15288
## 3 2 3 3 3 4 4 4 4 2 4 4 3
## 15289 15292 15296 15297 15299 15300 15303 15304 15306 15307 15308 15312 15313
## 1 4 3 1 2 3 3 2 3 4 4 1 4
## 15314 15315 15316 15318 15319 15320 15322 15325 15326 15327 15329 15330 15332
## 4 4 4 4 4 4 3 4 4 4 1 3 3
## 15334 15335 15339 15342 15343 15344 15345 15346 15347 15348 15349 15350 15351
## 1 4 4 3 4 1 3 4 4 4 4 4 2
## 15353 15355 15356 15360 15361 15363 15364 15365 15366 15367 15368 15370 15374
## 3 4 2 3 3 4 3 2 4 3 3 2 4
## 15376 15379 15380 15381 15384 15385 15386 15389 15392 15393 15394 15395 15396
## 3 2 1 4 4 4 3 3 1 4 3 4 4
## 15397 15398 15399 15400 15402 15405 15406 15407 15408 15410 15411 15412 15414
## 4 3 1 1 4 4 4 1 4 2 1 4 1
## 15415 15417 15419 15421 15422 15423 15424 15426 15427 15428 15429 15432 15433
## 3 3 4 1 4 4 4 1 3 4 4 4 4
## 15434 15435 15436 15437 15438 15440 15442 15443 15444 15445 15447 15448 15449
## 1 4 3 4 4 1 3 2 3 4 4 3 1
## 15450 15452 15453 15454 15456 15457 15458 15460 15462 15463 15466 15467 15468
## 3 1 2 4 1 4 4 4 1 4 4 1 4
## 15469 15471 15472 15473 15475 15478 15483 15488 15489 15491 15492 15493 15494
## 4 3 3 2 3 3 1 4 3 2 4 1 3
## 15497 15500 15503 15504 15505 15506 15507 15508 15510 15511 15512 15514 15516
## 3 1 4 4 3 1 3 1 4 1 4 2 4
## 15517 15518 15520 15521 15522 15523 15524 15525 15526 15527 15528 15529 15530
## 4 2 4 2 4 3 3 1 4 2 4 2 1
## 15532 15533 15535 15537 15539 15540 15541 15543 15544 15545 15549 15550 15551
## 3 1 1 4 3 4 4 4 2 4 3 1 3
## 15552 15553 15554 15556 15557 15561 15562 15563 15565 15567 15568 15569 15571
## 4 3 4 4 3 1 4 1 4 4 1 1 1
## 15572 15573 15574 15577 15578 15579 15582 15584 15585 15587 15589 15592 15593
## 2 4 1 1 4 4 1 1 3 1 1 3 4
## 15594 15596 15597 15598 15599 15602 15603 15604 15605 15606 15607 15608 15609
## 1 1 4 4 3 2 4 4 1 2 4 1 4
## 15610 15612 15618 15619 15620 15621 15622 15623 15624 15625 15626 15628 15630
## 4 4 1 4 3 1 2 4 1 1 4 2 3
## 15632 15634 15636 15637 15639 15641 15643 15644 15645 15646 15648 15649 15651
## 2 4 3 4 3 3 1 1 3 1 4 3 1
## 15652 15653 15654 15655 15656 15657 15658 15659 15660 15661 15663 15664 15667
## 4 3 3 3 1 4 1 4 2 4 4 3 4
## 15668 15669 15670 15671 15673 15674 15675 15677 15678 15679 15680 15681 15683
## 4 1 4 2 3 3 1 3 4 1 3 1 4
## 15687 15689 15690 15691 15692 15695 15696 15699 15700 15701 15703 15704 15705
## 2 4 4 4 4 4 2 4 4 1 4 3 4
## 15706 15707 15708 15709 15712 15713 15714 15716 15717 15720 15721 15722 15723
## 1 1 2 4 1 4 4 1 4 3 3 3 4
## 15724 15725 15727 15729 15730 15732 15733 15734 15737 15739 15740 15743 15744
## 4 3 3 4 3 4 4 3 2 3 4 1 4
## 15745 15746 15747 15748 15750 15752 15753 15754 15755 15756 15757 15758 15759
## 1 4 1 4 2 2 4 1 2 1 3 4 1
## 15762 15763 15764 15766 15768 15773 15774 15775 15776 15777 15780 15781 15783
## 4 3 2 4 1 3 4 4 4 1 1 1 4
## 15785 15787 15789 15790 15793 15795 15796 15797 15799 15800 15801 15802 15803
## 3 1 4 4 1 3 2 3 1 4 1 3 3
## 15806 15807 15809 15810 15811 15812 15813 15814 15815 15819 15820 15821 15822
## 1 1 1 1 2 1 3 3 3 3 4 4 3
## 15823 15825 15826 15829 15830 15831 15834 15835 15836 15837 15839 15840 15841
## 4 3 3 4 3 1 3 1 4 3 1 4 1
## 15843 15844 15845 15847 15850 15852 15853 15855 15857 15858 15860 15861 15862
## 4 4 2 4 4 4 4 1 4 1 2 2 1
## 15863 15864 15865 15866 15869 15870 15872 15874 15877 15880 15881 15882 15883
## 4 2 1 4 4 4 4 2 4 4 1 1 4
## 15885 15886 15888 15889 15891 15894 15895 15897 15898 15899 15900 15901 15903
## 1 4 4 4 3 4 4 4 1 4 4 1 3
## 15904 15906 15907 15909 15910 15912 15916 15917 15918 15919 15920 15921 15922
## 4 2 1 4 2 4 2 4 4 4 1 4 3
## 15923 15925 15930 15932 15933 15935 15937 15938 15940 15942 15944 15945 15948
## 4 4 3 2 3 4 4 1 4 4 4 4 3
## 15949 15950 15951 15952 15953 15957 15958 15963 15965 15967 15969 15970 15973
## 4 3 3 1 2 3 4 4 1 4 1 4 4
## 15974 15975 15976 15977 15980 15981 15983 15984 15985 15986 15987 15988 15990
## 2 3 4 3 3 2 1 2 3 4 2 4 3
## 15992 15993 15994 15996 15998 16003 16005 16006 16007 16008 16009 16010 16012
## 4 2 3 1 3 3 1 4 3 1 1 1 3
## 16014 16015 16016 16017 16018 16019 16020 16022 16023 16024 16025 16026 16027
## 1 1 2 4 4 2 1 3 1 4 3 4 1
## 16030 16031 16034 16036 16037 16038 16040 16042 16043 16045 16048 16049 16050
## 4 4 1 3 1 1 3 1 1 1 4 3 4
## 16052 16053 16054 16055 16056 16057 16059 16062 16063 16065 16066 16070 16071
## 4 3 3 4 3 2 1 1 4 3 1 3 4
## 16072 16073 16076 16078 16079 16080 16081 16083 16084 16085 16086 16091 16092
## 3 4 2 4 3 4 3 3 3 1 1 4 1
## 16093 16094 16096 16097 16098 16099 16102 16103 16104 16105 16106 16107 16109
## 4 1 4 4 2 1 3 1 4 4 4 2 4
## 16110 16112 16113 16114 16115 16116 16117 16119 16120 16121 16122 16123 16124
## 3 1 4 4 2 3 4 4 1 3 1 4 4
## 16125 16127 16128 16131 16134 16135 16136 16139 16140 16141 16142 16143 16144
## 4 3 1 3 4 3 1 1 3 3 3 2 4
## 16145 16146 16147 16148 16149 16150 16153 16156 16157 16159 16160 16162 16163
## 2 1 3 4 4 1 1 2 1 4 3 4 3
## 16164 16169 16170 16171 16172 16173 16174 16175 16177 16178 16179 16181 16183
## 1 3 2 4 1 1 1 1 4 4 4 4 4
## 16184 16185 16188 16189 16190 16193 16198 16200 16201 16202 16203 16204 16205
## 1 4 1 4 4 4 3 3 3 4 1 3 1
## 16206 16207 16208 16209 16211 16212 16213 16214 16215 16217 16218 16221 16224
## 1 3 4 3 3 4 4 1 4 4 2 1 1
## 16225 16226 16227 16229 16230 16232 16233 16235 16236 16239 16242 16243 16244
## 1 1 4 3 4 1 1 1 3 4 2 4 3
## 16245 16247 16248 16249 16250 16255 16256 16257 16261 16265 16266 16268 16271
## 3 4 4 1 4 2 3 4 1 2 1 4 1
## 16272 16274 16275 16278 16279 16282 16283 16284 16287 16292 16293 16295 16297
## 3 4 3 3 3 4 1 3 4 4 2 1 4
## 16298 16302 16305 16306 16308 16309 16311 16313 16315 16316 16317 16318 16319
## 1 4 4 1 3 3 4 4 4 2 3 4 3
## 16320 16321 16322 16323 16324 16325 16327 16330 16332 16337 16338 16339 16340
## 3 1 4 4 1 1 3 1 2 4 4 4 3
## 16341 16342 16343 16344 16345 16347 16348 16349 16350 16351 16352 16354 16356
## 3 1 4 4 3 3 2 4 1 4 4 4 1
## 16357 16358 16359 16360 16361 16362 16363 16364 16365 16366 16367 16368 16369
## 1 3 2 3 1 1 4 3 2 4 3 4 3
## 16370 16372 16374 16376 16377 16378 16379 16383 16384 16385 16386 16387 16389
## 1 4 4 3 3 1 3 4 4 1 4 4 1
## 16392 16394 16395 16399 16400 16402 16403 16404 16405 16406 16407 16409 16411
## 4 1 1 4 4 4 4 3 4 4 2 1 4
## 16412 16413 16414 16415 16416 16418 16419 16423 16424 16425 16426 16427 16429
## 4 4 4 4 1 1 1 4 4 4 2 4 4
## 16430 16431 16432 16433 16434 16438 16440 16441 16442 16444 16445 16447 16448
## 4 1 4 4 2 1 3 4 1 1 4 4 4
## 16449 16450 16451 16454 16455 16456 16457 16460 16461 16462 16463 16464 16466
## 3 4 4 4 2 3 4 1 4 4 1 3 2
## 16468 16469 16470 16471 16473 16474 16475 16477 16478 16479 16480 16482 16483
## 4 1 1 4 1 2 1 2 1 4 3 4 4
## 16484 16485 16488 16491 16493 16495 16496 16497 16498 16499 16500 16503 16504
## 4 4 1 3 1 1 3 2 4 4 1 1 3
## 16505 16506 16509 16510 16511 16513 16515 16516 16517 16518 16519 16520 16526
## 3 4 4 4 1 1 1 4 4 4 4 1 4
## 16527 16528 16529 16531 16533 16535 16536 16539 16542 16545 16546 16549 16550
## 4 4 3 2 3 3 3 1 4 4 3 2 3
## 16551 16552 16554 16555 16556 16557 16560 16561 16565 16566 16567 16569 16570
## 1 4 1 4 2 4 3 4 4 1 3 4 2
## 16571 16572 16573 16574 16581 16582 16583 16584 16586 16587 16589 16591 16593
## 3 1 4 3 4 4 4 3 3 4 1 4 1
## 16594 16595 16596 16597 16598 16600 16601 16602 16603 16609 16610 16611 16612
## 4 4 4 4 4 1 4 3 4 3 4 4 1
## 16613 16614 16616 16617 16618 16619 16620 16621 16623 16624 16625 16627 16628
## 3 3 4 4 3 4 4 1 4 3 4 4 3
## 16629 16633 16634 16637 16638 16639 16641 16642 16643 16644 16647 16648 16650
## 4 2 4 1 2 3 4 4 3 3 4 4 3
## 16653 16654 16655 16657 16658 16659 16660 16665 16666 16667 16668 16669 16670
## 3 1 3 1 4 4 1 4 4 4 1 3 2
## 16671 16674 16676 16679 16680 16681 16682 16685 16686 16688 16689 16690 16692
## 3 4 3 4 4 2 1 4 2 1 4 4 3
## 16693 16696 16697 16706 16708 16709 16710 16711 16712 16714 16715 16716 16717
## 4 1 4 1 3 3 2 1 2 3 4 3 3
## 16718 16719 16720 16721 16723 16725 16726 16727 16728 16730 16732 16734 16735
## 3 2 4 4 4 1 1 4 1 1 3 1 3
## 16737 16738 16739 16742 16743 16744 16747 16748 16750 16752 16753 16755 16756
## 3 4 4 3 2 2 3 1 1 4 4 3 4
## 16757 16758 16759 16761 16762 16763 16765 16766 16767 16768 16769 16770 16771
## 4 3 1 4 3 3 4 3 2 1 3 1 3
## 16773 16774 16775 16776 16777 16778 16780 16781 16784 16788 16789 16790 16791
## 4 1 2 3 4 4 4 4 4 4 4 1 2
## 16792 16793 16794 16795 16796 16801 16803 16804 16805 16806 16807 16808 16809
## 4 4 2 3 4 3 4 1 4 1 3 4 1
## 16810 16811 16812 16813 16816 16817 16818 16820 16823 16824 16825 16826 16828
## 4 4 3 2 1 2 2 3 4 4 3 4 4
## 16829 16830 16832 16833 16834 16835 16836 16837 16838 16841 16842 16846 16847
## 4 4 1 1 3 4 4 2 4 2 3 4 4
## 16848 16849 16850 16851 16852 16855 16856 16858 16859 16861 16863 16866 16869
## 4 4 4 1 4 4 4 3 3 4 4 1 1
## 16871 16872 16875 16877 16878 16880 16881 16882 16883 16884 16885 16887 16889
## 2 1 3 1 4 2 3 1 4 4 1 4 3
## 16891 16892 16893 16895 16897 16898 16899 16900 16903 16905 16906 16907 16909
## 1 1 4 4 4 1 1 1 3 2 1 1 3
## 16910 16912 16913 16914 16915 16916 16917 16918 16919 16921 16924 16926 16927
## 2 2 4 4 1 4 3 1 2 4 1 4 1
## 16929 16930 16932 16933 16934 16936 16938 16942 16943 16947 16948 16949 16950
## 2 1 4 4 3 4 3 2 1 3 1 1 3
## 16951 16952 16953 16954 16955 16956 16957 16959 16960 16961 16963 16965 16966
## 3 4 4 2 1 4 4 4 1 4 4 4 2
## 16967 16968 16969 16971 16976 16978 16979 16980 16982 16983 16985 16987 16988
## 4 4 1 4 4 4 2 3 3 2 2 2 4
## 16989 16990 16992 16996 16997 16998 16999 17001 17002 17004 17006 17007 17010
## 1 4 1 1 1 1 4 2 3 3 1 1 4
## 17011 17014 17015 17018 17019 17022 17024 17025 17026 17027 17029 17030 17031
## 4 1 3 3 1 4 4 1 4 1 3 4 4
## 17033 17034 17035 17038 17040 17041 17042 17043 17045 17046 17047 17048 17049
## 1 1 4 4 3 1 1 3 1 3 3 1 2
## 17050 17051 17052 17053 17054 17058 17059 17060 17061 17062 17063 17064 17069
## 2 4 3 3 1 3 3 4 2 1 2 1 2
## 17070 17071 17073 17075 17076 17078 17079 17080 17081 17083 17085 17086 17088
## 4 2 1 1 1 4 4 4 4 3 1 2 3
## 17090 17091 17092 17094 17095 17096 17097 17100 17101 17102 17105 17109 17110
## 2 2 3 4 3 1 2 3 3 4 4 1 4
## 17111 17114 17115 17117 17118 17119 17120 17122 17123 17124 17125 17126 17128
## 4 2 1 4 4 4 4 4 4 4 4 1 4
## 17131 17133 17134 17135 17138 17140 17142 17144 17146 17147 17148 17152 17153
## 3 2 4 2 3 3 3 3 1 3 4 3 4
## 17154 17155 17157 17158 17159 17160 17162 17163 17164 17165 17166 17169 17171
## 4 4 4 3 3 3 2 4 2 4 4 3 4
## 17172 17173 17174 17175 17176 17179 17180 17181 17183 17186 17187 17188 17189
## 4 2 4 1 4 1 1 4 3 4 4 2 4
## 17190 17191 17193 17194 17198 17201 17203 17204 17205 17206 17211 17212 17213
## 4 2 2 4 1 4 3 3 3 4 2 4 2
## 17214 17217 17218 17219 17221 17222 17223 17226 17227 17228 17229 17230 17231
## 1 4 2 4 4 4 4 3 1 2 4 2 2
## 17232 17233 17234 17235 17236 17237 17239 17242 17245 17247 17248 17250 17251
## 4 4 4 4 1 4 3 3 4 4 4 4 4
## 17252 17253 17254 17255 17256 17259 17262 17263 17265 17266 17267 17268 17272
## 4 4 4 4 4 4 1 4 4 1 4 1 3
## 17274 17277 17278 17279 17282 17284 17286 17287 17288 17289 17290 17291 17293
## 4 3 4 4 3 1 4 2 2 1 4 3 2
## 17295 17297 17298 17299 17301 17302 17303 17309 17311 17312 17314 17320 17321
## 1 4 4 1 4 1 4 4 3 1 2 3 4
## 17323 17324 17325 17329 17330 17331 17333 17334 17337 17339 17341 17343 17344
## 2 1 4 4 4 4 3 4 3 4 1 4 4
## 17345 17347 17348 17349 17350 17351 17356 17357 17358 17359 17360 17361 17362
## 1 4 1 4 1 1 4 4 4 4 1 1 4
## 17364 17365 17367 17368 17370 17371 17372 17373 17374 17375 17376 17379 17382
## 2 2 4 2 1 1 2 1 4 1 4 3 4
## 17383 17384 17385 17386 17387 17388 17391 17392 17394 17397 17398 17400 17403
## 4 4 4 2 3 1 4 4 4 4 1 3 4
## 17405 17406 17408 17409 17410 17411 17412 17414 17415 17418 17420 17422 17423
## 1 3 4 3 1 1 2 3 3 4 1 2 4
## 17425 17427 17429 17430 17431 17432 17433 17434 17436 17438 17440 17442 17446
## 3 4 1 4 3 4 4 2 4 3 1 2 4
## 17447 17449 17451 17453 17454 17455 17456 17457 17458 17459 17460 17461 17462
## 4 2 2 4 1 4 4 1 4 4 1 1 4
## 17463 17464 17466 17468 17469 17470 17472 17475 17480 17481 17483 17486 17489
## 1 4 3 4 1 1 1 4 3 1 1 3 4
## 17490 17491 17492 17495 17496 17498 17499 17500 17501 17502 17503 17504 17505
## 2 2 3 4 4 4 3 3 4 1 4 2 3
## 17506 17507 17508 17509 17510 17512 17513 17514 17515 17516 17517 17519 17520
## 4 4 3 2 4 2 3 4 1 1 4 2 3
## 17521 17522 17523 17524 17525 17526 17527 17528 17530 17531 17534 17535 17536
## 1 1 1 4 3 1 1 2 2 4 4 4 4
## 17537 17538 17540 17542 17545 17548 17549 17550 17551 17552 17554 17555 17556
## 3 4 4 4 1 4 4 1 4 1 1 4 4
## 17557 17560 17561 17562 17564 17566 17567 17569 17571 17572 17573 17574 17578
## 1 1 4 2 1 3 2 4 1 1 1 4 4
## 17579 17580 17582 17584 17585 17588 17589 17590 17591 17593 17594 17595 17596
## 1 1 4 3 1 3 3 3 2 3 3 4 2
## 17600 17601 17603 17604 17608 17609 17612 17614 17615 17616 17618 17619 17620
## 4 4 3 4 4 1 2 3 1 1 1 4 4
## 17621 17623 17624 17625 17628 17629 17630 17631 17633 17634 17636 17637 17639
## 3 3 3 3 4 2 4 1 1 2 4 4 4
## 17640 17642 17643 17644 17646 17647 17648 17650 17651 17653 17654 17655 17656
## 3 3 4 2 1 4 3 4 2 1 4 2 1
## 17658 17660 17663 17664 17666 17667 17668 17669 17670 17671 17673 17674 17676
## 4 4 2 4 3 1 4 2 4 3 1 4 1
## 17678 17680 17682 17684 17685 17691 17692 17693 17694 17695 17696 17697 17698
## 4 4 2 4 2 4 1 4 4 3 2 4 4
## 17700 17701 17702 17703 17704 17705 17707 17708 17709 17711 17712 17714 17715
## 3 3 3 1 3 2 4 4 4 4 3 4 4
## 17716 17718 17720 17722 17723 17724 17725 17731 17732 17733 17734 17736 17737
## 2 4 1 3 2 1 2 1 4 4 1 1 4
## 17738 17739 17742 17744 17746 17747 17749 17750 17752 17754 17758 17759 17760
## 3 2 4 2 4 4 4 2 4 1 2 1 4
## 17761 17763 17764 17765 17767 17768 17769 17770 17771 17772 17774 17775 17777
## 3 4 3 1 4 3 2 1 4 4 1 4 1
## 17779 17781 17783 17785 17786 17787 17788 17789 17791 17793 17795 17796 17797
## 1 4 4 4 4 3 3 4 4 4 4 1 1
## 17799 17800 17802 17805 17806 17812 17813 17816 17817 17819 17824 17827 17828
## 2 2 3 3 3 1 1 1 1 2 4 1 3
## 17830 17831 17832 17835 17836 17837 17838 17839 17843 17848 17849 17852 17854
## 1 4 4 1 4 2 3 4 4 2 1 4 4
## 17855 17856 17859 17860 17861 17862 17863 17864 17866 17867 17869 17871 17873
## 4 1 4 4 2 4 2 1 4 1 1 4 1
## 17874 17877 17878 17879 17880 17881 17883 17884 17885 17886 17887 17888 17889
## 1 4 3 4 3 4 1 1 4 1 4 2 4
## 17890 17891 17892 17893 17894 17895 17896 17897 17898 17899 17900 17901 17904
## 4 4 1 4 2 4 4 1 4 4 4 4 4
## 17905 17906 17908 17911 17912 17913 17914 17917 17921 17923 17924 17925 17926
## 1 4 4 4 1 4 4 1 1 4 2 4 4
## 17928 17929 17930 17931 17932 17934 17935 17936 17937 17939 17940 17941 17942
## 4 1 1 4 3 4 4 3 2 4 2 4 4
## 17946 17947 17948 17950 17951 17955 17956 17957 17958 17960 17962 17964 17966
## 4 4 4 1 1 1 4 4 3 4 4 4 1
## 17967 17968 17969 17970 17972 17973 17974 17976 17977 17978 17979 17980 17984
## 4 4 4 3 4 4 1 4 4 4 1 1 4
## 17985 17986 17987 17988 17990 17991 17994 17995 17997 17999 18001 18004 18005
## 3 4 4 1 1 4 1 4 2 4 4 4 4
## 18006 18008 18009 18010 18011 18013 18014 18015 18016 18017 18018 18019 18022
## 3 2 4 4 4 4 4 4 1 1 4 4 3
## 18024 18027 18030 18032 18033 18034 18035 18036 18037 18040 18042 18043 18044
## 4 4 4 4 4 4 1 1 1 4 4 1 2
## 18045 18048 18050 18053 18055 18056 18058 18059 18061 18062 18064 18066 18067
## 4 4 4 4 2 4 4 1 2 1 3 4 3
## 18068 18069 18071 18072 18074 18075 18077 18078 18080 18081 18082 18084 18085
## 4 1 4 4 3 2 2 4 3 1 3 4 4
## 18086 18088 18093 18094 18095 18096 18097 18099 18101 18104 18105 18106 18108
## 4 4 3 2 4 1 2 4 4 3 4 3 4
## 18110 18112 18113 18114 18116 18117 18119 18120 18121 18122 18123 18125 18126
## 4 4 4 4 2 4 4 4 4 2 4 1 4
## 18127 18129 18130 18135 18136 18138 18142 18143 18145 18146 18147 18149 18150
## 1 4 1 1 1 4 3 3 3 4 4 1 1
## 18151 18154 18155 18156 18158 18159 18160 18161 18164 18165 18167 18168 18169
## 4 4 1 3 4 3 4 1 3 4 3 1 4
## 18170 18171 18173 18174 18176 18177 18178 18179 18180 18181 18183 18184 18185
## 1 1 3 4 3 1 3 2 2 3 4 4 4
## 18188 18189 18190 18191 18193 18196 18200 18202 18203 18204 18205 18209 18210
## 3 3 4 4 4 4 4 3 4 3 4 4 2
## 18211 18212 18213 18215 18216 18217 18218 18219 18220 18221 18222 18224 18226
## 1 4 4 4 3 4 4 2 4 1 3 4 2
## 18227 18228 18230 18231 18232 18233 18235 18236 18237 18239 18240 18242 18245
## 4 3 2 1 1 3 3 1 1 1 3 3 2
## 18246 18248 18249 18250 18252 18255 18257 18259 18260 18261 18262 18263 18265
## 4 3 4 4 4 4 2 3 2 4 4 3 3
## 18268 18269 18270 18272 18273 18274 18276 18277 18278 18280 18281 18282 18287
## 4 4 4 2 1 4 4 4 4 4 4 4 3
##
## Within cluster sum of squares by cluster:
## [1] 372.4234 521.1263 749.8502 554.4539
## (between_SS / total_SS = 70.8 %)
##
## Available components:
##
## [1] "cluster" "centers" "totss" "withinss" "tot.withinss"
## [6] "betweenss" "size" "iter" "ifault"Conclusión
Primero, se tuvo que analizar que variables se tenían que tener en cuenta para generar los clusters. Ya que es un supermercado, se tenía en cuenta la frecuencia y el total del ticket, y así crear estrategias para atacar ese tipo de segmento de mercado.
En la gráfica se puede observar que se crearon 4 segmentos: Clientes casuales (negro), clientes poco frecuentes pero gastan mucho (azul), Clientes regulares (rojo) y clientes leales (verdes). Un ejemplo de estrategia podría ser crear un programa de lealtad (por ejemplo, puntos por compra) y así retener los clientes leales y atraer a los clientes casuales.
Paso 5. Plan de ejecución.
El plan de ejecución es elaborar diferentes técnicas de mercadotecnia para poder atraer y/o mantener a su mercado actual.
LS0tCnRpdGxlOiA8c3BhbiBzdHlsZT0iQ29sb3I6R3JlZW4iPiAiSy1tZWFuc19DbHVzdGVyaW5nLVN1cGVybWVyY2FkbyIKYXV0aG9yOiAiRGFuYSBQZXJleiAtIEEwMDIyNzA0MSIKZGF0ZTogIjkvMjAvMjAyMiIKb3V0cHV0OiAKICBodG1sX2RvY3VtZW50OiAKICAgIHRvYzogdHJ1ZQogICAgdG9jX2Zsb2F0OiB0cnVlCiAgICBjb2RlX2Rvd25sb2FkOiB0cnVlCi0tLQoKPGltZyBzcmM9Ii9Vc2Vycy9kYW5uYXBlcmV6L0Rlc2t0b3AvaW1hZ2VuZXMgcGFyYSBIVE1ML0Rpc2Vuby1zaW4tdGl0dWxvLTcucG5nIj4KCiMgSGVycm1pZW50YSAiRWwgR2VuZXJhZG9yIGRlIFZhbG9yIGRlIERhdG9zIgoqUGFzbyAxLiBEZWZpbmlyIGVsIMOhcmVhIGRlbCBuZWdvY2lvIHF1ZSBidXNjYW1vcyBpbXBhY3RhciBvIG1lam9yYXIgeSBzdSBLUEkqICAKRW4gZXN0ZSBjYXNvIHNlIGJ1c2NhIGFncnVwYXIgYSBsb3MgY2xpZW50ZXMgY29uZm9ybWUgYSBkb3MgdmFyaWFibGVzOiBmcmVjdWVuY2lhIGRlIHZpc2l0YSB5IGVsIHRvdGFsIHF1ZSBzZSBnYXN0YSBjYWRhIGNsaWVudGUuIENvbiBlc3RvIHNlIGJ1c2NhIG1lam9yYXIgbGFzIHZlbnRhcyBhdGFjYW5kbyBhIGNhZGEgc2VnbWVudG8gY29uIHVuYSB0w6ljbmljYSBkaWZlcmVudGUuIEtQSTogQ29tcHJhcyBwb3IgQ3VzdG9tZXIgSUQKCipQYXNvIDIuIFNlbGVjY2lvbmFyIHBsYW50aWxsYSgtcykgcGFyYSBjcmVhciB2YWxvciBhIHBhcnRpciBkZSBsb3MgZGF0b3MgZGUgbG9zIGNsaWVudGVzLiogICAgCioqVmlzacOzbioqIC8gKipTZWdtZW50YWNpw7NuKiogLyBQZXJzb25hbGl6YWNpw7NuIC8gQ29udGV4dHVhbGl6YWNpw7NuICAKCipQYXNvIDMuIEdlbmVyYXIgaWRlYXMgbyBjb25jZXB0b3MgZXNwZWPDrWZpY29zLiogICAKwr9DdcOhbnRvcyBzZWdtZW50b3Mgc2UgZ2VuZXJhbj8Kwr9RdcOpIHRpcG8gZGUgY2xpZW50ZXMgc2UgdGllbmUgZW4gYmFzZSBhIGxvcyBkYXRvcz8Kwr9Dw7NtbyBpZGVhciBlc3RyYXRlZ2lhcyBwYXJhIGF1bWVudGFyIHN1IGNvbnN1bW8gbyBtYW50ZW5lciBzdSBsZWFsdGFkIGhhY2lhIGxhIGVtcHJlc2E/CgoqUGFzbyA0LiBSZXVuaXIgbG9zIGRhdG9zIHJlcXVlcmlkb3MuKiAgICAKQ3VzdG9tZXIgSUQsIGNvbXByYXMgcG9yIEN1c3RvbWVyIElELCBuw7ptZXJvIGRlIHRpY2tldCwgdmlzaXRhcy4KCiMgSW1wb3J0YXIgYmFzZSBkZSBkYXRvcwpgYGB7cn0KI2ZpbGUuY2hvb3NlKCkKYmQgPC0gcmVhZC5jc3YoIi9Vc2Vycy9kYW5uYXBlcmV6L0Rlc2t0b3AvUi9iYXNlcyBkZSBkYXRvcy92ZW50YXNfYmllbi5jc3YiKQpzdW1tYXJ5KGJkKQoKbGlicmFyeShkcGx5cikKYGBgCgojIEFncmVnYXIgdG90YWwKYGBge3J9CmJkJHRvdGFsIDwtIGJkJFByaWNlICogYmQkUXVhbnRpdHkKc3RyKGJkKQpgYGAKCiMgT2J0ZW5lciBlbCB0b3RhbCBwb3IgdGlja2V0LCBhZ3JlZ2FuZG8gZWwgY2xpZW50ZQpgYGB7cn0KYmQxIDwtIGJkCmJkMSA8LSBhZ2dyZWdhdGUodG90YWwgfiBDdXN0b21lcklEICsgQmlsbE5vLCBkYXRhID0gYmQxLCBzdW0pCmBgYAoKIyBPYnRlbmVyIGVsIHRpY2tldCBwcm9tZWRpbyBwb3IgY2xpZW50ZQpgYGB7cn0KYmQyIDwtIGJkMQpiZDIgPC0gYWdncmVnYXRlKHRvdGFsIH4gQ3VzdG9tZXJJRCwgZGF0YSA9IGJkMSwgbWVhbikKYGBgCgojIE9idGVuZXIgdmlzaXRhcyBhbCBzdXBlcm1lcmNhZG8gcG9yIGNsaWVudGUKYGBge3J9CmJkMyA8LSBiZDEKYmQzIDwtIGdyb3VwX2J5KGJkMSxDdXN0b21lcklEKSAlPiUgc3VtbWFyaXNlIChWaXNpdGFzID0gbl9kaXN0aW5jdChCaWxsTm8pKQpgYGAKCiMgSnVudGFyIGJhc2UgZGUgZGF0b3MKYGBge3J9CmJkNCA8LSBtZXJnZShiZDIsYmQzLGJ5PSJDdXN0b21lcklEIikKYGBgCgojIEV4cG9ydGFyIGNzdiAKYGBge3J9CndyaXRlLmNzdihiZDQsImRhdG9zX2NsaWVudGVzLmNzdiIsIHJvdy5uYW1lcyA9IEZBTFNFKQpgYGAKCiMgSW1wb3J0YXIgbGEgYmFzZSBkZSBkYXRvcwpgYGB7cn0KI2ZpbGUuY2hvb3NlKCkKYmQ1IDwtIHJlYWQuY3N2KCIvVXNlcnMvZGFubmFwZXJlei9EZXNrdG9wL1IvYmFzZXMgZGUgZGF0b3MvZGF0b3NfY2xpZW50ZXMuY3N2IikKc3VtbWFyeShiZDUpCmBgYAoKIyBBZ3JlZ2FyIGxlIEN1c3RvbWVyIElEIGNvbW8gbm9tYnJlIGRlIGxvcyByZW5nbG9uZXMKYGBge3J9CmJkNiA8LSBiZDUKcm93bmFtZXMoYmQ2KSA8LSBiZDYkQ3VzdG9tZXJJRCAKYGBgCgojIEVsaW1pbmFyIGxhIGNvbHVtbmEgZGUgY3VzdG9tZXIgaWQKYGBge3J9CmJkNyA8LSBiZDYKYmQ3IDwtIHN1YnNldChiZDcsIHNlbGVjdCA9IC1jIChDdXN0b21lcklEICkpCmBgYAoKIyBSZXZpc2FyIHByZXNlbmNpYSBkZSBkYXRvcyBhbm9ybWFsZXMKYGBge3J9CiAgc3VtbWFyeShiZDcpCnBsb3QoYmQ3JHRvdGFsLGJkNyRWaXNpdGFzKQpgYGAKCkxvcyBkYXRvcyBmdWVyYSBkZSBsbyBub3JtYWwgZXN0w6FuIGZ1ZXJhIGRlIGxvcyBzaWd1aWVudGVzIGzDrW1pdGVzOiAgCmzDrW1pdGUgaW5mZXJpb3IgPSBRMSAtIDEuNSpJUVIgIApsw61taXRlIHN1cGVyaW9yID0gUTMgKyAxLjUqSVFSICAKUTEgOiBjdWFydGlsIDEsIFEzIDogY3VhcnRpbCAzLCBJUVIgOiBSYW5nbyBpbnRlcmN1YXJ0aWwgPSBRMyAtIFExICAKCiMgQ2FsY3VsYXIgZWwgbMOtbWl0ZSBzdXBlcmlvciBkZWwgdG90YWwKYGBge3J9Cmlxcl90b3RhbCA8LSBJUVIoYmQ3JHRvdGFsKQpsaW1pdGVfc3VwZXJpb3JfdG90YWwgPC0gNDI2LjYzICsgMS41Kmlxcl90b3RhbApsaW1pdGVfc3VwZXJpb3JfdG90YWwKYGBgCgojIENvbnNlcnZhciBzb2xvIGxvcyB0aWNrZXRzIHByb21lZGlvcyBtZW5vcmVzIGEgODAwCmBgYHtyfQpiZDggPC0gYmQ3CmJkOCA8LSBiZDhbYmQ4JHRvdGFsIDwgODAwLCBdCnN1bW1hcnkoYmQ4KQpgYGAKCiMgQ2FsY3VsYXIgZWwgbMOtbWl0ZSBzdXBlcmlvciBkZSBsYXMgdmlzaXRhcwpgYGB7cn0KaXFyX3Zpc2l0YXMgPC0gSVFSKGJkNyRWaXNpdGFzKQpsaW1pdGVfc3VwZXJpb3JfdmlzaXRhcyA8LSA1ICsgMS41Kmlxcl92aXNpdGFzCmxpbWl0ZV9zdXBlcmlvcl92aXNpdGFzCmBgYAoKIyBDb25zZXJ2YXIgc29sbyBsb3MgdGlja2V0cyBwcm9tZWRpb3MgbWVub3JlcyBhIDEyCmBgYHtyfQpiZDkgPC0gYmQ4CmJkOSA8LSBiZDlbYmQ5JFZpc2l0YXMgPCAxMiwgXQpzdW1tYXJ5KGJkOSkKcGxvdChiZDkkdG90YWwsYmQ5JFZpc2l0YXMpCmBgYAoKIyBLLW1lYW5zIGNsdXN0ZXJpbmcKCiMjIFBhc28gMS4gTm9ybWFsaXphciB2YXJpYWJsZXMgCmBgYHtyfQpiZDEwIDwtIGJkOQpiZDEwIDwtIGFzLmRhdGEuZnJhbWUoc2NhbGUoYmQxMCkpCgpwbG90KGJkMTAkdG90YWwsIGJkMTAkVmlzaXRhcykKYGBgCgojIyBQYXNvMi4gay0gbWVhbnMgY2x1c3RlcmluZwpgYGB7cn0Kc2VnbWVudG9zIDwtIGttZWFucyhiZDEwLCAzKQpzZWdtZW50b3MKCmFzaWduYWNpb24gPC0gY2JpbmQoYmQ5LCBjbHVzdGVyID0gc2VnbWVudG9zJGNsdXN0ZXIpCmhlYWQoYXNpZ25hY2lvbiwxMCkKYGBgCgojIyBQYXNvIDMuIEV4cG9ydGFyIGNzdgpgYGB7cn0Kd3JpdGUuY3N2KGFzaWduYWNpb24sICJjbGllbnRlc19zZWdlbWVudGFkb3MuY3N2IikKYGBgCgojIyBQYXNvIDQuIFZpc3VhbGl6YXIgc2VnbWVudG9zIApgYGB7cn0KI2luc3RhbGwucGFja2FnZXMoImZhY3RvZXh0cmEiKQpsaWJyYXJ5KGZhY3RvZXh0cmEpCmZ2aXpfY2x1c3RlcihzZWdtZW50b3MsIGRhdGEgPSBiZDEwLAogICAgICAgICAgICAgcGFsZXR0ZT1jKCJyZWQiLCAiYmx1ZSIsICJibGFjayIsICJkYXJrZ3JlZW4iKSwKICAgICAgICAgICAgIGVsbGlzZS50eXBlID0gImV1Y2xpZCIsCiAgICAgICAgICAgICBzdGFyLnBsb3QgPSBULAogICAgICAgICAgICAgcmVwZWwgPSBULAogICAgICAgICAgICAgZ2d0aGVtZSA9IHRoZW1lKCkpCmxpYnJhcnkoImNsdXN0ZXIiKQpgYGAKCiMjIFBhc28gNS4gT3B0aW1pemFyIGsgCmBgYHtyfQpzZXQuc2VlZCgxMjMpCm9wdGltaXphY2lvbiA8LSBjbHVzR2FwKGJkMTAsIEZVTiA9IGttZWFucywgbnN0YXJ0ID0gMjUsIEsubWF4ID0gMTAsIEIgPSA1MCkKcGxvdChvcHRpbWl6YWNpb24sIHhsYWIgPSAiTnVtZXJvIGRlIGNsdXN0ZXJzIGsiKQoKYGBgCgojIyBQYXNvIDYuIENsdXN0ZXJzIG9wdGltaXphZG9zIApgYGB7cn0Kc2VnbWVudG9zIDwtIGttZWFucyhiZDEwLCA0KQpzZWdtZW50b3MKCmBgYAoKIyBDb25jbHVzacOzbgpQcmltZXJvLCBzZSB0dXZvIHF1ZSBhbmFsaXphciBxdWUgdmFyaWFibGVzIHNlIHRlbsOtYW4gcXVlIHRlbmVyIGVuIGN1ZW50YSBwYXJhIGdlbmVyYXIgbG9zIGNsdXN0ZXJzLiBZYSBxdWUgZXMgdW4gc3VwZXJtZXJjYWRvLCBzZSB0ZW7DrWEgZW4gY3VlbnRhIGxhIGZyZWN1ZW5jaWEgeSBlbCB0b3RhbCBkZWwgdGlja2V0LCB5IGFzw60gY3JlYXIgZXN0cmF0ZWdpYXMgcGFyYSBhdGFjYXIgZXNlIHRpcG8gZGUgc2VnbWVudG8gZGUgbWVyY2Fkby4gIApFbiBsYSBncsOhZmljYSBzZSBwdWVkZSBvYnNlcnZhciBxdWUgc2UgY3JlYXJvbiA0IHNlZ21lbnRvczogQ2xpZW50ZXMgY2FzdWFsZXMgKG5lZ3JvKSwgY2xpZW50ZXMgcG9jbyBmcmVjdWVudGVzIHBlcm8gZ2FzdGFuIG11Y2hvIChhenVsKSwgQ2xpZW50ZXMgcmVndWxhcmVzIChyb2pvKSB5IGNsaWVudGVzIGxlYWxlcyAodmVyZGVzKS4gVW4gZWplbXBsbyBkZSBlc3RyYXRlZ2lhIHBvZHLDrWEgc2VyIGNyZWFyIHVuIHByb2dyYW1hIGRlIGxlYWx0YWQgKHBvciBlamVtcGxvLCBwdW50b3MgcG9yIGNvbXByYSkgeSBhc8OtIHJldGVuZXIgbG9zIGNsaWVudGVzIGxlYWxlcyB5IGF0cmFlciBhIGxvcyBjbGllbnRlcyBjYXN1YWxlcy4KCipQYXNvIDUuIFBsYW4gZGUgZWplY3VjacOzbi4qICAKRWwgcGxhbiBkZSBlamVjdWNpw7NuIGVzIGVsYWJvcmFyIGRpZmVyZW50ZXMgdMOpY25pY2FzIGRlIG1lcmNhZG90ZWNuaWEgcGFyYSBwb2RlciBhdHJhZXIgeS9vIG1hbnRlbmVyIGEgc3UgbWVyY2FkbyBhY3R1YWwuIAo=