Merge two data tables

mergeData(dt1, dt2, idvars)

Arguments

dt1: Name of first data.table
dt2: Name of second data.table
idvars: Vector of string names to merge on

Value

A new data table that merges dt2 with dt1

Examples

def1 <- defData(varname = "x", formula = 0, variance = 1)
def1 <- defData(varname = "xcat", formula = ".3;.2", dist = "categorical")

def2 <- defData(varname = "yBin", formula = 0.5, dist = "binary", id = "xcat")
def2 <- defData(def2, varname = "yNorm", formula = 5, variance = 2)

dt1 <- genData(20, def1)
#> Warning: Probabilities do not sum to 1. Adding category to all rows!
dt2 <- genData(3, def2)

dtMerge <- mergeData(dt1, dt2, "xcat")
dtMerge
#> Key: <id>
#>        id  xcat  yBin    yNorm
#>     <int> <int> <int>    <num>
#>  1:     1     2     0 3.224902
#>  2:     2     3     0 3.666332
#>  3:     3     2     0 3.224902
#>  4:     4     1     0 7.288896
#>  5:     5     2     0 3.224902
#>  6:     6     3     0 3.666332
#>  7:     7     3     0 3.666332
#>  8:     8     1     0 7.288896
#>  9:     9     2     0 3.224902
#> 10:    10     3     0 3.666332
#> 11:    11     2     0 3.224902
#> 12:    12     3     0 3.666332
#> 13:    13     1     0 7.288896
#> 14:    14     3     0 3.666332
#> 15:    15     2     0 3.224902
#> 16:    16     2     0 3.224902
#> 17:    17     3     0 3.666332
#> 18:    18     3     0 3.666332
#> 19:    19     1     0 7.288896
#> 20:    20     3     0 3.666332
#>        id  xcat  yBin    yNorm