tidyft (version 0.9.20)

fill: Fill in missing values with previous or next value

Description

Fills missing values in selected columns using the next or previous entry.

Usage

fill(.data, ..., direction = "down")
shift_fill(x, direction = "down")

Value

A filled data.table

Arguments

.data

A data.table

...

A selection of columns.

direction

Direction in which to fill missing values. Currently either "down" (the default), "up".

x

A vector.

Details

fill is filling data.table's columns, shift_fill is filling any vectors.

Examples

df <- data.table(Month = 1:12, Year = c(2000, rep(NA, 10),2001))
df
df %>% fill(Year)

df <- data.table(Month = 1:12, Year = c(2000, rep(NA, 10),2001))
df %>% fill(Year,direction = "up")