Change Duration from (Years and Month) to (Month) in R

Question

I have some data frame like below. I need to add a "Duration" column beside the "Years and Month" column and convert the "Years and Month" to Month as duration.

For instance, I need to change the 2Y3M to 27M.

I have searched for it and didn't succeed. How do I do that? Thanks in advance.

Years and Month	Percentage Change
2Y3M	13%
3Y4M	23%

question from:https://stackoverflow.com/questions/65877766/change-duration-from-years-and-month-to-month-in-r

Answer 1

Assuming your dataframe is called df and column as ym you can use strcapture to extract year and month value.

result <- transform(strcapture('(\d+)Y(\d+)M', df$ym, 
                    proto = list(year = integer(), month = integer())), 
                    yearmonth = (year * 12) + month)
result

#  year month yearmonth
#1    2     3        27
#2    3     4        40

---

To assign the value to same column.

df$ym <- transform(strcapture('(\d+)Y(\d+)M', df$ym, 
           proto = list(year = integer(), month = integer())), 
          yearmonth = (year * 12) + month)$yearmonth