Hi Dila, Try: transform(melt(dat,id.var="Day"),Month=match(variable,month.abb),Year=2012,Amount=value)[,-c(2:3)]
A.K. On Tuesday, February 25, 2014 11:41 PM, dila radi <dilarad...@gmail.com> wrote: Dear Arun, sorry for asking again. Assume that we used the sama data set dat <- read.table(text="Day Jan Feb Mar Apr 1 0 2.5 0.5 2 2 0 6.5 0 29 3 0 9.5 0 0 4 0 0 8 0.5 5 0 5 0.5 110.5 6 0 4 3.5 22 7 11 0 12.5 3.5 8 0 5 8 36.5",sep="",header=TRUE) But now, I want to split the date into Day, Month and Year as follow: Day Month Year Amount 1 1 2012 0.0 2 1 2012 0.0 3 1 2012 0.0 .................... .................. How do I achieved that? Thank you so much. Regards, Dila On 24 February 2014 20:32, arun <smartpink...@yahoo.com> wrote: > >Hi Dila, >Glad to know it works. >Regards, >Arun > > >On Monday, February 24, 2014 10:59 PM, dila radi <dilarad...@gmail.com> wrote: > >Thank you Arun. I already tried it and it works!! Thank you so much. > > > >On 24 February 2014 19:47, arun <smartpink...@yahoo.com> wrote: > >Hi, >>Try: >>Assuming your dataset looks like below (please use ?dput) >> >>dat <- read.table(text="Day Jan Feb Mar Apr >> 1 0 2.5 0.5 2 >> 2 0 6.5 0 29 >> 3 0 9.5 0 0 >> 4 0 0 8 0.5 >> 5 0 5 0.5 110.5 >> 6 0 4 3.5 22 >> 7 11 0 12.5 3.5 >> 8 0 5 8 36.5",sep="",header=TRUE) >>library(reshape2) >> >>res <- >>transform(melt(dat,id.var="Day"),Date=paste(Day,match(variable,month.abb),2012,sep="/"),Amount=value)[,-c(1:3)] >>A.K. >> >> >> >> >> >>On Monday, February 24, 2014 10:20 PM, dila radi <dilarad...@gmail.com> wrote: >>Hi all, >> >>I have a data set in this form: >> >>Year: 2012 >>Day Jan Feb Mar Apr 1 0 2.5 0.5 2 2 0 6.5 0 29 3 0 9.5 0 0 4 0 0 8 0.5 >>5 0 5 0.5 110.5 6 0 4 3.5 22 7 11 0 12.5 3.5 8 0 5 8 36.5 >>I want to rearrange the data in this form: >> >> Date Amount >>1/1/2012 0 >>2/1/2012 0 >>3/1/2012 0 >>4/1/2012 0 >>... ... >>... ... >> >>How can I achieve this? >> >>Thank you in advanced! >> >>Regards, >>Dila >> >> [[alternative HTML version deleted]] >> >>______________________________________________ >>R-help@r-project.org 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. >> >> > ______________________________________________ R-help@r-project.org 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.
