How to include NA data in a table

r na crosstab xtable
gfa2001 picture gfa2001 · Jul 14, 2018 · Viewed 7.1k times · Source

I've recently been using the package tab in R to build frequency tables. Using the tabfreq() or the tabmulti() functions, the default output excludes NA values. Does anyone know the command to include NA values within these functions?

Answer

coip picture coip · Mar 29, 2019

The table() function in base R can display missing values (i.e. NAs) via useNA, which takes several arguments: "no", "ifany", or "always". 

data(airquality) # loads the built-in data frame, which has NAs
table(airquality$Ozone, useNA = "always") # always displays the number of missing values
table(airquality$Wind, useNA = "ifany") # only displays the number of missing values if there are some

Related questions

How do I replace NA values with zeros in an R dataframe?

I have a data frame and some columns have NA values. How do I replace these NA values with zeroes?

Read More
Remove NA values from a vector

I have a huge vector which has a couple of NA values, and I'm trying to find the max value in that vector (the vector is all numbers), but I can't do this because of the NA values. How can …

Read More
Subset of rows containing NA (missing) values in a chosen column of a data frame

We have a data frame from a CSV file. The data frame DF has columns that contain observed values and a column (VaR2) that contains the date at which a measurement has been taken. If the date was not recorded, …

Read More