Message-ID: <007c01d84486$6fb88620$4f299260$@sbcglobal.net>
Date: 2022-03-30T22:35:18Z
From: Jeff Reichman
Subject: Inserting missing seq number
In-Reply-To: <CAHqSRuSMUDhbJ8-MwD8pNEK8hWfoqtGaK6EBpUcFNGAVQ7omyA@mail.gmail.com>
Bill
Thank you. This is a third option to look into.
Jeff
From: Bill Dunlap <williamwdunlap at gmail.com>
Sent: Wednesday, March 30, 2022 10:40 AM
To: reichmanj at sbcglobal.net
Cc: R-help at r-project.org
Subject: Re: [R] Inserting missing seq number
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 <mailto: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 <mailto: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]]