Convert date-time string to class Date

You may be overcomplicating things, is there any reason you need the stringr package? You can use as.Date and its format argument to specify the input format of your string.

 df <- data.frame(Date = c("10/9/2009 0:00:00", "10/15/2009 0:00:00"))
 as.Date(df$Date, format =  "%m/%d/%Y %H:%M:%S")
 # [1] "2009-10-09" "2009-10-15"

Note the Details section of ?as.Date:

Character strings are processed as far as necessary for the format specified: any trailing characters are ignored

Thus, this also works:

as.Date(df$Date, format =  "%m/%d/%Y)
# [1] "2009-10-09" "2009-10-15"

All the conversion specifications that can be used to specify the input format are found in the Details section in ?strptime. Make sure that the order of the conversion specification as well as any separators correspond exactly with the format of your input string.

More generally and if you need the time component as well, use as.POSIXct or strptime:

as.POSIXct(df$Date, "%m/%d/%Y %H:%M:%S")    
strptime(df$Date, "%m/%d/%Y %H:%M:%S")

I’m guessing at what your actual data might look at from the partial results you give.

Related Posts:

  1. Poker hand range chart visualization in R
  2. ggplot wrong color assignment
  3. How to rename a single column in a data.frame?
  4. Critical t values in R
  5. What does %>% function mean in R?
  6. t-stat for feature selection
  7. Reasons for using the set.seed function
  8. R on MacOS Error: vector memory exhausted (limit reached?)
  9. Remove legend ggplot 2.2
  10. How do I replace NA values with zeros in an R dataframe?
  11. How to change legend title in ggplot
  12. Changing column names of a data frame
  13. R: Using equation with natural logarithm in nls
  14. How to change legend title in ggplot
  15. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  16. R on MacOS Error: vector memory exhausted (limit reached?)
  17. kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
  18. R issue “object not found”
  19. Error in Confusion Matrix : the data and reference factors must have the same number of levels
  20. Why do I get “number of items to replace is not a multiple of replacement length”
  21. Having trouble setting working directory
  22. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  23. R ggplot2 scale_y_continuous : Combining breaks & limits
  24. Add color to boxplot – “Continuous value supplied to discrete scale” error
  25. “Error: Mapping should be created with `aes()` or `aes_()`.”
  26. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  27. Error in plot.window(…) : need finite ‘xlim’ valuescc
  28. Longer object length is not a multiple of shorter object length?
  29. rmarkdown error “attempt to use zero-length variable name”
  30. cannot coerce type ‘closure’ to vector of type ‘character’
  31. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  32. Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
  33. R – longer object length is not a multiple of shorter object length
  34. Opposite of %in%: exclude rows with values specified in a vector
  35. Arcsine transformation of percentage data
  36. R loop that adds following numbers to each element in list
  37. R: Using equation with natural logarithm in nls
  38. remove legend title in ggplot
  39. scale_color_manual() not working
  40. Can I calculate z-score with R?
  41. Clear R environment of all objetcs & packages
  42. Function to clear the console in R and RStudio
  43. “replace” function examples
  44. R: need finite ‘ylim’ values in function
  45. Convert a list to a data frame
  46. Manually colouring plots with `scale_fill_manual` in ggplot2 not working
  47. Why I get this error writing data to a file
  48. Correlation between multiple variables of a data frame
  49. Adding a regression line on a ggplot
  50. Remove grid, background color, and top and right borders from ggplot2
  51. R: “Unary operator error” from multiline ggplot2 command
  52. What does the double percentage sign (%%) mean?
  53. invalid type (list) for variable
  54. not a Stata version 5-12 .dta file
  55. How to subset a Data frame column wise using column names?
  56. Mean of a column in a data frame, given the column’s name
  57. No non-missing arguments warning when using min or max in reshape2
  58. How to convert a factor to integer\numeric without loss of information?
  59. Having trouble setting working directory
  60. Custom legend for multiple layer ggplot
  61. Understanding `scale` in R
  62. file.path function in R
  63. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  64. Convert categorical variables to numeric in R
  65. How to sum data.frame column values?
  66. Error: invalid subscript type ‘list’ in R
  67. “non-numeric argument to binary operator” error in R
  68. How to sum a variable by group
  69. readOGR() cannot open file
  70. What does “The following object is masked from ‘package:xxx'” mean?
  71. grep using a character vector with multiple patterns
  72. How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
  73. R error in unique.default(x) unique() applies only to vectors
  74. Unused arguments in R
  75. Combine two data frames by rows (rbind) when they have different sets of columns
  76. Boxplot dplyr: Error: non-numeric argument to binary operator
  77. How do I install an R package from source?
  78. Getting invalid model formula in ExtractVars when using rpart function in R
  79. Error: ggplot2 doesn’t know how to deal with data of class matrix?
  80. Aggregate multiple columns at once
  81. Error in match.fun(FUN)
  82. Error in file(filename, “r”, encoding = encoding) : cannot open the connection
  83. installing data.table results in “there is no package”
  84. What is integer overflow in R and how can it happen?
  85. R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
  86. Correct syntax for mutate_if
  87. Plotting data in R; error: default method not implemented for type ‘list’
  88. Error:attempt to apply non-function
  89. Error in contrib.url(repos, “source”) in R trying to use CRAN without setting a mirror Calls: install.packages -> contrib.url Execution halted
  90. Changing fonts in ggplot2
  91. Error in : target of assignment expands to non-language object
  92. How do I combine two data-frames based on two columns?
  93. Indicator function in R
  94. Batch convert columns to numeric type
  95. R4DS error comparison (1) is possible only for atomic and list types
  96. How can I make a list of lists in R?
  97. Warning: non-integer #successes in a binomial glm! (survey packages)
  98. Remove columns from dataframe where some of values are NA
  99. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  100. How to deal with “data of class uneval” error from ggplot2?

Leave a Comment