Re: [R] For loop and sqldf

2011-05-06 Thread Gabor Grothendieck
On Fri, Apr 29, 2011 at 4:27 PM, mathijsdevaan wrote: > Hi list, > > Can anyone tell my why the following does not work? Thanks a lot! Your help > is very much appreciated. > > DF = data.frame(read.table(textConnection("    B  C  D  E  F  G > 8025  1995  0  4  1  2 > 8025  1997  1  1  3  4 > 8026

Re: [R] For loop and sqldf

2011-04-30 Thread mathijsdevaan
Great, thanks! Still need to figure out all these functions... ;) -- View this message in context: http://r.789695.n4.nabble.com/For-loop-and-sqldf-tp3484559p3484715.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org

Re: [R] For loop and sqldf

2011-04-29 Thread Jeff Newmiller
Putting SQL columns/variables into square brackets is valid syntax for sqlite. Expecting sqlite to share variables with R is not, so there was only one necessary change. --- Jeff Newmiller The . . Go Live... DCN: Basi

Re: [R] For loop and sqldf

2011-04-29 Thread David Winsemius
On Apr 29, 2011, at 4:27 PM, mathijsdevaan wrote: Hi list, Can anyone tell my why the following does not work? Thanks a lot! Your help is very much appreciated. DF = data.frame(read.table(textConnection("B C D E F G 8025 1995 0 4 1 2 8025 1997 1 1 3 4 8026 1995 0 7 0

Re: [R] For loop and sqldf

2011-04-29 Thread Dennis Murphy
Hi: Try split(DF, DF$C) Does that work? Dennis On Fri, Apr 29, 2011 at 1:27 PM, mathijsdevaan wrote: > Hi list, > > Can anyone tell my why the following does not work? Thanks a lot! Your help > is very much appreciated. > > DF = data.frame(read.table(textConnection("    B  C  D  E  F  G > 802