Package 'crosswalkr'

Encode data frame column using external crosswalk file.

Description

Encode data frame column using external crosswalk file.

Usage

encodefrom(
  .data,
  var,
  cw_file,
  raw,
  clean,
  label,
  delimiter = NULL,
  sheet = NULL,
  case_ignore = TRUE,
  ignore_tibble = FALSE
)

encodefrom_(
  .data,
  var,
  cw_file,
  raw,
  clean,
  label,
  delimiter = NULL,
  sheet = NULL,
  case_ignore = TRUE,
  ignore_tibble = FALSE
)

Arguments

.data	Data frame or tbl_df
var	Column name of vector to be encoded
cw_file	Either data frame object or string with path to external crosswalk file, including path, which has columns representing raw (current) vector values, clean (new) vector values, and labels for values. Values in raw and clean columns must be unique (1:1 match) or an error will be thrown. Acceptable file types include: delimited (.csv, .tsv, or other), R (.rda, .rdata, .rds), or Stata (.dta).
raw	Name of column in cw_file that contains values in current vector.
clean	Name of column in cw_file that contains new values for vector.
label	Name of column in cw_file with labels for new values.
delimiter	String delimiter used to parse cw_file. Only necessary if using a delimited file that isn't a comma-separated or tab-separated file (guessed by function based on file ending).
sheet	Specify sheet if cw_file is an Excel file and required sheet isn't the first one.
case_ignore	Ignore case when matching current (raw) vector name with new (clean) column name.
ignore_tibble	Ignore .data status as tbl_df and return vector as a factor rather than labelled vector.

Value

Vector that is either a factor or labelled, depending on data input and options

Functions

• encodefrom_(): Standard evaluation version of encodefrom (var, raw, clean, and label must be strings when using this version)

Examples

df <- data.frame(state = c('Kentucky','Tennessee','Virginia'),
                 stfips = c(21,47,51),
                 cenregnm = c('South','South','South'))

df_tbl <- tibble::as_tibble(df)

cw <- get(data(stcrosswalk))

df$state2 <- encodefrom(df, state, cw, stname, stfips, stabbr)
df_tbl$state2 <- encodefrom(df_tbl, state, cw, stname, stfips, stabbr)
df_tbl$state3 <- encodefrom(df_tbl, state, cw, stname, stfips, stabbr,
                            ignore_tibble = TRUE)

haven::as_factor(df_tbl)
haven::zap_labels(df_tbl)

---

Rename data frame columns using external crosswalk file.

Description

Rename data frame columns using external crosswalk file.

Usage

renamefrom(
  .data,
  cw_file,
  raw,
  clean,
  label = NULL,
  delimiter = NULL,
  sheet = NULL,
  drop_extra = TRUE,
  case_ignore = TRUE,
  keep_label = FALSE,
  name_label = FALSE
)

renamefrom_(
  .data,
  cw_file,
  raw,
  clean,
  label = NULL,
  delimiter = NULL,
  sheet = NULL,
  drop_extra = TRUE,
  case_ignore = TRUE,
  keep_label = FALSE,
  name_label = FALSE
)

Arguments

.data	Data frame or tbl_df
cw_file	Either data frame object or string with path to external crosswalk file, which has columns representing raw (current) column names, clean (new) column names, and labels (optional). Values in raw and clean columns must be unique (1:1 match) or an error will be thrown. Acceptable file types include: delimited (.csv, .tsv, or other), R (.rda, .rdata, .rds), or Stata (.dta).
raw	Name of column in cw_file that contains column names of current data frame.
clean	Name of column in cw_file that contains new column names.
label	Name of column in cw_file with labels for columns.
delimiter	String delimiter used to parse cw_file. Only necessary if using a delimited file that isn't a comma-separated or tab-separated file (guessed by function based on file ending).
sheet	Specify sheet if cw_file is an Excel file and required sheet isn't the first one.
drop_extra	Drop extra columns in current data frame if they are not matched in cw_file.
case_ignore	Ignore case when matching current (raw) column names with new (clean) column names.
keep_label	Keep current label, if any, on data frame columns that aren't matched in cw_file. Default FALSE means that unmatched columns have any existing labels set to NULL.
name_label	Use old (raw) column name as new (clean) column name label. Cannot be used if label option is set.

Value

Data frame or tbl_df with new column names and labels.

Functions

• renamefrom_(): Standard evaluation version of renamefrom (raw, clean, and label must be strings when using this version)

Examples

df <- data.frame(state = c('Kentucky','Tennessee','Virginia'),
                 fips = c(21,47,51),
                 region = c('South','South','South'))

cw <- data.frame(old_name = c('state','fips'),
                 new_name = c('stname','stfips'),
                 label = c('Full state name', 'FIPS code'))

df1 <- renamefrom(df, cw, old_name, new_name, label)
df2 <- renamefrom(df, cw, old_name, new_name, name_label = TRUE)
df3 <- renamefrom(df, cw, old_name, new_name, drop_extra = FALSE)

---

State crosswalk data set.

Description

An example state crosswalk. Includes information for all states plus the District of Columbia.

Usage

stcrosswalk

Format

A data frame with 51 rows and 7 variables:

stfips

Two-digit state FIPS codes

stabbr

Two-letter state abbreviation

stname

Full state name

cenreg

Census region number

cenregnm

Census region name

cendiv

Census division number

cendivnm

Census division name

---

State and territory crosswalk data set.

Description

An example state and territory crosswalk. Includes information for all states plus the District of Columbia plus territories.

Usage

sttercrosswalk

Format

A data frame with 69 rows and 10 variables:

stfips

Two-digit FIPS codes

stabbr

Two-letter abbreviation

stname

Full name

cenreg

Census region number

cenregnm

Census region name

cendiv

Census division number

cendivnm

Census division name

is_state

Indicator for status as state

is_state_dc

Indicator for status as state or DC

status

1 := Under U.S. sovereignty; 2 := Minor Outlying Islands; 3 := Independent nation under Compact of Free Association with U.S.; 4 := Individual Minor Outlying Islands (within status 2)

---