Re: [R] How insert data to a column in existing csv file?

2012-04-12 Thread Yellow
Hi everyone, I read your messages and I tried some things out. The Data2 is filled with NA. So what I did was: NameFile.csv$Data2[is.na(NameFile.csv$Data2)] = log2Values And now it worked. :) Seems like I needed to replace it, and not only write it. Thanks. -- View this message in con

Re: [R] How insert data to a column in existing csv file?

2012-04-12 Thread jim holtman
: >> -Original Message- >> From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- >> project.org] On Behalf Of Yellow >> Sent: Thursday, April 12, 2012 2:18 AM >> To: r-help@r-project.org >> Subject: [R] How insert data to a column in existing csv file? >&

Re: [R] How insert data to a column in existing csv file?

2012-04-12 Thread Nordlund, Dan (DSHS/RDA)
> -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of Yellow > Sent: Thursday, April 12, 2012 2:18 AM > To: r-help@r-project.org > Subject: [R] How insert data to a column in existing csv file? > > I was

Re: [R] How insert data to a column in existing csv file?

2012-04-12 Thread David Winsemius
On Apr 12, 2012, at 5:18 AM, Yellow wrote: I was working with some excel files with a lot of data. And by hand it is impossible to handle them. So they are now converted to .csv. With headers above the columns, like: Data1, Data2, Data3 But now I needed to calculate the log2 value of Data1 an

Re: [R] How insert data to a column in existing csv file?

2012-04-12 Thread ramonovelar
Hi, You can use write.table with Append = TRUE to keep on writing in the same csv file, but I don't know how to write in an specific cell of your csv file. http://stat.ethz.ch/R-manual/R-devel/library/utils/html/write.table.html write.table (data, file = "example.csv", sep = ";", col.names = NA,

[R] How insert data to a column in existing csv file?

2012-04-12 Thread Yellow
I was working with some excel files with a lot of data. And by hand it is impossible to handle them. So they are now converted to .csv. With headers above the columns, like: Data1, Data2, Data3 But now I needed to calculate the log2 value of Data1 and place the result under Data2. I can't