Question

How to remove rows with one or more NA in data frame with R

Answer 1

df = data.frame(a = c(1, 3, NA, NA),
                b = c(12, 98, 89, 20),
                c = c(2, 4, 6, 9),
                d = c(13, 77, NA, 20),
                row.names = c('o', 'p', 's', 't'))
 
print(df)
 
df = df[complete.cases(df),]
 
print(df)
 
 
 
       
       
# run:
#
#    a  b c  d
# o  1 12 2 13
# p  3 98 4 77
# s NA 89 6 NA
# t NA 20 9 20
#   a  b c  d
# o 1 12 2 13
# p 3 98 4 77
#

 

70+ SQL courses for beginners and professionals