How to change multiple Date formats in same column?

by

I like lubridate for its ease of use:

library(lubridate) 

# note added ugly formats below
data <- data.frame(initialDiagnose = c("14.01.2009", "9/22/2005", 
        "4/21/2010", "28.01.2010", "09.01.2009", "3/28/2005", 
        "04.01.2005", "04.01.2005", "Created on 9/17/2010", "03 01 2010"))

mdy <- mdy(data$initialDiagnose) 
dmy <- dmy(data$initialDiagnose) 
mdy[is.na(mdy)] <- dmy[is.na(mdy)] # some dates are ambiguous, here we give 
data$initialDiagnose <- mdy        # mdy precedence over dmy
data
#   initialDiagnose
#       2009-01-14
#       2005-09-22
#       2010-04-21
#       2010-01-28
#       2009-09-01
#       2005-03-28
#       2005-04-01
#       2005-04-01
#       2010-09-17
#       2010-03-01

More Related Contents:

  1. Changing date format in R
  2. Convert decimal day to HH:MM
  3. Transform year/week to date object
  4. Looping over a Date or POSIXct object results in a numeric iterator
  5. Axis labels on two lines with nested x variables (year below months)
  6. Get the difference between dates in terms of weeks, months, quarters, and years
  7. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  8. How to flatten / merge overlapping time periods
  9. How to get week numbers from dates?
  10. Extract month and year from a zoo::yearmon object
  11. How to get a vertical geom_vline to an x-axis of class date?
  12. How to subtract/add days from/to a date?
  13. Formatting dates with scale_x_date in ggplot2
  14. Format number in R with both comma thousands separator and specified decimals
  15. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  16. Convert a numeric month to a month abbreviation
  17. Converting Date formats in R [closed]
  18. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  19. Convert four digit year values to class Date
  20. Convert string to date, format: “dd.mm.yyyy”
  21. Add (subtract) months without exceeding the last day of the new month
  22. Convert yyyymmdd string to Date class in R
  23. Format date as Year/Quarter
  24. How to write to json with children from R
  25. Converting a character string into a date in R
  26. Create end of the month date from a date variable
  27. Convert Factor to Date/Time in R
  28. How to convert a date from a character string?
  29. change a column from birth date to age in r
  30. Convert two-digit years to four-digit years with correct century

Leave a Comment