Is this what you want: > x Latitude Longitude Temperature OrigLat p.value Blaney 1 -90 -38.75 NA -87.75 17.10167 NA 2 -90 135.75 NA -87.75 17.10167 NA 3 -90 80.25 NA -87.75 17.10167 NA 4 -90 95.75 NA -87.75 17.10167 NA 5 -90 66.75 NA -87.75 17.10167 NA 6 -90 75.75 NA -87.75 17.10167 NA > y <- melt(x, measure='Blaney') > cast(y, OrigLat ~ Longitude, c) OrigLat -38.75 66.75 75.75 80.25 95.75 135.75 1 -87.75 NA NA NA NA NA NA
On Mon, Aug 17, 2009 at 12:52 PM, Steve Murray<[email protected]> wrote: > > Dear R Users, > > I'm trying to use the 'cast' function in the 'reshape' package to convert > column-format data to gridded-format data. A sample of my dataset is as > follows: > > head(finalframe) > Latitude Longitude Temperature OrigLat p-value Blaney > 1 -90 -38.75 NA -87.75 17.10167 NA > 2 -90 135.75 NA -87.75 17.10167 NA > 3 -90 80.25 NA -87.75 17.10167 NA > 4 -90 95.75 NA -87.75 17.10167 NA > 5 -90 66.75 NA -87.75 17.10167 NA > 6 -90 75.75 NA -87.75 17.10167 NA > > > I'm attempting to form a grid based on the OrigLat, Longitude and Blaney > columns, to form the rows, columns and values of the new grid respectively. > > The command I've been using is: > > cast_test <- cast(finalframe, finalframe$OrigLat~variable, > finalframe$Longitude~variable, finalframe$Blaney~variable) > Error: Casting formula contains variables not found in molten data: > finalframe$OrigLat, variable > > And I've tried removing the ~variable suffixes: > > cast_test <- cast(finalframe, finalframe$OrigLat, finalframe$Longitude, > finalframe$Blaney) > Error: Casting formula contains variables not found in molten data: > -87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75-87.75 > [etc etc] > > > I'm not sure how to get round this error, nor what the 'molten data' is that > the error is referring to. I'm assuming it means the data frame presented > above, yet the variables are clearly present! > > Any help or advice on this would be most welcomed. > > Many thanks, > > Steve > > > _________________________________________________________________ > > [[elided Hotmail spam]] > > ______________________________________________ > [email protected] 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. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? ______________________________________________ [email protected] 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.
