For loop and sqldf
Hi: Try split(DF, DF$C) Does that work? Dennis
On Fri, Apr 29, 2011 at 1:27 PM, mathijsdevaan <mathijsdevaan at gmail.com> 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 ?0
8026 ?1996 ?1 ?2 ?3 ?0
8026 ?1997 ?1 ?2 ?3 ?1
8026 ?1998 ?6 ?0 ?0 ?4
8026 ?1999 ?3 ?7 ?0 ?3
8027 ?1997 ?1 ?2 ?3 ?9
8027 ?1998 ?1 ?2 ?3 ?1
8027 ?1999 ?6 ?0 ?0 ?2
8028 ?1999 ?3 ?7 ?0 ?0
8029 ?1995 ?0 ?2 ?3 ?3
8029 ?1998 ?1 ?2 ?3 ?2
8029 ?1999 ?6 ?0 ?0 ?1"),head=TRUE,stringsAsFactors=FALSE))
list<-sort(unique(DF$C))
for (t in 1:length(list))
? ? ? ?{
? ? ? ?year = as.character(list[t])
? ? ? ?data[year]<-sqldf('select * from DF where C = [year]')
? ? ? ?}
I am trying to split up the data.frame into 5 new ones, one for every year.
--
View this message in context: http://r.789695.n4.nabble.com/For-loop-and-sqldf-tp3484559p3484559.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________ 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.