Hi,
It is better to show example data using ?dput().
dat <- structure(list(row.names = 1:4, XYZ = c("sample",
"sample2",
"sample3", "sample4"), `000_001` = c("sample",
"Au5", "C", "C"
), `000_002` = c("sample", "Au32", "C",
"Au4"), `000_003` = c("sample",
"Au5", "A", "AC")), .Names =
c("row.names", "XYZ", "000_001",
"000_002", "000_003"), class = "data.frame",
row.names = c(NA,
-4L))
dat[,intersect(grep("Au5", dat),
grep("\\bC\\b",dat)),drop=FALSE]
#? 000_001
#1? sample
#2???? Au5
#3?????? C
#4?????? C
A.K.
On Tuesday, April 29, 2014 9:45 AM, "pascalbells at libero.it"
<pascalbells at libero.it> wrote:
Hello,
thank you for accepting me into the list.
I have the following dataframe:
? row.names? X? ? ? ? ? Y? ? ? Z? ? 000_001? 000_002? 000_003
1? ? ? ? ? ? ? ? ? ? sample? ? ? ? ? ? ? ? ? ? sample? ? sample? ? sample
2? ? ? ? ? ? ? ? ? ? sample2? ? ? ? ? ? ? ? ? Au5? ? ? ? Au32? ? ? Au5
3? ? ? ? ? ? ? ? ? ? sample3? ? ? ? ? ? ? ? ? C? ? ? ? ? ? ? C? ? ? ? ? ? C
4? ? ? ? ? ? ? ? ? ? ...........?
..
..n? ? ? ? ? ? ? ? ? ? ............? ? ? ? ? ? ? ? ? ? ....? ? ? ? ? ? .......?
? ? ? ............
I would like to select al the columns that have Au5 and C.
thank you in advance for your help,
james
??? [[alternative HTML version deleted]]
______________________________________________
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.