New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Getting an error with arules package

UserBird
Dataiker
Dataiker
Getting an error with arules package

[2017/08/11-20:50:27.790] [Exec-35] [INFO] [dku.utils] - [1] "********** R code failed **********"
[2017/08/11-20:50:27.791] [Exec-35] [INFO] [dku.utils] - [1] "Error evaluating R code: Error in `[.data.frame`(df, i): undefined columns selected\n"
[2017/08/11-20:50:27.854] [FRT-33-FlowRunnable] [INFO] [com.dataiku.dip.dataflow.exec.r.RRecipeRunner] - Error file found, trying to throw it: /home/phani/dataiku-dss-4.0.5/DATA_DIR/jobs/SNAPFISHMARKETBASKET/Build_associations_2017-08-11T15-20-22.942/compute_associations_NP/out-R-EhYvSTHve8dj/error.json
[2017/08/11-20:50:27.864] [FRT-33-FlowRunnable] [INFO] [dku.flow.activity] - Run thread failed for activity compute_associations_NP
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError : undefined columns selected
at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:304)
at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:231)
at com.dataiku.dip.recipes.code.r.AbstractRRecipeRunner.executeScript(AbstractRRecipeRunner.java:31)
at com.dataiku.dip.dataflow.exec.r.RRecipeRunner.run(RRecipeRunner.java:36)
at com.dataiku.dip.dataflow.jobrunner.ActivityRunner$FlowRunnableThread.run(ActivityRunner.java:353)
[2017/08/11-20:50:27.927] [ActivityExecutor-28] [INFO] [dku.flow.activity] running compute_associations_NP - activity is finished
[2017/08/11-20:50:27.927] [ActivityExecutor-28] [ERROR] [dku.flow.activity] running compute_associations_NP - Activity failed
com.dataiku.common.server.APIError$SerializedErrorException: Error in R process: simpleError : undefined columns selected
at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:304)
at com.dataiku.dip.dataflow.exec.AbstractCodeBasedActivityRunner.execute(AbstractCodeBasedActivityRunner.java:231)
at com.dataiku.dip.recipes.code.r.AbstractRRecipeRunner.executeScript(AbstractRRecipeRunner.java:31)
at com.dataiku.dip.dataflow.exec.r.RRecipeRunner.run(RRecipeRunner.java:36)
at com.dataiku.dip.dataflow.jobrunner.ActivityRunner$FlowRunnableThread.run(ActivityRunner.java:353)


------------------------------



Following is the code:




library(dataiku)
library(arules)

# Recipe inputs
user_Categories <- dkuReadDataset("User_Categories", samplingMethod="head", nbRows=1)

user_Categories <- as(
split(as.vector(user_Categories$product_category), as.vector(user_Categories$account_id)),
"transactions"
)

rules <- apriori(
user_Categories,
parameter=list(supp=0.02, conf=0.8, target="rules", minlen=2, maxlen=2)
)

rules <- sort(rules, by="lift")


# Recipe outputs
dkuWriteDataset(as(rules,"data.frame"),"associations")


 



 



 

0 Kudos
0 Replies
Labels (3)
A banner prompting to get Dataiku DSS