R help - May 2012 - Create and Change Column in a Matrix as per condition

Hi,

i have a matrix like this
  *DWATT *
    10               
    20             
    30               
    30              
    32              
Here i need to create a new column named "*DWATT_QF*" with filling
value as
per the following condition,
if DWATT_QF = RC When DWATT value less than 30 and greater than 31. Which
means, i need output like this,

  *DWATT               DWATT_QF*  
    10                          RC
    20                          RC
    30                          RC
    30                          RC
    32                          RC

Here " GetCsv " is my matrix name. i tried this way and its getting
proper
in "R",
GetCsv[(GetCsv[,ColHdr]< 30) |
(GetCsv[,ColHdr]>31),ColHdr_QF]<-"RC"

But i *not getting in Eclips*, and getting error like "*Sub script Out of
Range*"

Could you please help me fast. Its an urgent !   


- Thanks 
Antony

--
View this message in context:
http://r.789695.n4.nabble.com/Create-and-Change-Column-in-a-Matrix-as-per-condition-tp4631691.html
Sent from the R help mailing list archive at Nabble.com.

Hi Antony,

Try this,
I changed matrix to data frame to make it work and change it back again to
matrix.? There might be a easy way to do this.


?GetCsv<-as.matrix(data.frame("DWATT"=c(10,20,30,30,32)))
?GetCsv<-data.frame(GetCsv)
?GetCsv[GetCsv$DWATT<30 | GetCsv$DWATT >31, "DWAT_QF"]
<-"RC"
?GetCsv[is.na(GetCsv)]<- ""
?GetCsv
? DWATT DWAT_QF
1??? 10????? RC
2??? 20????? RC
3??? 30??????? 
4??? 30??????? 
5??? 32????? RC
?GetCsv<-as.matrix(GetCsv)
?GetCsv
???? DWATT DWAT_QF
[1,] "10"? "RC"?? 
[2,] "20"? "RC"?? 
[3,] "30"? ""???? 
[4,] "30"? ""???? 
[5,] "32"? "RC"?? 


A.K.



----- Original Message -----
From: Rantony <antony.akkara at ge.com>
To: r-help at r-project.org
Cc: 
Sent: Tuesday, May 29, 2012 9:13 AM
Subject: [R] Create and Change Column in a Matrix as per condition

Hi,

i have a matrix like this
? *DWATT *
? ? 10? ? ? ? ? ? ? 
? ? 20? ? ? ? ? ? 
? ? 30? ? ? ? ? ? ? 
? ? 30? ? ? ? ? ? ? 
? ? 32? ? ? ? ? ? ? 
Here i need to create a new column named "*DWATT_QF*" with filling
value as
per the following condition,
if DWATT_QF = RC When DWATT value less than 30 and greater than 31. Which
means, i need output like this,

? *DWATT? ? ? ? ? ? ?  DWATT_QF*? 
? ? 10? ? ? ? ? ? ? ? ? ? ? ? ? RC
? ? 20? ? ? ? ? ? ? ? ? ? ? ? ? RC
? ? 30? ? ? ? ? ? ? ? ? ? ? ? ? RC
? ? 30? ? ? ? ? ? ? ? ? ? ? ? ? RC
? ? 32? ? ? ? ? ? ? ? ? ? ? ? ? RC

Here " GetCsv " is my matrix name. i tried this way and its getting
proper
in "R",
GetCsv[(GetCsv[,ColHdr]< 30) |
(GetCsv[,ColHdr]>31),ColHdr_QF]<-"RC"

But i *not getting in Eclips*, and getting error like "*Sub script Out of
Range*"

Could you please help me fast. Its an urgent !? 


- Thanks 
Antony

--
View this message in context:
http://r.789695.n4.nabble.com/Create-and-Change-Column-in-a-Matrix-as-per-condition-tp4631691.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.