[R] Subsetting problem data

Peter Alspach Peter.Alspach at plantandfood.co.nz
Wed Jul 18 22:54:02 CEST 2012

Tena koe Lib

In case you have receive a reply to this (I didn't notice one), here is one option:

> lib
  A X1 X4 X5
1 A  2  3  3
2 A  3  4 NA
3 B  1  6  6
4 B  2 NA  6
5 C  1  6  5
6 C  3  2  2
> str(lib)
'data.frame':   6 obs. of  4 variables:
 $ A : chr  "A" "A" "B" "B" ...
 $ X1: num  2 3 1 2 1 3
 $ X4: num  3 4 6 NA 6 2
 $ X5: num  3 NA 6 6 5 2
> lib1 <- aggregate(lib[,-1], list(lib[,1]), function(x) length(x[is.na(x)])>0)
> lib1[apply(lib1[,-1], 1, sum)>0,1]
[1] "A" "B"

HTH ...

Peter Alspach

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Lib Gray
Sent: Thursday, 19 July 2012 7:30 a.m.
To: r-help at r-project.org
Subject: [R] Subsetting problem data

Hello, I need to subset my data to only look at the parts that have "holes"
in it. I already have a formula to get rid of inconsistencies, but now I
need to look only at the problem data to reconfigure it. In my data set
where there are multiple "cycles" per "patient," and I want to highlight
the patients who have a variable was not measured every cycle.

Here's a similar example of the data:

Patient, Cycle, Variable1, Variable 2
A, 1, 4, 5
A, 2, 3, 3
A, 3, 4, NA
B, 1, 6, 6
B, 2, NA, 6
C, 1, 6, 5
C, 3, 2, 2

So in this case, I would want Patient A and Patient B, but not Patient C.


	[[alternative HTML version deleted]]

R-help at r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

The contents of this e-mail are confidential and may be subject to legal privilege.
 If you are not the intended recipient you must not use, disseminate, distribute or
 reproduce all or any part of this e-mail or attachments.  If you have received this
 e-mail in error, please notify the sender and delete all material pertaining to this
 e-mail.  Any opinion or views expressed in this e-mail are those of the individual
 sender and may not represent those of The New Zealand Institute for Plant and
 Food Research Limited.

More information about the R-help mailing list