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-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Lib Gray Sent: Thursday, 19 July 2012 7:30 a.m. To: r-help@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. Thanks! [[alternative HTML version deleted]] ______________________________________________ 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. 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. ______________________________________________ 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.
