Dear R helpers, I have 2 questions : - 1. My excel sheet has a column with dates like 01/03/1980 which is formatted as 03/80 when I read this into R it reads as Mar-80. How can I read it in the source format ? 2.> v<-c("Mar-80") > as.Date(v,format="%b-%y")[1] NA>Could someone please tell me where I am wrong in this date format conversion ? Thank you all very much. [[alternative HTML version deleted]]
You get the NA since it is indeterminate as to the date; paste on a 1 for the day"> v<-c("Mar-80") > as.Date(paste(v, '1'),format="%b-%y %d")[1] "1980-03-01" On Tue, Jun 28, 2011 at 8:04 AM, Ashim Kapoor <ashimkapoor at gmail.com> wrote:> Dear R helpers, > > I have 2 questions : - > > 1. My excel sheet has a column with dates like 01/03/1980 which is formatted > as 03/80 when I read this into R it reads as Mar-80. How can I read it in > the source format ? > > 2. > >> v<-c("Mar-80") >> as.Date(v,format="%b-%y") > [1] NA >> > > Could someone please tell me where I am wrong in this date format conversion > ? > > Thank you all very much. > > ? ? ? ?[[alternative HTML version deleted]] > > ______________________________________________ > 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. >-- Jim Holtman Data Munger Guru What is the problem that you are trying to solve?
On Jun 28, 2011, at 8:04 AM, Ashim Kapoor wrote:> Dear R helpers, > > I have 2 questions : - > > 1. My excel sheet has a column with dates like 01/03/1980 which is > formatted > as 03/80 when I read this into R it reads as Mar-80.You should be able to change that from the format menu in Excel. If you use a "custom" format of yyyy-mm-dd and then save as csv you get dates in "%Y-%m-%d" acceptable format for importing, namely your date which on the data entry line appears as 3/1/80 appears in the cell as 1980-03-01, and likewise in the text output the same way, and could be input using a colClasses argument of "Date".> How can I read it in > the source format ? > > 2. > >> v<-c("Mar-80") >> as.Date(v,format="%b-%y") > [1] NA >> > > Could someone please tell me where I am wrong in this date format > conversion > ?-- David Winsemius, MD West Hartford, CT