otp.Month#
- Month(n)#
Object representing month’s datetime offset.
Can be added to or subtracted from:
otp.datetime
objectsSource
columns of datetime type
- Parameters
n (int,
Column
,Operation
) – Offset integer value or column ofSource
. The onlyOperation
supported is subtracting one datetime column from another. See example below.
Examples
Add to or subtract from
otp.datetime
object:>>> otp.datetime(2012, 12, 12, 12) + otp.Month(1) 2013-01-12 12:00:00 >>> otp.datetime(2012, 12, 12, 12) - otp.Month(1) 2012-11-12 12:00:00
Use offset in columns:
>>> t = otp.Tick(A=1) >>> t['T'] = otp.datetime(2012, 12, 12, 12) >>> t['T'] += otp.Month(t['A']) >>> otp.run(t) Time T A 0 2003-12-01 2013-01-12 12:00:00 1
Use it to calculate difference between two dates:
>>> t = otp.Tick(A=otp.dt(2022, 1, 1), B=otp.dt(2023, 1, 1)) >>> t['DIFF'] = otp.Month(t['B'] - t['A']) >>> otp.run(t) Time A B DIFF 0 2003-12-01 2022-01-01 2023-01-01 12