Projection#

TableFrame.drop(*columns[, strict])

Discard columns from the TableFrame.

TableFrame.item()

Returns a scalar value if the TableFrame contains exactly one user column and one row.

TableFrame.rename(mapping)

Rename columns from the TableFrame.

TableFrame.select(*exprs, **named_exprs)

Select column(s) from the TableFrame.

TableFrame.udf(on, function)

Apply a user-defined function (UDF) to the columns resolved by expr.

TableFrame.unnest(columns, *more_columns)

Expand one or more struct columns so that each field within the struct becomes a separate column in the TableFrame.

TableFrame.with_columns(*exprs, **named_exprs)

Add columns to the TableFrame.

all()

Select all columns in a TableFrame.

alpha([ascii_only, ignore_spaces])

Select all columns with names made up of only alphabetic characters.

alphanumeric([ascii_only, ignore_spaces])

Select all columns whose names contain only letters and digits.

binary()

Select all columns of binary (bytes) data type.

boolean()

Select all columns of boolean data type.

by_dtype(*dtypes)

Select all columns of the specified data type.

by_index(*indices)

Select columns by their position in the TableFrame.

by_name(*names[, require_all])

Select all columns whose names match any given names.

categorical()

Select all columns with categorical data type.

contains(*substring)

Select all columns whose names contain one or more of the given substrings.

date()

Select all columns of date data type.

datetime([time_unit, time_zone])

Select all columns of datetime data type.

decimal()

Select all columns of decimal data type.

digit([ascii_only])

Select all columns whose names consist only of digit characters.

duration([time_unit])

Select all columns of duration data type.

ends_with(*suffix)

Select all columns whose names end with any of the given suffixes.

exclude(columns, *more_columns)

Exclude specific columns from selection by name, data type, expression, or selector.

first()

Select the first column in the TableFrame.

float()

Select all columns of float data types.

integer()

Select all columns with integer data types.

last()

Select the last column in the TableFrame.

matches(pattern)

Select all columns whose names match a regular expression pattern.

numeric()

Select all columns of numeric data types.

object()

Select all columns of object data type.

signed_integer()

Select all columns of signed integer data types.

starts_with(*prefix)

Select all columns whose names start with any of the given prefixes.

string(*[, include_categorical])

Select all columns of string or categorical data type.

temporal()

Select all columns of temporal data types.

time()

Select columns of Python time values.

unsigned_integer()

Select all columns of unsigned integer data types.