[R] Fwd: DateTime wrong when exporting to csv in R

David Winsemius dwinsemius at comcast.net
Thu Aug 21 00:08:47 CEST 2014


The image file I prepared and attached did not make it through. Trying again.

-- 
David

Begin forwarded message:

> From: David Winsemius <dwinsemius at comcast.net>
> Subject: Re: [R] DateTime wrong when exporting to csv in R
> Date: August 20, 2014 1:48:14 PM PDT
> To: Sneha Bishnoi <sneha.bishnoi at gmail.com>
> Cc: r-help <R-help at r-project.org>
> 
> 
> On Aug 20, 2014, at 4:53 AM, Sneha Bishnoi wrote:
> 
>> Hi All!
>> 
>> This seems to be trival but I am not able to find a solution for it.
>> I have a dataframe with datetime columns in form of  ("%d/%m/%y %H:%M:%OS").
>> 
>> I write it to csv file. Whne i open the csv file the date time format are
>> in some number form .
> 
> What does "same number form" mean?
> 
>> So even if I use custome settings from excel to change it into date time
>> format, it gives me wrong value.
>> 
>> My data frame is as below:
>> 
> 
> PostDate                            Status                 ArrTime              NumGuests
> 2014-08-14 16:13:08.850       O                    2012-01-13 00:00:00.000    6
> 2014-08-14 16:13:08.850       A
> 
>> 
>> -SB
>> 
>> 	[[alternative HTML version deleted]]
> 
> The reason you are asked to post in plain text is to avoid the line wrapping and other mangling of data that html formatting causes. I've reformatted your posting to be what appears to be a very incomplete representation of your file.
> 
> I substituted tabs for the varying number of space
> -- opened and empty excel workbook
> -- formatted the first and third columns with a custom format for a date-time in the POSIX standard format (or a close as I can get to that in Excel, anyway)  as illustrated in the attached .png file.
> 
> 
> 
> -- open the tab-separated file.
> 
> Dates and times all agree.
> 
> 
> 
> 
>> 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
> Alameda, CA, USA
> 

David Winsemius
Alameda, CA, USA



More information about the R-help mailing list