padr (version 0.7.0)

pad_int: Pad the integer column of a data frame

Description

pad_int fills the gaps in incomplete integer variables. It will insert a record for each of the missing value. For all other variables in the data frame a missing value will be inserted at the padded rows.

Usage

pad_int(x, by, start_val = NULL, end_val = NULL, group = NULL, step = 1)

Value

The data frame x with the specified variable padded. All non-grouping variables in the data frame will have missing values at the rows that are padded.

Arguments

x

A data frame.

by

The column to be padded.

start_val

The first value of the returned variable. If NULL it will use the lowest value of the input variable.

end_val

The last value of the returned variable. If NULL it will use the highest value of the input variable.

group

Optional character vector that specifies the grouping variable(s). Padding will take place within the different group values.

step

The step size of the returned variable.

Examples

int_df <- data.frame(
  x = c(2005, 2007, 2008, 2011),
  val = c(3, 2, 6, 3)
)
pad_int(int_df, "x")
pad_int(int_df, "x", start_val = 2006, end_val = 2013)

int_df2 <- data.frame(x = c(2005, 2015), val = c(3, 4))
pad_int(int_df2, "x", step = 2)
pad_int(int_df2, "x", step = 5)

int_df3 <- data.frame(
  x = c(2005, 2006, 2008, 2006, 2007, 2009),
  g = rep(LETTERS[1:2], each = 3),
  val = c(6, 6, 3, 5, 4, 3)
)
pad_int(int_df3, "x", group = "g")
pad_int(int_df3, "x", group = "g", start_val = 2005, end_val = 2009)