[R] Remove a complete row as per the Range in a Matrix

arun smartpink111 at yahoo.com
Tue Jul 31 14:48:33 CEST 2012


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.akkara at ge.com>
To: r-help at 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 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.




More information about the R-help mailing list