[R] Remove thw data from the dataframe

R. Michael Weylandt michael.weylandt at gmail.com
Tue Nov 15 06:08:58 CET 2011


I'm not aware of a way that one can have "blank" data.frame elements
in R....something about this seems mighty suspicious...

For the NA's, if you wish to omit them, I might suggest na.omit()

I don't know if you've seen this, but you should have a look at the
apropos() command. Very helpful

Michael



On Mon, Nov 14, 2011 at 11:50 PM, arunkumar1111 <akpbond007 at gmail.com> wrote:
> Hi,
>
>  I want to remove the entire row from the dataset if any of the row contains
> blank or NA
>
> my dataset look like
>
> State   Year    Y       X2      X3      X4      X5      X6
> State1  1960    27.8    397.5   42.2    50.7    78.3    65.8
> State2  1960    29.9    413.3   38.1    52      79.2    66.9
> State1  1961    29.8    439.2   40.3    54      79.2    67.8
> State2  1961    30.8    459.7   39.5            79.2    69.6
> State1  1962    31.2    492.9   37.3    54.7    77.4    68.7
> State2  1962            528.6   38.1            80.2    73.6
> State1  1963    35.6    560.3   39.3    69.8    80.4    76.3
> State2  1963    36.4    624.6   37.8    65.9            77.2
> State1  1964            666.4   38.4    64.5    85.5    78.1
> State2  1964    38.4    717.8   40.1            93.7    84.7
> State1  1965    40.4    768.2   38.6    73.2            93.3
> State2  1965    40.3            39.8    67.8    104.8   89.7
>
> I want to remove the entire row from the dataset if any of the rows have
> blanks or NA
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Remove-thw-data-from-the-dataframe-tp4041903p4041903.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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