How to convert variable with mixed date formats to one format?

by

You may try parse_date_time in package lubridate which “allows the user to specify several format-orders to handle heterogeneous date-time character representations” using the orders argument. Something like…

library(lubridate)
parse_date_time(x = df$date,
                orders = c("d m y", "d B Y", "m/d/y"),
                locale = "eng")

…should be able to handle most of your formats. Please note that b/B formats are locale sensitive.

Other date-time formats which can be used in orders are listed in the Details section in ?strptime.

More Related Contents:

  1. Formatting dates with scale_x_date in ggplot2
  2. How to add leading zeros?
  3. How to prevent ifelse() from turning Date objects into numeric objects
  4. Formatting Decimal places in R
  5. Changing date format in R
  6. Split date-time column into Date and time variables
  7. Generate a sequence of the last day of the month over two years
  8. converting multiple columns from character to numeric format in r
  9. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  10. R: How to handle times without dates?
  11. Extract Month and Year From Date in R
  12. Split date into different columns for year, month and day
  13. Converting Date formats in R [closed]
  14. convert character to date *quickly* in R [duplicate]
  15. Converting date in Year.decimal form in R
  16. Change day of the month in a Date to first day (01)
  17. Sort year-month column by year AND month
  18. R ifelse avoiding change in date format [duplicate]
  19. Creating a unique sequence of dates
  20. Changing date format to “%d/%m/%Y”
  21. How to account for leap years?
  22. Checking if Date is Between two Dates in R
  23. Order x axis day values in ggplot2
  24. R: How to get the Week number of the month
  25. Simplified dput() in R
  26. Subset data.frame by date
  27. change a column from birth date to age in r
  28. Convert two-digit years to four-digit years with correct century
  29. Create a Vector of All Days Between Two Dates
  30. Using geom_rect for time series shading in R

Leave a Comment