Re: [R] Mixed Date Formats

2015-07-30 Thread farnoosh sheikhi via R-help
> Sent: Thu, 30 Jul 2015 09:19:55 -0400 > To: jrkrid...@inbox.com > Subject: Re: [R] Mixed Date Formats > > On Thu, Jul 30, 2015 at 9:14 AM, John Kane wrote: >> This does not look good. But not too bad >> >> Can we assume that the original data is in D-M-Y in all

Re: [R] Mixed Date Formats

2015-07-30 Thread John Kane
biguously dated. John Kane Kingston ON Canada > -Original Message- > From: sarah.gos...@gmail.com > Sent: Thu, 30 Jul 2015 09:19:55 -0400 > To: jrkrid...@inbox.com > Subject: Re: [R] Mixed Date Formats > > On Thu, Jul 30, 2015 at 9:14 AM, John Kane wrote: >> This

Re: [R] Mixed Date Formats

2015-07-30 Thread Sarah Goslee
c-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:

Re: [R] Mixed Date Formats

2015-07-30 Thread John Kane
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 + (UTC) > To: sarah.gos...@gmail.com > Subject: Re: [R] Mi

Re: [R] Mixed Date Formats

2015-07-29 Thread Duncan Mackay
ds Duncan Duncan Mackay Department of Agronomy and Soil Science University of New England Armidale NSW 2351 Email: home: mac...@northnet.com.au -Original Message- From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of farnoosh sheikhi via R-help Sent: Thursday, 30 July 2015 07:16 To:

Re: [R] Mixed Date Formats

2015-07-29 Thread farnoosh sheikhi via R-help
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,                                            

Re: [R] Mixed Date Formats

2015-07-29 Thread Sarah Goslee
I'm assuming you actually want the date column to be character, not factor: SampleData <- structure(list(id = 1:7, value = c(5813L, 8706L, 4049L, 5877L, 1375L, 2223L, 3423L), date = c("19-Dec-11", "07-Dec-11", "06/05/11", "05/12/11", "31/12/2011", "10/19/2011", "01/22/2011")), .Names = c("id", "val

Re: [R] Mixed Date Formats

2015-07-29 Thread Sarah Goslee
On Wed, Jul 29, 2015 at 2:45 PM, farnoosh sheikhi via R-help 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 re

[R] Mixed Date Formats

2015-07-29 Thread farnoosh sheikhi via R-help
 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. [[alternative HTML version dele