Conditional binary join and update by reference using the data.table package

by

Copying from Arun’s updated answer here

TK[venue_id %in% 1:2, New_id := DFT[.SD, New_id]][]
#    venue_id DFT_id New_id
# 1:        1      1      3
# 2:        2      1      3
# 3:        1      2      4
# 4:        3      2   9401
# 5:        2      3      2
# 6:        3      3    456

His answer gives the details of what is going on.

More Related Contents:

  1. Overlap join with start and end positions
  2. Left join using data.table
  3. Why does X[Y] join of data.tables not allow a full outer join, or a left join?
  4. data.table join then add columns to existing data.frame without re-copy
  5. R: data.table cross-join not working
  6. Rolling join on data.table with duplicate keys
  7. Update subset of data.table based on join
  8. Non-equi join using data.table: column missing from the output
  9. rolling joins data.table in R
  10. Merging multiple data.tables
  11. data.table vs dplyr: can one do something well the other can’t or does poorly?
  12. How to delete a row by reference in data.table?
  13. dplyr mutate/replace several columns on a subset of rows
  14. Proper/fastest way to reshape a data.table
  15. Creating dummy variables in R data.table
  16. How to reorder data.table columns (without copying)
  17. Using setDT inside a function
  18. How to add a index by set of data when using rbindlist?
  19. Dynamically add column names to data.table when aggregating
  20. R: Reshaping Multiple Columns from Long to Wide
  21. Long Numbers As A Character String
  22. How to group data.table by multiple columns?
  23. Apply a function to a subset of data.table columns, by column-indices instead of name
  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