Learn R Programming

DataCombine (version 0.2.18)

FillDown: Fills in missing (NA) values with the previous non-missing value

Description

Fills in missing (NA) values with the previous non-missing value

Usage

FillDown(data, Var)

Arguments

data
a data frame. Optional as you can simply specify a vector with Var,
Var
the variable in data or a vector you would like to fill down missing (NA) values.

Value

  • data frame

Examples

Run this code
# Create fake data
id <- c('Algeria', NA, NA, NA, 'Mexico', NA, NA)
score <- rnorm(7)
Data <- data.frame(id, score)

# FillDown id
DataOut <- FillDown(Data, 'id')

# Use group_by and mutate from dplyr to FillDown grouped data, e.g.:
Example <- Example %>% group_by(grouping) %>% 
             mutate(NewFilled = FillDown(Var = VarToFill))

Run the code above in your browser using DataLab