rquery (version 0.2.0)

rename_columns: Make a rename columns node (not a relational operation).

Description

Make a rename columns node (not a relational operation).

Usage

rename_columns(source, cmap)

Arguments

source

source to rename from.

cmap

map written as new column names as keys and old column names as values.

Value

rename columns node.

Examples

# NOT RUN {
my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
d <- dbi_copy_to(my_db, 'd',
                data.frame(AUC = 0.6, R2 = 0.2, z = 3))
eqn <- rename_columns(d, c('AUC2' := 'AUC', 'R' := 'R2'))
cat(format(eqn))
sql <- to_sql(eqn, my_db)
cat(sql)
DBI::dbGetQuery(my_db, sql)
DBI::dbDisconnect(my_db)

# }