[R] (no subject)

[arun]

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 <dilaradi21 at 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 <smartpink111 at yahoo.com> wrote:


>
>Hi Dila,
>Glad to know it works.
>Regards,
>Arun
>
>
>On Monday, February 24, 2014 10:59 PM, dila radi <dilaradi21 at gmail.com> wrote:
>
>Thank you Arun. I already tried it and it works!! Thank you so much.
>
>
>
>On 24 February 2014 19:47, arun <smartpink111 at 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 <dilaradi21 at 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 at 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.
>>
>>
>