consistent handling of missing values for all endpoints

WHOIGit / nes-lter-ims

NES-LTER information system components

MIT License

5 stars 0 forks source link

consistent handling of missing values for all endpoints #116

Closed joefutrelle closed 7 months ago

joefutrelle commented 10 months ago

Currently a mix of empty cells, "NA", and "NaN" (among others?)

All endpoint CSVs should represent missing values in the same way:

For string and date/time columns, an empty cell
For numeric columns, "NaN"

joannekoch commented 9 months ago

@joefutrelle,

Cast values in some end point files are numeric and they are alphanumeric in other files. I suggest Cast values are classified as numeric and missing Cast values converted to NaN.

Please let me know if you agree.

from joe: the correct behavior would be to carry them through (which means always treating cast numbers as strings)