Hi, Try this: myMatrix<-read.table(text=" Name Age ANTONY 27 IMRAN 30 RAJ 22 NAHAS 32 GEO 42 ",sep="",header=TRUE) MinMaxArray <- data.frame(MIN = 25,MAX=35) myMatrix[myMatrix$Age<=MinMaxArray$MAX & myMatrix$Age>=MinMaxArray$MIN,] # Name Age #1 ANTONY 27 #2 IMRAN 30 #4 NAHAS 32
#or subset(myMatrix,myMatrix$Age<=MinMaxArray$MAX & myMatrix$Age>=MinMaxArray$MIN) # Name Age #1 ANTONY 27 #2 IMRAN 30 #4 NAHAS 32 A.K. ----- Original Message ----- From: Rantony <antony.akk...@ge.com> To: r-help@r-project.org Cc: Sent: Tuesday, July 31, 2012 3:58 AM Subject: [R] Remove a complete row as per the Range in a Matrix Hi, Here i have a Matrix MyMatrix <- Name Age --------- ------- ANTONY 27 IMRAN 30 RAJ 22 NAHAS 32 GEO 42 and here i have an array with Minimum and Maximum values. MinMaxArray <- data.frame(MIN = 25,MAX=35) MIN MAX ------ -------- 25 35 ------------------------------------------------------ Now what is, i need to get a matrix by removing the rows which is NOT coming the "Age"-column in between the MIN and MAX value. Is it possible to avoid "for-loop", bcz its a huge matrix. so, final matrix looks like this, Name Age --------- ------- ANTONY 27 IMRAN 30 NAHAS 32 - Thanks in advance, Antony. -- View this message in context: http://r.789695.n4.nabble.com/Remove-a-complete-row-as-per-the-Range-in-a-Matrix-tp4638508.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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. ______________________________________________ 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.
