Expand description
Fluent-style API for creating Expr
s
Functionsยง
- approx_
distinct - approximate number of distinct input values
- approx_
median - Computes the approximate median of a set of numbers
- approx_
percentile_ cont - Computes the approximate percentile continuous of a set of numbers
- approx_
percentile_ cont_ with_ weight - Computes the approximate percentile continuous with weight of a set of numbers
- array_
agg - input values, including nulls, concatenated into an array
- avg
- Returns the avg of a group of values.
- bit_and
- Returns the bitwiseBitwiseOperationType::Andof a group of values
- bit_or
- Returns the bitwiseBitwiseOperationType::Orof a group of values
- bit_xor
- Returns the bitwiseBitwiseOperationType::Xorof a group of values
- bool_
and - The values to combine with
AND
- bool_or
- The values to combine with
OR
- corr
- Correlation between two numeric values.
- count
- Count the number of non-null values in the column
- count_
distinct - covar_
pop - Computes the population covariance.
- covar_
samp - Computes the sample covariance.
- first_
value - Returns the first value in a group of values.
- grouping
- Returns 1 if the data is aggregated across the specified column or 0 for not aggregated in the result set.
- last_
value - Returns the last value in a group of values.
- max
- Returns the maximum of a group of values.
- median
- Computes the median of a set of numbers
- min
- Returns the minimum of a group of values.
- nth_
value - Returns the nth value in a group of values.
- regr_
avgx - Compute a linear regression of type RegrType::AvgX
- regr_
avgy - Compute a linear regression of type RegrType::AvgY
- regr_
count - Compute a linear regression of type RegrType::Count
- regr_
intercept - Compute a linear regression of type RegrType::Intercept
- regr_r2
- Compute a linear regression of type RegrType::R2
- regr_
slope - Compute a linear regression of type RegrType::Slope
- regr_
sxx - Compute a linear regression of type RegrType::SXX
- regr_
sxy - Compute a linear regression of type RegrType::SXY
- regr_
syy - Compute a linear regression of type RegrType::SYY
- stddev
- Compute the standard deviation of a set of numbers
- stddev_
pop - Compute the population standard deviation of a set of numbers
- sum
- Returns the sum of a group of values.
- var_pop
- Computes the population variance.
- var_
sample - Computes the sample variance.