[R] Indexing to Insert values from a dataframe into a matrix

Daisy Englert Duursma daisy.duursma at gmail.com
Wed Jun 29 03:18:14 CEST 2011


Hello,

I think this is a simple problem but I am not coming up with a simple
solution. I think it just an indexing problem.

I can easily replace values in a matrix from a dataframe when the
dataframe has row and column numbers. In the example below I use row
and column names and  I can not get it to work

#make a matrix where rows and columns are the lat and long for a
bounding box of Australia and all elements have the value of -9990

bb<-matrix(c(rep(-9999,691*886)),nrow=691
,ncol=886,dimnames=list(seq(-10,-44.50,by=-0.05),seq(112,156.25,by=0.05)))

#dfr with row names and col names and values to be replaced in the matrix

dfr <- data.frame(cbind(x=seq(120,125,by=0.05), y=-25, var.1=1))

#insert the values from the dfr into the matrix
bb[dfr$x,dfr$y]<-d$var.1

Thanks for your help,
Daisy



More information about the R-help mailing list