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 |
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 |
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.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 in ascending order
|
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 © 2018. All rights reserved.