Extract a column from a data.table as a vector, by position

by

A data.table inherits from class data.frame. Therefore it is a list (of column vectors) internally and can be treated as such. 

is.list(DT)
#[1] TRUE

Fortunately, list subsetting, i.e. [[, is very fast and, in contrast to [, package data.table doesn’t define a method for it. Thus, you can simply use [[ to extract by an index:

DT[[2]]
#[1] 3 4

More Related Contents:

  1. Keyed lookup on data.table without ‘with’
  2. Select / assign to data.table when variable names are stored in a character vector
  3. Is there a dplyr equivalent to data.table::rleid?
  4. How to find common elements from multiple vectors?
  5. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  6. Assign multiple columns using := in data.table, by group
  7. Efficient way to rbind data.frames with different columns
  8. How to replace NA values in a table for selected columns
  9. data.table “key indices” or “group counter”
  10. Select subset of columns in data.table R [duplicate]
  11. Finding All Positions for Multiple Elements in a Vector
  12. How to extract the first n rows per group?
  13. R: data.table cross-join not working
  14. Dynamically build call for lookup multiple columns
  15. Select values from different columns based on a variable containing column names [duplicate]
  16. Add a row by reference at the end of a data.table object
  17. Subsetting data.table using variables with same name as column
  18. Conditional binary join and update by reference using the data.table package
  19. How do you delete a column by name in data.table?
  20. How does one change the levels of a factor column in a data.table
  21. When should I use setDT() instead of data.table() to create a data.table?
  22. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  23. In R data.table, how do I pass variable parameters to an expression?
  24. Merging two sets of data by data.table roll=’nearest’ function
  25. Using data.table i and j arguments in functions
  26. R data.table breaks in exported functions
  27. Applying a function to each row of a data.table
  28. Empty factors in “by” data.table
  29. What you can do with a data.frame that you can’t with a data.table?
  30. data.table: anonymous function in j

Leave a Comment