Fusion: Fusion

In FernandoTusell/ipv: Computation of housing price indices

Fusion

Description

Fusion

Usage

Fusion(
  X,
  Y = NULL,
  varX,
  locX = 1,
  varY,
  locY = 2,
  canon,
  locCanon = NULL,
  transX = NULL,
  transY = NULL
)

Arguments

X	Second dataframe to merge
Y	Second dataframe to merge
varX	Variable acting as key in X
locX	Column in canon against which to match values of column varX in X
varY	Variable acting as key in Y
locY	Column in canon against which to match values of column varY in Y
canon	Correspondence between varX, varY and canonical value of the key (defaults to column 'Canon').
locCanon	Column in canon holding the canonical names. Defaults to column named 'Canon' if one exists and the argument is not set on call.
transX	Transformation to be applied to varX (if any)
transY	Transformation to be applied to varY (if any)

Value

Data frame or merge of two data frames, with location names replaced by canonical names.

Examples

X     <- data.frame(a=c("Bilbao","San Sebastian","Vitoria","Teruel"),
                    b=c("A","B","B","D"), d=c(TRUE,TRUE,FALSE,TRUE))
X
Y     <- data.frame(e=c("Bilbao","Donostia","Vitoria/Gazteiz","Soria"),
                    g=c("F","G","H","J"), h=c(TRUE,FALSE,TRUE,TRUE))
Y
canon <- data.frame(X=c("Bilbao","San Sebastian","Vitoria"),
                    Y=c("Bilbao","Donostia","Vitoria/Gazteiz"),
                    Canon=c("Bilbao","Donostia","Vitoria"))
canon

Fusion(X, varX="a", locX=1, locCanon=3, canon=canon)

Fusion(X=Y, varX="e", locX=2, locCanon=3, canon=canon)

Fusion(X,Y,varX="a",varY="e",locX=1, locY=2, canon=canon)

canon <- data.frame(X=c("Bilbao","San Sebastian","Vitoria","Teruel","Soria"),
                    Y=c("Bilbao","Donostia","Vitoria/Gazteiz", "Teruel","Soria"),
                    Canon=c("Bilbao","Donostia","Vitoria","Teruel","Soria"))

Fusion(X, varX="a", locX=1, locCanon=3, canon=canon)

Fusion(X=Y, varX="e", locX=2, locCanon=3, canon=canon)

Fusion(X,Y,varX="a",varY="e",locX=1, locY=2, canon=canon)

canon <- data.frame(X=c("Bilbao","San Sebastian","Vitoria","Teruel","Soria"),
                    Y=c("Bilbao","Donostia","Vitoria/Gazteiz", "Teruel","Soria"),
                    Canon=c("CAPV","CAPV","CAPV","NoCAPV","NoCAPV"))

Fusion(X, varX="a", locX=1, locCanon=3, canon=canon)

Fusion(X=Y, varX="e", locX=2, locCanon=3, canon=canon)

# This hardly makes sense:

Fusion(X, Y, varX="a", varY="e", locX=1, locY=2, locCanon=3, canon=canon)

FernandoTusell/ipv documentation built on Nov. 7, 2022, 6:03 a.m.