Inserting missing seq number
Petr & Eric Thank you for the two options. Figured there was an easy straight forward way. Jeff -----Original Message----- From: PIKAL Petr <petr.pikal at precheza.cz> Sent: Wednesday, March 30, 2022 12:59 AM To: reichmanj at sbcglobal.net Cc: r-help at r-project.org Subject: RE: [R] Inserting missing seq number Hallo Jeff Similar result you will get by na.locf function from zoo package df <- data.frame(seq = c(1,2,4,5,7), count = c(4,7,3,5,2)) vec <-data.frame(seq =1:7) df <- merge(vec, df, all=T) library(zoo) df$count <- na.locf(df$count) Cheers Petr
-----Original Message----- From: R-help <r-help-bounces at r-project.org> On Behalf Of Eric Berger Sent: Wednesday, March 30, 2022 5:36 AM To: reichmanj at sbcglobal.net Cc: r-help at r-project.org Subject: Re: [R] Inserting missing seq number Hi Jeff, tidyr::fill() will do what you want aDf <- data.frame(seq=1:7) bDf <- left_join(aDf,df,by="seq") tidyr::fill(bDf,count) HTH, Eric On Wed, Mar 30, 2022 at 5:47 AM Jeff Reichman <reichmanj at sbcglobal.net> wrote:
R-help Is there a R function that will insert missing sequence number(s) and then fill a missing observation with the preceding value. For example df <- data.frame(seq = c(1,2,4,5,7), count = c(4,7,3,5,2)) seq count 1 1 4 2 2 7 3 4 3 4 5 5 5 7 2 What I need is seq count 1 1 4 2 2 7 3 3 7 4 4 3 5 5 5 6 6 5 7 7 2 Jeff
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see 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 at r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.