Gabor:
In my attempts to provide a reproducible example I now run into the
following problems:
> SP500<-read.zoo("SP500.csv", sep = ",")
Error in read.zoo("SP500.csv", sep = ",") :
index contains NAs
> DGS10<-read.zoo("DGS10.csv",sep=",")
Error in read.zoo("DGS10.csv", sep = ",") :
index contains NAs
> SP500
Error: object "SP500" not found
> DGS10
Error: object "DGS10" not found
>
First ten records of SP500.csv:
Date Open High Low Close Volume Adj. Close*
3-Jan-50 16.66 16.66 16.66 16.66 1260000 16.66
4-Jan-50 16.85 16.85 16.85 16.85 1890000 16.85
5-Jan-50 16.93 16.93 16.93 16.93 2550000 16.93
6-Jan-50 16.98 16.98 16.98 16.98 2010000 16.98
9-Jan-50 17.08 17.08 17.08 17.08 2520000 17.08
10-Jan-50 17.03 17.03 17.03 17.03 2160000 17.03
11-Jan-50 17.09 17.09 17.09 17.09 2630000 17.09
12-Jan-50 16.76 16.76 16.76 16.76 2970000 16.76
13-Jan-50 16.67 16.67 16.67 16.67 3330000 16.67
First ten records of DGS10.csv
DATE VALUE
1/2/1962 4.06
1/3/1962 4.03
1/4/1962 3.99
1/5/1962 4.02
1/8/1962 4.03
1/9/1962 4.05
1/10/1962 4.07
1/11/1962 4.08
1/12/1962 4.08
This worked perfectly yesterday; I did get the NA warnings but it read
the entire file(s) correctly.
John
-----Original Message-----
From: Gabor Grothendieck [mailto:[EMAIL PROTECTED]
Sent: Friday, June 23, 2006 3:24 PM
To: Kerpel, John
Cc: [email protected]
Subject: Re: [R] Problems with weekday extraction from zoo objects
Please provide a reproducible example (and read the posting
guide at the bottom of each email).
On 6/23/06, Kerpel, John <[EMAIL PROTECTED]> wrote:
> Hi Folks!
>
>
>
> I'm struggling with dates - but enough about my personal life.....
>
>
>
> I have two daily time series files. In one (x) the date format is
Y/m/d
> and the other (y) is d/m/y. I used read.zoo on both and they read
into
> R with no problem.
>
>
>
> Then I use: weekdays(as.Date(x$DATE)) and get what I expect - all the
> days of the week in my data set.
>
>
>
> When I use: weekdays(as.Date(y$Date)) I get:
>
>
>
> Error in fromchar(x) : character string is not in a standard
unambiguous
> format
>
>
>
> I've tried to set the format= in read.zoo to format="%d/%m/%Y" but
this
> doesn't seem to solve the problem.
>
>
>
> What's going on here? (I'm new to these dates functions, so please be
> patient - I'll get the hang out of soon!)
>
>
>
> Best,
>
>
>
> John
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
>
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
