samyishak
3/1/2017 - 5:27 PM

data.table joins

data.table joins

library(data.table)

# left join, subsetting left table, on different column names
right_DT[1:100,
         .(right_id, right_cols_ls)
         ][left_DT[1:10,
                   .(left_id, left_cols_ls)
                   ],
           on = c(right_id = 'left_id')]