Hi,
I have a data.frame containing a Date column. When using write.csv()
function to generate a CSV file, I always get the Date column formatted as
"YYYY-MM-DD". I would like to have it formatted as "MM/DD/YYYY", but
could not find an easy way to do it. Here is the test code:
d <- data.frame(ticker=c("IBM", "IBM"), date = as.Date(c("2009-12-03",
"2009-12-04")), price=c(120.00, 123.00))
write.csv(d, file="C:/temp/test.csv", row.names=FALSE)
The test.csv generated looks like this:
"ticker","date","price"
"IBM",2009-12-03,120
"IBM",2009-12-04,123
I would like to have the date fields in the CSV formatted as "MM/DD/YYYY".
Is there any easy way to do this?
Thanks in advance.
George Zou
The information contained in this e-mail, and any attachment, is confidential
and is intended solely for the use of the intended recipient. Access, copying
or re-use of the e-mail or any attachment, or any information contained
therein, by any other person is not authorized. If you are not the intended
recipient please return the e-mail to the sender and delete it from your
computer. Although we attempt to sweep e-mail and attachments for viruses, we
do not guarantee that either are virus-free and accept no liability for any
damage sustained as a result of viruses.
Please refer to http://disclaimer.bnymellon.com/eu.htm for certain disclosures
relating to European legal entities.
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
