On Thu, 2007-11-15 at 09:41 +1100, Andrew Hoskins wrote: > Hi, > > I have a data frame with two columns of data, one an indexing column > and the other a data column. My issue is, this data frame is > incomplete and there are missing lines. I want to know how I can > find and add data into these missing lines. See example below > > ## Example data > > data <- data.frame(index=c(1:4,6:10), data=c > (1.5,4.3,5.6,6.7,7.1,12.5,14.5,16.8,3.4)) > > index data > 1 1 1.5 > 2 2 4.3 > 3 3 5.6 > 4 4 6.7 > 5 6 7.1 > 6 7 12.5 > 7 8 14.5 > 8 9 16.8 > 9 10 3.4 > > ## note: index number 5 is missing > > ## What I want > > index data > 1 1 1.5 > 2 2 4.3 > 3 3 5.6 > 4 4 6.7 > 5 5 NA > 6 6 7.1 > 7 7 12.5 > 8 8 14.5 > 9 9 16.8 > 10 10 3.4 > > I'm running R2.6.0 on Mac OSX.
How about this: > DF index data 1 1 1.5 2 2 4.3 3 3 5.6 4 4 6.7 5 6 7.1 6 7 12.5 7 8 14.5 8 9 16.8 9 10 3.4 DF.NEW <- data.frame(index = seq(max(DF$index))) > DF.NEW index 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 DF.NEW <- merge(DF.NEW, DF, all.x = TRUE) > DF.NEW index data 1 1 1.5 2 2 4.3 3 3 5.6 4 4 6.7 5 5 NA 6 6 7.1 7 7 12.5 8 8 14.5 9 9 16.8 10 10 3.4 See ?merge for more information. HTH, Marc Schwartz ______________________________________________ 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.
