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