[R] Average row and column

[MSousa]

Sorry, I ll explain better.

    For example in the next dataset, 

x<-data.frame(v_source=3,v_destine=3,dist=4)
x<-rbind(x,data.frame(v_source=7,v_destine=7,dist=0))
x<-rbind(x,data.frame(v_source=6,v_destine=6,dist=0))
x<-rbind(x,data.frame(v_source=4,v_destine=4,dist=56))
x<-rbind(x,data.frame(v_source=4,v_destine=3,dist=61))
x<-rbind(x,data.frame(v_source=3,v_destine=3,dist=300))
x<-rbind(x,data.frame(v_source=3,v_destine=3,dist=27))
x<-rbind(x,data.frame(v_source=3,v_destine=3,dist=87))
x<-rbind(x,data.frame(v_source=3,v_destine=4,dist=49))


when execute this instruction gives
res<-table(x$v_source,x$v_destine)
  3 4 6 7
3 4 1 0 0
4 1 1 0 0
6 0 0 1 0
7 0 0 0 1
   
my idea is that if possible, is an array like this, 
but instead of having the frequency having the minimum or average.
appears 4 times, no lugar de aparecer o valor 4 na matriz, 

Appears 4 times, instead of the value displayed in the matrix 4, show the
average 
value of all in the case mean 104.5 (4, 300,27,87).

The idea was to the average value for each combination of row and column.
the idea is to get something like the following matrix.
       3        4  6 7
3 104.5 49  0 0
4  61      56  0 0
6  0         0   0 0
7  0        0   0    0

Thanks
.


--
View this message in context: http://r.789695.n4.nabble.com/Average-row-and-column-tp4474524p4475135.html
Sent from the R help mailing list archive at Nabble.com.