Re: [R] data in form of a date
Hi, 2006/11/22, James J. Roper <[EMAIL PROTECTED]>: > I often use dates and times in analyses. I just can't figure out how to > format my date or time column in R. So, apparently R sees the date as > something other than date (character). Let's say I am opening a CSV > file, one of the columns of which is a date or time. How do I specify > that when opening the file? In the xlsReadWrite*Pro* version I have implemented an oleDateTime (and oleDate and oleTime) class which works quite nicely with Excel dates - info: http://treetron.googlepages.com/ - download zip: http://treetron.googlepages.com/xlsReadWritePro_1.0.5.zip If you are on windows you might want to try that out. The xlsReadWritePro version is not free like xlsReadWrite, sorry. But as you work in ecology I'll send you a free key (if non-free packages are in principle acceptable for you). Just contact me off list. In the next version of the free xlsReadWrite package I have at least implemented that dates will be retrieved as ISO formated date/time strings. The format is fixed and you are able to convert this to R date related classes (e.g. chron, date, POSIXt/ct/lt, fCalendar). - The new xlsReadWrite is finished but not yet uploaded, I just uploaded it "unofficially": - bin zip: http://treetron.googlepages.com/xlsReadWrite_1.2.0.zip - source: http://treetron.googlepages.com/xlsReadWrite_1.2.0.tar.gz It should be ok, i.e. runs my internal tests, but I want to add some more tests before official release. New is also that you can specify rowNames for matrices (and not only data.frame). Regards, Hans-Peter __ R-help@stat.math.ethz.ch 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.
Re: [R] data in form of a date
James J. Roper escribió: > Dear all, > > I often use dates and times in analyses. I just can't figure out how to > format my date or time column in R. So, apparently R sees the date as > something other than date (character). Let's say I am opening a CSV > file, one of the columns of which is a date or time. How do I specify > that when opening the file? > > Thanks for the help, > > Jim > > Jim, Suppose a matrix F (6575,189) where rows are days and columns some grid points: First we set the starting date of the series (6575 is the total number of days): library(zoo) x.Date<-as.Date("1987-12-31")+ c(1:6575) F.zoo <- zoo(F, x.Date) #then take a look F.zoo[,1] HTH Antonio __ R-help@stat.math.ethz.ch 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.
Re: [R] data in form of a date
Read the help desk article in R News 4/1. On 11/22/06, James J. Roper <[EMAIL PROTECTED]> wrote: > Dear all, > > I often use dates and times in analyses. I just can't figure out how to > format my date or time column in R. So, apparently R sees the date as > something other than date (character). Let's say I am opening a CSV > file, one of the columns of which is a date or time. How do I specify > that when opening the file? > > Thanks for the help, > > Jim > > -- > - > James J. Roper, Ph.D. > Universidade Federal do Paraná > Depto. de Zoologia > Caixa Postal 19020 > 81531-990 Curitiba, Paraná, Brasil > = > E-mail: [EMAIL PROTECTED] > Phone/Fone/Teléfono: 55 41 33611764 > celular: 55 41 99870543 > = > Zoologia na UFPR > http://zoo.bio.ufpr.br/zoologia/ > Ecologia e Conservação na UFPR > http://www.bio.ufpr.br/ecologia/ > - > http://jjroper.sites.uol.com.br > Currículo Lattes > http://lattes.cnpq.br/2553295738925812 > > __ > R-help@stat.math.ethz.ch 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. > __ R-help@stat.math.ethz.ch 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.
Re: [R] data in form of a date
there are probably many other ways but check out read.zoo. I cans end you of read.zoo also if you like. Let me know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James J. Roper Sent: Wednesday, November 22, 2006 4:18 PM To: r-help@stat.math.ethz.ch Subject: [R] data in form of a date Dear all, I often use dates and times in analyses. I just can't figure out how to format my date or time column in R. So, apparently R sees the date as something other than date (character). Let's say I am opening a CSV file, one of the columns of which is a date or time. How do I specify that when opening the file? Thanks for the help, Jim -- - James J. Roper, Ph.D. Universidade Federal do Paraná Depto. de Zoologia Caixa Postal 19020 81531-990 Curitiba, Paraná, Brasil = E-mail: [EMAIL PROTECTED] Phone/Fone/Teléfono: 55 41 33611764 celular: 55 41 99870543 = Zoologia na UFPR http://zoo.bio.ufpr.br/zoologia/ Ecologia e Conservação na UFPR http://www.bio.ufpr.br/ecologia/ - http://jjroper.sites.uol.com.br Currículo Lattes http://lattes.cnpq.br/2553295738925812 __ R-help@stat.math.ethz.ch 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. This is not an offer (or solicitation of an offer) to buy/se...{{dropped}} __ R-help@stat.math.ethz.ch 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.