dfMerge: Merges two data frames

Description

Merges variables from two data frames (DataX, DataY) by default or merges cases (if AddVars= FALSE). When mergeing variables, by default matches on row names but can use other variable names in DataX (ByX) and DataY (ByY) as needed. Also by default, includes all cases in DataX and DataY but can limit to only matching (AllX=FALSE, AllY=FALSE) or left join (AllY=FALSE) or right join (AllX=FALSE).

When merging cases, will add variables to DataX or DataY as needed and set added variables to NA

Usage

dfMerge(DataX, DataY, ByX = 0, ByY = 0, AllX = TRUE, AllY = TRUE, AddVars=TRUE)

Arguments

DataX

first data frame for merge

DataY

second data frame for merge

ByX

Name of variable in DataX to match cases on. Column can be specified by name or number. Default is 0 which uses rownames

ByY

Name of variable in DataY to match cases on. Column can be specified by name or number. Default is 0 which uses rownames

AllX

logical; if TRUE, then extra rows will be added to the output, one for each row in DataX that has no matching row in DataY These rows will have NAs in those columns that are usually filled with values from dY. The default is TRUE, so that all rows with data from both dX and dY are included in the output. In other words, it is the union of these two dataframes

AllY

analagous to AllX but for DataY

AddVars

Default is to merge variables (columns). If FALSE will merge cases (rows)

Value

Returns merged data frame

Details

see merge() or rbind() for more details on merging variables or cases, respectively.

Examples

Run this code

# NOT RUN {
dX <- data.frame(v1=c(1,2,3,4,5), v2=c(1,NA,NA,2,4), data=1:5)
rownames(dX) = c(1,2,3,4,5)
dY <- data.frame(v3=c(3,2,1,4,15), v4=c(2,4,5,6,7), data=6:10)
rownames(dY) = c(1,2,3,4,6)
dNew = dfMerge(dX,dY)
# }