[R] "timeDate" package: Read dates from xls or txt

jpm miao miaojpm at gmail.com
Tue Sep 30 03:10:01 CEST 2014


Thanks. Could "timeDate" object be transformed to/from "zoo" or "xts"?

2014-09-30 9:01 GMT+08:00 Jeff Newmiller <jdnewmil at dcn.davis.ca.us>:

> If you read the documentation for that package you will find that the
> answer is no, for the simple reason that it doesn't do input or output. It
> does help you with conversions between POSIXt types, and can help figure
> out which days are holidays or weekends, but you need the date in character
> format to start.
>
> For reading in CSV data I use as.is=TRUE or stringsAsFactors=FALSE in my
> call to read.csv. For reading xls files I have had difficulties, which is
> why I prefer to export Excel data to CSV before reading it into R.  One
> XLConnect bug workaround I have used is to convert the timestamp column
> into character using as.character with specified format and then back using
> as.POSIXct and a specified timezone, but it was borne of desperation and
> may not always be necessary or even sufficient.
>
> Please post using plain text rather than HTML format on this list. Only
> you can prevent your postings from being garbled.
> ---------------------------------------------------------------------------
> Jeff Newmiller                        The     .....       .....  Go Live...
> DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
> Go...
>                                       Live:   OO#.. Dead: OO#..  Playing
> Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
> /Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
> ---------------------------------------------------------------------------
> Sent from my phone. Please excuse my brevity.
>
> On September 29, 2014 2:47:01 AM PDT, jpm miao <miaojpm at gmail.com> wrote:
> >Hi,
> >
> >   timeDate package create a date vector like this:
> >
> >   Dates <- c("1989-09-28","2001-01-15","2004-08-30","1990-02-09")
> >
> >
> >   I have a date whose size is large. Could this package read the dates
> >from xls or txt files? Could we convert the read vector (e.g., I
> >usually
> >use XLConnect to read xls files) to the date?
> >
> >   Thanks,
> >
> >Miao
> >
> >       [[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.
>
>

	[[alternative HTML version deleted]]



More information about the R-help mailing list