dataframe - Association rule - Changing table structure in R

Question

I want to run association analysis in R. Dataset header in csv looks like

col1, col2, col3, basket_id, article_name
xxx, xxx,  xxx, 10000, name1
xxx, xxx,  xxx, 10000, name2
xxx, xxx,  xxx, 10000, name3
xxx, xxx,  xxx, 10001, name4
xxx, xxx,  xxx, 10001, name5

but i want it to be like'

xxx, xxx,  xxx, 10000, name1, name2, name3
xxx, xxx,  xxx, 10001, name4, name5

I started doing it this way, by iterating through rows, but maybe there is an easier way...

# read csv
dataset=read.csv('data.csv',sep = ';')

# created empty data frame
df <- data.frame(matrix(ncol = 4, nrow = 0))
x <- c("channel", "date", "article_id","basket_id")
colnames(df) <- x

basket_id=0
for(i in 1:nrow(dataset)) {
  row <- dataset[i,]
  
  
  if(row[4]!=basket_id){ # the same basket id
    df<-rbind(dataset,c(row[1],row[2],row[3],row[4]))
  }
  else{ # new basket id
   # d
  }
  break
}

Please if you know some package in R or library doing this thing help

question from:https://stackoverflow.com/questions/65682026/association-rule-changing-table-structure-in-r

Answer 1

Waitting for answers