Modifier and Type | Method | 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(int step) |
Returns a summary of the records grouped into subsets of the same size, in the order they
appear
|
Table |
Summarizer.by(String... columnNames) |
Similar in intent to the SQL "group by" statement, it produces a table with one row for each
subgroup of the output data containing the result of applying the summary functions to the
subgroup
|
Table |
Summarizer.by(CategoricalColumn<?>... columns) |
Similar in intent to the SQL "group by" statement, it produces a table with one row for each
subgroup of the output data containing the result of applying the summary functions to the
subgroup
|
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) |
Returns a Table containing counts of records in the given Table grouped by the given columnName
See also {@link Table:countBy()}
|
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 |
Table |
Summarizer.having(Function<Table,Selection> selection) |
Similar in intent to the SQL having command, it enables the user to apply a filter to the
grouped results of summary.
|
static Table |
CrossTab.percents(Table table,
String column1) |
Returns a Table containing the proportion of records in the given Table grouped by the given
column TODO: Consider renaming to proportions
|
static Table |
PivotTable.pivot(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumericColumn<?> values,
AggregateFunction<?,?> aggregateFunction) |
Returns a table that is a rotation of the given table pivoted around the key columns, and
filling the output cells using the values calculated by the
aggregateFunction when
applied to the values column grouping by the key 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.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) |
Returns a Table containing counts of records in the given Table grouped by the given columnName
See also {@link Table:countBy()}
|
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) |
Returns a Table containing the proportion of records in the given Table grouped by the given
column TODO: Consider renaming to proportions
|
static Table |
PivotTable.pivot(Table table,
CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumericColumn<?> values,
AggregateFunction<?,?> aggregateFunction) |
Returns a table that is a rotation of the given table pivoted around the key columns, and
filling the output cells using the values calculated by the
aggregateFunction when
applied to the values column grouping by the key 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.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 |
---|---|---|
Table |
Summarizer.having(Function<Table,Selection> selection) |
Similar in intent to the SQL having command, it enables the user to apply a filter to the
grouped results of summary.
|
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 |
AnalyticQuery.execute() |
Executes the query adding all the calculated columns to a new table.
|
Table |
AnalyticQuerySteps.Execute.execute() |
Executes the query adding all the calculated columns to a new table.
|
Table |
AnalyticQuery.getTable() |
The Table behind the query.
|
Modifier and Type | Method | Description |
---|---|---|
AnalyticQuerySteps.FullAnalyticQuerySteps.PartitionByStep |
AnalyticQuerySteps.FullAnalyticQuerySteps.FromStep.from(Table table) |
Set the From/Source Table name to use in the query.
|
AnalyticQuerySteps.NumberingQuerySteps.PartitionByStep |
AnalyticQuerySteps.NumberingQuerySteps.FromStep.from(Table table) |
Set the From/Source Table name to use in the query.
|
AnalyticQuerySteps.DefineWindowFame |
AnalyticQuerySteps.QuickQuerySteps.FromStep.from(Table table) |
Set the From/Source Table name to use in the query.
|
Modifier and Type | Method | Description |
---|---|---|
Table |
Table.addColumns(Column<?>... cols) |
Adds the given column to this table
|
Table |
Table.append(Row row) |
Appends the given row to this table and returns the table.
|
Table |
Table.append(Relation tableToAppend) |
Returns this table after adding the data from the argument
|
Table |
Table.cast() |
Cast implements the 'tidy' cast operation as described in these papers by Hadley Wickham:
|
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(String... categoricalColumnNames) |
Returns a table containing a column for each grouping column, and a column named "Count" that
contains the counts for each combination of grouping column values
|
Table |
Table.countBy(CategoricalColumn<?>... groupingColumns) |
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() |
Returns a count of the number of elements in each category (i.e., the number of repetitions of
each value) TODO: This needs to be well tested, especially for IntColumn
|
Table |
LongColumn.countByCategory() |
|
Table |
StringColumn.countByCategory() |
|
static Table |
Table.create() |
Returns a new, empty table (without rows or columns)
|
static Table |
Table.create(String tableName) |
Returns a new, empty table (without rows or columns) with the given name
|
static Table |
Table.create(String name,
Collection<Column<?>> columns) |
Returns a new table with the given columns and given name
|
static Table |
Table.create(String name,
Stream<Column<?>> columns) |
Returns a new table with the given columns and given name
|
static Table |
Table.create(String name,
Column<?>... columns) |
Returns a new table with the given columns and given name
|
static Table |
Table.create(Collection<Column<?>> columns) |
Returns a new table with the given columns
|
static Table |
Table.create(Stream<Column<?>> columns) |
Returns a new table with the given columns
|
static Table |
Table.create(Column<?>... columns) |
Returns a new table with the given columns
|
Table |
Table.dropDuplicateRows() |
Returns the unique records in this table Note: Uses a lot of memory for a sort
|
Table |
Table.dropRange(int rowCount) |
Returns a new table EXCLUDING the first rowCount rows if rowCount positive.
|
Table |
Table.dropRange(int rowStart,
int rowEnd) |
Returns a table EXCLUDING the rows contained in the range from rowStart inclusive to rowEnd
exclusive
|
Table |
Table.dropRows(int... rowNumbers) |
Returns a table EXCLUDING the rows contained in the given array of row indices
|
Table |
Table.dropRowsWithMissingValues() |
Returns only those records in this table that have no columns with missing values
|
Table |
Table.dropWhere(Function<Table,Selection> selection) |
Returns a new Table made by EXCLUDING any rows returned when the given function is applied to
this table
|
Table |
Table.dropWhere(Selection selection) |
Returns a table EXCLUDING the rows contained in the given 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 rowCount) |
Returns a new table containing the first rowCount rows if rowCount positive.
|
Table |
Table.inRange(int rowStart,
int rowEnd) |
Returns a new table containing the rows contained in the range from rowStart inclusive to
rowEnd exclusive
|
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.melt(List<String> idVariables,
List<NumericColumn<?>> measuredVariables,
Boolean dropMissing) |
Melt implements the 'tidy' melt operation as described in these papers by Hadley Wickham.
|
Table |
Table.missingValueCounts() |
Returns a table containing the number of missing values in each column in this table
|
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.pivot(CategoricalColumn<?> column1,
CategoricalColumn<?> column2,
NumericColumn<?> 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.rejectColumns(int... columnIndexes) |
Returns a new table containing copies of all the columns from this table, except those at the
given indexes
|
Table |
Table.rejectColumns(String... columnNames) |
Returns a new table containing copies of all the columns from this table, except those named in
the argument
|
Table |
Table.rejectColumns(Column<?>... columns) |
Returns a new table containing copies of all the columns from this table, except those named in
the argument
|
Table |
Table.removeColumns(int... columnIndexes) |
Removes the columns at the given indices from this table and returns this table
|
Table |
Table.removeColumns(String... columns) |
Removes the columns with the given names from this table and returns this table
|
Table |
Table.removeColumns(Column<?>... columns) |
Removes the given columns from this table and returns this table
|
Table |
Table.removeColumnsWithMissingValues() |
Removes all columns with missing values from this table, and returns this table.
|
Table |
Table.reorderColumns(String... columnNames) |
Return a new table (shallow copy) that contains all the columns in this table, in the order
given in the argument.
|
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.replaceColumn(Column<?> newColumn) |
Replaces an existing column having the same name of the given column with the given column
|
Table |
Table.retainColumns(int... columnIndexes) |
Removes all columns except for those given in the argument from this table and returns this
table
|
Table |
Table.retainColumns(String... columnNames) |
Removes all columns except for those given in the argument from this table and returns this
table
|
Table |
Table.retainColumns(Column<?>... columns) |
Removes all columns except for those given in the argument from this table and returns this
table
|
Table |
Table.rows(int... rowNumbers) |
Returns a table containing the rows contained in the given array of row indices
|
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) |
Deprecated.
Use
selectColumns(String[]) instead |
Table |
Table.select(Column<?>... columns) |
Deprecated.
Use
selectColumns(Column[]) instead |
Table |
Table.selectColumns(int... columnIndexes) |
Returns a new table containing copies of the columns at the given indexes
|
Table |
Table.selectColumns(String... columnNames) |
Returns a new table containing copies of the selected columns from this table
|
Table |
Table.selectColumns(Column<?>... columns) |
Returns a new table containing copies of the selected columns from this table
|
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
|
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) |
Returns a copy of this table sorted using the given sort key.
|
Table[] |
Table.stratifiedSampleSplit(CategoricalColumn<?> column,
double table1Proportion) |
Splits the table into two stratified samples, this uses the specified column to divide the
table into groups, randomly assigning records to each according to the proportion given in
trainingProportion.
|
Table |
BooleanColumn.summary() |
|
Table |
DateColumn.summary() |
Returns a table of dates and the number of observations of those dates
|
Table |
DateTimeColumn.summary() |
|
Table |
InstantColumn.summary() |
Returns a table containing a ColumnType specific summary of the data in this column
|
default Table |
NumericColumn.summary() |
|
Table |
StringColumn.summary() |
|
Table |
TextColumn.summary() |
Returns a table containing a ColumnType specific summary of the data in this column
|
Table |
TimeColumn.summary() |
Returns a table containing a ColumnType specific summary of the data in this column
|
Table |
Table.transpose() |
Transposes data in the table, switching rows for columns.
|
Table |
Table.transpose(boolean includeColumnHeadingsAsFirstColumn,
boolean useFirstColumnForHeadings) |
Transposes data in the table, switching rows for columns.
|
Table |
Table.where(Function<Table,Selection> selection) |
Returns a new Table made by applying the given function to this table
|
Table |
Table.where(Selection selection) |
Returns a table containing the rows contained in the given Selection
|
Table |
Table.xTabColumnPercents(String column1Name,
String column2Name) |
Returns a table with n by m + 1 cells.
|
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) |
TODO: Rename the method to xTabProportions, deprecating this version 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) |
Returns a table with n by m + 1 cells.
|
Table |
Table.xTabTablePercents(String column1Name,
String column2Name) |
Returns a table with n by m + 1 cells.
|
Modifier and Type | Method | Description |
---|---|---|
static Function<Table,Selection> |
QuerySupport.all(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that match all of the given functions.
|
static Function<Table,Selection> |
QuerySupport.and(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that match all of the given functions
|
static Function<Table,Selection> |
QuerySupport.any(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that match any of the given functions.
|
static Function<Table,Selection> |
QuerySupport.both(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match both of the given functions
|
static Function<Table,Selection> |
QuerySupport.either(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match either of the given functions
|
static Function<Table,Selection> |
QuerySupport.neither(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match neither of the given functions.
|
static Function<Table,Selection> |
QuerySupport.not(Function<Table,Selection> deferredSelection) |
Returns a selection for all records for which the given function is
false |
static Function<Table,Selection> |
QuerySupport.notAll(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that don't match all of the given functions
|
static Function<Table,Selection> |
QuerySupport.notAny(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that don't match any of the given functions
|
static Function<Table,Selection> |
QuerySupport.notBoth(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that don't match both of the given functions.
|
static Function<Table,Selection> |
QuerySupport.or(Function<Table,Selection>... deferredSelections) |
Returns a selection for all records that match any of the given functions
|
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.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 |
---|---|---|
static Function<Table,Selection> |
QuerySupport.both(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match both of the given functions
|
Table |
Table.dropWhere(Function<Table,Selection> selection) |
Returns a new Table made by EXCLUDING any rows returned when the given function is applied to
this table
|
static Function<Table,Selection> |
QuerySupport.either(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match either of the given functions
|
static Function<Table,Selection> |
QuerySupport.neither(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that match neither of the given functions.
|
static Function<Table,Selection> |
QuerySupport.not(Function<Table,Selection> deferredSelection) |
Returns a selection for all records for which the given function is
false |
static Function<Table,Selection> |
QuerySupport.notBoth(Function<Table,Selection> sel1,
Function<Table,Selection> sel2) |
Returns a selection for all records that don't match both of the given functions.
|
Table |
Table.where(Function<Table,Selection> selection) |
Returns a new Table made by applying the given function to this table
|
Constructor | Description |
---|---|
Row(Table table) |
Constructs a Row object for the given table
|
Row(Table table,
int rowNumber) |
Constructs a Row object for the given Table, with the Row positioned at the given 0-based index
|
Modifier and Type | Method | Description |
---|---|---|
Table |
Column.summary() |
Returns a table containing a ColumnType specific summary of the data in this column
|
Modifier and Type | Method | Description |
---|---|---|
Table |
Stats.asTable() |
|
Table |
Stats.asTableComplete() |
Modifier and Type | Method | Description |
---|---|---|
Table |
ByteDictionaryMap.countByCategory(String columnName) |
|
Table |
DictionaryMap.countByCategory(String columnName) |
|
Table |
IntDictionaryMap.countByCategory(String columnName) |
|
Table |
ShortDictionaryMap.countByCategory(String columnName) |
Modifier and Type | Method | Description |
---|---|---|
Selection |
And.apply(Table table) |
|
Selection |
Not.apply(Table table) |
|
Selection |
Or.apply(Table table) |
Constructor | Description |
---|---|
Not(Function<Table,Selection> argument) |
Modifier and Type | Method | Description |
---|---|---|
static Table |
TableBuildingUtils.build(List<String> columnNames,
List<String[]> dataRows,
ReadOptions options) |
|
Table |
DataFrameReader.csv(File file) |
|
Table |
DataFrameReader.csv(InputStream stream) |
|
Table |
DataFrameReader.csv(InputStream stream,
String name) |
|
Table |
DataFrameReader.csv(Reader reader) |
|
Table |
DataFrameReader.csv(String file) |
|
Table |
DataFrameReader.csv(String contents,
String tableName) |
|
Table |
DataFrameReader.csv(URL url) |
|
Table |
DataFrameReader.csv(CsvReadOptions options) |
|
Table |
DataFrameReader.csv(CsvReadOptions.Builder options) |
|
Table |
DataFrameReader.db(ResultSet resultSet) |
|
Table |
DataFrameReader.db(ResultSet resultSet,
String tableName) |
|
Table |
DataFrameReader.file(File file) |
Reads the given file into a table using default options Uses converter specified based on given
file extension Use
usingOptions to use non-default options |
Table |
DataFrameReader.file(String file) |
Reads the given file into a table using default options Uses converter specified based on given
file extension Use
usingOptions to use non-default options |
protected Table |
FileReader.parseRows(ReadOptions options,
boolean headerOnly,
Reader reader,
ReadOptions.ColumnTypeReadOptions columnTypeReadOptions,
com.univocity.parsers.common.AbstractParser<?> parser) |
|
protected Table |
FileReader.parseRows(ReadOptions options,
boolean headerOnly,
Reader reader,
ReadOptions.ColumnTypeReadOptions columnTypeReadOptions,
com.univocity.parsers.common.AbstractParser<?> parser,
int sampleSize) |
|
Table |
DataReader.read(O options) |
|
Table |
DataReader.read(Source source) |
|
Table |
DataFrameReader.string(String s,
String fileExtension) |
Reads the given string contents into a table using default options Uses converter specified
based on given file extension Use
usingOptions to use
non-default options |
Table |
DataFrameReader.url(String url) |
Reads the given URL into a table using default options Uses appropriate converter based on
mime-type Use
usingOptions to use non-default options |
Table |
DataFrameReader.url(URL url) |
Reads the given URL into a table using default options Uses appropriate converter based on
mime-type Use
usingOptions to use non-default options |
<T extends ReadOptions> |
DataFrameReader.usingOptions(T options) |
|
Table |
DataFrameReader.usingOptions(ReadOptions.Builder builder) |
Modifier and Type | Method | Description |
---|---|---|
protected String |
FileReader.getTypeString(Table structure) |
|
void |
DataWriter.write(Table table,
O options) |
|
void |
DataWriter.write(Table table,
Destination dest) |
Constructor | Description |
---|---|
DataFrameWriter(WriterRegistry registry,
Table table) |
Modifier and Type | Method | Description |
---|---|---|
Table |
CsvReader.read(CsvReadOptions options) |
|
Table |
CsvReader.read(Source source) |
Modifier and Type | Method | Description |
---|---|---|
void |
CsvWriter.write(Table table,
CsvWriteOptions options) |
|
void |
CsvWriter.write(Table table,
Destination dest) |
Modifier and Type | Method | Description |
---|---|---|
Table |
FixedWidthReader.read(FixedWidthReadOptions options) |
|
Table |
FixedWidthReader.read(Source source) |
Modifier and Type | Method | Description |
---|---|---|
void |
FixedWidthWriter.write(Table table,
Destination dest) |
|
void |
FixedWidthWriter.write(Table table,
FixedWidthWriteOptions options) |
Modifier and Type | Method | Description |
---|---|---|
static Table |
SqlResultSetReader.read(ResultSet resultSet) |
Returns a new table with the given tableName, constructed from the given result set
|
Modifier and Type | Method | 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,
boolean allowDuplicateColumnNames,
boolean keepAllJoinKeyColumns,
String... col2Names) |
Joins the joiner to the table2, using the given columns for the second table and returns the
resulting table
|
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.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 allowDuplicateColumnNames,
boolean keepAllJoinKeyColumns,
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,
boolean keepAllJoinKeyColumns,
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,
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,
boolean keepAllJoinKeyColumns,
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,
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 | 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,
boolean allowDuplicateColumnNames,
boolean keepAllJoinKeyColumns,
String... col2Names) |
Joins the joiner to the table2, using the given columns for the second table and returns the
resulting table
|
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.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 allowDuplicateColumnNames,
boolean keepAllJoinKeyColumns,
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,
boolean keepAllJoinKeyColumns,
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,
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,
boolean keepAllJoinKeyColumns,
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,
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 | Description |
---|---|
DataFrameJoiner(Table table,
String... joinColumnNames) |
Constructor.
|
Modifier and Type | Method | Description |
---|---|---|
static Sort |
Sort.create(Table table,
String... columnNames) |
Create a Sort object from the given table and sort column names.
|
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() |
|
abstract Table |
Relation.first(int nRows) |
Returns a new table containing the first n rows in this Relation
|
Table |
TableSlice.first(int nRows) |
|
Table |
TableSliceGroup.getSourceTable() |
|
Table |
TableSlice.getTable() |
|
Table |
Relation.structure() |
Returns the structure of the this relation as a 3-column Table, consisting of Index (an
IntColumn), Column Name (a StringColumn), and Column Type (a StringColumn)
|
Table |
Relation.summary() |
Returns a table containing summary statistics for the columns in this Relation
|
static Table |
TableSliceGroup.summaryTableName(Table source) |
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(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 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) |
|
protected void |
TableSliceGroup.setSourceTable(Table sourceTable) |
|
static Table |
TableSliceGroup.summaryTableName(Table source) |
|
static void |
Rows.tail(int rowsToInclude,
Table oldTable,
Table newTable) |
Constructor | Description |
---|---|
TableSlice(Table table) |
Returns a new view constructed from the given table.
|
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 © 2021. All rights reserved.