Converting a year-month column to date type

Question

I have a column in a data.frame in R that looks like the picture and it is stored as a factor: enter image description here

I need to create a new column in the data.frame that has a data type = date, where this date is the first day of the month. Any ideas of how to create this in an easy way?

Are you inputting from a file? IF so you need to add `stringAsFactors = FALSE` in the input file — Nedinator, Jun 01 '15 at 14:47

score 5 · Accepted Answer · answered Jun 01 '15 at 14:58

5

You can use paste to paste the day with the 'Date' column, convert to Date class using as.Date with the appropriate format argument.

  df1$Date <- as.Date(paste(df1$Date, '01'), '%Y %B %d')

For more info, you can check ?as.Date, ?strptime, ?as.POSIXct

answered Jun 01 '15 at 14:58

akrun

874,273
37
540
662

1

Thanks! Just want I was looking for :) – Darius Jun 02 '15 at 08:06

Converting a year-month column to date type

1 Answers1

Linked