[R] Extract

[Val]

Thank you Jeff and Bert for your help!
The components of the string  could be nixed (i.e,  numeric, character
or date). Once that is splitted it would be easy for me to format it
accordingly.

On Fri, Jul 19, 2024 at 2:10 PM Bert Gunter <bgunter.4567 using gmail.com> wrote:
>
> I did not look closely at the solutions that you were offered, but
> note that you did not specify in your post whether the numbers in your
> string were to be character or numeric variables after they are broken
> out into their own columns. I believe that they are character in the
> solutions, but you should check this. If you want them as numeric,
> e.g., for further processing, you will need to convert them. Or
> vice-versa.
>
> Bert
>
>
> On Fri, Jul 19, 2024 at 9:52 AM Val <valkremk using 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 using 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.