r: convert a string to date [duplicate]

by

We can use sub to create a - between the first 4 characters and the next 2. Match the four characters (.{4}), place it in a capture groups ((...)), followed by the next 2 characters in another capture group, replace it with the backreference for those groups (\\1, \\2) and in between we add the -.

df1$Col <- sub('(.{4})(.{2})', "\\1-\\2", df1$month_key)
df1$Col
#[1] "2016-01" "2016-03" "2016-04" "2016-06" "2015-01"

Another option is substr/paste

with(df1, paste(substr(month_key, 1,4), substr(month_key, 5, 6), sep="-"))

However, a Date class have a day as well. So, to convert the original column to ‘Date’, we can append with any day, perhaps with 01 and use the format in as.Date

as.Date(paste0(df1$month_key, "01"), "%Y%m%d")

data

df1 <- structure(list(Col = c(201601L, 201603L, 201604L, 201606L, 201501L
 )), .Names = "month_key", class = "data.frame", row.names = c(NA, -5L))

More Related Contents:

  1. Convert date-time string to class Date
  2. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  3. Convert week number to date
  4. R Convert to date from multiple formats
  5. How to make a great R reproducible example
  6. Combine a list of data frames into one data frame by row
  7. How to read data when some numbers contain commas as thousand separator?
  8. How to split a data frame?
  9. Replace a value in a data frame based on a conditional (`if`) statement
  10. Vectorized IF statement in R?
  11. Convert hour:minute:second (HH:MM:SS) string to proper time class
  12. Put stars on ggplot barplots and boxplots – to indicate the level of significance (p-value)
  13. R shiny: display “loading…” message while function is running
  14. dplyr on data.table, am I really using data.table?
  15. Marker mouse click event in R leaflet for shiny
  16. how to show a legend on dual y-axis ggplot
  17. Different colours of geom_line above and below a specific value
  18. use ggpairs to create this plot
  19. Update handsontable by editing table and/or eventReactive
  20. Why is as.Date slow on a character vector?
  21. Alternative to expand.grid for data.frames
  22. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  23. Apply a function to a subset of data.table columns, by column-indices instead of name
  24. Creating (and Accessing) a Sparse Matrix with NA default entries
  25. Deleting specific rows from a data frame
  26. What does the R function `poly` really do?
  27. Identifying where value changes in R data.frame column
  28. Double clustered standard errors for panel data
  29. Shiny – observe() triggered by dynamicaly generated inputs
  30. Create a Vector of All Days Between Two Dates

Leave a Comment