[R] Column create and Update using function
Rantony
antony.akkara at ge.com
Fri Jul 13 08:42:48 CEST 2012
Hi,
here i have a Max and Min values
Min <-3
Max <-6
and also a matrix like this,
ABC XYZ PQR
------ ------- -------
2 4 3
5 4 8
7 1 3
In this i need to check each particular column values are between Max and
Min value.
If the coulmn value not coming between Max and Min, then i need to create
another coulmn
by adding column name header with "_QF". and assign a string like "RC" for
that particular row.
For eg:- i need to checkout coulmn "ABC".
Here 2,5,6 are the values we need to checkout with Min,Max values. and here
Min <-3,Max <-6
First need to create a new column called "ABC_QF" with current matrix.
ABC XYZ PQR ABC_QF
------ ------- ------- -----------
2 4 3 RC
5 4 8
7 1 3
Next, for 5 , it coming in between 3 to 6. so nothing to do.
ABC XYZ PQR ABC_QF
------ ------- ------- -----------
2 4 3 RC
5 4 8
7 1 3
Next, for 7 , its not coming in between 3 to 6. so put "RC"
ABC XYZ PQR ABC_QF
------ ------- ------- -----------
2 4 3 RC
5 4 8
7 1 3 RC
-----------------------------------------------------------
This is the requirement. i did it using for-loop,it will check each value
and it taking time when bulk of data come.
Any hope to do using lappy,appy kind of functions ? Because at a time
complete coulmn should get update.
Could you please help me urgently ?
- Thanks
Antony.
--
View this message in context: http://r.789695.n4.nabble.com/Column-create-and-Update-using-function-tp4636400.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list