且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

月相差YYYYMM pandas

更新时间:2023-02-26 20:34:31

我认为需要减去由

I think need subtract periods created byto_period :

df = pd.DataFrame({'Date_1':[20150810, 20160804],
                   'Date_2':[201505.0, 201602.0]})

print (df)
     Date_1    Date_2
0  20150810  201505.0
1  20160804  201602.0

df['Date_1'] = pd.to_datetime(df['Date_1'], format = '%Y%m%d').dt.to_period('m') 
df['Date_2'] = pd.to_datetime(df['Date_2'], format='%Y%m.0').dt.to_period('m') 
df['diff'] = df['Date_1'] - df['Date_2'] 
print (df)
   Date_1  Date_2 diff
0 2015-08 2015-05    3
1 2016-08 2016-02    6

另一种解决方案是将Date_1转换为每月的第一天:

Another solution is convert Date_1 to first day of month:

df['Date_1'] = pd.to_datetime(df['Date_1'], format = '%Y%m%d') - pd.offsets.MonthBegin()
df['Date_2'] = pd.to_datetime(df['Date_2'], format='%Y%m.0')
df['diff'] = df['Date_1'] - df['Date_2'] 
print (df)
      Date_1     Date_2     diff
0 2015-08-01 2015-05-01  92 days
1 2016-08-01 2016-02-01 182 days