dupstatus: Duplicate Status

In crazybilly/muadc: A collection of functions and variables

Description

calculate dup status

Usage

dupstatus(df, dfxrefs = NA, xrefslong = NA, segmentcol = NA)

Arguments

df	a data frame to work on
dfxrefs	a data frame of xrefs generated by getrelationships(). If NA, this is generated.
xrefslong	a data frame in long format of all known xrefs, passed as an argument to getrelationships() if necessary. If NA, defaults to xaxref-pa.csv and xaxref-si.csv in data/warehouse.
segmentcol	an the unquoted name of a column that df is segemented by

Value

a data frame with new columns describing status. Possible statuses for the dupstatus are:

• dupstatus a column describing whether the row is a duplicate or not. Possible statuses include:

  • single - no relationship to anyone else in df

  • bulk inbox - address is a bulk inbox (1184 W Main, PO Box 1955 or 301 SW Adams)

  • relationships unknown - constituent shares an address with one or more people in df, but are not xref'd to those people

  • primary spouse - constituent is married to another constituent in df and is the primary

  • 2nd spouse - constituent is married to another constituent in df and is not the primary

  • other family - constituent shares an address with someone else on th elist and that person's child, parent or sibling

• cataddr - the concatenated mailing address

• countcat - a count of how many times cataddr appears in df

• bulkaddr - a logical value describing whether cataddr is a bulk mail box

• CH - whether the row is a child of someone else in df

• PA - whether the row is a parent of someone else in df

• SI - whether the row is a sibling of someone else in df

• SP - whether the row is a spouse of someone else in df

Also included are cataddr (concatenated address), countcat (a count of how often cataddr appears in df), bulkaddr a logical

crazybilly/muadc documentation built on March 6, 2021, 4:15 p.m.