Difference between revisions of "Template:NA Handling Table"
From dataZoa Wiki
| Line 5: | Line 5: | ||
<li>Fill forward, then backward</li> | <li>Fill forward, then backward</li> | ||
<li>Fill backward, then forward</li> | <li>Fill backward, then forward</li> | ||
| − | <li>For example: | + | <li>For example: <i>Fill Forward, then Backward</i> of <i>NA, 2, NA, 4, NA</i> yields<i>2, 2, 2, 4, 4</i></li> |
</ul> | </ul> | ||
Latest 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
