dt_fill: Fill with data.table

Description Usage Arguments Value Examples

View source: R/fill.R

Description

Fills in values, similar to tidyr::fill(), by within data.table. This function relies on the Rcpp functions that drive tidyr::fill() but applies them within data.table.

Usage

1
dt_fill(dt_, ..., id = NULL, .direction = c("down", "up", "downup", "updown"))

Arguments

dt_

the data table (or if not a data.table then it is coerced with as.data.table)

...

the columns to fill

id

the grouping variable(s) to fill within

.direction

either "down" or "up" (down fills values down, up fills values up), or "downup" (down first then up) or "updown" (up first then down)

Value

A data.table with listed columns having values filled in

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
set.seed(84322)
library(data.table)

x = 1:10
dt = data.table(v1 = x,
                v2 = shift(x),
                v3 = shift(x, -1L),
                v4 = sample(c(rep(NA, 10), x), 10),
                grp = sample(1:3, 10, replace = TRUE))
dt_fill(dt, v2, v3, v4, id = grp, .direction = "downup")
dt_fill(dt, v2, v3, v4, id = grp)
dt_fill(dt, .direction = "up")

tidyfast documentation built on March 20, 2020, 5:08 p.m.