Complete Cases in R with Examples

Complete cases in R, To eliminate missing values from a vector, matrix, or data frame, use the complete.cases() function in R.

The following is the fundamental syntax for this function.

How to Read rda file in R (with Example) » finnstats

You can delete any values that are missing from the vector

vector <- x[complete.cases(x)]

In any column in the data frame, remove rows with missing values.

df <- df[complete.cases(df), ]

Now, in certain columns of the data frame, eliminate entries with NA.

Correlation Analysis Different Types of Plots in R » finnstats

df <- df[complete.cases(df[ , c('col1', 'col2', ...)]), ]

Complete Cases in R with Examples

The examples below demonstrate how to utilize this function in practice.

Approach 1: Remove any values that are missing from the vector.

To delete all NA values from a vector, use the following code,

vect <- c(5, 3, 4,5, NA, 64, 25, NA, 19)

We can now delete the NA values from the vector.

Principal Component Analysis in R » finnstats

vect <- vect [complete.cases(vect)]
vect

[1]  5  3  4  5 64 25 19

Approach 2: Rows having NA in any column of the data frame should be removed.

The following code explains how to remove rows from a data frame that have NA values in any column,

Let’s create a data frame,

df <- data.frame(A=c(10, 2, NA, 16, NA, 23),
                 B=c(NA, 45, 45, 12, NA, 18),
                 C=c(NA, 45, 12, 5, 18, 22))
df

   A  B  C
1 10 NA NA
2  2 45 45
3 NA 45 12
4 16 12  5
5 NA NA 18
6 23 18 22

In any column data frame, eliminate rows with a NA value.

eXtreme Gradient Boosting in R » Ultimate Guide » finnstats

df <- df[complete.cases(df), ]
df

Approach 3: Rows containing NA in specific columns of a data frame should be removed.

The following code explains how to remove rows from a data frame that have NA values in certain columns,

df <- data.frame(A=c(10, 2, NA, 16, NA, 23),
                 B=c(NA, 45, 45, 12, NA, 18),
                 C=c(NA, 45, 12, 5, 18, 22))
df

   x  y  z
1  1 NA NA
2 24  3  7
3 NA  4  5
4  6  8 15
5 NA NA  7
6  9 12 14

Rows with a NA value in the A or B column should be removed.

Time Series Trend Analysis in R » finnstats

df <- df[complete.cases(df[ , c('A', 'B')]), ]df

   A  B  C
2  2 45 45
4 16 12  5
6 23 18 22