[R] Duplicate dates in zoo objects

From: Research <risk2009_at_ath.forthnet.gr>
Date: Tue, 22 Jun 2010 17:35:37 +0300


Hello,

I have a zoo time series read from an excel file which has some dates the same, such as the following example:

02/10/1995     4925.5
30/10/1995     4915.9
23/01/1996     4963.5
23/01/1996     5009.2
04/03/1996     5031.9     # here
04/03/1996     5006.5     # here
03/04/1996     5069.2
03/05/1996     5103.7
31/05/1996     5107.1
01/07/1996     5153.1
02/08/1996     5151.7

Is there a simple way to keep the last price of the ones that have the same dates?

04/03/1996 5031.9
04/03/1996 5006.5

i.e., keep only the "04/03/1996 5006.5" price and discard the previous one... Is there an implicit function that does that or do I need some sort of recursive algorithm?

You can try a solution on this example (for convenience):

x.Date <- as.Date("2003-02-01") + c(1, 3, 7, 7, 14) - 1 x <- zoo(rnorm(5), x.Date)

Zoo object has 2 prices with same dates.

Many thanks in advance,
Costas



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 Tue 22 Jun 2010 - 14:37:25 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 Tue 22 Jun 2010 - 19:10:34 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