Package tech.tablesaw.api

Class QuerySupport

java.lang.Object

tech.tablesaw.api.QuerySupport

public class QuerySupport
extends Object

Utility methods to aid in the construction of complex queries on tables

Method Summary

Modifier and Type	Method	Description
static Function<Table,Selection>	all(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that match all of the given functions.
static Function<Table,Selection>	and(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that match all of the given functions
static Function<Table,Selection>	any(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that match any of the given functions.
static DeferredBooleanColumn	bool(String columnName)
static DeferredBooleanColumn	booleanColumn(String columnName)
static Function<Table,Selection>	both(Function<Table,Selection> sel1, Function<Table,Selection> sel2)	Returns a selection for all records that match both of the given functions
static DeferredColumn	col(String columnName)
static DeferredColumn	column(String columnName)
static DeferredDateColumn	date(String columnName)
static DeferredDateColumn	dateColumn(String columnName)
static DeferredDateTimeColumn	dateTime(String columnName)
static DeferredDateTimeColumn	dateTimeColumn(String columnName)
static Function<Table,Selection>	either(Function<Table,Selection> sel1, Function<Table,Selection> sel2)	Returns a selection for all records that match either of the given functions
static DeferredInstantColumn	instantColumn(String columnName)
static Function<Table,Selection>	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>	not(Function<Table,Selection> deferredSelection)	Returns a selection for all records for which the given function is false
static Function<Table,Selection>	notAll(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that don't match all of the given functions
static Function<Table,Selection>	notAny(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that don't match any of the given functions
static Function<Table,Selection>	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 DeferredNumberColumn	num(String columnName)
static DeferredNumberColumn	numberColumn(String columnName)
static Function<Table,Selection>	or(Function<Table,Selection>... deferredSelections)	Returns a selection for all records that match any of the given functions
static DeferredStringColumn	str(String columnName)
static DeferredStringColumn	stringColumn(String columnName)
static DeferredTextColumn	text(String columnName)
static DeferredTextColumn	textColumn(String columnName)
static DeferredTimeColumn	time(String columnName)
static DeferredTimeColumn	timeColumn(String columnName)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

not

public static Function<Table,Selection> not(Function<Table,Selection> deferredSelection)

Returns a selection for all records for which the given function is false

neither

public static Function<Table,Selection> neither(Function<Table,Selection> sel1,
 Function<Table,Selection> sel2)

Returns a selection for all records that match neither of the given functions. In other words, if either (or both) of sel1 or sel2 is true, the record as a whole is false.

notBoth

public static Function<Table,Selection> notBoth(Function<Table,Selection> sel1,
 Function<Table,Selection> sel2)

Returns a selection for all records that don't match both of the given functions. In other words, if both sel1 and sel2 are true, the record as a whole is false, and if either (or both) of sel1 or sel2 is false, the record as a whole is true.

notAny

@SafeVarargs
public static Function<Table,Selection> notAny(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that don't match any of the given functions

notAll

@SafeVarargs
public static Function<Table,Selection> notAll(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that don't match all of the given functions

and

@SafeVarargs
public static Function<Table,Selection> and(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that match all of the given functions

all

@SafeVarargs
public static Function<Table,Selection> all(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that match all of the given functions. A synonym for and()

both

public static Function<Table,Selection> both(Function<Table,Selection> sel1,
 Function<Table,Selection> sel2)

Returns a selection for all records that match both of the given functions

or

@SafeVarargs
public static Function<Table,Selection> or(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that match any of the given functions

any

@SafeVarargs
public static Function<Table,Selection> any(Function<Table,Selection>... deferredSelections)

Returns a selection for all records that match any of the given functions. A synonym for or()

either

public static Function<Table,Selection> either(Function<Table,Selection> sel1,
 Function<Table,Selection> sel2)

Returns a selection for all records that match either of the given functions

column

public static DeferredColumn column(String columnName)

col

public static DeferredColumn col(String columnName)

booleanColumn

public static DeferredBooleanColumn booleanColumn(String columnName)

bool

public static DeferredBooleanColumn bool(String columnName)

stringColumn

public static DeferredStringColumn stringColumn(String columnName)

str

public static DeferredStringColumn str(String columnName)

text

public static DeferredTextColumn text(String columnName)

textColumn

public static DeferredTextColumn textColumn(String columnName)

numberColumn

public static DeferredNumberColumn numberColumn(String columnName)

num

public static DeferredNumberColumn num(String columnName)

dateColumn

public static DeferredDateColumn dateColumn(String columnName)

date

public static DeferredDateColumn date(String columnName)

dateTimeColumn

public static DeferredDateTimeColumn dateTimeColumn(String columnName)

dateTime

public static DeferredDateTimeColumn dateTime(String columnName)

instantColumn

public static DeferredInstantColumn instantColumn(String columnName)

timeColumn

public static DeferredTimeColumn timeColumn(String columnName)

time

public static DeferredTimeColumn time(String columnName)