Remove thw data from the dataframe
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.