[R] search a value in variables dataset

[ronggui]

use logical index.

> my.reducedID<-read.table(file.choose())
> head(my.reducedID)
     V1 V2 V3 V4 V5 V6 V7 V8 V9
[1,]  1  0  0  1 14  3  1  0  2
[2,]  2  0  0  1 14  3  1  0  2
[3,]  0  1  0  1 14  2  1  0  2
[4,]  0  0  1  1 14  3  1  0  2
[5,]  0  1  1  0 14  2  1  0  2
[6,]  0  0  0  1 14  3  1  0  2
> attach(my.reducedID)
> my.reducedID[(V1==0 & V5==14 & V6==2),]
      V1 V2 V3 V4 V5 V6 V7 V8 V9
[3,]   0  1  0  1 14  2  1  0  2
[5,]   0  1  1  0 14  2  1  0  2
[29,]  0  0  0  1 14  2  1  0  2


======= 2005-10-20 21:59:24 ÄúÔÚÀ´ÐÅÖÐÐ´µÀ£º=======

>Dear R-list,
>I have a dataset, say (the real dataset is 20 columns,110200 rows).
>
> > my.reducedID
>       V1 V2 V3 V4 V5 V6 V7  V8  V9
>  [1,]  1  0  0  1 14  3  1   0   2
>  [2,]  2  0  0  1 14  3  1   0   2
>  [3,]  0  1  0  1 14  2  1   0   2
>  [4,]  0  0  1  1 14  3  1   0   2
>  [5,]  0  1  1  0 14  2  1   0   2
>  [6,]  0  0  0  1 14  3  1   0   2
>  [7,]  0  0  0  1  0  3  1   0   2
>  [8,]  0  0  0  1  1  3  1   0   2
>  [9,]  0  0  0  1  2  3  1   0   2
>[10,]  0  0  0  1  3  3  1   0   2
>[11,]  0  0  0  1  4  3  1   0   2
>[12,]  0  0  0  1  5  3  1   0   2
>[13,]  0  0  0  1  6  3  1   0   2
>[14,]  0  0  0  1  7  3  1   0   2
>[15,]  0  0  0  1  8  3  1   0   2
>[16,]  0  0  0  1  9  3  1   0   2
>[17,]  0  0  0  1 10  3  1   0   2
>[18,]  0  0  0  1 11  3  1   0   2
>[19,]  0  0  0  1 12  3  1   0   2
>[20,]  0  0  0  1 13  3  1   0   2
>[21,]  0  0  0  1 15  3  1   0   2
>[22,]  0  0  0  1 16  3  1   0   2
>[23,]  0  0  0  1 17  3  1   0   2
>[24,]  0  0  0  1 18  3  1   0   2
>[25,]  0  0  0  1 19  3  1   0   2
>[26,]  0  0  0  1 20  3  1   0   2
>[27,]  0  0  0  1 14  0  1   0   2
>[28,]  0  0  0  1 14  1  1   0   2
>[29,]  0  0  0  1 14  2  1   0   2
>[30,]  0  0  0  1 14  4  1   0   2
> >
>
>I want to search a value in variables, say V1=0, V5=14 and V6=2.
>The result should look like
>       V1 V2 V3 V4 V5 V6 V7  V8  V9
>  [3,]  0  1  0  1 14  2  1   0   2
>  [5,]  0  1  1  0 14  2  1   0   2
>[29,]  0  0  0  1 14  2  1   0   2
>
>I can do this with: my.reducedID[c(3,5,29),]
>Because I have very large dataset I can not make this manual.
>Then I need the ID of row did not change, I mean like,
>[3,]
>[5,]
>[29,]
>In dataset this is about ID our customers.
>I was wondering if anyone give me a trick to make simple.
>Thanks you very much for any suggestions.
>
>Best, Muhammad Subianto
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

= = = = = = = = = = = = = = = = = = = =
			


 

2005-10-20

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com