In order to do anything effectively with data, us SQL-minded folks need our joins. nD has joining capabilities just like SQL, and here is the syntax for joining two data frames (like tables): DT1{Column1, Column2}, DT2{Column3,Column4}

Inner join:

DT1.join(DT2, DT1.Column1 == DT2.Column3)

Outer join:

DT1.outerJoin(DT2, DT1.Column1 == DT2.Column3)

Left outer join:

DT1.leftOuterJoin(DT2, DT1.Column1 == DT2.Column3)

Right outer join:

DT1.rightOuterJoin(DT2, DT1.Column1 == DT2.Column3)
Advertisements