Examples for all aggregate functions can be found at: <pkg_install_location>\teradataml\data\notebooks\sqlalchemy\Teradata Vantage Aggregate Functions using SQLAlchemy.ipynb.
Supported functions
| S/N | Function Name | Description |
|---|---|---|
| 1 | Avg / Average / Ave | Returns the arithmetic average of all values in value_expression. |
| 2 | Corr | Returns the Sample Pearson product moment correlation coefficient of its arguments for all non-null data point pairs. |
| 3 | Count | Returns a column value that is the total number of qualified rows in value_expression. |
| 4 | Covar_pop | Returns the population covariance of its arguments for all non-null data point pairs. |
| 5 | Covar_samp | Returns the sample covariance of its arguments for all non-null data point pairs. |
| 6 | Kurtosis | Returns the kurtosis of the distribution of value_expression. |
| 7 | max / maximum | Returns a column value that is the maximum value for value_expression. |
| 8 | min / minimum | Returns a column value that is the minimum value for value_expression. |
| 9 | REGR_AVGX | Returns the mean of the independent_variable_expression for all non-null data pairs of the dependent and independent variable arguments. |
| 10 | REGR_AVGY | Returns the mean of the dependent_variable_expression for all non-null data pairs of the dependent and independent variable arguments. |
| 11 | REGR_Count | Returns the count of all non-null data pairs of the dependent and independent variable arguments. |
| 12 | REGR_Intercept | Returns the intercept of the univariate linear regression line through all non-null data pairs of the dependent and independent variable arguments. |
| 13 | REGR_R2 | Returns the coefficient of determination for all non-null data pairs of the dependent and independent variable arguments. |
| 14 | REGR_SLOPE | Returns the slope of the univariate linear regression line through all non-null data pairs of the dependent and independent variable arguments. |
| 15 | REGR_SXX | Returns the sum of the squares of the independent_variable_expression for all non-null data pairs of the dependent and independent variable arguments. |
| 16 | REGR_SXY | Returns the sum of the products of the independent_variable_expression and the dependent_variable_expression for all non-null data pairs of the dependent and independent variable arguments. |
| 17 | REGR_SYY | Returns the sum of the squares of the dependent_variable_expression for all non-null data pairs of the dependent and independent variable arguments. |
| 18 | Skew | Returns the skewness of the distribution of value_expression. |
| 19 | stddev_pop | Returns the population standard deviation for the non-null data points in value_expression. |
| 20 | stddev_samp | Returns the sample standard deviation for the non-null data points in value_expression. |
| 21 | sum | Returns a column value that is the arithmetic sum of value_expression. |
| 22 | var_pop | Returns the population variance for the data points in value_expression. |
| 23 | var_samp | Returns the sample variance for the data points in value_expression. |
Grouping of columns is not allowed with DataFrame.assign() in teradataml 17.00.00.00. Always use 'drop_column = True' in DataFrame.assign().
Unsupported functions
- grouping
- pivot
- unpivot