protect_integer_cols: Protect column names that are bare integers from being...
In rohmin9122/gcam-korea-release: Build the GCAM-Korea Input Datasets

Description Usage Arguments Details Value Examples

protect_integer_cols will prepend an 'X' to column names that are bare integers to protect them from being misinterpreted during sensitive operations (see below). unprotect_integer_cols will reverse the effect, reverting the column names to their original form.

1
2
3

protect_integer_cols(d)

unprotect_integer_cols(d)

`d`	The data to have integer column names protected or unprotected

Some of our data frames have column names that are years, such as "2005". In some cases a column name of this form can be misinterpreted as a column index, the (likely nonexistent) 2005th column in this example. The *_if functions in dplyr are examples of such circumstances. Protecting the column names with a leading character allows these functions to perform normally.

Much of the data system is expecting years in column names to be bare integers; therefore, you should unprotect the column names as soon as the sensitive operations are complete.

Tibble with the integer column names protected

library(magrittr)
df <- dplyr::tibble(iso=c('bad','dum'), `2005`=c(123.45, NA), `2050`=c(867, 5309))
protect_integer_cols(df) %>%
    dplyr::select_if(function(col) {!any(is.na(col))}) %>%
    unprotect_integer_cols