Locate index of rows in a dataframe that have the value of NA

r dataframe na
Jin-Dominique picture Jin-Dominique · Nov 10, 2013 · Viewed 41.7k times · Source

Suppose that we have the following data frame:

>  dataset1
      x
  1   1
  2   2
  3   3
  4   NA
  5   5

I want to come up with a R command that computes the row index of the 1-column data frame that contains the value of 'NA'. More specifically, in above dataset1 example, such command would return 4 - because the 'NA' appears in the 4th row of the data frame. How can I make this happen? thank you!

Answer

Jilber Urbina picture Jilber Urbina · Nov 10, 2013

As suggested by Ben Bolker, you can use both which and is.na as in:

> which(is.na(dataset1), arr.ind=TRUE)
  row col
4   4   1  # NA is in row 4 and column 1

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
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
Omit rows containing specific column of NA

I want to know how to omit NA values in a data frame, but only in some columns I am interested in. For example, DF <- data.frame(x = c(1, 2, 3), y = c(0, 10, NA), z=c(NA, 33, 22)) but I only …

Read More