List rows with missing values across multiple columns

Missing can be NA and for character variables it can be certain strings too. This function is experimental and design may change in future releases.

listMissings(data, cols, by, na.strings = c("", "."), quiet = FALSE, as.fun)

Arguments

data

The data to look into.

cols

The columns to look for missings in.

by

If supplied, we are keeping track of the missings within the values of the by columns. In summary, by is included too.

na.strings

Strings that should be interpreted as missing. All spaces will be removed before we compare to na.strings. The default is c("",".") so say " . " is a missing by default.

quiet

Keep quiet? Default is not to.

as.fun

A function that will be run on the result before returning. If first input data set is a data.table, the default is to return a data.table, if not the default is to return a data.frame. Use whatever to get what fits in with your workflow. Default can be configured with NMdataConf.

Value

Invisibly, a data.frame including all findings

See also

Other DataWrangling: compareCols(), dims()