Tool Moving Statistics
For each record the statistics over the selected attribute and the specified number of records is calculated.
- Author: O.Conrad (c) 2009
- Menu: Table|Calculus
Parameters
| Name | Type | Identifier | Description | Constraints |
Input | Input | table, input | INPUT | - | - |
Output | Output (*) | table, output, optional | OUTPUT | - | - |
Options | Field | table field | FIELD | - | - |
Order by... (*) | table field | INDEX | - | - |
Missing Records | choice | MISSING | Create output option. If 'complete' specified number of records must be found, 'in range' ignores no-data in found records. | Available Choices: [0] complete records [1] all records in range [2] all records Default: 0 |
Offset | integer number | OFFSET | The number of preceding records to be taken into account for statistics. | Default: 5 |
Number of Records | integer number | LENGTH | The total number of records to be taken into account for statistics. | Minimum: 1 Default: 11 |
Mean | boolean | MEAN | - | Default: 1 |
Mean (*) | table field | FIELD_MEAN | - | - |
Median | boolean | MEDIAN | - | Default: 0 |
Median (*) | table field | FIELD_MEDIAN | - | - |
Minimum | boolean | MIN | - | Default: 0 |
Minimum (*) | table field | FIELD_MIN | - | - |
Maximum | boolean | MAX | - | Default: 0 |
Maximum (*) | table field | FIELD_MAX | - | - |
Standard Deviation | boolean | STDV | - | Default: 0 |
Standard Deviation (*) | table field | FIELD_STDV | - | - |
Lower Standard Deviation | boolean | STDV_LO | - | Default: 0 |
Lower Standard Deviation (*) | table field | FIELD_STDV_LO | - | - |
Higher Standard Deviation | boolean | STDV_HI | - | Default: 0 |
Higher Standard Deviation (*) | table field | FIELD_STDV_HI | - | - |
(*) optional |
Command-line
Usage: saga_cmd table_calculus 5 [-INPUT <str>] [-OUTPUT <str>] [-FIELD <str>] [-INDEX <str>] [-MISSING <str>] [-OFFSET <num>] [-LENGTH <num>] [-MEAN <str>] [-FIELD_MEAN <str>] [-MEDIAN <str>] [-FIELD_MEDIAN <str>] [-MIN <str>] [-FIELD_MIN <str>] [-MAX <str>] [-FIELD_MAX <str>] [-STDV <str>] [-FIELD_STDV <str>] [-STDV_LO <str>] [-FIELD_STDV_LO <str>] [-STDV_HI <str>] [-FIELD_STDV_HI <str>]
-INPUT:<str> Input
table, input
-OUTPUT:<str> Output
table, output, optional
-FIELD:<str> Field
table field
-INDEX:<str> Order by...
table field
-MISSING:<str> Missing Records
choice
Available Choices:
[0] complete records
[1] all records in range
[2] all records
Default: 0
-OFFSET:<num> Offset
integer number
Default: 5
-LENGTH:<num> Number of Records
integer number
Minimum: 1
Default: 11
-MEAN:<str> Mean
boolean
Default: 1
-FIELD_MEAN:<str> Mean
table field
-MEDIAN:<str> Median
boolean
Default: 0
-FIELD_MEDIAN:<str> Median
table field
-MIN:<str> Minimum
boolean
Default: 0
-FIELD_MIN:<str> Minimum
table field
-MAX:<str> Maximum
boolean
Default: 0
-FIELD_MAX:<str> Maximum
table field
-STDV:<str> Standard Deviation
boolean
Default: 0
-FIELD_STDV:<str> Standard Deviation
table field
-STDV_LO:<str> Lower Standard Deviation
boolean
Default: 0
-FIELD_STDV_LO:<str> Lower Standard Deviation
table field
-STDV_HI:<str> Higher Standard Deviation
boolean
Default: 0
-FIELD_STDV_HI:<str> Higher Standard Deviation
table field