Re: [R] Convert date column with two different structures

HI, You could try: library(lubridate) 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") A.K. On Tuesday, November 5, 2013 12:38 PM, Abraham Mathew wrote: Let's say I have the following data frame and t

Re: [R] Convert date column with two different structures

Hello, Try the following. idx <- grep("[[:alpha:]]", df$Date) Date <- as.Date(df$Date, "%m/%d/%y") Date[idx] <- as.Date(paste("01", df$Date[idx]), "%d %b-%y") Hope this helps, Rui Barradas Em 05-11-2013 16:00, Abraham Mathew escreveu: Let's say I have the following data frame and the date

[R] Convert date column with two different structures

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", "Apr-11","Apr-1