[R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread D. Alain
Dear R-List, I have a dataframe with one column name.of.report containing character values, e.g. df$name.of.report jeff_2001_teamx teamy_jeff_2002 robert_2002_teamz mary_2002_teamz 2003_mary_teamy ... (i.e. the bit of interest is not always at same position) Now I want to recode the column

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread Marc Schwartz
On Feb 4, 2011, at 6:32 AM, D. Alain wrote: Dear R-List, I have a dataframe with one column name.of.report containing character values, e.g. df$name.of.report jeff_2001_teamx teamy_jeff_2002 robert_2002_teamz mary_2002_teamz 2003_mary_teamy ... (i.e. the bit of interest is

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread Marc Schwartz
Do you mean something like: with(DF.new, paste(person, year, paste(team, team, sep = ), sep = _)) [1] jeff_2001_teamx jeff_2002_teamy robert_2002_teamz [4] mary_2002_teamz mary_2003_teamy ? See ?paste and ?with for more information, if so. HTH, Marc On Feb 4, 2011, at 7:26 AM, Denis

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread Denis Kazakiewicz
Dear R people Could you please help I have similar but opposite question How to reshape data from DF.new to DF from example, Mark kindly provided? Thank you Denis On Пят, 2011-02-04 at 07:09 -0600, Marc Schwartz wrote: On Feb 4, 2011, at 6:32 AM, D. Alain wrote: Dear R-List, I have

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread David Winsemius
On Feb 4, 2011, at 8:26 AM, Denis Kazakiewicz wrote: Dear R people Could you please help I have similar but opposite question How to reshape data from DF.new to DF from example, Mark kindly provided? Well, I don't think you want a random order, right? If what you are asking is for a

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread Greg Snow
So you want to combine multiple columns back into a single column with the strings pasted together? If that is correct then look at the paste and sprintf functions (use one or the other, not both). -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare

Re: [R] recode according to specific sequence of characters within a string variable

2011-02-04 Thread Greg Snow
You can do this with regular expressions, since you want to extract specific values from the string I would suggest learning about the gsubfn package, it is a bit easier with gsubfn than with the other matching tools. -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain