Difference between revisions of "Missing values"
Nils Duepont (talk | contribs) |
Nils Duepont (talk | contribs) |
||
| Line 2: | Line 2: | ||
Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention. | Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention. | ||
| − | Still, below you can find a set of "missing codes" that have been agreed upon, and it is | + | Still, below you can find a set of "missing codes" that have been agreed upon, and it is '''strongly recommended''' to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on certain types of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS. |
{|class="wikitable sortable" border="1" | {|class="wikitable sortable" border="1" | ||
Revision as of 20:04, 12 September 2024
The recommended way of flagging "missing data" in WeSIS is by using an exclamation mark in the column user_na_values (cf. file formats). A detailed description of how to input and upload data containing "missings" can be found in the file upload guide.
Such a way of flagging missing data is very generic to give the data providers room for defining "missings" in line with their intention.
Still, below you can find a set of "missing codes" that have been agreed upon, and it is strongly recommended to comply whenever you see fit with your indicator to ensure consistency across WeSIS. If you need more codes for unveiling additional information on certain types of "missingness" try to add codes that fit the already existing scheme (e.g., using -444, -555 etc.). In this case, please extend the list so that other projects can adopt your suggestion. Keep in mind that you still should document the use of any "missing codes" on each indicator page in the "Quick info box" under "Value labels" to also show up in WeSIS.
| Suggested column name | Description |
|---|---|
| -999 | No information available |
| -888 | Absence of a program |
| -777 | Not applicable |
| -9999 | Program not (yet) introduded (applies to indicators with introduction years only) |
