jdnewm|| @end|ng |rom dcn@d@v|@@c@@u@
Fri Nov 5 01:58:45 CET 2021
Then you are looking at a different file... check your filenames. You have imported the column as character, and R has not yet recognized that it is supposed to be a date, so it can only show what it found.
You will almost certainly find your error if you make a reproducible example.
On November 4, 2021 5:30:22 PM PDT, Val <valkremk using gmail.com> wrote:
>The date from y data file looks like as follow in the Linux environment,
>On Thu, Nov 4, 2021 at 5:00 PM Jeff Newmiller <jdnewmil using dcn.davis.ca.us> wrote:
>> You are claiming behavior that is not something R does, but is something Excel does constantly.
>> Compare what your data file looks like using a text editor with what R has imported. Absolutely do not use a spreadsheet program to do this.
>> On November 4, 2021 2:43:25 PM PDT, Val <valkremk using gmail.com> wrote:
>> >IHi All, l,
>> >I am reading a csv file and one of the columns is named as "mydate"
>> > with this form, 2019-09-16.
>> >I am reading this file as
>> > the structure of the data looks like as follow
>> >mydate : chr "09/16/2019" "02/21/2021" "02/22/2021" "10/11/2017" ...
>> >Please note the format has changed from YYYY-mm-dd to mm/dd/YYYY
>> >When I tried to change this as a Date using
>> >as.Date(as.Date(mydate, format="%m/%d/%Y" )
>> >I am getting this error message
>> > Error in charToDate(x) :
>> > characte string is not in a standard unambiguous format
>> >My question is,
>> >1. how can I read the file as it is (i.e., without changing the date format) ?
>> >2. why does R change the date format?
>> >Thank you,
>> >R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> >PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> >and provide commented, minimal, self-contained, reproducible code.
>> Sent from my phone. Please excuse my brevity.
Sent from my phone. Please excuse my brevity.
More information about the R-help