[R] Need help on parsing dates
Ajay Shah
ajayshah at mayin.org
Mon Feb 23 21:07:23 CET 2004
I know this:
> library(date)
> x="1979-04-04"
> try=as.date(x, "ymd")
> print(try)
[1] 4Apr79
and that `x' here has to be a string, e.g.:
> x=1979-04-04
> print(x)
[1] 1971
I'm stuck in reading from a file. I say:
> A <- read.table(file="try")
> print(A)
V1 V2
1 1979-04-04 -1.04712042
2 1979-04-06 0.54538055
3 1979-04-09 0.09663392
4 1979-04-11 0.57119871
5 1979-04-12 0.73594112
6 1979-04-17 -1.54422087
7 1979-04-18 -0.20595691
8 1979-04-19 0.12700429
9 1979-04-20 0.42016807
10 1979-04-23 -1.46838241
I am confused - is V1 a number or a string? Looking at it, it must be
a string. But yet:
> library(date)
> try=as.date(A$V1, "ymd")
Error in as.date(A$V1, "ymd") : Cannot coerce to date format
In short, how do I parse in dates of the format yyyy-mm-dd (the ISO
8601 format) or the yyyymmdd format.
And if I may ask the next step: How do I tell R that I have a file
full of data all of which is time-series data, where V1 is the
datetime vector, and all the other columns are time-series, to do
things like ARMA models and ts plots with?
--
Ajay Shah Consultant
ajayshah at mayin.org Department of Economic Affairs
http://www.mayin.org/ajayshah Ministry of Finance, New Delhi
More information about the R-help
mailing list