Re: [R] stacking consecutive columns

On Wed, Nov 17, 2010 at 10:37 AM, Graves, Gregory wrote: > Follows is the exact solution to this: > > v <- NULL > > #note that decreasing is FALSE so preceding year preceeds > > for(i in 2:46) { >  kk <- melt(yearmonth[, c(1, i, i+1)], id.vars="month", variable_name="year") >  v[[i-1]] <- kk[order

Re: [R] stacking consecutive columns

On Nov 17, 2010, at 16:37 , Graves, Gregory wrote: > Follows is the exact solution to this: > > v <- NULL > > #note that decreasing is FALSE so preceding year preceeds > > for(i in 2:46) { > kk <- melt(yearmonth[, c(1, i, i+1)], id.vars="month", variable_name="year") > v[[i-1]] <- kk[order(k

Re: [R] stacking consecutive columns

On Nov 17, 2010, at 10:37 AM, Graves, Gregory wrote: Follows is the exact solution to this: v <- NULL #note that decreasing is FALSE so preceding year preceeds for(i in 2:46) { kk <- melt(yearmonth[, c(1, i, i+1)], id.vars="month", variable_name="year") v[[i-1]] <- kk[order(kk$year, decre

Re: [R] stacking consecutive columns

ESK: 561 / 682 - 2429       CELL:  561 / 719 - 8157 -Original Message- From: Patrick Hausmann [mailto:patrick.hausm...@uni-bremen.de] Sent: Wednesday, November 17, 2010 9:49 AM To: r-help@r-project.org; Graves, Gregory Subject: Re: [R] stacking consecutive columns Hi Grego

Re: [R] stacking consecutive columns

South Florida Water Management District Phones:  DESK: 561 / 682 - 2429       CELL:  561 / 719 - 8157 -Original Message- From: Patrick Hausmann [mailto:patrick.hausm...@uni-bremen.de] Sent: Wednesday, November 17, 2010 9:49 AM To: r-help@r-project.org; Graves, Gregory Subje

Re: [R] stacking consecutive columns

Hi Gregory, is this what you want? Ok, not the most elegant way... # using 'melt' from the 'reshape' package library(reshape) Data <- data.frame(month = 1:12, x2002 = runif(12), x2003 = runif(12), x2004 = runif(12), x2005 = ru

Re: [R] stacking consecutive columns

Dear Gregory, Is there an easier, cleaner way to do this? Thanks. There are of course several ways... (assuming yearmonth to be a data.frame) --- 1 --- year <- colnames (yearmonth) [-1] year <- gsub ("^[^[:digit:]]*([[:digit:]]*[^[:digit:]]*$)", "\\1", year) year <- as.numeric (year) month

Re: [R] stacking consecutive columns

one approach is the following: # say 'Data' is your data frame DataNew <- reshape(Data, direction = "long", varying = list(2:length(Data))) DataNew$year <- rep(2000:2009, each = 12) DataNew I hope it helps. Best, Dimitris On 11/17/2010 3:03 PM, Graves, Gregory wrote: I have a file, each col

[R] stacking consecutive columns

I have a file, each column of which is a separate year, and each row of each column is mean precipitation for that month. Looks like this (except it goes back to 1964). monthX2000 X2001 X2002 X2003 X2004 X2005 X2006 X2007 X2008 X2009 11.600 1.010 4.320 2.110 0.