Skip to content
Back to formatted view

Raw Message

Message-ID: <01fd01d843e0$6fc9efb0$4f5dcf10$@sbcglobal.net>
Date: 2022-03-30T02:47:02Z
From: Jeff Reichman
Subject: Inserting missing seq number

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