Modifier and Type | Class and Description |
---|---|
class |
NumericSummaryTable
NumericSummaryTable is a standard table, but one with a specific format:
It has two columns, the first a category column and the second a numeric column,
so that it is appropriate for managing data that summarizes numeric variables by groups
|
Modifier and Type | Method and Description |
---|---|
static Table |
CrossTab.columnPercents(Table xTabCounts) |
static Table |
CrossTab.rowPercents(Table xTabCounts) |
static Table |
CrossTab.tablePercents(Table xTabCounts) |
static Table |
CrossTab.xCount(Table table,
Column column1,
Column column2) |
static Table |
CrossTab.xTabCount(Table table,
Column column1,
Column column2)
Returns a table containing two-dimensional cross-tabulated counts for each combination of values in
column1 and column2 |
static Table |
CrossTab.xTabCount(Table table,
DateColumn column1,
Column column2) |
Modifier and Type | Method and Description |
---|---|
static Table |
CrossTab.columnPercents(Table xTabCounts) |
static Table |
CrossTab.rowPercents(Table xTabCounts) |
static Table |
CrossTab.tablePercents(Table xTabCounts) |
static Table |
CrossTab.xCount(Table table,
Column column1,
Column column2) |
static Table |
CrossTab.xTabCount(Table table,
Column column1,
Column column2)
Returns a table containing two-dimensional cross-tabulated counts for each combination of values in
column1 and column2 |
static Table |
CrossTab.xTabCount(Table table,
DateColumn column1,
Column column2) |
Constructor and Description |
---|
SummaryFunction(Table original,
String summarizedColumnName,
AggregateFunction function) |
Modifier and Type | Method and Description |
---|---|
Table |
Table.addColumn(Column... cols)
Adds the given column to this table
|
Table |
Table.addColumn(int index,
Column column)
Adds the given column to this table at the given position in the column list
|
Table |
Table.countBy(CategoryColumn column) |
Table |
CategoryColumn.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
|
static Table |
Table.create(TableMetadata metadata)
Returns a new, empty table constructed according to the given metadata
|
Table |
Table.dropRows(Collection<Integer> rows)
Returns a table with the given rows dropped
|
Table |
Table.dropRows(int start,
int end)
Returns a table with the given rows dropped
|
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.fullCopy()
Returns a table with the same columns as this table
|
Table |
Table.last(int nRows)
Returns a new table containing the last
nrows of data in this table |
static Table |
Table.readTable(String tableNameAndPath) |
Table |
Table.removeColumns(Column... columns)
Removes the given columns
|
Table |
Table.sample(double proportion)
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.selectRows(Collection<Integer> rows)
Returns a table with the given rows selected
|
Table |
Table.selectRows(int start,
int end)
Returns a table with the given rows selected
|
Table |
Table.selectWhere(Filter filter) |
Table |
Table.selectWhere(Selection selection) |
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
|
Table |
Table.sortOn(it.unimi.dsi.fastutil.ints.IntComparator rowComparator)
Returns a copy of this table sorted using the given comparator
|
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 |
DateTimeColumn.summary() |
Table |
IntColumn.summary() |
Table |
DoubleColumn.summary() |
Table |
ShortColumn.summary() |
Table |
LongColumn.summary() |
Table |
CategoryColumn.summary() |
Table |
FloatColumn.summary() |
Table |
TimeColumn.summary() |
Table |
Table.uniqueRecords()
Returns the unique records in this table
Note: Uses a lot of memory for a sort
|
Modifier and Type | Method and Description |
---|---|
void |
Table.append(Table tableToAppend) |
Modifier and Type | Method and Description |
---|---|
Table |
Column.summary() |
Modifier and Type | Method and Description |
---|---|
Selection |
AllOf.apply(Table relation) |
Selection |
StringIsIn.apply(Table relation) |
Selection |
LocalDateBetweenExclusive.apply(Table relation) |
Selection |
FloatLessThanOrEqualTo.apply(Table relation) |
Selection |
DoubleGreaterThan.apply(Table relation) |
Selection |
IntIsIn.apply(Table relation) |
Selection |
StringIsNotIn.apply(Table relation) |
Selection |
DateEqualTo.apply(Table relation) |
Selection |
DoubleLessThanOrEqualTo.apply(Table relation) |
Selection |
LongNotEqualTo.apply(Table relation) |
Selection |
DateTimeEqualTo.apply(Table relation) |
Selection |
IsTrue.apply(Table relation)
Returns true if the element in the given row in my
column is true |
Selection |
BooleanIsTrue.apply(Table relation) |
abstract Selection |
Filter.apply(Table relation) |
Selection |
IntBetweenExclusive.apply(Table relation) |
Selection |
AnyOf.apply(Table relation) |
Selection |
IntGreaterThan.apply(Table relation) |
Selection |
LongLessThan.apply(Table relation) |
Selection |
FloatGreaterThanOrEqualTo.apply(Table relation) |
Selection |
DoubleLessThan.apply(Table relation) |
Selection |
IntLessThan.apply(Table relation) |
Selection |
TimeNotEqualTo.apply(Table relation) |
Selection |
DoubleGreaterLessThanOrEqualTo.apply(Table relation) |
Selection |
BooleanIsFalse.apply(Table relation) |
Selection |
FloatNotEqualTo.apply(Table relation) |
Selection |
IsNotMissing.apply(Table relation) |
Selection |
DoubleEqualTo.apply(Table relation) |
Selection |
IntEqualTo.apply(Table table) |
Selection |
DoubleGreaterThanOrEqualTo.apply(Table relation) |
Selection |
LocalDateBetweenInclusive.apply(Table relation) |
Selection |
StringEqualTo.apply(Table relation) |
Selection |
IntBetweenInclusive.apply(Table relation) |
Selection |
LongEqualTo.apply(Table relation) |
Selection |
LongLessThanOrEqualTo.apply(Table relation) |
Selection |
IntGreaterThanOrEqualTo.apply(Table relation) |
Selection |
IsFalse.apply(Table relation)
Returns true if the element in the given row in my
column is true |
Selection |
IntNotEqualTo.apply(Table table) |
Selection |
StringNotEqualTo.apply(Table relation) |
Selection |
LongGreaterThanOrEqualTo.apply(Table relation) |
Selection |
FloatLessThan.apply(Table relation) |
Selection |
FloatGreaterThan.apply(Table relation) |
Selection |
IsMissing.apply(Table relation) |
Selection |
IntLessThanOrEqualTo.apply(Table relation) |
Selection |
DoubleNotEqualTo.apply(Table relation) |
Selection |
TimeEqualTo.apply(Table relation) |
Selection |
LongGreaterThan.apply(Table relation) |
Selection |
FloatEqualTo.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Selection |
ColumnEqualTo.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Selection |
LocalDateIsOnOrBefore.apply(Table relation) |
Selection |
LocalDateIsOnOrAfter.apply(Table relation) |
Selection |
LocalDateIsAfter.apply(Table relation) |
Selection |
LocalDateIsBefore.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Selection |
IsInApril.apply(Table relation) |
Selection |
IsInOctober.apply(Table relation) |
Selection |
IsFirstDayOfTheMonth.apply(Table relation) |
Selection |
IsTuesday.apply(Table relation) |
Selection |
IsInQ4.apply(Table relation) |
Selection |
IsWednesday.apply(Table relation) |
Selection |
IsInQ2.apply(Table relation) |
Selection |
IsInMay.apply(Table relation) |
Selection |
IsInJuly.apply(Table relation) |
Selection |
IsInYear.apply(Table relation) |
Selection |
IsInNovember.apply(Table relation) |
Selection |
DateIsOnOrAfter.apply(Table relation) |
Selection |
IsInFebruary.apply(Table relation) |
Selection |
DateTimeIsAfter.apply(Table relation) |
Selection |
IsInJanuary.apply(Table relation) |
Selection |
IsLastDayOfTheMonth.apply(Table relation) |
Selection |
IsInQ1.apply(Table relation) |
Selection |
IsInJune.apply(Table relation) |
Selection |
IsMonday.apply(Table relation) |
Selection |
IsInDecember.apply(Table relation) |
Selection |
DateTimeIsBefore.apply(Table relation) |
Selection |
IsInMarch.apply(Table relation) |
Selection |
IsThursday.apply(Table relation) |
Selection |
IsSunday.apply(Table relation) |
Selection |
IsFriday.apply(Table relation) |
Selection |
IsInSeptember.apply(Table relation) |
Selection |
IsInQ3.apply(Table relation) |
Selection |
DateIsOnOrBefore.apply(Table relation) |
Selection |
IsInAugust.apply(Table relation) |
Selection |
IsSaturday.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Selection |
TextEqualToIgnoringCase.apply(Table relation) |
Selection |
TextIsEmpty.apply(Table relation) |
Selection |
TextIsAlpha.apply(Table relation) |
Selection |
TextHasLengthEqualTo.apply(Table relation) |
Selection |
TextStartsWith.apply(Table relation) |
Selection |
TextContains.apply(Table relation) |
Selection |
TextIsIn.apply(Table relation) |
Selection |
TextIsUpperCase.apply(Table relation) |
Selection |
TextIsNumeric.apply(Table relation) |
Selection |
TextIsAlphaNumeric.apply(Table relation) |
Selection |
TextMatchesRegex.apply(Table relation) |
Selection |
TextIsLowerCase.apply(Table relation) |
Selection |
TextIsLongerThan.apply(Table relation) |
Selection |
TextIsShorterThan.apply(Table relation) |
Selection |
TextEndsWith.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Selection |
IsNoon.apply(Table relation) |
Selection |
IsAfterNoon.apply(Table relation) |
Selection |
IsMidnight.apply(Table relation) |
Selection |
IsAfter.apply(Table relation) |
Selection |
IsBeforeNoon.apply(Table relation) |
Selection |
IsBefore.apply(Table relation) |
Modifier and Type | Method and Description |
---|---|
Table |
DataFrameReader.csv(CsvReadOptionsBuilder 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) |
static Table |
DataFrameReader.db(ResultSet resultSet,
String tableName) |
Constructor and Description |
---|
DataFrameWriter(Table table) |
Modifier and Type | Method and 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 and Description |
---|---|
static void |
CsvWriter.write(Table table,
File file)
Writes the given table to athe given file
|
static void |
CsvWriter.write(Table table,
OutputStream stream)
Writes the given table to a file with the given filename
|
static void |
CsvWriter.write(Table table,
String fileName)
Writes the given table to a file with the given filename
|
static void |
CsvWriter.write(Table table,
Writer writer)
Writes the given table to the given file
|
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 |
---|---|
static Table |
StorageManager.readTable(String path)
Reads a tablesaw table into memory
|
Modifier and Type | Class and Description |
---|---|
class |
SubTable
A specialization of the standard Relation used for tables formed by grouping operations on a Relation
|
Modifier and Type | Method and Description |
---|---|
Table |
TemporaryView.asTable() |
abstract Table |
Relation.first(int nRows) |
Table |
TemporaryView.first(int nRows) |
Table |
ViewGroup.getSortedOriginal() |
Table |
TableGroup.reduce(String numericColumnName,
AggregateFunction function) |
Table |
Relation.structure() |
Table |
Projection.where(Filter filter) |
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(it.unimi.dsi.fastutil.ints.IntArrayList rows,
Table oldTable,
Table newTable) |
static void |
Rows.copyRowsToTable(Selection rows,
Table oldTable,
Table newTable) |
static ViewGroup |
ViewGroup.create(Table original,
String... columnsNames) |
static void |
Rows.head(int rowCount,
Table oldTable,
Table newTable) |
static void |
Rows.tail(int rowsToInclude,
Table oldTable,
Table newTable) |
Constructor and Description |
---|
Projection(Table table,
String[] columnNames) |
TableGroup(Table original,
Column... columns) |
TableGroup(Table original,
String... splitColumnNames) |
TemporaryView(Table table,
Selection rowSelection)
Returns a new View constructed from the given table, containing only the rows represented by the bitmap
|
ViewGroup(Table original,
Column... columns) |
Modifier and Type | Method and Description |
---|---|
Table |
Stats.asTable() |
Table |
Stats.asTableComplete() |
Copyright © 2017. All rights reserved.