Replace values according to conditions
I have the following data called mydata in a data.frame Col1 Col2 Col3 Col4 Col5 1 2 4 6 7 8 8 7 3 5 4 4 5 6 7 I want to replace the data according to the following conditions Condition 1 if data <= 3, replace with -1 Condition 2 if data >=6, replace with 1 Condition 3 if data = 4 or data =5, replace with 0 So the expected output for the example, would be Col1 Col2 Col3 Col4 Col5 -1 -1 0 1 1 1 1 1 -1 0 0 0 1 1 1 ... 1. I would like to know if there are better ways to achieve the expected output?
mydata[mydata<=3] = -1 mydata[mydata==4 | mydata==5] = 0 mydata[mydata>=6] = 1 See the Intro to R, section 2.7.
2. What are the symbols for OR and AND in R?
There are two versions: | and & that do elementwise logical comparisons on
vectors; and || and && that are quicker for scalar logical comparisons
(mostly used in 'if' statement conditions).
See the Intro to R, section 2.4 and 9.2.1.
Regards,
Richie.
Mathematical Sciences Unit
HSL
------------------------------------------------------------------------
ATTENTION:
This message contains privileged and confidential inform...{{dropped:20}}