Hello, I write most of my R code in excel and then paste it into R. I am wondering if there is a limit to how much I can paste? I want to paste about 19,000 lines of code should this work? I am doing this because when I did it chunks it took about an hour and half. I thought if I could insert it all and leave it for that long that would be better time management. I am still waiting for 19,000 paste to process. Any thoughts or suggestions? Thanks, Michael [[alternative HTML version deleted]]
Nothing except: Nothing exceeds like excel. url: www.econ.uiuc.edu/~roger Roger Koenker email rkoenker at uiuc.edu Department of Economics vox: 217-333-4558 University of Illinois fax: 217-244-6678 Champaign, IL 61820 On Oct 14, 2008, at 1:02 PM, Michael Just wrote:> Hello, > I write most of my R code in excel and then paste it into R. I am > wondering > if there is a limit to how much I can paste? I want to paste about > 19,000 > lines of code should this work? I am doing this because when I did > it chunks > it took about an hour and half. I thought if I could insert it all > and leave > it for that long that would be better time management. I am still > waiting > for 19,000 paste to process. Any thoughts or suggestions? > > Thanks, > Michael > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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.
Michael Just wrote:> Hello, > I write most of my R code in excel and then paste it into R.Do you actually use Excel as a text editor? Is this common? What benefits do you get by writing code in Excel?
"Michael Just" <mgjust at gmail.com> wrote:> I write most of my R code in excel and then paste it into R. I am wondering > if there is a limit to how much I can paste? I want to paste about 19,000 > lines of code should this work? I am doing this because when I did it chunks > it took about an hour and half. I thought if I could insert it all and leave > it for that long that would be better time management. I am still waiting > for 19,000 paste to process. Any thoughts or suggestions?Write your code in a text editor and include it with the "source" function. -- Mike Prager, NOAA, Beaufort, NC * Opinions expressed are personal and not represented otherwise. * Any use of tradenames does not constitute a NOAA endorsement.
Michael Just wrote:> Hello, > I write most of my R code in excel and then paste it into R. I am wondering > if there is a limit to how much I can paste? I want to paste about 19,000 > lines of code should this work? I am doing this because when I did it chunks > it took about an hour and half. I thought if I could insert it all and leave > it for that long that would be better time management. I am still waiting > for 19,000 paste to process. Any thoughts or suggestions? > > Thanks, > Michael > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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. >Hi, For windows I use the Tinn-R text editor that integrates nicely with R. For linux I use Kate (standard KDE text editor). 19000 lines of code, pfieuw, that is a lot of code....you could export the lines to a text file and load them into R using source(). cheers, Paul -- Drs. Paul Hiemstra Department of Physical Geography Faculty of Geosciences University of Utrecht Heidelberglaan 2 P.O. Box 80.115 3508 TC Utrecht Phone: +31302535773 Fax: +31302531145 http://intamap.geo.uu.nl/~paul