[R] Inserting missing seq number

Eric Berger er|cjberger @end|ng |rom gm@||@com
Wed Mar 30 05:35:36 CEST 2022


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 using 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 using 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]]



More information about the R-help mailing list