3.5.6.2 dropNA

dropNA-func

Description

This function return a dataset by removing missing value or empty value rows in vd

Syntax

dataset dropNA(dataset vd [, int text, int end])

Parameter

vd

a dataset, or a column in Origin worksheet

text

If text = 0, text (neither masked nor empty) is not dropped; if text = 1, text is dropped

end(2026)

if end = 0 (default): remove all missing value; if end = 1 (new): remove missing value at beginning and end only.

Return

Returns a dataset by removing missing value or empty value rows in vd

Examples

newbook
col(a) = data(1, 10);
col(a)[5] = "--";
col(b)=dropNA(col(a));