Statistics
Compute different statistics using your data
Statistics operators allow for quick computation of summary statistics and different types of averages.
See APIs for more details
A q interface can be used to build pipelines programatically. 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
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
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
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
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. |