checkVarNames {eatGADS} | R Documentation |
Check names for SQLite
column name conventions.
Description
Checks names for SQLite
column name conventions and
applies appropriate variable name changes to GADSdat
or all_GADSdat
objects.
Usage
checkVarNames(
GADSdat,
checkKeywords = TRUE,
checkDots = TRUE,
checkDuplicates = TRUE
)
Arguments
GADSdat |
|
checkKeywords |
Logical. Should |
checkDots |
Logical. Should occurrences of |
checkDuplicates |
Logical. Should case insensitive duplicate variable names be checked and modified? |
Details
Invalid column names in a SQLite
data base include
-
SQLite
keywords (seesqlite_keywords
), column names with a
"."
in it andduplicate variable names which arise from
SQLite
being case insensitive.
The corresponding variable name changes are
appending the suffix
"Var"
to allSQLite
keywords,changing all
"."
in variable names to"_"
andappending
"_2"
to case insensitive duplicated variable names.
Note that avoiding "."
in variable names is beneficial for multiple reasons, such as
avoiding confusion with S3
methods in R
and issues when importing from Stata
.
Value
Returns the original object with updated variable names.
Examples
# Change example data set (create an invalid variable name)
pisa2 <- changeVarNames(pisa, oldNames = "computer_age",
newNames = "computer.age")
pisa3 <- checkVarNames(pisa2)