Association 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.
Hi,
I have a table with 2 Columns ID and Product.
I want to Edit the Script in R, but I can't get it to work
How should it be the read.transactions statement?
> txn <- read.transactions(dataset, rm.duplicates= TRUE,format='basket',sep='','',cols =1)
But I get this error...
Error in readLines(file, encoding = encoding) : 'con' is not a connection
Hi,
The function "read.transactions" reads a transaction data file from disk and creates a transactions object. The error you get indicates that R could not open the file for reading.
1) Save your excel as CSV for example to : "c:\\Users\\someone\\Downloads\\try.csv
2) Run
txn <- read.transactions("c:\\Users\\boefraty\\Downloads\\try.csv", rm.duplicates= TRUE,format='single', sep='','',cols =c(2,1))Beside this, you should make sure that your data is a transaction object: to store a binary incidence matrix, item labels, and optionally transaction IDs and user IDs. Check your format is "single" or "basket"
You are welcome to continue and discuss this example with me via email: [email protected] or hereThe data with 2 columns: "TransactionID" and "Product" is indeed very natural. Attached is the PBIX with R code suited to such input.
The relevant data transformation is in lines
nnn = names(dataset)
transData <- as(split(dataset[,nnn[2]], dataset[,nnn[1]]), "transactions")
The data in PBIX is synthetic.
Hi,
I'm trying to use the R script to create association rules for transaction ID and item reference in PBI. I used the script you have in the example but it didn't seem to work. any idea why?
Thanks
