[R] Need help on parsing dates
Don MacQueen
macq at llnl.gov
Mon Feb 23 21:28:29 CET 2004
At 1:37 AM +0530 2/24/04, Ajay Shah wrote:
>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:
You can find out what it is by asking:
mode(A$V1)
class(A$V1)
str(A$V1)
and there are no doubt some other ways to ask.
>
> > 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
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
--
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
More information about the R-help
mailing list