Select multiple columns in data.table by their numeric indices

by

For versions of data.table >= 1.9.8, the following all just work:

library(data.table)
dt <- data.table(a = 1, b = 2, c = 3)

# select single column by index
dt[, 2]
#    b
# 1: 2

# select multiple columns by index
dt[, 2:3]
#    b c
# 1: 2 3

# select single column by name
dt[, "a"]
#    a
# 1: 1

# select multiple columns by name
dt[, c("a", "b")]
#    a b
# 1: 1 2

For versions of data.table < 1.9.8 (for which numerical column selection required the use of with = FALSE), see this previous version of this answer. See also NEWS on v1.9.8, POTENTIALLY BREAKING CHANGES, point 3.

More Related Contents:

  1. data.table vs dplyr: can one do something well the other can’t or does poorly?
  2. How to delete a row by reference in data.table?
  3. Why does X[Y] join of data.tables not allow a full outer join, or a left join?
  4. dplyr mutate/replace several columns on a subset of rows
  5. Proper/fastest way to reshape a data.table
  6. Filtering out duplicated/non-unique rows in data.table
  7. data.table with two string columns of set elements, extract unique rows with each row unsorted
  8. Evaluating both column name and the target value within `j` expression within `data.table`
  9. Fill in missing values by group in data.table
  10. dplyr on data.table, am I really using data.table?
  11. data.table and parallel computing
  12. Elegantly assigning multiple columns in data.table with lapply()
  13. Sort a data.table fast by Ascending/Descending order
  14. No RTools compatible with R version 3.5.0 was found
  15. Join R data.tables where key values are not exactly equal–combine rows with closest times
  16. how to show a legend on dual y-axis ggplot
  17. Why is as.Date slow on a character vector?
  18. Cleaning `Inf` values from an R dataframe
  19. How to group data.table by multiple columns?
  20. can the value.var in dcast be a list or have multiple value variables?
  21. Apply a function to a subset of data.table columns, by column-indices instead of name
  22. Selecting a subset of columns in a data.table
  23. grouped operations that result in length not equal to 1 or length of group in dplyr
  24. Merge overlapping ranges into unique groups, in dataframe
  25. add missing rows to a data table
  26. Convert a data frame to a data.table without copy
  27. Row sums over columns with a certain pattern in their name
  28. paste two data.table columns
  29. Removing multiple columns from R data.table with parameter for columns to remove
  30. Fill option for fread

Leave a Comment