[R] Convert date column with two different structures

arun smartpink111 at yahoo.com
Tue Nov 5 20:03:53 CET 2013

You could try:

Date1 <- mdy(as.character(df[,1]))
 Date1[is.na(Date1)] <- parse_date_time(paste(1,as.character(df[,1][is.na(Date1)]),sep="-"),"%d-%b-%y")


On Tuesday, November 5, 2013 12:38 PM, Abraham Mathew <abmathewks at gmail.com> wrote:
Let's say I have the following data frame and the date column has two
different ways in which date is presented. How can I use as.Date or the
lubridate package to have one date structure for the entire colum

df = data.frame(Date=c("5/1/13","8/1/13","9/1/13","Apr-10",

It's "month/date/year" and "month-year".

An alternative approach would be to perform some conditional statements
where if the date is "Apr-11", then populate it with "04/01/2011".

    [[alternative HTML version deleted]]

R-help at r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list