VerbsΒΆ

alias

Changes the name of the current table and allows subqueries in SQL.

arrange

Sorts the rows of the table.

ast_repr

Prints the AST of the table to stdout.

build_query

Compiles the operations accumulated on the current table to a SQL query.

collect

Execute all accumulated operations and write the result to a new Table.

drop

Removes a subset of the columns.

export

Convert a pydiverse.transform Table to a data frame.

filter

Selects a subset of rows based on some condition.

full_join

Alias for the pydiverse.transform.join verb with how="full".

group_by

Add a grouping state to the table.

inner_join

Alias for the pydiverse.transform.join verb with how="inner".

join

Joins two tables on a boolean expression.

left_join

Alias for the pydiverse.transform.join verb with how="left".

mutate

Adds new columns to the table.

name

Returns the name of the table.

rename

Renames columns.

select

Selects a subset of columns.

show

Prints the table to stdout.

show_query

Prints the compiled SQL query to stdout.

slice_head

Selects a subset of rows based on their index.

summarize

Computes aggregates over groups of rows.

ungroup

Clear the grouping state of the table.

union

Unions two tables by stacking rows vertically.