[R] Mixed Date Formats

farnoosh sheikhi farnoosh_81 at yahoo.com
Thu Jul 30 17:23:10 CEST 2015


Thank you all for your help.I came to this conclusion that data needs to be verified by its source. Thanks again. 
 


     On Thursday, July 30, 2015 7:07 AM, John Kane <jrkrideau at inbox.com> wrote:
   

 That's what I get for reading without a cup of tea beside me. I looked at 5 and my eye just slide over the last entries. 


I change my assessment : this looks bad. (Tea at hand).

So, presumably Farnoosh may not be able to guarantee the formats for 3 & 4 either unless they are unambiguously dated.


John Kane
Kingston ON Canada


> -----Original Message-----
> From: sarah.goslee at gmail.com
> Sent: Thu, 30 Jul 2015 09:19:55 -0400
> To: jrkrideau at inbox.com
> Subject: Re: [R] Mixed Date Formats
> 
> On Thu, Jul 30, 2015 at 9:14 AM, John Kane <jrkrideau at inbox.com> wrote:
>> This does not look good. But not too bad
>> 
>> Can we assume that the original data is in D-M-Y in all cases. The
>> values at 3 & 4 in the sample data are ambigous, in that someone may be
>> using the American dating system of M-D-Y.  Given the rest of the data
>> it seems unlikely but possible.
> 
> Take a look at 5 and 7:
>>  5  1375 31/12/2011 # dd/mm/yyyy
>>  7  3423 01/22/2011 # mm/dd/yyyy
> 
> They're unambiguously different.
> 
>> Otherwise it looks possible, but probably not for me since I'm lousy at
>> things like grep, to sort the data set into three parts based on the
>> last three characters in the Year part of the date, convert and
>> recombine.
> 
> It would be easy if month and day were consistent, regardless of year
> format.
> 
> 
>> SampleData
>>  id value      date
>>  1  5813  19-Dec-11
>>  2  8706  07-Dec-11
>>  3  4049  06/05/11
>>  4  5877  05/12/11
>>  5  1375 31/12/2011
>>  6  2223 10/19/2011
>>  7  3423 01/22/2011
>> 
>> John Kane
>> Kingston ON Canada
>> 
>> 
>>> -----Original Message-----
>>> From: r-help at r-project.org
>>> Sent: Wed, 29 Jul 2015 21:15:45 +0000 (UTC)
>>> To: sarah.goslee at gmail.com
>>> Subject: Re: [R] Mixed Date Formats
>>> 
>>> Hi Sarah,
>>> Thanks for getting back to me.Here is an example of my data:SampleData
>>> <-
>>> structure(list(id = 1:7, value = c(5813L, 8706L, 4049L, 5877L,
>>> 1375L, 2223L, 3423L), date = structure(c(4L, 3L, 2L, 1L, 7L,
>>> 6L, 5L), .Label = c("05/12/11", "06/05/11", "07-Dec-11",
>>> "19-Dec-11", "01/22/2011", "10/19/2011", "31/12/2011"
>>> ), class = "factor")), .Names = c("id", "value", "date"), row.names =
>>> c(NA,
>>> -7L), class = "data.frame")SampleData
>>> Thanks for your help:).
>>> 
>>> 
>>> 
>>> 
>>>      On Wednesday, July 29, 2015 1:50 PM, Sarah Goslee
>>> <sarah.goslee at gmail.com> wrote:
>>> 
>>> 
>>>  On Wed, Jul 29, 2015 at 2:45 PM, farnoosh sheikhi via R-help
>>> <r-help at r-project.org> wrote:
>>>>  Hi Arun,
>>>> Hope all is well with you. I have a data with a column for date.The
>>>> date
>>>> format is mixed. There are date values with Month/Day/Year format and
>>>> values with Day/Month/Year format.I don't know how to unify it.I
>>>> really
>>>> appreciate your help.Thanks.
>>> 
>>> You sent this to the R-help list, not just to Arun, so I'm assuming
>>> this is an R question. The best way to get help is to provide a sample
>>> of your data using dput() and to clearly specify what you would like
>>> as the result - "unify" is a bit vague. paste(x, collapse="") could be
>>> considered unification, after all.
>>> 
>>> Sarah
>>> 
>>> --
>>> Sarah Goslee
>>> http://www.functionaldiversity.org
>>> 
>>> 
>> 
> 
> 
> 
> --
> Sarah Goslee
> http://www.functionaldiversity.org

____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family!
[[elided Yahoo spam]]



  
	[[alternative HTML version deleted]]



More information about the R-help mailing list