I would suggest using the XLConnect package so that you can read/write the Excel files directly. You can read in the files to a dataframe, make your transformations and then write the result back out to the Excel file.
On Thu, Apr 12, 2012 at 11:29 AM, Nordlund, Dan (DSHS/RDA) <nord...@dshs.wa.gov> wrote: >> -----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 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 find how to do that. >> Does anyone else know? >> >> I have the log2 values, but how do I get then inside the .csv file >> under >> Data2? >> >> I already tried write.table(), buy that wasn't it. >> And I am kinda stuck on this now..... >> >> > > In the absence of a reproducible example, we can only guess. My guess is > that you should read the csv file into a data frame, add or modify your > variable(s), then write out a new csv file. > > > Dan > > Daniel J. Nordlund > Washington State Department of Social and Health Services > Planning, Performance, and Accountability > Research and Data Analysis Division > Olympia, WA 98504-5204 > > > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
