Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
271 views
in Technique[技术] by (71.8m points)

dataframe - Association rule - Changing table structure in R

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...