...
In the table below an example of in and output using both methods is given:
Original series |
| Aggregated series |
|
|
|
|
|
|---|---|---|---|---|---|---|---|
| method-> | Normal |
| Alternate |
| Normal | Alternate |
| option-> | allow missing | allow missing |
| do not allow missing | do not allow missing |
|
Date/Time | Value | Value | Calculation | Value | Calculation | Value | Value |
01-01-2007 00:00 | 1 |
|
|
|
|
|
|
01-01-2007 06:00 | 2 |
|
|
|
|
|
|
01-01-2007 12:00 | 3 |
|
|
|
|
|
|
01-01-2007 18:00 | 4 |
|
|
|
|
|
|
02-01-2007 00:00 | 5 | 3,50 | (2 + 3 + 4 + 5)/4 | 3 | (((1+2)/2) + ((2+3)/2) + ((3+4)/2) + ((4+5)/2))/4 | 3,5 | 3 |
02-01-2007 06:00 | 6 |
|
|
|
|
|
|
02-01-2007 12:00 | 7 |
|
|
|
|
|
|
02-01-2007 18:00 | NaN |
|
|
|
|
|
|
03-01-2007 00:00 | 9 | 7,33 | (6 + 7 + 9)/3 | 6 | (((5+6)/2)+((6+7)/2))/2 | - | - |
03-01-2007 06:00 | 10 |
|
|
|
|
|
|
...