Message-ID: <521B3FBD.5030607@bitwrit.com.au>
Date: 2013-08-26T11:45:01Z
From: Jim Lemon
Subject: transform variables
In-Reply-To: <CAEW+BDLf_=0tTF-ZvJNgVybhS2U9sQURGg1P9iQ9K4wVxnS5Pg@mail.gmail.com>
On 08/26/2013 09:04 PM, catalin roibu wrote:
> Dear all!
>
> I have a data frame composed by 13 columns (year, and 12 months). I want to
> transform this data base in another like this
> year month values
> 1901 1
> 1901 2
> 1901 3
> .....
> 1901 12
> 1902 1
> 1902 2
> ....
> 1902 12
>
> Is there a possibility to succeed that in R?
>
> Thank you!
>
> best regards!
> CR
>
Hi catalin,
Try this:
yrmon<-data.frame(cbind(1901:1905,matrix(rnorm(60),ncol=12)))
names(yrmon)<-c("year",month.abb)
library(prettyR)
yrmon2<-rep_n_stack(yrmon,to.stack=2:13)
yrmon2[order(yrmon2$year),]
Jim