月份减去月份 [英] Month subtract month

问题描述

我试图获取以下date1和date2之间的月份数(以月为单位).结果只是2016-12减去2016-5(即7).我只知道如何将int取整，有人可以教我如何以mths(即7)取结果吗?

I am trying to get number of months between date1 and date2 below in months. The result is just simply 2016-12 minus 2016-5, which is 7. I only know how to get days in int, can someone teach me how to get the result in mths, which is 7?

import pandas as pd
import numpy as np

date1=pd.to_datetime('2016-12-1')
date2=pd.to_datetime('2016-5-27')

print((date1-date2)/np.timedelta64(1,'D'))

推荐答案

您可以将日期转换为月期间，然后进行减法:

You can convert the date to month period and then do the subtraction:

date1.to_period("M") - date2.to_period("M")
# 7

这篇关于月份减去月份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！