Difference between revisions of "Template:NA Handling Table"

From dataZoa Wiki
Jump to: navigation, search
(Created page with "If there are NA values in the calculated Series, you can...<ul><li>Just <i>accept</i> them as-is</li><li>Fill the NAs with neighboring values</li><li>For example:<br><i>Fill F...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
If there are NA values in the calculated Series, you can...<ul><li>Just <i>accept</i> them as-is</li><li>Fill the NAs with neighboring values</li><li>For example:<br><i>Fill Forward, then Backward</i> of<br><br><i>NA, 2, NA, 4, NA</i><br><br>yields<br><br><i>2, 2, 2, 4, 4</i></li></ul>
+
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>
−
{| class="wikitable"
+
<li>Fill forward</li>
−
|-
+
<li>Fill backward</li>
−
! Non-Numeric Type !! Meaning !! String to enter as Input !! String displayed as Output
+
<li>Fill forward, then backward</li>
−
|-
+
<li>Fill backward, then forward</li>
−
| No Data || Data point is known not to exist || ##ND## || ND
+
<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>
−
| Non-Disclosed Data || Data point exists but is not being shown || ##NDD## || NDD
+
−
|-
+
−
| Not Available || Data may exist but is not available || ##NA## || NA
+
−
|}
+

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
Retrieved from "https://docwiki.datazoa.com/index.php?title=Template:NA_Handling_Table&oldid=2581"