[R] Regrouping data

From: Sandeepa Ramakrishnan <sandeepa_ramakrishnan_at_yahoo.com>
Date: Thu, 07 Apr 2011 17:33:08 +0530 (IST)

Dear R forum

I have just started my venture with R. While I am trying to learn R through the tutorials, I think the current problem I need to address to is beyond my knowledge about R.

I have a dataframe as defined below -

rat_dat = data.frame(name = c("A", "A", "A", "B", "B", "B", "C", "C", "C", "D", "D", "D"),

                              period = c("31-Mar-11", "30-Mar-11", "29-Mar-11", "31-Mar-11", "30-Mar-11", "29-Mar-11",  "31-Mar-11", "30-Mar-11", "29-Mar-11", "31-Mar-11", "30-Mar-11", "29-Mar-11"),
cy_date = c("31-May-11","31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11", "31-May-11"),  values = c(10.42, 10.46, 10.37, 12.62, 12.65, 12.61, 14.10, 14.12, 14.08, 11.11, 11.15, 11.17)) 

> rat_dat

   name    period   cy_date values
1     A 31-Mar-11 31-May-11  10.42
2     A 30-Mar-11 31-May-11  10.46
3     A 29-Mar-11 31-May-11  10.37
4     B 31-Mar-11 31-May-11  12.62
5     B 30-Mar-11 31-May-11  12.65
6     B 29-Mar-11 31-May-11  12.61
7     C 31-Mar-11 31-May-11  14.10
8     C 30-Mar-11 31-May-11  14.12
9     C 29-Mar-11 31-May-11  14.08
10    D 31-Mar-11 31-May-11  11.11

11    D 30-Mar-11 31-May-11  11.15

12    D 29-Mar-11 31-May-11  11.17

My actual data is too large. I need to

(1) rearrange this input as

period  

  cy_date
          A
      B
    C
    D

31-Mar-11
 31-May-11 
10.42
  12.62
14.10
11.11

30-Mar-11
 31-May-11 
10.46
  12.65
14.12
11.15

29-Mar-11
 31-May-11 
10.37
  12.61
14.08
11.17

(2) Also, I need to find the difference between (rat_dat$cy_date) - (rat_dat$period)

I hope I am able to put forward my requirement properly. If not, please forgive me.

Sandeepa

        [[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. Received on Thu 07 Apr 2011 - 15:33:58 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 07 Apr 2011 - 17:10:29 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive