I would split dat$string into it's own vector, break it apart at the spaces into an array, and then place dat$year and dat$sex in positions 1 and 2 of that newly created array.
On Fri, Jul 19, 2024, 12:52 PM Val <valkr...@gmail.com> wrote: > Hi All, > > I want to extract new variables from a string and add it to the dataframe. > Sample data is csv file. > > dat<-read.csv(text="Year, Sex,string > 2002,F,15 xc Ab > 2003,F,14 > 2004,M,18 xb 25 35 21 > 2005,M,13 25 > 2006,M,14 ac 256 AV 35 > 2007,F,11",header=TRUE) > > The string column has a maximum of five variables. Some rows have all > and others may not have all the five variables. If missing then fill > it with NA, > Desired result is shown below, > > > Year,Sex,string, S1, S2, S3 S4,S5 > 2002,F,15 xc Ab, 15,xc,Ab, NA, NA > 2003,F,14, 14,NA,NA,NA,NA > 2004,M,18 xb 25 35 21,18, xb, 25, 35, 21 > 2005,M,13 25,13, 25,NA,NA,NA > 2006,M,14 ac 256 AV 35, 14, ac, 256, AV, 35 > 2007,F,11, 11,NA,NA,NA,NA > > Any help? > Thank you in advance. > > ______________________________________________ > 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. > [[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.
