Re: [R] Combining CSV data

2013-06-17 Thread arun
Comment 2, Comment 3  Comment 1  Comment 2 Comment 3 #2  Comment 1a, Comment 2a Comment 1a Comment 2a  A.K. ____ From: Shreya Rawal To: arun Cc: R mailing list ; jim holtman Sent: Monday, June 17, 2013 9:55 AM Subject: Re: [R] Combining CSV data Hi Arun, Sorry to bother y

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

Re: [R] Combining CSV data

2013-06-12 Thread Shreya Rawal
> > > > From: Shreya Rawal > To: arun > Cc: R help ; jim holtman > Sent: Wednesday, June 12, 2013 8:58 AM > Subject: Re: [R] Combining CSV data > > > > Great, thanks Arun, but I seem to be running into this error. Not sur

Re: [R] Combining CSV data

2013-06-12 Thread arun
is is comment 2 This is comment 3 #2    A.K. From: Shreya Rawal To: arun Cc: R help ; jim holtman Sent: Wednesday, June 12, 2013 8:58 AM Subject: Re: [R] Combining CSV data Great, thanks Arun, but I seem to be running into this error.

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-11 Thread arun
reya Rawal To: arun Sent: Tuesday, June 11, 2013 4:22 PM Subject: Re: [R] Combining CSV data Hey Arun, I guess you could guide me with this a little bit. I have been working on the solution Jim suggested (and also because that I could understand it with my little knowledge of R :)) So with thes

Re: [R] Combining CSV data

2013-06-11 Thread arun
  dd   ee   ff This is comment 1  # DataComment2  DataComment3 #1 This is comment 2 This is comment 3 #2 This is comment 2  Otherwise, you need to provide an example that matches the real dataset. A.K. ____________ From: Shreya Rawal T

Re: [R] Combining CSV data

2013-06-11 Thread Shreya Rawal
b cc This is > comment 1 > #2 2 dd ee ff > > # DataComment2 DataComment3 > #1 This is comment 2 This is comment 3 > #2 This is comment 2 This is comment 3 > > > A.K. > > > - Original

Re: [R] Combining CSV data

2013-06-11 Thread Shreya Rawal
Hi Jim, Thanks for you reply. Your solution works well for most of if the part except that in the end its creating one column for all the comments and in the result the comments needs to be in a separate column like DataComment1, DataComment2 and so on. Is there an option with which I can further

Re: [R] Combining CSV data

2013-06-10 Thread arun
  ff  #   DataComment2  DataComment3 #1 This is comment 2 This is comment 3 #2 This is comment 2 This is comment 3 A.K. - Original Message - From: arun To: Shreya Rawal Cc: R help Sent: Monday, June 10, 2013 6:41 PM Subject: Re: [R] Combining CSV data Hi, T

Re: [R] Combining CSV data

2013-06-10 Thread arun
    A.K. - Original Message ----- From: Shreya Rawal To: r-help@r-project.org Cc: Sent: Monday, June 10, 2013 4:38 PM Subject: [R] Combining CSV data Hello R community, I am trying to combine two CSV files that look like this: File A Row_ID_CR,  Data1,    Data2,    Data3 1

Re: [R] Combining CSV data

2013-06-10 Thread jim holtman
try this: > fileA <- read.csv(text = "Row_ID_CR, Data1,Data2,Data3 + 1, aa, bb, cc + 2, dd, ee, ff", as.is = TRUE) > > fileB <- read.csv(text = "Row_ID_N, Src_Row_ID, DataN1 + 1a, 1,

[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,