addrlink: Merge Data To Reference Index

In KOR.addrlink: Matching Address Data to Reference Index

Merge Data To Reference Index

Description

Takes two data.frames with address data and merges them together.

Usage

addrlink(df_ref, df_match, 
col_ref = c("Strasse", "Hausnummer", "Hausnummernzusatz"), 
col_match = c("Strasse", "Hausnummer", "Hausnummernzusatz"), 
fuzzy_threshold = 0.9, seed = 1234)

Arguments

df_ref	data.frame with address references
df_match	data.frame with addresses to be matched
col_ref	character vector of length three, naming the df_ref columns which contain the steet names, house numbers and additional letters (in that order)
col_match	character vector of length three, naming the df_match columns which contain the steet names, house numbers and additional letters (in that order)
fuzzy_threshold	The threshold used for fuzzy matching street names
seed	Seed for random numbers

Details

The matching is done in four stages.

Stage 1 (qAdress = 1). This is an exact match (highest quality, qscore = 1)

Stage 2 (qAdress = 2). Exact match on street name, but no valid house number could be found. Be aware that random house numbers might be used. Consider setting your own seed. qscore indicates the match quality. See match_number for details.

Stage 3 (qAdress = 3). No exact match on street name could be found. Street names are fuzzy matched. The method "jw" (Jaro-Winkler distance) from package stringdist is used (see stringdist-metrics). If 1 - [Jaro-Winkler distance] is greater than fuzzy_threshold, a match is assumed. The highest score is taken and house number matching is done as outlined in Stage 2. qscore is fuzzy_score*[house number score].

Stage 4 (qAdress = 4). No match (qscore = 0)

Value

A list

ret	The merged dataset
QA	The quality markers (qAdress and qscore)

Author(s)

Daniel Schürmann

See Also

split_address, split_number

KOR.addrlink documentation built on May 29, 2024, 4 a.m.