Remove NA values from a vector

r max min na missing-data
CodeGuy picture CodeGuy · Oct 10, 2011 · Viewed 542.4k times · Source

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 I remove the NA values so that I can compute the max?

Answer

Josh O'Brien picture Josh O'Brien · Oct 10, 2011

Trying ?max, you'll see that it actually has a na.rm = argument, set by default to FALSE. (That's the common default for many other R functions, including sum(), mean(), etc.)

Setting na.rm=TRUE does just what you're asking for:

d <- c(1, 100, NA, 10)
max(d, na.rm=TRUE)

If you do want to remove all of the NAs, use this idiom instead:

d <- d[!is.na(d)]

A final note: Other functions (e.g. table(), lm(), and sort()) have NA-related arguments that use different names (and offer different options). So if NA's cause you problems in a function call, it's worth checking for a built-in solution among the function's arguments. I've found there's usually one already there.

Related questions

How to extract the row with min or max values?

With a dataframe like this one: ID Year Temp ph 1 P1 1996 11.3 6.80 2 P1 1996 9.7 6.90 3 P1 1997 9.8 7.10 ... 2000 P2 1997 10.5 6.90 2001 P2 1997 9.9 7.00 2002 P2 1997 10.0 6.93 if I want to know where the max value is I type: which.max(df$Temp) and R print the index of the row, …

Read More
min for each row with dataframe in R

I'm try to do a simple minimum across multiple columns in a data frame but the min function automatically returns the min across the whole of each column rather than for each row separately. I'm sure I'm missing something really …

Read More
which.max ties method in R

which.max and which.min will return the smallest index of the max or min value if there are ties. Is there a way around this so that the largest index is returned without affecting the efficiency of the function? …

Read More