Re: Simple NA problem

[Chuck Cleland <ccleland@optonline.net>]

Jan Ivanouw wrote:
> I am sorry I can't find the solution to this simple problem. Can anyone
> help?
>  
> I have a (large) data frame with missing values, like this:
>  
> a       b     c
> 1       3     5
> NA    9     2
> 3       5     2
> NA    8     6
> 5       3     7
>  
> Based on non-missing values of variable a, I want it changed to
>  
> a     b     c
> 1     3     5
> 3     5     2
> 5     3     7
>  
>  
> Thank you
>  
> Jan Ivanouw PhD
> University of Copenhagen
> Denmark

  Does this help?

df <- data.frame(a = c(1, NA, 3, NA, 5),
                 b = c(3,  9, 5,  8, 3),
                 c = c(5,  2, 2,  6, 7))

df
   a b c
1  1 3 5
2 NA 9 2
3  3 5 2
4 NA 8 6
5  5 3 7

newdf <- df[!is.na(df$a),]

newdf
  a b c
1 1 3 5
3 3 5 2
5 5 3 7

-- 
Chuck Cleland, Ph.D.
NDRI, Inc.
71 West 23rd Street, 8th floor
New York, NY 10010
tel: (212) 845-4495 (Tu, Th)
tel: (732) 512-0171 (M, W, F)
fax: (917) 438-0894