duplicated(sale_report$User_ID) %>% table() #### 5891 unique customer ## .
## FALSE TRUE
## 5891 531686table(sale_report$Product_ID)##
## P00000142 P00000242 P00000342 P00000442 P00000542 P00000642 P00000742
## 1130 371 238 92 146 512 238
## P00000842 P00000942 P00001042 P00001142 P00001242 P00001342 P00001442
## 36 54 494 572 99 61 83
## P00001542 P00001642 P00001742 P00001842 P00001942 P00002042 P00002142
## 68 349 449 76 209 91 728
## P00002242 P00002342 P00002442 P00002542 P00002642 P00002742 P00002842
## 195 66 325 532 62 39 83
## P00002942 P00003042 P00003142 P00003242 P00003342 P00003442 P00003542
## 219 37 87 830 2 951 35
## P00003642 P00003742 P00003842 P00003942 P00004042 P00004142 P00004242
## 503 4 16 730 12 118 113
## P00004342 P00004442 P00004542 P00004642 P00004742 P00004842 P00004942
## 93 143 275 90 591 207 19
## P00005042 P00005142 P00005242 P00005342 P00005442 P00005542 P00005642
## 955 224 4 26 25 4 47
## P00005742 P00005842 P00005942 P00006042 P00006142 P00006242 P00006342
## 269 5 180 36 291 60 39
## P00006442 P00006542 P00006642 P00006742 P00006842 P00006942 P00007042
## 89 57 2 27 187 495 43
## P00007142 P00007242 P00007342 P00007442 P00007542 P00007642 P00007742
## 46 121 67 5 78 18 31
## P00007842 P00007942 P00008042 P00008142 P00008242 P00008342 P00008442
## 64 28 88 50 19 14 106
## P00008542 P00008642 P00008742 P00008842 P00008942 P00009042 P00009142
## 124 47 107 105 1 44 47
## P00009242 P00009342 P00009442 P00009542 P00009642 P00009742 P00010042
## 109 349 7 28 3 24 26
## P00010142 P00010242 P00010342 P00010442 P00010542 P00010642 P00010742
## 21 348 201 8 131 4 1331
## P00010842 P00010942 P00011042 P00011142 P00011242 P00011342 P00011442
## 662 303 31 6 25 40 35
## P00011542 P00011642 P00011742 P00011842 P00011942 P00012042 P00012142
## 5 3 19 90 62 5 183
## P00012242 P00012342 P00012442 P00012542 P00012742 P00012842 P00012942
## 51 1 7 5 9 42 1
## P00013142 P00013242 P00013342 P00013442 P00013542 P00013642 P00013742
## 71 7 3 1 1 67 350
## P00013842 P00013942 P00014042 P00014142 P00014242 P00014342 P00014442
## 1 233 193 9 105 10 23
## P00014542 P00014642 P00014742 P00014842 P00014942 P00015042 P00015142
## 665 313 36 407 92 48 32
## P00015242 P00015342 P00015442 P00015542 P00015642 P00015742 P00015842
## 103 144 58 291 410 237 265
## P00015942 P00016042 P00016142 P00016242 P00016342 P00016442 P00016542
## 203 442 29 2 190 62 157
## P00016642 P00016742 P00016842 P00016942 P00017042 P00017142 P00017242
## 50 259 309 43 127 126 67
## P00017342 P00017442 P00017542 P00017642 P00017742 P00017842 P00017942
## 11 27 242 49 33 17 13
## P00018042 P00018142 P00018242 P00018342 P00018442 P00018542 P00018642
## 296 108 60 105 9 49 43
## P00018742 P00018842 P00018942 P00019042 P00019142 P00019242 P00019342
## 2 94 119 71 310 8 327
## P00019442 P00019542 P00019642 P00019742 P00019842 P00019942 P00020042
## 60 5 18 13 111 106 46
## P00020142 P00020242 P00020342 P00020442 P00020542 P00020642 P00020742
## 48 115 350 31 20 22 7
## P00020842 P00020942 P00021042 P00021142 P00021242 P00021342 P00021442
## 63 15 79 184 40 110 10
## P00021542 P00021642 P00021742 P00021842 P00021942 P00022042 P00022142
## 17 176 762 199 138 1 74
## P00022242 P00022342 P00022442 P00022542 P00022642 P00022742 P00022842
## 10 68 183 365 180 126 88
## P00022942 P00023042 P00023142 P00023242 P00023342 P00023442 P00023542
## 516 180 152 17 92 20 14
## P00023642 P00023742 P00023842 P00023942 P00024042 P00024142 P00024242
## 45 4 6 6 387 259 77
## P00024342 P00024442 P00024542 P00024642 P00024742 P00024842 P00024942
## 149 15 10 188 408 18 40
## P00025042 P00025142 P00025242 P00025342 P00025442 P00025542 P00025642
## 116 55 72 54 1586 163 96
## P00025742 P00025842 P00025942 P00026042 P00026142 P00026242 P00026342
## 13 2 429 374 72 32 27
## P00026442 P00026542 P00026642 P00026742 P00026842 P00026942 P00027042
## 37 34 206 133 10 38 123
## P00027142 P00027242 P00027342 P00027442 P00027542 P00027642 P00027742
## 87 22 22 119 132 104 8
## P00027842 P00027942 P00028042 P00028142 P00028242 P00028342 P00028442
## 1 7 371 90 95 28 411
## P00028542 P00028642 P00028742 P00028842 P00028942 P00029042 P00029142
## 488 18 12 1172 14 13 75
## P00029242 P00029342 P00029442 P00029542 P00029642 P00029742 P00029842
## 359 26 45 212 22 74 186
## P00029942 P00030042 P00030142 P00030242 P00030442 P00030542 P00030642
## 113 108 25 2 55 27 154
## P00030742 P00030842 P00030942 P00031042 P00031142 P00031242 P00031342
## 77 586 356 1168 140 19 35
## P00031442 P00031542 P00031642 P00031742 P00031842 P00031942 P00032042
## 104 16 32 32 190 81 544
## P00032142 P00032242 P00032342 P00032442 P00032542 P00032642 P00032742
## 78 13 84 229 64 21 12
## P00032842 P00032942 P00033042 P00033142 P00033242 P00033342 P00033442
## 379 118 378 43 17 269 21
## P00033542 P00033642 P00033742 P00033842 P00033942 P00034042 P00034142
## 408 237 66 27 227 573 273
## P00034242 P00034342 P00034442 P00034542 P00034642 P00034742 P00034842
## 141 65 395 39 136 1188 670
## P00034942 P00035042 P00035142 P00035242 P00035342 P00035442 P00035542
## 70 12 65 152 132 34 591
## P00035642 P00035742 P00035842 P00035942 P00036042 P00036142 P00036242
## 36 134 631 428 26 210 123
## P00036342 P00036442 P00036542 P00036642 P00036742 P00036842 P00036942
## 221 149 106 9 182 865 80
## P00037042 P00037142 P00037242 P00037342 P00037442 P00037542 P00037642
## 215 744 105 150 148 25 5
## P00037742 P00037842 P00037942 P00038042 P00038142 P00038242 P00038342
## 21 58 47 10 28 24 13
## P00038442 P00038542 P00038642 P00038742 P00038842 P00039142 P00039242
## 63 14 1 7 1 3 110
## P00039342 P00039442 P00039542 P00039642 P00039742 P00039842 P00039942
## 7 107 35 22 247 8 166
## P00040042 P00040142 P00040242 P00040342 P00040442 P00040542 P00040642
## 147 49 93 48 114 13 72
## P00040742 P00040842 P00040942 P00041042 P00041142 P00041242 P00041342
## 175 51 35 125 39 54 154
## P00041442 P00041542 P00041642 P00041742 P00041842 P00041942 P00042042
## 98 137 101 12 185 218 22
## P00042142 P00042242 P00042342 P00042442 P00042542 P00042742 P00042842
## 384 276 80 31 77 497 359
## P00042942 P00043042 P00043142 P00043242 P00043342 P00043442 P00043542
## 344 12 47 53 129 13 130
## P00043642 P00043742 P00043842 P00043942 P00044042 P00044142 P00044242
## 37 113 52 18 37 443 142
## P00044342 P00044442 P00044542 P00044642 P00044742 P00044842 P00044942
## 58 1099 43 68 20 47 13
## P00045042 P00045142 P00045242 P00045342 P00045442 P00045542 P00045642
## 26 113 56 300 26 200 40
## P00045742 P00045842 P00045942 P00046042 P00046142 P00046242 P00046342
## 20 319 22 88 513 159 21
## P00046442 P00046542 P00046642 P00046742 P00046842 P00046942 P00047042
## 112 10 78 1417 159 89 46
## P00047142 P00047242 P00047342 P00047442 P00047542 P00047642 P00047742
## 19 270 30 27 27 55 90
## P00047842 P00047942 P00048042 P00048142 P00048242 P00048342 P00048442
## 116 196 164 204 26 21 342
## P00048542 P00048642 P00048742 P00048842 P00048942 P00049042 P00049142
## 30 27 441 62 85 8 85
## P00049242 P00049342 P00049442 P00049542 P00049642 P00049742 P00049842
## 36 65 169 307 326 26 80
## P00049942 P00050042 P00050142 P00050242 P00050342 P00050442 P00050542
## 104 37 183 234 134 209 77
## P00050642 P00050742 P00050842 P00050942 P00051042 P00051142 P00051242
## 103 204 56 41 59 257 12
## P00051342 P00051442 P00051542 P00051642 P00051742 P00051842 P00051942
## 4 1233 40 409 1 185 214
## P00052042 P00052142 P00052242 P00052342 P00052442 P00052542 P00052642
## 107 141 158 30 112 175 534
## P00052742 P00052842 P00052942 P00053042 P00053142 P00053242 P00053342
## 89 968 114 354 72 1 197
## P00053442 P00053542 P00053642 P00053742 P00053842 P00053942 P00054042
## 67 70 81 93 559 290 291
## P00054142 P00054242 P00054342 P00054442 P00054542 P00054642 P00054742
## 12 346 72 1 81 2 4
## P00054842 P00054942 P00055042 P00055142 P00055242 P00055342 P00055442
## 7 260 11 28 31 5 9
## P00055542 P00055642 P00055742 P00055842 P00055942 P00056042 P00056142
## 15 57 10 17 2 14 87
## P00056242 P00056342 P00056442 P00056542 P00056642 P00056742 P00056842
## 63 1 27 1 1 27 68
## P00057042 P00057242 P00057342 P00057442 P00057542 P00057642 P00057742
## 11 222 356 618 716 1430 804
## P00057942 P00058042 P00058142 P00058242 P00058342 P00058442 P00058542
## 774 1396 396 578 276 546 4
## P00058642 P00058742 P00058942 P00059042 P00059142 P00059242 P00059342
## 131 16 20 28 121 49 1
## P00059442 P00059542 P00059642 P00059742 P00059842 P00059942 P00060042
## 1384 28 347 118 43 45 5
## P00060142 P00060242 P00060342 P00060442 P00060542 P00060642 P00060742
## 31 148 6 5 17 23 1
## P00060942 P00061042 P00061142 P00061242 P00061342 P00061442 P00061542
## 13 68 255 5 44 8 11
## P00061742 P00061842 P00061942 P00062042 P00062142 P00062342 P00062442
## 41 70 11 41 39 1 1
## P00062642 P00062742 P00062842 P00062942 P00063042 P00063242 P00063342
## 13 255 838 7 49 5 318
## P00063442 P00063542 P00063642 P00063742 P00063842 P00064042 P00064142
## 1 20 1 1 11 280 69
## P00064242 P00064342 P00064442 P00064542 P00064642 P00064742 P00064842
## 163 5 19 1 28 17 12
## P00064942 P00065042 P00065142 P00065242 P00065342 P00065442 P00065542
## 32 269 1 309 211 160 1
## P00065642 P00065742 P00065842 P00065942 P00066042 P00066142 P00066242
## 37 6 3 1 15 2 112
## P00066342 P00066442 P00066542 P00066642 P00066742 P00066842 P00066942
## 1 62 52 74 71 3 43
## P00067042 P00067142 P00067342 P00067442 P00067542 P00067642 P00067742
## 4 73 17 3 22 22 2
## P00067842 P00067942 P00068042 P00068142 P00068242 P00068342 P00068442
## 148 366 75 29 25 1 90
## P00068542 P00068642 P00068742 P00068842 P00068942 P00069042 P00069142
## 27 16 1 16 131 221 14
## P00069242 P00069342 P00069442 P00069542 P00069642 P00069742 P00069842
## 225 44 3 123 1 1 27
## P00069942 P00070042 P00070142 P00070242 P00070342 P00070442 P00070542
## 4 731 1 58 590 155 170
## P00070642 P00070742 P00070842 P00070942 P00071042 P00071142 P00071242
## 109 52 3 371 19 26 225
## P00071342 P00071442 P00071542 P00071642 P00071742 P00071842 P00071942
## 3 725 10 16 7 3 2
## P00072042 P00072142 P00072242 P00072342 P00072442 P00072542 P00072742
## 1 1 32 20 68 160 33
## P00072842 P00072942 P00073042 P00073142 P00073242 P00073342 P00073442
## 85 68 15 6 6 1 3
## P00073542 P00073642 P00073742 P00073842 P00073942 P00074042 P00074142
## 2 412 29 921 53 79 195
## P00074242 P00074342 P00074442 P00074542 P00074642 P00074742 P00074842
## 210 410 246 1 506 1 1
## P00075042 P00075142 P00075242 P00075342 P00075442 P00075542 P00075642
## 1 6 2 106 180 342 62
## P00075742 P00075842 P00075942 P00076042 P00076142 P00076242 P00076342
## 232 34 120 205 31 5 15
## P00076442 P00076542 P00076642 P00076742 P00076942 P00077042 P00077142
## 51 71 5 28 5 95 2
## P00077242 P00077342 P00077442 P00077542 P00077742 P00077842 P00077942
## 1 1 13 1 24 75 149
## P00078042 P00078142 P00078242 P00078342 P00078442 P00078542 P00078642
## 10 307 44 2 57 136 118
## P00078742 P00078842 P00078942 P00079042 P00079142 P00079342 P00079442
## 281 72 24 11 88 2 17
## P00079542 P00079642 P00079742 P00079842 P00079942 P00080042 P00080142
## 5 83 263 17 66 334 2
## P00080242 P00080342 P00080442 P00080542 P00080642 P00080742 P00080842
## 4 1186 1 7 147 17 8
## P00080942 P00081142 P00081242 P00081342 P00081442 P00081542 P00081642
## 9 334 13 1 28 25 1
## P00081742 P00081842 P00081942 P00082042 P00082242 P00082342 P00082442
## 5 28 10 13 136 165 36
## P00082542 P00082742 P00082842 P00082942 P00083042 P00083142 P00083242
## 30 21 53 2 24 1 102
## P00083342 P00083442 P00083542 P00083642 P00083742 P00083842 P00083942
## 82 35 1 26 48 300 410
## P00084042 P00084142 P00084242 P00084342 P00084442 P00084542 P00084642
## 193 102 372 481 553 198 102
## P00084742 P00084842 P00084942 P00085042 P00085142 P00085242 P00085342
## 60 729 225 423 172 893 542
## P00085442 P00085542 P00085642 P00085742 P00085842 P00085942 P00086042
## 334 196 232 38 95 945 614
## P00086142 P00086242 P00086342 P00086442 P00086542 P00086642 P00086742
## 161 268 613 956 5 212 36
## P00086842 P00086942 P00087042 P00087142 P00087242 P00087342 P00087442
## 225 52 235 110 100 214 169
## P00087542 P00087642 P00087742 P00087842 P00087942 P00088042 P00088142
## 44 63 21 99 6 201 47
## P00088242 P00088342 P00088442 P00088542 P00088642 P00088742 P00088842
## 169 103 51 143 92 105 73
## P00088942 P00089042 P00089142 P00089242 P00089342 P00089442 P00089542
## 128 150 203 145 393 200 207
## P00089642 P00089742 P00089842 P00089942 P00090042 P00090142 P00090242
## 26 20 6 34 8 15 7
## P00090342 P00090442 P00090542 P00090642 P00090742 P00090842 P00090942
## 33 30 151 4 8 386 569
## P00091042 P00091142 P00091242 P00091342 P00091442 P00091542 P00091642
## 21 148 5 44 3 1 28
## P00091742 P00091842 P00091942 P00092042 P00092142 P00092242 P00092342
## 1 59 2 2 46 15 2
## P00092442 P00092542 P00092642 P00092842 P00092942 P00093042 P00093142
## 123 22 43 28 103 10 6
## P00093242 P00093342 P00093442 P00093542 P00093642 P0009842 P0009942
## 251 136 17 56 154 65 128
## P00100042 P00100142 P00100342 P00100442 P00100542 P00100642 P00100742
## 19 64 2 710 12 423 202
## P00100842 P00100942 P00101042 P00101142 P00101242 P00101342 P00101442
## 705 502 227 70 86 359 67
## P00101542 P00101642 P00101742 P00101842 P00101942 P00102042 P00102142
## 204 7 384 633 610 188 404
## P00102242 P00102342 P00102442 P00102542 P00102642 P00102742 P00102842
## 376 668 301 165 1228 2 100
## P00102942 P00103042 P00103142 P00103242 P00103342 P00103442 P00103542
## 231 559 3 223 279 24 3
## P00103642 P00103742 P00103842 P00103942 P00104042 P00104142 P00104242
## 49 16 21 20 1 6 8
## P00104342 P00104442 P00104542 P00104642 P00104742 P00104842 P00104942
## 1 13 233 8 20 220 207
## P00105042 P00105142 P00105242 P00105342 P00105442 P00105542 P00105642
## 168 905 95 475 124 106 123
## P00105842 P00105942 P00106042 P00106142 P00106342 P00106442 P00106542
## 2 217 892 4 1 5 2
## P00106642 P00106742 P00106842 P00106942 P00107042 P00107142 P00107242
## 150 478 2 80 17 15 4
## P00107342 P00107442 P00107542 P00107642 P00107742 P00107842 P00107942
## 5 1 47 54 12 1 1
## P00108042 P00108142 P00108242 P00108342 P00108442 P00108542 P00108642
## 46 10 16 10 233 344 101
## P00108742 P00108842 P00108942 P00109042 P00109142 P00109242 P00109342
## 2 196 69 75 112 456 23
## P00109442 P00109542 P00109642 P00109742 P00109842 P00109942 P00110042
## 7 553 47 243 315 75 348
## P00110142 P00110242 P00110342 P00110442 P00110542 P00110642 P00110742
## 151 73 119 58 944 105 1591
## P00110842 P00110942 P00111042 P00111142 P00111242 P00111342 P00111442
## 1260 1336 493 1004 427 36 316
## P00111542 P00111642 P00111742 P00111842 P00111942 P00112042 P00112142
## 437 118 679 510 637 91 1539
## P00112242 P00112342 P00112442 P00112542 P00112642 P00112742 P00112842
## 121 286 906 1113 500 44 180
## P00112942 P00113042 P00113142 P00113242 P00113342 P00113442 P00113542
## 119 657 747 921 668 250 209
## P00113642 P00113742 P00113842 P00113942 P00114042 P00114142 P00114242
## 729 128 135 365 692 395 26
## P00114342 P00114442 P00114542 P00114642 P00114742 P00114842 P00114942
## 536 541 369 49 180 196 1162
## P00115042 P00115142 P00115242 P00115342 P00115442 P00115542 P00115642
## 34 578 177 366 197 471 706
## P00115742 P00115842 P00115942 P00116042 P00116142 P00116242 P00116342
## 285 398 525 137 627 282 254
## P00116442 P00116542 P00116642 P00116742 P00116842 P00116942 P00117042
## 23 314 257 599 966 163 296
## P00117142 P00117242 P00117342 P00117442 P00117542 P00117642 P00117742
## 372 375 133 1227 543 388 159
## P00117842 P00117942 P00118042 P00118142 P00118242 P00118342 P00118442
## 373 1346 334 341 82 245 396
## P00118542 P00118642 P00118742 P00118842 P00118942 P00119042 P00119142
## 487 182 636 103 149 106 511
## P00119242 P00119342 P00119442 P00119542 P00119642 P00119742 P00119842
## 237 304 432 137 387 608 96
## P00119942 P00120042 P00120142 P00120242 P00120342 P00120442 P00120542
## 112 892 320 343 622 136 295
## P00120642 P00120742 P00120842 P00120942 P00121042 P00121142 P00121242
## 241 227 391 171 194 437 165
## P00121342 P00121442 P00121542 P00121642 P00121742 P00121842 P00121942
## 749 57 79 841 24 4 16
## P00122042 P00122142 P00122342 P00122442 P00122542 P00122642 P00122742
## 4 2 15 510 284 15 29
## P00122842 P00122942 P00123042 P00123142 P00123242 P00123342 P00123442
## 12 12 25 201 12 18 59
## P00123542 P00123642 P00123742 P00123842 P00123942 P00124042 P00124142
## 29 64 397 203 12 27 29
## P00124242 P00124342 P00124442 P00124542 P00124642 P00124742 P00124842
## 342 102 36 150 388 198 311
## P00124942 P00125042 P00125142 P00125242 P00125342 P00125442 P00125542
## 89 249 131 10 228 18 53
## P00125642 P00125742 P00125842 P00125942 P00126042 P00126142 P00126242
## 103 149 42 714 306 635 132
## P00126342 P00126442 P00126542 P00126642 P00126742 P00126842 P00126942
## 1 87 48 54 1 28 54
## P00127042 P00127142 P00127242 P00127342 P00127442 P00127542 P00127642
## 195 3 590 431 529 340 747
## P00127742 P00127842 P00127942 P00128042 P00128142 P00128242 P00128342
## 490 596 522 306 204 458 169
## P00128442 P00128542 P00128642 P00128742 P00128942 P00129042 P00129142
## 63 6 2 242 926 193 117
## P00129242 P00129342 P00129442 P00129542 P00129642 P00129742 P00129842
## 69 557 116 733 763 151 587
## P00129942 P00130042 P00130142 P00130242 P00130342 P00130442 P00130542
## 37 33 55 80 35 248 12
## P00130642 P00130742 P00130842 P00130942 P00131042 P00131142 P00131242
## 480 540 199 47 207 14 30
## P00131342 P00131442 P00131542 P00131642 P00131742 P00131842 P00131942
## 85 15 146 18 74 4 12
## P00132042 P00132142 P00132242 P00132342 P00132442 P00132542 P00132642
## 140 7 82 12 31 35 168
## P00132742 P00132842 P00132942 P00133042 P00133142 P00133242 P00133342
## 1 123 60 1 2 3 13
## P00133442 P00133542 P00133642 P00133742 P00133842 P00133942 P00134042
## 171 22 40 250 36 6 72
## P00134142 P00134242 P00134342 P00134442 P00134542 P00134642 P00134742
## 96 25 242 6 77 43 12
## P00134842 P00134942 P00135042 P00135142 P00135242 P00135342 P00135442
## 28 147 13 212 51 114 15
## P00135542 P00135642 P00135742 P00135842 P00135942 P00136042 P00136142
## 80 62 405 80 1 2 23
## P00136242 P00136342 P00136442 P00136542 P00136642 P00136742 P00136842
## 24 84 43 286 16 300 131
## P00136942 P00137042 P00137142 P00137242 P00137342 P00137442 P00137542
## 29 85 64 358 4 88 152
## P00137642 P00137742 P00137842 P00137942 P00138042 P00138142 P00138242
## 25 17 8 6 26 14 26
## P00138342 P00138442 P00138542 P00138642 P00138742 P00138842 P00138942
## 79 214 588 9 6 92 9
## P00139042 P00139142 P00139242 P00139442 P00139542 P00139642 P00139742
## 21 17 8 10 415 2 101
## P00139842 P00139942 P00140042 P00140142 P00140242 P00140342 P00140442
## 29 655 190 2 6 4 29
## P00140542 P00140642 P00140742 P00140942 P00141042 P00141142 P00141242
## 22 45 781 17 3 4 15
## P00141342 P00141442 P00141542 P00141642 P00141742 P00141842 P00141942
## 3 49 212 3 7 126 127
## P00142042 P00142142 P00142242 P00142342 P00142442 P00142542 P00142642
## 4 702 38 27 17 1 10
## P00142742 P00142842 P00142942 P00143042 P00143142 P00143242 P00143342
## 37 18 500 3 67 1 201
## P00143442 P00143542 P00143642 P00143742 P00143842 P00143942 P00144042
## 1 2 329 23 22 9 254
## P00144142 P00144242 P00144342 P00144442 P00144542 P00144642 P00144742
## 3 464 18 24 12 732 8
## P00144842 P00144942 P00145042 P00145142 P00145242 P00145342 P00145442
## 7 1 1384 28 33 15 737
## P00145542 P00145642 P00145742 P00145842 P00145942 P00146042 P00146142
## 13 303 300 152 281 277 239
## P00146242 P00146342 P00146442 P00146542 P00146642 P00146742 P00146842
## 71 78 164 39 15 442 65
## P00146942 P00147042 P00147142 P00147242 P00147342 P00147442 P00147542
## 36 45 36 23 191 37 45
## P00147642 P00147742 P00147842 P00147942 P00148042 P00148142 P00148242
## 59 570 33 894 127 28 15
## P00148342 P00148442 P00148542 P00148642 P00148742 P00148842 P00148942
## 244 129 191 1179 202 215 45
## P00149042 P00149142 P00149242 P00149342 P00149442 P00149542 P00149642
## 3 59 25 472 47 142 61
## P00149742 P00149842 P00149942 P00150042 P00150142 P00150242 P00150342
## 1 23 11 136 261 2 544
## P00150442 P00150542 P00150642 P00150742 P00150842 P00150942 P00151042
## 49 633 37 141 253 431 48
## P00151142 P00151242 P00151342 P00151442 P00151542 P00151642 P00151742
## 58 106 112 21 10 2 583
## P00151842 P00151942 P00152042 P00152142 P00152242 P00152342 P00152442
## 49 46 4 7 60 5 106
## P00152542 P00152642 P00152742 P00152842 P00152942 P00153042 P00153142
## 45 12 382 2 103 6 60
## P00153242 P00153342 P00153442 P00153542 P00153642 P00153742 P00153842
## 19 19 39 11 179 606 560
## P00153942 P00154042 P00154142 P00154242 P00154342 P00154442 P00154542
## 5 615 20 242 14 235 71
## P00154642 P00154742 P00154842 P00154942 P00155042 P00155142 P00155242
## 562 123 26 2 54 175 170
## P00155342 P00155442 P00155542 P00155642 P00155742 P00155842 P00155942
## 124 418 12 199 252 14 16
## P00156042 P00156142 P00156242 P00156342 P00156442 P00156542 P00156642
## 90 148 160 28 820 86 1
## P00156742 P00156842 P00157042 P00157142 P00157242 P00157342 P00157442
## 339 115 7 261 4 208 3
## P00157542 P00157642 P00157842 P00157942 P00158042 P00158142 P00158242
## 823 475 16 71 118 7 388
## P00158342 P00158442 P00158542 P00158642 P00158742 P00158842 P00158942
## 92 38 592 39 111 151 23
## P00159042 P00159142 P00159242 P00159342 P00159442 P00159542 P00159642
## 3 6 40 36 503 487 7
## P00159742 P00159842 P00159942 P00160042 P00160142 P00160242 P00160342
## 31 117 104 199 18 25 53
## P00160442 P00160542 P00160642 P00160742 P00160842 P00160942 P00161042
## 28 105 128 1 10 169 13
## P00161142 P00161242 P00161342 P00161442 P00161542 P00161642 P00161742
## 27 139 2 495 290 4 4
## P00161842 P00161942 P00162042 P00162142 P00162242 P00162342 P00162442
## 121 792 108 2 49 25 263
## P00162542 P00162642 P00162742 P00162842 P00162942 P00163042 P00163142
## 11 79 1 3 90 27 107
## P00163242 P00163342 P00163442 P00163542 P00163642 P00163742 P00163842
## 197 64 336 96 8 17 182
## P00163942 P00164042 P00164142 P00164242 P00164342 P00164442 P00164642
## 4 26 14 1 67 6 105
## P00164742 P00164842 P00164942 P00165042 P00165142 P00165242 P00165442
## 13 55 18 20 50 19 355
## P00165642 P00165742 P00165842 P00165942 P00166042 P00166142 P00166242
## 135 260 204 70 40 34 88
## P00166342 P00166442 P00166642 P00166742 P00166842 P00166942 P00167042
## 58 1 13 171 10 104 2
## P00167142 P00167242 P00167342 P00167442 P00167542 P00167642 P00167742
## 8 1 1 6 28 54 43
## P00167842 P00167942 P00168042 P00168142 P00168342 P00168442 P00168542
## 10 95 20 21 92 69 7
## P00168642 P00168742 P00168842 P00168942 P00169042 P00169142 P00169242
## 31 105 19 2 23 38 3
## P00169342 P00169442 P00169542 P00169642 P00169742 P00169842 P00169942
## 7 137 14 89 493 1 5
## P00170042 P00170142 P00170242 P00170342 P00170442 P00170542 P00170642
## 8 13 32 253 352 159 327
## P00170742 P00170842 P00170942 P00171042 P00171142 P00171242 P00171342
## 4 32 204 25 2 5 204
## P00171442 P00171542 P00171642 P00171742 P00171842 P00171942 P00172042
## 10 272 165 24 73 10 6
## P00172142 P00172242 P00172342 P00172442 P00172542 P00172642 P00172742
## 36 3 18 3 55 1 17
## P00172842 P00173042 P00173142 P00173242 P00173342 P00173442 P00173542
## 267 528 24 290 459 69 203
## P00173742 P00173842 P00173942 P00174042 P00174142 P00174242 P00174342
## 190 611 387 64 204 322 27
## P00174442 P00174542 P00174642 P00174742 P00174842 P00174942 P00175042
## 714 146 20 20 160 15 47
## P00175142 P00175242 P00175342 P00175442 P00175542 P00175642 P00175742
## 2 129 22 11 42 63 51
## P00175842 P00175942 P00176042 P00176142 P00176242 P00176342 P00176442
## 41 63 116 52 64 72 30
## P00176542 P00176642 P00176742 P00176842 P00176942 P00177042 P00177142
## 205 269 106 412 116 110 186
## P00177242 P00177342 P00177442 P00177542 P00177642 P00177742 P00177842
## 127 363 466 583 248 270 358
## P00177942 P00178042 P00178142 P00178242 P00178342 P00178442 P00178542
## 296 311 345 703 365 118 165
## P00178642 P00178742 P00178842 P00178942 P00179042 P00179142 P00179242
## 377 102 301 824 137 151 133
## P00179342 P00179442 P00179542 P00179642 P00179742 P00179842 P00179942
## 100 112 154 93 118 90 69
## P00180042 P00180142 P00180242 P00180342 P00180442 P00180542 P00180642
## 66 46 53 281 105 59 68
## P00180742 P00180842 P00180942 P00181042 P00181142 P00181242 P00181342
## 69 55 27 7 8 140 73
## P00181442 P00181542 P00181642 P00181742 P00181842 P00181942 P00182042
## 40 438 106 66 448 60 77
## P00182142 P00182242 P00182342 P00182442 P00182542 P00182642 P00182742
## 891 568 451 399 197 394 529
## P00182842 P00182942 P00183042 P00183142 P00183242 P00183342 P00183442
## 35 6 254 211 642 620 348
## P00183542 P00183642 P00183742 P00183842 P00183942 P00184042 P00184142
## 101 197 60 88 300 334 401
## P00184242 P00184342 P00184442 P00184542 P00184642 P00184742 P00184842
## 403 121 427 77 115 98 75
## P00184942 P00185042 P00185142 P00185242 P00185342 P00185442 P00185542
## 1424 44 19 20 100 156 32
## P00185642 P00185742 P00185842 P00185942 P00186042 P00186142 P00186242
## 49 20 107 1 61 74 99
## P00186342 P00186442 P00186542 P00186642 P00186742 P00186842 P00186942
## 88 25 31 297 7 68 23
## P00187042 P00187142 P00187242 P00187342 P00187442 P00187542 P00187642
## 52 56 114 196 522 22 7
## P00187742 P00187842 P00187942 P00188042 P00188142 P00188242 P00188342
## 52 438 141 107 2 38 4
## P00188442 P00188542 P00188642 P00188742 P00188842 P00188942 P00189042
## 453 272 66 310 59 78 138
## P00189142 P00189242 P00189342 P00189442 P00189542 P00189642 P00189742
## 99 159 35 11 49 341 72
## P00189842 P00189942 P00190042 P00190142 P00190242 P00190342 P00190442
## 351 7 460 564 187 142 40
## P00190542 P00190642 P00190742 P00190842 P00190942 P00191042 P00191142
## 306 14 315 261 130 129 113
## P00191242 P00191342 P00191442 P00191542 P00191642 P00191742 P00191842
## 96 140 408 62 257 113 43
## P00191942 P00192042 P00192142 P00192242 P00192342 P00192442 P00192542
## 109 625 6 105 19 31 521
## P00192642 P00192742 P00192842 P00192942 P00193042 P00193142 P00193242
## 95 107 458 314 200 180 202
## P00193342 P00193442 P00193542 P00193642 P00193742 P00193842 P00193942
## 39 131 606 241 143 192 84
## P00194042 P00194142 P00194242 P00194342 P00194442 P00194542 P00194642
## 144 125 121 111 388 234 266
## P00194742 P00194842 P00194942 P00195042 P00195142 P00195242 P00195342
## 3 19 4 162 13 158 306
## P00195442 P00195542 P00195642 P00195742 P00195842 P00195942 P00196042
## 273 129 132 262 175 191 350
## P00196142 P00196242 P00196342 P00196442 P00196542 P00196642 P00196742
## 215 104 185 385 362 195 123
## P00196842 P00196942 P00197042 P00197142 P00197242 P00197342 P00197442
## 93 52 366 71 43 145 85
## P00197542 P00197642 P00197742 P00197842 P00197942 P00198042 P00198142
## 151 6 13 12 117 389 400
## P00198242 P00198342 P00198442 P00198542 P00198642 P00198742 P00198842
## 88 110 14 58 78 430 42
## P00198942 P00199042 P00199142 P00199242 P00199342 P00199442 P00199542
## 74 67 99 2 59 779 7
## P00199642 P00199742 P00199842 P00199942 P00200042 P00200142 P00200242
## 91 46 48 27 32 68 60
## P00200342 P00200442 P00200542 P00200642 P00200742 P00200842 P00200942
## 86 83 9 261 15 141 12
## P00201042 P00201142 P00201242 P00201342 P00201442 P00201542 P00201642
## 29 3 3 411 581 82 15
## P00201742 P00201842 P00201942 P00202042 P00202142 P00202242 P00202342
## 9 2 2 10 120 120 48
## P00202442 P00202542 P00202642 P00202742 P00202842 P00202942 P00203042
## 13 91 4 115 7 29 7
## P00203142 P00203242 P00203442 P00203642 P00203742 P00203842 P00203942
## 63 1 6 1 4 6 1
## P00204042 P00204142 P00204242 P00204342 P00204442 P00204542 P00204742
## 1 14 180 122 1 5 110
## P00204842 P00204942 P00205042 P00205142 P00205242 P00205342 P00205442
## 21 45 50 127 73 3 426
## P00205542 P00205642 P00205742 P00205842 P00205942 P00206042 P00206142
## 4 287 8 195 489 114 25
## P00206242 P00206342 P00206442 P00206542 P00206642 P00206742 P00206842
## 1 107 245 1 44 15 9
## P00206942 P00207042 P00207142 P00207242 P00207342 P00207442 P00207542
## 1 99 25 82 163 101 33
## P00207642 P00207742 P00207842 P00207942 P00208042 P00208142 P00208242
## 38 100 39 538 129 44 61
## P00208342 P00208442 P00208542 P00208642 P00208742 P00208842 P00208942
## 354 39 34 1 436 133 60
## P00209042 P00209142 P00209242 P00209342 P00209442 P00209542 P00209642
## 7 171 29 23 19 24 149
## P00209742 P00209842 P00209942 P00210042 P00210142 P00210242 P00210342
## 380 535 54 775 15 12 334
## P00210442 P00210542 P00210642 P00210742 P00210842 P00210942 P00211042
## 40 76 180 8 2 330 190
## P00211142 P00211242 P00211342 P00211442 P00211542 P00211642 P00211742
## 602 171 2 16 54 21 1
## P00211942 P00212042 P00212142 P00212242 P00212342 P00212442 P00212542
## 65 224 171 261 57 88 143
## P00212642 P00212742 P00212842 P00212942 P00213042 P00213142 P00213242
## 4 174 84 618 166 23 626
## P00213342 P00213442 P00213542 P00213642 P00213742 P00213842 P00213942
## 73 11 53 85 350 45 88
## P00214042 P00214142 P00214242 P00214342 P00214442 P00214542 P00214642
## 5 295 194 234 497 68 170
## P00214742 P00214842 P00214942 P00215042 P00215142 P00215242 P00215342
## 12 179 23 8 1 98 18
## P00215442 P00215542 P00215642 P00215742 P00215842 P00215942 P00216042
## 168 44 185 84 11 60 455
## P00216142 P00216242 P00216342 P00216442 P00216542 P00216642 P00216742
## 554 71 925 46 111 2 369
## P00216842 P00216942 P00217042 P00217142 P00217242 P00217342 P00217442
## 60 90 29 157 68 78 394
## P00217542 P00217642 P00217742 P00217842 P00217942 P00218042 P00218142
## 155 34 414 74 325 122 99
## P00218242 P00218342 P00218442 P00218542 P00218642 P00218742 P00218842
## 134 213 161 93 209 115 105
## P00218942 P00219042 P00219142 P00219242 P00219342 P00219442 P00219542
## 95 84 75 287 72 34 119
## P00219642 P00219742 P00219842 P00219942 P00220042 P00220142 P00220242
## 11 149 177 399 107 428 310
## P00220342 P00220442 P00220542 P00220642 P00220742 P00220842 P00220942
## 686 1253 6 193 119 25 158
## P00221042 P00221142 P00221242 P00221342 P00221442 P00221542 P00221642
## 213 214 164 377 731 538 135
## P00221742 P00221842 P00221942 P00222042 P00222142 P00222242 P00222342
## 240 225 219 145 238 204 9
## P00222442 P00222542 P00222642 P00222742 P00222842 P00222942 P00223042
## 186 37 56 40 261 263 147
## P00223142 P00223242 P00223342 P00223442 P00223542 P00223642 P00223742
## 270 455 31 16 440 261 104
## P00223842 P00223942 P00224042 P00224142 P00224242 P00224342 P00224442
## 77 251 88 339 27 64 62
## P00224542 P00224642 P00224742 P00224842 P00224942 P00225042 P00225142
## 43 1 102 23 13 85 65
## P00225242 P00225342 P00225442 P00225542 P00225642 P00225742 P00225842
## 3 40 32 136 97 20 210
## P00225942 P00226042 P00226142 P00226242 P00226342 P00226442 P00226542
## 63 8 105 259 591 162 136
## P00226642 P00226742 P00226842 P00226942 P00227042 P00227142 P00227342
## 77 130 64 30 24 247 24
## P00227442 P00227542 P00227642 P00227742 P00227842 P00227942 P00228042
## 4 174 187 259 506 216 58
## P00228142 P00228242 P00228342 P00228442 P00228542 P00228642 P00228742
## 88 178 85 145 20 312 25
## P00228842 P00228942 P00229042 P00229142 P00229342 P00229442 P00229542
## 1 16 16 14 219 3 4
## P00229642 P00229742 P00229842 P00229942 P00230042 P00230142 P00230242
## 41 436 57 87 16 16 56
## P00230342 P00230442 P00230542 P00230642 P00230742 P00230842 P00230942
## 193 89 52 33 69 326 454
## P00231042 P00231142 P00231242 P00231342 P00231442 P00231542 P00231642
## 5 104 162 81 28 8 1
## P00231742 P00231842 P00231942 P00232042 P00232142 P00232242 P00232342
## 42 12 168 67 31 32 139
## P00232442 P00232542 P00232642 P00232742 P00232842 P00232942 P00233042
## 159 52 90 41 43 22 142
## P00233142 P00233242 P00233342 P00233442 P00233542 P00233642 P00233742
## 80 70 349 329 623 198 165
## P00233842 P00233942 P00234042 P00234142 P00234242 P00234342 P00234442
## 195 248 9 67 15 17 3
## P00234542 P00234642 P00234742 P00234842 P00234942 P00235042 P00235142
## 341 85 311 349 1 10 3
## P00235242 P00235342 P00235442 P00235542 P00235642 P00235742 P00235842
## 85 61 98 94 104 21 125
## P00235942 P00236042 P00236242 P00236342 P00236442 P00236542 P00236642
## 78 81 2 126 14 100 64
## P00236742 P00236942 P00237042 P00237142 P00237242 P00237342 P00237442
## 3 211 21 158 112 4 53
## P00237542 P00237642 P00237742 P00237842 P00237942 P00238042 P00238142
## 1374 381 22 101 72 2 16
## P00238242 P00238342 P00238442 P00238542 P00238642 P00238742 P00238842
## 2 15 369 338 30 122 1
## P00238942 P00239042 P00239142 P00239242 P00239342 P00239442 P00239642
## 22 9 53 34 18 1 19
## P00239742 P00239842 P00239942 P00240042 P00240142 P00240242 P00240342
## 36 81 35 275 802 219 3
## P00240442 P00240542 P00240642 P00240742 P00240842 P00240942 P00241042
## 405 105 46 4 34 21 83
## P00241142 P00241242 P00241342 P00241442 P00241542 P00241642 P00241742
## 77 163 29 91 320 546 26
## P00241842 P00241942 P00242042 P00242142 P00242242 P00242342 P00242442
## 1 24 36 212 4 49 40
## P00242542 P00242642 P00242742 P00242842 P00242942 P00243042 P00243142
## 26 7 1194 80 25 2 4
## P00243242 P00243342 P00243442 P00243542 P00243642 P00243742 P00243842
## 97 51 15 10 18 22 91
## P00243942 P00244042 P00244142 P00244242 P00244342 P00244442 P00244542
## 674 460 280 179 122 57 17
## P00244642 P00244742 P00244842 P00244942 P00245042 P00245142 P00245242
## 23 222 35 18 52 34 26
## P00245342 P00245442 P00245542 P00245642 P00245742 P00245842 P00245942
## 76 27 33 683 7 34 74
## P00246042 P00246142 P00246242 P00246342 P00246442 P00246542 P00246642
## 45 319 25 334 38 19 36
## P00246742 P00246842 P00246942 P00247042 P00247142 P00247242 P00247342
## 148 65 129 401 211 5 15
## P00247442 P00247542 P00247642 P00247742 P00247842 P00247942 P00248042
## 8 158 127 17 2 22 48
## P00248142 P00248242 P00248342 P00248442 P00248542 P00248642 P00248742
## 809 3 312 225 372 20 235
## P00248842 P00248942 P00249042 P00249142 P00249242 P00249342 P00249442
## 13 570 112 447 7 42 24
## P00249542 P00249642 P00249742 P00249842 P00250042 P00250142 P00250242
## 778 713 473 204 18 4 759
## P00250342 P00250442 P00250542 P00250642 P00250742 P00250842 P00250942
## 340 22 123 665 11 518 208
## P00251042 P00251142 P00251242 P00251342 P00251442 P00251542 P00251642
## 47 14 1167 298 203 266 194
## P00251742 P00251842 P00251942 P00252042 P00252142 P00252242 P00252342
## 45 313 463 340 51 69 13
## P00252442 P00252542 P00252642 P00252742 P00252842 P00252942 P00253042
## 236 119 78 118 78 31 238
## P00253142 P00253242 P00253342 P00253442 P00253542 P00253642 P00253742
## 256 122 8 43 243 10 31
## P00253942 P00254042 P00254142 P00254242 P00254342 P00254442 P00254542
## 14 18 126 500 185 67 48
## P00254642 P00254742 P00254842 P00254942 P00255042 P00255142 P00255242
## 144 25 93 37 7 20 11
## P00255342 P00255442 P00255542 P00255642 P00255742 P00255842 P00255942
## 68 12 232 4 382 1354 552
## P00256042 P00256142 P00256242 P00256342 P00256442 P00256542 P00256642
## 149 3 18 12 10 39 493
## P00256742 P00256842 P00256942 P00257042 P00257142 P00257242 P00257342
## 100 132 9 37 8 8 3
## P00257442 P00257542 P00257642 P00257742 P00257842 P00257942 P00258042
## 17 178 41 31 58 3 34
## P00258142 P00258242 P00258342 P00258442 P00258542 P00258642 P00258742
## 11 30 68 231 95 26 955
## P00258842 P00258942 P00259042 P00259142 P00259242 P00259342 P00259442
## 298 136 201 291 127 814 90
## P00259542 P00259642 P00259742 P00259842 P00259942 P00260042 P00260142
## 55 11 47 162 199 741 231
## P00260242 P00260342 P00260442 P00260542 P00260642 P00260742 P00260842
## 85 46 191 13 25 1 23
## P00260942 P00261042 P00261142 P00261242 P00261342 P00261442 P00261542
## 16 4 145 75 62 32 170
## P00261642 P00261742 P00261842 P00261942 P00262042 P00262142 P00262242
## 32 2 142 2 6 2 413
## P00262342 P00262442 P00262542 P00262642 P00262742 P00262842 P00262942
## 186 73 87 8 2 2 9
## P00263042 P00263142 P00263242 P00263342 P00263442 P00263542 P00263642
## 34 91 13 6 214 284 25
## P00263742 P00263842 P00264042 P00264142 P00264242 P00264342 P00264442
## 11 41 82 13 18 8 2
## P00264542 P00264642 P00264742 P00264842 P00264942 P00265042 P00265142
## 78 76 15 4 7 41 217
## P00265242 P00265342 P00265442 P00265542 P00265642 P00265742 P00265842
## 1858 132 73 198 50 257 16
## P00265942 P00266042 P00266142 P00266242 P00266342 P00266442 P00266542
## 16 112 161 35 3 104 401
## P00266642 P00266742 P00266842 P00266942 P00267042 P00267142 P00267242
## 424 10 36 162 25 113 21
## P00267342 P00267442 P00267542 P00267642 P00267742 P00267842 P00267942
## 89 34 425 65 139 22 34
## P00268042 P00268142 P00268242 P00268342 P00268442 P00268542 P00268642
## 15 3 65 149 559 90 7
## P00268742 P00268842 P00269042 P00269142 P00269242 P00269342 P00269442
## 27 21 14 12 51 70 88
## P00269542 P00269642 P00269742 P00269842 P00269942 P00270042 P00270142
## 174 95 50 7 37 138 122
## P00270242 P00270442 P00270542 P00270642 P00270742 P00270842 P00270942
## 479 4 252 12 7 462 1141
## P00271042 P00271142 P00271242 P00271342 P00271442 P00271542 P00271642
## 286 781 197 55 196 130 7
## P00271742 P00271842 P00271942 P00272042 P00272142 P00272242 P00272342
## 67 28 234 58 44 110 2
## P00272442 P00272542 P00272642 P00272742 P00272842 P00272942 P00273042
## 2 64 5 2 78 81 53
## P00273142 P00273242 P00273342 P00273442 P00273542 P00273642 P00273742
## 22 27 58 157 209 85 386
## P00273842 P00273942 P00274042 P00274142 P00274242 P00274342 P00274442
## 18 175 465 399 350 191 278
## P00274542 P00274642 P00274742 P00274842 P00274942 P00275042 P00275142
## 115 193 2 73 782 1 165
## P00275242 P00275342 P00275442 P00275542 P00275642 P00275742 P00275842
## 7 9 7 37 226 64 551
## P00275942 P00276042 P00276142 P00276242 P00276342 P00276442 P00276542
## 34 51 167 31 259 35 60
## P00276642 P00276742 P00276842 P00276942 P00277042 P00277142 P00277242
## 299 22 60 24 7 22 38
## P00277342 P00277442 P00277542 P00277642 P00277742 P00277842 P00277942
## 7 648 272 968 62 214 194
## P00278042 P00278142 P00278242 P00278342 P00278442 P00278542 P00278642
## 214 12 234 5 178 71 1213
## P00278742 P00278842 P00278942 P00279142 P00279242 P00279342 P00279442
## 6 2 172 23 5 139 346
## P00279542 P00279642 P00279742 P00279842 P00279942 P00280042 P00280142
## 480 151 22 23 80 5 39
## P00280242 P00280342 P00280442 P00280542 P00280642 P00280742 P00280842
## 35 77 223 56 139 215 275
## P00280942 P00281042 P00281142 P00281242 P00281342 P00281442 P00281542
## 17 120 86 7 3 4 78
## P00281642 P00281742 P00281842 P00281942 P00282042 P00282142 P00282242
## 100 114 29 127 481 177 219
## P00282342 P00282442 P00282542 P00282642 P00282742 P00282842 P00282942
## 96 318 43 460 167 38 37
## P00283042 P00283142 P00283242 P00283342 P00283442 P00283542 P00283642
## 16 299 65 52 13 47 14
## P00283742 P00283842 P00283942 P00284042 P00284142 P00284242 P00284342
## 6 87 526 183 77 46 4
## P00284542 P00284642 P00284742 P00284842 P00284942 P00285042 P00285142
## 7 298 156 198 81 29 1
## P00285242 P00285342 P00285442 P00285542 P00285642 P00285742 P00285842
## 103 187 200 30 335 159 524
## P00285942 P00286042 P00286142 P00286242 P00286342 P00286442 P00286542
## 17 126 36 39 53 84 69
## P00286642 P00286742 P00286842 P00286942 P00287042 P00287142 P00287242
## 550 453 215 2 1 47 264
## P00287342 P00287442 P00287542 P00287642 P00287742 P00287842 P00287942
## 201 124 99 70 10 108 51
## P00288042 P00288142 P00288242 P00288342 P00288442 P00288542 P00288642
## 279 41 121 291 141 320 448
## P00288742 P00288842 P00288942 P00289042 P00289142 P00289242 P00289342
## 128 32 412 365 15 476 521
## P00289442 P00289542 P00289642 P00289742 P00289842 P00289942 P00290042
## 36 17 103 45 302 828 55
## P00290142 P00290242 P00290342 P00290442 P00290542 P00290642 P00290742
## 6 41 31 3 63 9 18
## P00290842 P00290942 P00291042 P00291142 P00291242 P00291342 P00291442
## 2 16 97 2 27 23 159
## P00291542 P00291642 P00291742 P00291842 P00291942 P00292042 P00292142
## 71 1 14 17 98 97 1
## P00292242 P00292342 P00292442 P00292542 P00292642 P00292742 P00292842
## 9 37 6 5 33 74 18
## P00292942 P00293042 P00293142 P00293242 P00293342 P00293442 P00293542
## 21 144 172 656 384 4 34
## P00293742 P00293842 P00293942 P00294042 P00294142 P00294242 P00294342
## 187 144 4 165 209 278 15
## P00294442 P00294542 P00294642 P00294742 P00294842 P00295042 P00295142
## 234 605 8 12 156 31 4
## P00295242 P00295342 P00295442 P00295542 P00295642 P00295742 P00295842
## 95 270 139 16 1 255 476
## P00295942 P00296042 P00296142 P00296242 P00296342 P00296442 P00296542
## 959 716 85 282 106 38 93
## P00296642 P00296742 P00296842 P00296942 P00297042 P00297142 P00297242
## 61 31 2 200 226 2 25
## P00297342 P00297442 P00297542 P00297642 P00297742 P00297842 P00297942
## 169 89 14 119 190 131 178
## P00298042 P00298142 P00298242 P00298342 P00298442 P00298542 P00298742
## 35 98 189 1 280 107 67
## P00298842 P00298942 P00299042 P00299142 P00299242 P00299342 P00299442
## 1 144 1 457 34 1 124
## P00299542 P00299642 P00299742 P00299842 P00299942 P00300042 P00300242
## 54 9 1 48 17 246 14
## P00300342 P00300442 P00300542 P00300642 P00300742 P00300942 P00301042
## 15 16 36 62 1 41 3
## P00301142 P00301242 P00301342 P00301442 P00301542 P00301642 P00301742
## 2 40 2 1 161 18 17
## P00301842 P00301942 P00302042 P00302142 P00302242 P00302342 P00302442
## 29 1 161 169 3 255 373
## P00302542 P00302642 P00302742 P00302842 P00302942 P00303042 P00303142
## 107 174 194 138 284 587 241
## P00303242 P00303342 P00303442 P00303542 P00303642 P00303742 P00303842
## 601 581 348 194 214 260 231
## P00303942 P00304042 P00304142 P00304242 P00304342 P00304442 P00304542
## 78 353 269 169 73 256 96
## P00304642 P00304742 P00304842 P00304942 P00305042 P00305142 P00305242
## 244 108 181 89 316 252 53
## P00305342 P00305442 P00305542 P00305642 P00305742 P00305842 P00305942
## 21 1 1 31 5 6 25
## P00306042 P00306142 P00306242 P00306342 P00306442 P00306542 P00306742
## 214 73 66 3 31 1 4
## P00306942 P00307042 P00307142 P00307242 P00307342 P00307442 P00307542
## 1 1 110 1 333 92 294
## P00307642 P00307742 P00307842 P00307942 P00308042 P00308142 P00308242
## 326 25 4 27 1 13 150
## P00308342 P00308442 P00308542 P00308642 P00308842 P00308942 P00309042
## 146 14 20 14 12 3 1
## P00309142 P00309242 P00309342 P00309442 P00309542 P00309642 P00309742
## 160 276 26 18 27 1 3
## P00309942 P00310042 P00310142 P00310242 P00310342 P00310442 P00310542
## 103 82 95 73 177 14 60
## P00310642 P00310742 P00310842 P00310942 P00311042 P00311242 P00311342
## 19 8 232 4 2 15 22
## P00311442 P00311542 P00311642 P00311742 P00311842 P00311942 P00312042
## 42 94 110 21 9 17 3
## P00312142 P00312242 P00312342 P00312442 P00312542 P00312742 P00312842
## 108 14 77 11 1 440 151
## P00312942 P00313042 P00313142 P00313242 P00313342 P00313442 P00313542
## 55 250 273 325 591 404 509
## P00313642 P00313742 P00313842 P00313942 P00314042 P00314142 P00314242
## 84 121 136 23 33 36 31
## P00314342 P00314542 P00314642 P00314742 P00314842 P00314942 P00315042
## 26 9 34 1 1 2 49
## P00315142 P00315242 P00315442 P00315542 P00315642 P00315742 P00315842
## 1 1 139 79 396 91 165
## P00315942 P00316042 P00316142 P00316242 P00316342 P00316442 P00316542
## 21 11 52 98 24 113 29
## P00316642 P00316742 P00316842 P00316942 P00317042 P00317142 P00317242
## 410 194 177 43 15 61 13
## P00317342 P00317442 P00317542 P00317642 P00317742 P00317842 P00317942
## 22 126 63 58 2 746 224
## P00318042 P00318142 P00318342 P00318442 P00318542 P00318642 P00318742
## 5 86 28 10 32 32 750
## P00318842 P00318942 P00319042 P00319142 P00319242 P00319342 P00319442
## 3 109 642 131 41 425 39
## P00319542 P00319642 P00319742 P00319842 P00319942 P00320042 P00320142
## 107 40 33 148 121 44 37
## P00320242 P00320342 P00320442 P00320542 P00320642 P00320742 P00320842
## 23 23 264 67 8 275 130
## P00320942 P00321042 P00321142 P00321242 P00321342 P00321442 P00321542
## 114 258 23 3 116 73 22
## P00321642 P00321742 P00321842 P00321942 P00322042 P00322142 P00322242
## 38 568 21 439 192 177 51
## P00322342 P00322442 P00322542 P00322742 P00322942 P00323042 P00323142
## 21 29 72 36 192 155 4
## P00323242 P00323342 P00323442 P00323542 P00323642 P00323742 P00323842
## 10 10 106 149 239 140 47
## P00323942 P00324042 P00324142 P00324242 P00324342 P00324442 P00324542
## 786 4 11 9 81 355 146
## P00324642 P00324742 P00324842 P00324942 P00325042 P00325142 P00325242
## 145 311 79 775 2 89 167
## P00325342 P00325442 P00325542 P00325642 P00325742 P00325842 P00325942
## 1 7 35 14 382 9 33
## P00326042 P00326242 P00326342 P00326442 P00326542 P00326642 P00326742
## 9 175 3 23 50 156 503
## P00326842 P00326942 P00327042 P00327142 P00327242 P00327342 P00327442
## 97 147 49 81 373 179 102
## P00327542 P00327642 P00327742 P00327842 P00327942 P00328042 P00328142
## 196 199 46 428 36 247 220
## P00328242 P00328342 P00328442 P00328642 P00328742 P00328842 P00328942
## 31 108 117 28 110 22 99
## P00329042 P00329142 P00329242 P00329342 P00329442 P00329542 P00329642
## 1 3 285 195 414 695 177
## P00329742 P00329842 P00329942 P00330042 P00330142 P00330242 P00330342
## 83 1 18 10 2 271 337
## P00330442 P00330542 P00330642 P00330742 P00330842 P00331042 P00331142
## 264 16 94 18 15 468 52
## P00331242 P00331342 P00331442 P00331542 P00331642 P00331742 P00331842
## 237 117 40 153 129 86 205
## P00331942 P00332042 P00332142 P00332242 P00332342 P00332442 P00332542
## 493 49 63 518 179 66 11
## P00332642 P00332742 P00332842 P00332942 P00333042 P00333142 P00333242
## 15 7 69 145 182 20 18
## P00333342 P00333442 P00333542 P00333642 P00333742 P00333842 P00333942
## 24 5 70 41 16 8 2
## P00334042 P00334142 P00334242 P00334342 P00334442 P00334542 P00334642
## 154 32 1082 35 13 5 73
## P00334742 P00334842 P00334942 P00335042 P00335142 P00335242 P00335342
## 11 15 19 20 43 357 2
## P00335442 P00335542 P00335642 P00335742 P00335842 P00335942 P00336042
## 190 105 1 38 20 92 53
## P00336142 P00336242 P00336342 P00336442 P00336542 P00336642 P00336742
## 75 1 32 3 74 26 83
## P00336942 P00337042 P00337142 P00337242 P00337342 P00337442 P00337542
## 443 4 18 11 13 44 290
## P00337642 P00337742 P00337842 P00337942 P00338042 P00338142 P00338242
## 174 81 233 189 50 28 1
## P00338342 P00338442 P00338542 P00338642 P00338742 P00338842 P00338942
## 48 715 414 9 25 67 50
## P00339042 P00339142 P00339242 P00339342 P00339442 P00339542 P00339642
## 154 1 23 185 85 258 6
## P00339742 P00339842 P00339942 P00340042 P00340142 P00340242 P00340342
## 15 326 234 5 3 12 54
## P00340442 P00340542 P00340642 P00340742 P00340842 P00340942 P00341042
## 11 11 98 1 6 156 2
## P00341142 P00341242 P00341342 P00341442 P00341542 P00341642 P00341742
## 2 95 252 30 1 2 40
## P00341842 P00341942 P00342042 P00342142 P00342242 P00342342 P00342442
## 23 83 43 52 37 32 14
## P00342542 P00342642 P00342742 P00342842 P00342942 P00343042 P00343142
## 2 19 200 38 12 586 83
## P00343242 P00343342 P00343442 P00343542 P00343642 P00343742 P00343842
## 15 19 146 112 26 49 32
## P00343942 P00344042 P00344142 P00344242 P00344342 P00344442 P00344542
## 28 168 117 331 207 278 236
## P00344742 P00344842 P00344942 P00345042 P00345142 P00345242 P00345342
## 185 89 58 19 29 99 32
## P00345442 P00345542 P00345642 P00345742 P00345842 P00345942 P00346042
## 29 37 347 385 462 136 271
## P00346142 P00346242 P00346342 P00346442 P00346542 P00346642 P00346742
## 586 547 387 192 250 124 147
## P00346842 P00346942 P00347042 P00347142 P00347242 P00347342 P00347442
## 61 105 17 185 45 32 45
## P00347542 P00347642 P00347742 P00347842 P00347942 P00348042 P00348142
## 38 321 37 27 49 17 1
## P00348242 P00348342 P00348442 P00348542 P00348642 P00348742 P00348842
## 147 98 59 59 79 73 130
## P00348942 P00349042 P00349142 P00349242 P00349342 P00349442 P00349542
## 244 19 37 143 31 281 19
## P00349642 P00349742 P00349842 P00349942 P00350042 P00350142 P00350242
## 31 49 25 323 121 133 51
## P00350342 P00350442 P00350542 P00350642 P00350842 P00350942 P00351042
## 245 295 31 80 12 726 314
## P00351142 P00351242 P00351342 P00351442 P00351542 P00351642 P00351742
## 638 115 554 14 11 57 19
## P00351842 P00351942 P00352042 P00352142 P00352242 P00352342 P00352442
## 170 14 1 379 129 25 111
## P00352542 P00352642 P00352742 P00352842 P00352942 P00353042 P00353142
## 59 47 115 185 86 1 91
## P00353242 P00353342 P00353442 P00353542 P00353642 P00353742 P00353842
## 31 12 17 7 3 1 24
## P00353942 P00354042 P00354142 P00354242 P00354342 P00354442 P00354542
## 17 25 134 93 323 100 27
## P00354642 P00354742 P00354842 P00354942 P00355042 P00355142 P00355242
## 131 84 28 246 35 807 64
## P00355342 P00355442 P00355542 P00355642 P00355742 P00355842 P00355942
## 36 4 21 259 60 2 118
## P00356042 P00356142 P00356242 P00356342 P00356442 P00356542 P00356642
## 175 6 20 15 31 69 18
## P00356742 P00356842 P00356942 P00357042 P00357142 P00357242 P00357342
## 462 46 184 151 41 119 27
## P00357442 P00357542 P00357642 P00357742 P00357842 P00357942 P00358042
## 9 1 126 20 132 44 35
## P00358142 P00358242 P00358342 P00358442 P00358542 P00358642 P00358742
## 69 122 223 263 2 8 100
## P00358842 P00358942 P00359042 P00359142 P00359242 P00359342 P00359442
## 13 26 98 100 191 61 24
## P00359542 P00359642 P00359742 P00359942 P00360042 P00360142 P00360242
## 28 58 171 19 233 13 77
## P00360342 P00360442 P00360542 P00360642 P00360742 P00360842 P00360942
## 11 10 25 7 20 115 6
## P00361042 P00361142 P00361242 P00361342 P00361442 P00361542 P00361642
## 9 18 30 36 47 7 135
## P00361742 P00361842 P00361942 P00362042 P00362142 P00362242 P00362342
## 11 352 80 78 4 4 362
## P00362442 P00362542 P00362642 P00362742 P00362842 P00362942 P00363042
## 237 24 154 61 152 13 3
## P00363142 P00363242 P00363342 P00363442 P00363542 P00363742 P00363842
## 2 104 6 61 9 122 7
## P00363942 P00364042 P00364142 P00364242 P00364342 P00364442 P00364542
## 23 16 18 3 1 72 1
## P00364642 P00364742 P00364842 P00364942 P00365042 P00365142 P00365242
## 3 6 318 11 49 95 517
## P00365342 P00365442 P00365542 P00365642 P00365742 P00365842 P00365942
## 25 2 22 51 11 28 1
## P00366042 P00366142 P00366242 P00366342 P00366442 P00366542 P00366642
## 6 16 49 34 123 359 24
## P00366742 P00366842 P00366942 P00367042 P00367142 P00367242 P00367342
## 13 40 63 224 160 88 51
## P00367442 P00367542 P00367642 P00367742 P00367842 P00367942 P00368042
## 38 21 23 60 14 66 93
## P00368142 P00368242 P00368342 P00368442 P00368542 P00368642 P00368742
## 193 115 82 127 20 130 8
## P00368842 P00368942 P00369042 P00369142 P00369242 P00369342 P00369442
## 14 10 64 78 15 15 8
## P00369542 P00369642 P00369742 P00369842 P00369942 P00370042 P00370142
## 14 12 49 5 23 46 30
## P00370242 P00370342 P00370442 P00370542 P00370642 P0093742 P0093842
## 461 165 25 23 216 10 5
## P0093942 P0094042 P0094142 P0094242 P0094342 P0094442 P0094542
## 65 57 78 46 121 47 172
## P0094642 P0094742 P0094842 P0094942 P0095042 P0095142 P0095242
## 132 72 164 151 83 113 84
## P0095342 P0095442 P0095542 P0095642 P0095742 P0095842 P0095942
## 145 60 305 208 114 308 108
## P0096042 P0096142 P0096242 P0096342 P0096442 P0096542 P0096642
## 67 162 2 179 523 321 171
## P0096742 P0096842 P0096942 P0097042 P0097142 P0097242 P0097342
## 172 296 153 87 482 896 358
## P0097442 P0097542 P0097642 P0097742 P0097842 P0097942 P0098042
## 6 3 1 249 276 62 20
## P0098142 P0098242 P0098342 P0098442 P0098542 P0098642 P0098742
## 42 229 251 72 45 26 46
## P0098842 P0098942 P0099042 P0099142 P0099242 P0099342 P0099442
## 10 33 141 7 255 435 196
## P0099642 P0099742 P0099842 P0099942
## 13 123 100 13names(sale_report)## [1] "User_ID" "Product_ID"
## [3] "GenFer" "Age"
## [5] "Occupation" "City_Category"
## [7] "Stay_In_Current_City_Years" "Marital_Status"
## [9] "Purchase"##### merge the customer's data
### remove product_id (insufficient information)
### limitation_ some user may shop on more than one channel
sale_report %>% distinct(User_ID,City_Category) ###5881 ## # A tibble: 5,893 x 2
## User_ID City_Category
## <int> <chr>
## 1 1000001 A
## 2 1000002 C
## 3 1000003 A
## 4 1000004 B
## 5 1000005 A
## 6 1000006 A
## 7 1000007 B
## 8 1000008 C
## 9 1000009 C
## 10 1000010 B
## # ... with 5,883 more rowsmerge_sales_report <- sale_report %>% group_by(User_ID) %>% summarise(
Gender=first(GenFer),
Age=first(Age),
Occupation = first(Occupation),
City_Category = first(City_Category),
Stay_In_Current_City_Years = first(Stay_In_Current_City_Years),
Marital_Status=first(Marital_Status),
mean_purchase = mean(Purchase)
) %>% unique()
table(merge_sales_report$City_Category)##
## A B C
## 1045 1707 3139### replace category
for ( i in 1:nrow(merge_sales_report)) {
if( grepl("A", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "US" }
else { if ( grepl("B", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "UK" }
else{ if( grepl("C", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "Online" } } } }
###
merge_sales_report$mean_purchase <- round(merge_sales_report$mean_purchase)
###
write.csv(merge_sales_report,"~/Desktop/Simulation//merge_sales_report.csv", row.names = FALSE)library(readr)
setwd("~/Desktop/Simulation")
shoe_sales <- read_csv("shoe_sales.csv",
col_types = cols(date = col_date(format = "%Y-%m-%d")))
View(shoe_sales)
### distinct id and brand
shoe_sales %>% distinct(id,brand) ## # A tibble: 653 x 2
## id brand
## <chr> <chr>
## 1 AVpfEf_hLJeJML431ueH Naturalizer
## 2 AVpi74XfLJeJML43qZAc MUK LUKS
## 3 AVpjXyCc1cnluZ0-V-Gj MUK LUKS
## 4 AVphGKLPilAPnD_x1Nrm MUK LUKS
## 5 AVpg91ziilAPnD_xziOo Soft Ones
## 6 AVpjGKXyLJeJML43r8BH MUK LUKS
## 7 AVpfLXyhilAPnD_xWmNc MUK LUKS
## 8 AVpfeWdJ1cnluZ0-lXYU MUK LUKS
## 9 AVpf38PKLJeJML43FRwO MUK LUKS
## 10 AVph9abqilAPnD_x_Nrp MUK LUKS
## # ... with 643 more rowstable(shoe_sales$colors)##
## Angora,Light Porcelain Blue
## 1
## Anthracitedark Grey-Black,Inkdeadly Pink-Fire Pink-Black
## 72
## Aquifer/Vintage Indigo,Black/Azalea
## 2
## Armory Blue/Armory Navy-Cirrus Blue
## 1
## Aruba Blue/Aruba Blue/Turkish Tile,Blue Purple/Black/Flash Coral,Black/Porcelain Blue/White,Black/Silver/Ink Peacoat
## 12
## Asphalt/Griffin,Cherries Jubilee/Purple Passion
## 1
## Atomic Blue/Bluefish/Nightlife,Pink Glo/Black/Nightlife
## 1
## Basalt/Tapa,Dark Java/Tan,Koa/Tapa,Black/Tan,Vintage Indigo/Pale Grey
## 12
## Bayou Blue/Steel/Black,Premier Purple/Rhino Gray/Black
## 2
## Bayou Blue/True Ink/Bayou Blue,Steel/Apollo Gray/Metallic Silver
## 1
## Beige
## 1
## Birch,Black,Marine
## 4
## Black
## 171
## Black Blue Silver,Gray Pink
## 16
## Black Boundary,Mahogany Oro-Iginal Leather
## 4
## Black Cherry Heritage Canvas,Mojolica Blue Heritage Canvas,Morning Dove Heritage Canvas
## 6
## Black Distressed Leather,Black,Black Smooth Leather,Black Lizard Embossed Leather
## 1
## Black Faux Leather,Blue Denim Twill,Pewter Faux Leather
## 51
## Black Leather
## 1
## Black Leather,Blue Leather,Bronze Leather,Red Leather,White Leather
## 15
## Black Leather,Fabric,Brown Leather,Navy Leather,Wine Leather
## 11
## Black Oiled,Antique Brown Oiled,Honey Distressed
## 4
## Black Patent,Black Snake,Coffee Pu,Khaki Patent,Gold Snake,Grey Croc,Brown Pu,Khaki Pu,Red Patent,White Patent,Taupe Pu,Fuchsia Patent,Blue Patent,Beige Snake,Black Pu,Grey Snake,Wine Pu,Beige Python,Mint Patent,Black Croc,Black Python,Nude Patent
## 1
## Black Patent,Blackwhite Texture,Black,Blacksilver Textured,Multi-Color,Beige,Blackblack Texture,Red Patent,Blackwhite Textured,Blue,Navy Polyurethane,Navy,Gold Polyurethane,Black Polyurethane,Blacksilver Texture,Red,Nude Patent,White Texture,Silver Texture,Black Texture
## 29
## Black Patent,Taupe Patent,Beige Patent
## 1
## Black Polyurethane,Lux Navy Polyurethane,Pinot Nior Fabric,Purpleblack Fabric,Grey Fabric,Black Fabric,Luxe Navy Pu,Red Polyurethane,Taupe Polyurethane
## 34
## Black Polyurethane,Stone Polyurethane,Silver Pu,Dark Red Fabric,Black Fabric,Black Underglass Combpatent,Luxe Navy Pu,Stone
## 157
## Black Slubby Cotton,Natural Yarn Dye,Navy Slubby Cotton
## 2
## Black,Black Lamy,Black Synthetic,Bone Synthetic,Navy Synthetic,Pewter Synthetic,Red Synthetic,Silver Satin,Stone Super Suede,White Synthetic
## 34
## Black,Bone,Grey,Floral,Taupe
## 1
## Black,Brown
## 6
## Black,Brown,Chestnut
## 3
## Black,Brown,Dark Grey,Chestnut,Taupe
## 1
## Black,Brown,Grey
## 1
## Black,Brown,Taupe
## 1
## Black,Brunette
## 3
## Black,Charcoal,Taupe
## 1
## Black,Cream,Grey,Cognac,Sage
## 5
## Black,Fuchsia
## 1
## Black,Grey,Beige
## 14
## Black,Grey,Beige,Red,Blue,Tan
## 2
## Black,Grey,Chestnut
## 1
## Black,Grey,Olive,Taupe
## 1
## Black,Grey,Pewter
## 3
## Black,Grey,Red,Taupe
## 1
## Black,Grey,Taupe
## 84
## Black,Marlin Blue
## 8
## Black,Medium Beige
## 1
## Black,Nude
## 2
## Black,Nude,Grey,Hot Pink
## 1
## Black,Oyster
## 1
## Black,Pearl Grey
## 2
## Black,Pewter,Silver,Red,Taupe
## 44
## Black,Pewter,White,Gray,Beige,Tan,Navy Synthetic,Pewter Synthetic,Blue,Navy,White Synthetic,Red Synthetic,Tan Synthetic,Black Synthetic
## 77
## Black,Red
## 2
## Black,Rose Quartz
## 7
## Black,Tan
## 1
## Black,Taupe
## 1
## Black,Teal
## 4
## Black,True White
## 1
## Black,White,Nude,Grey,Red
## 1
## Black,Wine
## 1
## Black/Black
## 1
## Black/Black/Black Metallic,Quarry/Acai/Fair Aqua,Poseidon/Eggshell Blue/Black,Hawaiian Surf/Astral Aura/Grape Juice,Bird Of Paradise/Nasturtium/Pink Yarrow,Slateblue/Spa Blue/Fresh Green,Tibetan Red/Sangria/Black,Deep Peacock Blue/Lime Punch/Grape Juice
## 13
## Black/Black/Black,Raw Grey/Raw Grey/Ash Grey,Black/Black/White,Easy Coral/Black/White
## 5
## Black/Blanc De Blanc,Madder Brown/Blanc De Blanc,Licorice/Blanc De Blanc,Silver Lining/Blanc De Blanc,Birch/True White
## 3
## Black/Bluebird
## 1
## Black/Magnet,Brindle/Inca Gold
## 2
## Black/Pink/White,Blue/Lime/White,Grey/Blue/White
## 5
## Black/Purple/Blue
## 1
## Black/Silver,Eggplant/Dark Grey,Turquoise/Granite Gray
## 5
## Black/Silver/Thistle,Black-Purple-Print,Grey/Aqua Green/Ebony,Navy/Coral/Purple
## 4
## Black/Virtual Pink/Black,Blue Bird/Scarlet Ibis/Black
## 3
## Black/White
## 2
## Black/White-Anthracite,Glacier Blue/Metallic Silver
## 2
## Black/White-Dark Grey-Anthracite,Dark Stucco/Barely Grey-Sequoia-Black,Blue Recall/Obsidian-Royal Tint-Black,Mica Blue/White-Racer Pink-Sport Fuchsia
## 7
## Black/White,Gunsmoke/Crimson Pulse-atmosphere Grey
## 3
## Blackchrome-Aurora Green-Hot Punch,Pure Platinumblue Fury
## 185
## Blackcotton Candychrome Silver,Coraltaupe Fabric,Calypso Coralvapor Grey,Frost Greyultra Violet
## 18
## Blackgrey,Greyblack,Navyblue
## 6
## Blackmetallic Silveranthracite
## 64
## Blackwatch Plaid,Black
## 4
## Blackwhite
## 12
## Blue
## 24
## Blue Bird/Deep Lagoon/Navy Blazer,Sangria/Living Coral/Virtual Pink
## 2
## Blue,Orchid
## 1
## Blue,Purple,Gray/Blue
## 6
## Blue/Lime,Charcoal/Blue,Raspberry
## 2
## Blue/Teal
## 2
## Blueprint/Surf The Web,Medieval Blue/Fuchsia
## 2
## Bomber Brown
## 5
## Brown
## 113
## Brown Sugar,Turbulence
## 1
## Brown Tweed
## 1
## Brown,Black
## 3
## Buckskin
## 1
## Burgundy,Black,Brown,Grey,Blue
## 1
## Burgundy,Black,Nude
## 1
## Burgundy/Peach,Black/Turquoise
## 6
## Capri/Poseidon
## 1
## Castlerock/White
## 1
## Ceramic/Lime Punch/Black,Evening Blue/Grape Juice/Black
## 4
## Charcoal Gray,Grey,Dark Brown,Moccasin,Light Gray,Medium Brown
## 2
## Charcoal,Black,Chocolate,Taupe
## 10
## Chestnut,Chocolate,Black
## 10
## Chocolate Nubuck
## 1
## Clematis/Coral Red
## 3
## Core Black/Core Black/Core Black,Noble Indigo/Aero Blue/Aero Blue,Utility Black/Core Black/Shock Pink,Grey Five/Night Met/Core Black,Light Solid Grey/White/Mgh Solid Grey,Nobile Ink/Footwear White/Energy Aqua
## 5
## Dark Green Nubuck,Wheat Nubuck
## 3
## Dark Shadow/Dark Shadow,Mustang/Mustang
## 2
## Diva Pink/Anthracite/Bluefish
## 1
## Emerald/Mint,Fjord/Malibu Blue
## 2
## Fiji
## 3
## Fjord,Grey/Papaya
## 1
## Footwear White/Core Black/Core Black,Core Black/Silver Met/Shock Pink,Easy Blue/Footwear White/Easy Coral,Grey Five/Night Met/Core Black,Footwear White/Silver Met/Energy Aqua
## 7
## Glacier Gray,Black/Cornstalk
## 2
## Gold Metallic,Black,Medium Brown,Bordo,Peach,Medium Brown Leather,Black Patent,White
## 14
## Gray,Blue
## 4
## Gray/Berry,Stone/Mint
## 7
## Gray/Sky
## 1
## Graysilver,Naturalgold
## 1
## Grey
## 10
## Grey Pu,Black Pu
## 4
## Grey Three/Utility Black/Grey Four,White/Energy Aqua/Mystery Petrol,Coreblack/Footwear White/Footwear White
## 6
## Grey,Dark Brown,Chestnut,Brown
## 2
## Grey,Dark Brown,Taupe
## 1
## Grey,Light Blue,Navy
## 7
## Grey/Blue
## 2
## Grey/Coral
## 4
## Grey/Pink,Azalea/Grey
## 3
## Gunsmoke/Solar Red-Hot Punch-Vast Grey,Cool Grey/Black/Pure Platinum/White,Black/White/Dark Grey/Wolf Grey
## 2
## Habana Oiled Leather,Black Oiled Leather,Tobacco Oiled Leather
## 2
## Highrisewhite,Flamingo Pinkwhite,Whitewhite,Beaujolaiswhite,Brooke Greenwhite,Blackwhite
## 5
## Honey Leather/Blue Chambray,Black Leather/Chambray
## 2
## Honey,White
## 1
## Ice/Red,Black/Fuchsia
## 4
## Indigo Blue/Aqua Splash/Diva Blue
## 1
## Indigo Blue/Silver/Prune
## 1
## Insignia Blue/Silver/Glacier Sea,Carbon/Silver/Arctic Aqua,Black/Bay/Diva Pink,Regatta Blue/Flash Coral/Indigo Blue
## 1
## Insignia Blue/Silver/Rouge Red,Dark Grey/Silver/Glacier Sea
## 3
## Insignia Blueshamrock Green,Blueblue Pufabric,Greypurple Pufabric,Whitegrey Pufabric,Blackgrey Pufabric,Blackfrost Grey,Redpink Pufabric,Tanwhite Pufabric
## 18
## Ivory,Black,Nude,Grey,Red
## 1
## Ivory,Black,Nude,Red
## 1
## Ivory,Navy,Black,Brown,Gray,Grey,Dark Tan,Navy Synthetic,Blue,Dark Tan Synthetic
## 44
## Jiffy Black/Shell White/Shell White,Pigeon Grey/Bone White/Shell White
## 8
## Liberty/Fuchsia,Poseidon/Vintage Indigo
## 1
## Light Blue,Brown,Navy,Purple,Burgundy,Black,Natural
## 2
## Light Blue/Coral,Black
## 4
## Lilac
## 1
## Marine,Black,Natural
## 4
## Maroon,Leopard,Grey
## 1
## Mauve
## 1
## Me Time Blackwhite
## 34
## Metallic Multi,Pewterchampagne Polyurethane,Black,White,Black Polyurethane,Natural,Bronze
## 43
## Mushroom Fabric,Black Pu,Black Fabric,Dark Red Pu,Taupe Pu,Tornado Pu
## 39
## N/a,Kiwi,Blue,Black
## 1
## Nasturtium/Blue Bird/Black
## 1
## Navy
## 7
## Navy Blazer Stripe
## 1
## Navy Multi,Silver Teal,AquariumFlashCoralBlueJewel
## 11
## Navy-Plum-Ice Blue
## 3
## Navy-Teal-Mint,Ebony-Silver-Pink
## 3
## Navy,Black,Black Patent Manmade,Black Manmade,Rainbow Swirl Manmade,Beige,Red,Gray Patent Manmade,Navy Patent Manmade,Blue,Beige NubuckLeather
## 19
## Navy,Black,Brown,White,Gray,Soft Gold,Luggage,Gold,Soft Gold Syntheticgore,Blue
## 77
## Navy,Black,Gray,Teal,Light Purple,Beige,Light Blue,Red,Red Textile,Grey Textile,Purple Mesh Textile,Blue Textile,Black Textile
## 20
## Navy,Black,Grey,Beige,Red
## 1
## Navy,Black,Pewter,Punch,Soft Gold,White Sand
## 86
## Navy,Brown Polyurethane,Black Tool Polyurethane,Gore,Tan Burnished,Brown Tool Polyurethane,Black Lamey,Navy Tool,Black Smooth
## 39
## Navy,Grey
## 1
## Neon Pink/Black/White,Black/Berry/Teal
## 1
## Neutral Grey/Whisper
## 2
## Orange
## 1
## Oro Legacy Leather
## 1
## Pearl Grey,Black
## 5
## Pink,Black and Pink,Pink and White
## 1
## Pink,Black,Bone,Grey
## 39
## Pink,White,Blue
## 1
## Pink,White,Gray,Black,Brown
## 1
## Platinum
## 1
## Primer Grey/Teal Victory/Silver,Purple-Pink-Teal,Black/Pink Peacock/Living Coral,Diva Pink/Black/Iceland Blue
## 4
## Raspberry/white Thermabuck,Brownbark Perma Hide,Black Durabrush,Charcoalcreamgumblue-Black Thermabuck,Golden Wheatcreamgum Thermabuck,Brown/bark Perma Hide,Golden Wheat/cream/gum Thermabuck,Black/cream/gum Durabrush,Raspberrywhite Thermabuck
## 4
## Red Ochre,Slate Navy,Bleach
## 4
## Red/Red,Black/Black,Turquoise/Navy
## 5
## Reflecting/Mallard Blue,Tibet Red/Sangria/Lime
## 3
## Sand,Navy
## 1
## Silver Mink/White
## 1
## Silver,Blackgreenbrown Meshpu,Leopard,Blackgreen,Redyellow
## 18
## Silver,Cream Watercolor Floral
## 1
## Silver,Pink
## 1
## Silver/Pistachio/Pink
## 1
## Slate,Black Heather
## 2
## Slate/Sulphur
## 1
## Stone
## 1
## Stone,Black,Brown,Grey
## 2
## Stone,Black,Grey,Taupe
## 94
## Summit White/Blue Tint-Ivory
## 1
## Super Purple/Footwear White/Energy Aqua
## 3
## Sweet Violet/Budding Green
## 1
## Tan Faux Leather
## 92
## Tan,Navy
## 2
## Taupe
## 1
## Taupe Suede,Mocha Suede
## 3
## Taupe White
## 6
## Taupe,White
## 3
## Teal/Dark Red/Black
## 1
## Teal/Navy/Purple
## 2
## Team Colors
## 1
## Tideline,Fusion Coral
## 1
## True Navy,Cabana Blue,Bleach
## 1
## Turquo,Black,Yellow,Navy,Natural,Coral,Pewter
## 48
## Twilight/Mauveine,Blue Nights/Coral,Caraibes/Blue Nights
## 3
## Virtual Pink/Black/Enamel Blue,Fair Aqua/Crown Blue/Sulphur Spring
## 5
## White
## 165
## White,Black
## 1
## White,Grey Mint
## 1
## White/Silver,Blue/Mint/Black
## 3
## Whitebrooke Green,Blacksmoky Grapewhite,Stingraywhite
## 5
## Whitefire Pink-Comet Blue
## 17
## Wood,Cashew,Fatigue
## 3### mean_price max + low
shoe_sales$mean_price <- round((shoe_sales$prices.amountMax + shoe_sales$prices.amountMax) / 2 )
### turn it into lower case to get rid of duplicate brand name
shoe_sales$brand <- tolower(shoe_sales$brand)
table(shoe_sales$brand)##
## 2 lips too a2 by aerosoles
## 19 670
## adidas adidas outdoor
## 95 5
## altra andrew geller
## 21 3
## apt. 9 arc'teryx
## 183 3
## asics astral
## 130 10
## betula by birkenstock birkenstock
## 1 6
## bogs brinley co.
## 1 37
## brinley co. collection brooks
## 39 19
## candies carrini
## 144 1
## chaco clarks
## 2 39
## corkys croft barrow
## 1 315
## daniel green danskin now
## 1 1
## dansko dolce by mojo moxy
## 4 58
## dr. scholl's dr. scholls
## 1 337
## earth spirit eastland
## 2 56
## easy street ellie shoes
## 585 1
## faded glory fergalicious
## 4 4
## fila forever collectibles
## 23 1
## forever young free people
## 1 2
## frye genuine dickies
## 8 1
## henry ferrera herstar
## 2 2
## hoka one one ib non-slip
## 7 1
## inov 8 jennifer lopez
## 10 24
## journee collection k-swiss
## 2182 10
## kaanas keds
## 1 22
## keen kisses by 2 lips too
## 2 23
## koolaburra by ugg la sportiva
## 18 8
## laredo lc lauren conrad
## 6 69
## lifestride lowa
## 1593 7
## lugz madden nyc
## 5 84
## mammut merrell
## 2 13
## mlb mo mo
## 1 3
## muk luks native shoes
## 19 8
## naturalizer naturalsoul by naturalizer
## 1 107
## new balance nike
## 267 464
## nyla olivia miller
## 1 1
## olukai on footwear
## 14 2
## otzshoes puma
## 1 7
## qupid rampage
## 3 20
## red wing reef
## 5 7
## riverberry rocky 4eursole
## 1 11
## ryka salewa
## 147 1
## salomon saucony
## 31 5
## scarpa seavees
## 4 26
## seven7 seychelles footwear
## 14 2
## silver lilly simply vera vera wang
## 1 164
## skechers sloggers
## 336 1
## so soft ones
## 422 1
## soft style by hush puppies softwalk
## 25 1
## soludos sonoma goods for life
## 9 229
## sperry top-sider splendid
## 10 7
## spring step style charles by charles david
## 79 478
## sugar the north face
## 8 1
## timberland toms
## 3 10
## topo athletic ugg
## 10 3
## unbranded under armour
## 3 14
## unionbay unique bargains
## 55 1
## vans victoria k.
## 30 1### replace word
for ( i in 1:nrow(shoe_sales)) {
if( grepl("adidas", shoe_sales[i,6]) == "TRUE" ) {
shoe_sales[i,6] <- "adidas" }
else { if ( grepl("birkenstock", shoe_sales[i,6]) == "TRUE" ) {
shoe_sales[i,6] <- "birkenstock" }
else{ if( grepl("brinley co.", shoe_sales[i,6]) == "TRUE" ) {
shoe_sales[i,6] <- "brinley co." }
else{ if( grepl("dr. scholl's", shoe_sales[i,6]) == "TRUE" ) {
shoe_sales[i,6] <- "dr. scholl's" }
else{ if( grepl("naturalizer", shoe_sales[i,6]) == "TRUE" ) {
shoe_sales[i,6] <- "naturalizer" } } } } } }
table(shoe_sales$brand)##
## 2 lips too a2 by aerosoles
## 19 670
## adidas altra
## 100 21
## andrew geller apt. 9
## 3 183
## arc'teryx asics
## 3 130
## astral birkenstock
## 10 7
## bogs brinley co.
## 1 76
## brooks candies
## 19 144
## carrini chaco
## 1 2
## clarks corkys
## 39 1
## croft barrow daniel green
## 315 1
## danskin now dansko
## 1 4
## dolce by mojo moxy dr. scholl's
## 58 1
## dr. scholls earth spirit
## 337 2
## eastland easy street
## 56 585
## ellie shoes faded glory
## 1 4
## fergalicious fila
## 4 23
## forever collectibles forever young
## 1 1
## free people frye
## 2 8
## genuine dickies henry ferrera
## 1 2
## herstar hoka one one
## 2 7
## ib non-slip inov 8
## 1 10
## jennifer lopez journee collection
## 24 2182
## k-swiss kaanas
## 10 1
## keds keen
## 22 2
## kisses by 2 lips too koolaburra by ugg
## 23 18
## la sportiva laredo
## 8 6
## lc lauren conrad lifestride
## 69 1593
## lowa lugz
## 7 5
## madden nyc mammut
## 84 2
## merrell mlb
## 13 1
## mo mo muk luks
## 3 19
## native shoes naturalizer
## 8 108
## new balance nike
## 267 464
## nyla olivia miller
## 1 1
## olukai on footwear
## 14 2
## otzshoes puma
## 1 7
## qupid rampage
## 3 20
## red wing reef
## 5 7
## riverberry rocky 4eursole
## 1 11
## ryka salewa
## 147 1
## salomon saucony
## 31 5
## scarpa seavees
## 4 26
## seven7 seychelles footwear
## 14 2
## silver lilly simply vera vera wang
## 1 164
## skechers sloggers
## 336 1
## so soft ones
## 422 1
## soft style by hush puppies softwalk
## 25 1
## soludos sonoma goods for life
## 9 229
## sperry top-sider splendid
## 10 7
## spring step style charles by charles david
## 79 478
## sugar the north face
## 8 1
## timberland toms
## 3 10
## topo athletic ugg
## 10 3
## unbranded under armour
## 3 14
## unionbay unique bargains
## 55 1
## vans victoria k.
## 30 1n_distinct(shoe_sales$brand)## [1] 112##lower case
shoe_sales$categories <- tolower(shoe_sales$categories)
### replace word ( only for woman)
for ( i in 1:nrow(shoe_sales)) {
if( grepl("women", shoe_sales[i,7]) == "TRUE" ) {
shoe_sales[i,7] <- "Women's shoes" } }
table(shoe_sales$categories) ## all women shoes ##
## Women's shoes
## 10000### combine the data
shoe_sales_margin <- shoe_sales %>% group_by(id,date) %>% summarise(
price=round(mean(mean_price)),
brand = first(brand),
order= n()
)
##### this is not a sale file !!!
write.csv(shoe_sales,"~/Desktop/Simulation//shoe_sales_clean.csv", row.names = FALSE)
############################################# word cloud making
# create corpus from vector 字串轉成向量
corpus = Corpus(VectorSource(shoe_sales$colors))
corpus[[1]]$content # content of the first document## [1] "Silver,Cream Watercolor Floral"# 轉為小寫
corpus = tm_map(corpus, content_transformer(tolower))## Warning in tm_map.SimpleCorpus(corpus, content_transformer(tolower)):
## transformation drops documentscorpus[[1]]$content ## [1] "silver,cream watercolor floral"##移除標點符號
# some version of tm may have to do the commmad below
# corpus = tm_map(corpus, PlainTextDocument)
corpus = tm_map(corpus, removePunctuation)## Warning in tm_map.SimpleCorpus(corpus, removePunctuation): transformation
## drops documents##去除贅字 (特別去除Kobe，因為每篇都幾乎都會提到)
corpus = tm_map(corpus, removeWords,stopwords("english"))## Warning in tm_map.SimpleCorpus(corpus, removeWords, stopwords("english")):
## transformation drops documentscorpus[[1]]$content ## [1] "silvercream watercolor floral"frequencies = DocumentTermMatrix(corpus)
frequencies## <<DocumentTermMatrix (documents: 10000, terms: 547)>>
## Non-/sparse entries: 10399/5459601
## Sparsity : 100%
## Maximal term length: 42
## Weighting : term frequency (tf)##移除頻率太低的字詞
sparse = removeSparseTerms(frequencies, 0.995)
sparse## <<DocumentTermMatrix (documents: 10000, terms: 47)>>
## Non-/sparse entries: 5987/464013
## Sparsity : 99%
## Maximal term length: 32
## Weighting : term frequency (tf)###轉成矩陣
tweetsSparse = as.data.frame(as.matrix(sparse))
# Make all variable names R-friendly
colnames(tweetsSparse) = make.names(colnames(tweetsSparse))
head(tweetsSparse)## black brown white navy pinkblack leather blackgreytaupe
## 1 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0
## 4 1 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0
## 6 0 1 0 0 0 0 0
## stoneblackgreytaupe blue fabricblack red goldwhite
## 1 0 0 0 0 0
## 2 0 0 0 0 0
## 3 0 0 0 0 0
## 4 0 0 0 0 0
## 5 0 0 0 0 0
## 6 0 0 0 0 0
## navyblackpewterpunchsoft sand combpatentluxe polyurethanesilver
## 1 0 0 0 0
## 2 0 0 0 0
## 3 0 0 0 0
## 4 0 0 0 0
## 5 0 0 0 0
## 6 0 0 0 0
## polyurethanestone pudark pustone underglass denim faux leatherblue
## 1 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0
## twillpewter gold blackchromeaurora fury greenhot platinumblue punchpure
## 1 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0
## polyurethaneblack synthetic syntheticpewter syntheticred anthracitedark
## 1 0 0 0 0 0
## 2 0 0 0 0 0
## 3 0 0 0 0 0
## 4 0 0 0 0 0
## 5 0 0 0 0 0
## 6 0 0 0 0 0
## greyblackinkdeadly pinkfire blackmetallic silveranthracite tan
## 1 0 0 0 0 0
## 2 0 0 0 0 0
## 3 0 0 0 0 0
## 4 0 0 0 0 0
## 5 0 0 0 0 0
## 6 0 0 0 0 0
## blackpewterwhitegraybeigetannavy syntheticblack syntheticbluenavywhite
## 1 0 0 0
## 2 0 0 0
## 3 0 0 0
## 4 0 0 0
## 5 0 0 0
## 6 0 0 0
## synthetictan goldluggagegoldsoft navyblackbrownwhitegraysoft
## 1 0 0 0
## 2 0 0 0
## 3 0 0 0
## 4 0 0 0
## 5 0 0 0
## 6 0 0 0
## syntheticgoreblue
## 1 0
## 2 0
## 3 0
## 4 0
## 5 0
## 6 0names(colSums(tweetsSparse)) -> t1
colSums(tweetsSparse) %>% as.data.frame() -> t2
t2$Var <- t1
names(t2) <- c("Freq","Var")
as.data.frame(t1) -> t1
t1$Freq <- t2$Freq
names(t1) <- c("Var","Freq")
### 載入字頻表封包
library(wordcloud2)
wordcloud2(t1)library(readr)
shop_nordstrom_com <- read_csv("shop_nordstrom_com.csv",
col_types = cols(mrp = col_number(),
price = col_number(), review_count = col_number()))## Warning in rbind(names(probs), probs_f): number of columns of result is not
## a multiple of vector length (arg 1)## Warning: 4690 parsing failures.
## row # A tibble: 5 x 5 col row col expected actual file expected <int> <chr> <chr> <chr> <chr> actual 1 8 review_count a number NULL 'shop_nordstrom_com.csv' file 2 9 review_count a number NULL 'shop_nordstrom_com.csv' row 3 12 review_count a number NULL 'shop_nordstrom_com.csv' col 4 13 review_count a number NULL 'shop_nordstrom_com.csv' expected 5 16 review_count a number NULL 'shop_nordstrom_com.csv'
## ... ................. ... ............................................................. ........ ............................................................. ...... ............................................................. .... ............................................................. ... ............................................................. ... ............................................................. ........ .............................................................
## See problems(...) for more details.View(shop_nordstrom_com)
############################################# word cloud making
# create corpus from vector 字串轉成向量
corpus2 = Corpus(VectorSource(shop_nordstrom_com$color))
corpus2[[1]]$content # content of the first document## [1] "Black"# 轉為小寫
corpus2 = tm_map(corpus2, content_transformer(tolower))## Warning in tm_map.SimpleCorpus(corpus2, content_transformer(tolower)):
## transformation drops documentscorpus2[[1]]$content ## [1] "black"##移除標點符號
# some version of tm may have to do the commmad below
# corpus = tm_map(corpus, PlainTextDocument)
corpus2 = tm_map(corpus2, removePunctuation)## Warning in tm_map.SimpleCorpus(corpus2, removePunctuation): transformation
## drops documents##去除贅字 (特別去除Kobe，因為每篇都幾乎都會提到)
corpus2 = tm_map(corpus2, removeWords,stopwords("english"))## Warning in tm_map.SimpleCorpus(corpus2, removeWords, stopwords("english")):
## transformation drops documentscorpus2[[1]]$content ## [1] "black"frequencies2 = DocumentTermMatrix(corpus2)
frequencies2## <<DocumentTermMatrix (documents: 12568, terms: 206)>>
## Non-/sparse entries: 19580/2569428
## Sparsity : 99%
## Maximal term length: 15
## Weighting : term frequency (tf)##移除頻率太低的字詞
sparse2 = removeSparseTerms(frequencies2, 0.995)
sparse2## <<DocumentTermMatrix (documents: 12568, terms: 61)>>
## Non-/sparse entries: 15574/751074
## Sparsity : 98%
## Maximal term length: 11
## Weighting : term frequency (tf)###轉成矩陣
tweetsSparse2 = as.data.frame(as.matrix(sparse2))
# Make all variable names R-friendly
colnames(tweetsSparse2) = make.names(colnames(tweetsSparse2))
head(tweetsSparse2)## black nude white navy sand conch shell blue natural beige ice peach
## 1 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 1 0 0 0 0 0 0 0 0 0 0
## 3 0 0 1 0 0 0 0 0 0 0 0 0
## 4 0 0 0 1 0 0 0 0 0 0 0 0
## 5 1 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 1 0 0 0 0 0 0 0
## vanilla night desert ivory sunset lake light lilac pink chai bare
## 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0
## naturally marshmallow mocha yarrow grey violet multi toast campanula
## 1 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0
## granite coral soft heather sleet royal fresh taupe dark glow candy
## 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0
## cotton logo turquoise stripe wood haze purple red rose bridal cappuccino
## 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0
## bright bliss ripple teal floral graphite frappe
## 1 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0names(colSums(tweetsSparse2)) -> t1
colSums(tweetsSparse2) %>% as.data.frame() -> t2
t2$Var <- t1
names(t2) <- c("Freq","Var")
as.data.frame(t1) -> t1
t1$Freq <- t2$Freq
names(t1) <- c("Var","Freq")
### 載入字頻表封包
library(wordcloud2)
wordcloud2(t1)####
table(shop_nordstrom_com$brand_name)##
## B.TEMPT'D BY WACOAL CALVIN KLEIN HANKY PANKY
## 912 3142 4582
## NORDSTROM LINGERIE WACOAL
## 870 3062write.csv(shop_nordstrom_com,"~/Desktop/Simulation//shop_nordstrom_com2.csv", row.names = FALSE)####Import data set
## compnay 1 underwear
library(readr)
victor <- read_csv("victoriassecret_com.csv",
col_types = cols(price = col_number()))
View(victor)
## compnay 2 underwear
library(readr)
topshop <- read_csv("us_topshop_com.csv",
col_types = cols(price = col_number()))
View(topshop)
## compnay 3 underwear
nordstrom <- read_csv("shop_nordstrom_com.csv",
col_types = cols(mrp = col_number(),
price = col_number(), review_count = col_number()))## Warning in rbind(names(probs), probs_f): number of columns of result is not
## a multiple of vector length (arg 1)## Warning: 4690 parsing failures.
## row # A tibble: 5 x 5 col row col expected actual file expected <int> <chr> <chr> <chr> <chr> actual 1 8 review_count a number NULL 'shop_nordstrom_com.csv' file 2 9 review_count a number NULL 'shop_nordstrom_com.csv' row 3 12 review_count a number NULL 'shop_nordstrom_com.csv' col 4 13 review_count a number NULL 'shop_nordstrom_com.csv' expected 5 16 review_count a number NULL 'shop_nordstrom_com.csv'
## ... ................. ... ............................................................. ........ ............................................................. ...... ............................................................. .... ............................................................. ... ............................................................. ... ............................................................. ........ .............................................................
## See problems(...) for more details.View(nordstrom)
## compnay 4 underwear
hankypanky <- read_csv("hankypanky_com.csv",
col_types = cols(price = col_number()))
View(hankypanky)
### compnay 5 underwear
macys <- read_csv("macys_com.csv", col_types = cols(price = col_number()))
View(macys)
### compnay 6 underwear
ck <- read_csv("calvinklein_com.csv",
col_types = cols(price = col_number()))
View(ck)
### compnay 7 underwear
btemptd <- read_csv("btemptd_com.csv",
col_types = cols(price = col_number()))
View(btemptd)
### compnay 8 underwear
amazon <- read_csv("amazon_com.csv",
col_types = cols(price = col_number()))
View(amazon)
### company 9
ae <- read_csv("ae_com.csv", col_types = cols(price = col_number()))
View(ae)
##### combining all the dataset from different channels
names(victor)## [1] "product_name" "mrp" "price"
## [4] "pdp_url" "brand_name" "product_category"
## [7] "retailer" "description" "rating"
## [10] "review_count" "style_attributes" "total_sizes"
## [13] "available_size" "color"underwear <-
rbind (victor[,c("product_name","price","brand_name","product_category","retailer","color" )],topshop[,c("product_name","price","brand_name","product_category","retailer","color" )],nordstrom[,c("product_name","price","brand_name","product_category","retailer","color" )],hankypanky[,c("product_name","price","brand_name","product_category","retailer","color" )],macys[,c("product_name","price","brand_name","product_category","retailer","color" )],ck[,c("product_name","price","brand_name","product_category","retailer","color" )],btemptd[,c("product_name","price","brand_name","product_category","retailer","color" )],amazon[,c("product_name","price","brand_name","product_category","retailer","color" )],ae[,c("product_name","price","brand_name","product_category","retailer","color" )])table(underwear$retailer) ### 9 retail channel ##
## Ae US Amazon US Btemptd US
## 28328 31612 3518
## Calvin Klein US Hankypanky US Macys US
## 4747 35005 40897
## Nordstrom US Topshop US Victoriassecret US
## 12568 3082 453386table(underwear$brand_name) %>% as.data.frame() -> brandname
################### Brand name cleaning
### turn it into lower case to get rid of duplicate brand name
underwear$brand_name <- tolower(underwear$brand_name)
table(underwear$brand_name) %>% as.data.frame() -> brandname
### replace word
for ( i in 1:nrow(underwear)) {
if( grepl("aeo", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Aeo" } }
for ( i in 1:nrow(underwear)) {
if ( grepl("aerie", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Aerie" } }
for ( i in 1:nrow(underwear)) {
if( grepl("tempt", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "B-temptd" } }
for ( i in 1:nrow(underwear)) {
if( grepl("calvin", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Calvin Klein" } }
for ( i in 1:nrow(underwear)) {
if( grepl("hanky", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Hanky Panky" } }
for ( i in 1:nrow(underwear)) {
if( grepl("nordstrom lingerie", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Nordstrom lingerie" } }
for ( i in 1:nrow(underwear)) {
if( grepl("us topshop", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Topshop" } }
for ( i in 1:nrow(underwear)) {
if( grepl("vanity fair", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Vanity fair" } }
for ( i in 1:nrow(underwear)) {
if( grepl("victoria", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Victoria's Secret" } }
for ( i in 1:nrow(underwear)) {
if( grepl("wacoal", underwear[i,3]) == "TRUE" ) {
underwear[i,3] <- "Wacoal" } }
table(underwear$brand_name) %>% as.data.frame() -> brandname
underwear1 <- underwear
### 太大跑不動
#####for ( i in 1:nrow(underwear)) {
#### if( grepl("aeo", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Aeo" }
#### else { if ( grepl("aerie", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Aerie" }
#### else{ if( grepl("tempt", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "B-temptd" }
#### else{ if( grepl("calvin", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Calvin Klein" }
#### else{ if( grepl("hanky", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Hanky Panky" }
#### else{ if( grepl("nordstrom lingerie", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Nordstrom lingerie" }
#### else{ if( grepl("us topshop", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Topshop" }
#### else{ if( grepl("vanity fair", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Vanity fair" }
#### else{ if( grepl("victoria", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Victoria's Secret" }
#### else{ if( grepl("wacoal", underwear[i,3]) == "TRUE" ) {
#### underwear[i,3] <- "Wacoal" } } } } } } } } } } }
#### remove useless brand name
underwear[-(which(underwear$brand_name == "compression-comfort")),] -> underwear
underwear[-(which(underwear$brand_name == "creative-motion")),] -> underwear
underwear[-(which(underwear$brand_name == "fila")),] -> underwear
underwear[-(which(underwear$brand_name == "lucky-brand")),] -> underwear
underwear[-(which(underwear$brand_name == "nintendo")),] -> underwear
underwear[-(which(underwear$brand_name == "s")),] -> underwear
underwear[-(which(underwear$brand_name == "sexy-hair")),] -> underwear
table(underwear$brand_name) %>% as.data.frame() -> brandname ####613134 obs
write.csv(underwear,"~/Desktop/Simulation//underwear.csv", row.names = FALSE)############### prouct category cleaning
table(underwear$product_category) %>% as.data.frame() -> productcategory
underwear$product_category <- tolower(underwear$product_category)
### replace word
for ( i in 1:nrow(underwear)) {
if( grepl("demi bra", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Demi bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("push-up", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Push-up bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("push-up", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Push-up bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("sport bra", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Sport bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("push up", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Push-up bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("sports bra", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "Sport bra" } }
for ( i in 1:nrow(underwear)) {
if( grepl("t-shirt bra", underwear[i,4]) == "TRUE" ) {
underwear[i,4] <- "T-shirt bra" } }
for ( i in 1:nrow(underwear)) {
if( underwear[i,4] == "bras" ) {
underwear[i,4] <- "Bras" } }
for ( i in 1:nrow(underwear)) {
if( underwear[i,4] == "bralettes" ) {
underwear[i,4] <- "Bras" } }
for ( i in 1:nrow(underwear)) {
if( underwear[i,4] == "bralettes & bras" ) {
underwear[i,4] <- "Bras" } }
for ( i in 1:nrow(underwear)) {
if( underwear[i,4] == "bralettes and bras" ) {
underwear[i,4] <- "Bras" } }
for ( i in 1:nrow(underwear)) {
if( underwear[i,4] == "women - lingerie & shapewear - bras" ) {
underwear[i,4] <- "Bras" } }
underwear[which(underwear$product_category == "perfect shape bra"),4] <- "Bras"
underwear[which(underwear$product_category == "wicked unlined uplift bra"),4] <- "push-up bra"
underwear[which(underwear$product_category == "bras-and-tops"),4] <- "bras"
underwear[which(underwear$product_category == "lace triangle underwire bralette"),4] <- "bras"
underwear[which(underwear$product_category == "wear everywhere lightly lined bra"),4] <- "bras"
underwear[which(underwear$product_category == "Bras"),4] <- "bras"
underwear[which(underwear$product_category == "scoopneck bralette"),4] <- "bras"
######
underwear -> underwear2
for ( i in 1:nrow(underwear)) {
if( grepl("bras", underwear[i,4]) & grepl("lace", underwear[i,4]) ) {
underwear[i,4] <- "lace bras" } }
for ( i in 1:nrow(underwear)) {
if( grepl("lace", underwear[i,4]) & grepl("panty", underwear[i,4]) ) {
underwear[i,4] <- "lace panty" } }
for ( i in 1:nrow(underwear)) {
if( grepl("lace", underwear[i,4]) & grepl("panties", underwear[i,4]) ) {
underwear[i,4] <- "lace panty" } }
for ( i in 1:nrow(underwear)) {
if( grepl("lace", underwear[i,4]) & grepl("bralette", underwear[i,4]) ) {
underwear[i,4] <- "lace bras" } }
for ( i in 1:nrow(underwear)) {
if( grepl("lace", underwear[i,4]) & grepl("bralettes", underwear[i,4]) ) {
underwear[i,4] <- "lace bras" } }
for ( i in 1:nrow(underwear)) {
if( grepl("lace", underwear[i,4]) & grepl("thong", underwear[i,4]) ) {
underwear[i,4] <- "lace panty" } }
underwear[which(underwear$product_category == "women - lingerie & shapewear - panties"),4] <- "panties"
underwear[which(underwear$product_category == "thongs"),4] <- "panties"
underwear[which(underwear$product_category == "women - lingerie & shapewear - designer lingerie"),4] <- "panties"
underwear[which(underwear$product_category == "lingerie"),4] <- "panties"
underwear[which(underwear$product_category == "women's panties"),4] <- "panties"
underwear[which(underwear$product_category == "wear everywhere super push"),4] <- "push-up bra"
underwear[which(underwear$product_category == "thong panty"),4] <- "panties"
underwear[which(underwear$product_category == "logo thong"),4] <- "panties"
underwear[which(underwear$product_category == "everyday loves undies 6 for $26 usd"),4] <- "panties"
underwear[which(underwear$product_category == "logo thong"),4] <- "panties"
underwear[which(underwear$product_category == "sexy lingerie"),4] <- "lace panty"
underwear[which(underwear$product_category == "women - lingerie & shapewear - bridal lingerie"),4] <- "panties"
underwear[which(underwear$product_category == "panties"),4] <- "panty"
underwear[which(underwear$product_category == "everyday loves undies 7 for $27.50 usd"),4] <- "panty"
underwear[which(underwear$product_category == "women - lingerie & shapewear - sexy lingerie"),4] <- "lace panty"
underwear[which(underwear$product_category == "women - lingerie & shapewear - sexy lingerie"),4] <- "lace panty"
####改名lace panty 不被覆蓋
underwear2 -> underwear
underwear[which(underwear$product_category == "lace panties"),4] <- "lace panty"
which(underwear$product_category == "lace panty")## integer(0)for ( i in 1:nrow(underwear)) {
if( grepl("panty", underwear[i,4])) {
underwear[i,4] <- "panty" } }
########## done!!!!
### extract the data
which(underwear$product_category == c("panty","lace panty","push-up bra","bras","sport bra","demi bra","t-shirt bra","lace bras")) %>% n_distinct()## Warning in underwear$product_category == c("panty", "lace panty", "push-up
## bra", : longer object length is not a multiple of shorter object length## [1] 15168which(underwear$product_category == "push-up bra") -> a1
which(underwear$product_category == "panty") -> a2
which(underwear$product_category == "lace panty") -> a3
which(underwear$product_category == "bras") -> a4
which(underwear$product_category == "sport bra") -> a5
which(underwear$product_category == "demi bra") -> a6
which(underwear$product_category == "t-shirt bra") -> a7
which(underwear$product_category == "lace bras") -> a8
underwear[c(a1,a2,a3,a4,a5,a6,a7,a8),] -> underwear_clean
table(underwear_clean$brand_name) ##
## Aerie B-temptd Calvin Klein
## 2812 4429 11222
## Hanky Panky Nordstrom lingerie Vanity fair
## 5446 110 1509
## Victoria's Secret Wacoal
## 72474 22786unique(underwear_clean) -> underwear_clean_unique
table(underwear_clean_unique$brand_name)##
## Aerie B-temptd Calvin Klein
## 440 619 1340
## Hanky Panky Nordstrom lingerie Vanity fair
## 416 16 161
## Victoria's Secret Wacoal
## 1871 2006write.csv(underwear_clean_unique,"~/Desktop/Simulation//underwear_clean.csv", row.names = FALSE)You can also embed plots, for example: ### color underwear
## [1] "peach melba"## Warning in tm_map.SimpleCorpus(corpus3, content_transformer(tolower)):
## transformation drops documents## [1] "peach melba"## Warning in tm_map.SimpleCorpus(corpus3, removePunctuation): transformation
## drops documents## Warning in tm_map.SimpleCorpus(corpus3, removeWords, stopwords("english")):
## transformation drops documents## [1] "peach melba"## <<DocumentTermMatrix (documents: 24045, terms: 1348)>>
## Non-/sparse entries: 43486/32369174
## Sparsity : 100%
## Maximal term length: 29
## Weighting : term frequency (tf)## <<DocumentTermMatrix (documents: 24045, terms: 73)>>
## Non-/sparse entries: 24576/1730709
## Sparsity : 99%
## Maximal term length: 10
## Weighting : term frequency (tf)## peach black plum blue ensign orchid coconut white multi stripe marl grey
## 1 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 1 0 0 0 0 0 0 0 0 0 0
## 3 0 0 1 0 0 0 0 0 0 0 0 0
## 4 0 0 0 1 1 0 0 0 0 0 0 0
## 5 0 0 0 0 0 1 0 0 0 0 0 0
## 6 0 0 0 1 0 0 0 0 0 0 0 0
## logo print red teal buff violet pure green champagne floral denim faded
## 1 0 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0 0
## sea silver wine fir pink blush powder rose taupe mauve rosy lace cool
## 1 0 0 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0 0 0
## maroon nude pearl back coral dark glaze ginger bright light tropical
## 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0
## midnight sunset heather solid ivory large purple gray turquoise wild
## 1 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0
## night medium deep soft navy sand natural vanilla chai bare naturally
## 1 0 0 0 0 0 0 0 0 0 0 0
## 2 0 0 0 0 0 0 0 0 0 0 0
## 3 0 0 0 0 0 0 0 0 0 0 0
## 4 0 0 0 0 0 0 0 0 0 0 0
## 5 0 0 0 0 0 0 0 0 0 0 0
## 6 0 0 0 0 0 0 0 0 0 0 0
## cappuccino true small muslin
## 1 0 0 0 0
## 2 0 0 0 0
## 3 0 0 0 0
## 4 0 0 0 0
## 5 0 0 0 0
## 6 0 0 0 0duplicated(sale_report$User_ID) %>% table() #### 5891 unique customer ## .
## FALSE TRUE
## 5891 531686table(sale_report$Product_ID)##
## P00000142 P00000242 P00000342 P00000442 P00000542 P00000642 P00000742
## 1130 371 238 92 146 512 238
## P00000842 P00000942 P00001042 P00001142 P00001242 P00001342 P00001442
## 36 54 494 572 99 61 83
## P00001542 P00001642 P00001742 P00001842 P00001942 P00002042 P00002142
## 68 349 449 76 209 91 728
## P00002242 P00002342 P00002442 P00002542 P00002642 P00002742 P00002842
## 195 66 325 532 62 39 83
## P00002942 P00003042 P00003142 P00003242 P00003342 P00003442 P00003542
## 219 37 87 830 2 951 35
## P00003642 P00003742 P00003842 P00003942 P00004042 P00004142 P00004242
## 503 4 16 730 12 118 113
## P00004342 P00004442 P00004542 P00004642 P00004742 P00004842 P00004942
## 93 143 275 90 591 207 19
## P00005042 P00005142 P00005242 P00005342 P00005442 P00005542 P00005642
## 955 224 4 26 25 4 47
## P00005742 P00005842 P00005942 P00006042 P00006142 P00006242 P00006342
## 269 5 180 36 291 60 39
## P00006442 P00006542 P00006642 P00006742 P00006842 P00006942 P00007042
## 89 57 2 27 187 495 43
## P00007142 P00007242 P00007342 P00007442 P00007542 P00007642 P00007742
## 46 121 67 5 78 18 31
## P00007842 P00007942 P00008042 P00008142 P00008242 P00008342 P00008442
## 64 28 88 50 19 14 106
## P00008542 P00008642 P00008742 P00008842 P00008942 P00009042 P00009142
## 124 47 107 105 1 44 47
## P00009242 P00009342 P00009442 P00009542 P00009642 P00009742 P00010042
## 109 349 7 28 3 24 26
## P00010142 P00010242 P00010342 P00010442 P00010542 P00010642 P00010742
## 21 348 201 8 131 4 1331
## P00010842 P00010942 P00011042 P00011142 P00011242 P00011342 P00011442
## 662 303 31 6 25 40 35
## P00011542 P00011642 P00011742 P00011842 P00011942 P00012042 P00012142
## 5 3 19 90 62 5 183
## P00012242 P00012342 P00012442 P00012542 P00012742 P00012842 P00012942
## 51 1 7 5 9 42 1
## P00013142 P00013242 P00013342 P00013442 P00013542 P00013642 P00013742
## 71 7 3 1 1 67 350
## P00013842 P00013942 P00014042 P00014142 P00014242 P00014342 P00014442
## 1 233 193 9 105 10 23
## P00014542 P00014642 P00014742 P00014842 P00014942 P00015042 P00015142
## 665 313 36 407 92 48 32
## P00015242 P00015342 P00015442 P00015542 P00015642 P00015742 P00015842
## 103 144 58 291 410 237 265
## P00015942 P00016042 P00016142 P00016242 P00016342 P00016442 P00016542
## 203 442 29 2 190 62 157
## P00016642 P00016742 P00016842 P00016942 P00017042 P00017142 P00017242
## 50 259 309 43 127 126 67
## P00017342 P00017442 P00017542 P00017642 P00017742 P00017842 P00017942
## 11 27 242 49 33 17 13
## P00018042 P00018142 P00018242 P00018342 P00018442 P00018542 P00018642
## 296 108 60 105 9 49 43
## P00018742 P00018842 P00018942 P00019042 P00019142 P00019242 P00019342
## 2 94 119 71 310 8 327
## P00019442 P00019542 P00019642 P00019742 P00019842 P00019942 P00020042
## 60 5 18 13 111 106 46
## P00020142 P00020242 P00020342 P00020442 P00020542 P00020642 P00020742
## 48 115 350 31 20 22 7
## P00020842 P00020942 P00021042 P00021142 P00021242 P00021342 P00021442
## 63 15 79 184 40 110 10
## P00021542 P00021642 P00021742 P00021842 P00021942 P00022042 P00022142
## 17 176 762 199 138 1 74
## P00022242 P00022342 P00022442 P00022542 P00022642 P00022742 P00022842
## 10 68 183 365 180 126 88
## P00022942 P00023042 P00023142 P00023242 P00023342 P00023442 P00023542
## 516 180 152 17 92 20 14
## P00023642 P00023742 P00023842 P00023942 P00024042 P00024142 P00024242
## 45 4 6 6 387 259 77
## P00024342 P00024442 P00024542 P00024642 P00024742 P00024842 P00024942
## 149 15 10 188 408 18 40
## P00025042 P00025142 P00025242 P00025342 P00025442 P00025542 P00025642
## 116 55 72 54 1586 163 96
## P00025742 P00025842 P00025942 P00026042 P00026142 P00026242 P00026342
## 13 2 429 374 72 32 27
## P00026442 P00026542 P00026642 P00026742 P00026842 P00026942 P00027042
## 37 34 206 133 10 38 123
## P00027142 P00027242 P00027342 P00027442 P00027542 P00027642 P00027742
## 87 22 22 119 132 104 8
## P00027842 P00027942 P00028042 P00028142 P00028242 P00028342 P00028442
## 1 7 371 90 95 28 411
## P00028542 P00028642 P00028742 P00028842 P00028942 P00029042 P00029142
## 488 18 12 1172 14 13 75
## P00029242 P00029342 P00029442 P00029542 P00029642 P00029742 P00029842
## 359 26 45 212 22 74 186
## P00029942 P00030042 P00030142 P00030242 P00030442 P00030542 P00030642
## 113 108 25 2 55 27 154
## P00030742 P00030842 P00030942 P00031042 P00031142 P00031242 P00031342
## 77 586 356 1168 140 19 35
## P00031442 P00031542 P00031642 P00031742 P00031842 P00031942 P00032042
## 104 16 32 32 190 81 544
## P00032142 P00032242 P00032342 P00032442 P00032542 P00032642 P00032742
## 78 13 84 229 64 21 12
## P00032842 P00032942 P00033042 P00033142 P00033242 P00033342 P00033442
## 379 118 378 43 17 269 21
## P00033542 P00033642 P00033742 P00033842 P00033942 P00034042 P00034142
## 408 237 66 27 227 573 273
## P00034242 P00034342 P00034442 P00034542 P00034642 P00034742 P00034842
## 141 65 395 39 136 1188 670
## P00034942 P00035042 P00035142 P00035242 P00035342 P00035442 P00035542
## 70 12 65 152 132 34 591
## P00035642 P00035742 P00035842 P00035942 P00036042 P00036142 P00036242
## 36 134 631 428 26 210 123
## P00036342 P00036442 P00036542 P00036642 P00036742 P00036842 P00036942
## 221 149 106 9 182 865 80
## P00037042 P00037142 P00037242 P00037342 P00037442 P00037542 P00037642
## 215 744 105 150 148 25 5
## P00037742 P00037842 P00037942 P00038042 P00038142 P00038242 P00038342
## 21 58 47 10 28 24 13
## P00038442 P00038542 P00038642 P00038742 P00038842 P00039142 P00039242
## 63 14 1 7 1 3 110
## P00039342 P00039442 P00039542 P00039642 P00039742 P00039842 P00039942
## 7 107 35 22 247 8 166
## P00040042 P00040142 P00040242 P00040342 P00040442 P00040542 P00040642
## 147 49 93 48 114 13 72
## P00040742 P00040842 P00040942 P00041042 P00041142 P00041242 P00041342
## 175 51 35 125 39 54 154
## P00041442 P00041542 P00041642 P00041742 P00041842 P00041942 P00042042
## 98 137 101 12 185 218 22
## P00042142 P00042242 P00042342 P00042442 P00042542 P00042742 P00042842
## 384 276 80 31 77 497 359
## P00042942 P00043042 P00043142 P00043242 P00043342 P00043442 P00043542
## 344 12 47 53 129 13 130
## P00043642 P00043742 P00043842 P00043942 P00044042 P00044142 P00044242
## 37 113 52 18 37 443 142
## P00044342 P00044442 P00044542 P00044642 P00044742 P00044842 P00044942
## 58 1099 43 68 20 47 13
## P00045042 P00045142 P00045242 P00045342 P00045442 P00045542 P00045642
## 26 113 56 300 26 200 40
## P00045742 P00045842 P00045942 P00046042 P00046142 P00046242 P00046342
## 20 319 22 88 513 159 21
## P00046442 P00046542 P00046642 P00046742 P00046842 P00046942 P00047042
## 112 10 78 1417 159 89 46
## P00047142 P00047242 P00047342 P00047442 P00047542 P00047642 P00047742
## 19 270 30 27 27 55 90
## P00047842 P00047942 P00048042 P00048142 P00048242 P00048342 P00048442
## 116 196 164 204 26 21 342
## P00048542 P00048642 P00048742 P00048842 P00048942 P00049042 P00049142
## 30 27 441 62 85 8 85
## P00049242 P00049342 P00049442 P00049542 P00049642 P00049742 P00049842
## 36 65 169 307 326 26 80
## P00049942 P00050042 P00050142 P00050242 P00050342 P00050442 P00050542
## 104 37 183 234 134 209 77
## P00050642 P00050742 P00050842 P00050942 P00051042 P00051142 P00051242
## 103 204 56 41 59 257 12
## P00051342 P00051442 P00051542 P00051642 P00051742 P00051842 P00051942
## 4 1233 40 409 1 185 214
## P00052042 P00052142 P00052242 P00052342 P00052442 P00052542 P00052642
## 107 141 158 30 112 175 534
## P00052742 P00052842 P00052942 P00053042 P00053142 P00053242 P00053342
## 89 968 114 354 72 1 197
## P00053442 P00053542 P00053642 P00053742 P00053842 P00053942 P00054042
## 67 70 81 93 559 290 291
## P00054142 P00054242 P00054342 P00054442 P00054542 P00054642 P00054742
## 12 346 72 1 81 2 4
## P00054842 P00054942 P00055042 P00055142 P00055242 P00055342 P00055442
## 7 260 11 28 31 5 9
## P00055542 P00055642 P00055742 P00055842 P00055942 P00056042 P00056142
## 15 57 10 17 2 14 87
## P00056242 P00056342 P00056442 P00056542 P00056642 P00056742 P00056842
## 63 1 27 1 1 27 68
## P00057042 P00057242 P00057342 P00057442 P00057542 P00057642 P00057742
## 11 222 356 618 716 1430 804
## P00057942 P00058042 P00058142 P00058242 P00058342 P00058442 P00058542
## 774 1396 396 578 276 546 4
## P00058642 P00058742 P00058942 P00059042 P00059142 P00059242 P00059342
## 131 16 20 28 121 49 1
## P00059442 P00059542 P00059642 P00059742 P00059842 P00059942 P00060042
## 1384 28 347 118 43 45 5
## P00060142 P00060242 P00060342 P00060442 P00060542 P00060642 P00060742
## 31 148 6 5 17 23 1
## P00060942 P00061042 P00061142 P00061242 P00061342 P00061442 P00061542
## 13 68 255 5 44 8 11
## P00061742 P00061842 P00061942 P00062042 P00062142 P00062342 P00062442
## 41 70 11 41 39 1 1
## P00062642 P00062742 P00062842 P00062942 P00063042 P00063242 P00063342
## 13 255 838 7 49 5 318
## P00063442 P00063542 P00063642 P00063742 P00063842 P00064042 P00064142
## 1 20 1 1 11 280 69
## P00064242 P00064342 P00064442 P00064542 P00064642 P00064742 P00064842
## 163 5 19 1 28 17 12
## P00064942 P00065042 P00065142 P00065242 P00065342 P00065442 P00065542
## 32 269 1 309 211 160 1
## P00065642 P00065742 P00065842 P00065942 P00066042 P00066142 P00066242
## 37 6 3 1 15 2 112
## P00066342 P00066442 P00066542 P00066642 P00066742 P00066842 P00066942
## 1 62 52 74 71 3 43
## P00067042 P00067142 P00067342 P00067442 P00067542 P00067642 P00067742
## 4 73 17 3 22 22 2
## P00067842 P00067942 P00068042 P00068142 P00068242 P00068342 P00068442
## 148 366 75 29 25 1 90
## P00068542 P00068642 P00068742 P00068842 P00068942 P00069042 P00069142
## 27 16 1 16 131 221 14
## P00069242 P00069342 P00069442 P00069542 P00069642 P00069742 P00069842
## 225 44 3 123 1 1 27
## P00069942 P00070042 P00070142 P00070242 P00070342 P00070442 P00070542
## 4 731 1 58 590 155 170
## P00070642 P00070742 P00070842 P00070942 P00071042 P00071142 P00071242
## 109 52 3 371 19 26 225
## P00071342 P00071442 P00071542 P00071642 P00071742 P00071842 P00071942
## 3 725 10 16 7 3 2
## P00072042 P00072142 P00072242 P00072342 P00072442 P00072542 P00072742
## 1 1 32 20 68 160 33
## P00072842 P00072942 P00073042 P00073142 P00073242 P00073342 P00073442
## 85 68 15 6 6 1 3
## P00073542 P00073642 P00073742 P00073842 P00073942 P00074042 P00074142
## 2 412 29 921 53 79 195
## P00074242 P00074342 P00074442 P00074542 P00074642 P00074742 P00074842
## 210 410 246 1 506 1 1
## P00075042 P00075142 P00075242 P00075342 P00075442 P00075542 P00075642
## 1 6 2 106 180 342 62
## P00075742 P00075842 P00075942 P00076042 P00076142 P00076242 P00076342
## 232 34 120 205 31 5 15
## P00076442 P00076542 P00076642 P00076742 P00076942 P00077042 P00077142
## 51 71 5 28 5 95 2
## P00077242 P00077342 P00077442 P00077542 P00077742 P00077842 P00077942
## 1 1 13 1 24 75 149
## P00078042 P00078142 P00078242 P00078342 P00078442 P00078542 P00078642
## 10 307 44 2 57 136 118
## P00078742 P00078842 P00078942 P00079042 P00079142 P00079342 P00079442
## 281 72 24 11 88 2 17
## P00079542 P00079642 P00079742 P00079842 P00079942 P00080042 P00080142
## 5 83 263 17 66 334 2
## P00080242 P00080342 P00080442 P00080542 P00080642 P00080742 P00080842
## 4 1186 1 7 147 17 8
## P00080942 P00081142 P00081242 P00081342 P00081442 P00081542 P00081642
## 9 334 13 1 28 25 1
## P00081742 P00081842 P00081942 P00082042 P00082242 P00082342 P00082442
## 5 28 10 13 136 165 36
## P00082542 P00082742 P00082842 P00082942 P00083042 P00083142 P00083242
## 30 21 53 2 24 1 102
## P00083342 P00083442 P00083542 P00083642 P00083742 P00083842 P00083942
## 82 35 1 26 48 300 410
## P00084042 P00084142 P00084242 P00084342 P00084442 P00084542 P00084642
## 193 102 372 481 553 198 102
## P00084742 P00084842 P00084942 P00085042 P00085142 P00085242 P00085342
## 60 729 225 423 172 893 542
## P00085442 P00085542 P00085642 P00085742 P00085842 P00085942 P00086042
## 334 196 232 38 95 945 614
## P00086142 P00086242 P00086342 P00086442 P00086542 P00086642 P00086742
## 161 268 613 956 5 212 36
## P00086842 P00086942 P00087042 P00087142 P00087242 P00087342 P00087442
## 225 52 235 110 100 214 169
## P00087542 P00087642 P00087742 P00087842 P00087942 P00088042 P00088142
## 44 63 21 99 6 201 47
## P00088242 P00088342 P00088442 P00088542 P00088642 P00088742 P00088842
## 169 103 51 143 92 105 73
## P00088942 P00089042 P00089142 P00089242 P00089342 P00089442 P00089542
## 128 150 203 145 393 200 207
## P00089642 P00089742 P00089842 P00089942 P00090042 P00090142 P00090242
## 26 20 6 34 8 15 7
## P00090342 P00090442 P00090542 P00090642 P00090742 P00090842 P00090942
## 33 30 151 4 8 386 569
## P00091042 P00091142 P00091242 P00091342 P00091442 P00091542 P00091642
## 21 148 5 44 3 1 28
## P00091742 P00091842 P00091942 P00092042 P00092142 P00092242 P00092342
## 1 59 2 2 46 15 2
## P00092442 P00092542 P00092642 P00092842 P00092942 P00093042 P00093142
## 123 22 43 28 103 10 6
## P00093242 P00093342 P00093442 P00093542 P00093642 P0009842 P0009942
## 251 136 17 56 154 65 128
## P00100042 P00100142 P00100342 P00100442 P00100542 P00100642 P00100742
## 19 64 2 710 12 423 202
## P00100842 P00100942 P00101042 P00101142 P00101242 P00101342 P00101442
## 705 502 227 70 86 359 67
## P00101542 P00101642 P00101742 P00101842 P00101942 P00102042 P00102142
## 204 7 384 633 610 188 404
## P00102242 P00102342 P00102442 P00102542 P00102642 P00102742 P00102842
## 376 668 301 165 1228 2 100
## P00102942 P00103042 P00103142 P00103242 P00103342 P00103442 P00103542
## 231 559 3 223 279 24 3
## P00103642 P00103742 P00103842 P00103942 P00104042 P00104142 P00104242
## 49 16 21 20 1 6 8
## P00104342 P00104442 P00104542 P00104642 P00104742 P00104842 P00104942
## 1 13 233 8 20 220 207
## P00105042 P00105142 P00105242 P00105342 P00105442 P00105542 P00105642
## 168 905 95 475 124 106 123
## P00105842 P00105942 P00106042 P00106142 P00106342 P00106442 P00106542
## 2 217 892 4 1 5 2
## P00106642 P00106742 P00106842 P00106942 P00107042 P00107142 P00107242
## 150 478 2 80 17 15 4
## P00107342 P00107442 P00107542 P00107642 P00107742 P00107842 P00107942
## 5 1 47 54 12 1 1
## P00108042 P00108142 P00108242 P00108342 P00108442 P00108542 P00108642
## 46 10 16 10 233 344 101
## P00108742 P00108842 P00108942 P00109042 P00109142 P00109242 P00109342
## 2 196 69 75 112 456 23
## P00109442 P00109542 P00109642 P00109742 P00109842 P00109942 P00110042
## 7 553 47 243 315 75 348
## P00110142 P00110242 P00110342 P00110442 P00110542 P00110642 P00110742
## 151 73 119 58 944 105 1591
## P00110842 P00110942 P00111042 P00111142 P00111242 P00111342 P00111442
## 1260 1336 493 1004 427 36 316
## P00111542 P00111642 P00111742 P00111842 P00111942 P00112042 P00112142
## 437 118 679 510 637 91 1539
## P00112242 P00112342 P00112442 P00112542 P00112642 P00112742 P00112842
## 121 286 906 1113 500 44 180
## P00112942 P00113042 P00113142 P00113242 P00113342 P00113442 P00113542
## 119 657 747 921 668 250 209
## P00113642 P00113742 P00113842 P00113942 P00114042 P00114142 P00114242
## 729 128 135 365 692 395 26
## P00114342 P00114442 P00114542 P00114642 P00114742 P00114842 P00114942
## 536 541 369 49 180 196 1162
## P00115042 P00115142 P00115242 P00115342 P00115442 P00115542 P00115642
## 34 578 177 366 197 471 706
## P00115742 P00115842 P00115942 P00116042 P00116142 P00116242 P00116342
## 285 398 525 137 627 282 254
## P00116442 P00116542 P00116642 P00116742 P00116842 P00116942 P00117042
## 23 314 257 599 966 163 296
## P00117142 P00117242 P00117342 P00117442 P00117542 P00117642 P00117742
## 372 375 133 1227 543 388 159
## P00117842 P00117942 P00118042 P00118142 P00118242 P00118342 P00118442
## 373 1346 334 341 82 245 396
## P00118542 P00118642 P00118742 P00118842 P00118942 P00119042 P00119142
## 487 182 636 103 149 106 511
## P00119242 P00119342 P00119442 P00119542 P00119642 P00119742 P00119842
## 237 304 432 137 387 608 96
## P00119942 P00120042 P00120142 P00120242 P00120342 P00120442 P00120542
## 112 892 320 343 622 136 295
## P00120642 P00120742 P00120842 P00120942 P00121042 P00121142 P00121242
## 241 227 391 171 194 437 165
## P00121342 P00121442 P00121542 P00121642 P00121742 P00121842 P00121942
## 749 57 79 841 24 4 16
## P00122042 P00122142 P00122342 P00122442 P00122542 P00122642 P00122742
## 4 2 15 510 284 15 29
## P00122842 P00122942 P00123042 P00123142 P00123242 P00123342 P00123442
## 12 12 25 201 12 18 59
## P00123542 P00123642 P00123742 P00123842 P00123942 P00124042 P00124142
## 29 64 397 203 12 27 29
## P00124242 P00124342 P00124442 P00124542 P00124642 P00124742 P00124842
## 342 102 36 150 388 198 311
## P00124942 P00125042 P00125142 P00125242 P00125342 P00125442 P00125542
## 89 249 131 10 228 18 53
## P00125642 P00125742 P00125842 P00125942 P00126042 P00126142 P00126242
## 103 149 42 714 306 635 132
## P00126342 P00126442 P00126542 P00126642 P00126742 P00126842 P00126942
## 1 87 48 54 1 28 54
## P00127042 P00127142 P00127242 P00127342 P00127442 P00127542 P00127642
## 195 3 590 431 529 340 747
## P00127742 P00127842 P00127942 P00128042 P00128142 P00128242 P00128342
## 490 596 522 306 204 458 169
## P00128442 P00128542 P00128642 P00128742 P00128942 P00129042 P00129142
## 63 6 2 242 926 193 117
## P00129242 P00129342 P00129442 P00129542 P00129642 P00129742 P00129842
## 69 557 116 733 763 151 587
## P00129942 P00130042 P00130142 P00130242 P00130342 P00130442 P00130542
## 37 33 55 80 35 248 12
## P00130642 P00130742 P00130842 P00130942 P00131042 P00131142 P00131242
## 480 540 199 47 207 14 30
## P00131342 P00131442 P00131542 P00131642 P00131742 P00131842 P00131942
## 85 15 146 18 74 4 12
## P00132042 P00132142 P00132242 P00132342 P00132442 P00132542 P00132642
## 140 7 82 12 31 35 168
## P00132742 P00132842 P00132942 P00133042 P00133142 P00133242 P00133342
## 1 123 60 1 2 3 13
## P00133442 P00133542 P00133642 P00133742 P00133842 P00133942 P00134042
## 171 22 40 250 36 6 72
## P00134142 P00134242 P00134342 P00134442 P00134542 P00134642 P00134742
## 96 25 242 6 77 43 12
## P00134842 P00134942 P00135042 P00135142 P00135242 P00135342 P00135442
## 28 147 13 212 51 114 15
## P00135542 P00135642 P00135742 P00135842 P00135942 P00136042 P00136142
## 80 62 405 80 1 2 23
## P00136242 P00136342 P00136442 P00136542 P00136642 P00136742 P00136842
## 24 84 43 286 16 300 131
## P00136942 P00137042 P00137142 P00137242 P00137342 P00137442 P00137542
## 29 85 64 358 4 88 152
## P00137642 P00137742 P00137842 P00137942 P00138042 P00138142 P00138242
## 25 17 8 6 26 14 26
## P00138342 P00138442 P00138542 P00138642 P00138742 P00138842 P00138942
## 79 214 588 9 6 92 9
## P00139042 P00139142 P00139242 P00139442 P00139542 P00139642 P00139742
## 21 17 8 10 415 2 101
## P00139842 P00139942 P00140042 P00140142 P00140242 P00140342 P00140442
## 29 655 190 2 6 4 29
## P00140542 P00140642 P00140742 P00140942 P00141042 P00141142 P00141242
## 22 45 781 17 3 4 15
## P00141342 P00141442 P00141542 P00141642 P00141742 P00141842 P00141942
## 3 49 212 3 7 126 127
## P00142042 P00142142 P00142242 P00142342 P00142442 P00142542 P00142642
## 4 702 38 27 17 1 10
## P00142742 P00142842 P00142942 P00143042 P00143142 P00143242 P00143342
## 37 18 500 3 67 1 201
## P00143442 P00143542 P00143642 P00143742 P00143842 P00143942 P00144042
## 1 2 329 23 22 9 254
## P00144142 P00144242 P00144342 P00144442 P00144542 P00144642 P00144742
## 3 464 18 24 12 732 8
## P00144842 P00144942 P00145042 P00145142 P00145242 P00145342 P00145442
## 7 1 1384 28 33 15 737
## P00145542 P00145642 P00145742 P00145842 P00145942 P00146042 P00146142
## 13 303 300 152 281 277 239
## P00146242 P00146342 P00146442 P00146542 P00146642 P00146742 P00146842
## 71 78 164 39 15 442 65
## P00146942 P00147042 P00147142 P00147242 P00147342 P00147442 P00147542
## 36 45 36 23 191 37 45
## P00147642 P00147742 P00147842 P00147942 P00148042 P00148142 P00148242
## 59 570 33 894 127 28 15
## P00148342 P00148442 P00148542 P00148642 P00148742 P00148842 P00148942
## 244 129 191 1179 202 215 45
## P00149042 P00149142 P00149242 P00149342 P00149442 P00149542 P00149642
## 3 59 25 472 47 142 61
## P00149742 P00149842 P00149942 P00150042 P00150142 P00150242 P00150342
## 1 23 11 136 261 2 544
## P00150442 P00150542 P00150642 P00150742 P00150842 P00150942 P00151042
## 49 633 37 141 253 431 48
## P00151142 P00151242 P00151342 P00151442 P00151542 P00151642 P00151742
## 58 106 112 21 10 2 583
## P00151842 P00151942 P00152042 P00152142 P00152242 P00152342 P00152442
## 49 46 4 7 60 5 106
## P00152542 P00152642 P00152742 P00152842 P00152942 P00153042 P00153142
## 45 12 382 2 103 6 60
## P00153242 P00153342 P00153442 P00153542 P00153642 P00153742 P00153842
## 19 19 39 11 179 606 560
## P00153942 P00154042 P00154142 P00154242 P00154342 P00154442 P00154542
## 5 615 20 242 14 235 71
## P00154642 P00154742 P00154842 P00154942 P00155042 P00155142 P00155242
## 562 123 26 2 54 175 170
## P00155342 P00155442 P00155542 P00155642 P00155742 P00155842 P00155942
## 124 418 12 199 252 14 16
## P00156042 P00156142 P00156242 P00156342 P00156442 P00156542 P00156642
## 90 148 160 28 820 86 1
## P00156742 P00156842 P00157042 P00157142 P00157242 P00157342 P00157442
## 339 115 7 261 4 208 3
## P00157542 P00157642 P00157842 P00157942 P00158042 P00158142 P00158242
## 823 475 16 71 118 7 388
## P00158342 P00158442 P00158542 P00158642 P00158742 P00158842 P00158942
## 92 38 592 39 111 151 23
## P00159042 P00159142 P00159242 P00159342 P00159442 P00159542 P00159642
## 3 6 40 36 503 487 7
## P00159742 P00159842 P00159942 P00160042 P00160142 P00160242 P00160342
## 31 117 104 199 18 25 53
## P00160442 P00160542 P00160642 P00160742 P00160842 P00160942 P00161042
## 28 105 128 1 10 169 13
## P00161142 P00161242 P00161342 P00161442 P00161542 P00161642 P00161742
## 27 139 2 495 290 4 4
## P00161842 P00161942 P00162042 P00162142 P00162242 P00162342 P00162442
## 121 792 108 2 49 25 263
## P00162542 P00162642 P00162742 P00162842 P00162942 P00163042 P00163142
## 11 79 1 3 90 27 107
## P00163242 P00163342 P00163442 P00163542 P00163642 P00163742 P00163842
## 197 64 336 96 8 17 182
## P00163942 P00164042 P00164142 P00164242 P00164342 P00164442 P00164642
## 4 26 14 1 67 6 105
## P00164742 P00164842 P00164942 P00165042 P00165142 P00165242 P00165442
## 13 55 18 20 50 19 355
## P00165642 P00165742 P00165842 P00165942 P00166042 P00166142 P00166242
## 135 260 204 70 40 34 88
## P00166342 P00166442 P00166642 P00166742 P00166842 P00166942 P00167042
## 58 1 13 171 10 104 2
## P00167142 P00167242 P00167342 P00167442 P00167542 P00167642 P00167742
## 8 1 1 6 28 54 43
## P00167842 P00167942 P00168042 P00168142 P00168342 P00168442 P00168542
## 10 95 20 21 92 69 7
## P00168642 P00168742 P00168842 P00168942 P00169042 P00169142 P00169242
## 31 105 19 2 23 38 3
## P00169342 P00169442 P00169542 P00169642 P00169742 P00169842 P00169942
## 7 137 14 89 493 1 5
## P00170042 P00170142 P00170242 P00170342 P00170442 P00170542 P00170642
## 8 13 32 253 352 159 327
## P00170742 P00170842 P00170942 P00171042 P00171142 P00171242 P00171342
## 4 32 204 25 2 5 204
## P00171442 P00171542 P00171642 P00171742 P00171842 P00171942 P00172042
## 10 272 165 24 73 10 6
## P00172142 P00172242 P00172342 P00172442 P00172542 P00172642 P00172742
## 36 3 18 3 55 1 17
## P00172842 P00173042 P00173142 P00173242 P00173342 P00173442 P00173542
## 267 528 24 290 459 69 203
## P00173742 P00173842 P00173942 P00174042 P00174142 P00174242 P00174342
## 190 611 387 64 204 322 27
## P00174442 P00174542 P00174642 P00174742 P00174842 P00174942 P00175042
## 714 146 20 20 160 15 47
## P00175142 P00175242 P00175342 P00175442 P00175542 P00175642 P00175742
## 2 129 22 11 42 63 51
## P00175842 P00175942 P00176042 P00176142 P00176242 P00176342 P00176442
## 41 63 116 52 64 72 30
## P00176542 P00176642 P00176742 P00176842 P00176942 P00177042 P00177142
## 205 269 106 412 116 110 186
## P00177242 P00177342 P00177442 P00177542 P00177642 P00177742 P00177842
## 127 363 466 583 248 270 358
## P00177942 P00178042 P00178142 P00178242 P00178342 P00178442 P00178542
## 296 311 345 703 365 118 165
## P00178642 P00178742 P00178842 P00178942 P00179042 P00179142 P00179242
## 377 102 301 824 137 151 133
## P00179342 P00179442 P00179542 P00179642 P00179742 P00179842 P00179942
## 100 112 154 93 118 90 69
## P00180042 P00180142 P00180242 P00180342 P00180442 P00180542 P00180642
## 66 46 53 281 105 59 68
## P00180742 P00180842 P00180942 P00181042 P00181142 P00181242 P00181342
## 69 55 27 7 8 140 73
## P00181442 P00181542 P00181642 P00181742 P00181842 P00181942 P00182042
## 40 438 106 66 448 60 77
## P00182142 P00182242 P00182342 P00182442 P00182542 P00182642 P00182742
## 891 568 451 399 197 394 529
## P00182842 P00182942 P00183042 P00183142 P00183242 P00183342 P00183442
## 35 6 254 211 642 620 348
## P00183542 P00183642 P00183742 P00183842 P00183942 P00184042 P00184142
## 101 197 60 88 300 334 401
## P00184242 P00184342 P00184442 P00184542 P00184642 P00184742 P00184842
## 403 121 427 77 115 98 75
## P00184942 P00185042 P00185142 P00185242 P00185342 P00185442 P00185542
## 1424 44 19 20 100 156 32
## P00185642 P00185742 P00185842 P00185942 P00186042 P00186142 P00186242
## 49 20 107 1 61 74 99
## P00186342 P00186442 P00186542 P00186642 P00186742 P00186842 P00186942
## 88 25 31 297 7 68 23
## P00187042 P00187142 P00187242 P00187342 P00187442 P00187542 P00187642
## 52 56 114 196 522 22 7
## P00187742 P00187842 P00187942 P00188042 P00188142 P00188242 P00188342
## 52 438 141 107 2 38 4
## P00188442 P00188542 P00188642 P00188742 P00188842 P00188942 P00189042
## 453 272 66 310 59 78 138
## P00189142 P00189242 P00189342 P00189442 P00189542 P00189642 P00189742
## 99 159 35 11 49 341 72
## P00189842 P00189942 P00190042 P00190142 P00190242 P00190342 P00190442
## 351 7 460 564 187 142 40
## P00190542 P00190642 P00190742 P00190842 P00190942 P00191042 P00191142
## 306 14 315 261 130 129 113
## P00191242 P00191342 P00191442 P00191542 P00191642 P00191742 P00191842
## 96 140 408 62 257 113 43
## P00191942 P00192042 P00192142 P00192242 P00192342 P00192442 P00192542
## 109 625 6 105 19 31 521
## P00192642 P00192742 P00192842 P00192942 P00193042 P00193142 P00193242
## 95 107 458 314 200 180 202
## P00193342 P00193442 P00193542 P00193642 P00193742 P00193842 P00193942
## 39 131 606 241 143 192 84
## P00194042 P00194142 P00194242 P00194342 P00194442 P00194542 P00194642
## 144 125 121 111 388 234 266
## P00194742 P00194842 P00194942 P00195042 P00195142 P00195242 P00195342
## 3 19 4 162 13 158 306
## P00195442 P00195542 P00195642 P00195742 P00195842 P00195942 P00196042
## 273 129 132 262 175 191 350
## P00196142 P00196242 P00196342 P00196442 P00196542 P00196642 P00196742
## 215 104 185 385 362 195 123
## P00196842 P00196942 P00197042 P00197142 P00197242 P00197342 P00197442
## 93 52 366 71 43 145 85
## P00197542 P00197642 P00197742 P00197842 P00197942 P00198042 P00198142
## 151 6 13 12 117 389 400
## P00198242 P00198342 P00198442 P00198542 P00198642 P00198742 P00198842
## 88 110 14 58 78 430 42
## P00198942 P00199042 P00199142 P00199242 P00199342 P00199442 P00199542
## 74 67 99 2 59 779 7
## P00199642 P00199742 P00199842 P00199942 P00200042 P00200142 P00200242
## 91 46 48 27 32 68 60
## P00200342 P00200442 P00200542 P00200642 P00200742 P00200842 P00200942
## 86 83 9 261 15 141 12
## P00201042 P00201142 P00201242 P00201342 P00201442 P00201542 P00201642
## 29 3 3 411 581 82 15
## P00201742 P00201842 P00201942 P00202042 P00202142 P00202242 P00202342
## 9 2 2 10 120 120 48
## P00202442 P00202542 P00202642 P00202742 P00202842 P00202942 P00203042
## 13 91 4 115 7 29 7
## P00203142 P00203242 P00203442 P00203642 P00203742 P00203842 P00203942
## 63 1 6 1 4 6 1
## P00204042 P00204142 P00204242 P00204342 P00204442 P00204542 P00204742
## 1 14 180 122 1 5 110
## P00204842 P00204942 P00205042 P00205142 P00205242 P00205342 P00205442
## 21 45 50 127 73 3 426
## P00205542 P00205642 P00205742 P00205842 P00205942 P00206042 P00206142
## 4 287 8 195 489 114 25
## P00206242 P00206342 P00206442 P00206542 P00206642 P00206742 P00206842
## 1 107 245 1 44 15 9
## P00206942 P00207042 P00207142 P00207242 P00207342 P00207442 P00207542
## 1 99 25 82 163 101 33
## P00207642 P00207742 P00207842 P00207942 P00208042 P00208142 P00208242
## 38 100 39 538 129 44 61
## P00208342 P00208442 P00208542 P00208642 P00208742 P00208842 P00208942
## 354 39 34 1 436 133 60
## P00209042 P00209142 P00209242 P00209342 P00209442 P00209542 P00209642
## 7 171 29 23 19 24 149
## P00209742 P00209842 P00209942 P00210042 P00210142 P00210242 P00210342
## 380 535 54 775 15 12 334
## P00210442 P00210542 P00210642 P00210742 P00210842 P00210942 P00211042
## 40 76 180 8 2 330 190
## P00211142 P00211242 P00211342 P00211442 P00211542 P00211642 P00211742
## 602 171 2 16 54 21 1
## P00211942 P00212042 P00212142 P00212242 P00212342 P00212442 P00212542
## 65 224 171 261 57 88 143
## P00212642 P00212742 P00212842 P00212942 P00213042 P00213142 P00213242
## 4 174 84 618 166 23 626
## P00213342 P00213442 P00213542 P00213642 P00213742 P00213842 P00213942
## 73 11 53 85 350 45 88
## P00214042 P00214142 P00214242 P00214342 P00214442 P00214542 P00214642
## 5 295 194 234 497 68 170
## P00214742 P00214842 P00214942 P00215042 P00215142 P00215242 P00215342
## 12 179 23 8 1 98 18
## P00215442 P00215542 P00215642 P00215742 P00215842 P00215942 P00216042
## 168 44 185 84 11 60 455
## P00216142 P00216242 P00216342 P00216442 P00216542 P00216642 P00216742
## 554 71 925 46 111 2 369
## P00216842 P00216942 P00217042 P00217142 P00217242 P00217342 P00217442
## 60 90 29 157 68 78 394
## P00217542 P00217642 P00217742 P00217842 P00217942 P00218042 P00218142
## 155 34 414 74 325 122 99
## P00218242 P00218342 P00218442 P00218542 P00218642 P00218742 P00218842
## 134 213 161 93 209 115 105
## P00218942 P00219042 P00219142 P00219242 P00219342 P00219442 P00219542
## 95 84 75 287 72 34 119
## P00219642 P00219742 P00219842 P00219942 P00220042 P00220142 P00220242
## 11 149 177 399 107 428 310
## P00220342 P00220442 P00220542 P00220642 P00220742 P00220842 P00220942
## 686 1253 6 193 119 25 158
## P00221042 P00221142 P00221242 P00221342 P00221442 P00221542 P00221642
## 213 214 164 377 731 538 135
## P00221742 P00221842 P00221942 P00222042 P00222142 P00222242 P00222342
## 240 225 219 145 238 204 9
## P00222442 P00222542 P00222642 P00222742 P00222842 P00222942 P00223042
## 186 37 56 40 261 263 147
## P00223142 P00223242 P00223342 P00223442 P00223542 P00223642 P00223742
## 270 455 31 16 440 261 104
## P00223842 P00223942 P00224042 P00224142 P00224242 P00224342 P00224442
## 77 251 88 339 27 64 62
## P00224542 P00224642 P00224742 P00224842 P00224942 P00225042 P00225142
## 43 1 102 23 13 85 65
## P00225242 P00225342 P00225442 P00225542 P00225642 P00225742 P00225842
## 3 40 32 136 97 20 210
## P00225942 P00226042 P00226142 P00226242 P00226342 P00226442 P00226542
## 63 8 105 259 591 162 136
## P00226642 P00226742 P00226842 P00226942 P00227042 P00227142 P00227342
## 77 130 64 30 24 247 24
## P00227442 P00227542 P00227642 P00227742 P00227842 P00227942 P00228042
## 4 174 187 259 506 216 58
## P00228142 P00228242 P00228342 P00228442 P00228542 P00228642 P00228742
## 88 178 85 145 20 312 25
## P00228842 P00228942 P00229042 P00229142 P00229342 P00229442 P00229542
## 1 16 16 14 219 3 4
## P00229642 P00229742 P00229842 P00229942 P00230042 P00230142 P00230242
## 41 436 57 87 16 16 56
## P00230342 P00230442 P00230542 P00230642 P00230742 P00230842 P00230942
## 193 89 52 33 69 326 454
## P00231042 P00231142 P00231242 P00231342 P00231442 P00231542 P00231642
## 5 104 162 81 28 8 1
## P00231742 P00231842 P00231942 P00232042 P00232142 P00232242 P00232342
## 42 12 168 67 31 32 139
## P00232442 P00232542 P00232642 P00232742 P00232842 P00232942 P00233042
## 159 52 90 41 43 22 142
## P00233142 P00233242 P00233342 P00233442 P00233542 P00233642 P00233742
## 80 70 349 329 623 198 165
## P00233842 P00233942 P00234042 P00234142 P00234242 P00234342 P00234442
## 195 248 9 67 15 17 3
## P00234542 P00234642 P00234742 P00234842 P00234942 P00235042 P00235142
## 341 85 311 349 1 10 3
## P00235242 P00235342 P00235442 P00235542 P00235642 P00235742 P00235842
## 85 61 98 94 104 21 125
## P00235942 P00236042 P00236242 P00236342 P00236442 P00236542 P00236642
## 78 81 2 126 14 100 64
## P00236742 P00236942 P00237042 P00237142 P00237242 P00237342 P00237442
## 3 211 21 158 112 4 53
## P00237542 P00237642 P00237742 P00237842 P00237942 P00238042 P00238142
## 1374 381 22 101 72 2 16
## P00238242 P00238342 P00238442 P00238542 P00238642 P00238742 P00238842
## 2 15 369 338 30 122 1
## P00238942 P00239042 P00239142 P00239242 P00239342 P00239442 P00239642
## 22 9 53 34 18 1 19
## P00239742 P00239842 P00239942 P00240042 P00240142 P00240242 P00240342
## 36 81 35 275 802 219 3
## P00240442 P00240542 P00240642 P00240742 P00240842 P00240942 P00241042
## 405 105 46 4 34 21 83
## P00241142 P00241242 P00241342 P00241442 P00241542 P00241642 P00241742
## 77 163 29 91 320 546 26
## P00241842 P00241942 P00242042 P00242142 P00242242 P00242342 P00242442
## 1 24 36 212 4 49 40
## P00242542 P00242642 P00242742 P00242842 P00242942 P00243042 P00243142
## 26 7 1194 80 25 2 4
## P00243242 P00243342 P00243442 P00243542 P00243642 P00243742 P00243842
## 97 51 15 10 18 22 91
## P00243942 P00244042 P00244142 P00244242 P00244342 P00244442 P00244542
## 674 460 280 179 122 57 17
## P00244642 P00244742 P00244842 P00244942 P00245042 P00245142 P00245242
## 23 222 35 18 52 34 26
## P00245342 P00245442 P00245542 P00245642 P00245742 P00245842 P00245942
## 76 27 33 683 7 34 74
## P00246042 P00246142 P00246242 P00246342 P00246442 P00246542 P00246642
## 45 319 25 334 38 19 36
## P00246742 P00246842 P00246942 P00247042 P00247142 P00247242 P00247342
## 148 65 129 401 211 5 15
## P00247442 P00247542 P00247642 P00247742 P00247842 P00247942 P00248042
## 8 158 127 17 2 22 48
## P00248142 P00248242 P00248342 P00248442 P00248542 P00248642 P00248742
## 809 3 312 225 372 20 235
## P00248842 P00248942 P00249042 P00249142 P00249242 P00249342 P00249442
## 13 570 112 447 7 42 24
## P00249542 P00249642 P00249742 P00249842 P00250042 P00250142 P00250242
## 778 713 473 204 18 4 759
## P00250342 P00250442 P00250542 P00250642 P00250742 P00250842 P00250942
## 340 22 123 665 11 518 208
## P00251042 P00251142 P00251242 P00251342 P00251442 P00251542 P00251642
## 47 14 1167 298 203 266 194
## P00251742 P00251842 P00251942 P00252042 P00252142 P00252242 P00252342
## 45 313 463 340 51 69 13
## P00252442 P00252542 P00252642 P00252742 P00252842 P00252942 P00253042
## 236 119 78 118 78 31 238
## P00253142 P00253242 P00253342 P00253442 P00253542 P00253642 P00253742
## 256 122 8 43 243 10 31
## P00253942 P00254042 P00254142 P00254242 P00254342 P00254442 P00254542
## 14 18 126 500 185 67 48
## P00254642 P00254742 P00254842 P00254942 P00255042 P00255142 P00255242
## 144 25 93 37 7 20 11
## P00255342 P00255442 P00255542 P00255642 P00255742 P00255842 P00255942
## 68 12 232 4 382 1354 552
## P00256042 P00256142 P00256242 P00256342 P00256442 P00256542 P00256642
## 149 3 18 12 10 39 493
## P00256742 P00256842 P00256942 P00257042 P00257142 P00257242 P00257342
## 100 132 9 37 8 8 3
## P00257442 P00257542 P00257642 P00257742 P00257842 P00257942 P00258042
## 17 178 41 31 58 3 34
## P00258142 P00258242 P00258342 P00258442 P00258542 P00258642 P00258742
## 11 30 68 231 95 26 955
## P00258842 P00258942 P00259042 P00259142 P00259242 P00259342 P00259442
## 298 136 201 291 127 814 90
## P00259542 P00259642 P00259742 P00259842 P00259942 P00260042 P00260142
## 55 11 47 162 199 741 231
## P00260242 P00260342 P00260442 P00260542 P00260642 P00260742 P00260842
## 85 46 191 13 25 1 23
## P00260942 P00261042 P00261142 P00261242 P00261342 P00261442 P00261542
## 16 4 145 75 62 32 170
## P00261642 P00261742 P00261842 P00261942 P00262042 P00262142 P00262242
## 32 2 142 2 6 2 413
## P00262342 P00262442 P00262542 P00262642 P00262742 P00262842 P00262942
## 186 73 87 8 2 2 9
## P00263042 P00263142 P00263242 P00263342 P00263442 P00263542 P00263642
## 34 91 13 6 214 284 25
## P00263742 P00263842 P00264042 P00264142 P00264242 P00264342 P00264442
## 11 41 82 13 18 8 2
## P00264542 P00264642 P00264742 P00264842 P00264942 P00265042 P00265142
## 78 76 15 4 7 41 217
## P00265242 P00265342 P00265442 P00265542 P00265642 P00265742 P00265842
## 1858 132 73 198 50 257 16
## P00265942 P00266042 P00266142 P00266242 P00266342 P00266442 P00266542
## 16 112 161 35 3 104 401
## P00266642 P00266742 P00266842 P00266942 P00267042 P00267142 P00267242
## 424 10 36 162 25 113 21
## P00267342 P00267442 P00267542 P00267642 P00267742 P00267842 P00267942
## 89 34 425 65 139 22 34
## P00268042 P00268142 P00268242 P00268342 P00268442 P00268542 P00268642
## 15 3 65 149 559 90 7
## P00268742 P00268842 P00269042 P00269142 P00269242 P00269342 P00269442
## 27 21 14 12 51 70 88
## P00269542 P00269642 P00269742 P00269842 P00269942 P00270042 P00270142
## 174 95 50 7 37 138 122
## P00270242 P00270442 P00270542 P00270642 P00270742 P00270842 P00270942
## 479 4 252 12 7 462 1141
## P00271042 P00271142 P00271242 P00271342 P00271442 P00271542 P00271642
## 286 781 197 55 196 130 7
## P00271742 P00271842 P00271942 P00272042 P00272142 P00272242 P00272342
## 67 28 234 58 44 110 2
## P00272442 P00272542 P00272642 P00272742 P00272842 P00272942 P00273042
## 2 64 5 2 78 81 53
## P00273142 P00273242 P00273342 P00273442 P00273542 P00273642 P00273742
## 22 27 58 157 209 85 386
## P00273842 P00273942 P00274042 P00274142 P00274242 P00274342 P00274442
## 18 175 465 399 350 191 278
## P00274542 P00274642 P00274742 P00274842 P00274942 P00275042 P00275142
## 115 193 2 73 782 1 165
## P00275242 P00275342 P00275442 P00275542 P00275642 P00275742 P00275842
## 7 9 7 37 226 64 551
## P00275942 P00276042 P00276142 P00276242 P00276342 P00276442 P00276542
## 34 51 167 31 259 35 60
## P00276642 P00276742 P00276842 P00276942 P00277042 P00277142 P00277242
## 299 22 60 24 7 22 38
## P00277342 P00277442 P00277542 P00277642 P00277742 P00277842 P00277942
## 7 648 272 968 62 214 194
## P00278042 P00278142 P00278242 P00278342 P00278442 P00278542 P00278642
## 214 12 234 5 178 71 1213
## P00278742 P00278842 P00278942 P00279142 P00279242 P00279342 P00279442
## 6 2 172 23 5 139 346
## P00279542 P00279642 P00279742 P00279842 P00279942 P00280042 P00280142
## 480 151 22 23 80 5 39
## P00280242 P00280342 P00280442 P00280542 P00280642 P00280742 P00280842
## 35 77 223 56 139 215 275
## P00280942 P00281042 P00281142 P00281242 P00281342 P00281442 P00281542
## 17 120 86 7 3 4 78
## P00281642 P00281742 P00281842 P00281942 P00282042 P00282142 P00282242
## 100 114 29 127 481 177 219
## P00282342 P00282442 P00282542 P00282642 P00282742 P00282842 P00282942
## 96 318 43 460 167 38 37
## P00283042 P00283142 P00283242 P00283342 P00283442 P00283542 P00283642
## 16 299 65 52 13 47 14
## P00283742 P00283842 P00283942 P00284042 P00284142 P00284242 P00284342
## 6 87 526 183 77 46 4
## P00284542 P00284642 P00284742 P00284842 P00284942 P00285042 P00285142
## 7 298 156 198 81 29 1
## P00285242 P00285342 P00285442 P00285542 P00285642 P00285742 P00285842
## 103 187 200 30 335 159 524
## P00285942 P00286042 P00286142 P00286242 P00286342 P00286442 P00286542
## 17 126 36 39 53 84 69
## P00286642 P00286742 P00286842 P00286942 P00287042 P00287142 P00287242
## 550 453 215 2 1 47 264
## P00287342 P00287442 P00287542 P00287642 P00287742 P00287842 P00287942
## 201 124 99 70 10 108 51
## P00288042 P00288142 P00288242 P00288342 P00288442 P00288542 P00288642
## 279 41 121 291 141 320 448
## P00288742 P00288842 P00288942 P00289042 P00289142 P00289242 P00289342
## 128 32 412 365 15 476 521
## P00289442 P00289542 P00289642 P00289742 P00289842 P00289942 P00290042
## 36 17 103 45 302 828 55
## P00290142 P00290242 P00290342 P00290442 P00290542 P00290642 P00290742
## 6 41 31 3 63 9 18
## P00290842 P00290942 P00291042 P00291142 P00291242 P00291342 P00291442
## 2 16 97 2 27 23 159
## P00291542 P00291642 P00291742 P00291842 P00291942 P00292042 P00292142
## 71 1 14 17 98 97 1
## P00292242 P00292342 P00292442 P00292542 P00292642 P00292742 P00292842
## 9 37 6 5 33 74 18
## P00292942 P00293042 P00293142 P00293242 P00293342 P00293442 P00293542
## 21 144 172 656 384 4 34
## P00293742 P00293842 P00293942 P00294042 P00294142 P00294242 P00294342
## 187 144 4 165 209 278 15
## P00294442 P00294542 P00294642 P00294742 P00294842 P00295042 P00295142
## 234 605 8 12 156 31 4
## P00295242 P00295342 P00295442 P00295542 P00295642 P00295742 P00295842
## 95 270 139 16 1 255 476
## P00295942 P00296042 P00296142 P00296242 P00296342 P00296442 P00296542
## 959 716 85 282 106 38 93
## P00296642 P00296742 P00296842 P00296942 P00297042 P00297142 P00297242
## 61 31 2 200 226 2 25
## P00297342 P00297442 P00297542 P00297642 P00297742 P00297842 P00297942
## 169 89 14 119 190 131 178
## P00298042 P00298142 P00298242 P00298342 P00298442 P00298542 P00298742
## 35 98 189 1 280 107 67
## P00298842 P00298942 P00299042 P00299142 P00299242 P00299342 P00299442
## 1 144 1 457 34 1 124
## P00299542 P00299642 P00299742 P00299842 P00299942 P00300042 P00300242
## 54 9 1 48 17 246 14
## P00300342 P00300442 P00300542 P00300642 P00300742 P00300942 P00301042
## 15 16 36 62 1 41 3
## P00301142 P00301242 P00301342 P00301442 P00301542 P00301642 P00301742
## 2 40 2 1 161 18 17
## P00301842 P00301942 P00302042 P00302142 P00302242 P00302342 P00302442
## 29 1 161 169 3 255 373
## P00302542 P00302642 P00302742 P00302842 P00302942 P00303042 P00303142
## 107 174 194 138 284 587 241
## P00303242 P00303342 P00303442 P00303542 P00303642 P00303742 P00303842
## 601 581 348 194 214 260 231
## P00303942 P00304042 P00304142 P00304242 P00304342 P00304442 P00304542
## 78 353 269 169 73 256 96
## P00304642 P00304742 P00304842 P00304942 P00305042 P00305142 P00305242
## 244 108 181 89 316 252 53
## P00305342 P00305442 P00305542 P00305642 P00305742 P00305842 P00305942
## 21 1 1 31 5 6 25
## P00306042 P00306142 P00306242 P00306342 P00306442 P00306542 P00306742
## 214 73 66 3 31 1 4
## P00306942 P00307042 P00307142 P00307242 P00307342 P00307442 P00307542
## 1 1 110 1 333 92 294
## P00307642 P00307742 P00307842 P00307942 P00308042 P00308142 P00308242
## 326 25 4 27 1 13 150
## P00308342 P00308442 P00308542 P00308642 P00308842 P00308942 P00309042
## 146 14 20 14 12 3 1
## P00309142 P00309242 P00309342 P00309442 P00309542 P00309642 P00309742
## 160 276 26 18 27 1 3
## P00309942 P00310042 P00310142 P00310242 P00310342 P00310442 P00310542
## 103 82 95 73 177 14 60
## P00310642 P00310742 P00310842 P00310942 P00311042 P00311242 P00311342
## 19 8 232 4 2 15 22
## P00311442 P00311542 P00311642 P00311742 P00311842 P00311942 P00312042
## 42 94 110 21 9 17 3
## P00312142 P00312242 P00312342 P00312442 P00312542 P00312742 P00312842
## 108 14 77 11 1 440 151
## P00312942 P00313042 P00313142 P00313242 P00313342 P00313442 P00313542
## 55 250 273 325 591 404 509
## P00313642 P00313742 P00313842 P00313942 P00314042 P00314142 P00314242
## 84 121 136 23 33 36 31
## P00314342 P00314542 P00314642 P00314742 P00314842 P00314942 P00315042
## 26 9 34 1 1 2 49
## P00315142 P00315242 P00315442 P00315542 P00315642 P00315742 P00315842
## 1 1 139 79 396 91 165
## P00315942 P00316042 P00316142 P00316242 P00316342 P00316442 P00316542
## 21 11 52 98 24 113 29
## P00316642 P00316742 P00316842 P00316942 P00317042 P00317142 P00317242
## 410 194 177 43 15 61 13
## P00317342 P00317442 P00317542 P00317642 P00317742 P00317842 P00317942
## 22 126 63 58 2 746 224
## P00318042 P00318142 P00318342 P00318442 P00318542 P00318642 P00318742
## 5 86 28 10 32 32 750
## P00318842 P00318942 P00319042 P00319142 P00319242 P00319342 P00319442
## 3 109 642 131 41 425 39
## P00319542 P00319642 P00319742 P00319842 P00319942 P00320042 P00320142
## 107 40 33 148 121 44 37
## P00320242 P00320342 P00320442 P00320542 P00320642 P00320742 P00320842
## 23 23 264 67 8 275 130
## P00320942 P00321042 P00321142 P00321242 P00321342 P00321442 P00321542
## 114 258 23 3 116 73 22
## P00321642 P00321742 P00321842 P00321942 P00322042 P00322142 P00322242
## 38 568 21 439 192 177 51
## P00322342 P00322442 P00322542 P00322742 P00322942 P00323042 P00323142
## 21 29 72 36 192 155 4
## P00323242 P00323342 P00323442 P00323542 P00323642 P00323742 P00323842
## 10 10 106 149 239 140 47
## P00323942 P00324042 P00324142 P00324242 P00324342 P00324442 P00324542
## 786 4 11 9 81 355 146
## P00324642 P00324742 P00324842 P00324942 P00325042 P00325142 P00325242
## 145 311 79 775 2 89 167
## P00325342 P00325442 P00325542 P00325642 P00325742 P00325842 P00325942
## 1 7 35 14 382 9 33
## P00326042 P00326242 P00326342 P00326442 P00326542 P00326642 P00326742
## 9 175 3 23 50 156 503
## P00326842 P00326942 P00327042 P00327142 P00327242 P00327342 P00327442
## 97 147 49 81 373 179 102
## P00327542 P00327642 P00327742 P00327842 P00327942 P00328042 P00328142
## 196 199 46 428 36 247 220
## P00328242 P00328342 P00328442 P00328642 P00328742 P00328842 P00328942
## 31 108 117 28 110 22 99
## P00329042 P00329142 P00329242 P00329342 P00329442 P00329542 P00329642
## 1 3 285 195 414 695 177
## P00329742 P00329842 P00329942 P00330042 P00330142 P00330242 P00330342
## 83 1 18 10 2 271 337
## P00330442 P00330542 P00330642 P00330742 P00330842 P00331042 P00331142
## 264 16 94 18 15 468 52
## P00331242 P00331342 P00331442 P00331542 P00331642 P00331742 P00331842
## 237 117 40 153 129 86 205
## P00331942 P00332042 P00332142 P00332242 P00332342 P00332442 P00332542
## 493 49 63 518 179 66 11
## P00332642 P00332742 P00332842 P00332942 P00333042 P00333142 P00333242
## 15 7 69 145 182 20 18
## P00333342 P00333442 P00333542 P00333642 P00333742 P00333842 P00333942
## 24 5 70 41 16 8 2
## P00334042 P00334142 P00334242 P00334342 P00334442 P00334542 P00334642
## 154 32 1082 35 13 5 73
## P00334742 P00334842 P00334942 P00335042 P00335142 P00335242 P00335342
## 11 15 19 20 43 357 2
## P00335442 P00335542 P00335642 P00335742 P00335842 P00335942 P00336042
## 190 105 1 38 20 92 53
## P00336142 P00336242 P00336342 P00336442 P00336542 P00336642 P00336742
## 75 1 32 3 74 26 83
## P00336942 P00337042 P00337142 P00337242 P00337342 P00337442 P00337542
## 443 4 18 11 13 44 290
## P00337642 P00337742 P00337842 P00337942 P00338042 P00338142 P00338242
## 174 81 233 189 50 28 1
## P00338342 P00338442 P00338542 P00338642 P00338742 P00338842 P00338942
## 48 715 414 9 25 67 50
## P00339042 P00339142 P00339242 P00339342 P00339442 P00339542 P00339642
## 154 1 23 185 85 258 6
## P00339742 P00339842 P00339942 P00340042 P00340142 P00340242 P00340342
## 15 326 234 5 3 12 54
## P00340442 P00340542 P00340642 P00340742 P00340842 P00340942 P00341042
## 11 11 98 1 6 156 2
## P00341142 P00341242 P00341342 P00341442 P00341542 P00341642 P00341742
## 2 95 252 30 1 2 40
## P00341842 P00341942 P00342042 P00342142 P00342242 P00342342 P00342442
## 23 83 43 52 37 32 14
## P00342542 P00342642 P00342742 P00342842 P00342942 P00343042 P00343142
## 2 19 200 38 12 586 83
## P00343242 P00343342 P00343442 P00343542 P00343642 P00343742 P00343842
## 15 19 146 112 26 49 32
## P00343942 P00344042 P00344142 P00344242 P00344342 P00344442 P00344542
## 28 168 117 331 207 278 236
## P00344742 P00344842 P00344942 P00345042 P00345142 P00345242 P00345342
## 185 89 58 19 29 99 32
## P00345442 P00345542 P00345642 P00345742 P00345842 P00345942 P00346042
## 29 37 347 385 462 136 271
## P00346142 P00346242 P00346342 P00346442 P00346542 P00346642 P00346742
## 586 547 387 192 250 124 147
## P00346842 P00346942 P00347042 P00347142 P00347242 P00347342 P00347442
## 61 105 17 185 45 32 45
## P00347542 P00347642 P00347742 P00347842 P00347942 P00348042 P00348142
## 38 321 37 27 49 17 1
## P00348242 P00348342 P00348442 P00348542 P00348642 P00348742 P00348842
## 147 98 59 59 79 73 130
## P00348942 P00349042 P00349142 P00349242 P00349342 P00349442 P00349542
## 244 19 37 143 31 281 19
## P00349642 P00349742 P00349842 P00349942 P00350042 P00350142 P00350242
## 31 49 25 323 121 133 51
## P00350342 P00350442 P00350542 P00350642 P00350842 P00350942 P00351042
## 245 295 31 80 12 726 314
## P00351142 P00351242 P00351342 P00351442 P00351542 P00351642 P00351742
## 638 115 554 14 11 57 19
## P00351842 P00351942 P00352042 P00352142 P00352242 P00352342 P00352442
## 170 14 1 379 129 25 111
## P00352542 P00352642 P00352742 P00352842 P00352942 P00353042 P00353142
## 59 47 115 185 86 1 91
## P00353242 P00353342 P00353442 P00353542 P00353642 P00353742 P00353842
## 31 12 17 7 3 1 24
## P00353942 P00354042 P00354142 P00354242 P00354342 P00354442 P00354542
## 17 25 134 93 323 100 27
## P00354642 P00354742 P00354842 P00354942 P00355042 P00355142 P00355242
## 131 84 28 246 35 807 64
## P00355342 P00355442 P00355542 P00355642 P00355742 P00355842 P00355942
## 36 4 21 259 60 2 118
## P00356042 P00356142 P00356242 P00356342 P00356442 P00356542 P00356642
## 175 6 20 15 31 69 18
## P00356742 P00356842 P00356942 P00357042 P00357142 P00357242 P00357342
## 462 46 184 151 41 119 27
## P00357442 P00357542 P00357642 P00357742 P00357842 P00357942 P00358042
## 9 1 126 20 132 44 35
## P00358142 P00358242 P00358342 P00358442 P00358542 P00358642 P00358742
## 69 122 223 263 2 8 100
## P00358842 P00358942 P00359042 P00359142 P00359242 P00359342 P00359442
## 13 26 98 100 191 61 24
## P00359542 P00359642 P00359742 P00359942 P00360042 P00360142 P00360242
## 28 58 171 19 233 13 77
## P00360342 P00360442 P00360542 P00360642 P00360742 P00360842 P00360942
## 11 10 25 7 20 115 6
## P00361042 P00361142 P00361242 P00361342 P00361442 P00361542 P00361642
## 9 18 30 36 47 7 135
## P00361742 P00361842 P00361942 P00362042 P00362142 P00362242 P00362342
## 11 352 80 78 4 4 362
## P00362442 P00362542 P00362642 P00362742 P00362842 P00362942 P00363042
## 237 24 154 61 152 13 3
## P00363142 P00363242 P00363342 P00363442 P00363542 P00363742 P00363842
## 2 104 6 61 9 122 7
## P00363942 P00364042 P00364142 P00364242 P00364342 P00364442 P00364542
## 23 16 18 3 1 72 1
## P00364642 P00364742 P00364842 P00364942 P00365042 P00365142 P00365242
## 3 6 318 11 49 95 517
## P00365342 P00365442 P00365542 P00365642 P00365742 P00365842 P00365942
## 25 2 22 51 11 28 1
## P00366042 P00366142 P00366242 P00366342 P00366442 P00366542 P00366642
## 6 16 49 34 123 359 24
## P00366742 P00366842 P00366942 P00367042 P00367142 P00367242 P00367342
## 13 40 63 224 160 88 51
## P00367442 P00367542 P00367642 P00367742 P00367842 P00367942 P00368042
## 38 21 23 60 14 66 93
## P00368142 P00368242 P00368342 P00368442 P00368542 P00368642 P00368742
## 193 115 82 127 20 130 8
## P00368842 P00368942 P00369042 P00369142 P00369242 P00369342 P00369442
## 14 10 64 78 15 15 8
## P00369542 P00369642 P00369742 P00369842 P00369942 P00370042 P00370142
## 14 12 49 5 23 46 30
## P00370242 P00370342 P00370442 P00370542 P00370642 P0093742 P0093842
## 461 165 25 23 216 10 5
## P0093942 P0094042 P0094142 P0094242 P0094342 P0094442 P0094542
## 65 57 78 46 121 47 172
## P0094642 P0094742 P0094842 P0094942 P0095042 P0095142 P0095242
## 132 72 164 151 83 113 84
## P0095342 P0095442 P0095542 P0095642 P0095742 P0095842 P0095942
## 145 60 305 208 114 308 108
## P0096042 P0096142 P0096242 P0096342 P0096442 P0096542 P0096642
## 67 162 2 179 523 321 171
## P0096742 P0096842 P0096942 P0097042 P0097142 P0097242 P0097342
## 172 296 153 87 482 896 358
## P0097442 P0097542 P0097642 P0097742 P0097842 P0097942 P0098042
## 6 3 1 249 276 62 20
## P0098142 P0098242 P0098342 P0098442 P0098542 P0098642 P0098742
## 42 229 251 72 45 26 46
## P0098842 P0098942 P0099042 P0099142 P0099242 P0099342 P0099442
## 10 33 141 7 255 435 196
## P0099642 P0099742 P0099842 P0099942
## 13 123 100 13names(sale_report)## [1] "User_ID" "Product_ID"
## [3] "GenFer" "Age"
## [5] "Occupation" "City_Category"
## [7] "Stay_In_Current_City_Years" "Marital_Status"
## [9] "Purchase"##### merge the customer's data
### remove product_id (insufficient information)
### limitation_ some user may shop on more than one channel
sale_report %>% distinct(User_ID,City_Category) ###5881 ## # A tibble: 5,893 x 2
## User_ID City_Category
## <int> <chr>
## 1 1000001 A
## 2 1000002 C
## 3 1000003 A
## 4 1000004 B
## 5 1000005 A
## 6 1000006 A
## 7 1000007 B
## 8 1000008 C
## 9 1000009 C
## 10 1000010 B
## # ... with 5,883 more rows#### combine customer data
merge_sales_report <- sale_report %>% group_by(User_ID) %>% summarise(
Gender=first(GenFer),
Age=first(Age),
Occupation = first(Occupation),
City_Category = first(City_Category),
Stay_In_Current_City_Years = first(Stay_In_Current_City_Years),
Marital_Status=first(Marital_Status),
mean_purchase = mean(Purchase)
) %>% unique()
table(merge_sales_report$City_Category)##
## A B C
## 1045 1707 3139### replace category to numeric
for ( i in 1:nrow(merge_sales_report)) {
if( grepl("A", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "1" }
else { if ( grepl("B", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "2" }
else{ if( grepl("C", merge_sales_report[i,5]) == "TRUE" ) {
merge_sales_report[i,5] <- "3" } } } }
### replace gender to numeric
for ( i in 1:nrow(merge_sales_report)) {
if( grepl("F", merge_sales_report[i,2]) ) {
merge_sales_report[i,2] <- "0" }
else { if ( grepl("M", merge_sales_report[i,2]) ) {
merge_sales_report[i,2] <- "1" } } }
merge_sales_report$City_Category <- as.numeric(merge_sales_report$City_Category)
na.omit(merge_sales_report) -> merge_sales_report
#### 4 cluster / kmeans
kmeans(merge_sales_report[,c(2,5,8)],4, nstart=25) -> sales_kmean
merge_sales_report1 <- cbind(merge_sales_report, cluster = sales_kmean$cluster)
#### recover the name
for ( i in 1:nrow(merge_sales_report1)) {
if( grepl("1", merge_sales_report1[i,5]) == "TRUE" ) {
merge_sales_report1[i,5] <- "US" }
else { if ( grepl("2", merge_sales_report1[i,5]) == "TRUE" ) {
merge_sales_report1[i,5] <- "UK" }
else{ if( grepl("3", merge_sales_report1[i,5]) == "TRUE" ) {
merge_sales_report1[i,5] <- "Online" } } } }
for ( i in 1:nrow(merge_sales_report1)) {
if( grepl("0", merge_sales_report1[i,2]) ) {
merge_sales_report1[i,2] <- "F" }
else { if ( grepl("1", merge_sales_report1[i,2]) ) {
merge_sales_report1[i,2] <- "M" } } }
write.csv(merge_sales_report1,"~/Desktop/Simulation//kmeans.csv", row.names = FALSE)
means <- aggregate(merge_sales_report1, by=list(sales_kmean$cluster), FUN=mean)## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NANote that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.