fill.: Fill in missing values with previous or next value

Description Usage Arguments Examples

View source: R/fill.R

Description

Fills missing values in the selected columns using the next or previous entry. Can be done by group.

Supports tidyselect

Usage

1
fill.(.df, ..., .direction = c("down", "up", "downup", "updown"), .by = NULL)

Arguments

.df

A data.frame or data.table

...

A selection of columns. tidyselect compatible.

.direction

Direction in which to fill missing values. Currently "down" (the default), "up", "downup" (first down then up), or "updown" (first up and then down)

.by

Columns to group by when filling should be done by group

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
test_df <- data.table(
  a = c(1, NA, 3, 4, 5),
  b = c(NA, 2, NA, NA, 5),
  groups = c("a", "a", "a", "b", "b")
 )

test_df %>%
  fill.(a, b)

test_df %>%
  fill.(a, b, .direction = "downup")

test_df %>%
  fill.(a, b, .direction = "downup", .by = groups)

mtfairbanks/gdt documentation built on May 4, 2021, 9:44 a.m.