r - data.table: using setkey with a column name variable -


i have variable name saved string variable which_id.

w data.table. how call setkey on w which_id ?

this i've tried

 > eval( paste( 'setkey(w,' , which_id , ')' ) ) [1] "setkey(w, customer_id_a )" 

but call tables() shows customer_id_a key didn't take.

 > evalq( paste( 'setkey(w,' , which_id , ')' ) ) [1] "setkey(w, customer_id_a )" 

customer_id_a key still didn't take.

 > setkeyv( w , cols=which_id ) 

and

 > setkeyv( w , cols=c( which_id ) ) 

--> same thing, customer_id_a key isn't there.

any pointers? thanks.

setkeyv should work. here reproducible example:

library(data.table) w <- data.table(customer_id_a = 1:2) which_id <- "customer_id_a" setkeyv(w, which_id) tables() ##      name nrow mb cols          key           ## [1,] w       2 1  customer_id_a customer_id_a ## total: 1mb 

Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

javascript - Clean way to programmatically use CSS transitions from JS? -

android - send complex objects as post php java -