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... columnNames) Constructor.

Method Summary

Modifier and Type	Method and Description
Table	fullOuter(boolean allowDuplicateColumnNames, Table... tables) Full outer join to the given tables assuming that they have a column of the name we're joining on
Table	fullOuter(Table... tables) Full outer join to the given tables assuming that they have a column of the name we're joining on
Table	fullOuter(Table table2, String col2Name) Full outer join the joiner to the table2, using the given column for the second table and returns the resulting table
Table	fullOuter(Table table1, Table table2, boolean allowDuplicateColumnNames, String... col2Names) Full outer join table1 to table2, using the given columns 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, boolean outer, boolean allowDuplicateColumnNames, String... col2Names) Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
Table	inner(Table table2, boolean allowDuplicateColumnNames, String... col2Names) Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
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[] col2Names) Joins the joiner to the table2, using the given columns 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, boolean allowDuplicateColumnNames, String... col2Names) Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
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[] col2Names) Joins the joiner to the table2, using the given columns 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, boolean allowDuplicateColumnNames, String... col2Names) Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
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[] col2Names) Joins the joiner to the table2, using the given columns 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... columnNames)

Constructor.

Parameters:

table - The table to join on

columnNames - The column names to join on

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.

Returns:

The resulting table

inner

public Table inner(Table table2,
                   String[] col2Names)

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

Parameters:

table2 - The table to join with

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

Returns:

The resulting table

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*

Returns:

The resulting table

inner

public Table inner(Table table2,
                   boolean allowDuplicateColumnNames,
                   String... col2Names)

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

Parameters:

table2 - The table 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*

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

Returns:

The resulting table

inner

public Table inner(Table table2,
                   boolean outer,
                   boolean allowDuplicateColumnNames,
                   String... col2Names)

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

Parameters:

table2 - The table to join with

outer - True if this join is actually an outer join, left or right or full, otherwise false.

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*

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

Returns:

The resulting table

fullOuter

public Table fullOuter(Table... tables)

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

Parameters:

tables - The tables to join with

Returns:

The resulting table

fullOuter

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

Full outer join 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

Returns:

The resulting table

fullOuter

public Table fullOuter(Table table2,
                       String col2Name)

Full outer join 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.

Returns:

The resulting table

fullOuter

public Table fullOuter(Table table1,
                       Table table2,
                       boolean allowDuplicateColumnNames,
                       String... col2Names)

Full outer join table1 to table2, using the given columns for the second table and returns the resulting table

Parameters:

table1 - The base table to join on

table2 - The table 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*

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

Returns:

The resulting table

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

Returns:

The resulting table

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

Returns:

The resulting table

leftOuter

public Table leftOuter(Table table2,
                       String[] col2Names)

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

Parameters:

table2 - The table to join with

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

Returns:

The resulting table

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.

Returns:

The resulting table

leftOuter

public Table leftOuter(Table table2,
                       boolean allowDuplicateColumnNames,
                       String... col2Names)

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

Parameters:

table2 - The table 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

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

Returns:

The resulting table

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

Returns:

The resulting table

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:

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

Returns:

The resulting table

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.

Returns:

The resulting table

rightOuter

public Table rightOuter(Table table2,
                        String[] col2Names)

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

Parameters:

table2 - The table to join with

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

Returns:

The resulting table

rightOuter

public Table rightOuter(Table table2,
                        boolean allowDuplicateColumnNames,
                        String... col2Names)

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

Parameters:

table2 - The table 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

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

Returns:

The resulting table