Modifier and Type | Method | Description |
---|---|---|
Table |
Summarizer.apply() |
Returns the result of applying to the functions to all the values in the appropriate column
|
Table |
Summarizer.by(String... columnNames) |
|
Table |
Summarizer.by(String groupNameTemplate,
int step) |
|
Table |
Summarizer.by(CategoricalColumn... 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.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.counts(Table table,
String columnName) |
|
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.percents(Table table,
String column1) |
|
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.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.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
|
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
|
Modifier and Type | Method | Description |
---|---|---|
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.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.counts(Table table,
String columnName) |
|
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.percents(Table table,
String column1) |
|
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.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.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
|
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
|
Constructor | Description |
---|---|
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
|
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
|
Modifier and Type | Method | 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
|
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(Filter filter) |
|
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(String... columnNames) |
Removes all columns except for those given in the argument from this table
|
Table |
Table.retainColumns(Column... columns) |
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(String... columnNames) |
|
Table |
Table.select(Column... columns) |
|
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(int... columnIndexes) |
Sorts this table into a new table on the columns indexed in ascending order
|
Table |
Table.sortOn(String... columnNames) |
Returns a copy of this table sorted on the given column names, applied in order,
|
Table |
Table.sortOn(Comparator<Row> rowComparator) |
Returns a copy of this table sorted using the given comparator
|
Table |
Table.sortOn(Sort key) |
|
Table |
Table.structure() |
|
Table |
BooleanColumn.summary() |
|
Table |
DateColumn.summary() |
Returns a table of dates and the number of observations of those dates
|
Table |
DateTimeColumn.summary() |
|
Table |
DoubleColumn.summary() |
|
Table |
NumberColumn.summary() |
|
Table |
StringColumn.summary() |
|
Table |
TimeColumn.summary() |
|
Table |
Table.where(Filter filter) |
|
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 | 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
|
Modifier and Type | Method | Description |
---|---|---|
Table |
Column.summary() |
Modifier and Type | Method | Description |
---|---|---|
Selection |
IsFalse.apply(Table relation) |
|
Selection |
IsTrue.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
BetweenExclusive.apply(Table relation) |
|
Selection |
BetweenInclusive.apply(Table relation) |
|
Selection |
EqualTo.apply(Table relation) |
|
Selection |
IsAfter.apply(Table relation) |
|
Selection |
IsBefore.apply(Table relation) |
|
Selection |
IsOnOrAfter.apply(Table relation) |
|
Selection |
IsOnOrBefore.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
EqualTo.apply(Table relation) |
|
Selection |
IsAfter.apply(Table relation) |
|
Selection |
IsBefore.apply(Table relation) |
|
Selection |
IsFirstDayOfTheMonth.apply(Table relation) |
|
Selection |
IsFriday.apply(Table relation) |
|
Selection |
IsInApril.apply(Table relation) |
|
Selection |
IsInAugust.apply(Table relation) |
|
Selection |
IsInDecember.apply(Table relation) |
|
Selection |
IsInFebruary.apply(Table relation) |
|
Selection |
IsInJanuary.apply(Table relation) |
|
Selection |
IsInJuly.apply(Table relation) |
|
Selection |
IsInJune.apply(Table relation) |
|
Selection |
IsInMarch.apply(Table relation) |
|
Selection |
IsInMay.apply(Table relation) |
|
Selection |
IsInNovember.apply(Table relation) |
|
Selection |
IsInOctober.apply(Table relation) |
|
Selection |
IsInQ1.apply(Table relation) |
|
Selection |
IsInQ2.apply(Table relation) |
|
Selection |
IsInQ3.apply(Table relation) |
|
Selection |
IsInQ4.apply(Table relation) |
|
Selection |
IsInSeptember.apply(Table relation) |
|
Selection |
IsInYear.apply(Table relation) |
|
Selection |
IsLastDayOfTheMonth.apply(Table relation) |
|
Selection |
IsMonday.apply(Table relation) |
|
Selection |
IsOnOrAfter.apply(Table relation) |
|
Selection |
IsOnOrBefore.apply(Table relation) |
|
Selection |
IsSaturday.apply(Table relation) |
|
Selection |
IsSunday.apply(Table relation) |
|
Selection |
IsThursday.apply(Table relation) |
|
Selection |
IsTuesday.apply(Table relation) |
|
Selection |
IsWednesday.apply(Table relation) |
|
Selection |
NotEqualTo.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Table |
Stats.asTable() |
|
Table |
Stats.asTableComplete() |
Modifier and Type | Method | Description |
---|---|---|
Selection |
BetweenExclusive.apply(Table relation) |
|
Selection |
BetweenInclusive.apply(Table relation) |
|
Selection |
EqualTo.apply(Table relation) |
|
Selection |
GreaterThan.apply(Table relation) |
|
Selection |
GreaterThanOrEqualTo.apply(Table relation) |
|
Selection |
IsCloseTo.apply(Table relation) |
|
Selection |
IsIn.apply(Table relation) |
|
Selection |
IsNegative.apply(Table relation) |
|
Selection |
IsNonNegative.apply(Table relation) |
|
Selection |
IsNotIn.apply(Table relation) |
|
Selection |
IsPositive.apply(Table relation) |
|
Selection |
IsZero.apply(Table relation) |
|
Selection |
LessThan.apply(Table relation) |
|
Selection |
LessThanOrEqualTo.apply(Table relation) |
|
Selection |
NotEqualTo.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
ContainsString.apply(Table relation) |
|
Selection |
EndsWith.apply(Table relation) |
|
Selection |
EqualTo.apply(Table relation) |
|
Selection |
EqualToIgnoringCase.apply(Table relation) |
|
Selection |
HasLengthEqualTo.apply(Table relation) |
|
Selection |
IsAlpha.apply(Table relation) |
|
Selection |
IsAlphaNumeric.apply(Table relation) |
|
Selection |
IsEmptyString.apply(Table relation) |
|
Selection |
IsIn.apply(Table relation) |
|
Selection |
IsLongerThan.apply(Table relation) |
|
Selection |
IsLowerCase.apply(Table relation) |
|
Selection |
IsNotIn.apply(Table relation) |
|
Selection |
IsNumeric.apply(Table relation) |
|
Selection |
IsShorterThan.apply(Table relation) |
|
Selection |
IsUpperCase.apply(Table relation) |
|
Selection |
MatchesRegex.apply(Table relation) |
|
Selection |
NotEqualTo.apply(Table relation) |
|
Selection |
StartsWith.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
EqualTo.apply(Table relation) |
|
Selection |
IsAfter.apply(Table relation) |
|
Selection |
IsAfterNoon.apply(Table relation) |
|
Selection |
IsBefore.apply(Table relation) |
|
Selection |
IsBeforeNoon.apply(Table relation) |
|
Selection |
IsMidnight.apply(Table relation) |
|
Selection |
IsNoon.apply(Table relation) |
|
Selection |
IsOnOrAfter.apply(Table relation) |
|
Selection |
IsOnOrBefore.apply(Table relation) |
|
Selection |
NotEqualTo.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
Filter.apply(Table relation) |
|
Selection |
IsMissing.apply(Table relation) |
|
Selection |
IsNotMissing.apply(Table relation) |
|
Selection |
TwoColumnFilter.apply(Table relation) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
AllOf.apply(Table relation) |
|
Selection |
AnyOf.apply(Table relation) |
|
Selection |
IsFalse.apply(Table relation) |
Returns true if the element in the given row in my
column is true |
Selection |
IsTrue.apply(Table relation) |
Returns true if the element in the given row in my
column is true |
Modifier and Type | Method | Description |
---|---|---|
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.csv(CsvReadOptions options) |
|
Table |
DataFrameReader.csv(CsvReadOptions.Builder options) |
|
Table |
DataFrameReader.db(ResultSet resultSet,
String tableName) |
|
Table |
DataFrameReader.html(String url) |
Constructor | Description |
---|---|
DataFrameWriter(Table table) |
Modifier and Type | Method | Description |
---|---|---|
static Table |
CsvReader.headerOnly(ColumnType[] types,
boolean header,
char columnSeparator,
File file) |
Returns a Table constructed from a CSV File with the given file name
|
static Table |
CsvReader.read(CsvReadOptions options) |
Modifier and Type | Method | Description |
---|---|---|
static void |
CsvWriter.write(Table table,
CsvWriteOptions options) |
Writes the given table to a file
|
Modifier and Type | Method | Description |
---|---|---|
static String |
HtmlTableWriter.write(Table table) |
|
static void |
HtmlTableWriter.write(Table table,
OutputStream outputStream) |
Modifier and Type | Method | 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 | Description |
---|---|---|
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.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.rightOuter(Table table2,
String col2Name) |
Joins the joiner to the table2, using the given column for the second table and returns the resulting table
|
Modifier and Type | Method | Description |
---|---|---|
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.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.rightOuter(Table table2,
String col2Name) |
Joins the joiner to the table2, using the given column for the second table and returns the resulting table
|
Constructor | Description |
---|---|
DataFrameJoiner(Table table,
String column) |
Modifier and Type | Method | Description |
---|---|---|
default Selection |
Selection.apply(Table relation) |
Modifier and Type | Method | 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 | 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() |
|
Table |
Projection.first(int nRows) |
|
abstract Table |
Relation.first(int nRows) |
|
Table |
TableSlice.first(int nRows) |
|
Table |
TableSliceGroup.getSourceTable() |
|
Table |
Relation.structure() |
|
static Table |
TableSliceGroup.summaryTableName(Table source) |
|
Table |
Projection.where(Filter filter) |
Modifier and Type | Method | 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 | 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(it.unimi.dsi.fastutil.ints.IntArrayList rows,
Table oldTable,
Table newTable) |
|
static void |
Rows.copyRowsToTable(Selection rows,
Table oldTable,
Table newTable) |
|
static SelectionTableSliceGroup |
SelectionTableSliceGroup.create(Table original,
String subTableNameTemplate,
int step) |
|
static StandardTableSliceGroup |
StandardTableSliceGroup.create(Table original,
String... columnsNames) |
Returns a viewGroup splitting the original table on the given columns.
|
static StandardTableSliceGroup |
StandardTableSliceGroup.create(Table original,
CategoricalColumn... columns) |
Returns a viewGroup splitting the original table on the given columns.
|
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 | Description |
---|---|
Projection(Table table,
String[] columnNames) |
|
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.