[R] (no subject)

[arun]

Hi Dila,

Try:
transform(melt(dat,id.var=c("Day","Year")),Month=match(variable,month.abb),Amount=value)[,-c(3:4)]
A.K.




On Thursday, February 27, 2014 1:02 AM, dila radi <dilaradi21 at gmail.com> wrote:

Dear Arun,

Thank you so much for your help..but this command doesn't apply if I have more than one id. variables such as follows:

dat <- read.table(text="Day Year Jan Feb Mar Apr 
  1  2012 0 2.5 0.5 2  
  2  2013 0 6.5 0 29
  3  2013 0 9.5 0 0 
  4  2013 0 0 8 0.5 
  5  2013 0 5 0.5 110.5  
  6  2011 0 4 3.5 22  
  7  2012 11 0 12.5 3.5
  8  2011 0 5 8 36.5",sep="",header=TRUE)
library(reshape2)


I have try this but it doesnt work

res <- transform(melt(dat,id.var="Day"),Month=match(variable,month.abb),melt(dat,id.var="Year"),Amount=value)
res

Could you help me on this one..Sorry for asking again and again..
Thank you so much.

Regards,
Dila