spread_multivalue: tidyr's spread for multiple values

In weiyangtham/twydyverse: Assorted functions written by me

Description

Extension of 'tidyr::spread' when there is a key with multiple values. Same purpose as Stata's 'reshape' wide.

Usage

spread_multivalue(data, key, values, sep = "")

Arguments

data	a data frame
key	key, a string
values	A selection of columns. If empty, all variables are selected. You can supply bare variable names, select all variables between x and z with x:z, exclude y with -y. For more options, see the dplyr::select() documentation.
sep	separator to use between key and values

Examples

scores <- data.frame(
id = LETTERS[1:5],
age2000 = 11:15,
age2010 = 21:25,
scores2000 = 96:100,
scores2010 = 100:96)

# gather_multivalue(scores, "year", -id)
scores_long <- gather_multivalue(scores, "year", age2000:scores2010)

spread_multivalue(scores_long, "year", c(age, scores))

weiyangtham/twydyverse documentation built on May 17, 2019, 8:46 p.m.