Filters#

Expr.filter(*predicates)

Apply a filter predicate to an expression.

Expr.slice(offset[, length])

Compute a slice of the TableFrame for the specified columns.

TableFrame.extract_as_columns(offset, length)

Extract a slice of rows from the table as a column-oriented dictionary.

TableFrame.extract_as_rows(offset, length)

Extract a slice of rows from the TableFrame as a list of dictionaries.

TableFrame.filter(*predicates)

Filter the TableFrame based on the given predicates.

TableFrame.first()

Return a TableFrame with the first row.

TableFrame.first_row([named])

Return a tuple or dictionary with the first row, or None if no row.

TableFrame.head([n])

Return a TableFrame with the first n rows.

TableFrame.last()

Return a TableFrame with the last row.

TableFrame.last_row([named])

Return a tuple or dictionary with the last row, or None if no row.

TableFrame.limit([n])

Return a TableFrame with the first n rows.

TableFrame.slice(offset[, length])

Return a TableFrame with a slice of the original TableFrame

TableFrame.tail([n])

Return a TableFrame with the last n rows.

TableFrame.unique([subset, keep, maintain_order])

Deduplicate rows from the TableFrame.