DATA MINING Desktop Survival Guide by Graham Williams
Desktop Survival Project Home List of Figures List of Tables Data Mining Data Mining Data Mining with Rattle Introduction Data Transform Explore A Model Building Framework Unsupervised Modelling Two Class Models Multi Class Models Regression Models Text Mining Evaluation and Deployment Moving into R Troubleshooting R for the Data Miner R Data Graphics in R Understanding Data Preparing Data Building Models Evaluating Models Algorithms Apriori Bagging Bayes Classifier Boosting Cluster Analysis Conditional Trees Hierarchical Clustering K-Means K-Nearest Neighbours Linear Models Logistic Regression Neural Networks Support Vector Machines Text Mining Open Products AlphaMiner Borgelt Data Mining Suite KNime R Rattle Weka Closed Products C4.5 Clementine Equbits Foresight GhostMiner InductionEngine ODM Enterprise Miner Statistica Data Miner TreeNet Virtual Predict Appendicies Glossary Bibliography Index

Finding Index of Elements

To obtain a list of row indicies for a matrix or data frame for those rows meeting some criteria we can use the which function:

> which(iris$Sepal.Length == 6.2)
[1]  69  98 127 149

Conditions can be combined, in which case it becomes useful to use the with function, which specifies a dataset with which to evaluate the expression:

> with(iris, which(Sepal.Length < 6.2 & Sepal.Width > 4))
[1] 16 33 34

Similarly for a matrix:

> A <- matrix(c(1:19, 10), 4, 5)
> A
     [,1] [,2] [,3] [,4] [,5]
[1,]    1    5    9   13   17
[2,]    2    6   10   14   18
[3,]    3    7   11   15   19
[4,]    4    8   12   16   10
> which(A == 11, arr.ind = TRUE)
     row col
[1,]   3   3
>  which(A == 14, arr.ind = TRUE)
     row col
[1,]   2   4
>  which(A == 10, arr.ind = TRUE)
     row col
[1,]   2   3
[2,]   4   5

Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware.