Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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

?
Labels (3)
A banner prompting to get Dataiku