Skip to content

concatenating 2 text columns in a data.frame

3 messages · Shaun Grannis, Dimitris Rizopoulos, Philipp Pagel

Shaun Grannis
# 
Hi,

I'm trying to concatenate values from two columns in a data frame. For 
example, I have the following data.frame:

C1  C2  C3  C4  C5
 A   B   *F   C*   Q
 G   H   *I   J*   T
 K   D   *R   S*   E
 P   L   *M   N*   O

I'd like to concatenate text from columns C3 and C4, to yield either a 
list or vector, like so:

NewCol
  FC
  IJ
  RS
  MN

Is this feasible in R?

Thanks!
Dimitris Rizopoulos
# 
yes, try this:

dat <- read.table(textConnection(
"C1  C2  C3  C4  C5
A   B   F   C   Q
G   H   I   J   T
K   D   R   S   E
P   L   M   N   O"
), header = TRUE)
closeAllConnections()

dat$NewCol <- do.call(paste, c(dat[c("C3", "C4")], sep = ""))
dat


I hope it helps.

Best,
Dimitris
Shaun Grannis wrote:

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Philipp Pagel
    

    

      
      #
    

  


  

      
On Mon, Feb 02, 2009 at 09:44:28AM -0500, Shaun Grannis wrote:

            

      
      
      
    

        
assuming your data frame is named foo:

foo$NewCol <- paste(foo$C3, foo$C4, sep='')

cu
	Philipp