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(kk$year,

Re: [R] stacking consecutive columns

On Wed, Nov 17, 2010 at 10:37 AM, Graves, Gregory ggra...@sfwmd.gov 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]] -

[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

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 column

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

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 =

Re: [R] stacking consecutive columns

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 Subject: Re: [R] stacking

Re: [R] stacking consecutive columns

-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 Gregory, is this what you want? Ok, not the most elegant way

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,