Re: [R] Discretizing data rows into regular intervals

From: wulei wong <wuleiwong_at_gmail.com>
Date: Sun, 03 Apr 2011 23:36:14 +0800

i suggest you'd better translate the.data format to another form like in SAS, the data can be a number count from a fixed time like 2005-01-01, then you can translate the datas to a sequence.

On 03-Apr-2011 5:40 PM, "Gabor Grothendieck" <ggrothendieck_at_gmail.com> wrote:

On Sat, Apr 2, 2011 at 9:31 PM, Linh Tran <Tranlm_at_berkeley.edu> wrote:
> Hi guys,
>
> I'd like to thank you ahead of time for any help that you can offer me.
> I'm kind of stuck trying to do this.
>
> I have a data frame with dates and values (note: only two columns shown):
>
> head(test)
> date value stop
> 1 01/02/05 100 12/01/07
> 2 07/16/05 200 12/01/07
> 3 12/20/05 150 12/01/07
> 4 04/01/06 250 12/01/07
> 5 10/01/06 10 12/01/07
>
> What I need to do is create regularly spaced 3-month intervals (starting
> with the first observed date) with values that are closest to but recorded
> after the date created. I would stop at the stop date. So the result would
> look like:
>
> new_date value
> 1 01/02/05 100
> 2 04/02/05 100
> 3 07/02/05 100
> 4 10/02/05 200
> 5 01/02/06 150
> 6 04/02/06 250
> 7 07/02/06 250
> 8 10/02/06 10
> 9 01/02/07 10
> etc
> etc
> etc 10/02/07 --- ## Final obs since next one would be 1/2/08 (after
> stop date)
>

See question #13 in the zoo-faq vignette: http://cran.r-project.org/web/packages/zoo/index.html and note the existence of zoo's yearqtr class.

--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com

______________________________________________
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.

	[[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 Sun 03 Apr 2011 - 20:27:33 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 Sun 03 Apr 2011 - 20:40:26 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