GGplot and Dplyr
B. Depaire
Monday, March 23, 2015
The purpose of this document is to explore the potential when combining dplyr with ggplot. Let us first load the interaction data.
source("data/load_interaction_data.R")
interaction_data## Source: local data frame [147,004 x 17]
##
## ci_name ci_type ci_subtype service_component
## 1 SBA000243 application Server Based Application WBS000125
## 2 SUB000443 subapplication Web Based Application WBS000125
## 3 LAP000110 computer Laptop WBS000187
## 4 DTA000110 application Desktop Application WBS000256
## 5 SBA000855 application Server Based Application WBS000054
## 6 SUB000424 subapplication Web Based Application WBS000073
## 7 SUB000508 subapplication Web Based Application WBS000162
## 8 DTA000616 application Desktop Application WBS000092
## 9 CBD000079 computer Banking Device WBS000147
## 10 SBA000207 application Server Based Application WBS000123
## .. ... ... ... ...
## Variables not shown: interaction_id (fctr), status (fctr), impact (fctr),
## urgency (fctr), priority (fctr), category (fctr), km_number (fctr),
## open_time (fctr), close_time (fctr), closure_code (fctr),
## first_call_resolution (fctr), handle_time (int), related_incident (fctr)summary(interaction_data)## ci_name ci_type
## SAN000182: 10668 application :99483
## DTA000616: 7911 subapplication:20745
## WBA000133: 6897 storage :11829
## SUB000456: 6476 computer : 8410
## DTA000057: 5708 software : 1981
## SBA000659: 4008 displaydevice : 1662
## (Other) :105336 (Other) : 2894
## ci_subtype service_component interaction_id
## Server Based Application:48469 WBS000073:33528 SD0000001: 1
## Web Based Application :39225 WBS000128:14130 SD0000002: 1
## Desktop Application :24239 WBS000092: 7219 SD0000003: 1
## SAN :11675 WBS000094: 6825 SD0000004: 1
## Citrix : 3836 WBS000091: 6411 SD0000005: 1
## Laptop : 3604 WBS000089: 6011 SD0000006: 1
## (Other) :15956 (Other) :72880 (Other) :146998
## status impact urgency priority
## Closed :146998 1: 2 1: 32 1: 2
## Open - Linked: 6 2: 904 2: 950 2: 947
## 3:16357 3:16074 3:16340
## 4:75552 4:76645 4:77534
## 5:54189 5:53303 5:52181
##
##
## category km_number
## complaint : 63 KM0002125: 5727
## incident :115704 KM0001935: 1768
## problem : 5 KM0002126: 1698
## request for change : 1 KM0001968: 1606
## request for information: 31183 KM0001625: 1415
## service request : 48 KM0000075: 1389
## (Other) :133401
## open_time close_time
## 14-1-2014 9:07 : 12 25-11-2013 12:02: 55
## 20-1-2014 11:16 : 12 10-10-2013 12:29: 49
## 1-10-2013 11:35 : 10 28-1-2014 14:39 : 49
## 14-1-2014 15:25 : 10 10-10-2013 12:30: 48
## 18-12-2013 11:45: 10 10-10-2013 12:31: 47
## 23-12-2013 10:25: 10 10-10-2013 12:32: 46
## (Other) :146940 (Other) :146710
## closure_code first_call_resolution
## Other :54487 N:53008
## Software :45573 Y:93996
## Referred : 9793
## User error : 9052
## No error - works as designed: 5975
## Hardware : 4224
## (Other) :17900
## handle_time related_incident
## Min. : 0.0 :94250
## 1st Qu.: 176.0 #MULTIVALUE: 873
## Median : 324.0 IM0000220 : 239
## Mean : 444.7 IM0031184 : 85
## 3rd Qu.: 562.0 IM0016639 : 69
## Max. :22530.0 IM0014444 : 54
## (Other) :51434A first glance at the data and the data summary, rises several questions:
- We see several categorical variables with possibly many levels (e.g. ci_name). It would be interesting to get an idea of the true distribution and to see if the 20/80 rule applies (20% of the categories cover 80% of the data). This would allow us to focus on a specific, though substantial part of the data first.
- It could be interesting to see how impact, urgency, priority, first_call_resolution and handle_time relate to eachother (and how this relationship varies accross e.g. ci_type)
Testing the 20-80 Rule
To get an actual distribution of e.g. ci_name, we can use the table command. But as we can see below, this is not very usefull when there are a lot of levels.
table(interaction_data$ci_name)##
## #N/B ACS000001 ADB000005 ADB000010 ADB000011 ADB000012 ADB000021
## 16 1 1 225 1 1 1
## ADB000023 ADB000025 ADB000042 ADB000050 ADB000053 ADB000065 ADB000094
## 1 1 16 23 1 1 64
## APP000001 APP000002 APP000003 APP000004 APP000005 ASW000010 CBA000002
## 80 106 9 644 2281 60 15
## CBA000003 CBA000004 CBA000006 CBA000009 CBA000014 CBA000015 CBA000017
## 1 1 8 103 1260 1 20
## CBA000018 CBA000020 CBA000021 CBD000001 CBD000002 CBD000003 CBD000004
## 187 8 1 1 1 2 1
## CBD000005 CBD000006 CBD000007 CBD000008 CBD000009 CBD000010 CBD000011
## 2 1 1 2 1 2 1
## CBD000012 CBD000014 CBD000015 CBD000016 CBD000017 CBD000018 CBD000019
## 2 2 1 4 1 4 1
## CBD000020 CBD000021 CBD000022 CBD000023 CBD000024 CBD000025 CBD000026
## 4 1 3 3 2 1 1
## CBD000027 CBD000028 CBD000029 CBD000030 CBD000031 CBD000032 CBD000033
## 1 2 1 2 1 1 2
## CBD000034 CBD000035 CBD000036 CBD000037 CBD000038 CBD000039 CBD000040
## 2 1 2 1 1 2 1
## CBD000041 CBD000042 CBD000044 CBD000045 CBD000046 CBD000047 CBD000048
## 2 1 1 1 2 3 1
## CBD000049 CBD000050 CBD000051 CBD000052 CBD000054 CBD000055 CBD000056
## 1 1 1 1 3 1 2
## CBD000057 CBD000058 CBD000059 CBD000060 CBD000061 CBD000062 CBD000063
## 1 1 1 1 2 2 1
## CBD000064 CBD000065 CBD000066 CBD000067 CBD000068 CBD000069 CBD000070
## 2 1 2 2 1 1 1
## CBD000071 CBD000072 CBD000073 CBD000074 CBD000075 CBD000076 CBD000077
## 1 1 1 3 2 1 1
## CBD000078 CBD000079 CBD000080 CBD000081 CBD000082 CBD000083 CBD000084
## 1 2 1 1 1 2 1
## CBD000085 CBD000086 CBD000087 CBD000088 CBD000089 CBD000090 CBD000091
## 1 3 1 1 2 2 1
## CBD000092 CBD000093 CBD000094 CBD000095 CBD000096 CBD000097 CBD000098
## 1 1 1 1 2 1 1
## CBD000099 CBD000100 CBD000101 CBD000102 CBD000103 CBD000104 CBD000105
## 1 3 1 1 2 1 1
## CBD000106 CBD000107 CBD000108 CBD000110 CBD000111 CBD000112 CBD000113
## 2 1 1 2 1 2 1
## CBD000114 CBD000115 CBD000116 CBD000117 CBD000118 CBD000119 CBD000120
## 1 1 1 1 1 2 1
## CBD000121 CBD000122 CBD000123 CBD000124 CBD000125 CBD000126 CBD000127
## 1 1 1 1 1 2 1
## CBD000128 CBD000129 CBD000130 CBD000131 CBD000132 CBD000134 CBD000135
## 2 1 1 1 2 2 1
## CBD000136 CBD000137 CBD000138 CBD000139 CBD000140 CBD000141 CBD000142
## 2 2 3 1 1 3 1
## CBD000143 CBD000144 CBD000145 CBD000146 CBD000147 CBD000148 CBD000149
## 1 1 1 1 2 2 1
## CBD000150 CBD000151 CBD000152 CBD000153 CBD000154 CBD000155 CBD000156
## 1 1 1 1 2 1 1
## CBD000157 CBD000158 CBD000159 CBD000160 CBD000161 CBD000162 CBD000163
## 1 1 1 1 2 2 1
## CBD000164 CBD000165 CBD000166 CBD000167 CBD000168 CBD000169 CBD000170
## 1 1 1 1 1 1 1
## CBD000171 CBD000172 CBD000173 CBD000174 CBD000175 CBD000177 CBD000178
## 1 2 2 1 1 1 1
## CBD000179 CBD000180 CBD000181 CBD000182 CBD000183 CBD000184 CBD000185
## 1 1 2 1 1 2 1
## CBD000186 CBD000187 CBD000188 CBD000189 CBD000190 CBD000191 CBD000192
## 1 1 1 2 1 1 1
## CBD000193 CBD000194 CBD000195 CBD000196 CBD000197 CBD000198 CBD000199
## 2 1 1 1 1 1 6
## CBD000200 CBD000201 CBD000202 CBD000203 CBD000204 CBD000205 CBD000206
## 1 1 1 1 1 1 3
## CBD000207 CBD000208 CBD000209 CBD000210 CBD000211 CBD000212 CBD000213
## 1 1 1 1 1 2 1
## CBD000214 CBD000215 CBD000216 CBD000217 CBD000218 CBD000219 CBD000220
## 1 1 1 1 1 1 1
## CBD000221 CBD000222 CBD000223 CBD000224 CBD000225 CBD000226 CBD000227
## 1 3 1 1 1 1 2
## CBD000228 CBD000229 CBD000230 CBD000231 CBD000232 CBD000233 CBD000234
## 1 2 3 1 2 1 3
## CBD000235 CBD000236 CBD000237 CBD000238 CBD000239 CBD000240 CBD000241
## 1 1 1 3 1 1 1
## CBD000242 CBD000243 CBD000244 CBD000245 CBD000246 CBD000248 CBD000249
## 1 4 1 2 1 3 1
## CBD000250 CBD000251 CBD000252 CBD000253 CBD000254 CBD000255 CBD000256
## 1 2 1 1 1 1 1
## CBD000257 CBD000258 CBD000259 CBD000260 CBD000261 CBD000262 CBD000263
## 2 2 2 7 1 3 1
## CBD000264 CBD000265 CBD000266 CBD000267 CBD000268 CBD000269 CBD000271
## 2 1 1 1 1 3 2
## CBD000273 CBD000275 CBD000276 CBD000277 CBD000278 CBD000279 CBD000280
## 1 2 1 2 2 1 2
## CBD000281 CBD000282 CBD000283 CBD000285 CBD000286 CBD000287 CBD000288
## 1 2 1 1 1 1 1
## CBD000289 CBD000290 CBD000291 CBD000292 CBD000293 CBD000294 CBD000295
## 2 1 3 1 1 2 1
## CBD000296 CBD000297 CBD000298 CBD000299 CBD000300 CBD000301 CBD000302
## 1 4 3 4 3 1 1
## CBD000303 CBD000304 CBD000305 CBD000306 CBD000307 CBD000308 CBD000309
## 1 1 4 7 3 5 2
## CBD000310 CBD000311 CBD000312 CBD000313 CBD000314 CBD000315 CBD000316
## 1 1 1 1 3 1 1
## CBD000317 CBD000318 CBD000319 CBD000320 CBD000321 CBD000322 CBD000323
## 3 2 2 1 3 2 1
## CBD000324 CBD000325 CBD000326 CBD000328 CBD000329 CBD000331 CBD000332
## 1 1 1 1 1 1 2
## CBD000333 CBD000335 CBD000336 CBD000339 CBD000340 CBD000341 CBD000342
## 1 2 1 1 1 4 2
## CBD000343 CBD000344 CBD000345 CBD000347 CBD000348 CBD000349 CBD000350
## 1 1 1 1 2 1 2
## CBD000351 CBD000352 CBD000353 CBD000354 CBD000355 CBD000356 CBD000357
## 1 2 1 1 4 2 1
## CBD000358 CBD000359 CBD000360 CBD000361 CBD000362 CBD000363 CBD000364
## 3 1 1 1 1 1 3
## CBD000365 CBD000366 CBD000367 CBD000368 CBD000369 CBD000370 CBD000371
## 2 2 2 1 3 2 2
## CBD000372 CBD000373 CBD000374 CBD000375 CBD000376 CBD000377 CBD000378
## 1 1 1 3 3 1 1
## CBD000379 CBD000380 CBD000381 CBD000382 CBD000384 CBD000385 CBD000387
## 2 1 2 1 1 1 3
## CBD000388 CBD000390 CBD000391 CBD000392 CBD000393 CBD000397 CBD000398
## 3 1 1 1 5 4 3
## CBD000399 CBD000400 CBD000401 CBD000402 CBD000403 CBD000404 CBD000405
## 1 2 1 1 2 2 2
## CBD000406 CBD000407 CBD000408 CBD000409 CBD000410 CBD000411 CBD000412
## 1 3 1 1 1 1 1
## CBD000414 CBD000415 CBD000416 CBD000417 CBD000419 CBD000420 CBD000422
## 1 4 6 2 2 2 1
## CBD000423 CBD000424 CBD000425 CBD000426 CBD000427 CBD000429 CBD000430
## 1 1 1 1 1 3 1
## CBD000431 CBD000432 CBD000433 CBD000434 CBD000435 CBD000436 CBD000437
## 1 1 2 1 1 1 1
## CBD000439 CBD000440 CBD000441 CBD000442 CBD000443 CBD000444 CBD000445
## 1 2 3 2 1 2 2
## CBD000446 CBD000447 CBD000448 CBD000449 CBD000450 CBD000451 CBD000452
## 1 6 1 2 1 1 2
## CBD000453 CBD000454 CBD000455 CBD000456 CBD000457 CBD000458 CBD000459
## 2 2 1 2 1 2 1
## CBD000461 CBD000462 CBD000463 CBD000464 CBD000465 CBD000466 CBD000467
## 1 2 2 1 1 1 1
## CBD000468 CBD000469 CBD000470 CBD000471 CBD000472 CBD000473 CBD000474
## 1 1 1 5 1 1 6
## CBD000475 CBD000476 CBD000477 CBD000478 CBD000480 CBD000482 CBD000483
## 1 1 1 2 2 1 1
## CBD000484 CBD000485 CBD000486 CBD000487 CBD000488 CBD000489 CBD000490
## 1 3 1 3 1 1 1
## CBD000491 CBD000492 CBD000493 CBD000494 CBD000495 CBD000496 CBD000497
## 1 1 6 2 2 2 2
## CBD000498 CBD000499 CBD000500 CBD000501 CBD000502 CBD000503 CBD000504
## 1 1 1 1 4 1 2
## CBD000505 CBD000506 CBD000507 CBD000508 CBD000509 CBD000510 CBD000511
## 6 2 1 1 2 1 2
## CBD000512 CBD000513 CBD000514 CBD000515 CBD000516 CBD000517 CBD000518
## 4 3 1 1 2 1 1
## CBD000519 CBD000520 CBD000521 CBD000522 CBD000523 CBD000524 CBD000525
## 2 2 1 1 4 1 4
## CBD000526 CBD000528 CBD000529 CBD000530 CBD000531 CBD000532 CBD000533
## 2 1 1 1 1 1 3
## CBD000534 CBD000535 CBD000536 CBD000537 CBD000538 CBD000539 CBD000540
## 3 1 1 1 1 1 1
## CBD000541 CBD000542 CBD000543 CBD000544 CBD000545 CBD000546 CBD000547
## 1 2 1 1 1 1 6
## CBD000548 CBD000549 CBD000550 CBD000551 CBD000552 CBD000553 CBD000554
## 2 1 1 1 1 2 4
## CBD000555 CBD000556 CBD000557 CBD000558 CBD000559 CBD000560 CBD000561
## 1 1 1 1 2 1 1
## CBD000562 CBD000563 CBD000564 CBD000566 CBD000567 CBD000568 CBD000569
## 1 1 5 1 1 2 1
## CBD000570 CBD000572 CBD000573 CBD000574 CBD000575 CBD000576 CBD000577
## 1 1 1 1 1 1 9
## CBD000578 CBD000579 CBD000580 CBD000581 CBD000582 CBD000583 CBD000584
## 2 1 1 1 2 2 1
## CBD000585 CBD000586 CBD000587 CBD000588 CBD000589 CBD000590 CBD000591
## 1 1 1 1 1 1 1
## CBD000592 CBD000593 CBD000594 CBD000595 CBD000596 CBD000597 CBD000598
## 3 2 1 1 1 9 1
## CBD000600 CBD000601 CBD000602 CBD000603 CBD000604 CBD000606 CBD000607
## 1 1 1 1 1 1 1
## CBD000608 CBD000609 CBD000610 CBD000611 CBD000612 CBD000613 CBD000614
## 1 1 2 2 3 1 3
## CBD000615 CBD000616 CBD000617 CBD000618 CBD000619 CBD000620 CBD000621
## 1 2 1 1 1 2 2
## CBD000622 CBD000623 CBD000624 CBD000625 CBD000627 CBD000628 CBD000629
## 1 3 2 7 2 3 1
## CBD000630 CBD000631 CBD000632 CBD000633 CBD000634 CBD000635 CBD000636
## 1 1 1 1 2 1 6
## CBD000637 CBD000638 CBD000639 CBD000640 CBD000641 CBD000642 CBD000643
## 1 2 1 1 1 2 1
## CBD000644 CBD000645 CBD000646 CBD000649 CBD000650 CBD000651 CBD000652
## 2 1 1 1 2 1 1
## CBD000653 CBD000654 CBD000655 CBD000656 CBD000657 CBD000658 CBD000659
## 1 3 1 1 1 3 6
## CBD000660 CBD000661 CBD000662 CBD000663 CBD000664 CBD000665 CBD000666
## 1 3 3 2 4 1 3
## CBD000667 CBD000668 CBD000669 CBD000670 CBD000671 CBD000672 CBD000674
## 1 3 1 2 1 2 2
## CBD000675 CBD000676 CBD000677 CBD000678 CBD000679 CBD000680 CBD000681
## 1 1 3 1 1 1 2
## CBD000682 CBD000683 CBD000684 CBD000685 CBD000686 CBD000687 CBD000688
## 2 1 2 4 1 1 1
## CBD000689 CBD000690 CBD000691 CBD000692 CBD000693 CBD000694 CBD000695
## 2 1 1 3 1 1 1
## CBD000696 CBD000697 CBD000698 CBD000699 CBD000700 CBD000701 CBD000702
## 1 1 3 1 1 2 1
## CBD000703 CBD000705 CBD000706 CBD000707 CBD000710 CBD000711 CBD000712
## 2 1 1 1 1 1 1
## CBD000713 CBD000714 CBD000715 CBD000716 CBD000717 CBD000718 CBD000719
## 2 4 1 3 5 1 1
## CBD000720 CBD000721 CBD000722 CBD000723 CBD000724 CBD000725 CBD000726
## 1 2 1 2 1 1 1
## CBD000727 CBD000728 CBD000729 CBD000730 CBD000731 CBD000732 CBD000733
## 2 1 1 1 2 1 2
## CBD000734 CBD000735 CBD000736 CBD000737 CBD000738 CBD000739 CBD000740
## 1 1 2 1 3 1 1
## CBD000741 CBD000742 CBD000743 CBD000744 CBD000745 CBD000746 CBD000747
## 2 1 1 1 1 1 4
## CBD000748 CBD000749 CBD000750 CBD000751 CBD000752 CBD000753 CBD000754
## 1 1 3 1 1 1 1
## CBD000755 CBD000756 CBD000757 CBD000758 CBD000759 CBD000760 CBD000761
## 1 2 1 1 1 1 2
## CBD000762 CBD000763 CBD000764 CBD000765 CBD000766 CBD000767 CBD000768
## 1 1 2 2 1 3 4
## CBD000769 CBD000770 CBD000771 CBD000773 CBD000774 CBD000775 CBD000777
## 3 2 1 1 1 2 1
## CBD000778 CBD000779 CBD000780 CBD000781 CBD000782 CBD000783 CBD000784
## 1 1 5 1 1 6 1
## CBD000785 CBD000786 CBD000787 CBD000788 CBD000789 CBD000790 CBD000791
## 1 1 1 2 1 1 3
## CBD000792 CBD000793 CBD000794 CBD000795 CBD000796 CBD000797 CBD000798
## 1 4 1 2 2 2 9
## CBD000799 CBD000800 CBD000801 CBD000802 CBD000803 CBD000804 CBD000805
## 1 1 1 1 2 1 1
## CBD000806 CBD000807 CBD000808 CBD000809 CBD000810 CBD000811 CBD000812
## 1 1 1 1 2 1 1
## CBD000813 CBD000814 CBD000815 CBD000816 CBD000817 CBD000818 CBD000819
## 1 1 1 2 2 3 5
## CBD000820 CBD000821 CBD000822 CBD000823 CBD000824 CBD000825 CBD000826
## 1 1 1 1 1 2 1
## CBD000827 CBD000828 CBD000829 CBD000830 CBD000831 CBD000833 CBD000834
## 1 1 3 3 2 1 1
## CBD000836 CBD000837 CBD000838 CBD000839 CBD000840 CBD000841 CBD000842
## 2 1 2 5 3 2 1
## CBD000843 CBD000844 CBD000845 CBD000846 CBD000847 CBD000848 CBD000849
## 1 1 1 1 2 2 1
## CBD000850 CBD000851 CBD000852 CBD000853 CBD000854 CBD000855 CBD000856
## 1 1 1 2 1 2 7
## CBD000857 CBD000858 CBD000859 CBD000860 CBD000861 CBD000862 CBD000863
## 2 1 1 1 1 1 2
## CBD000864 CBD000865 CBD000866 CBD000867 CBD000868 CBD000869 CBD000870
## 1 1 4 1 1 3 1
## CBD000871 CBD000872 CBD000873 CBD000874 CBD000875 CBD000876 CBD000877
## 2 1 5 1 1 5 4
## CBD000878 CBD000879 CBD000880 CBD000881 CBD000882 CBD000883 CBD000884
## 1 3 1 1 1 1 2
## CBD000885 CBD000886 CBD000887 CBD000888 CBD000889 CBD000890 CBD000891
## 1 1 1 1 2 1 1
## CBD000892 CBD000893 CBD000895 CBD000896 CBD000897 CBD000898 CBD000899
## 1 2 1 1 2 2 1
## CBD000900 CBD000901 CBD000902 CBD000903 CBD000904 CBD000905 CBD000906
## 4 4 1 2 3 4 4
## CBD000907 CBD000908 CBD000909 CBD000910 CBD000911 CBD000912 CBD000913
## 2 3 1 1 4 2 1
## CBD000914 CBD000915 CBD000916 CBD000917 CBD000918 CBD000919 CBD000920
## 1 4 1 2 2 3 1
## CBD000921 CBD000922 CBD000926 CBD000928 CBD000929 CBD000930 CBD000931
## 2 1 2 1 1 2 3
## CBD000932 CBD000933 CBD000934 CBD000935 CBD000936 CBD000937 CBD000938
## 2 1 1 1 1 1 4
## CBD000939 CBD000940 CBD000941 CBD000942 CBD000943 CBD000945 CBD000946
## 1 1 4 1 3 1 1
## CBD000947 CBD000948 CBD000949 CBD000950 CBD000951 CBD000952 CBD000953
## 3 4 2 3 4 1 2
## CBD000954 CBD000955 CBD000956 CBD000957 CBD000958 CBD000959 CBD000960
## 1 2 2 3 1 5 1
## CBD000961 CBD000962 CBD000963 CBD000964 CBD000965 CBD000967 CBD000968
## 1 2 1 2 3 6 1
## CBD000969 CBD000970 CBD000971 CBD000972 CBD000973 CBD000974 CBD000975
## 7 3 1 3 1 1 3
## CBD000976 CBD000978 CBD000979 CBD000980 CBD000981 CBD000982 CBD000983
## 1 5 1 6 2 1 1
## CBD000984 CBD000985 CBD000986 CBD000987 CBD000988 CBD000989 CBD000990
## 1 2 1 1 2 2 1
## CBD000991 CBD000992 CBD000993 CBD000994 CBD000995 CBD000996 CBD000997
## 3 1 1 1 1 1 1
## CBD000998 CBD000999 CBD001000 CBD001001 CBD001002 CBD001003 CBD001004
## 1 2 1 1 1 2 1
## CBD001005 CBD001006 CBD001007 CBD001008 CBD001009 CBD001010 CBD001011
## 1 2 1 1 7 2 1
## CBD001012 CBD001014 CBD001015 CBD001016 CBD001017 CBD001018 CBD001019
## 1 2 1 1 3 1 1
## CBD001020 CBD001021 CBD001022 CBD001023 CBD001024 CBD001026 CBD001027
## 1 1 1 6 1 4 1
## CBD001028 CBD001029 CBD001030 CBD001031 CBD001032 CBD001033 CBD001034
## 1 1 5 1 1 1 1
## CBD001035 CBD001036 CBD001037 CBD001038 CBD001039 CBD001040 CBD001041
## 1 1 1 1 2 1 1
## CBD001042 CBD001043 CBD001044 CBD001045 CBD001046 CBD001047 CBD001048
## 1 1 1 1 1 1 1
## CBD001049 CBD001050 CBD001051 CBD001054 CBD001055 CBD001056 CBD001057
## 1 1 1 1 3 1 3
## CBD001058 CBD001059 CBD001060 CBD001061 CBD001062 CBD001063 CBD001064
## 1 5 2 1 1 2 1
## CBD001065 CBD001066 CBD001067 CBD001068 CBD001069 CBD001070 CBD001071
## 2 1 1 1 3 1 1
## CBD001072 CBD001073 CBD001074 CBD001075 CBD001076 CBD001077 CBD001078
## 2 1 1 1 1 2 1
## CBD001079 CBD001080 CBD001081 CBD001082 CBD001083 CBD001084 CBD001085
## 1 1 1 1 1 1 1
## CBD001086 CBD001087 CBD001088 CBD001089 CBD001090 CBD001091 CBD001093
## 1 2 1 1 1 1 1
## CBD001094 CBD001095 CBD001096 CBD001097 CBD001098 CBD001099 CBD001101
## 1 1 1 1 1 1 1
## CBD001102 CBD001103 CBD001104 CBD001105 CBD001106 CBD001107 CBD001109
## 1 1 1 2 1 2 1
## CBD001110 CBD001111 CBD001112 CBD001113 CBD001114 CBD001115 CBD001116
## 1 1 1 2 1 1 1
## CBD001117 CBD001118 CBD001119 CBD001120 CBD001121 CBD001122 CBD001124
## 2 1 3 1 2 1 1
## CBD001126 CBD001127 CBD001128 CBD001129 CBD001130 CBD001131 CBD001132
## 1 1 1 3 2 1 2
## CBD001133 CBD001134 CBD001135 CBD001136 CBD001137 CBD001140 CBD001141
## 1 1 1 1 1 1 1
## CBD001142 CBD001143 CBD001145 CBD001147 CBD001148 CBD001149 CBD001150
## 1 1 1 3 1 2 1
## CBD001151 CBD001152 CBD001153 CBD001154 CBD001155 CBD001156 CBD001157
## 2 1 1 1 2 1 1
## CBD001158 CBD001159 CBD001160 CBD001161 CBD001162 CBD001163 CBD001164
## 1 2 1 1 1 2 1
## CBD001165 CBD001166 CBD001167 CBD001168 CBD001169 CBD001171 CBD001172
## 1 3 3 1 3 1 3
## CBD001173 CBD001174 CBD001175 CBD001176 CBD001177 CBD001178 CBD001179
## 2 1 1 4 1 1 1
## CBD001180 CBD001181 CBD001182 CBD001183 CBD001184 CBD001185 CBD001186
## 1 1 1 1 2 1 1
## CBD001188 CBD001189 CBD001190 CBD001191 CBD001192 CBD001193 CBD001194
## 1 1 2 1 2 4 1
## CBD001196 CBD001197 CBD001198 CBD001199 CBD001200 CBD001201 CBD001202
## 1 1 1 1 1 1 1
## CBD001203 CBD001204 CBD001205 CBD001206 CBD001207 CBD001208 CBD001209
## 1 1 5 3 2 2 1
## CBD001210 CBD001212 CBD001213 CBD001214 CBD001215 CBD001216 CBD001217
## 1 1 1 1 1 1 2
## CBD001218 CBD001219 CBD001220 CBD001221 CBD001222 CBD001223 CBD001224
## 1 1 1 2 1 2 1
## CBD001226 CBD001227 CBD001229 CBD001232 CBD001233 CBD001234 CBD001235
## 1 2 1 5 1 1 3
## CBD001237 CBD001240 CBD001241 CBD001242 CBD001243 CBD001244 CNT000002
## 2 1 1 1 2 2 1
## CNT000004 CNT000005 CNT000006 CNT000007 CNT000008 CNT000009 CNT000010
## 2 5 4 1 6 8 3
## CNT000012 CNT000013 CNT000014 CNT000015 CNT000016 CNT000017 CNT000019
## 6 2 1 3 6 2 1
## CNT000020 CNT000021 CNT000022 CNT000023 CNT000024 CNT000025 CNT000026
## 2 3 7 1 6 5 2
## CNT000027 CNT000029 CNT000032 CNT000035 CNT000037 CNT000038 CNT000042
## 1 1 2 10 2 4 4
## CNT000043 CNT000045 CNT000046 CNT000047 CNT000048 CNT000057 CNT000061
## 2 6 14 6 5 1 1
## CNT000062 CNT000063 CNT000065 CNT000069 CNT000072 CNT000074 CNT000077
## 2 2 1 2 1 1 1
## COM000001 COM000003 DBI000174 DBI000184 DBR00031 DCE000002 DCE000003
## 2 1607 1 1 1 9 1
## DCE000004 DCE000007 DCE000011 DCE000041 DCE000076 DCE000077 DCE000081
## 1 1 2 1 2 112 1
## DCE000098 DCE000099 DCE000100 DCE000101 DCE000102 DCE000103 DCE000104
## 1 3 3 11 12 2 2
## DCE000105 DCE000106 DCE000107 DCE000108 DCE000109 DCE000110 DCE000111
## 8 6 7 12 7 7 5
## DCE000112 DCE000113 DCE000114 DCE000115 DCE000116 DCE000117 DCE000118
## 2 1 3 3 4 3 2
## DCE000119 DCE000120 DCE000123 DCE000125 DCE000126 DCE000165 DCE000166
## 2 1 12 1 16 1 10
## DCE000167 DCE000177 DCE000178 DCE000179 DSK000001 DSK000002 DSK000003
## 9 18 19 1 21 208 4
## DSK000004 DSK000005 DSK000006 DSK000007 DSK000008 DSK000010 DSK000011
## 27 69 147 1 26 1 1
## DSK000012 DSK000013 DSK000014 DSK000015 DSK000016 DSK000018 DSK000019
## 1 1 1 1 1 1 1
## DSK000020 DSK000022 DSK000023 DSK000024 DSK000025 DSK000027 DSK000028
## 1 1 1 2 1 2 1
## DSK000029 DSK000030 DSK000031 DSK000033 DSK000034 DSK000036 DSK000037
## 1 1 2 1 2 1 1
## DSK000039 DSK000040 DSK000041 DSK000042 DSK000043 DSK000046 DSK000048
## 1 1 1 1 1 1 1
## DSK000051 DSK000055 DSK000056 DSK000057 DSK000059 DSK000060 DSK000061
## 1 1 1 1 1 1 1
## DSK000062 DSK000063 DSK000064 DSK000065 DSK000066 DSK000067 DSK000068
## 1 1 1 1 1 1 1
## DSK000070 DSK000072 DSK000074 DSK000076 DSK000078 DSK000079 DSK000081
## 1 1 1 1 1 1 2
## DSK000084 DSK000085 DSK000086 DSK000087 DSK000088 DSK000090 DSK000091
## 1 1 1 1 1 1 1
## DSK000092 DSK000093 DSK000096 DSK000098 DSK000099 DSK000100 DSK000101
## 1 2 1 2 1 3 2
## DSK000102 DSK000103 DSK000104 DSK000105 DSK000107 DSK000108 DSK000110
## 1 2 1 1 1 1 1
## DSK000113 DSK000115 DSK000116 DSK000117 DSK000118 DSK000126 DSK000127
## 1 1 1 1 1 1 1
## DSK000128 DSK000129 DSK000130 DSK000131 DSK000132 DSK000133 DSK000134
## 1 1 1 1 1 1 1
## DSK000135 DSK000136 DSK000137 DSK000138 DSK000141 DSK000142 DSK000143
## 1 1 1 1 1 1 1
## DSK000145 DSK000146 DSK000147 DSK000148 DSK000149 DSK000150 DSK000151
## 1 1 1 1 1 1 1
## DSK000153 DSK000155 DSK000156 DSK000159 DSK000161 DSK000163 DSK000164
## 1 1 1 1 1 1 1
## DSK000167 DSK000169 DSK000171 DSK000172 DSK000173 DSK000175 DSK000176
## 1 1 1 1 1 1 1
## DSK000177 DSK000178 DSK000179 DSK000180 DSK000181 DSK000182 DSK000183
## 1 1 2 1 1 1 1
## DSK000186 DSK000190 DSK000191 DSK000193 DSK000195 DSK000196 DSK000197
## 1 2 2 1 1 1 1
## DSK000198 DSK000199 DSK000200 DSK000202 DSK000203 DSK000206 DSK000207
## 1 1 1 1 1 1 1
## DSK000208 DSK000209 DSK000210 DSK000212 DSK000213 DSK000217 DSK000219
## 1 2 2 1 2 1 1
## DSK000220 DSK000225 DSK000226 DSK000227 DSK000231 DSK000236 DSK000237
## 1 1 1 1 1 1 1
## DSK000238 DSK000239 DSK000240 DSK000241 DSK000245 DSK000251 DSK000253
## 1 1 1 1 3 1 1
## DSK000255 DSK000256 DSK000257 DSK000261 DSK000269 DSK000273 DSK000274
## 1 1 2 1 1 1 2
## DSK000277 DSK000279 DSK000281 DSK000282 DSK000283 DSK000284 DSK000285
## 2 1 1 1 1 2 1
## DSK000288 DSK000296 DSK000303 DSK000305 DSK000308 DSK000310 DSK000311
## 1 1 1 2 1 1 1
## DSK000312 DSK000313 DSK000316 DSK000321 DSK000324 DSK000327 DSK000329
## 1 1 1 1 1 1 1
## DSK000330 DSK000332 DSK000333 DSK000336 DSK000337 DSK000339 DSK000341
## 1 1 1 1 1 2 1
## DSK000342 DSK000343 DSK000344 DSK000346 DSK000347 DSK000349 DSK000351
## 1 1 1 1 1 1 1
## DSK000358 DSK000360 DSK000361 DSK000366 DSK000367 DSK000369 DSK000371
## 1 1 1 1 1 2 1
## DSK000372 DSK000375 DSK000376 DSK000377 DSK000380 DSK000388 DSK000389
## 1 1 1 1 1 1 3
## DSK000392 DSK000393 DSK000394 DSK000395 DSK000396 DSK000399 DSK000400
## 1 1 1 1 2 1 1
## DSK000401 DSK000402 DSK000403 DSK000408 DSK000409 DSK000410 DSK000411
## 1 1 1 1 1 1 1
## DSK000412 DSK000413 DSK000416 DSK000418 DSK000420 DSK000421 DSK000423
## 1 1 1 1 1 1 1
## DSK000424 DSK000425 DSK000429 DSK000430 DSK000433 DSK000434 DSK000435
## 1 1 2 1 1 1 1
## DSK000436 DSK000437 DSK000440 DSK000444 DSK000446 DSK000451 DSK000456
## 1 1 1 2 1 1 1
## DSK000457 DSK000462 DSK000463 DSK000464 DSK000465 DSK000466 DSK000468
## 1 1 1 2 1 1 1
## DSK000469 DSK000470 DSK000473 DSK000474 DSK000475 DSK000478 DSK000482
## 1 1 1 1 1 1 1
## DSK000483 DSK000484 DSK000485 DSK000486 DSK000487 DSK000493 DSK000495
## 1 1 1 1 1 1 1
## DSK000504 DSK000506 DSK000507 DSK000508 DSK000516 DSK000517 DSK000519
## 1 1 1 1 1 1 1
## DSK000526 DSK000527 DSK000528 DSK000529 DSK000530 DSK000531 DSK000532
## 1 1 2 1 1 1 1
## DSK000533 DSK000534 DSK000535 DSK000536 DSK000537 DSK000538 DSK000541
## 2 2 2 2 1 1 1
## DSK000543 DSK000544 DSK000545 DSK000547 DSK000549 DSK000551 DSK000552
## 1 2 1 1 1 1 1
## DSK000553 DSK000554 DSK000555 DSK000556 DSK000557 DSK000558 DSK000559
## 1 1 1 2 1 1 1
## DSK000561 DSK000565 DSK000567 DSK000568 DSK000569 DSK000571 DSK000574
## 2 1 1 1 1 1 1
## DSK000577 DSK000584 DSK000585 DSK000586 DSK000587 DSK000589 DSK000590
## 1 1 1 1 1 1 3
## DSK000591 DSK000593 DSK000594 DSK000595 DSK000596 DSK000597 DSK000598
## 1 1 1 1 1 1 1
## DSK000600 DSK000601 DSK000602 DSK000603 DSK000604 DSK000605 DSK000607
## 1 1 1 1 1 1 1
## DSK000608 DSK000609 DSK000611 DSK000612 DSK000614 DSK000616 DSK000617
## 1 1 1 1 2 1 1
## DSK000618 DSK000619 DSK000620 DSK000621 DSK000623 DSK000624 DSK000625
## 2 1 1 1 1 1 1
## DSK000626 DSK000627 DSK000628 DSK000629 DSK000630 DSK000632 DSK000633
## 1 3 1 3 1 1 1
## DSK000634 DSK000637 DSK000639 DSK000641 DSK000642 DSK000643 DSK000648
## 1 1 1 1 1 1 1
## DSK000649 DSK000651 DSK000653 DSK000656 DSK000657 DSK000658 DSK000659
## 1 1 1 1 1 2 1
## DSK000660 DSK000661 DSK000670 DSK000671 DSK000675 DSK000679 DSW000011
## 1 1 1 1 1 1 2
## DSW000012 DSW000027 DSW000028 DSW000044 DSW000045 DTA000001 DTA000002
## 1 1 1 3 1 96 24
## DTA000004 DTA000006 DTA000007 DTA000008 DTA000011 DTA000012 DTA000013
## 9 266 75 1 736 185 127
## DTA000015 DTA000016 DTA000017 DTA000018 DTA000019 DTA000020 DTA000021
## 72 1154 69 64 189 1 11
## DTA000023 DTA000024 DTA000025 DTA000026 DTA000027 DTA000029 DTA000030
## 717 655 520 96 199 14 2
## DTA000031 DTA000032 DTA000033 DTA000034 DTA000035 DTA000036 DTA000037
## 290 77 245 2 58 199 1
## DTA000038 DTA000039 DTA000040 DTA000041 DTA000043 DTA000044 DTA000045
## 1 1 5 1 78 21 87
## DTA000046 DTA000047 DTA000048 DTA000049 DTA000050 DTA000051 DTA000052
## 1 27 669 1 4 3 111
## DTA000053 DTA000054 DTA000055 DTA000056 DTA000057 DTA000058 DTA000059
## 394 1 43 503 5708 8 23
## DTA000060 DTA000062 DTA000064 DTA000065 DTA000066 DTA000067 DTA000068
## 44 1 138 1 1 1 14
## DTA000110 DTA000113 DTA000135 DTA000137 DTA000146 DTA000159 DTA000165
## 1 1 1 4 1 8 1
## DTA000187 DTA000189 DTA000203 DTA000231 DTA000232 DTA000253 DTA000255
## 1 460 1 10 4 1 22
## DTA000256 DTA000257 DTA000289 DTA000301 DTA000302 DTA000322 DTA000326
## 1 2 1 1 475 3 1
## DTA000332 DTA000339 DTA000344 DTA000353 DTA000363 DTA000381 DTA000382
## 1 3 203 2 2 83 1
## DTA000414 DTA000415 DTA000419 DTA000451 DTA000452 DTA000471 DTA000481
## 40 8 1 26 1 1 1
## DTA000484 DTA000489 DTA000517 DTA000519 DTA000520 DTA000521 DTA000547
## 1 1 1 1 2 1 1
## DTA000572 DTA000573 DTA000574 DTA000577 DTA000579 DTA000588 DTA000591
## 6 2 12 21 1 32 542
## DTA000596 DTA000598 DTA000599 DTA000600 DTA000601 DTA000602 DTA000612
## 14 1 2 7 2 3 4
## DTA000613 DTA000614 DTA000615 DTA000616 DTA000618 DTA000619 DTA000620
## 4 76 28 7911 1 122 5
## DTA000621 ENC000003 ENC000007 ENC000009 ENC000010 ENC000012 ENC000013
## 18 106 1 1 3 51 10
## ESC000060 ESC000069 ESC000075 ESC000082 ESS000009 ESS000030 EXC000001
## 1 1 5 1 1 1 331
## EXC000002 EXC000004 FRW000002 FRW000014 HMD000002 HMD000005 HMD000013
## 101 585 1 1 2 2 1
## HMD000014 HMD000015 HMD000016 HMD000017 HMD000018 HMD000025 HMD000026
## 2 4 15 35 1 5 13
## HMD000028 HMD000037 HMD000043 HMD000046 HMD000047 KVM000001 KYB000001
## 5 2 2 4 110 97 73
## KYB000002 LAP000002 LAP000004 LAP000005 LAP000006 LAP000007 LAP000008
## 110 422 1 1 2 69 153
## LAP000009 LAP000010 LAP000011 LAP000012 LAP000013 LAP000014 LAP000015
## 60 28 82 311 321 27 3
## LAP000016 LAP000017 LAP000018 LAP000019 LAP000021 LAP000022 LAP000023
## 48 119 52 201 1 1 1
## LAP000024 LAP000026 LAP000027 LAP000028 LAP000029 LAP000031 LAP000032
## 1 1 1 2 1 1 1
## LAP000033 LAP000035 LAP000036 LAP000037 LAP000038 LAP000039 LAP000040
## 1 1 2 2 1 1 1
## LAP000042 LAP000043 LAP000044 LAP000045 LAP000046 LAP000047 LAP000048
## 1 1 1 1 1 1 1
## LAP000050 LAP000051 LAP000052 LAP000053 LAP000054 LAP000055 LAP000056
## 1 1 1 1 1 1 1
## LAP000059 LAP000060 LAP000061 LAP000062 LAP000063 LAP000064 LAP000066
## 1 1 1 2 1 1 1
## LAP000071 LAP000073 LAP000074 LAP000075 LAP000076 LAP000077 LAP000079
## 1 2 3 1 1 1 2
## LAP000080 LAP000082 LAP000083 LAP000085 LAP000086 LAP000087 LAP000088
## 4 1 3 1 1 1 1
## LAP000090 LAP000091 LAP000099 LAP000103 LAP000106 LAP000107 LAP000109
## 1 2 1 1 1 1 1
## LAP000110 LAP000111 LAP000112 LAP000119 LAP000122 LAP000124 LAP000126
## 1 1 1 1 2 1 1
## LAP000127 LAP000131 LAP000135 LAP000136 LAP000137 LAP000138 LAP000141
## 1 2 1 1 1 1 1
## LAP000145 LAP000146 LAP000148 LAP000149 LAP000154 LAP000156 LAP000157
## 1 1 1 1 1 1 1
## LAP000159 LAP000160 LAP000162 LAP000164 LAP000165 LAP000166 LAP000167
## 3 1 1 2 1 1 1
## LAP000169 LAP000170 LAP000171 LAP000173 LAP000175 LAP000179 LAP000180
## 1 1 1 1 1 1 1
## LAP000184 LAP000188 LAP000191 LAP000195 LAP000196 LAP000197 LAP000198
## 1 2 1 1 1 1 1
## LAP000200 LAP000201 LAP000203 LAP000204 LAP000205 LAP000206 LAP000208
## 1 1 1 1 1 1 1
## LAP000209 LAP000211 LAP000212 LAP000213 LAP000214 LAP000216 LAP000217
## 1 1 1 1 1 1 1
## LAP000218 LAP000220 LAP000221 LAP000222 LAP000223 LAP000224 LAP000225
## 1 2 1 1 1 1 1
## LAP000226 LAP000228 LAP000232 LAP000233 LAP000234 LAP000236 LAP000238
## 1 1 1 1 2 1 1
## LAP000239 LAP000241 LAP000243 LAP000245 LAP000246 LAP000247 LAP000249
## 1 1 2 1 1 1 1
## LAP000250 LAP000251 LAP000252 LAP000255 LAP000256 LAP000257 LAP000258
## 1 2 1 1 1 1 1
## LAP000259 LAP000261 LAP000262 LAP000263 LAP000267 LAP000268 LAP000269
## 1 1 1 1 1 1 2
## LAP000272 LAP000275 LAP000276 LAP000278 LAP000281 LAP000282 LAP000286
## 1 1 1 1 2 1 1
## LAP000287 LAP000288 LAP000289 LAP000290 LAP000291 LAP000292 LAP000293
## 1 1 2 1 1 1 1
## LAP000294 LAP000296 LAP000299 LAP000300 LAP000302 LAP000303 LAP000306
## 1 1 1 2 1 1 1
## LAP000307 LAP000313 LAP000314 LAP000315 LAP000316 LAP000317 LAP000318
## 1 1 1 2 1 1 2
## LAP000319 LAP000320 LAP000322 LAP000324 LAP000325 LAP000326 LAP000327
## 2 1 1 1 1 1 1
## LAP000328 LAP000329 LAP000330 LAP000331 LAP000332 LAP000333 LAP000334
## 1 1 1 1 1 1 1
## LAP000335 LAP000336 LAP000338 LAP000339 LAP000340 LAP000341 LAP000343
## 1 1 1 1 1 1 1
## LAP000344 LAP000345 LAP000346 LAP000347 LAP000348 LAP000349 LAP000351
## 1 1 1 1 1 1 1
## LAP000352 LAP000353 LAP000355 LAP000356 LAP000357 LAP000358 LAP000360
## 1 1 1 2 1 1 1
## LAP000361 LAP000362 LAP000364 LAP000365 LAP000366 LAP000368 LAP000369
## 1 1 1 2 1 2 1
## LAP000370 LAP000372 LAP000373 LAP000375 LAP000377 LAP000378 LAP000380
## 1 1 1 1 1 1 1
## LAP000382 LAP000383 LAP000385 LAP000387 LAP000388 LAP000393 LAP000395
## 1 1 1 1 2 1 1
## LAP000396 LAP000397 LAP000398 LAP000399 LAP000400 LAP000402 LAP000403
## 2 1 1 1 1 1 1
## LAP000405 LAP000406 LAP000407 LAP000410 LAP000412 LAP000415 LAP000416
## 1 1 1 1 1 1 1
## LAP000417 LAP000418 LAP000419 LAP000420 LAP000421 LAP000422 LAP000423
## 1 2 1 2 1 1 1
## LAP000425 LAP000427 LAP000428 LAP000430 LAP000432 LAP000433 LAP000436
## 1 1 1 1 1 2 1
## LAP000439 LAP000440 LAP000441 LAP000442 LAP000443 LAP000444 LAP000445
## 1 1 1 1 1 1 1
## LAP000446 LAP000448 LAP000449 LAP000450 LAP000451 LAP000452 LAP000453
## 1 3 1 2 1 1 1
## LAP000454 LAP000456 LAP000458 LAP000459 LAP000466 LAP000467 LAP000468
## 1 1 1 1 1 3 1
## LAP000471 LAP000472 LAP000474 LAP000476 LAP000477 LAP000479 LAP000480
## 1 2 1 1 1 1 1
## LAP000482 LAP000484 LAP000485 LAP000487 LAP000491 LAP000493 LAP000494
## 1 1 2 1 1 1 1
## LAP000495 LAP000498 LAP000499 LAP000501 LAP000502 LAP000504 LAP000505
## 1 1 2 1 1 1 1
## LAP000509 LAP000513 LAP000515 LAP000520 LAP000521 LAP000522 LAP000523
## 1 1 2 1 2 1 1
## LAP000524 LAP000527 LAP000530 LAP000532 LAP000533 LAP000536 LAP000537
## 1 2 1 1 1 1 1
## LAP000538 LAP000541 LAP000542 LAP000547 LAP000549 LAP000551 LAP000553
## 2 1 1 2 2 2 1
## LAP000554 LAP000555 LAP000556 LAP000557 LAP000558 LAP000561 LAP000562
## 1 1 1 1 1 1 1
## LAP000563 LAP000565 LAP000567 LAP000569 LAP000571 LAP000573 LAP000574
## 1 1 1 1 1 2 1
## LAP000575 LAP000576 LAP000578 LAP000579 LAP000580 LAP000581 LAP000582
## 1 1 2 1 1 1 1
## LAP000583 LAP000584 LAP000585 LAP000588 LAP000589 LAP000590 LAP000591
## 1 4 1 1 1 1 1
## LAP000594 LAP000599 LAP000600 LAP000602 LAP000603 LAP000604 LAP000608
## 2 1 1 1 1 1 1
## LAP000611 LAP000612 LAP000613 LAP000614 LAP000615 LAP000617 LAP000618
## 1 1 1 3 3 2 1
## LAP000620 LAP000621 LAP000622 LAP000623 LAP000624 LAP000625 LAP000628
## 1 1 1 1 1 1 1
## LAP000633 LAP000634 LAP000635 LAP000637 LAP000639 LAP000640 LAP000642
## 1 1 1 1 1 2 1
## LAP000646 LAP000648 LAP000650 LAP000653 LAP000654 LAP000655 LAP000656
## 1 1 1 1 1 1 1
## LAP000659 LAP000660 LAP000662 LAP000665 LAP000666 LAP000669 LAP000670
## 1 1 1 1 1 1 1
## LAP000671 LAP000675 LAP000676 LAP000677 LAP000679 LAP000681 LAP000682
## 1 1 1 1 1 1 1
## LAP000683 LAP000688 LAP000689 LAP000690 LAP000694 LAP000695 LAP000696
## 1 1 1 1 2 1 1
## LAP000697 LAP000698 LAP000699 LAP000700 LAP000701 LAP000702 LAP000703
## 1 1 1 1 2 1 1
## LAP000704 LAP000705 LAP000707 LAP000708 LAP000712 LAP000713 LAP000715
## 1 1 1 1 1 1 1
## LAP000723 LAP000724 LAP000725 LAP000727 LAP000729 LAP000730 LAP000731
## 2 1 1 1 2 1 1
## LAP000732 LAP000734 LAP000739 LAP000741 LAP000743 LAP000744 LAP000746
## 1 1 1 1 1 1 1
## LAP000749 LAP000750 LAP000753 LAP000755 LAP000757 LAP000759 LAP000760
## 1 2 1 1 1 1 1
## LAP000762 LAP000763 LAP000766 LAP000767 LAP000769 LAP000771 LAP000772
## 1 1 1 1 1 1 1
## LAP000773 LAP000774 LAP000776 LAP000777 LAP000779 LAP000782 LAP000783
## 1 1 1 1 1 1 1
## LAP000784 LAP000786 LAP000788 LAP000790 LAP000791 LAP000792 LAP000796
## 2 2 1 1 1 2 1
## LAP000797 LAP000798 LAP000799 LAP000800 LAP000802 LAP000804 LAP000806
## 1 1 1 1 1 1 1
## LAP000808 LAP000809 LAP000810 LAP000811 LAP000812 LAP000813 LAP000816
## 1 1 1 1 1 2 1
## LAP000819 LAP000821 LAP000822 LAP000825 LAP000826 LAP000827 LAP000828
## 1 1 1 1 1 1 2
## LAP000829 LAP000830 LAP000832 LAP000833 LAP000834 LAP000836 LAP000838
## 1 1 2 1 1 1 1
## LAP000839 LAP000840 LAP000842 LAP000843 LAP000845 LAP000846 LAP000848
## 2 2 1 1 1 1 1
## LAP000849 LAP000850 LAP000853 LAP000854 LAP000855 LAP000856 LAP000857
## 1 1 2 1 1 1 1
## LAP000858 LAP000861 LAP000862 LAP000863 LAP000864 LAP000865 LAP000867
## 2 1 1 1 1 1 2
## LAP000868 LAP000869 LAP000870 LAP000871 LAP000872 LAP000873 LAP000874
## 1 1 1 1 1 1 1
## LAP000875 LAP000876 LAP000879 LAP000882 LAP000883 LAP000884 LAP000885
## 1 1 1 1 1 1 1
## LAP000886 LAP000887 LAP000889 LAP000890 LAP000892 LAP000894 LAP000895
## 1 2 1 2 1 1 1
## LAP000896 LAP000897 LAP000898 LAP000902 LAP000903 LAP000905 LAP000907
## 1 1 1 1 2 1 2
## LAP000908 LAP000911 LAP000914 LAP000915 LAP000916 LAP000917 LAP000919
## 1 2 1 1 1 1 1
## LAP000920 LAP000921 LAP000923 LAP000926 LAP000927 LAP000928 LAP000929
## 1 1 1 1 1 1 2
## LAP000931 LAP000933 LAP000934 LAP000935 LAP000937 LAP000939 LAP000942
## 1 2 1 1 1 1 2
## LAP000944 LAP000945 LAP000946 LAP000947 LAP000948 LAP000949 LAP000950
## 1 1 1 1 1 1 2
## LAP000953 LAP000954 LAP000955 LAP000956 LAP000957 LAP000958 LAP000964
## 1 1 1 1 1 1 1
## LAP000965 LAP000966 LAP000968 LAP000969 LAP000971 LAP000973 LAP000975
## 1 1 1 2 1 1 1
## LAP000976 LAP000977 LAP000978 LAP000981 LAP000985 LAP000986 LAP000990
## 1 1 1 1 2 1 1
## LAP000992 LAP000993 LAP000995 LAP000999 LAP001000 LAP001001 LAP001003
## 1 1 1 1 1 1 1
## LAP001004 LAP001005 LAP001006 LAP001007 LAP001009 LAP001010 LAP001011
## 1 1 1 1 1 2 1
## LAP001012 LAP001015 LAP001016 LAP001018 LAP001019 LAP001021 LAP001022
## 1 1 1 1 1 1 1
## LAP001023 LAP001025 LAP001027 LAP001032 LAP001033 LAP001035 LAP001038
## 1 1 1 1 1 1 1
## LAP001039 LAP001040 LAP001043 LAP001045 LAP001046 LAP001048 LAP001049
## 2 1 1 2 1 3 1
## LAP001050 LAP001053 LAP001054 LAP001055 LAP001057 LAP001058 LAP001060
## 1 1 1 1 1 1 1
## LAP001062 LAP001066 LAP001068 LAP001069 LAP001070 LAP001071 LAP001073
## 1 1 1 1 1 4 1
## LAP001074 LAP001075 LAP001078 LAP001081 LAP001083 LAP001084 LAP001088
## 1 1 1 1 1 1 1
## LAP001089 LAP001091 LAP001094 LAP001095 LAP001096 LAP001097 LAP001098
## 1 1 1 1 2 1 2
## LAP001099 LAP001100 LAP001101 LAP001102 LAP001103 LAP001105 LAP001106
## 2 1 1 1 1 2 1
## LAP001109 LAP001110 LAP001113 LAP001116 LAP001122 LAP001123 LAP001125
## 1 1 1 1 1 1 1
## LAP001126 LAP001127 LAP001128 LAP001130 LAP001133 LAP001134 LAP001135
## 1 1 1 1 1 1 1
## LAP001136 LAP001137 LAP001140 LAP001143 LAP001144 LAP001145 LAP001146
## 1 2 1 4 1 1 1
## LAP001147 LAP001149 LAP001150 LAP001152 LAP001153 LAP001154 LAP001156
## 1 1 1 4 1 1 1
## LAP001157 LAP001159 LAP001160 LAP001161 LAP001162 LAP001163 LAP001164
## 1 1 1 1 1 1 1
## LAP001165 LAP001166 LAP001167 LAP001170 LAP001171 LAP001172 LAP001174
## 1 1 3 1 1 1 1
## LAP001176 LAP001177 LAP001178 LAP001179 LAP001180 LAP001182 LAP001183
## 1 1 1 1 1 1 2
## LAP001184 LAP001185 LAP001188 LAP001190 LAP001191 LAP001192 LAP001193
## 1 1 1 2 1 2 2
## LAP001194 LAP001197 LAP001199 LAP001201 LAP001202 LAP001205 LAP001206
## 1 1 2 1 1 1 2
## LAP001207 LAP001208 LAP001209 LAP001210 LAP001211 LAP001212 LAP001213
## 1 1 1 1 1 1 1
## LAP001214 LAP001215 LAP001216 LAP001217 LAP001218 LAP001221 LAP001222
## 1 1 1 1 1 2 1
## LAP001224 LAP001225 LAP001226 LAP001227 LAP001228 LAP001229 LAP001234
## 1 1 1 1 1 1 1
## LAP001235 LAP001237 LAP001238 LAP001239 LAP001241 LAP001245 LAP001246
## 1 1 1 1 1 1 1
## LAP001247 LAP001248 LAP001249 LAP001250 LAP001253 LAP001254 LAP001255
## 1 1 2 1 1 1 1
## LAP001256 LAP001258 LAP001261 LAP001262 LAP001263 LAP001265 LAP001266
## 1 1 1 2 2 1 1
## LAP001269 LAP001271 LAP001272 LAP001274 LAP001275 LAP001276 LAP001278
## 2 1 1 1 1 1 1
## LAP001279 LAP001281 LAP001282 LAP001288 LAP001290 LAP001292 LAP001293
## 1 1 1 1 1 1 2
## LAP001298 LAP001300 LAP001301 LAP001302 LAP001303 LAP001306 LAP001308
## 1 1 3 1 3 1 1
## LAP001309 LAP001310 LAP001313 LAP001315 LAP001316 LAP001317 LAP001320
## 1 1 2 1 1 1 1
## LAP001321 LAP001322 LAP001323 LAP001324 LAP001327 LAP001330 LAP001331
## 1 1 1 1 1 1 1
## LAP001333 LAP001335 LAP001336 LAP001337 LAP001340 LAP001341 LAP001343
## 1 1 1 1 1 1 1
## LAP001346 LAP001349 LAP001352 LAP001354 LAP001356 LAP001357 LAP001358
## 1 2 1 1 1 1 1
## LAP001360 LAP001361 LAP001363 LAP001365 LAP001369 LAP001371 LAP001373
## 1 1 1 1 1 1 1
## LAP001374 LAP001375 LAP001376 LAP001378 LAP001379 LAP001382 LAP001383
## 1 1 1 1 1 1 1
## LAP001384 LAP001386 LAP001387 LAP001388 LAP001391 LAP001392 LAP001394
## 1 1 1 1 1 1 2
## LAP001396 LAP001398 LAP001401 LAP001403 LAP001404 LAP001405 LAP001406
## 1 1 1 1 1 2 1
## LAP001407 LAP001408 LAP001409 LAP001411 LAP001413 LAP001414 LAP001418
## 2 1 1 2 1 1 1
## LAP001421 LAP001423 LAP001424 LAP001427 LAP001429 LAP001431 LAP001432
## 1 1 1 2 1 1 3
## LAP001434 LAP001439 LAP001442 LAP001443 LAP001444 LAP001445 LAP001446
## 1 1 1 1 1 1 2
## LAP001448 LAP001450 LAP001452 LAP001453 LAP001455 LAP001456 LAP001457
## 1 1 1 1 2 1 2
## LAP001458 LAP001459 LAP001460 LAP001461 LAP001462 LAP001463 LAP001464
## 1 1 2 1 2 2 2
## LAP001465 LAP001467 LAP001468 LAP001469 LAP001470 LAP001471 LAP001472
## 1 1 1 1 1 1 1
## LAP001473 LAP001476 LAP001479 LAP001481 LAP001484 LAP001485 LAP001486
## 1 1 1 1 1 1 2
## LAP001487 LAP001488 LAP001489 LAP001490 LAP001491 LAP001492 LAP001493
## 1 1 1 2 1 1 3
## LAP001494 LAP001495 LAP001496 LAP001497 LAP001502 LAP001507 LAP001510
## 1 1 1 1 1 1 1
## LAP001513 LAP001514 LAP001518 LAP001519 LAP001520 LAP001523 LAP001527
## 1 1 1 1 1 1 1
## LAP001529 LAP001534 LAP001536 LAP001537 LAP001538 LAP001539 LAP001540
## 1 1 1 1 2 1 1
## LAP001543 LAP001545 LAP001546 LAP001547 LAP001548 LAP001549 LAP001550
## 1 1 1 5 1 1 2
## LAP001552 LAP001553 LAP001554 LAP001555 LAP001558 LAP001559 LAP001560
## 1 1 2 1 2 1 1
## LAP001561 LAP001562 LAP001563 LAP001564 LAP001567 LAP001568 LAP001569
## 1 2 1 1 2 3 1
## LAP001570 LAP001571 LAP001574 LAP001575 LAP001578 LAP001580 LAP001582
## 1 1 1 1 1 1 1
## LAP001584 LAP001585 LAP001586 LAP001591 LAP001592 LAP001593 LAP001595
## 2 1 1 1 1 1 2
## LAP001598 LAP001600 LAP001602 LAP001603 LAP001604 LAP001605 LAP001607
## 1 1 1 1 1 1 1
## LAP001608 LAP001609 LAP001610 LAP001611 LAP001612 LAP001615 LAP001616
## 1 1 1 1 1 1 1
## LAP001617 LAP001621 LAP001624 LAP001625 LAP001627 LAP001628 LAP001629
## 1 1 1 1 1 1 1
## LAP001630 LAP001631 LAP001632 LAP001633 LAP001635 LAP001636 LAP001637
## 1 1 1 1 1 1 1
## LAP001638 LAP001639 LAP001641 LAP001642 LAP001647 LAP001648 LAP001649
## 2 1 1 1 1 1 1
## LAP001650 LAP001652 LAP001653 LAP001656 LAP001657 LAP001658 LAP001659
## 1 1 1 1 1 1 1
## LAP001660 LAP001666 LAP001668 LAP001670 LAP001671 LAP001672 LAP001673
## 1 1 1 1 1 2 1
## LAP001674 LAP001675 LAP001678 LAP001680 LAP001681 LAP001682 LAP001683
## 1 1 1 1 1 1 1
## LAP001685 LAP001687 LAP001690 LAP001691 LAP001692 LAP001694 LAP001697
## 1 1 1 2 1 1 2
## LAP001700 LAP001703 LAP001706 LAP001708 LAP001709 LAP001711 LAP001712
## 2 1 1 1 1 1 1
## LAP001714 LAP001715 LAP001717 LAP001718 LAP001719 LAP001722 LAP001724
## 1 2 2 1 1 1 1
## LAP001725 LAP001729 LAP001730 LAP001732 LAP001734 LAP001735 LAP001736
## 1 1 1 1 1 1 1
## LAP001737 LAP001741 LAP001742 LAP001743 LAP001745 LAP001746 LAP001748
## 1 1 1 1 1 1 2
## LAP001751 LAP001753 LAP001764 LAP001768 LAP001769 LAP001778 LAP001780
## 1 1 1 1 1 1 1
## LAP001781 LAP001788 LAP001789 LAP001791 LAP001795 LAP001797 LAP001798
## 1 1 1 1 1 1 1
## LAP001799 LAP001800 LAP001810 LAP001811 LAP001815 LAP001817 LAP001818
## 1 1 1 1 1 1 1
## LAP001821 LAP001828 LAP001831 LAP001837 LSR000026 LSR000080 LSR000146
## 1 1 1 462 1 1 1
## LSR000160 LSR000161 LSR000438 LSR000690 LSR000711 LSR000715 LSR000718
## 26 1 2 1 1 1 5
## LSR000731 LSR000732 LSR000846 LSR001042 LSR001043 LSR001044 LSR001045
## 1 1 1 3 2 2 1
## LSR001046 LSR001047 LSR001048 LSR001049 LSR001050 MON00003 MON00005
## 1 1 1 2 2 1 1
## MON00007 MON00008 MON00009 MON00010 MON00011 MON00012 MON00013
## 1 1 3 16 39 6 3
## MON00014 MON00015 MON00016 MON00017 MON00018 MON00019 MON00020
## 1 1478 1 1 2 4 13
## MON00021 MON00022 MON00023 MON00024 MON00025 MON00026 MON00027
## 3 10 12 9 6 8 41
## MON00028 MQM000025 MQM000322 NET000001 NET000018 NET000019 NET000020
## 2 1 3 1 1 1 1
## NET000022 NET000023 NET000024 NET000025 NET000028 NET000036 NET000037
## 1 1 1 1 1 1 1
## NET000042 NET000043 NET000049 NET000061 NET000075 NET000076 NET000077
## 1 1 1 1 1 10 1
## NET000083 NET000084 NET000092 NET000104 NET000105 NET000110 NET000120
## 4 3 2 1 1 1 1
## NET000121 NET000127 NET000129 NET000132 NET000133 NET000135 NET000137
## 2 1 1 1 1 1 1
## NET000138 NET000139 NET000142 NET000143 NET000145 NET000147 NET000148
## 1 1 1 1 1 1 1
## NET000149 NET000150 NET000152 NET000176 NET000207 NET000212 NET000217
## 1 1 1 1 3 1 1
## NET000300 NET000342 NET000381 NET000425 NET000426 NET000428 NET000429
## 2 1 1 1 1 1 1
## NET000430 NET000431 NET000432 NET000433 NET000444 NSH000001 NSH000002
## 1 1 1 1 1 1 1
## NSR000001 NSS000002 NSS000003 NSS000005 NSS000007 NSS000012 NSS000014
## 1 1 3 1 1 1 2
## NSS000015 NSS000016 NSS000025 NSS000027 NSS000029 OES000002 OES000032
## 1 1 4 1 2 1 1
## OES000041 OVR000009 OVR000010 OVR000011 OVR000014 OVR000015 OVR000016
## 1 1 2 4 1 3 1
## OVR000017 OVR000025 OVR000033 OVR000035 OVR000038 OVR000039 OVR000040
## 1 200 478 2 1 1 1
## OVR000041 OVR000042 OVR000043 OVR000044 OVR000047 OVR000059 OVR000060
## 1 2 1 1 2 5 2
## OVR000067 OVR000069 OVR000070 OVR000071 OVR000072 OVR000073 OVR000074
## 6 2 7 1 1 2 1
## OVR000078 OVR000081 OVR000083 OVR000084 OVR000085 OVR000086 OVR000087
## 1 1 3 1 1 1 1
## OVR000088 OVR000089 OVR000090 OVR000091 OVR000092 OVR000093 OVR000096
## 1 1 1 1 10 9 1
## OVR000098 OVR000099 OVR000100 OVR000101 OVR000107 OVR000146 OVR000147
## 3 4 1 1 1 2 1
## OVR000150 PHN000045 PHN000062 PRN000001 PRN000002 PRN000003 PRN000005
## 1 1 1 1 1 2 3
## PRN000006 PRN000007 PRN000008 PRN000009 PRN000010 PRN000011 PRN000012
## 1 1 1 1 1 1 1
## PRN000013 PRN000014 PRN000015 PRN000016 PRN000017 PRN000018 PRN000019
## 1 1 1 1 1 1 1
## PRN000020 PRN000021 PRN000022 PRN000025 PRN000028 PRN000029 PRN000030
## 1 1 1 1 1 1 1
## PRN000031 PRN000033 PRN000034 PRN000035 PRN000036 PRN000038 PRN000039
## 1 1 1 1 1 1 1
## PRN000040 PRN000041 PRN000042 PRN000043 PRN000044 PRN000045 PRN000046
## 1 1 1 2 1 1 1
## PRN000047 PRN000048 PRN000050 PRN000051 PRN000052 PRN000053 PRN000054
## 2 1 1 1 1 1 1
## PRN000055 PRN000056 PRN000057 PRN000058 PRN000059 PRN000060 PRN000061
## 1 1 2 1 2 1 1
## PRN000062 PRN000063 PRN000064 PRN000065 PRN000067 PRN000068 PRN000069
## 1 1 2 1 1 3 2
## PRN000070 PRN000071 PRN000072 PRN000073 PRN000074 PRN000075 PRN000076
## 2 2 1 1 1 1 1
## PRN000077 PRN000078 PRN000079 PRN000080 PRN000081 PRN000082 PRN000083
## 1 2 1 1 1 1 1
## PRN000084 PRN000085 PRN000086 PRN000087 PRN000088 PRN000089 PRN000090
## 1 1 1 1 1 1 1
## PRN000091 PRN000092 PRN000093 PRN000094 PRN000095 PRN000096 PRN000097
## 2 1 1 1 1 1 1
## PRN000098 PRN000099 PRN000100 PRN000101 PRN000102 PRN000103 PRN000104
## 1 1 1 1 1 1 2
## PRN000105 PRN000106 PRN000107 PRN000108 PRN000109 PRN000110 PRN000111
## 1 1 1 1 1 1 1
## PRN000113 PRN000114 PRN000115 PRN000132 PRN000133 PRN000134 PRN000135
## 1 1 1 1 3 1 1
## PRN000136 PRN000137 PRN000138 PRN000139 PRN000140 PRN000141 PRN000142
## 2 1 2 32 176 1 1
## PRN000143 PRN000144 PRN000145 PRN000146 PRN000147 PRN000148 PRN000149
## 1 1 1 1 2 1 1
## PRN000150 PRN000151 PRN000152 PRN000153 PRN000155 PRN000157 PRN000158
## 1 1 1 1 1 1 1
## PRN000159 RTR000009 RTR000013 RTR000020 RTR000028 RTR000029 RTR000033
## 1 1 1 1 1 1 1
## RTR000037 RTR000041 RTR000045 RTR000064 SAN000002 SAN000003 SAN000004
## 1 1 1 1 2 1 1
## SAN000005 SAN000006 SAN000036 SAN000037 SAN000052 SAN000088 SAN000089
## 1 1 1 1 1 1 1
## SAN000092 SAN000103 SAN000104 SAN000105 SAN000108 SAN000130 SAN000135
## 1 2 1 1 1 2 2
## SAN000137 SAN000138 SAN000141 SAN000144 SAN000145 SAN000146 SAN000147
## 2 2 2 2 1 1 2
## SAN000148 SAN000149 SAN000151 SAN000152 SAN000153 SAN000154 SAN000155
## 1 2 7 4 6 2 14
## SAN000156 SAN000157 SAN000178 SAN000182 SAN000184 SAP000002 SAP000003
## 7 2 862 10668 67 30 176
## SAP000004 SAP000005 SAP000006 SBA000001 SBA000004 SBA000007 SBA000008
## 952 378 16 1 1 2 3
## SBA000010 SBA000011 SBA000016 SBA000017 SBA000018 SBA000020 SBA000025
## 611 6 1 1512 36 28 269
## SBA000026 SBA000028 SBA000029 SBA000033 SBA000035 SBA000039 SBA000043
## 399 135 101 160 89 5 2
## SBA000045 SBA000049 SBA000053 SBA000054 SBA000057 SBA000058 SBA000059
## 122 8 1 412 3 14 3
## SBA000060 SBA000061 SBA000063 SBA000067 SBA000069 SBA000071 SBA000072
## 38 51 263 13 2 137 114
## SBA000073 SBA000074 SBA000076 SBA000078 SBA000079 SBA000080 SBA000081
## 59 113 33 4 214 1 2
## SBA000082 SBA000083 SBA000086 SBA000087 SBA000088 SBA000096 SBA000097
## 3 1 25 7 290 17 3
## SBA000100 SBA000101 SBA000111 SBA000113 SBA000118 SBA000119 SBA000120
## 1 121 1 4 5 103 34
## SBA000122 SBA000125 SBA000129 SBA000130 SBA000131 SBA000132 SBA000134
## 61 10 1 7 556 3 1
## SBA000135 SBA000137 SBA000141 SBA000142 SBA000144 SBA000145 SBA000146
## 1 3 8 189 6 44 1
## SBA000149 SBA000152 SBA000154 SBA000155 SBA000158 SBA000159 SBA000160
## 2 1 184 4 70 1 4
## SBA000163 SBA000164 SBA000165 SBA000167 SBA000168 SBA000169 SBA000170
## 5 1 4 28 2 1 5
## SBA000172 SBA000173 SBA000174 SBA000176 SBA000177 SBA000178 SBA000179
## 1251 74 9 3 1 1 1
## SBA000180 SBA000181 SBA000182 SBA000184 SBA000186 SBA000189 SBA000191
## 3 3 4 26 16 414 1
## SBA000193 SBA000196 SBA000203 SBA000206 SBA000207 SBA000211 SBA000213
## 10 1 1 1 1 4 17
## SBA000216 SBA000219 SBA000222 SBA000227 SBA000231 SBA000232 SBA000233
## 1 1 1 44 1 2 31
## SBA000235 SBA000241 SBA000242 SBA000243 SBA000245 SBA000249 SBA000251
## 2 2 1 6 23 1 21
## SBA000252 SBA000255 SBA000256 SBA000257 SBA000259 SBA000260 SBA000262
## 1 1 79 3 12 2 1
## SBA000263 SBA000264 SBA000266 SBA000267 SBA000268 SBA000276 SBA000277
## 3309 7 12 10 1 2 2
## SBA000279 SBA000283 SBA000284 SBA000287 SBA000288 SBA000290 SBA000291
## 1 1 374 21 30 3 1
## SBA000292 SBA000295 SBA000296 SBA000299 SBA000300 SBA000301 SBA000304
## 9 378 29 2 91 1 2
## SBA000307 SBA000309 SBA000310 SBA000311 SBA000313 SBA000314 SBA000316
## 1 1 86 43 9 51 2
## SBA000317 SBA000320 SBA000322 SBA000323 SBA000324 SBA000325 SBA000326
## 843 2 10 6 1 9 82
## SBA000328 SBA000330 SBA000333 SBA000335 SBA000338 SBA000342 SBA000343
## 1 2 1 109 65 2 31
## SBA000346 SBA000347 SBA000350 SBA000352 SBA000354 SBA000357 SBA000360
## 4 19 2 38 6 59 54
## SBA000386 SBA000393 SBA000394 SBA000398 SBA000399 SBA000400 SBA000402
## 5 118 84 6 4 3 4
## SBA000405 SBA000407 SBA000409 SBA000410 SBA000413 SBA000416 SBA000417
## 22 8 3 2 2 3 1
## SBA000418 SBA000419 SBA000420 SBA000422 SBA000423 SBA000424 SBA000427
## 38 22 12 7 57 1 568
## SBA000429 SBA000433 SBA000435 SBA000436 SBA000437 SBA000439 SBA000440
## 14 2 81 19 5 3983 2
## SBA000442 SBA000446 SBA000447 SBA000451 SBA000453 SBA000455 SBA000458
## 11 6 1 179 3 12 774
## SBA000459 SBA000460 SBA000461 SBA000462 SBA000464 SBA000467 SBA000479
## 591 89 263 3695 750 6 2
## SBA000485 SBA000500 SBA000515 SBA000516 SBA000517 SBA000518 SBA000523
## 1 3 2 9 18 14 9
## SBA000526 SBA000529 SBA000531 SBA000536 SBA000537 SBA000538 SBA000539
## 27 4 31 2 1 1 2
## SBA000540 SBA000543 SBA000559 SBA000563 SBA000564 SBA000569 SBA000571
## 17 3 2 1 4 1 20
## SBA000575 SBA000579 SBA000580 SBA000585 SBA000588 SBA000589 SBA000590
## 1 1 1 90 1 1 68
## SBA000594 SBA000599 SBA000601 SBA000602 SBA000604 SBA000605 SBA000606
## 1 1 1 2 44 1 55
## SBA000607 SBA000608 SBA000609 SBA000610 SBA000611 SBA000612 SBA000613
## 2827 49 551 1 3 2 7
## SBA000615 SBA000617 SBA000618 SBA000620 SBA000621 SBA000622 SBA000623
## 1 75 4 5 11 3 5
## SBA000624 SBA000626 SBA000628 SBA000629 SBA000630 SBA000641 SBA000642
## 1040 539 18 59 155 1 3
## SBA000643 SBA000644 SBA000645 SBA000646 SBA000649 SBA000651 SBA000659
## 7 12 58 2 8 7 4008
## SBA000662 SBA000663 SBA000665 SBA000669 SBA000670 SBA000671 SBA000674
## 52 2 32 1 1 211 2
## SBA000676 SBA000678 SBA000679 SBA000681 SBA000683 SBA000684 SBA000685
## 1 4 9 1 9 1 1
## SBA000686 SBA000687 SBA000688 SBA000689 SBA000690 SBA000693 SBA000694
## 5 3 2 570 302 2 10
## SBA000695 SBA000698 SBA000699 SBA000705 SBA000707 SBA000708 SBA000709
## 1 484 2 5 1 1 239
## SBA000710 SBA000711 SBA000713 SBA000714 SBA000716 SBA000727 SBA000728
## 1 21 42 1 1 1 1
## SBA000729 SBA000730 SBA000731 SBA000733 SBA000735 SBA000740 SBA000743
## 2588 28 1 21 8 4 18
## SBA000747 SBA000751 SBA000757 SBA000759 SBA000762 SBA000763 SBA000764
## 973 1 1 589 4 2 10
## SBA000765 SBA000766 SBA000767 SBA000768 SBA000769 SBA000770 SBA000773
## 5 10 20 3 1 1 34
## SBA000777 SBA000778 SBA000779 SBA000780 SBA000781 SBA000782 SBA000783
## 2 1 3 1 1 233 5
## SBA000784 SBA000785 SBA000787 SBA000788 SBA000790 SBA000795 SBA000805
## 1 1 6 1 2 26 604
## SBA000807 SBA000809 SBA000810 SBA000811 SBA000812 SBA000813 SBA000814
## 3 3 3 105 700 17 1
## SBA000816 SBA000817 SBA000818 SBA000820 SBA000821 SBA000823 SBA000824
## 7 2 9 1 5 1 7
## SBA000825 SBA000827 SBA000831 SBA000834 SBA000841 SBA000842 SBA000843
## 2 6 5 861 5 6 2
## SBA000844 SBA000845 SBA000846 SBA000847 SBA000849 SBA000850 SBA000855
## 13 1 1 177 3 26 1
## SCN000001 SCN000002 SCN000003 SCN000004 SCN000005 SPF000018 SSW000019
## 98 46 149 6 1 16 1
## SSW000021 SSW000031 SSW000039 SSW000040 SSW000048 SSW000056 SSW000057
## 1 1 1 1 1 2 1
## SSW000058 SSW000059 SSW000068 SSW000137 SSW000152 SSW000153 SSW000154
## 64 1 1626 3 2 1 1
## SSW000156 SSW000161 SSW000168 SSW000169 SSW000171 SSW000172 SSW000173
## 2 1 3 3 54 26 4
## SSW000175 SSW000247 SSW000280 SSW000327 SSW000336 SSW000341 SSW000356
## 2 1 1 1 2 1 80
## SSW000370 SSW000372 SSW000381 SSW000384 SSW000385 SSW000386 SSW000387
## 1 1 4 1 1 1 1
## SSW000414 SSW000416 SSW000417 SSW000418 SSW000426 SSW000427 SSW000440
## 1 1 4 1 1 1 1
## SSW000489 SSW000495 SSW000496 SSW000497 SSW000581 STA000001 STA000010
## 1 2 1 2 1 1 3
## STA000011 STA000012 STA000013 STA000015 STA000017 STA000019 STA000020
## 20 2 26 1 26 1 1
## STA000021 STA000022 STA000023 STA000025 STA000026 STA000032 STA000033
## 1 1 1 1 2 1 9
## STA000037 STA000043 STA000045 STA000049 STA000050 STA000059 STR000001
## 3 1 1 8 1 4 1
## SUB000002 SUB000004 SUB000008 SUB000016 SUB000017 SUB000030 SUB000034
## 716 43 2 13 176 3 23
## SUB000036 SUB000049 SUB000051 SUB000057 SUB000058 SUB000059 SUB000060
## 1 1 1 5 5 5 1
## SUB000062 SUB000063 SUB000064 SUB000068 SUB000073 SUB000074 SUB000081
## 1 2 1 1 155 1 15
## SUB000082 SUB000086 SUB000093 SUB000109 SUB000113 SUB000121 SUB000125
## 11 1 1 1 2213 1 1
## SUB000130 SUB000136 SUB000143 SUB000148 SUB000149 SUB000151 SUB000152
## 1 5 22 1 52 1 1
## SUB000161 SUB000196 SUB000202 SUB000251 SUB000253 SUB000255 SUB000256
## 29 1 1 5 18 1 3
## SUB000263 SUB000265 SUB000266 SUB000270 SUB000282 SUB000286 SUB000289
## 6 2 4 40 6 56 21
## SUB000303 SUB000309 SUB000310 SUB000311 SUB000317 SUB000374 SUB000386
## 1 1 34 1 4 1 1
## SUB000389 SUB000395 SUB000401 SUB000403 SUB000414 SUB000417 SUB000418
## 4 3 1 241 1 5 2
## SUB000420 SUB000421 SUB000422 SUB000424 SUB000425 SUB000426 SUB000427
## 74 2 30 1936 1 840 154
## SUB000431 SUB000433 SUB000434 SUB000436 SUB000439 SUB000440 SUB000441
## 13 450 3 440 1 1 6
## SUB000442 SUB000443 SUB000445 SUB000447 SUB000450 SUB000454 SUB000455
## 743 927 38 41 135 1 163
## SUB000456 SUB000457 SUB000458 SUB000464 SUB000465 SUB000468 SUB000471
## 6476 41 11 1 177 2 10
## SUB000476 SUB000479 SUB000480 SUB000481 SUB000482 SUB000483 SUB000497
## 5 714 1 12 16 1 6
## SUB000505 SUB000508 SUB000511 SUB000512 SUB000513 SUB000514 SUB000521
## 53 352 1 100 41 19 262
## SUB000522 SUB000523 SUB000524 SUB000533 SUB000534 SUB000535 SUB000537
## 2 776 56 739 67 104 89
## SUB000538 SUB000539 SUB000540 SUB000541 SUB000542 SUB000543 SUB000544
## 194 196 17 1 1 1 1
## SUB000545 SUB000546 SWT000001 SWT000009 SWT000027 SWT000062 SWT000182
## 213 12 1 1 1 1 1
## SWT000183 SWT000287 SWT000298 SWT000305 SWT000307 SWT000312 SWT000316
## 1 1 1 1 1 1 1
## SWT000318 SWT000319 SWT000321 SWT000324 SWT000329 SWT000341 SWT000342
## 1 2 1 1 1 1 1
## SWT000350 SWT000351 SWT000352 SWT000412 SWT000413 SWT000430 SYS000002
## 1 4 1 1 1 1 1
## SYS000004 TAB000001 TAP000002 TAP000014 TCL000001 TCL000007 TCL000013
## 1 1 1 1 1 1 1
## TCL000016 TCL000021 TCL000026 TCL000034 TCL000036 UIX000083 UIX000107
## 1 1 1 1 1 1 1
## UIX000125 UIX000193 UIX000359 VDI000024 VDI000046 VDI000096 VDI000149
## 1 1 1 1 1 1 1
## VDI000159 VDI000269 VDI000375 VDI001003 VDI001004 VDI001005 VDI001006
## 1 1 1 1 1 1 1
## VDI001008 VDI001011 VDI001015 VDI001016 VDI001018 VDI001020 VDI001026
## 1 1 1 1 1 1 1
## VDI001028 VDI001032 VDI001033 VDI001034 VDI001036 VMW000022 VTS000014
## 1 1 1 1 1 6 1
## WBA000001 WBA000003 WBA000005 WBA000007 WBA000008 WBA000009 WBA000011
## 93 148 8 5 302 175 2112
## WBA000014 WBA000017 WBA000018 WBA000022 WBA000023 WBA000024 WBA000025
## 27 115 943 466 9 1 21
## WBA000026 WBA000028 WBA000029 WBA000031 WBA000034 WBA000040 WBA000043
## 1 15 1 1 18 2 32
## WBA000044 WBA000049 WBA000051 WBA000053 WBA000054 WBA000057 WBA000058
## 48 24 1 4 32 2 2516
## WBA000059 WBA000060 WBA000062 WBA000065 WBA000068 WBA000069 WBA000070
## 1 392 9 1 264 5 2
## WBA000071 WBA000072 WBA000077 WBA000079 WBA000082 WBA000083 WBA000084
## 29 1 339 47 131 4 1
## WBA000085 WBA000092 WBA000094 WBA000095 WBA000097 WBA000103 WBA000104
## 1 159 564 2 4 762 11
## WBA000106 WBA000107 WBA000112 WBA000113 WBA000114 WBA000116 WBA000117
## 14 68 20 17 8 79 5
## WBA000118 WBA000119 WBA000120 WBA000121 WBA000122 WBA000124 WBA000126
## 1 14 2 1 225 1217 73
## WBA000127 WBA000128 WBA000129 WBA000131 WBA000133 WBA000135 WBA000139
## 2 176 3 27 6897 1 1
## WBA000140 WBA000141 WBA000143 WBA000144 WBA000145 WBA000146 WBA000147
## 2 53 8 2112 433 8 28
## WBA000148 WBA000150 WBA000151 WSR000001 WSR000008 WSR000118 WSR000119
## 1171 34 11 1 1 1 2
## WSR000124 WSR000166 WSR000174 WSR000175 WSR000178 WSR000180 WSR000182
## 1 2 1 1 1 1 1
## WSR000183 WSR000188 WSR000194 WSR000197 WSR000202 WSR000212 WSR000219
## 1 1 2 1 2 1 2
## WSR000220 WSR000221 WSR000229 WSR000231 WSR000240 WSR000248 WSR000252
## 1 1 1 1 2 1 1
## WSR000259 WSR000263 WSR000267 WSR000281 WSR000282 WSR000294 WSR000338
## 1 2 1 1 3 1 1
## WSR000355 WSR000371 WSR000373 WSR000374 WSR000395 WSR000396 WSR000429
## 2 2 1 1 1 1 1
## WSR000462 WSR000502 WSR000527 WSR000592 WSR000650 WSR000651 WSR000660
## 1 1 1 1 1 1 2
## WSR000664 WSR000682 WSR000695 WSR000712 WSR000719 WSR000721 WSR000786
## 2 1 1 1 2 3 2
## WSR000787 WSR000790 WSR000793 WSR000834 WSR000842 WSR000845 WSR000850
## 1 1 1 1 1 1 1
## WSR000851 WSR000862 WSR000875 WSR000893 WSR000918 WSR000924 WSR000926
## 1 1 1 1 2 2 2
## WSR000927 WSR000937 WSR000943 WSR000950 WSR000952 WSR000981 WSR000997
## 1 1 5 1 4 1 1
## WSR000999 WSR001006 WSR001025 WSR001051 WSR001058 WSR001100 WSR001104
## 2 1 1 1 1 3 2
## WSR001112 WSR001114 WSR001127 WSR001128 WSR001130 WSR001133 WSR001141
## 2 1 2 1 2 2 1
## WSR001157 WSR001167 WSR001173 WSR001194 WSR001202 WSR001203 WSR001215
## 1 1 4 3 1 1 1
## WSR001217 WSR001219 WSR001222 WSR001247 WSR001252 WSR001256 WSR001281
## 1 1 1 1 2 1 1
## WSR001283 WSR001286 WSR001294 WSR001301 WSR001317 WSR001324 WSR001342
## 1 1 1 1 1 1 1
## WSR001349 WSR001354 WSR001370 WSR001374 WSR001387 WSR001392 WSR001396
## 1 3 1 2 3 1 1
## WSR001397 WSR001424 WSR001438 WSR001487 WSR001494 WSR001498 WSR001503
## 2 1 1 2 1 1 1
## WSR001512 WSR001524 WSR001575 WSR001619 WSR001641 WSR001647 WSR001655
## 19 1 1 1 1 1 3
## WSR001670 WSR001674 WSR001684 WSR001710 WSR001720 WSR001824 WSR001879
## 1 1 1 1 1 2 1
## WSR001895 WSR001917 WSR001931 WSR001939 WSR001942 WSR001954 WSR001986
## 1 2 2 1 2 1 1
## XSR000008 XSR000017 XSR000042 XSR000091 XSR000092 XSR000093 XSR000094
## 1 1 1 1 1 1 2
## XSR000124 XSR000133 ZOC000002 ZOC000003 ZOC000004 ZOC000005 ZOS000006
## 1 1 7 1 9 1 1
## ZOS000011 ZOS000016
## 1 2There are many issues with the output above:
- The output is not in a table format, which makes it hard to read
- We only get the absolute occurences of each category, no percentages or cumulative figures
- The output is ordered based the alphabetical ordering of the category lables (i.e. levels)
- All levels are shown, also the ones that only occur once!
We can solve these issues with dplyr
by_ci_name <- interaction_data %>%
group_by(ci_name) %>%
summarise(n = n()) %>%
arrange(desc(n)) %>%
mutate(perc = n / sum(n), cum_perc = cumsum(perc), rank = 1-percent_rank(n))
by_ci_name## Source: local data frame [4,153 x 5]
##
## ci_name n perc cum_perc rank
## 1 SAN000182 10668 0.07256945 0.07256945 -2.886580e-15
## 2 DTA000616 7911 0.05381486 0.12638432 2.408478e-04
## 3 WBA000133 6897 0.04691709 0.17330141 4.816956e-04
## 4 SUB000456 6476 0.04405322 0.21735463 7.225434e-04
## 5 DTA000057 5708 0.03882888 0.25618351 9.633911e-04
## 6 SBA000659 4008 0.02726456 0.28344807 1.204239e-03
## 7 SBA000439 3983 0.02709450 0.31054257 1.445087e-03
## 8 SBA000462 3695 0.02513537 0.33567794 1.685934e-03
## 9 SBA000263 3309 0.02250959 0.35818753 1.926782e-03
## 10 SBA000607 2827 0.01923077 0.37741830 2.167630e-03
## .. ... ... ... ... ...Let’s see to what extent the 20-80 rule holds up here?
library(ggplot2)
ggplot(by_ci_name, aes(x = rank, y = cum_perc)) + geom_line() + geom_hline(y=0.8) + geom_vline(x=0.2)
This graph shows that 20% of the levels cover a lot more than 80% of the data, or one needs less than 20% of the levels to cover 80% of the data. A follow-up question could be how many (and which) levels one actually needs to cover 80% of the data?
by_ci_name %>%
filter(cum_perc < 0.80)## Source: local data frame [81 x 5]
##
## ci_name n perc cum_perc rank
## 1 SAN000182 10668 0.072569454 0.07256945 -2.886580e-15
## 2 DTA000616 7911 0.053814862 0.12638432 2.408478e-04
## 3 WBA000133 6897 0.046917091 0.17330141 4.816956e-04
## 4 SUB000456 6476 0.044053223 0.21735463 7.225434e-04
## 5 DTA000057 5708 0.038828875 0.25618351 9.633911e-04
## 6 SBA000659 4008 0.027264564 0.28344807 1.204239e-03
## 7 SBA000439 3983 0.027094501 0.31054257 1.445087e-03
## 8 SBA000462 3695 0.025135370 0.33567794 1.685934e-03
## 9 SBA000263 3309 0.022509592 0.35818753 1.926782e-03
## 10 SBA000607 2827 0.019230769 0.37741830 2.167630e-03
## 11 SBA000729 2588 0.017604963 0.39502326 2.408478e-03
## 12 WBA000058 2516 0.017115181 0.41213845 2.649326e-03
## 13 APP000005 2281 0.015516585 0.42765503 2.890173e-03
## 14 SUB000113 2213 0.015054012 0.44270904 3.131021e-03
## 15 WBA000011 2112 0.014366956 0.45707600 3.612717e-03
## 16 WBA000144 2112 0.014366956 0.47144295 3.612717e-03
## 17 SUB000424 1936 0.013169710 0.48461266 3.853565e-03
## 18 SSW000068 1626 0.011060924 0.49567359 4.094412e-03
## 19 COM000003 1607 0.010931675 0.50660526 4.335260e-03
## 20 SBA000017 1512 0.010285434 0.51689070 4.576108e-03
## 21 MON00015 1478 0.010054148 0.52694485 4.816956e-03
## 22 CBA000014 1260 0.008571195 0.53551604 5.057803e-03
## 23 SBA000172 1251 0.008509973 0.54402601 5.298651e-03
## 24 WBA000124 1217 0.008278686 0.55230470 5.539499e-03
## 25 WBA000148 1171 0.007965770 0.56027047 5.780347e-03
## 26 DTA000016 1154 0.007850127 0.56812060 6.021195e-03
## 27 SBA000624 1040 0.007074637 0.57519523 6.262042e-03
## 28 SBA000747 973 0.006618868 0.58181410 6.502890e-03
## 29 SAP000004 952 0.006476014 0.58829011 6.743738e-03
## 30 WBA000018 943 0.006414791 0.59470491 6.984586e-03
## 31 SUB000443 927 0.006305951 0.60101086 7.225434e-03
## 32 SAN000178 862 0.005863786 0.60687464 7.466281e-03
## 33 SBA000834 861 0.005856983 0.61273163 7.707129e-03
## 34 SBA000317 843 0.005734538 0.61846616 7.947977e-03
## 35 SUB000426 840 0.005714130 0.62418029 8.188825e-03
## 36 SUB000523 776 0.005278768 0.62945906 8.429672e-03
## 37 SBA000458 774 0.005265163 0.63472423 8.670520e-03
## 38 WBA000103 762 0.005183532 0.63990776 8.911368e-03
## 39 SBA000464 750 0.005101902 0.64500966 9.152216e-03
## 40 SUB000442 743 0.005054284 0.65006394 9.393064e-03
## 41 SUB000533 739 0.005027074 0.65509102 9.633911e-03
## 42 DTA000011 736 0.005006666 0.66009768 9.874759e-03
## 43 DTA000023 717 0.004877418 0.66497510 1.011561e-02
## 44 SUB000002 716 0.004870616 0.66984572 1.035645e-02
## 45 SUB000479 714 0.004857011 0.67470273 1.059730e-02
## 46 SBA000812 700 0.004761775 0.67946450 1.083815e-02
## 47 DTA000048 669 0.004550897 0.68401540 1.107900e-02
## 48 DTA000024 655 0.004455661 0.68847106 1.131985e-02
## 49 APP000004 644 0.004380833 0.69285190 1.156069e-02
## 50 SBA000010 611 0.004156349 0.69700824 1.180154e-02
## 51 SBA000805 604 0.004108732 0.70111698 1.204239e-02
## 52 SBA000459 591 0.004020299 0.70513728 1.228324e-02
## 53 SBA000759 589 0.004006694 0.70914397 1.252408e-02
## 54 EXC000004 585 0.003979484 0.71312345 1.276493e-02
## 55 SBA000689 570 0.003877446 0.71700090 1.300578e-02
## 56 SBA000427 568 0.003863840 0.72086474 1.324663e-02
## 57 WBA000094 564 0.003836630 0.72470137 1.348748e-02
## 58 SBA000131 556 0.003782210 0.72848358 1.372832e-02
## 59 SBA000609 551 0.003748197 0.73223178 1.396917e-02
## 60 DTA000591 542 0.003686975 0.73591875 1.421002e-02
## 61 SBA000626 539 0.003666567 0.73958532 1.445087e-02
## 62 DTA000025 520 0.003537319 0.74312264 1.469171e-02
## 63 DTA000056 503 0.003421676 0.74654431 1.493256e-02
## 64 SBA000698 484 0.003292427 0.74983674 1.517341e-02
## 65 OVR000033 478 0.003251612 0.75308835 1.541426e-02
## 66 DTA000302 475 0.003231205 0.75631956 1.565511e-02
## 67 WBA000022 466 0.003169982 0.75948954 1.589595e-02
## 68 LAP001837 462 0.003142772 0.76263231 1.613680e-02
## 69 DTA000189 460 0.003129167 0.76576148 1.637765e-02
## 70 SUB000433 450 0.003061141 0.76882262 1.661850e-02
## 71 SUB000436 440 0.002993116 0.77181573 1.685934e-02
## 72 WBA000145 433 0.002945498 0.77476123 1.710019e-02
## 73 LAP000002 422 0.002870670 0.77763190 1.734104e-02
## 74 SBA000189 414 0.002816250 0.78044815 1.758189e-02
## 75 SBA000054 412 0.002802645 0.78325080 1.782274e-02
## 76 SBA000026 399 0.002714212 0.78596501 1.806358e-02
## 77 DTA000053 394 0.002680199 0.78864521 1.830443e-02
## 78 WBA000060 392 0.002666594 0.79131180 1.854528e-02
## 79 SAP000005 378 0.002571359 0.79388316 1.902697e-02
## 80 SBA000295 378 0.002571359 0.79645452 1.902697e-02
## 81 SBA000284 374 0.002544148 0.79899867 1.926782e-02Apparently, we only need around 2% of the levels to cover 80% of the data. Unfortunately, this corresponds to 81 different levels, which is still a lot. Let’s try focussing on a different categorical variable, e.g. ci_subtype. We can easily repeat the experiments above
by_subtype <- interaction_data %>%
group_by(ci_subtype) %>%
summarise(n = n()) %>%
arrange(desc(n)) %>%
mutate(perc = n / sum(n), cum_perc = cumsum(perc), rank = 1-percent_rank(n))
by_subtype %>% select(ci_subtype, n, cum_perc, rank)## Source: local data frame [67 x 4]
##
## ci_subtype n cum_perc rank
## 1 Server Based Application 48469 0.3297121 6.661338e-16
## 2 Web Based Application 39225 0.5965416 1.515152e-02
## 3 Desktop Application 24239 0.7614283 3.030303e-02
## 4 SAN 11675 0.8408479 4.545455e-02
## 5 Citrix 3836 0.8669424 6.060606e-02
## 6 Laptop 3604 0.8914587 7.575758e-02
## 7 System Software 1911 0.9044584 9.090909e-02
## 8 Banking Device 1894 0.9173424 1.060606e-01
## 9 Monitor 1662 0.9286482 1.212121e-01
## 10 Client Based Application 1648 0.9398588 1.363636e-01
## 11 Omgeving 1609 0.9508041 1.515152e-01
## 12 SAP 1552 0.9613616 1.666667e-01
## 13 Exchange 1017 0.9682798 1.818182e-01
## 14 Desktop 924 0.9745653 1.969697e-01
## 15 no subtype 777 0.9798509 2.121212e-01
## 16 Printer 358 0.9822862 2.272727e-01
## 17 Database 336 0.9845718 2.424242e-01
## 18 DataCenterEquipment 324 0.9867759 2.575758e-01
## 19 Scanner 300 0.9888166 2.727273e-01
## 20 Standard Application 221 0.9903200 2.878788e-01
## 21 Windows Server 215 0.9917825 3.030303e-01
## 22 MigratieDummy 203 0.9931635 3.181818e-01
## 23 Keyboard 183 0.9944083 3.333333e-01
## 24 Encryption 172 0.9955784 3.484848e-01
## 25 Controller 146 0.9965715 3.636364e-01
## 26 KVM Switches 97 0.9972314 3.787879e-01
## 27 Automation Software 60 0.9976395 3.939394e-01
## 28 Linux Server 58 0.9980341 4.090909e-01
## 29 Network Component 32 0.9982517 4.393939e-01
## 30 Switch 32 0.9984694 4.393939e-01
## 31 VDI 23 0.9986259 4.545455e-01
## 32 NonStop Server 18 0.9987483 4.848485e-01
## 33 zOS Cluster 18 0.9988708 4.848485e-01
## 34 Net Device 17 0.9989864 5.000000e-01
## 35 #N/B 16 0.9990953 5.303030e-01
## 36 SharePoint Farm 16 0.9992041 5.303030e-01
## 37 Lines 14 0.9992993 5.454545e-01
## 38 Modem 11 0.9993742 5.606061e-01
## 39 Router 10 0.9994422 5.909091e-01
## 40 X86 Server 10 0.9995102 5.909091e-01
## 41 ESX Cluster 8 0.9995646 6.212121e-01
## 42 Thin Client 8 0.9996191 6.212121e-01
## 43 VMWare 6 0.9996599 6.363636e-01
## 44 Database Software 5 0.9996939 6.666667e-01
## 45 Unix Server 5 0.9997279 6.666667e-01
## 46 MQ Queue Manager 4 0.9997551 6.969697e-01
## 47 zOS Server 4 0.9997823 6.969697e-01
## 48 Oracle Server 3 0.9998027 7.272727e-01
## 49 Sealbag Software 3 0.9998231 7.272727e-01
## 50 ESX Server 2 0.9998367 8.484848e-01
## 51 Firewall 2 0.9998503 8.484848e-01
## 52 Instance 2 0.9998639 8.484848e-01
## 53 NonStop Harddisk 2 0.9998776 8.484848e-01
## 54 Number 2 0.9998912 8.484848e-01
## 55 Protocol 2 0.9999048 8.484848e-01
## 56 Tape Library 2 0.9999184 8.484848e-01
## 57 zOS Systeem 2 0.9999320 8.484848e-01
## 58 Application Server 1 0.9999388 1.000000e+00
## 59 Iptelephony 1 0.9999456 1.000000e+00
## 60 Neoview Server 1 0.9999524 1.000000e+00
## 61 NonStop Storage 1 0.9999592 1.000000e+00
## 62 RAC Service 1 0.9999660 1.000000e+00
## 63 Security Software 1 0.9999728 1.000000e+00
## 64 Tablet 1 0.9999796 1.000000e+00
## 65 Trafic Stream 1 0.9999864 1.000000e+00
## 66 Virtual Tape Server 1 0.9999932 1.000000e+00
## 67 Windows Server in extern beheer 1 1.0000000 1.000000e+00Again, it appears that you don’t need 20% of the levels to cover 80% of the data, but only 4% or the first four levels already gives you 84% of the data. We could decide to do a first analysis of the interactions on this part of the data.
data_84 <- interaction_data %>%
filter(ci_subtype %in% c("Server Based Application", "Web Based Application", "Desktop Application", "SAN")) %>% do(droplevels(.))
summary(data_84)## ci_name ci_type ci_subtype
## SAN000182:10668 application :92052 Desktop Application :24239
## DTA000616: 7911 software : 1 SAN :11675
## WBA000133: 6897 storage :11675 Server Based Application:48469
## SUB000456: 6476 subapplication:19880 Web Based Application :39225
## DTA000057: 5708
## SBA000659: 4008
## (Other) :81940
## service_component interaction_id status impact
## WBS000073:32265 SD0000001: 1 Closed :123603 1: 2
## WBS000128:14130 SD0000002: 1 Open - Linked: 5 2: 377
## WBS000092: 7199 SD0000004: 1 3:13902
## WBS000094: 5908 SD0000005: 1 4:65934
## WBS000089: 5179 SD0000006: 1 5:43393
## WBS000219: 4096 SD0000007: 1
## (Other) :54831 (Other) :123602
## urgency priority category km_number
## 1: 21 1: 2 complaint : 58 KM0002125: 5727
## 2: 402 2: 394 incident :98361 KM0001935: 1768
## 3:13814 3:14044 problem : 2 KM0002126: 1698
## 4:65931 4:66508 request for change : 1 KM0001968: 1423
## 5:43440 5:42660 request for information:25142 KM0001625: 1413
## service request : 44 KM0000075: 1389
## (Other) :110190
## open_time close_time
## 20-1-2014 11:16 : 12 25-11-2013 12:02: 55
## 14-1-2014 9:07 : 10 28-1-2014 14:39 : 49
## 8-1-2014 10:51 : 10 18-10-2013 11:03: 42
## 18-11-2013 10:29: 9 8-10-2013 13:56 : 40
## 23-12-2013 10:25: 9 20-11-2013 15:49: 39
## 27-1-2014 11:53 : 9 28-1-2014 14:40 : 38
## (Other) :123549 (Other) :123345
## closure_code first_call_resolution
## Other :47174 N:43577
## Software :38596 Y:80031
## Referred : 8829
## User error : 7804
## No error - works as designed: 5141
## Unknown : 3478
## (Other) :12586
## handle_time related_incident
## Min. : 0.0 :80248
## 1st Qu.: 170.0 #MULTIVALUE: 678
## Median : 319.0 IM0031184 : 85
## Mean : 437.5 IM0016639 : 69
## 3rd Qu.: 555.0 IM0014444 : 54
## Max. :22530.0 IM0018109 : 47
## (Other) :42427Remarkable in the summary is the fact that there is only one observation left that relates to software. Out of curiosity, which one is this?
filter(data_84, ci_type=="software")## Source: local data frame [1 x 17]
##
## ci_name ci_type ci_subtype service_component
## 1 SBA000001 software Server Based Application WBS000224
## Variables not shown: interaction_id (fctr), status (fctr), impact (fctr),
## urgency (fctr), priority (fctr), category (fctr), km_number (fctr),
## open_time (fctr), close_time (fctr), closure_code (fctr),
## first_call_resolution (fctr), handle_time (int), related_incident (fctr)Possibly, this should have been application i.o. software?
Let us now focus on the handletime of the interactions. A first plot simply shows with boxplots how handletime relates to the priority of an interaction. (Note a higher priority number indicates a lower priority)
p <- ggplot(data_84, aes(x=priority, y = handle_time))
p + geom_boxplot()
We can now also see how they differ between the four subtypes in our data.
p + geom_boxplot(aes(fill=ci_subtype))
This plot is hard to read because of the extreme values. Let’s have a look how handle time is distributed in the data
ggplot(data_84) + stat_ecdf(aes(x=handle_time))
It appears that the majority of observations have a relative small handletime. Let’s investigate several quantile values
quantile(data_84$handle_time, probs = c(0.8,0.9, 0.95, 0.99))## 80% 90% 95% 99%
## 634 895 1184 2027With a handletime less than approximately 2000 for 99% of the data, we decide to continue with only the first 99% of the data.
data_84_bulk <- data_84 %>%
filter(handle_time < quantile(handle_time, probs = 0.99))
ggplot(data_84_bulk, aes(x=priority, y = handle_time)) + geom_boxplot(aes(fill=ci_subtype))
If we want more details, we could use dplyr to summarize the data a bit.
data_84_bulk %>%
group_by( ci_subtype, priority) %>%
summarise(avg_ht = mean(handle_time), perc_fc = mean(first_call_resolution=="Y"), n = n()) %>%
ggplot(aes(x=priority, y=avg_ht)) + geom_point(aes(size = perc_fc, colour = n)) + facet_grid(.~ ci_subtype)