HI all,
DF <- read.table(textConnection(" X1 X2 X3 TIME
Alex1 0 0 1960
Alexa 0 0 1920
Abbot 0 0 0
Smith Alex1 Alexa 2012
Carla Alex1 0 1996
Jacky Smith Abbot 2013
Jack 0 Jacky 2014
Almo Jack Carla 2015 "),header = TRUE)
I want to add the time variable as prefix to the first column (X1)
and I did it as follow,
DF$X4 <- as.character(paste(DF$TIME,DF$X1 ,sep="_"))
DF
All names in column two (X1) and three (X3) are in column one. so I just
want bring that prefix to column three and two, as well but I could not do
that one.
Here is the final output that I would like to have.
X1 X2 X3
1960_Alex 0 0
1920_Alexa 0 0
0_Abbot 0 0
2012_Smith 1960_Alex 1920_Alexa
1996_Carla 1960_Alex 0
2013_Jacky 2012_Smith 0_Abbot
2014_Jack 0 2013_Jacky
2015_Almo 2014_Jack 1996_Carla
Your help is appreciated in advance
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
