fill gaps in sequence within data.table

Asked Apr 15 '19 at 17:56

Active Apr 15 '19 at 17:56

Viewed 55 times

I have data

dat <- data.table(id=c(1,1,1,2,2,2,3,3), week=c(1,2,3,1,2,3,1,3), val=c(1,2,3,5,6,7,9,10))
> dat
   id week val
1:  1    1   1
2:  1    2   2
3:  1    3   3
4:  2    1   5
5:  2    2   6
6:  2    3   7
7:  3    1   9
8:  3    3  10

where for id=3a value is missing for week 2. I want to fill these gaps with val=0 and wonder how this can be done.

I have tried to get weeks <- 1:3 and join this with dat but it did not help.

asked Apr 15 '19 at 17:56

bumblebee

1,116
8
20

Use the function provided by @Frank in the linked post: `completeDT(dat, cols = c("id", "week"), defs = c(val = 0))` – markus Apr 15 '19 at 18:17
or noting that dplyr/tidyr works on data.tables: `tidyr::complete(dat, id, week)` – G. Grothendieck Apr 15 '19 at 18:29

fill gaps in sequence within data.table

0 Answers0