town_names: Clean up town names as returned from ACS

In CT-Data-Haven/cwi: Prep for DataHaven's Community Wellbeing Index

Clean up town names as returned from ACS

Description

This function does two things: it removes text other than the town name from the column given as name_col, and it removes any rows for "county subdivisions not defined." For example, the string "Ansonia town, New Haven County, Connecticut" will become "Ansonia."

Usage

town_names(data, name_col)

Arguments

data	A data frame
name_col	Bare column name of town names

Value

A tibble/data frame with cleaned names and "not defined" towns removed

Examples

pops <- tibble::tribble(
  ~name, ~total_pop,
  "County subdivisions not defined, New Haven County, Connecticut",     0,
  "Ansonia town, New Haven County, Connecticut",                    18802,
  "Beacon Falls town, New Haven County, Connecticut",                6168,
  "Bethany town, New Haven County, Connecticut",                     5513,
  "Branford town, New Haven County, Connecticut",                    2802
  )
town_names(pops, name_col = name)

CT-Data-Haven/cwi documentation built on July 1, 2024, 7:45 a.m.