Inserting missing seq number

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

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.