# [R] matrix looping accessing previous column

R_novice kasojim at battelle.org
Mon Dec 27 19:11:03 CET 2010

```Hi,

I have a matrix with numbers and character. I want to evaluate each cell and
change the value of the cell before it depending on the evaluation. My
evaluation: if a cell had the word "down" change the cell preceding it to a
negative number by multiplying that value by a -1. I am have trouble going
back on clumn to make this change. I'm receiving an error on the j-1 part,
and the "down" cells are converted to 'NA'.
A sample of my data matrix and code are pasted below. Any suggestions would
be appreciated. Thanks!

Data:

PROBE 1     2.5     UP
PROBE 2     1        UP
PROBE 3     1.4     DOWN
PROBE 4     2.0     UP
PROBE 5     1.3     DOWN

#TAKE PART OF MATRIX
CEM1_PARTIAL <- CEM1[1:3,1:5]

for(j in 1:ncol(CEM1_PARTIAL))
{
for(i in 1:nrow(CEM1_PARTIAL))
{
if(CEM1_PARTIAL[i,j] == "down")
{CEM1_PARTIAL[i,j-1]= CEM1_PARTIAL[i,j-1] * -1;}
}
}

error:
Warning messages:
1: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors
2: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors
3: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors
4: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors
5: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors
6: In Ops.factor(CEM1_PARTIAL[i, j - 1], -1) :
* not meaningful for factors

--
View this message in context: http://r.789695.n4.nabble.com/matrix-looping-accessing-previous-column-tp3165308p3165308.html
Sent from the R help mailing list archive at Nabble.com.

```