tech.tablesaw.joining

Class DataFrameJoiner

java.lang.Object

tech.tablesaw.joining.DataFrameJoiner

public class DataFrameJoiner
extends Object

Constructor Summary

Constructors

Constructor and Description
DataFrameJoiner(Table table, String column)

Method Summary

Modifier and Type	Method and Description
Table	fullOuter(boolean allowDuplicateColumnNames, Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	fullOuter(Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	fullOuter(Table table2, String col2Name) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	fullOuter(Table table2, String col2Name, boolean allowDuplicateColumnNames) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	inner(boolean allowDuplicateColumnNames, Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	inner(Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	inner(Table table2, String col2Name) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	inner(Table table2, String col2Name, boolean allowDuplicateColumnNames) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	leftOuter(boolean allowDuplicateColumnNames, Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	leftOuter(Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	leftOuter(Table table2, String col2Name) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	leftOuter(Table table2, String col2Name, boolean allowDuplicateColumnNames) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	rightOuter(boolean allowDuplicateColumnNames, Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	rightOuter(Table... tables) Joins to the given tables assuming that they have a column of the name we're joining on
Table	rightOuter(Table table2, String col2Name) Joins the joiner to the table2, using the given column for the second table and returns the resulting table
Table	rightOuter(Table table2, String col2Name, boolean allowDuplicateColumnNames) Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DataFrameJoiner

public DataFrameJoiner(Table table,
                       String column)

Method Detail

inner

public Table inner(Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

tables - The tables to join with

inner

public Table inner(boolean allowDuplicateColumnNames,
                   Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed*

tables - The tables to join with

inner

public Table inner(Table table2,
                   String col2Name)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

inner

public Table inner(Table table2,
                   String col2Name,
                   boolean allowDuplicateColumnNames)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed*

fullOuter

public Table fullOuter(Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

tables - The tables to join with

fullOuter

public Table fullOuter(boolean allowDuplicateColumnNames,
                       Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed*

tables - The tables to join with

fullOuter

public Table fullOuter(Table table2,
                       String col2Name)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

fullOuter

public Table fullOuter(Table table2,
                       String col2Name,
                       boolean allowDuplicateColumnNames)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed

leftOuter

public Table leftOuter(Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

tables - The tables to join with

leftOuter

public Table leftOuter(boolean allowDuplicateColumnNames,
                       Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed*

tables - The tables to join with

leftOuter

public Table leftOuter(Table table2,
                       String col2Name)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

leftOuter

public Table leftOuter(Table table2,
                       String col2Name,
                       boolean allowDuplicateColumnNames)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed

rightOuter

public Table rightOuter(Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

tables - The tables to join with

rightOuter

public Table rightOuter(boolean allowDuplicateColumnNames,
                        Table... tables)

Joins to the given tables assuming that they have a column of the name we're joining on

Parameters:

tables - The tables to join with

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed

rightOuter

public Table rightOuter(Table table2,
                        String col2Name)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

rightOuter

public Table rightOuter(Table table2,
                        String col2Name,
                        boolean allowDuplicateColumnNames)

Joins the joiner to the table2, using the given column for the second table and returns the resulting table

Parameters:

table2 - The table to join with

col2Name - The column to join on. If col2Name refers to a double column, the join is performed after rounding to integers.

allowDuplicateColumnNames - if false the join will fail if any columns other than the join column have the same name if true the join will succeed and duplicate columns are renamed