Converting csv data into transactions for arules and market basket analysis

Question

I am a beginner to R and I would really appreciate all help. I have some data, which I cleaned, removed duplicates,etc. Now, I have this data in a csv file, my main issue is that I am not able to convert it into transactions. I am only able to convert them into lists, but not as transactions.

Please let me know how I can change this data to

This data (like as transactions)

Please help, TIA!!

http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example — Rentrop, Feb 19 '17 at 17:58
Look at the manual page of read.transactions using `? read.transactions`. There is an example that does exactly what you want. — Michael Hahsler, Feb 20 '17 at 15:05

Zeeshan · Answer 1 · 2017-11-22T19:09:10.760

To convert csv file into transaction file use this code. suppose tfile is the name of csv file

colnames = names(tfile)

bas_str = ""

for(row in 1:nrow(x)){ 


    if(row !=1){                          
            bas_str = paste0( bas_str, "\n")}
    bas_str = paste0(bas_str,row,",")     
    for(col in 2:length(colnames)){      
           if(col != 2){                       
                  bas_str = paste0(bas_str,",")}
    bas_str = paste0(bas_str,colnames[col],"=",tfile[row,col])}}

Converting csv data into transactions for arules and market basket analysis

1 Answers1