Skip to contents

The fjoin_* family

Data frame joins in a familiar x/y style

True joins

fjoin_inner()
Inner join
fjoin_left()
Left join
fjoin_right()
Right join
fjoin_full()
Full join

Semi-joins

fjoin_left_semi() fjoin_semi()
Left semi-join
fjoin_right_semi()
Right semi-join

Anti-joins

fjoin_left_anti() fjoin_anti()
Left anti-join
fjoin_right_anti()
Right anti-join

Cross-joins

fjoin_cross()
Cross join

The dtjoin_* family

An extended DT[i]-style interface for data frame joins

True joins

dtjoin()
Join data frame-like objects using an extended DT[i]-style interface to data.table

Semi-joins

dtjoin_semi()
Semi-join of DT in a DT[i]-style join of data frame-like objects

Anti-joins

dtjoin_anti()
Anti-join of DT in a DT[i]-style join of data frame-like objects

Cross joins

dtjoin_cross()
Cross join of data frame-like objects DT and i using a DT[i]-style interface to data.table