Message-ID: <CAHqSRuSMUDhbJ8-MwD8pNEK8hWfoqtGaK6EBpUcFNGAVQ7omyA@mail.gmail.com>
Date: 2022-03-30T15:40:19Z
From: Bill Dunlap
Subject: Inserting missing seq number
In-Reply-To: <01fd01d843e0$6fc9efb0$4f5dcf10$@sbcglobal.net>
stats::approx can do the job:
> approx(x=df$seq, df$count, xout=1:7, method="constant", f=0)
$x
[1] 1 2 3 4 5 6 7
$y
[1] 4 7 7 3 5 5 2
-Bill
On Tue, Mar 29, 2022 at 7:47 PM 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]]