Pass column name in data.table using variable [duplicate]

by

Use the quote() and eval() functions to pass a variable to j. You don’t need double-quotes on the column names when you do it this way, because the quote()-ed string will be evaluated inside the DT[]

temp <- quote(x)
DT[ , eval(temp)]
# [1] "b" "b" "b" "a" "a"

With a single column name, the result is a vector. If you want a data.table result, or several columns, use list form

temp <- quote(list(x, v))
DT[ , eval(temp)]
#   x           v
# 1: b  1.52566586
# 2: b  0.66057253
# 3: b -1.29654641
# 4: a -1.71998260
# 5: a  0.03159933

More Related Contents:

  1. How to create a lag variable within each group?
  2. data.table objects assigned with := from within function not printed
  3. What is the purpose of setting a key in data.table?
  4. data.table “key indices” or “group counter”
  5. Faster way to read fixed-width files
  6. Select subset of columns in data.table R [duplicate]
  7. Melt using patterns when variable names contain string information – avoid coercion to numeric
  8. Error: package or namespace load failed for ggplot2 and for data.table
  9. How to perform join over date ranges using data.table?
  10. How to extract the first n rows per group?
  11. Split text string in a data.table columns
  12. R: data.table cross-join not working
  13. Update subset of data.table based on join
  14. Dynamically build call for lookup multiple columns
  15. Select values from different columns based on a variable containing column names [duplicate]
  16. knitr gets tricked by data.table `:=` assignment
  17. Add multiple columns to R data.table in one function call?
  18. Subsetting data.table using variables with same name as column
  19. data.table merge based on date ranges
  20. Reason behind speed of fread in data.table package in R
  21. best way to transpose data.table
  22. data.table row-wise sum, mean, min, max like dplyr?
  23. := (pass by reference) operator in the data.table package modifies another data table object simultaneously
  24. Select NA in a data.table in R
  25. How to select R data.table rows based on substring match (a la SQL like)
  26. Any way to force fread() of data.table not to stop on empty lines?
  27. R data table: update join
  28. Split a string column into several dummy variables
  29. Is there a _fast_ way to run a rolling regression inside data.table?
  30. R fast single item lookup from list vs data.table vs hash

Leave a Comment