Separate Data into month,date, and year

[livcalvin]

Hi,
I am new to R, but need to know how to separate one column labeled "dates" into three separate columns of, month, year, and date.

[andresrcs]

There are many ways of doing it, but it's going to depend on the format of your dates, see this example.

# Sample data
df <- data.frame(stringsAsFactors = FALSE,
                 dates = c("2019-06-09", "2019-06-10")
)

library(tidyverse)

df
#>        dates
#> 1 2019-06-09
#> 2 2019-06-10

df %>% 
    separate(dates, c("month", "year", "day"), sep = "-")
#>   month year day
#> 1  2019   06  09
#> 2  2019   06  10

^{Created on 2019-06-10 by the reprex package (v0.3.0)}

[woodward]

I like to use the lubridate package which is also part of tidyverse:

library(tidyverse)
library(lubridate)

df <- tibble(dates=c("2019-06-09", "2019-06-10")) # dates as strings

df %>%
    mutate(
        dates2=ymd(dates), # convert to Date type using lubridate
        year=year(dates2), # extract parts
        month=month(dates2),
        day=day(dates2)
    )
#> # A tibble: 2 x 5
#>   dates      dates2      year month   day
#>   <chr>      <date>     <dbl> <dbl> <int>
#> 1 2019-06-09 2019-06-09  2019     6     9
#> 2 2019-06-10 2019-06-10  2019     6    10

^{Created on 2019-06-11 by the reprex package (v0.3.0)}

[livcalvin]

Instead of specific dates could I do a specific column for example dates=[, 2]?

[andresrcs]

I don`t understand what you mean with specific dates, I'm using some made up sample data you have to replace this with your own data.

[livcalvin]

I figured it out, thanks!

[mara]

If your question's been answered (even if by you), would you mind choosing a solution? (See FAQ below for how).

Having questions checked as resolved makes it a bit easier to navigate the site visually and see which threads still need help.

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

Thanks