Gather the values of certain columns into one column

Asked Aug 17 '19 at 15:13

Active Aug 17 '19 at 15:13

Viewed 19 times

I want to convert the values of the second and third columns of the dataframe below to one column with 6 rows.

fi<-c("a","b","c")
se<-c("d","e","f")
th<-c("g","h","1")
daf<-data.frame(fi,se,th)

Im trying something like:

for(i in 1:nrow(fi)){
  First <- data.frame(t(daf[i,-1]))
}

asked Aug 17 '19 at 15:13

firmo23

1

Do you need `tidyr::gather(daf, key, value, -1)` ? – Ronak Shah Aug 17 '19 at 15:15
yes that would do the job – firmo23 Aug 17 '19 at 15:19
1

Great. Actually, this has been asked before and I have marked it as duplicate. Hope that is fine and it also shows different ways to solve the same problem. – Ronak Shah Aug 17 '19 at 15:28
I get :attributes are not identical across measure variables; they will be dropped as warning message – firmo23 Aug 18 '19 at 19:59
And as a result many empty cells – firmo23 Aug 18 '19 at 20:31
1

That warning message can be removed if you create your dataframe by doing `daf<-data.frame(fi,se,th, stringsAsFactors = FALSE)`. Also I don't see any empty cells in example you shared. – Ronak Shah Aug 19 '19 at 00:48

0 Answers0