Try this: 1) xtabs(values ~ name + period + cy_date, rat_dat)
2) as.Date(rat_dat$cy_date, '%d-%b-%y') - as.Date(rat_dat$period, '%d-%b-%y') On Thu, Apr 7, 2011 at 9:03 AM, Sandeepa Ramakrishnan <sandeepa_ramakrish...@yahoo.com> wrote: > > > > > > > > > > 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@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. > > -- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O ______________________________________________ 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.