Skip to content

Instantly share code, notes, and snippets.

@gdbassett
Created January 28, 2015 14:11
Show Gist options
  • Save gdbassett/6438b4036a501eba9f5e to your computer and use it in GitHub Desktop.
Save gdbassett/6438b4036a501eba9f5e to your computer and use it in GitHub Desktop.
Association Rules Console Ouput 1
> df <- df[!names(df) %in% c('root.victim.region',
+ 'root.victim.country',
+ 'root.summary',
+ 'root.summary=Source_Category',
+ 'root.victim.industry',
+ 'root.timeline.incident.year',
+ 'root.plus.dbir_year',
+ 'root.action.social.notes',
+ 'root.victim.secondary.notes',
+ 'root.action.hacking.notes',
+ 'root.discovery_notes')]
> rules <- apriori(df)
Parameter specification:
confidence minval smax arem aval originalSupport support minlen maxlen target ext
0.8 0.1 1 none FALSE TRUE 0.1 1 10 rules FALSE
Algorithmic control:
filter tree heap memopt load sort verbose
0.1 TRUE TRUE FALSE TRUE 2 TRUE
apriori - find association rules with the apriori algorithm
version 4.21 (2004.05.09) (c) 1996-2004 Christian Borgelt
set item appearances ...[0 item(s)] done [0.00s].
set transactions ...[28015 item(s), 4785 transaction(s)] done [0.02s].
sorting and recoding items ... [33 item(s)] done [0.00s].
creating transaction tree ... done [0.00s].
checking subsets of size 1 2 3 4 done [0.00s].
writing ... [50 rule(s)] done [0.00s].
creating S4 object ... done [0.00s].
> rules <- sort(rules) # sort the rules by Support (what percentages of records fit the rules)
> inspect(rules)
lhs rhs support confidence lift
1 {root.attribute.confidentiality.data_victim=[u'Customer']} => {root.attribute.confidentiality.data_disclosure=Yes} 0.1803553 0.8035382 1.329046
2 {root.plus.f500=N} => {root.plus.asset.total=No} 0.1688610 0.9351852 4.400060
3 {root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1569488 1.0000000 5.973783
4 {root.victim.victim_id=United States Department of Veterans Affairs} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1569488 0.9375780 5.973783
5 {root.victim.victim_id=United States Department of Veterans Affairs} => {root.victim.employee_count=Over 100000} 0.1542320 0.9213483 5.102606
6 {root.victim.employee_count=Over 100000} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1542320 0.8541667 5.102606
7 {root.plus.attribute.confidentiality.credit_monitoring=U,
root.attribute.confidentiality.data_victim=[u'Customer']} => {root.attribute.confidentiality.data_disclosure=Yes} 0.1454545 0.8159437 1.349565
8 {root.attribute.confidentiality.data_disclosure=Yes,
root.attribute.confidentiality.data_victim=[u'Customer']} => {root.plus.attribute.confidentiality.credit_monitoring=U} 0.1454545 0.8064890 1.768584
9 {root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1437827 0.9161119 5.073606
10 {root.victim.victim_id=United States Department of Veterans Affairs,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1437827 0.9161119 5.073606
11 {root.victim.employee_count=Over 100000,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1437827 1.0000000 5.973783
12 {root.victim.victim_id=United States Department of Veterans Affairs,
root.victim.employee_count=Over 100000} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1437827 0.9322493 5.939831
13 {root.plus.attribute.confidentiality.data_abuse=U} => {root.plus.asset.total=No} 0.1423197 0.9784483 4.603614
14 {root.victim.victim_id=United States Department of Veterans Affairs} => {root.attribute.confidentiality.data_disclosure=Yes} 0.1339603 0.8002497 1.323607
15 {root.action.hacking.vector=[u'Web application']} => {root.asset.assets.variety=S - Web application} 0.1270637 0.8283379 4.657575
16 {root.attribute.confidentiality.data_disclosure=Yes,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1235110 1.0000000 5.973783
17 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_disclosure=Yes} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1235110 0.9219969 5.874507
18 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_disclosure=Yes} => {root.victim.employee_count=Over 100000} 0.1214211 0.9063963 5.019799
19 {root.attribute.confidentiality.data_disclosure=Yes,
root.victim.employee_count=Over 100000} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1214211 0.8723724 5.211363
20 {root.plus.timeline.notification.year=2012} => {root.plus.asset.total=No} 0.1199582 0.8541667 4.018867
21 {root.plus.attribute.confidentiality.data_abuse=U} => {root.plus.f500=N} 0.1197492 0.8232759 4.559462
22 {root.action.physical.variety=[u'Theft']} => {root.attribute.availability.variety=[u'Loss']} 0.1184953 0.9982394 3.674289
23 {root.plus.f500=N,
root.plus.attribute.confidentiality.data_abuse=U} => {root.plus.asset.total=No} 0.1168234 0.9755672 4.590058
24 {root.plus.attribute.confidentiality.data_abuse=U,
root.plus.asset.total=No} => {root.plus.f500=N} 0.1168234 0.8208517 4.546036
25 {root.plus.f500=N,
root.attribute.confidentiality.data_disclosure=Yes} => {root.plus.asset.total=No} 0.1161964 0.9619377 4.525931
26 {root.attribute.confidentiality.data_total=1} => {root.victim.employee_count=Over 100000} 0.1120167 0.8467615 4.689530
27 {root.attribute.confidentiality.data_disclosure=Yes,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1109718 0.8984772 4.975941
28 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_disclosure=Yes,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1109718 0.8984772 4.975941
29 {root.attribute.confidentiality.data_disclosure=Yes,
root.victim.employee_count=Over 100000,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1109718 1.0000000 5.973783
30 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_disclosure=Yes,
root.victim.employee_count=Over 100000} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1109718 0.9139415 5.823182
31 {root.attribute.confidentiality.data_total=1} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1107628 0.8372828 5.001745
32 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_total=1} => {root.victim.employee_count=Over 100000} 0.1107628 1.0000000 5.538194
33 {root.victim.employee_count=Over 100000,
root.attribute.confidentiality.data_total=1} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1107628 0.9888060 5.906912
34 {root.attribute.confidentiality.data_total=1} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1099269 0.8309637 5.294489
35 {root.attribute.confidentiality.data_total=1,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1099269 1.0000000 5.973783
36 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_total=1} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1099269 0.9924528 6.323418
37 {root.attribute.confidentiality.data_total=1,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1099269 1.0000000 5.538194
38 {root.victim.employee_count=Over 100000,
root.attribute.confidentiality.data_total=1} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1099269 0.9813433 6.252633
39 {root.victim.victim_id=United States Department of Veterans Affairs,
root.attribute.confidentiality.data_total=1,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.employee_count=Over 100000} 0.1099269 1.0000000 5.538194
40 {root.victim.employee_count=Over 100000,
root.attribute.confidentiality.data_total=1,
root.reference=http://vcdb.org/pdf/va-security.pdf} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1099269 1.0000000 5.973783
41 {root.victim.victim_id=United States Department of Veterans Affairs,
root.victim.employee_count=Over 100000,
root.attribute.confidentiality.data_total=1} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1099269 0.9924528 6.323418
42 {root.plus.attribute.confidentiality.credit_monitoring=U,
root.plus.f500=N} => {root.plus.asset.total=No} 0.1086729 0.9683426 4.556066
43 {root.asset.assets.variety=S - Database} => {root.attribute.confidentiality.data_disclosure=Yes} 0.1061651 0.8834783 1.461266
44 {root.plus.f500=N,
root.plus.timeline.notification.year=2012} => {root.plus.asset.total=No} 0.1040752 0.9669903 4.549704
45 {root.plus.timeline.notification.year=2012,
root.plus.asset.total=No} => {root.plus.f500=N} 0.1040752 0.8675958 4.804914
46 {root.attribute.confidentiality.data_victim=[u'Patient']} => {root.plus.attribute.confidentiality.credit_monitoring=U} 0.1038662 0.8539519 1.872667
47 {root.reference=http://vcdb.org/pdf/va-security.pdf,
root.action.error.vector=[u'Carelessness']} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1005225 1.0000000 5.973783
48 {root.victim.victim_id=United States Department of Veterans Affairs,
root.action.error.vector=[u'Carelessness']} => {root.reference=http://vcdb.org/pdf/va-security.pdf} 0.1005225 0.9285714 5.916397
49 {root.victim.victim_id=United States Department of Veterans Affairs,
root.action.error.vector=[u'Carelessness']} => {root.victim.employee_count=Over 100000} 0.1001045 0.9247104 5.121226
50 {root.victim.employee_count=Over 100000,
root.action.error.vector=[u'Carelessness']} => {root.victim.victim_id=United States Department of Veterans Affairs} 0.1001045 0.9937759 5.936602
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment