Converting string into year-month in R?

Question

I want to convert the following string into year-month?

df <- tribble( ~date, '20201227', )

Here is the desired output.

new_df <- tribble( ~date, '2020-12', )

How can I do this?

akrun · Accepted Answer · 2021-04-07 19:52:00Z

1

Convert to Date class and use format

library(dplyr) df <- df %>% mutate(date = format(as.Date(date, '%Y%m%d'), '%Y-%m'))

answered Apr 7, 2021 at 19:52

891k38 gold badges590 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ThomasIsCoding · Accepted Answer · 2021-04-07 21:08:13Z

Another possible option using gsub (but the as.Date answer by @akrun is more recommended)

transform( df, date = gsub("(\\d{4})(\\d{2}).*", "\\1-\\2", date) )

gives

 date 1 2020-12