Difference between revisions of "Template:NA Handling Table"
From dataZoa Wiki
Line 1: | Line 1: | ||
− | In calculations, NA values in the inputs yield NAs as outputs by default. Optionally, you can. | + | In calculations, NA values in the inputs yield NAs as outputs by default. Optionally, you can fill the inputs with their neighboring values before they are evaluated. In particular: |
+ | <ul> | ||
+ | <li>Fill forward</li> | ||
+ | <li>Fill backward</li> | ||
+ | <li>Fill forward, then backward</li> | ||
+ | <li>Fill backward, then forward</li> | ||
+ | <li>For example:<br><i>Fill Forward, then Backward</i> of <i>NA, 2, NA, 4, NA</i> yields<i>2, 2, 2, 4, 4</i></li> | ||
+ | </ul> |
Revision as of 14:25, 27 January 2017
In calculations, NA values in the inputs yield NAs as outputs by default. Optionally, you can fill the inputs with their neighboring values before they are evaluated. In particular:
- Fill forward
- Fill backward
- Fill forward, then backward
- Fill backward, then forward
- For example:
Fill Forward, then Backward of NA, 2, NA, 4, NA yields2, 2, 2, 4, 4