repair_header: Fix column names to be like conventional relational database...
In adamleerich/alrtools: My R Package

repair_header

R Documentation

Fix column names to be like conventional relational database names

Description

Fix column names to be like conventional relational database names

Usage

repair_header(x)

Arguments

`x`	names to convert

Value

Returns fixed names guaranteed to be unique

Examples

x <- c(
  "DR_NO", "Quarter", "Date Rptd",
  "DATE OCC", "TIME OCC", "AREA", "AREA NAME",
  "Rpt Dist No", "Part 1-2", "Crm Cd", "Crm Cd Desc", "Mocodes",
  "Vict Age", "Vict Sex", "Vict Descent", "Premis Cd", "Premis Desc",
  "Weapon Used Cd", "Weapon Desc", "Status", "Status Desc", "Crm Cd 1",
  "Crm Cd 2", "Crm Cd 3", "Crm Cd 4", "LOCATION|().,{}''", "Cross Street",
  "LAT", "LON", "FXEXCHANGERATE...COM",
  "Currency Symbols     ", "_Currency Symbols - FX Exchange Rate",
  "Home#", "Currency___Converter!",
  "World__Countries", "Gold%", '    ', "Currency Codes(ISO)",
  "100", "m$", "£", "€", "QUARTER")
repair_header(x)

adamleerich/alrtools documentation built on Dec. 16, 2024, 8:49 a.m.