[R] Combining CSV data

2013-06-10 Thread Shreya Rawal
Hello R community, I am trying to combine two CSV files that look like this: File A Row_ID_CR, Data1,Data2,Data3 1, aa, bb, cc 2, dd, ee, ff File B Row_ID_N, Src_Row_ID, DataN1 1a, 1,

Re: [R] Combining CSV data

2013-06-11 Thread Shreya Rawal
cc This is > comment 1, This is comment 2, This is comment 3 > 2 2dd ee ff > This is comment 1 > > > > > > On Mon, Jun 10, 2013 at 4:38 PM, Shreya Rawal wrote: > >> Hello R communi

Re: [R] Combining CSV data

2013-06-11 Thread Shreya Rawal
ff > > # DataComment2 DataComment3 > #1 This is comment 2 This is comment 3 > #2 This is comment 2 > fun1(dat1,dat3) > # Row_ID_CRData1Data2Data3 > DataComment1 > #1 1 aa b

Re: [R] Combining CSV data

2013-06-12 Thread Shreya Rawal
> > HI, > You could use: > result3<- > data.frame(result2[,-5],read.table(text=as.character(result2$comment),sep="|",fill=TRUE,na.strings=""),stringsAsFactors=FALSE) > colnames(result3)[5:7]<- paste0("DataComment",1:3) > A.K. > _

Re: [R] Combining CSV data

2013-06-12 Thread Shreya Rawal
aa bb cc This is > comment 1 > #2 2dd ee ff This is > comment 1 > # DataComment2 DataComment3 > #1 This is comment 2 This is comment 3 > #2 > > > > A.K.

Re: [R] Combining CSV data

2013-06-17 Thread Shreya Rawal
> Arun > > > > > > > ________ > From: Shreya Rawal > To: arun > Cc: R help > Sent: Wednesday, June 12, 2013 9:15 AM > Subject: Re: [R] Combining CSV data > > > > Ah that makes sense. This looks perfect now. Thanks for your help on thi