> 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}} ______________________________________________ R-help@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.