Hi Sandra, Terribly ugly, but this way at least you don't have to know which years are missing, etc.:
dat <- data.frame(year = c(1981,1984,1985,1986), size = c(1,2,3,4)) year_ <- data.frame(year = seq(1981,1986,1)) year_dat <- merge(year_, dat, by = "year", all=T) na_s <- subset(year_dat, is.na(size) == "TRUE") na_s_zeros <- cbind(na_s, size = rep(0, length(na_s[,1])))[,-2] newdat <- rbind(subset(year_dat, !is.na(size) == "TRUE"), na_s_zeros) hth, Scott On Wednesday, February 23, 2011 at 4:22 PM, saba wrote: > > Hello everyone, > > I have the following problem, I have a dataframes that looks like this: > > fire$Year fire$Size > 1 1981 1738.0 > 2 1984 2228.1 > 3 1985 38963.3 > 4 1986 2223.4 > 5 1987 3594.6 > 6 1988 1520.0 > ... > > What I would like to do is copy the values from the fire$Size colum and put > it into a new df but with "0" for the years that are missing. The result > should look like this: > > year size > > 1981 1738.0 > 1982 0 > 1983 0 > 1984 2228.1 > ... > > First I tried to merge the two dataframes > temp <-merge(fire.sum,fire2, by.x="fire$Year", by.y="year") > > but then it only gives me the years that are the same. So I thought it might > be easier to just copy them? > > Any help is appreciated, thank you so much > Cheers > Sandra > > -- > View this message in context: > http://r.789695.n4.nabble.com/copy-values-from-one-dataframes-into-another-tp3321805p3321805.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. > [[alternative HTML version deleted]] ______________________________________________ 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.
