Hi,
I have attached the data files to this note. I use this code:
library(zoo)
z1 <- read.zoo("baltimorefludata.txt", format = "%m/%d/%Y", header = TRUE)
z2 <- read.zoo("baltimorew.txt", format = "%Y%m%d", header = TRUE)
z3<-merge(z1,z2)
write.table(z3, "fluweatherdata_baltimore2.txt", sep="\t")
R is writing the other data to the file but not the dates... Is there a way to also write the dates to the file? Thank you!!
Sincerely,
tom
Thomas Heiman, PhD
Info Systems Eng, Sr
The MITRE Corporation | Center for Enterprise Modernization
Office: 703-983-2951 | theiman at mitre.org<mailto:theiman at mitre.org>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: baltimorew.txt
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110524/db99639e/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: baltimorefludata.txt
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110524/db99639e/attachment-0001.txt>
writing dates to a file
5 messages · Heiman, Thomas J., David Winsemius, Andy Zhu +1 more
On May 24, 2011, at 2:34 PM, Heiman, Thomas J. wrote:
Hi,
I have attached the data files to this note. I use this code:
library(zoo)
z1 <- read.zoo("baltimorefludata.txt", format = "%m/%d/%Y", header =
TRUE)
z2 <- read.zoo("baltimorew.txt", format = "%Y%m%d", header = TRUE)
z3<-merge(z1,z2)
write.table(z3, "fluweatherdata_baltimore2.txt", sep="\t")
R is writing the other data to the file but not the dates... Is
there a way to also write the dates to the file? Thank you!!
?write.zoo
David Winsemius, MD West Hartford, CT
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110524/4b94a18f/attachment.pl>
On Tue, May 24, 2011 at 2:34 PM, Heiman, Thomas J. <theiman at mitre.org> wrote:
Hi,
I have attached the data files to this note. ? I use this code:
library(zoo)
z1 <- read.zoo("baltimorefludata.txt", format = "%m/%d/%Y", header = TRUE)
z2 <- read.zoo("baltimorew.txt", format = "%Y%m%d", header = TRUE)
z3<-merge(z1,z2)
write.table(z3, "fluweatherdata_baltimore2.txt", sep="\t")
R is writing the other data to the file but not the dates... ?Is there a way to also write the dates to the file? ?Thank you!!
z3 is a zoo object so you want write.zoo, not write.table. See ?write.zoo.
Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com
On May 24, 2011, at 4:00 PM, Andy Zhu wrote:
I think if you attach the output file would make clear. I guess it is very likely your merge has the problem, not the write.table.
No. The merge woks fine. write.table is not writing the date indices but write.zoo would. Tested.
david.
> You may need "by" parameter in merge based on the date. It also
> could be date value is converged to numeric value, in this case you
> just need to convert it back.
>
>
> --- On Tue, 5/24/11, Heiman, Thomas J. <theiman at mitre.org> wrote:
>
> From: Heiman, Thomas J. <theiman at mitre.org>
> Subject: [R] writing dates to a file
> To: "R-help at r-project.org" <R-help at r-project.org>
> Date: Tuesday, May 24, 2011, 2:34 PM
>
> Hi,
>
> I have attached the data files to this note. I use this code:
>
> library(zoo)
> z1 <- read.zoo("baltimorefludata.txt", format = "%m/%d/%Y", header =
> TRUE)
> z2 <- read.zoo("baltimorew.txt", format = "%Y%m%d", header = TRUE)
>
> z3<-merge(z1,z2)
>
> write.table(z3, "fluweatherdata_baltimore2.txt", sep="\t")
>
> R is writing the other data to the file but not the dates... Is
> there a way to also write the dates to the file? Thank you!!
>
> Sincerely,
>
> tom
>
> Thomas Heiman, PhD
> Info Systems Eng, Sr
> The MITRE Corporation | Center for Enterprise Modernization
> Office: 703-983-2951 | theiman at mitre.org<mailto:theiman at mitre.org>
>
> -----Inline Attachment Follows-----
>
> ______________________________________________
> 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]]
>
> ______________________________________________
> 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.
David Winsemius, MD
West Hartford, CT