I need some help with sub-setting my data. I am trying to divide a data frame
into multiple data frames based on the year collected, and stored in a list with
each new data frame labeled with "year X" where X is the year the data
was collected. When I run my current code I get nine error messages stating
"In one_year[name] <- myear : number of items to replace is not a
multiple of replacement length"What I have so far is:
Below is my code, the data frame mydat, and what I would like the final product
to look like. I would appreciate any help or suggestions on what I am doing
wrong.
Thanks,
Tim
one_year<-list()
for (i in min(mydat$Year):max(mydat$Year)) #Loops from first to last year in
dataset
{
myear<-mydat[mydat$Year==i,]
name<-paste("Year",i)
one_year[name]<-myear
}
mydat:
Year Month Day number other Ind1 Ind2 Ind3 Ind4
1985 8 13 1 1 0 0 0 0
1986 8 5 2 3 0 0 0 0
1991 4 24 3 0 0 0 0 0
1991 4 25 4 0 0 0 0 0
1991 8 2 5 0 0 0 0 0
1991 8 6 6 0 0 0 0 0
1991 9 4 7 2 0 0 0 0
1991 9 9 8 4 0 0 0 0
1991 12 16 9 0 0 0 0 0
1992 3 18 10 1 0 0 0 0
1992 5 13 11 0 0 0 0 0
1992 7 31 12 1 0 0 0 0
1992 8 19 13 0 0 0 0 0
1992 10 14 14 2 0 0 0 0
1992 10 30 15 4 0 0 0 0
1992 11 11 16 2 0 0 0 0
1992 11 20 17 0 0 0 0 0
1992 12 5 18 0 0 0 0 0
1992 12 9 19 3 0 0 0 0
1993 1 24 20 5 0 0 0 0
What I would like is:
Year1985
1985 8 13 1 1 0 0 0 0
Year 1986
1986 8 5 2 3 0 0 0 0
Year 1991
1991 4 24 3 0 0 0 0 0
1991 4 25 4 0 0 0 0 0
1991 8 2 5 0 0 0 0 0
1991 8 6 6 0 0 0 0 0
1991 9 4 7 2 0 0 0 0
1991 9 9 8 4 0 0 0 0
1991 12 16 9 0 0 0 0 0
ect.
[[alternative HTML version deleted]]
?split. Hadley On Wed, Oct 29, 2008 at 3:22 PM, t c <mudiver1200 at yahoo.com> wrote:> I need some help with sub-setting my data. I am trying to divide a data frame into multiple data frames based on the year collected, and stored in a list with each new data frame labeled with "year X" where X is the year the data was collected. When I run my current code I get nine error messages stating > "In one_year[name] <- myear : number of items to replace is not a multiple of replacement length"What I have so far is: > Below is my code, the data frame mydat, and what I would like the final product to look like. I would appreciate any help or suggestions on what I am doing wrong. > Thanks, > Tim > > > one_year<-list() > for (i in min(mydat$Year):max(mydat$Year)) #Loops from first to last year in dataset > { > myear<-mydat[mydat$Year==i,] > name<-paste("Year",i) > one_year[name]<-myear > } > > > mydat: > Year Month Day number other Ind1 Ind2 Ind3 Ind4 > 1985 8 13 1 1 0 0 0 0 > 1986 8 5 2 3 0 0 0 0 > 1991 4 24 3 0 0 0 0 0 > 1991 4 25 4 0 0 0 0 0 > 1991 8 2 5 0 0 0 0 0 > 1991 8 6 6 0 0 0 0 0 > 1991 9 4 7 2 0 0 0 0 > 1991 9 9 8 4 0 0 0 0 > 1991 12 16 9 0 0 0 0 0 > 1992 3 18 10 1 0 0 0 0 > 1992 5 13 11 0 0 0 0 0 > 1992 7 31 12 1 0 0 0 0 > 1992 8 19 13 0 0 0 0 0 > 1992 10 14 14 2 0 0 0 0 > 1992 10 30 15 4 0 0 0 0 > 1992 11 11 16 2 0 0 0 0 > 1992 11 20 17 0 0 0 0 0 > 1992 12 5 18 0 0 0 0 0 > 1992 12 9 19 3 0 0 0 0 > 1993 1 24 20 5 0 0 0 0 > > > What I would like is: > Year1985 > 1985 8 13 1 1 0 0 0 0 > > Year 1986 > 1986 8 5 2 3 0 0 0 0 > > Year 1991 > 1991 4 24 3 0 0 0 0 0 > 1991 4 25 4 0 0 0 0 0 > 1991 8 2 5 0 0 0 0 0 > 1991 8 6 6 0 0 0 0 0 > 1991 9 4 7 2 0 0 0 0 > 1991 9 9 8 4 0 0 0 0 > 1991 12 16 9 0 0 0 0 0 > ect. > > > > > > [[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. > >-- http://had.co.nz/