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.
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.
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@r-project.org
> Sent: Wed, 29 Jul 2015 21:15:45 +0000 (UTC)
> To: sarah.gos...@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.gos...@gmail.com> wrote:
>
>
> On Wed, Jul 29, 2015 at 2:45 PM, farnoosh sheikhi via R-help
> <r-help@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
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your
desktop!
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
