Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing

What's The REAL Secret To First Date Success With a Woman? Click Here To Find Out

Teach Your Child To Read

Powerful WordPress hosting for WordPress professionals

Disclosure: My content contains affiliate links.

29,372 questions

38,322 answers

573 users

How to remove rows with all NA in data frame with R

1 Answer

0 votes
df = data.frame(a = c(1, 3, NA, NA),
                b = c(12, 98, NA, 20),
                c = c(2, 4, NA, 9),
                d = c(13, 77, NA, 20),
                row.names = c('o', 'p', 's', 't'))
 
print(df)
 
df = df[rowSums(is.na(df[ , 0:ncol(df)])) < ncol(df), ]
 
print(df)
 
 
 
       
       
# run:
#
#    a  b  c  d
# o  1 12  2 13
# p  3 98  4 77
# s NA NA NA NA
# t NA 20  9 20
#    a  b c  d
# o  1 12 2 13
# p  3 98 4 77
# t NA 20 9 20
#

 


Protect Your Privacy - Download VPN


answered Jul 9, 2021 by avibootz

Related questions

1 answer 49 views
1 answer 44 views
1 answer 62 views
1 answer 54 views
1 answer 55 views
...