[R] remove NA in df results in NA, NA.1 ... rows

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Thu Dec 13 10:09:02 CET 2012


is.na(df2) is not doing what you think it is doing. Perhaps you should read ?na.omit.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

raphael.felber at art.admin.ch wrote:

>Good morning!
>
>I have the following data frame (df):
>
>X.outer  Y.outer   X.PAD1   Y.PAD1   X.PAD2 Y.PAD2   X.PAD3 Y.PAD3  
>X.PAD4 Y.PAD4
>73 574690.0 179740.0 574690.2 179740.0 574618.3 179650 574729.2 179674
>574747.1 179598
>74 574680.6 179737.0 574693.4 179740.0 574719.0 179688 574831.8 179699
>574724.9 179673
>75 574671.0 179734.0 574696.2 179740.0 574719.0 179688 574807.8 179787
>574729.2 179674
>76 574663.6 179736.0 574699.1 179734.0 574723.5 179678 574703.4 179760
>574831.8 179699
>77 574649.9 179734.0 574704.7 179724.0 574724.9 179673 574702.4 179755
>574852.3 179626
>78 574647.3 179742.0 574706.9 179719.0 574747.1 179598 574702.0 179754
>574747.1 179598
>79 574633.6 179739.0 574711.4 179710.0 574641.8 179570 574698.0 179747 
>     NA     NA
>80 574634.9 179732.0 574716.6 179698.0 574639.6 179573 574700.2 179738 
>     NA     NA
>81 574616.5 179728.6 574716.7 179695.0 574618.3 179650 574704.4 179729 
>     NA     NA
>82 574615.4 179731.0 574718.2 179690.0       NA     NA 574708.1 179724 
>     NA     NA
>83 574614.4 179733.6 574719.1 179688.0       NA     NA 574709.3 179720 
>     NA     NA
>...
>
>44 574702.0 179754.0       NA       NA       NA     NA       NA     NA 
>     NA     NA
>
>45 574695.1 179751.0       NA       NA       NA     NA       NA     NA 
>     NA     NA
>
>46 574694.4 179752.0       NA       NA       NA     NA       NA     NA 
>     NA     NA
>
>Which I subset to
>
>df2 <- df[,c("X.PAD2","Y.PAD2")]
>
>df2
>
>     X.PAD2 Y.PAD2
>
>73 574618.3 179650
>
>74 574719.0 179688
>
>75 574719.0 179688
>
>76 574723.5 179678
>
>77 574724.9 179673
>
>78 574747.1 179598
>
>79 574641.8 179570
>
>80 574639.6 179573
>
>81 574618.3 179650
>
>82       NA     NA
>
>83       NA     NA
>
>...
>
>44       NA     NA
>
>45       NA     NA
>
>46       NA     NA
>
>
>
>
>
>followed by removing the NA's using
>
>
>
>df2 <- df2[!is.na(df2),]
>
>
>
>If I now call df2, I get:
>
>
>
>       X.PAD2 Y.PAD2
>
>73   574618.3 179650
>
>74   574719.0 179688
>
>75   574719.0 179688
>
>76   574723.5 179678
>
>77   574724.9 179673
>
>78   574747.1 179598
>
>79   574641.8 179570
>
>80   574639.6 179573
>
>81   574618.3 179650
>
>NA         NA     NA
>
>NA.1       NA     NA
>
>NA.2       NA     NA
>
>NA.3       NA     NA
>
>NA.4       NA     NA
>
>NA.5       NA     NA
>
>NA.6       NA     NA
>
>NA.7       NA     NA
>
>NA.8       NA     NA
>
>
>
>It seems there are still NA's in my data frame. How can I get rid of
>them? What is the meaning of the rows numbered NA, NA.1 and so on?
>
>
>
>Thanks for any hints.
>
>
>
>Best regards
>
>
>
>Raphael Felber
>
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list