How to extract column names that do not have even one missing value in an R data frame?

The extraction of column names that do not have missing values can be done with the help of colnames function along with the complete.cases function. The complete.cases function will extract the columns that do not have missing values then colnames will extract those column names only.

Example1

Consider the below data frame −

 Live Demo

x1<−sample(c(NA,1,0),20,replace=TRUE)
x2<−rpois(20,5)
x3<−sample(c(NA,5,10),20,replace=TRUE)
df1<−data.frame(x1,x2,x3)
df1

Output

   x1  x2 x3
1  1  1  5
2  NA 9 NA
3  0  5  5
4  NA 3 NA
5  0  2 10
6  NA 4 10
7  0  4 NA
8  NA 5  5
9  0  3 10
10 1  1  5
11 0  2  5
12 1  2 10
13 1  7 10
14 NA 8  5
15 1  1 NA
16 NA 3 NA
17 0  9  5
18 0  5  5
19 1  7 NA
20 1  4 10

Extracting column name that do not have missing values −

colnames(df1)[complete.cases(t(df1))]

Output

[1] "x2"

Example2

 Live Demo

y1<−letters[1:20]
y2<−sample(c(NA,"A","B","C"),20,replace=TRUE)
y3<−sample(c(NA,rnorm(5)),20,replace=TRUE)
df2<−data.frame(y1,y2,y3)
df2

Output

   y1  y2  y3
1 a A 1.2176106
2 b A NA
3 c A 0.7633109
4 d <NA> −0.3289873
5 e C 0.7633109
6 f C −0.3289873
7 g C −0.9952887
8 h <NA> 1.2176106
9 i B 1.2176106
10 j <NA> −0.9952887
11 k <NA> NA
12 l A 0.6808376
13 m B 0.7633109
14 n B −0.9952887
15 o C 0.7633109
16 p A NA
17 q C 1.2176106
18 r C −0.9952887
19 s A 0.7633109
20 t B 1.2176106

Extracting column name that do not have missing values −

Example

colnames(df2)[complete.cases(t(df2))]

Output

[1] "y1"

Nizamuddin Siddiqui

Updated on 05-Feb-2021 08:59:48

• Related Questions & Answers
• How to find rows in an R data frame that do not have missing values?
• How to extract values from an R data frame column that do not start and end with certain characters?
• How to remove column names from an R data frame?
• How to extract the first highest occurring value in an R data frame column?
• How to extract a single column of an R data frame as a data frame?
• How to remove underscore from column names of an R data frame?
• How to sort an R data frame column without losing row names?
• How to extract a particular value based on index from an R data frame column?
• How to extract a data frame’s column value based on a column value of another data frame in R?
• How to replace missing values with median in an R data frame column?
• How to remove rows that contains coded missing value for all columns in an R data frame?
• How to remove rows containing missing value based on a particular column in an R data frame?
• How to combine multiple columns into one in R data frame without using column names?
• How to determine the row that have min and max values in an R data frame column?
• Find the value in an R data frame column that exist n times.