如何计算R中的月差 [英] how to calculate month difference in R

问题描述

我的日期格式为2015-03(即年月).现在，我想计算两个日期之间的月份差.

I have dates of format 2015-03 (i.e year-month). Now I want to calculate the month difference in between 2 dates.

示例:日期2015-03和2014-12之间的差应为3或4，因为从12月到3月为3个月或4个月，具体取决于我们是否考虑12月.

Example: difference between dates 2015-03 and 2014-12 should be 3 or 4 as December to March is 3 months or 4 months depending on whether we consider December or not.

推荐答案

a <- "2015-03"
b <- "2014-12"
a <- unlist(strsplit(a, "-"))
b <- unlist(strsplit(b, "-"))
a <- (as.numeric(a[1])*12) + as.numeric(a[2])
b <- (as.numeric(b[1])*12) + as.numeric(b[2])
difference <- diff(c(b,a))
difference

结果是3

这篇关于如何计算R中的月差的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！