Functions#

These functions are available from the Polars module root and can be used as expressions, and sometimes also in eager contexts.


Available in module namespace:

all(*names[, ignore_nulls])

Either return an expression representing all columns, or evaluate a bitwise AND operation.

all_horizontal(*exprs)

Compute the bitwise AND horizontally across columns.

any(*names[, ignore_nulls])

Evaluate a bitwise OR operation.

any_horizontal(*exprs)

Compute the bitwise OR horizontally across columns.

approx_n_unique(*columns)

Approximate count of unique values.

arange([start, end, step, dtype, eager])

Generate a range of integers.

arctan2(y, x)

Compute two argument arctan in radians.

arctan2d(y, x)

Compute two argument arctan in degrees.

arg_sort_by(exprs, *more_exprs[, ...])

Return the row indices that would sort the column(s).

arg_where(condition, *[, eager])

Return indices where condition evaluates True.

business_day_count(start, end[, week_mask, ...])

Count the number of business days between start and end (not including end).

coalesce(exprs, *more_exprs)

Folds the columns from left to right, keeping the first non-null value.

concat_arr(exprs, *more_exprs)

Horizontally concatenate columns into a single array column.

concat_list(exprs, *more_exprs)

Horizontally concatenate columns into a single list column.

concat_str(exprs, *more_exprs[, separator, ...])

Horizontally concatenate columns into a single string column.

corr(a, b, *[, method, ddof, propagate_nans])

Compute the Pearson's or Spearman rank correlation correlation between two columns.

count(*columns)

Return the number of non-null values in the column.

cov(a, b[, ddof])

Compute the covariance between two columns/ expressions.

cum_count(*columns[, reverse])

Return the cumulative count of the non-null values in the column.

cum_fold(acc, function, exprs, *[, include_init])

Cumulatively fold horizontally across columns with a left fold.

cum_reduce(function, exprs)

Cumulatively reduce horizontally across columns with a left fold.

cum_sum(*names)

Cumulatively sum all values.

cum_sum_horizontal(*exprs)

Cumulatively sum all values horizontally across columns.

date(year, month, day)

Create a Polars literal expression of type Date.

date_range(start, end[, interval, closed, eager])

Generate a date range.

date_ranges(start, end[, interval, closed, ...])

Create a column of date ranges.

datetime(year, month, day[, hour, minute, ...])

Create a Polars literal expression of type Datetime.

datetime_range(start, end[, interval, ...])

Generate a datetime range.

datetime_ranges(start, end[, interval, ...])

Create a column of datetime ranges.

duration(*[, weeks, days, hours, minutes, ...])

Create polars Duration from distinct time components.

element()

Alias for an element being evaluated in an eval expression.

exclude(columns, *more_columns)

Represent all columns except for the given columns.

first(*columns)

Get the first column or value.

fold(acc, function, exprs)

Accumulate over multiple columns horizontally/ row wise with a left fold.

format(f_string, *args)

Format expressions as a string.

from_epoch(column[, time_unit])

Utility function that parses an epoch timestamp (or Unix time) to Polars Date(time).

groups(column)

Syntactic sugar for pl.col("foo").agg_groups().

head(column[, n])

Get the first n rows.

implode(*columns)

Aggregate all column values into a list.

int_range([start, end, step, dtype, eager])

Generate a range of integers.

int_ranges([start, end, step, dtype, eager])

Generate a range of integers for each row of the input columns.

last(*columns)

Get the last column or value.

len()

Return the number of rows in the context.

lit(value[, dtype, allow_object])

Return an expression representing a literal value.

map_batches(exprs, function[, return_dtype])

Map a custom function over multiple columns/expressions.

map_groups(exprs, function[, return_dtype, ...])

Apply a custom/user-defined function (UDF) in a GroupBy context.

max(*names)

Get the maximum value.

max_horizontal(*exprs)

Get the maximum value horizontally across columns.

mean(*columns)

Get the mean value.

mean_horizontal(*exprs[, ignore_nulls])

Compute the mean of all values horizontally across columns.

median(*columns)

Get the median value.

min(*names)

Get the minimum value.

min_horizontal(*exprs)

Get the minimum value horizontally across columns.

n_unique(*columns)

Count unique values.

nth(*indices)

Get the nth column(s) of the context.

ones(n[, dtype, eager])

Construct a column of length n filled with ones.

quantile(column, quantile[, interpolation])

Syntactic sugar for pl.col("foo").quantile(..).

reduce(function, exprs)

Accumulate over multiple columns horizontally/ row wise with a left fold.

repeat(value, n, *[, dtype, eager])

Construct a column of length n filled with the given value.

rolling_corr(a, b, *, window_size[, ...])

Compute the rolling correlation between two columns/ expressions.

rolling_cov(a, b, *, window_size[, ...])

Compute the rolling covariance between two columns/ expressions.

select(*exprs[, eager])

Run polars expressions without a context.

sql(query, *[, eager])

Execute a SQL query against frames in the global namespace.

sql_expr(sql)

Parse one or more SQL expressions to Polars expression(s).

std(column[, ddof])

Get the standard deviation.

struct(*exprs[, schema, eager])

Collect columns into a struct column.

sum(*names)

Sum all values.

sum_horizontal(*exprs[, ignore_nulls])

Sum all values horizontally across columns.

tail(column[, n])

Get the last n rows.

time([hour, minute, second, microsecond])

Create a Polars literal expression of type Time.

time_range([start, end, interval, closed, eager])

Generate a time range.

time_ranges([start, end, interval, closed, ...])

Create a column of time ranges.

var(column[, ddof])

Get the variance.

when(*predicates, **constraints)

Start a when-then-otherwise expression.

zeros(n[, dtype, eager])

Construct a column of length n filled with zeros.

Available in expression namespace:

Expr.all(*[, ignore_nulls])

Return whether all values in the column are True.

Expr.any(*[, ignore_nulls])

Return whether any of the values in the column are True.

Expr.approx_n_unique()

Approximate count of unique values.

Expr.count()

Return the number of non-null elements in the column.

Expr.first()

Get the first value.

Expr.head([n])

Get the first n rows.

Expr.implode()

Aggregate values into a list.

Expr.map_batches(function[, return_dtype, ...])

Apply a custom python function to a whole Series or sequence of Series.

Expr.map_elements(function[, return_dtype, ...])

Map a custom/user-defined function (UDF) to each element of a column.

Expr.max()

Get maximum value.

Expr.mean()

Get mean value.

Expr.median()

Get median value using linear interpolation.

Expr.min()

Get minimum value.

Expr.n_unique()

Count unique values.

Expr.quantile(quantile[, interpolation])

Get quantile value.

Expr.std([ddof])

Get standard deviation.

Expr.sum()

Get sum value.

Expr.tail([n])

Get the last n rows.

Expr.var([ddof])

Get variance.