You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

This option applies to time series data only:

Fill missing/bad data with NaNs (Not Number)

This option will, as it says, fill in data gaps with 'NaN' values in the data products. For CSV files, the text 'NaN' is inserted, while MAT files have a built-in type of the same name. Data gaps occur when the time difference between subsequent readings is greater than 1.9 times the sample period (otherwise known as the data rating).

This option will also keep any existing NaNs in the data. These are most often caused by quality control (QAQC) automatic or manual tests. The metadata report accompanying the data product will elaborate on the QAQC test that was applied.

This is the default option.

Do not fill gaps

This option will not take action to fill in data gaps.

This option will cause action to be taken to remove any existing NaNs in the data. Therefore, if the clean option had been selected, data that had been replaced by NaNs will now be removed entirely. There are exceptions to this unfortunately. For device-level time series scalar data, if one sensor at a given time stamp has valid data, the entire time stamp cannot be removed, so the remaining sensors will be left as NaNs. For example in a CSV file:

sample time

sensor 1

sensor 1 flag

sensor 2

sensor 2 flag

Comment

12:00:00

42

1

42

1

Good row.

12:00:01

NaN

4

NaN

9

Two bad values; one QAQC failure, one data gap. If the do not fill gaps is selected, this entire row will be removed.

12:00:02

NaN

4

44

9

One good value, can't remove row.

  • No labels