dt_dcast_string

Data.table dcast using character inputs for formula

Usage

dt_dcast_string(data, col_name1, col_name2, value.var)

Arguments

data

a data.table

col_name1

character. LHS of cast formula

col_name2

character. RHS of cast formula

value.var

character. Name of the column whose values will be filled to cast.

Value

A keyed data.table that has been cast

See also

data.table::dcast.data.table()

Examples

x <- data.table::data.table(
    col1 = c(rep("a", 3), rep("b", 3)),
    col2 = rep(LETTERS[1:3], 2),
    value = c(1:6)
)
force(x)
#>      col1   col2 value
#>    <char> <char> <int>
#> 1:      a      A     1
#> 2:      a      B     2
#> 3:      a      C     3
#> 4:      b      A     4
#> 5:      b      B     5
#> 6:      b      C     6
y <- dt_dcast_string(x, "col1", "col2", "value")
force(y)
#> Key: <col1>
#>      col1     A     B     C
#>    <char> <int> <int> <int>
#> 1:      a     1     2     3
#> 2:      b     4     5     6