Message-ID: <1343738913.17451.YahooMailNeo@web142605.mail.bf1.yahoo.com>
Date: 2012-07-31T12:48:33Z
From: arun
Subject: Remove a complete row as per the Range in a Matrix
In-Reply-To: <1343721519705-4638508.post@n4.nabble.com>
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.