Re: [R] Replacing string in matrix with zero

2012-11-15 Thread Nick Duncan
Dear Rolf, You are of course quite right, however I wish the diagonal to be ignored by setting the value to zero. The inf was just recognising the flow value from self to self. A very fair point though. Best, Nick On 15 November 2012 04:10, Rolf Turner wrote: > On 15/11/12 11:13, Nick Duncan wrot

Re: [R] Replacing string in matrix with zero

2012-11-14 Thread Rolf Turner
On 15/11/12 11:13, Nick Duncan wrote: Dear All, I have a matrix in which the diagonal has the string "Inf" in it. In order to be able to do cluster analysis this needs to be replaced with a Zero. I am very sceptical about this assertion. "Inf" means infinity which is of course *NOT* t

Re: [R] Replacing string in matrix with zero

2012-11-14 Thread arun
Cc: r-help@r-project.org Sent: Wednesday, November 14, 2012 7:14 PM Subject: Re: [R] Replacing string in matrix with zero Hello, I doubt your Inf is a string, R does have the numeric value Inf (and -Inf), just try 1/0. As for the question, x <- matrix(1:9, ncol = 3) diag(x) <- 1/0 x x[x ==

Re: [R] Replacing string in matrix with zero

2012-11-14 Thread Rui Barradas
Hello, I doubt your Inf is a string, R does have the numeric value Inf (and -Inf), just try 1/0. As for the question, x <- matrix(1:9, ncol = 3) diag(x) <- 1/0 x x[x == Inf] <- 0 x Note that it could also be diag(x) <- 0 Hope this helps, Rui Barradas Em 14-11-2012 22:13, Nick Duncan escreve

Re: [R] Replacing string in matrix with zero

2012-11-14 Thread Jeremy Miles
You can use ifelse() #Create data for example x <- matrix(data=c(Inf, 2, 3, 4, Inf, 6, 7, 8, Inf), nrow=3) #Turn Inf into zero. x <- ifelse(x == Inf, 0, x) Jeremy On 14 November 2012 14:13, Nick Duncan wrote: > Dear All, > > I have a matrix in which the diagonal has the string "Inf" in it.

[R] Replacing string in matrix with zero

2012-11-14 Thread Nick Duncan
Dear All, I have a matrix in which the diagonal has the string "Inf" in it. In order to be able to do cluster analysis this needs to be replaced with a Zero. I can do this by putting it into Excel, replacing and putting it back into R but it's tedious, and I am sure there is a simple way to do it