Filters

Command	Description
all	Test if every element of the input fulfills a predicate expression.
any	Tests if any element of the input fulfills a predicate expression.
append	Append any number of rows to a table.
collect	Collect the stream and pass it to a block.
columns	Given a record or table, produce a list of its columns' names.
compact	Creates a table with non-empty rows.
default	Sets a default row's column if missing.
drop	Remove items/rows from the end of the input list/table. Counterpart of `skip`. Opposite of `last`.
drop column	Remove N columns at the right-hand end of the input table. To remove columns by name, use `reject`.
drop nth	Drop the selected rows.
each	Run a closure on each row of the input list, creating a new list with the results.
each while	Run a block on each row of the input list until a null is found, then create a new list with the results.
enumerate	Enumerate the elements in a stream.
every	Show (or skip) every n-th row, starting from the first one.
filter	Filter values based on a predicate closure.
find	Searches terms in the input.
first	Return only the first several rows of the input. Counterpart of `last`. Opposite of `skip`.
flatten	Flatten the table.
get	Extract data using a cell path.
group	Groups input into groups of `group_size`.
headers	Use the first row of the table as column names.
insert	Insert a new column, using an expression or closure to create each row's values.
is-empty	Check for empty values.
items	Given a record, iterate on each pair of column name and associated value.
last	Return only the last several rows of the input. Counterpart of `first`. Opposite of `drop`.
length	Count the number of elements in the input.
lines	Converts input to lines.
merge	Merge the input with a record or table, overwriting values in matching columns.
move	Move columns before or after other columns.
par-each	Run a closure on each row of the input list in parallel, creating a new list with the results.
prepend	Prepend any number of rows to a table.
query	Show all the query commands
query json	execute json query on json file (open --raw <file> | query json 'query string')
query xml	execute xpath query on xml
range	Return only the selected rows.
reject	Remove the given columns or rows from the table. Opposite of `select`.
rename	Creates a new table with columns renamed.
reverse	Reverses the input list or table.
roll	Rolling commands for tables.
roll down	Roll table rows down.
roll left	Roll record or table columns left.
roll right	Roll table columns right.
roll up	Roll table rows up.
rotate	Rotates a table or record clockwise (default) or counter-clockwise (use --ccw flag).
select	Select only these columns or rows from the input. Opposite of `reject`.
shuffle	Shuffle rows randomly.
skip	Skip the first several rows of the input. Counterpart of `drop`. Opposite of `first`.
skip until	Skip elements of the input until a predicate is true.
skip while	Skip elements of the input while a predicate is true.
sort	Sort in increasing order.
sort-by	Sort by the given columns, in increasing order.
split list	Split a list into multiple lists using a separator.
take	Take only the first n elements of a list, or the first n bytes of a binary value.
take until	Take elements of the input until a predicate is true.
take while	Take elements of the input while a predicate is true.
uniq	Return the distinct values in the input.
uniq-by	Return the distinct values in the input by the given column(s).
update	Update an existing column to have a new value.
update cells	Update the table cells.
upsert	Update an existing column to have a new value, or insert a new column.
values	Given a record or table, produce a list of its columns' values.
where	Filter values based on a row condition.
window	Creates a sliding window of `window_size` that slide by n rows/elements across input.
wrap	Wrap the value into a column.
zip	Combine a stream with the input.