teradataml supports following set of time series aggregate functions which can be invoked on DataFrame.groupby_time() or DataFrame.resample().
See the teradataml: Time Series Functions section of Teradata Package for Python Function Reference, B700-4008) at https://docs.teradata.com/ for detailed description and usage examples of these functions.
|Sr. No.||Function Name||Description|
|1||bottom()||Returns the smallest number of values in the columns for each group, with or without ties.|
|2||count()||Returns column-wise count for each group.|
Generates statistics for numeric columns. It computes max, mean, min, std, median, mode, and percentiles for numeric columns.
Default statistics include: 'max', 'mean', 'min', 'std'.
|4||delta_t()||Calculates the time difference, or DELTA_T, between a starting and an ending event. The calculation is performed against a time-ordered time series data set.|
|5||first()||Returns the oldest value, determined by the timecode, for each group.|
Returns column-wise kurtosis value for each group.
Kurtosis is the fourth moment of the distribution of the standardized (z) values.
It is a measure of the outlier (rare, extreme observation) character of the distribution as compared with the normal (or Gaussian) distribution.
|7||last()||Returns the newest value, determined by the timecode, for each group.|
|8||mad()||Median Absolute Deviation (MAD) returns the median of the set of values defined as the absolute value of the difference between each value and the median of all values in each group.|
|9||max()||Returns column-wise maximum value for each group.|
|10||mean()||Returns column-wise mean value for each group.|
|11||median()||Returns column-wise median value for each group.|
|12||min()||Returns column-wise minimum value for each group.|
|13||mode()||Returns the column-wise mode of all values in each group.|
Return the value which represents the desired percentile from each group.
The result value is determined by the desired index (di) in an ordered list of values. The following equation is for the di:
di = (number of values in group - 1) * percentile/100
When di is a whole number, that value is the returned result. The di can also be between two data points, i and j, where i<j. In that case, the result is interpolated according to the value specified in interpolation argument.
Returns column-wise skewness of the distribution for each group.
Skewness is the third moment of a distribution. It is a measure of the asymmetry of the distribution about its mean compared with the normal (or Gaussian) distribution.
Returns column-wise sample or population standard deviation value for each group. The standard deviation is the second moment of a distribution.
The computation is more conservative for the population standard deviation to minimize the effect of outliers on the computed value.
|17||sum()||Returns column-wise sum value for each group.|
Returns column-wise sample or population variance of the columns for each group.
|19||top()||Returns the largest number of values in the columns for each group, with or without ties.|