Microsoft EmployeeAssociation Rules
Hi
I wonder if you can advice that what Im trying to acheive is possible.
I wanted to transform my dataset to transactions using a simple R script below
library(arules)
dd = as(dataset, "transactions")
df = as.data.frame(as(dd, "matrix"))
However I got an error message beolow. Can you please help what this error actually mean and how to fix it?
DataSource.Error: ADO.NET: R script error.
Loading required package: Matrix
Attaching package: 'arules'
The following objects are masked from 'package:base':
abbreviate, write
Error: could not find function "as"
Execution halted
Details:
DataSourceKind=R
DataSourcePath=R
Message=R script error.
Loading required package: Matrix
Attaching package: 'arules'
The following objects are masked from 'package:base':
abbreviate, write
Error: could not find function "as"
Execution halted
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Radio.RScriptRuntimeException
Answered by own question!
library(arules)
library(methods)
data(dataset)
dd1=as(dataset,"transactions")
trans=dd1
AdultData=as.data.frame(as(dd1, "matrix"))
AdultData=cbind(id=1:nrow(AdultData),AdultData)
replace data(Adult) with data(dataset) and R does the rest!.. didnt have eyes for details there.