Subsetting data.table using variables with same name as column

by

For now, a temporary solution could be,

`..` <- function (..., .env = globalenv())
{
  get(deparse(substitute(...)), env = .env)
}

..(a)
## [1] "b"

dt[a==..(a)]
##    a b  c
## 1: b a 15
## 2: b a 11
## 3: b b  8
## 4: b b  4
## 5: b c  5
## 6: b c 12

Though this looks elegant, I am still waiting for a more robust solution to such scope issues.

Edited according to @mnel’s suggestion,

`..` <- function (..., .env = sys.parent(2))
{
  get(deparse(substitute(...)), env = .env)
}

More Related Contents:

  1. Update subset of data.table based on join
  2. from data table, randomly select one row per group
  3. Subsetting data.table set by date range in R
  4. Subset data.table by logical column
  5. Filter data.frame rows by a logical condition
  6. Is there a dplyr equivalent to data.table::rleid?
  7. Assign multiple columns using := in data.table, by group
  8. Efficient way to rbind data.frames with different columns
  9. How to replace NA values in a table for selected columns
  10. data.table “key indices” or “group counter”
  11. Select subset of columns in data.table R [duplicate]
  12. Subset with unique cases, based on multiple columns
  13. R: data.table cross-join not working
  14. Why is allow.cartesian required at times when when joining data.tables with duplicate keys?
  15. Dynamically build call for lookup multiple columns
  16. Add a row by reference at the end of a data.table object
  17. How to speed up subset by groups
  18. Subsetting data.table by 2nd column only of a 2 column key, using binary search not vector scan
  19. Using dynamic column names in `data.table`
  20. Conditional binary join and update by reference using the data.table package
  21. How does one change the levels of a factor column in a data.table
  22. When should I use setDT() instead of data.table() to create a data.table?
  23. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  24. In R data.table, how do I pass variable parameters to an expression?
  25. Return df with a columns values that occur more than once [duplicate]
  26. Undefined columns selected when subsetting data frame
  27. assigning by reference into loaded package datasets
  28. calculating sum of previous 3 rows in R data.table (by grid-square)
  29. How to get all possible subsets of a character vector in R?
  30. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter

Leave a Comment