How to separate date in year, month and day in r

Question

I have a date variable in a data frame with date in "YYYY-MM-DD" format.

I used the separate function(below) in tidyr package which worked but it does not add columns to the table.

separate(<table name>, "<date variable>", c("Year", "Month", "Day"), sep = "-")

How can I get "Year", "Month" & "Day" variables added to the end of the table?

You need to assign? ie. `df <- separate(df, ...` – akrun Feb 23 '17 at 05:16 — akrun, Feb 23 '17 at 05:16

score 7 · Accepted Answer · answered Feb 23 '17 at 05:46

You need to define

argument to separate.

See this example:

d <- data.frame(date = c("2017-02-23", "2017-02-22"))
separate(d, "date", c("Year", "Month", "Day"), sep = "-")

Which yields:

  Year Month Day
1 2017    02  23
2 2017    02  22

1 Answers1