cycquery.ops

Query operations.

Classes

AddColumn	Add a column to some columns.
AddDeltaColumn	Construct and add an interval column to some columns.
AddDeltaConstant	Construct and add a datetime.timedelta object to some columns.
AddNumeric	Add a numeric value to some columns.
And	Combine multiple condition query ops using an And.
Apply	Apply function(s) to column(s).
Cast	Cast columns to a specified type.
ConditionAfterDate	Filter rows based on a timestamp being after some date.
ConditionBeforeDate	Filter rows based on a timestamp being before some date.
ConditionEndsWith	Filter rows based on ending with some string.
ConditionEquals	Filter rows based on being equal, or not equal, to some value.
ConditionGreaterThan	Filter rows based on greater than (or equal), to some value.
ConditionIn	Filter rows based on having a value in list of values.
ConditionInMonths	Filter rows based on a timestamp being in a list of years.
ConditionInYears	Filter rows based on a timestamp column being in a list of years.
ConditionLessThan	Filter rows based on less than (or equal), to some value.
ConditionLike	Filter rows by a LIKE condition.
ConditionRegexMatch	Filter rows based on matching a regular expression.
ConditionStartsWith	Filter rows based on starting with some string.
ConditionSubstring	Filter rows on based on having substrings.
Count	Count the number of rows.
Distinct	Get distinct rows.
Drop	Drop some columns.
DropEmpty	Remove rows with empty values in some specified columns.
DropNulls	Remove rows with null values in some specified columns.
ExtractTimestampComponent	Extract a component such as year or month from a timestamp column.
FillNull	Fill NULL values with a given value.
GroupByAggregate	Aggregate over a group by object.
Join	Join a table with another table.
Keep	Keep only the specified columns in a table.
Limit	Limit the number of rows returned in a query.
Literal	Add a literal column to a table.
Or	Combine multiple condition query ops using an OR.
OrderBy	Order, or sort, the rows of a table by some columns.
QueryOp	Base class for query operations.
RandomizeOrder	Randomize order of table rows.
Rename	Rename some columns.
Reorder	Reorder the columns in a table.
ReorderAfter	Reorder a number of columns to come after a specified column.
Sequential	Sequential query operations class.
Substring	Get substring of a string column.
Trim	Trim the whitespace from some string columns.
Union	Union two tables.