Modifier and Type | Method and Description |
---|---|
Table |
Summarizer.apply()
Returns the result of applying to the functions to all the values in the appropriate column
TODO add a test that uses a non numeric return type with apply
|
Table |
Summarizer.by(CategoricalColumn<?>... columns) |
Table |
Summarizer.by(String... columnNames) |
Table |
Summarizer.by(String groupNameTemplate,
int step) |
static Table |
CrossTab.columnPercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the column percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.columnPercents(Table table,
String column1,
String column2)
Returns a table containing the column percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.counts(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing two-dimensional cross-tabulated counts for each combination of values in
column1 and column2 |
static Table |
CrossTab.counts(Table table,
String columnName) |
static Table |
CrossTab.percents(Table table,
String column1) |
static Table |
PivotTable.pivot(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumberColumn<?> values,
AggregateFunction<?,?> aggregateFunction) |
static Table |
CrossTab.rowPercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the row percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.rowPercents(Table table,
String column1,
String column2)
Returns a table containing the row percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.tablePercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the table percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.tablePercents(Table table,
String column1,
String column2)
Returns a table containing the table percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
Modifier and Type | Method and Description |
---|---|
static Table |
CrossTab.columnPercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the column percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.columnPercents(Table table,
String column1,
String column2)
Returns a table containing the column percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.counts(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing two-dimensional cross-tabulated counts for each combination of values in
column1 and column2 |
static Table |
CrossTab.counts(Table table,
String columnName) |
static Table |
CrossTab.percents(Table table,
String column1) |
static Table |
PivotTable.pivot(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumberColumn<?> values,
AggregateFunction<?,?> aggregateFunction) |
static Table |
CrossTab.rowPercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the row percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.rowPercents(Table table,
String column1,
String column2)
Returns a table containing the row percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.tablePercents(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2)
Returns a table containing the table percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
static Table |
CrossTab.tablePercents(Table table,
String column1,
String column2)
Returns a table containing the table percents made from a source table, after first calculating the counts
cross-tabulated from the given columns
|
Constructor and Description |
---|
Summarizer(Table sourceTable,
Column<?> column,
AggregateFunction<?,?>... functions)
Returns an object capable of summarizing the given column in the given sourceTable,
by applying the given functions
|
Summarizer(Table sourceTable,
Column<?> column1,
Column<?> column2,
AggregateFunction<?,?>... functions)
Returns an object capable of summarizing the given columns in the given sourceTable,
by applying the given functions
|
Summarizer(Table sourceTable,
Column<?> column1,
Column<?> column2,
Column<?> column3,
AggregateFunction<?,?>... functions)
Returns an object capable of summarizing the given column2 in the given sourceTable,
by applying the given functions
|
Summarizer(Table sourceTable,
Column<?> column1,
Column<?> column2,
Column<?> column3,
Column<?> column4,
AggregateFunction<?,?>... functions)
Returns an object capable of summarizing the given columns in the given sourceTable,
by applying the given functions
|
Summarizer(Table sourceTable,
List<String> columnNames,
AggregateFunction<?,?>... functions)
Returns an object capable of summarizing the given column in the given sourceTable,
by applying the given functions
|
Modifier and Type | Method and Description |
---|---|
Table |
Table.addColumns(Column<?>... cols)
Adds the given column to this table
|
Table |
Table.append(Table tableToAppend) |
Table |
Table.concat(Table tableToConcatenate)
Add all the columns of tableToConcatenate to this table
Note: The columns in the result must have unique names, when compared case insensitive
Note: Both tables must have the same number of rows
|
Table |
Table.copy()
Returns a table with the same columns as this table
|
Table |
Table.countBy(CategoricalColumn<?> groupingColumn)
Returns a table containing two columns, the grouping column, and a column named "Count" that contains
the counts for each grouping column value
|
Table |
LongColumn.countByCategory() |
default Table |
CategoricalColumn.countByCategory() |
Table |
StringColumn.countByCategory() |
static Table |
Table.create(String tableName)
Returns a new, empty table (without rows or columns) with the given name
|
static Table |
Table.create(String tableName,
Column<?>... columns)
Returns a new table with the given columns and given name
|
Table |
Table.dropDuplicateRows()
Returns the unique records in this table
Note: Uses a lot of memory for a sort
|
Table |
Table.dropRange(int rowStart,
int rowEnd) |
Table |
Table.dropRows(int... rowNumbers) |
Table |
Table.dropRowsWithMissingValues()
Returns only those records in this table that have no columns with missing values
|
Table |
Table.dropWhere(Selection selection) |
Table |
Table.emptyCopy()
Returns a table with the same columns as this table, but no data
|
Table |
Table.emptyCopy(int rowSize)
Returns a table with the same columns as this table, but no data, initialized to the given row size
|
Table |
Table.first(int nRows)
Returns a new table containing the first
nrows of data in this table |
Table |
Table.inRange(int rowStart,
int rowEnd) |
Table |
Table.insertColumn(int index,
Column<?> column)
Adds the given column to this table at the given position in the column list
|
Table |
Table.last(int nRows)
Returns a new table containing the last
nrows of data in this table |
Table |
Table.missingValueCounts() |
Table |
Table.pivot(CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumberColumn<?> column3,
AggregateFunction<?,?> aggregateFunction)
Returns a pivot on this table, where:
The first column contains unique values from the index column1
There are n additional columns, one for each unique value in column2
The values in each of the cells in these new columns are the result of applying the given AggregateFunction
to the data in column3, grouped by the values of column1 and column2
|
Table |
Table.pivot(String column1Name,
String column2Name,
String column3Name,
AggregateFunction<?,?> aggregateFunction)
Returns a pivot on this table, where:
The first column contains unique values from the index column1
There are n additional columns, one for each unique value in column2
The values in each of the cells in these new columns are the result of applying the given AggregateFunction
to the data in column3, grouped by the values of column1 and column2
|
Table |
Table.removeColumns(Column<?>... columns)
Removes the given columns
|
Table |
Table.removeColumnsWithMissingValues()
Removes the given columns with missing values
|
Table |
Table.replaceColumn(int colIndex,
Column<?> newColumn)
Replaces an existing column (by index) in this table with the given new column
|
Table |
Table.replaceColumn(String columnName,
Column<?> newColumn)
Replaces an existing column (by name) in this table with the given new column
|
Table |
Table.retainColumns(Column<?>... columns)
Removes all columns except for those given in the argument from this table
|
Table |
Table.retainColumns(String... columnNames)
Removes all columns except for those given in the argument from this table
|
Table |
Table.rows(int... rowNumbers) |
Table |
Table.sampleN(int nRows)
Returns a table consisting of randomly selected records from this table
|
Table[] |
Table.sampleSplit(double table1Proportion)
Splits the table into two, randomly assigning records to each according to the proportion given in
trainingProportion
|
Table |
Table.sampleX(double proportion)
Returns a table consisting of randomly selected records from this table.
|
Table |
Table.select(Column<?>... columns) |
Table |
Table.select(String... columnNames) |
Table |
Table.setName(String name)
Sets the name of the table
|
Table |
Table.sortAscendingOn(String... columnNames)
Returns a copy of this table sorted in the order of the given column names, in ascending order
|
Table |
Table.sortDescendingOn(String... columnNames)
Returns a copy of this table sorted on the given column names, applied in order, descending
TODO: Provide equivalent methods naming columns by index
|
Table |
Table.sortOn(Comparator<Row> rowComparator)
Returns a copy of this table sorted using the given comparator
|
Table |
Table.sortOn(int... columnIndexes)
Sorts this table into a new table on the columns indexed
|
Table |
Table.sortOn(Sort key) |
Table |
Table.sortOn(String... columnNames)
Returns a copy of this table sorted on the given column names, applied in order,
|
Table |
Table.structure() |
Table |
BooleanColumn.summary() |
Table |
DateColumn.summary()
Returns a table of dates and the number of observations of those dates
|
Table |
TextColumn.summary() |
Table |
DateTimeColumn.summary() |
default Table |
NumericColumn.summary() |
Table |
StringColumn.summary() |
Table |
TimeColumn.summary() |
Table |
Table.where(Selection selection) |
Table |
Table.xTabColumnPercents(String column1Name,
String column2Name) |
Table |
Table.xTabCounts(String column1Name)
Returns a table with two columns, the first contains a value each unique value in the argument,
and the second contains the number of observations of each value
|
Table |
Table.xTabCounts(String column1Name,
String column2Name)
Returns a table with n by m + 1 cells.
|
Table |
Table.xTabPercents(String column1Name)
Returns a table with two columns, the first contains a value each unique value in the argument,
and the second contains the proportion of observations having that value
|
Table |
Table.xTabRowPercents(String column1Name,
String column2Name) |
Table |
Table.xTabTablePercents(String column1Name,
String column2Name)
Returns a table with n by m + 1 cells.
|
Modifier and Type | Method and Description |
---|---|
void |
Table.addRow(int rowIndex,
Table sourceTable)
Adds a single row to this table from sourceTable, copying every column in sourceTable
|
Table |
Table.append(Table tableToAppend) |
Table |
Table.concat(Table tableToConcatenate)
Add all the columns of tableToConcatenate to this table
Note: The columns in the result must have unique names, when compared case insensitive
Note: Both tables must have the same number of rows
|
Constructor and Description |
---|
Row(Table table) |
Modifier and Type | Method and Description |
---|---|
Table |
Column.summary() |
Modifier and Type | Method and Description |
---|---|
Table |
Stats.asTable() |
Table |
Stats.asTableComplete() |
Modifier and Type | Method and Description |
---|---|
Table |
IntDictionaryMap.countByCategory(String columnName) |
Table |
ByteDictionaryMap.countByCategory(String columnName) |
Table |
DictionaryMap.countByCategory(String columnName) |
Table |
ShortDictionaryMap.countByCategory(String columnName) |
Modifier and Type | Method and Description |
---|---|
Table |
DataFrameReader.csv(CsvReadOptions.Builder options) |
Table |
DataFrameReader.csv(CsvReadOptions options) |
Table |
DataFrameReader.csv(File file) |
Table |
DataFrameReader.csv(InputStream stream,
String tableName) |
Table |
DataFrameReader.csv(Reader reader,
String tableName) |
Table |
DataFrameReader.csv(String file) |
Table |
DataFrameReader.csv(String contents,
String tableName) |
Table |
DataFrameReader.db(ResultSet resultSet,
String tableName) |
Table |
DataFrameReader.html(String url) |
Constructor and Description |
---|
DataFrameWriter(Table table) |
Modifier and Type | Method and Description |
---|---|
Table |
CsvWriter.getTable() |
Table |
CsvReader.headerOnly(ColumnType[] types,
boolean header,
CsvReadOptions options,
File file)
Returns a Table constructed from a CSV File with the given file name
|
Table |
CsvReader.read(CsvReadOptions options) |
Constructor and Description |
---|
CsvWriter(Table table,
CsvWriteOptions options)
Private constructor to prevent instantiation
|
Modifier and Type | Method and Description |
---|---|
static String |
HtmlTableWriter.write(Table table) |
static void |
HtmlTableWriter.write(Table table,
OutputStream outputStream) |
Modifier and Type | Method and Description |
---|---|
static Table |
SqlResultSetReader.read(ResultSet resultSet,
String tableName)
Returns a new table with the given tableName, constructed from the given result set
|
Modifier and Type | Method and Description |
---|---|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.fullOuter(Table... tables)
Full outer join to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.inner(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.inner(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.leftOuter(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.leftOuter(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.rightOuter(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.rightOuter(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.rightOuter(Table table2,
String[] col2Names)
Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
|
Modifier and Type | Method and Description |
---|---|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.fullOuter(Table... tables)
Full outer join to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.inner(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.inner(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.leftOuter(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.leftOuter(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.rightOuter(boolean allowDuplicateColumnNames,
Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.rightOuter(Table... tables)
Joins to the given tables assuming that they have a column of the name we're joining on
|
Table |
DataFrameJoiner.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 |
DataFrameJoiner.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 |
DataFrameJoiner.rightOuter(Table table2,
String[] col2Names)
Joins the joiner to the table2, using the given columns for the second table and returns the resulting table
|
Constructor and Description |
---|
DataFrameJoiner(Table table,
String... columnNames)
Constructor.
|
Modifier and Type | Method and Description |
---|---|
static IntComparatorChain |
SortUtils.getChain(Table table,
Sort key)
Returns a comparator chain for sorting according to the given key
|
static it.unimi.dsi.fastutil.ints.IntComparator |
SortUtils.getComparator(Table table,
Sort key)
Returns a comparator that can be used to sort the records in this table according to the given sort key
|
Modifier and Type | Method and Description |
---|---|
Table |
TableSliceGroup.aggregate(com.google.common.collect.ListMultimap<String,AggregateFunction<?,?>> functions)
Applies the given aggregations to the given columns.
|
Table |
TableSliceGroup.aggregate(String colName1,
AggregateFunction<?,?>... functions)
Applies the given aggregation to the given column.
|
Table |
TableSlice.asTable() |
abstract Table |
Relation.first(int nRows) |
Table |
TableSlice.first(int nRows) |
Table |
TableSliceGroup.getSourceTable() |
Table |
Relation.structure() |
static Table |
TableSliceGroup.summaryTableName(Table source) |
Modifier and Type | Method and Description |
---|---|
List<Table> |
TableSliceGroup.asTableList()
Returns a list of Tables created by reifying my list of slices (views) over the original table
|
Modifier and Type | Method and Description |
---|---|
static void |
Rows.appendRowToTable(int row,
Table oldTable,
Table newTable) |
static boolean |
Rows.compareRows(int rowInOriginal,
Table original,
Table tempTable) |
static void |
Rows.copyRowsToTable(int[] rows,
Table oldTable,
Table newTable)
Copies the rows indicated by the row index values in the given array from oldTable to newTable
|
static void |
Rows.copyRowsToTable(Selection rows,
Table oldTable,
Table newTable)
Copies the rows indicated by the row index values in the given selection from oldTable to newTable
|
static StandardTableSliceGroup |
StandardTableSliceGroup.create(Table original,
CategoricalColumn<?>... columns)
Returns a viewGroup splitting the original table on the given columns.
|
static StandardTableSliceGroup |
StandardTableSliceGroup.create(Table original,
String... columnsNames)
Returns a viewGroup splitting the original table on the given columns.
|
static SelectionTableSliceGroup |
SelectionTableSliceGroup.create(Table original,
String subTableNameTemplate,
int step) |
static void |
Rows.head(int rowCount,
Table oldTable,
Table newTable) |
static Table |
TableSliceGroup.summaryTableName(Table source) |
static void |
Rows.tail(int rowsToInclude,
Table oldTable,
Table newTable) |
Constructor and Description |
---|
TableSlice(Table table,
Selection rowSelection)
Returns a new View constructed from the given table, containing only the rows represented by the bitmap
|
TableSliceGroup(Table original)
Returns an instance for calculating a single summary for the given table, with no sub-groupings
|
TableSliceGroup(Table sourceTable,
String[] groupColumnNames)
Returns an instance for calculating subgroups,
one for each combination of the given groupColumnNames that appear in the source table
|
Copyright © 2019. All rights reserved.