wider_dt: Pivot data from long to wide

In hope-data-science/tidydt: Tidy Verbs for 'data.table'

Description

Analogous function for pivot_wider in tidyr.

Usage

wider_dt(
  data,
  group_to_keep = NULL,
  name_to_spread,
  value_to_spread = NULL,
  fill = NA
)

Arguments

data	data.table
group_to_keep	The unchanged group in the transformation. Could use integer vector, character vector or regular expression(to match the column names). If NULL, use all other variables.
name_to_spread	Chracter.One column name of class to spread
value_to_spread	Chracter.One column name of value to spread. If NULL, use all other variables.
fill	Value with which to fill missing cells. Default uses NA.

Value

data.table

See Also

dcast

pivot_wider

Examples

 stocks = data.frame(
   time = as.Date('2009-01-01') + 0:9,
   X = rnorm(10, 0, 1),
   Y = rnorm(10, 0, 2),
   Z = rnorm(10, 0, 4)
 ) %>%
   longer_dt(time) -> longer_stocks

 longer_stocks

 longer_stocks %>%
   wider_dt("time","variable","value")

 longer_stocks %>%
   mutate_dt(one = 1) %>%
   wider_dt("time","variable","one")

hope-data-science/tidydt documentation built on Feb. 21, 2020, 10:25 a.m.