Statistics
This page explains how to set up statistics operators, for kdb Insights Enterprise pipelines, using the Web Interface.
Statistics operators allow for quick computation of summary statistics and different types of averages from your data.
See APIs for more details
A q interface can be used to build pipelines programmatically. See the q API for API details.
A Python interface is included along side the q interface and can be used if PyKX is enabled. See the Python API for API details.
The pipeline builder uses a drag-and-drop interface to link together operations within a pipeline. For details on how to wire together a transformation, see the building a pipeline guide.
Descriptive Statistics
This operator computes various descriptive statistics on a dataset.
See APIs for more details
q API: .qsp.stats.describe •
Python API: kxi.sp.stats.describe
Required Parameters:
| name | description | default |
|---|---|---|
| Columns | A list of column names to compute statistics on. | |
| Statistics | A list of statistics which should be computed. |
Simple Moving Average
This operator computes a simple moving average on a dataset.
See APIs for more details
q API: .qsp.stats.sma •
Python API: kxi.sp.stats.sma
Required Parameters:
| name | description | default |
|---|---|---|
| Source Columns | A list of column names on which to compute the average. | |
| Range | The number of records to include in the average. | |
| Destination Columns | The columns to write to. These can overwrite existing columns. |
Exponential Moving Average
This operator computes an exponential moving average on a dataset.
See APIs for more details
q API: .qsp.stats.ema •
Python API: kxi.sp.stats.ema
Required Parameters:
| name | description | default |
|---|---|---|
| Source Columns | A list of column names on which to compute the average. | |
| Alpha | The decay rate. | |
| Destination Columns | The columns to write to. These can overwrite existing columns. |
Time Weighted Average
This operator computes a time weighted average on a dataset containing times.
See APIs for more details
q API: .qsp.stats.twa •
Python API: kxi.sp.stats.twa
Required Parameters:
| name | description | default |
|---|---|---|
| Source Columns | A list of column names on which to compute the average. | |
| Time Column | The name of the column containing the time data. | |
| Range | The number of records to include in the average. | |
| Destination Columns | The columns to write to. These can overwrite existing columns. |