Writing rules generated by Apriori

Question

I'm working with some large transactions data. I've been using read.transactions and apriori (parts of the arules package) to mine for frequent item pairings.

My problem is this: when rules are generated (using "inspect()") I can easily view them in the R console. Right now I'm manually copying the results into a text file, then saving and opening in excel. I'd like to just save the generated rules using write.csv, or something similar, but when I try, I receive an error that the data cannot be coerced into data.frame.

Does anyone have experience doing this successfully in R?

score 36 · Accepted Answer · answered Jun 05 '13 at 19:33

I know I'm answering my own question, but I found out that the solution is to use as() to convert the rules into a data frame. [I'm new to R, so I missed this my first time searching for a solution.] From there, it can easily be manipulated in any way you'd like (sub setting, sorting, exporting, etc.).

> mba = read.transactions(file="Book2.csv",rm.duplicates=FALSE, format="single", sep=",",cols=c(1,2));

> rules_1 <- apriori(mba,parameter = list(sup = 0.001, conf = 0.01, target="rules"));

> as(rules_1, "data.frame");

score 6 · Answer 2 · answered Oct 03 '17 at 15:21

6

Another way to achieve that would be:

write(rules_1,
      file = "association_rules.csv",
      sep = ",",
      quote = TRUE,
      row.names = FALSE)

answered Oct 03 '17 at 15:21

RDRR

860
13
16

2

This is a much better solution than the one above as the as function can lead to errors using Rscript. Furthermore, it uses the write function of the package. – scs Oct 05 '18 at 19:08

score 0 · Answer 3 · edited Jan 25 '21 at 09:03

0

I found this post when struggling with writing my rules to excel. My solution is:

library(writexl)

write_xlsx(as(rules_1, "data.frame"), "rules_1.xlsx")

It is much easier to read and report when it is in excel.

edited Jan 25 '21 at 09:03

juliomalves

42,130
20
150
146

answered Jan 24 '21 at 22:06

Ipek DK

115
1
9

Writing rules generated by Apriori

3 Answers3

Linked