#Repeating a column in a data set

Question

I have a data set of this form:

ID   child1  child2  child3
1     ADE      SOLA     BIMPE
2    TUNDE     BYRA     FUNMY

And I want this output

1D   child
 1   ADE
 1   SOLA
 1   BIMPE
 2   TUNDE
2    BYRA
2    FUNMY

Please how do I write a code in R to obtain that output

what did you try? Or think that might work? – s_baldur Jul 26 '18 at 10:39 — s_baldur, Jul 26 '18 at 10:39

score 0 · Answer 1 · answered Jul 26 '18 at 10:41

0

Have a look at the reshape2 package with melt

answered Jul 26 '18 at 10:41

Martin

312
2
15

score 0 · Answer 2 · answered Jul 26 '18 at 10:43

data <- data.frame( 
  ID = 1:2, 
  child1 = c("ADE", "TUNDE"), 
  child2 = c("SOLA", "BYRA"), 
  child3 = c("BIMPE", "FUNMY"),
  stringsAsFactors = FALSE
)

melt(data, id.vars = "ID", value.name = "child")
  ID variable child
1  1   child1   ADE
2  2   child1 TUNDE
3  1   child2  SOLA
4  2   child2  BYRA
5  1   child3 BIMPE
6  2   child3 FUNMY

#Repeating a column in a data set

2 Answers2