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 | OFFSET | The number of preceding records to be taken into account for statistics. | Default: 5 |
Number of Records | Integer | 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
Default: 5
-LENGTH:<num> Number of Records
Integer
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