R help - Nov 2009 - Sorting NA's and Graphing a histogram

Let's say I have a dataset

Dataset<-read.csv("Dataset.txt", header=T, row.names=1)

Dataset
   Alpha Beta Gamma Delta
A   1      2        3       4
B   NA    2        4       5
C   NA    3        NA     NA
D   8      9       10      11
E    5     NA     7        13
F   NA    NA     NA       4

I want to remove all rows with more than one NA

So I want it to look like

   Alpha Beta Gamma Delta
A 1        2      3        4
B  NA     2       4        5
D  8       9      10       11
E  5       NA      7       13

Then I want to turn the rownames into variables A, B, D, E that I can work
with as if I had used the attach() cmd, but on the rownames.

plot(A)
-- 
View this message in context:
http://old.nabble.com/Sorting-NA%27s-and-Graphing-a-histogram-tp26157779p26157779.html
Sent from the R help mailing list archive at Nabble.com.

Hi Koraelus,

Here is a suggestion for the first part:

index <- apply(Dataset, 1, function(x) sum( is.na( x ) ) < 2 )
d2 <- Dataset[index ,]
d2
#  Alpha Beta Gamma Delta
# A     1    2     3     4
# B    NA    2     4     5
# D     8    9    10    11
# E     5   NA     7    13

Could you please explain us in more detail what would you like to do in the
second part?

HTH,
Jorge


On Mon, Nov 2, 2009 at 1:57 PM, Koraelus <> wrote:
>
> Let's say I have a dataset
>
> Dataset<-read.csv("Dataset.txt", header=T, row.names=1)
>
> Dataset
>   Alpha Beta Gamma Delta
> A   1      2        3       4
> B   NA    2        4       5
> C   NA    3        NA     NA
> D   8      9       10      11
> E    5     NA     7        13
> F   NA    NA     NA       4
>
> I want to remove all rows with more than one NA
>
> So I want it to look like
>
>   Alpha Beta Gamma Delta
> A 1        2      3        4
> B  NA     2       4        5
> D  8       9      10       11
> E  5       NA      7       13
>
> Then I want to turn the rownames into variables A, B, D, E that I can work
> with as if I had used the attach() cmd, but on the rownames.
>
> plot(A)
> --
> View this message in context:
>
http://old.nabble.com/Sorting-NA%27s-and-Graphing-a-histogram-tp26157779p26157779.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@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.
>
	[[alternative HTML version deleted]]