Split string into two variables with additional string functions in R

Question

I have a variable called time and it is written in the form of "1 year, 3 months" or "1 year" or "1 months". I want to extract the month and year into two separate variables. I am not sure how to do that.

akrun · Accepted Answer · 2022-08-11 14:51:51Z

3

If it is a column in a dataset, we can use str_extract

library(dplyr)
library(stringr)
df1 %>% 
   mutate(year = str_extract(time, "\\d+\\s+year"),
       month = str_extract(time, "\\d+\\s+months"))

-output

             time   year    month
1 1 year, 3 months 1 year 3 months
2           1 year 1 year     <NA>
3         1 months   <NA> 1 months

data

df1 <- structure(list(time = c("1 year, 3 months", "1 year", "1 months"
)), class = "data.frame", row.names = c(NA, -3L))

answered Aug 11, 2022 at 14:51

akrun

891k38 gold badges590 silver badges700 bronze badges

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

Collectives™ on Stack Overflow

Split string into two variables with additional string functions in R

1 Answer 1

data

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

data

Comments

Your Answer

Sign up or log in

Post as a guest

Related