/pandas/tseries/tests/test_offsets.py
Python | 4923 lines | 3895 code | 871 blank | 157 comment | 231 complexity | 2ab5f86d3cceca3f0ae7857b00894086 MD5 | raw file
Possible License(s): BSD-3-Clause, Apache-2.0
- import os
- from datetime import date, datetime, timedelta
- from dateutil.relativedelta import relativedelta
- from pandas.compat import range, iteritems
- from pandas import compat
- import nose
- from nose.tools import assert_raises
- import numpy as np
- from pandas.compat.numpy import np_datetime64_compat
- from pandas.core.datetools import (bday, BDay, CDay, BQuarterEnd, BMonthEnd,
- BusinessHour, CustomBusinessHour,
- CBMonthEnd, CBMonthBegin, BYearEnd,
- MonthEnd, MonthBegin, SemiMonthBegin,
- SemiMonthEnd, BYearBegin, QuarterBegin,
- BQuarterBegin, BMonthBegin, DateOffset,
- Week, YearBegin, YearEnd, Hour, Minute,
- Second, Day, Micro, Milli, Nano, Easter,
- WeekOfMonth, format, ole2datetime,
- QuarterEnd, to_datetime, normalize_date,
- get_offset, get_standard_freq)
- from pandas.core.series import Series
- from pandas.tseries.frequencies import (_offset_map, get_freq_code,
- _get_freq_str, _INVALID_FREQ_ERROR)
- from pandas.tseries.index import _to_m8, DatetimeIndex, _daterange_cache
- from pandas.tseries.tools import parse_time_string, DateParseError
- import pandas.tseries.offsets as offsets
- from pandas.io.pickle import read_pickle
- from pandas.tslib import NaT, Timestamp, Timedelta
- import pandas.tslib as tslib
- from pandas.util.testing import assertRaisesRegexp
- import pandas.util.testing as tm
- from pandas.tseries.offsets import BusinessMonthEnd, CacheableOffset, \
- LastWeekOfMonth, FY5253, FY5253Quarter, WeekDay
- from pandas.tseries.holiday import USFederalHolidayCalendar
- _multiprocess_can_split_ = True
- def test_monthrange():
- import calendar
- for y in range(2000, 2013):
- for m in range(1, 13):
- assert tslib.monthrange(y, m) == calendar.monthrange(y, m)
- ####
- # Misc function tests
- ####
- def test_format():
- actual = format(datetime(2008, 1, 15))
- assert actual == '20080115'
- def test_ole2datetime():
- actual = ole2datetime(60000)
- assert actual == datetime(2064, 4, 8)
- assert_raises(ValueError, ole2datetime, 60)
- def test_to_datetime1():
- actual = to_datetime(datetime(2008, 1, 15))
- assert actual == datetime(2008, 1, 15)
- actual = to_datetime('20080115')
- assert actual == datetime(2008, 1, 15)
- # unparseable
- s = 'Month 1, 1999'
- assert to_datetime(s, errors='ignore') == s
- def test_normalize_date():
- actual = normalize_date(datetime(2007, 10, 1, 1, 12, 5, 10))
- assert actual == datetime(2007, 10, 1)
- def test_to_m8():
- valb = datetime(2007, 10, 1)
- valu = _to_m8(valb)
- tm.assertIsInstance(valu, np.datetime64)
- # assert valu == np.datetime64(datetime(2007,10,1))
- # def test_datetime64_box():
- # valu = np.datetime64(datetime(2007,10,1))
- # valb = _dt_box(valu)
- # assert type(valb) == datetime
- # assert valb == datetime(2007,10,1)
- #####
- # DateOffset Tests
- #####
- class Base(tm.TestCase):
- _offset = None
- _offset_types = [getattr(offsets, o) for o in offsets.__all__]
- timezones = [None, 'UTC', 'Asia/Tokyo', 'US/Eastern',
- 'dateutil/Asia/Tokyo', 'dateutil/US/Pacific']
- @property
- def offset_types(self):
- return self._offset_types
- def _get_offset(self, klass, value=1, normalize=False):
- # create instance from offset class
- if klass is FY5253 or klass is FY5253Quarter:
- klass = klass(n=value, startingMonth=1, weekday=1,
- qtr_with_extra_week=1, variation='last',
- normalize=normalize)
- elif klass is LastWeekOfMonth:
- klass = klass(n=value, weekday=5, normalize=normalize)
- elif klass is WeekOfMonth:
- klass = klass(n=value, week=1, weekday=5, normalize=normalize)
- elif klass is Week:
- klass = klass(n=value, weekday=5, normalize=normalize)
- elif klass is DateOffset:
- klass = klass(days=value, normalize=normalize)
- else:
- try:
- klass = klass(value, normalize=normalize)
- except:
- klass = klass(normalize=normalize)
- return klass
- def test_apply_out_of_range(self):
- if self._offset is None:
- return
- # try to create an out-of-bounds result timestamp; if we can't create
- # the offset skip
- try:
- if self._offset in (BusinessHour, CustomBusinessHour):
- # Using 10000 in BusinessHour fails in tz check because of DST
- # difference
- offset = self._get_offset(self._offset, value=100000)
- else:
- offset = self._get_offset(self._offset, value=10000)
- result = Timestamp('20080101') + offset
- self.assertIsInstance(result, datetime)
- self.assertIsNone(result.tzinfo)
- tm._skip_if_no_pytz()
- tm._skip_if_no_dateutil()
- # Check tz is preserved
- for tz in self.timezones:
- t = Timestamp('20080101', tz=tz)
- result = t + offset
- self.assertIsInstance(result, datetime)
- self.assertEqual(t.tzinfo, result.tzinfo)
- except (tslib.OutOfBoundsDatetime):
- raise
- except (ValueError, KeyError) as e:
- raise nose.SkipTest(
- "cannot create out_of_range offset: {0} {1}".format(
- str(self).split('.')[-1], e))
- class TestCommon(Base):
- def setUp(self):
- # exected value created by Base._get_offset
- # are applied to 2011/01/01 09:00 (Saturday)
- # used for .apply and .rollforward
- self.expecteds = {'Day': Timestamp('2011-01-02 09:00:00'),
- 'DateOffset': Timestamp('2011-01-02 09:00:00'),
- 'BusinessDay': Timestamp('2011-01-03 09:00:00'),
- 'CustomBusinessDay':
- Timestamp('2011-01-03 09:00:00'),
- 'CustomBusinessMonthEnd':
- Timestamp('2011-01-31 09:00:00'),
- 'CustomBusinessMonthBegin':
- Timestamp('2011-01-03 09:00:00'),
- 'MonthBegin': Timestamp('2011-02-01 09:00:00'),
- 'BusinessMonthBegin':
- Timestamp('2011-01-03 09:00:00'),
- 'MonthEnd': Timestamp('2011-01-31 09:00:00'),
- 'SemiMonthEnd': Timestamp('2011-01-15 09:00:00'),
- 'SemiMonthBegin': Timestamp('2011-01-15 09:00:00'),
- 'BusinessMonthEnd': Timestamp('2011-01-31 09:00:00'),
- 'YearBegin': Timestamp('2012-01-01 09:00:00'),
- 'BYearBegin': Timestamp('2011-01-03 09:00:00'),
- 'YearEnd': Timestamp('2011-12-31 09:00:00'),
- 'BYearEnd': Timestamp('2011-12-30 09:00:00'),
- 'QuarterBegin': Timestamp('2011-03-01 09:00:00'),
- 'BQuarterBegin': Timestamp('2011-03-01 09:00:00'),
- 'QuarterEnd': Timestamp('2011-03-31 09:00:00'),
- 'BQuarterEnd': Timestamp('2011-03-31 09:00:00'),
- 'BusinessHour': Timestamp('2011-01-03 10:00:00'),
- 'CustomBusinessHour':
- Timestamp('2011-01-03 10:00:00'),
- 'WeekOfMonth': Timestamp('2011-01-08 09:00:00'),
- 'LastWeekOfMonth': Timestamp('2011-01-29 09:00:00'),
- 'FY5253Quarter': Timestamp('2011-01-25 09:00:00'),
- 'FY5253': Timestamp('2011-01-25 09:00:00'),
- 'Week': Timestamp('2011-01-08 09:00:00'),
- 'Easter': Timestamp('2011-04-24 09:00:00'),
- 'Hour': Timestamp('2011-01-01 10:00:00'),
- 'Minute': Timestamp('2011-01-01 09:01:00'),
- 'Second': Timestamp('2011-01-01 09:00:01'),
- 'Milli': Timestamp('2011-01-01 09:00:00.001000'),
- 'Micro': Timestamp('2011-01-01 09:00:00.000001'),
- 'Nano': Timestamp(np_datetime64_compat(
- '2011-01-01T09:00:00.000000001Z'))}
- def test_return_type(self):
- for offset in self.offset_types:
- offset = self._get_offset(offset)
- # make sure that we are returning a Timestamp
- result = Timestamp('20080101') + offset
- self.assertIsInstance(result, Timestamp)
- # make sure that we are returning NaT
- self.assertTrue(NaT + offset is NaT)
- self.assertTrue(offset + NaT is NaT)
- self.assertTrue(NaT - offset is NaT)
- self.assertTrue((-offset).apply(NaT) is NaT)
- def test_offset_n(self):
- for offset_klass in self.offset_types:
- offset = self._get_offset(offset_klass)
- self.assertEqual(offset.n, 1)
- neg_offset = offset * -1
- self.assertEqual(neg_offset.n, -1)
- mul_offset = offset * 3
- self.assertEqual(mul_offset.n, 3)
- def test_offset_freqstr(self):
- for offset_klass in self.offset_types:
- offset = self._get_offset(offset_klass)
- freqstr = offset.freqstr
- if freqstr not in ('<Easter>',
- "<DateOffset: kwds={'days': 1}>",
- 'LWOM-SAT', ):
- code = get_offset(freqstr)
- self.assertEqual(offset.rule_code, code)
- def _check_offsetfunc_works(self, offset, funcname, dt, expected,
- normalize=False):
- offset_s = self._get_offset(offset, normalize=normalize)
- func = getattr(offset_s, funcname)
- result = func(dt)
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected)
- result = func(Timestamp(dt))
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected)
- # test nano second is preserved
- result = func(Timestamp(dt) + Nano(5))
- self.assertTrue(isinstance(result, Timestamp))
- if normalize is False:
- self.assertEqual(result, expected + Nano(5))
- else:
- self.assertEqual(result, expected)
- if isinstance(dt, np.datetime64):
- # test tz when input is datetime or Timestamp
- return
- tm._skip_if_no_pytz()
- tm._skip_if_no_dateutil()
- for tz in self.timezones:
- expected_localize = expected.tz_localize(tz)
- tz_obj = tslib.maybe_get_tz(tz)
- dt_tz = tslib._localize_pydatetime(dt, tz_obj)
- result = func(dt_tz)
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected_localize)
- result = func(Timestamp(dt, tz=tz))
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected_localize)
- # test nano second is preserved
- result = func(Timestamp(dt, tz=tz) + Nano(5))
- self.assertTrue(isinstance(result, Timestamp))
- if normalize is False:
- self.assertEqual(result, expected_localize + Nano(5))
- else:
- self.assertEqual(result, expected_localize)
- def test_apply(self):
- sdt = datetime(2011, 1, 1, 9, 0)
- ndt = np_datetime64_compat('2011-01-01 09:00Z')
- for offset in self.offset_types:
- for dt in [sdt, ndt]:
- expected = self.expecteds[offset.__name__]
- self._check_offsetfunc_works(offset, 'apply', dt, expected)
- expected = Timestamp(expected.date())
- self._check_offsetfunc_works(offset, 'apply', dt, expected,
- normalize=True)
- def test_rollforward(self):
- expecteds = self.expecteds.copy()
- # result will not be changed if the target is on the offset
- no_changes = ['Day', 'MonthBegin', 'SemiMonthBegin', 'YearBegin',
- 'Week', 'Hour', 'Minute', 'Second', 'Milli', 'Micro',
- 'Nano', 'DateOffset']
- for n in no_changes:
- expecteds[n] = Timestamp('2011/01/01 09:00')
- expecteds['BusinessHour'] = Timestamp('2011-01-03 09:00:00')
- expecteds['CustomBusinessHour'] = Timestamp('2011-01-03 09:00:00')
- # but be changed when normalize=True
- norm_expected = expecteds.copy()
- for k in norm_expected:
- norm_expected[k] = Timestamp(norm_expected[k].date())
- normalized = {'Day': Timestamp('2011-01-02 00:00:00'),
- 'DateOffset': Timestamp('2011-01-02 00:00:00'),
- 'MonthBegin': Timestamp('2011-02-01 00:00:00'),
- 'SemiMonthBegin': Timestamp('2011-01-15 00:00:00'),
- 'YearBegin': Timestamp('2012-01-01 00:00:00'),
- 'Week': Timestamp('2011-01-08 00:00:00'),
- 'Hour': Timestamp('2011-01-01 00:00:00'),
- 'Minute': Timestamp('2011-01-01 00:00:00'),
- 'Second': Timestamp('2011-01-01 00:00:00'),
- 'Milli': Timestamp('2011-01-01 00:00:00'),
- 'Micro': Timestamp('2011-01-01 00:00:00')}
- norm_expected.update(normalized)
- sdt = datetime(2011, 1, 1, 9, 0)
- ndt = np_datetime64_compat('2011-01-01 09:00Z')
- for offset in self.offset_types:
- for dt in [sdt, ndt]:
- expected = expecteds[offset.__name__]
- self._check_offsetfunc_works(offset, 'rollforward', dt,
- expected)
- expected = norm_expected[offset.__name__]
- self._check_offsetfunc_works(offset, 'rollforward', dt,
- expected, normalize=True)
- def test_rollback(self):
- expecteds = {'BusinessDay': Timestamp('2010-12-31 09:00:00'),
- 'CustomBusinessDay': Timestamp('2010-12-31 09:00:00'),
- 'CustomBusinessMonthEnd':
- Timestamp('2010-12-31 09:00:00'),
- 'CustomBusinessMonthBegin':
- Timestamp('2010-12-01 09:00:00'),
- 'BusinessMonthBegin': Timestamp('2010-12-01 09:00:00'),
- 'MonthEnd': Timestamp('2010-12-31 09:00:00'),
- 'SemiMonthEnd': Timestamp('2010-12-31 09:00:00'),
- 'BusinessMonthEnd': Timestamp('2010-12-31 09:00:00'),
- 'BYearBegin': Timestamp('2010-01-01 09:00:00'),
- 'YearEnd': Timestamp('2010-12-31 09:00:00'),
- 'BYearEnd': Timestamp('2010-12-31 09:00:00'),
- 'QuarterBegin': Timestamp('2010-12-01 09:00:00'),
- 'BQuarterBegin': Timestamp('2010-12-01 09:00:00'),
- 'QuarterEnd': Timestamp('2010-12-31 09:00:00'),
- 'BQuarterEnd': Timestamp('2010-12-31 09:00:00'),
- 'BusinessHour': Timestamp('2010-12-31 17:00:00'),
- 'CustomBusinessHour': Timestamp('2010-12-31 17:00:00'),
- 'WeekOfMonth': Timestamp('2010-12-11 09:00:00'),
- 'LastWeekOfMonth': Timestamp('2010-12-25 09:00:00'),
- 'FY5253Quarter': Timestamp('2010-10-26 09:00:00'),
- 'FY5253': Timestamp('2010-01-26 09:00:00'),
- 'Easter': Timestamp('2010-04-04 09:00:00')}
- # result will not be changed if the target is on the offset
- for n in ['Day', 'MonthBegin', 'SemiMonthBegin', 'YearBegin', 'Week',
- 'Hour', 'Minute', 'Second', 'Milli', 'Micro', 'Nano',
- 'DateOffset']:
- expecteds[n] = Timestamp('2011/01/01 09:00')
- # but be changed when normalize=True
- norm_expected = expecteds.copy()
- for k in norm_expected:
- norm_expected[k] = Timestamp(norm_expected[k].date())
- normalized = {'Day': Timestamp('2010-12-31 00:00:00'),
- 'DateOffset': Timestamp('2010-12-31 00:00:00'),
- 'MonthBegin': Timestamp('2010-12-01 00:00:00'),
- 'SemiMonthBegin': Timestamp('2010-12-15 00:00:00'),
- 'YearBegin': Timestamp('2010-01-01 00:00:00'),
- 'Week': Timestamp('2010-12-25 00:00:00'),
- 'Hour': Timestamp('2011-01-01 00:00:00'),
- 'Minute': Timestamp('2011-01-01 00:00:00'),
- 'Second': Timestamp('2011-01-01 00:00:00'),
- 'Milli': Timestamp('2011-01-01 00:00:00'),
- 'Micro': Timestamp('2011-01-01 00:00:00')}
- norm_expected.update(normalized)
- sdt = datetime(2011, 1, 1, 9, 0)
- ndt = np_datetime64_compat('2011-01-01 09:00Z')
- for offset in self.offset_types:
- for dt in [sdt, ndt]:
- expected = expecteds[offset.__name__]
- self._check_offsetfunc_works(offset, 'rollback', dt, expected)
- expected = norm_expected[offset.__name__]
- self._check_offsetfunc_works(offset, 'rollback', dt, expected,
- normalize=True)
- def test_onOffset(self):
- for offset in self.offset_types:
- dt = self.expecteds[offset.__name__]
- offset_s = self._get_offset(offset)
- self.assertTrue(offset_s.onOffset(dt))
- # when normalize=True, onOffset checks time is 00:00:00
- offset_n = self._get_offset(offset, normalize=True)
- self.assertFalse(offset_n.onOffset(dt))
- if offset in (BusinessHour, CustomBusinessHour):
- # In default BusinessHour (9:00-17:00), normalized time
- # cannot be in business hour range
- continue
- date = datetime(dt.year, dt.month, dt.day)
- self.assertTrue(offset_n.onOffset(date))
- def test_add(self):
- dt = datetime(2011, 1, 1, 9, 0)
- for offset in self.offset_types:
- offset_s = self._get_offset(offset)
- expected = self.expecteds[offset.__name__]
- result_dt = dt + offset_s
- result_ts = Timestamp(dt) + offset_s
- for result in [result_dt, result_ts]:
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected)
- tm._skip_if_no_pytz()
- for tz in self.timezones:
- expected_localize = expected.tz_localize(tz)
- result = Timestamp(dt, tz=tz) + offset_s
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected_localize)
- # normalize=True
- offset_s = self._get_offset(offset, normalize=True)
- expected = Timestamp(expected.date())
- result_dt = dt + offset_s
- result_ts = Timestamp(dt) + offset_s
- for result in [result_dt, result_ts]:
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected)
- for tz in self.timezones:
- expected_localize = expected.tz_localize(tz)
- result = Timestamp(dt, tz=tz) + offset_s
- self.assertTrue(isinstance(result, Timestamp))
- self.assertEqual(result, expected_localize)
- def test_pickle_v0_15_2(self):
- offsets = {'DateOffset': DateOffset(years=1),
- 'MonthBegin': MonthBegin(1),
- 'Day': Day(1),
- 'YearBegin': YearBegin(1),
- 'Week': Week(1)}
- pickle_path = os.path.join(tm.get_data_path(),
- 'dateoffset_0_15_2.pickle')
- # This code was executed once on v0.15.2 to generate the pickle:
- # with open(pickle_path, 'wb') as f: pickle.dump(offsets, f)
- #
- tm.assert_dict_equal(offsets, read_pickle(pickle_path))
- class TestDateOffset(Base):
- _multiprocess_can_split_ = True
- def setUp(self):
- self.d = Timestamp(datetime(2008, 1, 2))
- _offset_map.clear()
- def test_repr(self):
- repr(DateOffset())
- repr(DateOffset(2))
- repr(2 * DateOffset())
- repr(2 * DateOffset(months=2))
- def test_mul(self):
- assert DateOffset(2) == 2 * DateOffset(1)
- assert DateOffset(2) == DateOffset(1) * 2
- def test_constructor(self):
- assert ((self.d + DateOffset(months=2)) == datetime(2008, 3, 2))
- assert ((self.d - DateOffset(months=2)) == datetime(2007, 11, 2))
- assert ((self.d + DateOffset(2)) == datetime(2008, 1, 4))
- assert not DateOffset(2).isAnchored()
- assert DateOffset(1).isAnchored()
- d = datetime(2008, 1, 31)
- assert ((d + DateOffset(months=1)) == datetime(2008, 2, 29))
- def test_copy(self):
- assert (DateOffset(months=2).copy() == DateOffset(months=2))
- def test_eq(self):
- offset1 = DateOffset(days=1)
- offset2 = DateOffset(days=365)
- self.assertNotEqual(offset1, offset2)
- class TestBusinessDay(Base):
- _multiprocess_can_split_ = True
- _offset = BDay
- def setUp(self):
- self.d = datetime(2008, 1, 1)
- self.offset = BDay()
- self.offset2 = BDay(2)
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = BDay()
- offset2 = BDay()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- self.assertEqual(repr(self.offset), '<BusinessDay>')
- assert repr(self.offset2) == '<2 * BusinessDays>'
- expected = '<BusinessDay: offset=datetime.timedelta(1)>'
- assert repr(self.offset + timedelta(1)) == expected
- def test_with_offset(self):
- offset = self.offset + timedelta(hours=2)
- assert (self.d + offset) == datetime(2008, 1, 2, 2)
- def testEQ(self):
- self.assertEqual(self.offset2, self.offset2)
- def test_mul(self):
- pass
- def test_hash(self):
- self.assertEqual(hash(self.offset2), hash(self.offset2))
- def testCall(self):
- self.assertEqual(self.offset2(self.d), datetime(2008, 1, 3))
- def testRAdd(self):
- self.assertEqual(self.d + self.offset2, self.offset2 + self.d)
- def testSub(self):
- off = self.offset2
- self.assertRaises(Exception, off.__sub__, self.d)
- self.assertEqual(2 * off - off, off)
- self.assertEqual(self.d - self.offset2, self.d + BDay(-2))
- def testRSub(self):
- self.assertEqual(self.d - self.offset2, (-self.offset2).apply(self.d))
- def testMult1(self):
- self.assertEqual(self.d + 10 * self.offset, self.d + BDay(10))
- def testMult2(self):
- self.assertEqual(self.d + (-5 * BDay(-10)), self.d + BDay(50))
- def testRollback1(self):
- self.assertEqual(BDay(10).rollback(self.d), self.d)
- def testRollback2(self):
- self.assertEqual(
- BDay(10).rollback(datetime(2008, 1, 5)), datetime(2008, 1, 4))
- def testRollforward1(self):
- self.assertEqual(BDay(10).rollforward(self.d), self.d)
- def testRollforward2(self):
- self.assertEqual(
- BDay(10).rollforward(datetime(2008, 1, 5)), datetime(2008, 1, 7))
- def test_roll_date_object(self):
- offset = BDay()
- dt = date(2012, 9, 15)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 14))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 17))
- offset = offsets.Day()
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- def test_onOffset(self):
- tests = [(BDay(), datetime(2008, 1, 1), True),
- (BDay(), datetime(2008, 1, 5), False)]
- for offset, d, expected in tests:
- assertOnOffset(offset, d, expected)
- def test_apply(self):
- tests = []
- tests.append((bday, {datetime(2008, 1, 1): datetime(2008, 1, 2),
- datetime(2008, 1, 4): datetime(2008, 1, 7),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 8)}))
- tests.append((2 * bday, {datetime(2008, 1, 1): datetime(2008, 1, 3),
- datetime(2008, 1, 4): datetime(2008, 1, 8),
- datetime(2008, 1, 5): datetime(2008, 1, 8),
- datetime(2008, 1, 6): datetime(2008, 1, 8),
- datetime(2008, 1, 7): datetime(2008, 1, 9)}))
- tests.append((-bday, {datetime(2008, 1, 1): datetime(2007, 12, 31),
- datetime(2008, 1, 4): datetime(2008, 1, 3),
- datetime(2008, 1, 5): datetime(2008, 1, 4),
- datetime(2008, 1, 6): datetime(2008, 1, 4),
- datetime(2008, 1, 7): datetime(2008, 1, 4),
- datetime(2008, 1, 8): datetime(2008, 1, 7)}))
- tests.append((-2 * bday, {datetime(2008, 1, 1): datetime(2007, 12, 28),
- datetime(2008, 1, 4): datetime(2008, 1, 2),
- datetime(2008, 1, 5): datetime(2008, 1, 3),
- datetime(2008, 1, 6): datetime(2008, 1, 3),
- datetime(2008, 1, 7): datetime(2008, 1, 3),
- datetime(2008, 1, 8): datetime(2008, 1, 4),
- datetime(2008, 1, 9): datetime(2008, 1, 7)}))
- tests.append((BDay(0), {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 4): datetime(2008, 1, 4),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 7)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_large_n(self):
- dt = datetime(2012, 10, 23)
- result = dt + BDay(10)
- self.assertEqual(result, datetime(2012, 11, 6))
- result = dt + BDay(100) - BDay(100)
- self.assertEqual(result, dt)
- off = BDay() * 6
- rs = datetime(2012, 1, 1) - off
- xp = datetime(2011, 12, 23)
- self.assertEqual(rs, xp)
- st = datetime(2011, 12, 18)
- rs = st + off
- xp = datetime(2011, 12, 26)
- self.assertEqual(rs, xp)
- off = BDay() * 10
- rs = datetime(2014, 1, 5) + off # see #5890
- xp = datetime(2014, 1, 17)
- self.assertEqual(rs, xp)
- def test_apply_corner(self):
- self.assertRaises(TypeError, BDay().apply, BMonthEnd())
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = BDay()
- offset2 = BDay()
- self.assertFalse(offset1 != offset2)
- class TestBusinessHour(Base):
- _multiprocess_can_split_ = True
- _offset = BusinessHour
- def setUp(self):
- self.d = datetime(2014, 7, 1, 10, 00)
- self.offset1 = BusinessHour()
- self.offset2 = BusinessHour(n=3)
- self.offset3 = BusinessHour(n=-1)
- self.offset4 = BusinessHour(n=-4)
- from datetime import time as dt_time
- self.offset5 = BusinessHour(start=dt_time(11, 0), end=dt_time(14, 30))
- self.offset6 = BusinessHour(start='20:00', end='05:00')
- self.offset7 = BusinessHour(n=-2, start=dt_time(21, 30),
- end=dt_time(6, 30))
- def test_constructor_errors(self):
- from datetime import time as dt_time
- with tm.assertRaises(ValueError):
- BusinessHour(start=dt_time(11, 0, 5))
- with tm.assertRaises(ValueError):
- BusinessHour(start='AAA')
- with tm.assertRaises(ValueError):
- BusinessHour(start='14:00:05')
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = self._offset()
- offset2 = self._offset()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- self.assertEqual(repr(self.offset1), '<BusinessHour: BH=09:00-17:00>')
- self.assertEqual(repr(self.offset2),
- '<3 * BusinessHours: BH=09:00-17:00>')
- self.assertEqual(repr(self.offset3),
- '<-1 * BusinessHour: BH=09:00-17:00>')
- self.assertEqual(repr(self.offset4),
- '<-4 * BusinessHours: BH=09:00-17:00>')
- self.assertEqual(repr(self.offset5), '<BusinessHour: BH=11:00-14:30>')
- self.assertEqual(repr(self.offset6), '<BusinessHour: BH=20:00-05:00>')
- self.assertEqual(repr(self.offset7),
- '<-2 * BusinessHours: BH=21:30-06:30>')
- def test_with_offset(self):
- expected = Timestamp('2014-07-01 13:00')
- self.assertEqual(self.d + BusinessHour() * 3, expected)
- self.assertEqual(self.d + BusinessHour(n=3), expected)
- def testEQ(self):
- for offset in [self.offset1, self.offset2, self.offset3, self.offset4]:
- self.assertEqual(offset, offset)
- self.assertNotEqual(BusinessHour(), BusinessHour(-1))
- self.assertEqual(BusinessHour(start='09:00'), BusinessHour())
- self.assertNotEqual(BusinessHour(start='09:00'),
- BusinessHour(start='09:01'))
- self.assertNotEqual(BusinessHour(start='09:00', end='17:00'),
- BusinessHour(start='17:00', end='09:01'))
- def test_hash(self):
- for offset in [self.offset1, self.offset2, self.offset3, self.offset4]:
- self.assertEqual(hash(offset), hash(offset))
- def testCall(self):
- self.assertEqual(self.offset1(self.d), datetime(2014, 7, 1, 11))
- self.assertEqual(self.offset2(self.d), datetime(2014, 7, 1, 13))
- self.assertEqual(self.offset3(self.d), datetime(2014, 6, 30, 17))
- self.assertEqual(self.offset4(self.d), datetime(2014, 6, 30, 14))
- def testRAdd(self):
- self.assertEqual(self.d + self.offset2, self.offset2 + self.d)
- def testSub(self):
- off = self.offset2
- self.assertRaises(Exception, off.__sub__, self.d)
- self.assertEqual(2 * off - off, off)
- self.assertEqual(self.d - self.offset2, self.d + self._offset(-3))
- def testRSub(self):
- self.assertEqual(self.d - self.offset2, (-self.offset2).apply(self.d))
- def testMult1(self):
- self.assertEqual(self.d + 5 * self.offset1, self.d + self._offset(5))
- def testMult2(self):
- self.assertEqual(self.d + (-3 * self._offset(-2)),
- self.d + self._offset(6))
- def testRollback1(self):
- self.assertEqual(self.offset1.rollback(self.d), self.d)
- self.assertEqual(self.offset2.rollback(self.d), self.d)
- self.assertEqual(self.offset3.rollback(self.d), self.d)
- self.assertEqual(self.offset4.rollback(self.d), self.d)
- self.assertEqual(self.offset5.rollback(self.d),
- datetime(2014, 6, 30, 14, 30))
- self.assertEqual(self.offset6.rollback(
- self.d), datetime(2014, 7, 1, 5, 0))
- self.assertEqual(self.offset7.rollback(
- self.d), datetime(2014, 7, 1, 6, 30))
- d = datetime(2014, 7, 1, 0)
- self.assertEqual(self.offset1.rollback(d), datetime(2014, 6, 30, 17))
- self.assertEqual(self.offset2.rollback(d), datetime(2014, 6, 30, 17))
- self.assertEqual(self.offset3.rollback(d), datetime(2014, 6, 30, 17))
- self.assertEqual(self.offset4.rollback(d), datetime(2014, 6, 30, 17))
- self.assertEqual(self.offset5.rollback(
- d), datetime(2014, 6, 30, 14, 30))
- self.assertEqual(self.offset6.rollback(d), d)
- self.assertEqual(self.offset7.rollback(d), d)
- self.assertEqual(self._offset(5).rollback(self.d), self.d)
- def testRollback2(self):
- self.assertEqual(self._offset(-3)
- .rollback(datetime(2014, 7, 5, 15, 0)),
- datetime(2014, 7, 4, 17, 0))
- def testRollforward1(self):
- self.assertEqual(self.offset1.rollforward(self.d), self.d)
- self.assertEqual(self.offset2.rollforward(self.d), self.d)
- self.assertEqual(self.offset3.rollforward(self.d), self.d)
- self.assertEqual(self.offset4.rollforward(self.d), self.d)
- self.assertEqual(self.offset5.rollforward(
- self.d), datetime(2014, 7, 1, 11, 0))
- self.assertEqual(self.offset6.rollforward(
- self.d), datetime(2014, 7, 1, 20, 0))
- self.assertEqual(self.offset7.rollforward(
- self.d), datetime(2014, 7, 1, 21, 30))
- d = datetime(2014, 7, 1, 0)
- self.assertEqual(self.offset1.rollforward(d), datetime(2014, 7, 1, 9))
- self.assertEqual(self.offset2.rollforward(d), datetime(2014, 7, 1, 9))
- self.assertEqual(self.offset3.rollforward(d), datetime(2014, 7, 1, 9))
- self.assertEqual(self.offset4.rollforward(d), datetime(2014, 7, 1, 9))
- self.assertEqual(self.offset5.rollforward(d), datetime(2014, 7, 1, 11))
- self.assertEqual(self.offset6.rollforward(d), d)
- self.assertEqual(self.offset7.rollforward(d), d)
- self.assertEqual(self._offset(5).rollforward(self.d), self.d)
- def testRollforward2(self):
- self.assertEqual(self._offset(-3)
- .rollforward(datetime(2014, 7, 5, 16, 0)),
- datetime(2014, 7, 7, 9))
- def test_roll_date_object(self):
- offset = BusinessHour()
- dt = datetime(2014, 7, 6, 15, 0)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2014, 7, 4, 17))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2014, 7, 7, 9))
- def test_normalize(self):
- tests = []
- tests.append((BusinessHour(normalize=True),
- {datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 2),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 2),
- datetime(2014, 7, 1, 23): datetime(2014, 7, 2),
- datetime(2014, 7, 1, 0): datetime(2014, 7, 1),
- datetime(2014, 7, 4, 15): datetime(2014, 7, 4),
- datetime(2014, 7, 4, 15, 59): datetime(2014, 7, 4),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7),
- datetime(2014, 7, 5, 23): datetime(2014, 7, 7),
- datetime(2014, 7, 6, 10): datetime(2014, 7, 7)}))
- tests.append((BusinessHour(-1, normalize=True),
- {datetime(2014, 7, 1, 8): datetime(2014, 6, 30),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 10): datetime(2014, 6, 30),
- datetime(2014, 7, 1, 0): datetime(2014, 6, 30),
- datetime(2014, 7, 7, 10): datetime(2014, 7, 4),
- datetime(2014, 7, 7, 10, 1): datetime(2014, 7, 7),
- datetime(2014, 7, 5, 23): datetime(2014, 7, 4),
- datetime(2014, 7, 6, 10): datetime(2014, 7, 4)}))
- tests.append((BusinessHour(1, normalize=True, start='17:00',
- end='04:00'),
- {datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 23): datetime(2014, 7, 2),
- datetime(2014, 7, 2, 2): datetime(2014, 7, 2),
- datetime(2014, 7, 2, 3): datetime(2014, 7, 2),
- datetime(2014, 7, 4, 23): datetime(2014, 7, 5),
- datetime(2014, 7, 5, 2): datetime(2014, 7, 5),
- datetime(2014, 7, 7, 2): datetime(2014, 7, 7),
- datetime(2014, 7, 7, 17): datetime(2014, 7, 7)}))
- for offset, cases in tests:
- for dt, expected in compat.iteritems(cases):
- self.assertEqual(offset.apply(dt), expected)
- def test_onOffset(self):
- tests = []
- tests.append((BusinessHour(), {datetime(2014, 7, 1, 9): True,
- datetime(2014, 7, 1, 8, 59): False,
- datetime(2014, 7, 1, 8): False,
- datetime(2014, 7, 1, 17): True,
- datetime(2014, 7, 1, 17, 1): False,
- datetime(2014, 7, 1, 18): False,
- datetime(2014, 7, 5, 9): False,
- datetime(2014, 7, 6, 12): False}))
- tests.append((BusinessHour(start='10:00', end='15:00'),
- {datetime(2014, 7, 1, 9): False,
- datetime(2014, 7, 1, 10): True,
- datetime(2014, 7, 1, 15): True,
- datetime(2014, 7, 1, 15, 1): False,
- datetime(2014, 7, 5, 12): False,
- datetime(2014, 7, 6, 12): False}))
- tests.append((BusinessHour(start='19:00', end='05:00'),
- {datetime(2014, 7, 1, 9, 0): False,
- datetime(2014, 7, 1, 10, 0): False,
- datetime(2014, 7, 1, 15): False,
- datetime(2014, 7, 1, 15, 1): False,
- datetime(2014, 7, 5, 12, 0): False,
- datetime(2014, 7, 6, 12, 0): False,
- datetime(2014, 7, 1, 19, 0): True,
- datetime(2014, 7, 2, 0, 0): True,
- datetime(2014, 7, 4, 23): True,
- datetime(2014, 7, 5, 1): True,
- datetime(2014, 7, 5, 5, 0): True,
- datetime(2014, 7, 6, 23, 0): False,
- datetime(2014, 7, 7, 3, 0): False}))
- for offset, cases in tests:
- for dt, expected in compat.iteritems(cases):
- self.assertEqual(offset.onOffset(dt), expected)
- def test_opening_time(self):
- tests = []
- # opening time should be affected by sign of n, not by n's value and
- # end
- tests.append((
- [BusinessHour(), BusinessHour(n=2), BusinessHour(
- n=4), BusinessHour(end='10:00'), BusinessHour(n=2, end='4:00'),
- BusinessHour(n=4, end='15:00')],
- {datetime(2014, 7, 1, 11): (datetime(2014, 7, 2, 9), datetime(
- 2014, 7, 1, 9)),
- datetime(2014, 7, 1, 18): (datetime(2014, 7, 2, 9), datetime(
- 2014, 7, 1, 9)),
- datetime(2014, 7, 1, 23): (datetime(2014, 7, 2, 9), datetime(
- 2014, 7, 1, 9)),
- datetime(2014, 7, 2, 8): (datetime(2014, 7, 2, 9), datetime(
- 2014, 7, 1, 9)),
- # if timestamp is on opening time, next opening time is
- # as it is
- datetime(2014, 7, 2, 9): (datetime(2014, 7, 2, 9), datetime(
- 2014, 7, 2, 9)),
- datetime(2014, 7, 2, 10): (datetime(2014, 7, 3, 9), datetime(
- 2014, 7, 2, 9)),
- # 2014-07-05 is saturday
- datetime(2014, 7, 5, 10): (datetime(2014, 7, 7, 9), datetime(
- 2014, 7, 4, 9)),
- datetime(2014, 7, 4, 10): (datetime(2014, 7, 7, 9), datetime(
- 2014, 7, 4, 9)),
- datetime(2014, 7, 4, 23): (datetime(2014, 7, 7, 9), datetime(
- 2014, 7, 4, 9)),
- datetime(2014, 7, 6, 10): (datetime(2014, 7, 7, 9), datetime(
- 2014, 7, 4, 9)),
- datetime(2014, 7, 7, 5): (datetime(2014, 7, 7, 9), datetime(
- 2014, 7, 4, 9)),
- datetime(2014, 7, 7, 9, 1): (datetime(2014, 7, 8, 9), datetime(
- 2014, 7, 7, 9))}))
- tests.append(([BusinessHour(start='11:15'),
- BusinessHour(n=2, start='11:15'),
- BusinessHour(n=3, start='11:15'),
- BusinessHour(start='11:15', end='10:00'),
- BusinessHour(n=2, start='11:15', end='4:00'),
- BusinessHour(n=3, start='11:15', end='15:00')],
- {datetime(2014, 7, 1, 11): (datetime(
- 2014, 7, 1, 11, 15), datetime(2014, 6, 30, 11, 15)),
- datetime(2014, 7, 1, 18): (datetime(
- 2014, 7, 2, 11, 15), datetime(2014, 7, 1, 11, 15)),
- datetime(2014, 7, 1, 23): (datetime(
- 2014, 7, 2, 11, 15), datetime(2014, 7, 1, 11, 15)),
- datetime(2014, 7, 2, 8): (datetime(2014, 7, 2, 11, 15),
- datetime(2014, 7, 1, 11, 15)),
- datetime(2014, 7, 2, 9): (datetime(2014, 7, 2, 11, 15),
- datetime(2014, 7, 1, 11, 15)),
- datetime(2014, 7, 2, 10): (datetime(
- 2014, 7, 2, 11, 15), datetime(2014, 7, 1, 11, 15)),
- datetime(2014, 7, 2, 11, 15): (datetime(
- 2014, 7, 2, 11, 15), datetime(2014, 7, 2, 11, 15)),
- datetime(2014, 7, 2, 11, 15, 1): (datetime(
- 2014, 7, 3, 11, 15), datetime(2014, 7, 2, 11, 15)),
- datetime(2014, 7, 5, 10): (datetime(
- 2014, 7, 7, 11, 15), datetime(2014, 7, 4, 11, 15)),
- datetime(2014, 7, 4, 10): (datetime(
- 2014, 7, 4, 11, 15), datetime(2014, 7, 3, 11, 15)),
- datetime(2014, 7, 4, 23): (datetime(
- 2014, 7, 7, 11, 15), datetime(2014, 7, 4, 11, 15)),
- datetime(2014, 7, 6, 10): (datetime(
- 2014, 7, 7, 11, 15), datetime(2014, 7, 4, 11, 15)),
- datetime(2014, 7, 7, 5): (datetime(2014, 7, 7, 11, 15),
- datetime(2014, 7, 4, 11, 15)),
- datetime(2014, 7, 7, 9, 1): (
- datetime(2014, 7, 7, 11, 15),
- datetime(2014, 7, 4, 11, 15))}))
- tests.append(([BusinessHour(-1), BusinessHour(n=-2),
- BusinessHour(n=-4),
- BusinessHour(n=-1, end='10:00'),
- BusinessHour(n=-2, end='4:00'),
- BusinessHour(n=-4, end='15:00')],
- {datetime(2014, 7, 1, 11): (datetime(2014, 7, 1, 9),
- datetime(2014, 7, 2, 9)),
- datetime(2014, 7, 1, 18): (datetime(2014, 7, 1, 9),
- datetime(2014, 7, 2, 9)),
- datetime(2014, 7, 1, 23): (datetime(2014, 7, 1, 9),
- datetime(2014, 7, 2, 9)),
- datetime(2014, 7, 2, 8): (datetime(2014, 7, 1, 9),
- datetime(2014, 7, 2, 9)),
- datetime(2014, 7, 2, 9): (datetime(2014, 7, 2, 9),
- datetime(2014, 7, 2, 9)),
- datetime(2014, 7, 2, 10): (datetime(2014, 7, 2, 9),
- datetime(2014, 7, 3, 9)),
- datetime(2014, 7, 5, 10): (datetime(2014, 7, 4, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 4, 10): (datetime(2014, 7, 4, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 4, 23): (datetime(2014, 7, 4, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 6, 10): (datetime(2014, 7, 4, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 7, 5): (datetime(2014, 7, 4, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 7, 9): (datetime(2014, 7, 7, 9),
- datetime(2014, 7, 7, 9)),
- datetime(2014, 7, 7, 9, 1): (datetime(2014, 7, 7, 9),
- datetime(2014, 7, 8, 9))}))
- tests.append(([BusinessHour(start='17:00', end='05:00'),
- BusinessHour(n=3, start='17:00', end='03:00')],
- {datetime(2014, 7, 1, 11): (datetime(2014, 7, 1, 17),
- datetime(2014, 6, 30, 17)),
- datetime(2014, 7, 1, 18): (datetime(2014, 7, 2, 17),
- datetime(2014, 7, 1, 17)),
- datetime(2014, 7, 1, 23): (datetime(2014, 7, 2, 17),
- datetime(2014, 7, 1, 17)),
- datetime(2014, 7, 2, 8): (datetime(2014, 7, 2, 17),
- datetime(2014, 7, 1, 17)),
- datetime(2014, 7, 2, 9): (datetime(2014, 7, 2, 17),
- datetime(2014, 7, 1, 17)),
- datetime(2014, 7, 4, 17): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 5, 10): (datetime(2014, 7, 7, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 4, 10): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 3, 17)),
- datetime(2014, 7, 4, 23): (datetime(2014, 7, 7, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 6, 10): (datetime(2014, 7, 7, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 7, 5): (datetime(2014, 7, 7, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 7, 17, 1): (datetime(
- 2014, 7, 8, 17), datetime(2014, 7, 7, 17)), }))
- tests.append(([BusinessHour(-1, start='17:00', end='05:00'),
- BusinessHour(n=-2, start='17:00', end='03:00')],
- {datetime(2014, 7, 1, 11): (datetime(2014, 6, 30, 17),
- datetime(2014, 7, 1, 17)),
- datetime(2014, 7, 1, 18): (datetime(2014, 7, 1, 17),
- datetime(2014, 7, 2, 17)),
- datetime(2014, 7, 1, 23): (datetime(2014, 7, 1, 17),
- datetime(2014, 7, 2, 17)),
- datetime(2014, 7, 2, 8): (datetime(2014, 7, 1, 17),
- datetime(2014, 7, 2, 17)),
- datetime(2014, 7, 2, 9): (datetime(2014, 7, 1, 17),
- datetime(2014, 7, 2, 17)),
- datetime(2014, 7, 2, 16, 59): (datetime(
- 2014, 7, 1, 17), datetime(2014, 7, 2, 17)),
- datetime(2014, 7, 5, 10): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 7, 17)),
- datetime(2014, 7, 4, 10): (datetime(2014, 7, 3, 17),
- datetime(2014, 7, 4, 17)),
- datetime(2014, 7, 4, 23): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 7, 17)),
- datetime(2014, 7, 6, 10): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 7, 17)),
- datetime(2014, 7, 7, 5): (datetime(2014, 7, 4, 17),
- datetime(2014, 7, 7, 17)),
- datetime(2014, 7, 7, 18): (datetime(2014, 7, 7, 17),
- datetime(2014, 7, 8, 17))}))
- for _offsets, cases in tests:
- for offset in _offsets:
- for dt, (exp_next, exp_prev) in compat.iteritems(cases):
- self.assertEqual(offset._next_opening_time(dt), exp_next)
- self.assertEqual(offset._prev_opening_time(dt), exp_prev)
- def test_apply(self):
- tests = []
- tests.append((
- BusinessHour(),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 12),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 1, 14),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 1, 19): datetime(2014, 7, 2, 10),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 2, 9),
- datetime(2014, 7, 1, 16, 30, 15): datetime(2014, 7, 2, 9, 30, 15),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 2, 10),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 2, 12),
- # out of business hours
- datetime(2014, 7, 2, 8): datetime(2014, 7, 2, 10),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 10),
- # saturday
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 10),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 10),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 9, 30),
- datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 9, 30,
- 30)}))
- tests.append((BusinessHour(
- 4), {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 2, 9),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 2, 11),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 2, 12),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 2, 15),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 13),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 13),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 12, 30),
- datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 12, 30,
- 30)}))
- tests.append(
- (BusinessHour(-1),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 10),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 1, 12),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 1, 14),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 1, 10): datetime(2014, 6, 30, 17),
- datetime(2014, 7, 1, 16, 30, 15): datetime(
- 2014, 7, 1, 15, 30, 15),
- datetime(2014, 7, 1, 9, 30, 15): datetime(
- 2014, 6, 30, 16, 30, 15),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 1, 5): datetime(2014, 6, 30, 16),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 2, 10),
- # out of business hours
- datetime(2014, 7, 2, 8): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 16),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 2, 16),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 2, 16),
- # saturday
- datetime(2014, 7, 5, 15): datetime(2014, 7, 4, 16),
- datetime(2014, 7, 7, 9): datetime(2014, 7, 4, 16),
- datetime(2014, 7, 7, 9, 30): datetime(2014, 7, 4, 16, 30),
- datetime(2014, 7, 7, 9, 30, 30): datetime(2014, 7, 4, 16, 30,
- 30)}))
- tests.append((BusinessHour(
- -4), {datetime(2014, 7, 1, 11): datetime(2014, 6, 30, 15),
- datetime(2014, 7, 1, 13): datetime(2014, 6, 30, 17),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 1, 11),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 1, 12),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1, 13),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 1, 13),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 4, 13),
- datetime(2014, 7, 4, 18): datetime(2014, 7, 4, 13),
- datetime(2014, 7, 7, 9, 30): datetime(2014, 7, 4, 13, 30),
- datetime(2014, 7, 7, 9, 30, 30): datetime(2014, 7, 4, 13, 30,
- 30)}))
- tests.append((BusinessHour(start='13:00', end='16:00'),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 14),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 1, 14),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 1, 19): datetime(2014, 7, 2, 14),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 2, 14),
- datetime(2014, 7, 1, 15, 30, 15): datetime(2014, 7, 2,
- 13, 30, 15),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 14),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 14)}))
- tests.append((BusinessHour(n=2, start='13:00', end='16:00'), {
- datetime(2014, 7, 1, 17): datetime(2014, 7, 2, 15),
- datetime(2014, 7, 2, 14): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 2, 15),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 15),
- datetime(2014, 7, 2, 14, 30): datetime(2014, 7, 3, 13, 30),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 15),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 15),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 15),
- datetime(2014, 7, 4, 14, 30): datetime(2014, 7, 7, 13, 30),
- datetime(2014, 7, 4, 14, 30, 30): datetime(2014, 7, 7, 13, 30, 30)
- }))
- tests.append((BusinessHour(n=-1, start='13:00', end='16:00'),
- {datetime(2014, 7, 2, 11): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 2, 13): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 2, 14): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 2, 15): datetime(2014, 7, 2, 14),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 15),
- datetime(2014, 7, 2, 16): datetime(2014, 7, 2, 15),
- datetime(2014, 7, 2, 13, 30, 15): datetime(2014, 7, 1,
- 15, 30, 15),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 4, 15),
- datetime(2014, 7, 7, 11): datetime(2014, 7, 4, 15)}))
- tests.append((BusinessHour(n=-3, start='10:00', end='16:00'), {
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1, 13),
- datetime(2014, 7, 2, 14): datetime(2014, 7, 2, 11),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 1, 13),
- datetime(2014, 7, 2, 13): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 2, 11, 30): datetime(2014, 7, 1, 14, 30),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 2, 13),
- datetime(2014, 7, 4, 10): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 4, 13),
- datetime(2014, 7, 4, 16): datetime(2014, 7, 4, 13),
- datetime(2014, 7, 4, 12, 30): datetime(2014, 7, 3, 15, 30),
- datetime(2014, 7, 4, 12, 30, 30): datetime(2014, 7, 3, 15, 30, 30)
- }))
- tests.append((BusinessHour(start='19:00', end='05:00'), {
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1, 20),
- datetime(2014, 7, 2, 14): datetime(2014, 7, 2, 20),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 2, 20),
- datetime(2014, 7, 2, 13): datetime(2014, 7, 2, 20),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 20),
- datetime(2014, 7, 2, 4, 30): datetime(2014, 7, 2, 19, 30),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 1),
- datetime(2014, 7, 4, 10): datetime(2014, 7, 4, 20),
- datetime(2014, 7, 4, 23): datetime(2014, 7, 5, 0),
- datetime(2014, 7, 5, 0): datetime(2014, 7, 5, 1),
- datetime(2014, 7, 5, 4): datetime(2014, 7, 7, 19),
- datetime(2014, 7, 5, 4, 30): datetime(2014, 7, 7, 19, 30),
- datetime(2014, 7, 5, 4, 30, 30): datetime(2014, 7, 7, 19, 30, 30)
- }))
- tests.append((BusinessHour(n=-1, start='19:00', end='05:00'), {
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1, 4),
- datetime(2014, 7, 2, 14): datetime(2014, 7, 2, 4),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 2, 4),
- datetime(2014, 7, 2, 13): datetime(2014, 7, 2, 4),
- datetime(2014, 7, 2, 20): datetime(2014, 7, 2, 5),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 2, 4),
- datetime(2014, 7, 2, 19, 30): datetime(2014, 7, 2, 4, 30),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 2, 23),
- datetime(2014, 7, 3, 6): datetime(2014, 7, 3, 4),
- datetime(2014, 7, 4, 23): datetime(2014, 7, 4, 22),
- datetime(2014, 7, 5, 0): datetime(2014, 7, 4, 23),
- datetime(2014, 7, 5, 4): datetime(2014, 7, 5, 3),
- datetime(2014, 7, 7, 19, 30): datetime(2014, 7, 5, 4, 30),
- datetime(2014, 7, 7, 19, 30, 30): datetime(2014, 7, 5, 4, 30, 30)
- }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_large_n(self):
- tests = []
- tests.append(
- (BusinessHour(40), # A week later
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 8, 11),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 8, 13),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 8, 15),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 8, 16),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 9, 9),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 9, 11),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 9, 9),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 10, 9),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 10, 9),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 10, 9),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 14, 9),
- datetime(2014, 7, 4, 18): datetime(2014, 7, 14, 9),
- datetime(2014, 7, 7, 9, 30): datetime(2014, 7, 14, 9, 30),
- datetime(2014, 7, 7, 9, 30, 30): datetime(2014, 7, 14, 9, 30,
- 30)}))
- tests.append(
- (BusinessHour(-25), # 3 days and 1 hour before
- {datetime(2014, 7, 1, 11): datetime(2014, 6, 26, 10),
- datetime(2014, 7, 1, 13): datetime(2014, 6, 26, 12),
- datetime(2014, 7, 1, 9): datetime(2014, 6, 25, 16),
- datetime(2014, 7, 1, 10): datetime(2014, 6, 25, 17),
- datetime(2014, 7, 3, 11): datetime(2014, 6, 30, 10),
- datetime(2014, 7, 3, 8): datetime(2014, 6, 27, 16),
- datetime(2014, 7, 3, 19): datetime(2014, 6, 30, 16),
- datetime(2014, 7, 3, 23): datetime(2014, 6, 30, 16),
- datetime(2014, 7, 4, 9): datetime(2014, 6, 30, 16),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 6, 18): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 7, 9, 30): datetime(2014, 7, 1, 16, 30),
- datetime(2014, 7, 7, 10, 30, 30): datetime(2014, 7, 2, 9, 30,
- 30)}))
- # 5 days and 3 hours later
- tests.append((BusinessHour(28, start='21:00', end='02:00'),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 9, 0),
- datetime(2014, 7, 1, 22): datetime(2014, 7, 9, 1),
- datetime(2014, 7, 1, 23): datetime(2014, 7, 9, 21),
- datetime(2014, 7, 2, 2): datetime(2014, 7, 10, 0),
- datetime(2014, 7, 3, 21): datetime(2014, 7, 11, 0),
- datetime(2014, 7, 4, 1): datetime(2014, 7, 11, 23),
- datetime(2014, 7, 4, 2): datetime(2014, 7, 12, 0),
- datetime(2014, 7, 4, 3): datetime(2014, 7, 12, 0),
- datetime(2014, 7, 5, 1): datetime(2014, 7, 14, 23),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 15, 0),
- datetime(2014, 7, 6, 18): datetime(2014, 7, 15, 0),
- datetime(2014, 7, 7, 1): datetime(2014, 7, 15, 0),
- datetime(2014, 7, 7, 23, 30): datetime(2014, 7, 15, 21,
- 30)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_nanoseconds(self):
- tests = []
- tests.append((BusinessHour(),
- {Timestamp('2014-07-04 15:00') + Nano(5): Timestamp(
- '2014-07-04 16:00') + Nano(5),
- Timestamp('2014-07-04 16:00') + Nano(5): Timestamp(
- '2014-07-07 09:00') + Nano(5),
- Timestamp('2014-07-04 16:00') - Nano(5): Timestamp(
- '2014-07-04 17:00') - Nano(5)}))
- tests.append((BusinessHour(-1),
- {Timestamp('2014-07-04 15:00') + Nano(5): Timestamp(
- '2014-07-04 14:00') + Nano(5),
- Timestamp('2014-07-04 10:00') + Nano(5): Timestamp(
- '2014-07-04 09:00') + Nano(5),
- Timestamp('2014-07-04 10:00') - Nano(5): Timestamp(
- '2014-07-03 17:00') - Nano(5), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = self._offset()
- offset2 = self._offset()
- self.assertFalse(offset1 != offset2)
- def test_datetimeindex(self):
- idx1 = DatetimeIndex(start='2014-07-04 15:00', end='2014-07-08 10:00',
- freq='BH')
- idx2 = DatetimeIndex(start='2014-07-04 15:00', periods=12, freq='BH')
- idx3 = DatetimeIndex(end='2014-07-08 10:00', periods=12, freq='BH')
- expected = DatetimeIndex(['2014-07-04 15:00', '2014-07-04 16:00',
- '2014-07-07 09:00',
- '2014-07-07 10:00', '2014-07-07 11:00',
- '2014-07-07 12:00',
- '2014-07-07 13:00', '2014-07-07 14:00',
- '2014-07-07 15:00',
- '2014-07-07 16:00', '2014-07-08 09:00',
- '2014-07-08 10:00'],
- freq='BH')
- for idx in [idx1, idx2, idx3]:
- tm.assert_index_equal(idx, expected)
- idx1 = DatetimeIndex(start='2014-07-04 15:45', end='2014-07-08 10:45',
- freq='BH')
- idx2 = DatetimeIndex(start='2014-07-04 15:45', periods=12, freq='BH')
- idx3 = DatetimeIndex(end='2014-07-08 10:45', periods=12, freq='BH')
- expected = DatetimeIndex(['2014-07-04 15:45', '2014-07-04 16:45',
- '2014-07-07 09:45',
- '2014-07-07 10:45', '2014-07-07 11:45',
- '2014-07-07 12:45',
- '2014-07-07 13:45', '2014-07-07 14:45',
- '2014-07-07 15:45',
- '2014-07-07 16:45', '2014-07-08 09:45',
- '2014-07-08 10:45'],
- freq='BH')
- expected = idx1
- for idx in [idx1, idx2, idx3]:
- tm.assert_index_equal(idx, expected)
- class TestCustomBusinessHour(Base):
- _multiprocess_can_split_ = True
- _offset = CustomBusinessHour
- def setUp(self):
- # 2014 Calendar to check custom holidays
- # Sun Mon Tue Wed Thu Fri Sat
- # 6/22 23 24 25 26 27 28
- # 29 30 7/1 2 3 4 5
- # 6 7 8 9 10 11 12
- self.d = datetime(2014, 7, 1, 10, 00)
- self.offset1 = CustomBusinessHour(weekmask='Tue Wed Thu Fri')
- self.holidays = ['2014-06-27', datetime(2014, 6, 30),
- np.datetime64('2014-07-02')]
- self.offset2 = CustomBusinessHour(holidays=self.holidays)
- def test_constructor_errors(self):
- from datetime import time as dt_time
- with tm.assertRaises(ValueError):
- CustomBusinessHour(start=dt_time(11, 0, 5))
- with tm.assertRaises(ValueError):
- CustomBusinessHour(start='AAA')
- with tm.assertRaises(ValueError):
- CustomBusinessHour(start='14:00:05')
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = self._offset()
- offset2 = self._offset()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- self.assertEqual(repr(self.offset1),
- '<CustomBusinessHour: CBH=09:00-17:00>')
- self.assertEqual(repr(self.offset2),
- '<CustomBusinessHour: CBH=09:00-17:00>')
- def test_with_offset(self):
- expected = Timestamp('2014-07-01 13:00')
- self.assertEqual(self.d + CustomBusinessHour() * 3, expected)
- self.assertEqual(self.d + CustomBusinessHour(n=3), expected)
- def testEQ(self):
- for offset in [self.offset1, self.offset2]:
- self.assertEqual(offset, offset)
- self.assertNotEqual(CustomBusinessHour(), CustomBusinessHour(-1))
- self.assertEqual(CustomBusinessHour(start='09:00'),
- CustomBusinessHour())
- self.assertNotEqual(CustomBusinessHour(start='09:00'),
- CustomBusinessHour(start='09:01'))
- self.assertNotEqual(CustomBusinessHour(start='09:00', end='17:00'),
- CustomBusinessHour(start='17:00', end='09:01'))
- self.assertNotEqual(CustomBusinessHour(weekmask='Tue Wed Thu Fri'),
- CustomBusinessHour(weekmask='Mon Tue Wed Thu Fri'))
- self.assertNotEqual(CustomBusinessHour(holidays=['2014-06-27']),
- CustomBusinessHour(holidays=['2014-06-28']))
- def test_hash(self):
- self.assertEqual(hash(self.offset1), hash(self.offset1))
- self.assertEqual(hash(self.offset2), hash(self.offset2))
- def testCall(self):
- self.assertEqual(self.offset1(self.d), datetime(2014, 7, 1, 11))
- self.assertEqual(self.offset2(self.d), datetime(2014, 7, 1, 11))
- def testRAdd(self):
- self.assertEqual(self.d + self.offset2, self.offset2 + self.d)
- def testSub(self):
- off = self.offset2
- self.assertRaises(Exception, off.__sub__, self.d)
- self.assertEqual(2 * off - off, off)
- self.assertEqual(self.d - self.offset2, self.d - (2 * off - off))
- def testRSub(self):
- self.assertEqual(self.d - self.offset2, (-self.offset2).apply(self.d))
- def testMult1(self):
- self.assertEqual(self.d + 5 * self.offset1, self.d + self._offset(5))
- def testMult2(self):
- self.assertEqual(self.d + (-3 * self._offset(-2)),
- self.d + self._offset(6))
- def testRollback1(self):
- self.assertEqual(self.offset1.rollback(self.d), self.d)
- self.assertEqual(self.offset2.rollback(self.d), self.d)
- d = datetime(2014, 7, 1, 0)
- # 2014/07/01 is Tuesday, 06/30 is Monday(holiday)
- self.assertEqual(self.offset1.rollback(d), datetime(2014, 6, 27, 17))
- # 2014/6/30 and 2014/6/27 are holidays
- self.assertEqual(self.offset2.rollback(d), datetime(2014, 6, 26, 17))
- def testRollback2(self):
- self.assertEqual(self._offset(-3)
- .rollback(datetime(2014, 7, 5, 15, 0)),
- datetime(2014, 7, 4, 17, 0))
- def testRollforward1(self):
- self.assertEqual(self.offset1.rollforward(self.d), self.d)
- self.assertEqual(self.offset2.rollforward(self.d), self.d)
- d = datetime(2014, 7, 1, 0)
- self.assertEqual(self.offset1.rollforward(d), datetime(2014, 7, 1, 9))
- self.assertEqual(self.offset2.rollforward(d), datetime(2014, 7, 1, 9))
- def testRollforward2(self):
- self.assertEqual(self._offset(-3)
- .rollforward(datetime(2014, 7, 5, 16, 0)),
- datetime(2014, 7, 7, 9))
- def test_roll_date_object(self):
- offset = BusinessHour()
- dt = datetime(2014, 7, 6, 15, 0)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2014, 7, 4, 17))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2014, 7, 7, 9))
- def test_normalize(self):
- tests = []
- tests.append((CustomBusinessHour(normalize=True,
- holidays=self.holidays),
- {datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 3),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 3),
- datetime(2014, 7, 1, 23): datetime(2014, 7, 3),
- datetime(2014, 7, 1, 0): datetime(2014, 7, 1),
- datetime(2014, 7, 4, 15): datetime(2014, 7, 4),
- datetime(2014, 7, 4, 15, 59): datetime(2014, 7, 4),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7),
- datetime(2014, 7, 5, 23): datetime(2014, 7, 7),
- datetime(2014, 7, 6, 10): datetime(2014, 7, 7)}))
- tests.append((CustomBusinessHour(-1, normalize=True,
- holidays=self.holidays),
- {datetime(2014, 7, 1, 8): datetime(2014, 6, 26),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 10): datetime(2014, 6, 26),
- datetime(2014, 7, 1, 0): datetime(2014, 6, 26),
- datetime(2014, 7, 7, 10): datetime(2014, 7, 4),
- datetime(2014, 7, 7, 10, 1): datetime(2014, 7, 7),
- datetime(2014, 7, 5, 23): datetime(2014, 7, 4),
- datetime(2014, 7, 6, 10): datetime(2014, 7, 4)}))
- tests.append((CustomBusinessHour(1, normalize=True, start='17:00',
- end='04:00', holidays=self.holidays),
- {datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
- datetime(2014, 7, 1, 23): datetime(2014, 7, 2),
- datetime(2014, 7, 2, 2): datetime(2014, 7, 2),
- datetime(2014, 7, 2, 3): datetime(2014, 7, 3),
- datetime(2014, 7, 4, 23): datetime(2014, 7, 5),
- datetime(2014, 7, 5, 2): datetime(2014, 7, 5),
- datetime(2014, 7, 7, 2): datetime(2014, 7, 7),
- datetime(2014, 7, 7, 17): datetime(2014, 7, 7)}))
- for offset, cases in tests:
- for dt, expected in compat.iteritems(cases):
- self.assertEqual(offset.apply(dt), expected)
- def test_onOffset(self):
- tests = []
- tests.append((CustomBusinessHour(start='10:00', end='15:00',
- holidays=self.holidays),
- {datetime(2014, 7, 1, 9): False,
- datetime(2014, 7, 1, 10): True,
- datetime(2014, 7, 1, 15): True,
- datetime(2014, 7, 1, 15, 1): False,
- datetime(2014, 7, 5, 12): False,
- datetime(2014, 7, 6, 12): False}))
- for offset, cases in tests:
- for dt, expected in compat.iteritems(cases):
- self.assertEqual(offset.onOffset(dt), expected)
- def test_apply(self):
- tests = []
- tests.append((
- CustomBusinessHour(holidays=self.holidays),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 12),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 1, 14),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 1, 16),
- datetime(2014, 7, 1, 19): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 3, 9),
- datetime(2014, 7, 1, 16, 30, 15): datetime(2014, 7, 3, 9, 30, 15),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 3, 10),
- # out of business hours
- datetime(2014, 7, 2, 8): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 10),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 10),
- # saturday
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 10),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 10),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 9, 30),
- datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 9, 30,
- 30)}))
- tests.append((
- CustomBusinessHour(4, holidays=self.holidays),
- {datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 15),
- datetime(2014, 7, 1, 13): datetime(2014, 7, 3, 9),
- datetime(2014, 7, 1, 15): datetime(2014, 7, 3, 11),
- datetime(2014, 7, 1, 16): datetime(2014, 7, 3, 12),
- datetime(2014, 7, 1, 17): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 11): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 8): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 13),
- datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 13),
- datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 13),
- datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 12, 30),
- datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 12, 30,
- 30)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_nanoseconds(self):
- tests = []
- tests.append((CustomBusinessHour(holidays=self.holidays),
- {Timestamp('2014-07-01 15:00') + Nano(5): Timestamp(
- '2014-07-01 16:00') + Nano(5),
- Timestamp('2014-07-01 16:00') + Nano(5): Timestamp(
- '2014-07-03 09:00') + Nano(5),
- Timestamp('2014-07-01 16:00') - Nano(5): Timestamp(
- '2014-07-01 17:00') - Nano(5)}))
- tests.append((CustomBusinessHour(-1, holidays=self.holidays),
- {Timestamp('2014-07-01 15:00') + Nano(5): Timestamp(
- '2014-07-01 14:00') + Nano(5),
- Timestamp('2014-07-01 10:00') + Nano(5): Timestamp(
- '2014-07-01 09:00') + Nano(5),
- Timestamp('2014-07-01 10:00') - Nano(5): Timestamp(
- '2014-06-26 17:00') - Nano(5), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- class TestCustomBusinessDay(Base):
- _multiprocess_can_split_ = True
- _offset = CDay
- def setUp(self):
- self.d = datetime(2008, 1, 1)
- self.nd = np_datetime64_compat('2008-01-01 00:00:00Z')
- self.offset = CDay()
- self.offset2 = CDay(2)
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = CDay()
- offset2 = CDay()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- assert repr(self.offset) == '<CustomBusinessDay>'
- assert repr(self.offset2) == '<2 * CustomBusinessDays>'
- expected = '<BusinessDay: offset=datetime.timedelta(1)>'
- assert repr(self.offset + timedelta(1)) == expected
- def test_with_offset(self):
- offset = self.offset + timedelta(hours=2)
- assert (self.d + offset) == datetime(2008, 1, 2, 2)
- def testEQ(self):
- self.assertEqual(self.offset2, self.offset2)
- def test_mul(self):
- pass
- def test_hash(self):
- self.assertEqual(hash(self.offset2), hash(self.offset2))
- def testCall(self):
- self.assertEqual(self.offset2(self.d), datetime(2008, 1, 3))
- self.assertEqual(self.offset2(self.nd), datetime(2008, 1, 3))
- def testRAdd(self):
- self.assertEqual(self.d + self.offset2, self.offset2 + self.d)
- def testSub(self):
- off = self.offset2
- self.assertRaises(Exception, off.__sub__, self.d)
- self.assertEqual(2 * off - off, off)
- self.assertEqual(self.d - self.offset2, self.d + CDay(-2))
- def testRSub(self):
- self.assertEqual(self.d - self.offset2, (-self.offset2).apply(self.d))
- def testMult1(self):
- self.assertEqual(self.d + 10 * self.offset, self.d + CDay(10))
- def testMult2(self):
- self.assertEqual(self.d + (-5 * CDay(-10)), self.d + CDay(50))
- def testRollback1(self):
- self.assertEqual(CDay(10).rollback(self.d), self.d)
- def testRollback2(self):
- self.assertEqual(
- CDay(10).rollback(datetime(2008, 1, 5)), datetime(2008, 1, 4))
- def testRollforward1(self):
- self.assertEqual(CDay(10).rollforward(self.d), self.d)
- def testRollforward2(self):
- self.assertEqual(
- CDay(10).rollforward(datetime(2008, 1, 5)), datetime(2008, 1, 7))
- def test_roll_date_object(self):
- offset = CDay()
- dt = date(2012, 9, 15)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 14))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 17))
- offset = offsets.Day()
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- def test_onOffset(self):
- tests = [(CDay(), datetime(2008, 1, 1), True),
- (CDay(), datetime(2008, 1, 5), False)]
- for offset, d, expected in tests:
- assertOnOffset(offset, d, expected)
- def test_apply(self):
- from pandas.core.datetools import cday
- tests = []
- tests.append((cday, {datetime(2008, 1, 1): datetime(2008, 1, 2),
- datetime(2008, 1, 4): datetime(2008, 1, 7),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 8)}))
- tests.append((2 * cday, {datetime(2008, 1, 1): datetime(2008, 1, 3),
- datetime(2008, 1, 4): datetime(2008, 1, 8),
- datetime(2008, 1, 5): datetime(2008, 1, 8),
- datetime(2008, 1, 6): datetime(2008, 1, 8),
- datetime(2008, 1, 7): datetime(2008, 1, 9)}))
- tests.append((-cday, {datetime(2008, 1, 1): datetime(2007, 12, 31),
- datetime(2008, 1, 4): datetime(2008, 1, 3),
- datetime(2008, 1, 5): datetime(2008, 1, 4),
- datetime(2008, 1, 6): datetime(2008, 1, 4),
- datetime(2008, 1, 7): datetime(2008, 1, 4),
- datetime(2008, 1, 8): datetime(2008, 1, 7)}))
- tests.append((-2 * cday, {datetime(2008, 1, 1): datetime(2007, 12, 28),
- datetime(2008, 1, 4): datetime(2008, 1, 2),
- datetime(2008, 1, 5): datetime(2008, 1, 3),
- datetime(2008, 1, 6): datetime(2008, 1, 3),
- datetime(2008, 1, 7): datetime(2008, 1, 3),
- datetime(2008, 1, 8): datetime(2008, 1, 4),
- datetime(2008, 1, 9): datetime(2008, 1, 7)}))
- tests.append((CDay(0), {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 4): datetime(2008, 1, 4),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 7)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_large_n(self):
- dt = datetime(2012, 10, 23)
- result = dt + CDay(10)
- self.assertEqual(result, datetime(2012, 11, 6))
- result = dt + CDay(100) - CDay(100)
- self.assertEqual(result, dt)
- off = CDay() * 6
- rs = datetime(2012, 1, 1) - off
- xp = datetime(2011, 12, 23)
- self.assertEqual(rs, xp)
- st = datetime(2011, 12, 18)
- rs = st + off
- xp = datetime(2011, 12, 26)
- self.assertEqual(rs, xp)
- def test_apply_corner(self):
- self.assertRaises(Exception, CDay().apply, BMonthEnd())
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = CDay()
- offset2 = CDay()
- self.assertFalse(offset1 != offset2)
- def test_holidays(self):
- # Define a TradingDay offset
- holidays = ['2012-05-01', datetime(2013, 5, 1),
- np.datetime64('2014-05-01')]
- tday = CDay(holidays=holidays)
- for year in range(2012, 2015):
- dt = datetime(year, 4, 30)
- xp = datetime(year, 5, 2)
- rs = dt + tday
- self.assertEqual(rs, xp)
- def test_weekmask(self):
- weekmask_saudi = 'Sat Sun Mon Tue Wed' # Thu-Fri Weekend
- weekmask_uae = '1111001' # Fri-Sat Weekend
- weekmask_egypt = [1, 1, 1, 1, 0, 0, 1] # Fri-Sat Weekend
- bday_saudi = CDay(weekmask=weekmask_saudi)
- bday_uae = CDay(weekmask=weekmask_uae)
- bday_egypt = CDay(weekmask=weekmask_egypt)
- dt = datetime(2013, 5, 1)
- xp_saudi = datetime(2013, 5, 4)
- xp_uae = datetime(2013, 5, 2)
- xp_egypt = datetime(2013, 5, 2)
- self.assertEqual(xp_saudi, dt + bday_saudi)
- self.assertEqual(xp_uae, dt + bday_uae)
- self.assertEqual(xp_egypt, dt + bday_egypt)
- xp2 = datetime(2013, 5, 5)
- self.assertEqual(xp2, dt + 2 * bday_saudi)
- self.assertEqual(xp2, dt + 2 * bday_uae)
- self.assertEqual(xp2, dt + 2 * bday_egypt)
- def test_weekmask_and_holidays(self):
- weekmask_egypt = 'Sun Mon Tue Wed Thu' # Fri-Sat Weekend
- holidays = ['2012-05-01', datetime(2013, 5, 1),
- np.datetime64('2014-05-01')]
- bday_egypt = CDay(holidays=holidays, weekmask=weekmask_egypt)
- dt = datetime(2013, 4, 30)
- xp_egypt = datetime(2013, 5, 5)
- self.assertEqual(xp_egypt, dt + 2 * bday_egypt)
- def test_calendar(self):
- calendar = USFederalHolidayCalendar()
- dt = datetime(2014, 1, 17)
- assertEq(CDay(calendar=calendar), dt, datetime(2014, 1, 21))
- def test_roundtrip_pickle(self):
- def _check_roundtrip(obj):
- unpickled = self.round_trip_pickle(obj)
- self.assertEqual(unpickled, obj)
- _check_roundtrip(self.offset)
- _check_roundtrip(self.offset2)
- _check_roundtrip(self.offset * 2)
- def test_pickle_compat_0_14_1(self):
- hdays = [datetime(2013, 1, 1) for ele in range(4)]
- pth = tm.get_data_path()
- cday0_14_1 = read_pickle(os.path.join(pth, 'cday-0.14.1.pickle'))
- cday = CDay(holidays=hdays)
- self.assertEqual(cday, cday0_14_1)
- class CustomBusinessMonthBase(object):
- _multiprocess_can_split_ = True
- def setUp(self):
- self.d = datetime(2008, 1, 1)
- self.offset = self._object()
- self.offset2 = self._object(2)
- def testEQ(self):
- self.assertEqual(self.offset2, self.offset2)
- def test_mul(self):
- pass
- def test_hash(self):
- self.assertEqual(hash(self.offset2), hash(self.offset2))
- def testRAdd(self):
- self.assertEqual(self.d + self.offset2, self.offset2 + self.d)
- def testSub(self):
- off = self.offset2
- self.assertRaises(Exception, off.__sub__, self.d)
- self.assertEqual(2 * off - off, off)
- self.assertEqual(self.d - self.offset2, self.d + self._object(-2))
- def testRSub(self):
- self.assertEqual(self.d - self.offset2, (-self.offset2).apply(self.d))
- def testMult1(self):
- self.assertEqual(self.d + 10 * self.offset, self.d + self._object(10))
- def testMult2(self):
- self.assertEqual(self.d + (-5 * self._object(-10)),
- self.d + self._object(50))
- def test_offsets_compare_equal(self):
- offset1 = self._object()
- offset2 = self._object()
- self.assertFalse(offset1 != offset2)
- def test_roundtrip_pickle(self):
- def _check_roundtrip(obj):
- unpickled = self.round_trip_pickle(obj)
- self.assertEqual(unpickled, obj)
- _check_roundtrip(self._object())
- _check_roundtrip(self._object(2))
- _check_roundtrip(self._object() * 2)
- class TestCustomBusinessMonthEnd(CustomBusinessMonthBase, Base):
- _object = CBMonthEnd
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = CBMonthEnd()
- offset2 = CBMonthEnd()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- assert repr(self.offset) == '<CustomBusinessMonthEnd>'
- assert repr(self.offset2) == '<2 * CustomBusinessMonthEnds>'
- def testCall(self):
- self.assertEqual(self.offset2(self.d), datetime(2008, 2, 29))
- def testRollback1(self):
- self.assertEqual(
- CDay(10).rollback(datetime(2007, 12, 31)), datetime(2007, 12, 31))
- def testRollback2(self):
- self.assertEqual(CBMonthEnd(10).rollback(self.d),
- datetime(2007, 12, 31))
- def testRollforward1(self):
- self.assertEqual(CBMonthEnd(10).rollforward(
- self.d), datetime(2008, 1, 31))
- def test_roll_date_object(self):
- offset = CBMonthEnd()
- dt = date(2012, 9, 15)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 8, 31))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 28))
- offset = offsets.Day()
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- def test_onOffset(self):
- tests = [(CBMonthEnd(), datetime(2008, 1, 31), True),
- (CBMonthEnd(), datetime(2008, 1, 1), False)]
- for offset, d, expected in tests:
- assertOnOffset(offset, d, expected)
- def test_apply(self):
- cbm = CBMonthEnd()
- tests = []
- tests.append((cbm, {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 2, 7): datetime(2008, 2, 29)}))
- tests.append((2 * cbm, {datetime(2008, 1, 1): datetime(2008, 2, 29),
- datetime(2008, 2, 7): datetime(2008, 3, 31)}))
- tests.append((-cbm, {datetime(2008, 1, 1): datetime(2007, 12, 31),
- datetime(2008, 2, 8): datetime(2008, 1, 31)}))
- tests.append((-2 * cbm, {datetime(2008, 1, 1): datetime(2007, 11, 30),
- datetime(2008, 2, 9): datetime(2007, 12, 31)}
- ))
- tests.append((CBMonthEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 2, 7): datetime(2008, 2, 29)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_large_n(self):
- dt = datetime(2012, 10, 23)
- result = dt + CBMonthEnd(10)
- self.assertEqual(result, datetime(2013, 7, 31))
- result = dt + CDay(100) - CDay(100)
- self.assertEqual(result, dt)
- off = CBMonthEnd() * 6
- rs = datetime(2012, 1, 1) - off
- xp = datetime(2011, 7, 29)
- self.assertEqual(rs, xp)
- st = datetime(2011, 12, 18)
- rs = st + off
- xp = datetime(2012, 5, 31)
- self.assertEqual(rs, xp)
- def test_holidays(self):
- # Define a TradingDay offset
- holidays = ['2012-01-31', datetime(2012, 2, 28),
- np.datetime64('2012-02-29')]
- bm_offset = CBMonthEnd(holidays=holidays)
- dt = datetime(2012, 1, 1)
- self.assertEqual(dt + bm_offset, datetime(2012, 1, 30))
- self.assertEqual(dt + 2 * bm_offset, datetime(2012, 2, 27))
- def test_datetimeindex(self):
- from pandas.tseries.holiday import USFederalHolidayCalendar
- hcal = USFederalHolidayCalendar()
- freq = CBMonthEnd(calendar=hcal)
- self.assertEqual(DatetimeIndex(start='20120101', end='20130101',
- freq=freq).tolist()[0],
- datetime(2012, 1, 31))
- class TestCustomBusinessMonthBegin(CustomBusinessMonthBase, Base):
- _object = CBMonthBegin
- def test_different_normalize_equals(self):
- # equivalent in this special case
- offset = CBMonthBegin()
- offset2 = CBMonthBegin()
- offset2.normalize = True
- self.assertEqual(offset, offset2)
- def test_repr(self):
- assert repr(self.offset) == '<CustomBusinessMonthBegin>'
- assert repr(self.offset2) == '<2 * CustomBusinessMonthBegins>'
- def testCall(self):
- self.assertEqual(self.offset2(self.d), datetime(2008, 3, 3))
- def testRollback1(self):
- self.assertEqual(
- CDay(10).rollback(datetime(2007, 12, 31)), datetime(2007, 12, 31))
- def testRollback2(self):
- self.assertEqual(CBMonthBegin(10).rollback(self.d),
- datetime(2008, 1, 1))
- def testRollforward1(self):
- self.assertEqual(CBMonthBegin(10).rollforward(
- self.d), datetime(2008, 1, 1))
- def test_roll_date_object(self):
- offset = CBMonthBegin()
- dt = date(2012, 9, 15)
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 3))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 10, 1))
- offset = offsets.Day()
- result = offset.rollback(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- result = offset.rollforward(dt)
- self.assertEqual(result, datetime(2012, 9, 15))
- def test_onOffset(self):
- tests = [(CBMonthBegin(), datetime(2008, 1, 1), True),
- (CBMonthBegin(), datetime(2008, 1, 31), False)]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_apply(self):
- cbm = CBMonthBegin()
- tests = []
- tests.append((cbm, {datetime(2008, 1, 1): datetime(2008, 2, 1),
- datetime(2008, 2, 7): datetime(2008, 3, 3)}))
- tests.append((2 * cbm, {datetime(2008, 1, 1): datetime(2008, 3, 3),
- datetime(2008, 2, 7): datetime(2008, 4, 1)}))
- tests.append((-cbm, {datetime(2008, 1, 1): datetime(2007, 12, 3),
- datetime(2008, 2, 8): datetime(2008, 2, 1)}))
- tests.append((-2 * cbm, {datetime(2008, 1, 1): datetime(2007, 11, 1),
- datetime(2008, 2, 9): datetime(2008, 1, 1)}))
- tests.append((CBMonthBegin(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 7): datetime(2008, 2, 1)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_large_n(self):
- dt = datetime(2012, 10, 23)
- result = dt + CBMonthBegin(10)
- self.assertEqual(result, datetime(2013, 8, 1))
- result = dt + CDay(100) - CDay(100)
- self.assertEqual(result, dt)
- off = CBMonthBegin() * 6
- rs = datetime(2012, 1, 1) - off
- xp = datetime(2011, 7, 1)
- self.assertEqual(rs, xp)
- st = datetime(2011, 12, 18)
- rs = st + off
- xp = datetime(2012, 6, 1)
- self.assertEqual(rs, xp)
- def test_holidays(self):
- # Define a TradingDay offset
- holidays = ['2012-02-01', datetime(2012, 2, 2),
- np.datetime64('2012-03-01')]
- bm_offset = CBMonthBegin(holidays=holidays)
- dt = datetime(2012, 1, 1)
- self.assertEqual(dt + bm_offset, datetime(2012, 1, 2))
- self.assertEqual(dt + 2 * bm_offset, datetime(2012, 2, 3))
- def test_datetimeindex(self):
- hcal = USFederalHolidayCalendar()
- cbmb = CBMonthBegin(calendar=hcal)
- self.assertEqual(DatetimeIndex(start='20120101', end='20130101',
- freq=cbmb).tolist()[0],
- datetime(2012, 1, 3))
- def assertOnOffset(offset, date, expected):
- actual = offset.onOffset(date)
- assert actual == expected, ("\nExpected: %s\nActual: %s\nFor Offset: %s)"
- "\nAt Date: %s" %
- (expected, actual, offset, date))
- class TestWeek(Base):
- _offset = Week
- def test_repr(self):
- self.assertEqual(repr(Week(weekday=0)), "<Week: weekday=0>")
- self.assertEqual(repr(Week(n=-1, weekday=0)), "<-1 * Week: weekday=0>")
- self.assertEqual(repr(Week(n=-2, weekday=0)),
- "<-2 * Weeks: weekday=0>")
- def test_corner(self):
- self.assertRaises(ValueError, Week, weekday=7)
- assertRaisesRegexp(ValueError, "Day must be", Week, weekday=-1)
- def test_isAnchored(self):
- self.assertTrue(Week(weekday=0).isAnchored())
- self.assertFalse(Week().isAnchored())
- self.assertFalse(Week(2, weekday=2).isAnchored())
- self.assertFalse(Week(2).isAnchored())
- def test_offset(self):
- tests = []
- tests.append((Week(), # not business week
- {datetime(2008, 1, 1): datetime(2008, 1, 8),
- datetime(2008, 1, 4): datetime(2008, 1, 11),
- datetime(2008, 1, 5): datetime(2008, 1, 12),
- datetime(2008, 1, 6): datetime(2008, 1, 13),
- datetime(2008, 1, 7): datetime(2008, 1, 14)}))
- tests.append((Week(weekday=0), # Mon
- {datetime(2007, 12, 31): datetime(2008, 1, 7),
- datetime(2008, 1, 4): datetime(2008, 1, 7),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 14)}))
- tests.append((Week(0, weekday=0), # n=0 -> roll forward. Mon
- {datetime(2007, 12, 31): datetime(2007, 12, 31),
- datetime(2008, 1, 4): datetime(2008, 1, 7),
- datetime(2008, 1, 5): datetime(2008, 1, 7),
- datetime(2008, 1, 6): datetime(2008, 1, 7),
- datetime(2008, 1, 7): datetime(2008, 1, 7)}))
- tests.append((Week(-2, weekday=1), # n=0 -> roll forward. Mon
- {datetime(2010, 4, 6): datetime(2010, 3, 23),
- datetime(2010, 4, 8): datetime(2010, 3, 30),
- datetime(2010, 4, 5): datetime(2010, 3, 23)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- for weekday in range(7):
- offset = Week(weekday=weekday)
- for day in range(1, 8):
- date = datetime(2008, 1, day)
- if day % 7 == weekday:
- expected = True
- else:
- expected = False
- assertOnOffset(offset, date, expected)
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = Week()
- offset2 = Week()
- self.assertFalse(offset1 != offset2)
- class TestWeekOfMonth(Base):
- _offset = WeekOfMonth
- def test_constructor(self):
- assertRaisesRegexp(ValueError, "^N cannot be 0", WeekOfMonth, n=0,
- week=1, weekday=1)
- assertRaisesRegexp(ValueError, "^Week", WeekOfMonth, n=1, week=4,
- weekday=0)
- assertRaisesRegexp(ValueError, "^Week", WeekOfMonth, n=1, week=-1,
- weekday=0)
- assertRaisesRegexp(ValueError, "^Day", WeekOfMonth, n=1, week=0,
- weekday=-1)
- assertRaisesRegexp(ValueError, "^Day", WeekOfMonth, n=1, week=0,
- weekday=7)
- def test_repr(self):
- self.assertEqual(repr(WeekOfMonth(weekday=1, week=2)),
- "<WeekOfMonth: week=2, weekday=1>")
- def test_offset(self):
- date1 = datetime(2011, 1, 4) # 1st Tuesday of Month
- date2 = datetime(2011, 1, 11) # 2nd Tuesday of Month
- date3 = datetime(2011, 1, 18) # 3rd Tuesday of Month
- date4 = datetime(2011, 1, 25) # 4th Tuesday of Month
- # see for loop for structure
- test_cases = [
- (-2, 2, 1, date1, datetime(2010, 11, 16)),
- (-2, 2, 1, date2, datetime(2010, 11, 16)),
- (-2, 2, 1, date3, datetime(2010, 11, 16)),
- (-2, 2, 1, date4, datetime(2010, 12, 21)),
- (-1, 2, 1, date1, datetime(2010, 12, 21)),
- (-1, 2, 1, date2, datetime(2010, 12, 21)),
- (-1, 2, 1, date3, datetime(2010, 12, 21)),
- (-1, 2, 1, date4, datetime(2011, 1, 18)),
- (1, 0, 0, date1, datetime(2011, 2, 7)),
- (1, 0, 0, date2, datetime(2011, 2, 7)),
- (1, 0, 0, date3, datetime(2011, 2, 7)),
- (1, 0, 0, date4, datetime(2011, 2, 7)),
- (1, 0, 1, date1, datetime(2011, 2, 1)),
- (1, 0, 1, date2, datetime(2011, 2, 1)),
- (1, 0, 1, date3, datetime(2011, 2, 1)),
- (1, 0, 1, date4, datetime(2011, 2, 1)),
- (1, 0, 2, date1, datetime(2011, 1, 5)),
- (1, 0, 2, date2, datetime(2011, 2, 2)),
- (1, 0, 2, date3, datetime(2011, 2, 2)),
- (1, 0, 2, date4, datetime(2011, 2, 2)),
- (1, 2, 1, date1, datetime(2011, 1, 18)),
- (1, 2, 1, date2, datetime(2011, 1, 18)),
- (1, 2, 1, date3, datetime(2011, 2, 15)),
- (1, 2, 1, date4, datetime(2011, 2, 15)),
- (2, 2, 1, date1, datetime(2011, 2, 15)),
- (2, 2, 1, date2, datetime(2011, 2, 15)),
- (2, 2, 1, date3, datetime(2011, 3, 15)),
- (2, 2, 1, date4, datetime(2011, 3, 15)),
- ]
- for n, week, weekday, dt, expected in test_cases:
- offset = WeekOfMonth(n, week=week, weekday=weekday)
- assertEq(offset, dt, expected)
- # try subtracting
- result = datetime(2011, 2, 1) - WeekOfMonth(week=1, weekday=2)
- self.assertEqual(result, datetime(2011, 1, 12))
- result = datetime(2011, 2, 3) - WeekOfMonth(week=0, weekday=2)
- self.assertEqual(result, datetime(2011, 2, 2))
- def test_onOffset(self):
- test_cases = [
- (0, 0, datetime(2011, 2, 7), True),
- (0, 0, datetime(2011, 2, 6), False),
- (0, 0, datetime(2011, 2, 14), False),
- (1, 0, datetime(2011, 2, 14), True),
- (0, 1, datetime(2011, 2, 1), True),
- (0, 1, datetime(2011, 2, 8), False),
- ]
- for week, weekday, dt, expected in test_cases:
- offset = WeekOfMonth(week=week, weekday=weekday)
- self.assertEqual(offset.onOffset(dt), expected)
- class TestLastWeekOfMonth(Base):
- _offset = LastWeekOfMonth
- def test_constructor(self):
- assertRaisesRegexp(ValueError, "^N cannot be 0", LastWeekOfMonth, n=0,
- weekday=1)
- assertRaisesRegexp(ValueError, "^Day", LastWeekOfMonth, n=1,
- weekday=-1)
- assertRaisesRegexp(ValueError, "^Day", LastWeekOfMonth, n=1, weekday=7)
- def test_offset(self):
- # Saturday
- last_sat = datetime(2013, 8, 31)
- next_sat = datetime(2013, 9, 28)
- offset_sat = LastWeekOfMonth(n=1, weekday=5)
- one_day_before = (last_sat + timedelta(days=-1))
- self.assertEqual(one_day_before + offset_sat, last_sat)
- one_day_after = (last_sat + timedelta(days=+1))
- self.assertEqual(one_day_after + offset_sat, next_sat)
- # Test On that day
- self.assertEqual(last_sat + offset_sat, next_sat)
- # Thursday
- offset_thur = LastWeekOfMonth(n=1, weekday=3)
- last_thurs = datetime(2013, 1, 31)
- next_thurs = datetime(2013, 2, 28)
- one_day_before = last_thurs + timedelta(days=-1)
- self.assertEqual(one_day_before + offset_thur, last_thurs)
- one_day_after = last_thurs + timedelta(days=+1)
- self.assertEqual(one_day_after + offset_thur, next_thurs)
- # Test on that day
- self.assertEqual(last_thurs + offset_thur, next_thurs)
- three_before = last_thurs + timedelta(days=-3)
- self.assertEqual(three_before + offset_thur, last_thurs)
- two_after = last_thurs + timedelta(days=+2)
- self.assertEqual(two_after + offset_thur, next_thurs)
- offset_sunday = LastWeekOfMonth(n=1, weekday=WeekDay.SUN)
- self.assertEqual(datetime(2013, 7, 31) +
- offset_sunday, datetime(2013, 8, 25))
- def test_onOffset(self):
- test_cases = [
- (WeekDay.SUN, datetime(2013, 1, 27), True),
- (WeekDay.SAT, datetime(2013, 3, 30), True),
- (WeekDay.MON, datetime(2013, 2, 18), False), # Not the last Mon
- (WeekDay.SUN, datetime(2013, 2, 25), False), # Not a SUN
- (WeekDay.MON, datetime(2013, 2, 25), True),
- (WeekDay.SAT, datetime(2013, 11, 30), True),
- (WeekDay.SAT, datetime(2006, 8, 26), True),
- (WeekDay.SAT, datetime(2007, 8, 25), True),
- (WeekDay.SAT, datetime(2008, 8, 30), True),
- (WeekDay.SAT, datetime(2009, 8, 29), True),
- (WeekDay.SAT, datetime(2010, 8, 28), True),
- (WeekDay.SAT, datetime(2011, 8, 27), True),
- (WeekDay.SAT, datetime(2019, 8, 31), True),
- ]
- for weekday, dt, expected in test_cases:
- offset = LastWeekOfMonth(weekday=weekday)
- self.assertEqual(offset.onOffset(dt), expected, msg=date)
- class TestBMonthBegin(Base):
- _offset = BMonthBegin
- def test_offset(self):
- tests = []
- tests.append((BMonthBegin(),
- {datetime(2008, 1, 1): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2006, 9, 1): datetime(2006, 10, 2),
- datetime(2007, 1, 1): datetime(2007, 2, 1),
- datetime(2006, 12, 1): datetime(2007, 1, 1)}))
- tests.append((BMonthBegin(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2006, 10, 2): datetime(2006, 10, 2),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2006, 9, 15): datetime(2006, 10, 2)}))
- tests.append((BMonthBegin(2),
- {datetime(2008, 1, 1): datetime(2008, 3, 3),
- datetime(2008, 1, 15): datetime(2008, 3, 3),
- datetime(2006, 12, 29): datetime(2007, 2, 1),
- datetime(2006, 12, 31): datetime(2007, 2, 1),
- datetime(2007, 1, 1): datetime(2007, 3, 1),
- datetime(2006, 11, 1): datetime(2007, 1, 1)}))
- tests.append((BMonthBegin(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 1),
- datetime(2008, 6, 30): datetime(2008, 6, 2),
- datetime(2008, 6, 1): datetime(2008, 5, 1),
- datetime(2008, 3, 10): datetime(2008, 3, 3),
- datetime(2008, 12, 31): datetime(2008, 12, 1),
- datetime(2006, 12, 29): datetime(2006, 12, 1),
- datetime(2006, 12, 30): datetime(2006, 12, 1),
- datetime(2007, 1, 1): datetime(2006, 12, 1)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- tests = [(BMonthBegin(), datetime(2007, 12, 31), False),
- (BMonthBegin(), datetime(2008, 1, 1), True),
- (BMonthBegin(), datetime(2001, 4, 2), True),
- (BMonthBegin(), datetime(2008, 3, 3), True)]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = BMonthBegin()
- offset2 = BMonthBegin()
- self.assertFalse(offset1 != offset2)
- class TestBMonthEnd(Base):
- _offset = BMonthEnd
- def test_offset(self):
- tests = []
- tests.append((BMonthEnd(),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 2, 29),
- datetime(2006, 12, 29): datetime(2007, 1, 31),
- datetime(2006, 12, 31): datetime(2007, 1, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 31),
- datetime(2006, 12, 1): datetime(2006, 12, 29)}))
- tests.append((BMonthEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2006, 12, 29): datetime(2006, 12, 29),
- datetime(2006, 12, 31): datetime(2007, 1, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 31)}))
- tests.append((BMonthEnd(2),
- {datetime(2008, 1, 1): datetime(2008, 2, 29),
- datetime(2008, 1, 31): datetime(2008, 3, 31),
- datetime(2006, 12, 29): datetime(2007, 2, 28),
- datetime(2006, 12, 31): datetime(2007, 2, 28),
- datetime(2007, 1, 1): datetime(2007, 2, 28),
- datetime(2006, 11, 1): datetime(2006, 12, 29)}))
- tests.append((BMonthEnd(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 29),
- datetime(2008, 6, 30): datetime(2008, 5, 30),
- datetime(2008, 12, 31): datetime(2008, 11, 28),
- datetime(2006, 12, 29): datetime(2006, 11, 30),
- datetime(2006, 12, 30): datetime(2006, 12, 29),
- datetime(2007, 1, 1): datetime(2006, 12, 29)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_normalize(self):
- dt = datetime(2007, 1, 1, 3)
- result = dt + BMonthEnd(normalize=True)
- expected = dt.replace(hour=0) + BMonthEnd()
- self.assertEqual(result, expected)
- def test_onOffset(self):
- tests = [(BMonthEnd(), datetime(2007, 12, 31), True),
- (BMonthEnd(), datetime(2008, 1, 1), False)]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_offsets_compare_equal(self):
- # root cause of #456
- offset1 = BMonthEnd()
- offset2 = BMonthEnd()
- self.assertFalse(offset1 != offset2)
- class TestMonthBegin(Base):
- _offset = MonthBegin
- def test_offset(self):
- tests = []
- # NOTE: I'm not entirely happy with the logic here for Begin -ss
- # see thread 'offset conventions' on the ML
- tests.append((MonthBegin(),
- {datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2008, 2, 1): datetime(2008, 3, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2006, 12, 1): datetime(2007, 1, 1),
- datetime(2007, 1, 31): datetime(2007, 2, 1)}))
- tests.append((MonthBegin(0),
- {datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2006, 12, 3): datetime(2007, 1, 1),
- datetime(2007, 1, 31): datetime(2007, 2, 1)}))
- tests.append((MonthBegin(2),
- {datetime(2008, 2, 29): datetime(2008, 4, 1),
- datetime(2008, 1, 31): datetime(2008, 3, 1),
- datetime(2006, 12, 31): datetime(2007, 2, 1),
- datetime(2007, 12, 28): datetime(2008, 2, 1),
- datetime(2007, 1, 1): datetime(2007, 3, 1),
- datetime(2006, 11, 1): datetime(2007, 1, 1)}))
- tests.append((MonthBegin(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 1),
- datetime(2008, 5, 31): datetime(2008, 5, 1),
- datetime(2008, 12, 31): datetime(2008, 12, 1),
- datetime(2006, 12, 29): datetime(2006, 12, 1),
- datetime(2006, 1, 2): datetime(2006, 1, 1)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- class TestMonthEnd(Base):
- _offset = MonthEnd
- def test_offset(self):
- tests = []
- tests.append((MonthEnd(),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 2, 29),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2007, 1, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 31),
- datetime(2006, 12, 1): datetime(2006, 12, 31)}))
- tests.append((MonthEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2006, 12, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 31)}))
- tests.append((MonthEnd(2),
- {datetime(2008, 1, 1): datetime(2008, 2, 29),
- datetime(2008, 1, 31): datetime(2008, 3, 31),
- datetime(2006, 12, 29): datetime(2007, 1, 31),
- datetime(2006, 12, 31): datetime(2007, 2, 28),
- datetime(2007, 1, 1): datetime(2007, 2, 28),
- datetime(2006, 11, 1): datetime(2006, 12, 31)}))
- tests.append((MonthEnd(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 5, 31),
- datetime(2008, 12, 31): datetime(2008, 11, 30),
- datetime(2006, 12, 29): datetime(2006, 11, 30),
- datetime(2006, 12, 30): datetime(2006, 11, 30),
- datetime(2007, 1, 1): datetime(2006, 12, 31)}))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- # def test_day_of_month(self):
- # dt = datetime(2007, 1, 1)
- # offset = MonthEnd(day=20)
- # result = dt + offset
- # self.assertEqual(result, datetime(2007, 1, 20))
- # result = result + offset
- # self.assertEqual(result, datetime(2007, 2, 20))
- def test_normalize(self):
- dt = datetime(2007, 1, 1, 3)
- result = dt + MonthEnd(normalize=True)
- expected = dt.replace(hour=0) + MonthEnd()
- self.assertEqual(result, expected)
- def test_onOffset(self):
- tests = [(MonthEnd(), datetime(2007, 12, 31), True),
- (MonthEnd(), datetime(2008, 1, 1), False)]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestSemiMonthEnd(Base):
- _offset = SemiMonthEnd
- def _get_tests(self):
- tests = []
- tests.append((SemiMonthEnd(),
- {datetime(2008, 1, 1): datetime(2008, 1, 15),
- datetime(2008, 1, 15): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 2, 15),
- datetime(2006, 12, 14): datetime(2006, 12, 15),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2007, 1, 15),
- datetime(2007, 1, 1): datetime(2007, 1, 15),
- datetime(2006, 12, 1): datetime(2006, 12, 15),
- datetime(2006, 12, 15): datetime(2006, 12, 31)}))
- tests.append((SemiMonthEnd(day_of_month=20),
- {datetime(2008, 1, 1): datetime(2008, 1, 20),
- datetime(2008, 1, 15): datetime(2008, 1, 20),
- datetime(2008, 1, 21): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 2, 20),
- datetime(2006, 12, 14): datetime(2006, 12, 20),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2007, 1, 20),
- datetime(2007, 1, 1): datetime(2007, 1, 20),
- datetime(2006, 12, 1): datetime(2006, 12, 20),
- datetime(2006, 12, 15): datetime(2006, 12, 20)}))
- tests.append((SemiMonthEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 15),
- datetime(2008, 1, 16): datetime(2008, 1, 31),
- datetime(2008, 1, 15): datetime(2008, 1, 15),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2006, 12, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 15)}))
- tests.append((SemiMonthEnd(0, day_of_month=16),
- {datetime(2008, 1, 1): datetime(2008, 1, 16),
- datetime(2008, 1, 16): datetime(2008, 1, 16),
- datetime(2008, 1, 15): datetime(2008, 1, 16),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2006, 12, 29): datetime(2006, 12, 31),
- datetime(2006, 12, 31): datetime(2006, 12, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 16)}))
- tests.append((SemiMonthEnd(2),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 2, 29),
- datetime(2006, 12, 29): datetime(2007, 1, 15),
- datetime(2006, 12, 31): datetime(2007, 1, 31),
- datetime(2007, 1, 1): datetime(2007, 1, 31),
- datetime(2007, 1, 16): datetime(2007, 2, 15),
- datetime(2006, 11, 1): datetime(2006, 11, 30)}))
- tests.append((SemiMonthEnd(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 6, 15),
- datetime(2008, 12, 31): datetime(2008, 12, 15),
- datetime(2006, 12, 29): datetime(2006, 12, 15),
- datetime(2006, 12, 30): datetime(2006, 12, 15),
- datetime(2007, 1, 1): datetime(2006, 12, 31)}))
- tests.append((SemiMonthEnd(-1, day_of_month=4),
- {datetime(2007, 1, 1): datetime(2006, 12, 31),
- datetime(2007, 1, 4): datetime(2006, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 6, 4),
- datetime(2008, 12, 31): datetime(2008, 12, 4),
- datetime(2006, 12, 5): datetime(2006, 12, 4),
- datetime(2006, 12, 30): datetime(2006, 12, 4),
- datetime(2007, 1, 1): datetime(2006, 12, 31)}))
- tests.append((SemiMonthEnd(-2),
- {datetime(2007, 1, 1): datetime(2006, 12, 15),
- datetime(2008, 6, 30): datetime(2008, 5, 31),
- datetime(2008, 3, 15): datetime(2008, 2, 15),
- datetime(2008, 12, 31): datetime(2008, 11, 30),
- datetime(2006, 12, 29): datetime(2006, 11, 30),
- datetime(2006, 12, 14): datetime(2006, 11, 15),
- datetime(2007, 1, 1): datetime(2006, 12, 15)}))
- return tests
- def test_offset_whole_year(self):
- dates = (datetime(2007, 12, 31),
- datetime(2008, 1, 15),
- datetime(2008, 1, 31),
- datetime(2008, 2, 15),
- datetime(2008, 2, 29),
- datetime(2008, 3, 15),
- datetime(2008, 3, 31),
- datetime(2008, 4, 15),
- datetime(2008, 4, 30),
- datetime(2008, 5, 15),
- datetime(2008, 5, 31),
- datetime(2008, 6, 15),
- datetime(2008, 6, 30),
- datetime(2008, 7, 15),
- datetime(2008, 7, 31),
- datetime(2008, 8, 15),
- datetime(2008, 8, 31),
- datetime(2008, 9, 15),
- datetime(2008, 9, 30),
- datetime(2008, 10, 15),
- datetime(2008, 10, 31),
- datetime(2008, 11, 15),
- datetime(2008, 11, 30),
- datetime(2008, 12, 15),
- datetime(2008, 12, 31))
- for base, exp_date in zip(dates[:-1], dates[1:]):
- assertEq(SemiMonthEnd(), base, exp_date)
- # ensure .apply_index works as expected
- s = DatetimeIndex(dates[:-1])
- result = SemiMonthEnd().apply_index(s)
- exp = DatetimeIndex(dates[1:])
- tm.assert_index_equal(result, exp)
- # ensure generating a range with DatetimeIndex gives same result
- result = DatetimeIndex(start=dates[0], end=dates[-1], freq='SM')
- exp = DatetimeIndex(dates)
- tm.assert_index_equal(result, exp)
- def test_offset(self):
- for offset, cases in self._get_tests():
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_index(self):
- for offset, cases in self._get_tests():
- s = DatetimeIndex(cases.keys())
- result = offset.apply_index(s)
- exp = DatetimeIndex(cases.values())
- tm.assert_index_equal(result, exp)
- def test_onOffset(self):
- tests = [(datetime(2007, 12, 31), True),
- (datetime(2007, 12, 15), True),
- (datetime(2007, 12, 14), False),
- (datetime(2007, 12, 1), False),
- (datetime(2008, 2, 29), True)]
- for dt, expected in tests:
- assertOnOffset(SemiMonthEnd(), dt, expected)
- def test_vectorized_offset_addition(self):
- for klass, assert_func in zip([Series, DatetimeIndex],
- [self.assert_series_equal,
- tm.assert_index_equal]):
- s = klass([Timestamp('2000-01-15 00:15:00', tz='US/Central'),
- Timestamp('2000-02-15', tz='US/Central')], name='a')
- result = s + SemiMonthEnd()
- result2 = SemiMonthEnd() + s
- exp = klass([Timestamp('2000-01-31 00:15:00', tz='US/Central'),
- Timestamp('2000-02-29', tz='US/Central')], name='a')
- assert_func(result, exp)
- assert_func(result2, exp)
- s = klass([Timestamp('2000-01-01 00:15:00', tz='US/Central'),
- Timestamp('2000-02-01', tz='US/Central')], name='a')
- result = s + SemiMonthEnd()
- result2 = SemiMonthEnd() + s
- exp = klass([Timestamp('2000-01-15 00:15:00', tz='US/Central'),
- Timestamp('2000-02-15', tz='US/Central')], name='a')
- assert_func(result, exp)
- assert_func(result2, exp)
- class TestSemiMonthBegin(Base):
- _offset = SemiMonthBegin
- def _get_tests(self):
- tests = []
- tests.append((SemiMonthBegin(),
- {datetime(2008, 1, 1): datetime(2008, 1, 15),
- datetime(2008, 1, 15): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 14): datetime(2006, 12, 15),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2007, 1, 1): datetime(2007, 1, 15),
- datetime(2006, 12, 1): datetime(2006, 12, 15),
- datetime(2006, 12, 15): datetime(2007, 1, 1)}))
- tests.append((SemiMonthBegin(day_of_month=20),
- {datetime(2008, 1, 1): datetime(2008, 1, 20),
- datetime(2008, 1, 15): datetime(2008, 1, 20),
- datetime(2008, 1, 21): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 14): datetime(2006, 12, 20),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2007, 1, 1): datetime(2007, 1, 20),
- datetime(2006, 12, 1): datetime(2006, 12, 20),
- datetime(2006, 12, 15): datetime(2006, 12, 20)}))
- tests.append((SemiMonthBegin(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 16): datetime(2008, 2, 1),
- datetime(2008, 1, 15): datetime(2008, 1, 15),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 2): datetime(2006, 12, 15),
- datetime(2007, 1, 1): datetime(2007, 1, 1)}))
- tests.append((SemiMonthBegin(0, day_of_month=16),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 16): datetime(2008, 1, 16),
- datetime(2008, 1, 15): datetime(2008, 1, 16),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2006, 12, 29): datetime(2007, 1, 1),
- datetime(2006, 12, 31): datetime(2007, 1, 1),
- datetime(2007, 1, 5): datetime(2007, 1, 16),
- datetime(2007, 1, 1): datetime(2007, 1, 1)}))
- tests.append((SemiMonthBegin(2),
- {datetime(2008, 1, 1): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 15),
- datetime(2006, 12, 1): datetime(2007, 1, 1),
- datetime(2006, 12, 29): datetime(2007, 1, 15),
- datetime(2006, 12, 15): datetime(2007, 1, 15),
- datetime(2007, 1, 1): datetime(2007, 2, 1),
- datetime(2007, 1, 16): datetime(2007, 2, 15),
- datetime(2006, 11, 1): datetime(2006, 12, 1)}))
- tests.append((SemiMonthBegin(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 15),
- datetime(2008, 6, 30): datetime(2008, 6, 15),
- datetime(2008, 6, 14): datetime(2008, 6, 1),
- datetime(2008, 12, 31): datetime(2008, 12, 15),
- datetime(2006, 12, 29): datetime(2006, 12, 15),
- datetime(2006, 12, 15): datetime(2006, 12, 1),
- datetime(2007, 1, 1): datetime(2006, 12, 15)}))
- tests.append((SemiMonthBegin(-1, day_of_month=4),
- {datetime(2007, 1, 1): datetime(2006, 12, 4),
- datetime(2007, 1, 4): datetime(2007, 1, 1),
- datetime(2008, 6, 30): datetime(2008, 6, 4),
- datetime(2008, 12, 31): datetime(2008, 12, 4),
- datetime(2006, 12, 5): datetime(2006, 12, 4),
- datetime(2006, 12, 30): datetime(2006, 12, 4),
- datetime(2006, 12, 2): datetime(2006, 12, 1),
- datetime(2007, 1, 1): datetime(2006, 12, 4)}))
- tests.append((SemiMonthBegin(-2),
- {datetime(2007, 1, 1): datetime(2006, 12, 1),
- datetime(2008, 6, 30): datetime(2008, 6, 1),
- datetime(2008, 6, 14): datetime(2008, 5, 15),
- datetime(2008, 12, 31): datetime(2008, 12, 1),
- datetime(2006, 12, 29): datetime(2006, 12, 1),
- datetime(2006, 12, 15): datetime(2006, 11, 15),
- datetime(2007, 1, 1): datetime(2006, 12, 1)}))
- return tests
- def test_offset_whole_year(self):
- dates = (datetime(2007, 12, 15),
- datetime(2008, 1, 1),
- datetime(2008, 1, 15),
- datetime(2008, 2, 1),
- datetime(2008, 2, 15),
- datetime(2008, 3, 1),
- datetime(2008, 3, 15),
- datetime(2008, 4, 1),
- datetime(2008, 4, 15),
- datetime(2008, 5, 1),
- datetime(2008, 5, 15),
- datetime(2008, 6, 1),
- datetime(2008, 6, 15),
- datetime(2008, 7, 1),
- datetime(2008, 7, 15),
- datetime(2008, 8, 1),
- datetime(2008, 8, 15),
- datetime(2008, 9, 1),
- datetime(2008, 9, 15),
- datetime(2008, 10, 1),
- datetime(2008, 10, 15),
- datetime(2008, 11, 1),
- datetime(2008, 11, 15),
- datetime(2008, 12, 1),
- datetime(2008, 12, 15))
- for base, exp_date in zip(dates[:-1], dates[1:]):
- assertEq(SemiMonthBegin(), base, exp_date)
- # ensure .apply_index works as expected
- s = DatetimeIndex(dates[:-1])
- result = SemiMonthBegin().apply_index(s)
- exp = DatetimeIndex(dates[1:])
- tm.assert_index_equal(result, exp)
- # ensure generating a range with DatetimeIndex gives same result
- result = DatetimeIndex(start=dates[0], end=dates[-1], freq='SMS')
- exp = DatetimeIndex(dates)
- tm.assert_index_equal(result, exp)
- def test_offset(self):
- for offset, cases in self._get_tests():
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_apply_index(self):
- for offset, cases in self._get_tests():
- s = DatetimeIndex(cases.keys())
- result = offset.apply_index(s)
- exp = DatetimeIndex(cases.values())
- tm.assert_index_equal(result, exp)
- def test_onOffset(self):
- tests = [(datetime(2007, 12, 1), True),
- (datetime(2007, 12, 15), True),
- (datetime(2007, 12, 14), False),
- (datetime(2007, 12, 31), False),
- (datetime(2008, 2, 15), True)]
- for dt, expected in tests:
- assertOnOffset(SemiMonthBegin(), dt, expected)
- def test_vectorized_offset_addition(self):
- for klass, assert_func in zip([Series, DatetimeIndex],
- [self.assert_series_equal,
- tm.assert_index_equal]):
- s = klass([Timestamp('2000-01-15 00:15:00', tz='US/Central'),
- Timestamp('2000-02-15', tz='US/Central')], name='a')
- result = s + SemiMonthBegin()
- result2 = SemiMonthBegin() + s
- exp = klass([Timestamp('2000-02-01 00:15:00', tz='US/Central'),
- Timestamp('2000-03-01', tz='US/Central')], name='a')
- assert_func(result, exp)
- assert_func(result2, exp)
- s = klass([Timestamp('2000-01-01 00:15:00', tz='US/Central'),
- Timestamp('2000-02-01', tz='US/Central')], name='a')
- result = s + SemiMonthBegin()
- result2 = SemiMonthBegin() + s
- exp = klass([Timestamp('2000-01-15 00:15:00', tz='US/Central'),
- Timestamp('2000-02-15', tz='US/Central')], name='a')
- assert_func(result, exp)
- assert_func(result2, exp)
- class TestBQuarterBegin(Base):
- _offset = BQuarterBegin
- def test_repr(self):
- self.assertEqual(repr(BQuarterBegin()),
- "<BusinessQuarterBegin: startingMonth=3>")
- self.assertEqual(repr(BQuarterBegin(startingMonth=3)),
- "<BusinessQuarterBegin: startingMonth=3>")
- self.assertEqual(repr(BQuarterBegin(startingMonth=1)),
- "<BusinessQuarterBegin: startingMonth=1>")
- def test_isAnchored(self):
- self.assertTrue(BQuarterBegin(startingMonth=1).isAnchored())
- self.assertTrue(BQuarterBegin().isAnchored())
- self.assertFalse(BQuarterBegin(2, startingMonth=1).isAnchored())
- def test_offset(self):
- tests = []
- tests.append((BQuarterBegin(startingMonth=1),
- {datetime(2008, 1, 1): datetime(2008, 4, 1),
- datetime(2008, 1, 31): datetime(2008, 4, 1),
- datetime(2008, 2, 15): datetime(2008, 4, 1),
- datetime(2008, 2, 29): datetime(2008, 4, 1),
- datetime(2008, 3, 15): datetime(2008, 4, 1),
- datetime(2008, 3, 31): datetime(2008, 4, 1),
- datetime(2008, 4, 15): datetime(2008, 7, 1),
- datetime(2007, 3, 15): datetime(2007, 4, 2),
- datetime(2007, 2, 28): datetime(2007, 4, 2),
- datetime(2007, 1, 1): datetime(2007, 4, 2),
- datetime(2007, 4, 15): datetime(2007, 7, 2),
- datetime(2007, 7, 1): datetime(2007, 7, 2),
- datetime(2007, 4, 1): datetime(2007, 4, 2),
- datetime(2007, 4, 2): datetime(2007, 7, 2),
- datetime(2008, 4, 30): datetime(2008, 7, 1), }))
- tests.append((BQuarterBegin(startingMonth=2),
- {datetime(2008, 1, 1): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2008, 1, 15): datetime(2008, 2, 1),
- datetime(2008, 2, 29): datetime(2008, 5, 1),
- datetime(2008, 3, 15): datetime(2008, 5, 1),
- datetime(2008, 3, 31): datetime(2008, 5, 1),
- datetime(2008, 4, 15): datetime(2008, 5, 1),
- datetime(2008, 8, 15): datetime(2008, 11, 3),
- datetime(2008, 9, 15): datetime(2008, 11, 3),
- datetime(2008, 11, 1): datetime(2008, 11, 3),
- datetime(2008, 4, 30): datetime(2008, 5, 1), }))
- tests.append((BQuarterBegin(startingMonth=1, n=0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2007, 12, 31): datetime(2008, 1, 1),
- datetime(2008, 2, 15): datetime(2008, 4, 1),
- datetime(2008, 2, 29): datetime(2008, 4, 1),
- datetime(2008, 1, 15): datetime(2008, 4, 1),
- datetime(2008, 2, 27): datetime(2008, 4, 1),
- datetime(2008, 3, 15): datetime(2008, 4, 1),
- datetime(2007, 4, 1): datetime(2007, 4, 2),
- datetime(2007, 4, 2): datetime(2007, 4, 2),
- datetime(2007, 7, 1): datetime(2007, 7, 2),
- datetime(2007, 4, 15): datetime(2007, 7, 2),
- datetime(2007, 7, 2): datetime(2007, 7, 2), }))
- tests.append((BQuarterBegin(startingMonth=1, n=-1),
- {datetime(2008, 1, 1): datetime(2007, 10, 1),
- datetime(2008, 1, 31): datetime(2008, 1, 1),
- datetime(2008, 2, 15): datetime(2008, 1, 1),
- datetime(2008, 2, 29): datetime(2008, 1, 1),
- datetime(2008, 3, 15): datetime(2008, 1, 1),
- datetime(2008, 3, 31): datetime(2008, 1, 1),
- datetime(2008, 4, 15): datetime(2008, 4, 1),
- datetime(2007, 7, 3): datetime(2007, 7, 2),
- datetime(2007, 4, 3): datetime(2007, 4, 2),
- datetime(2007, 7, 2): datetime(2007, 4, 2),
- datetime(2008, 4, 1): datetime(2008, 1, 1), }))
- tests.append((BQuarterBegin(startingMonth=1, n=2),
- {datetime(2008, 1, 1): datetime(2008, 7, 1),
- datetime(2008, 1, 15): datetime(2008, 7, 1),
- datetime(2008, 2, 29): datetime(2008, 7, 1),
- datetime(2008, 3, 15): datetime(2008, 7, 1),
- datetime(2007, 3, 31): datetime(2007, 7, 2),
- datetime(2007, 4, 15): datetime(2007, 10, 1),
- datetime(2008, 4, 30): datetime(2008, 10, 1), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- # corner
- offset = BQuarterBegin(n=-1, startingMonth=1)
- self.assertEqual(datetime(2007, 4, 3) + offset, datetime(2007, 4, 2))
- class TestBQuarterEnd(Base):
- _offset = BQuarterEnd
- def test_repr(self):
- self.assertEqual(repr(BQuarterEnd()),
- "<BusinessQuarterEnd: startingMonth=3>")
- self.assertEqual(repr(BQuarterEnd(startingMonth=3)),
- "<BusinessQuarterEnd: startingMonth=3>")
- self.assertEqual(repr(BQuarterEnd(startingMonth=1)),
- "<BusinessQuarterEnd: startingMonth=1>")
- def test_isAnchored(self):
- self.assertTrue(BQuarterEnd(startingMonth=1).isAnchored())
- self.assertTrue(BQuarterEnd().isAnchored())
- self.assertFalse(BQuarterEnd(2, startingMonth=1).isAnchored())
- def test_offset(self):
- tests = []
- tests.append((BQuarterEnd(startingMonth=1),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 4, 30),
- datetime(2008, 2, 15): datetime(2008, 4, 30),
- datetime(2008, 2, 29): datetime(2008, 4, 30),
- datetime(2008, 3, 15): datetime(2008, 4, 30),
- datetime(2008, 3, 31): datetime(2008, 4, 30),
- datetime(2008, 4, 15): datetime(2008, 4, 30),
- datetime(2008, 4, 30): datetime(2008, 7, 31), }))
- tests.append((BQuarterEnd(startingMonth=2),
- {datetime(2008, 1, 1): datetime(2008, 2, 29),
- datetime(2008, 1, 31): datetime(2008, 2, 29),
- datetime(2008, 2, 15): datetime(2008, 2, 29),
- datetime(2008, 2, 29): datetime(2008, 5, 30),
- datetime(2008, 3, 15): datetime(2008, 5, 30),
- datetime(2008, 3, 31): datetime(2008, 5, 30),
- datetime(2008, 4, 15): datetime(2008, 5, 30),
- datetime(2008, 4, 30): datetime(2008, 5, 30), }))
- tests.append((BQuarterEnd(startingMonth=1, n=0),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2008, 2, 15): datetime(2008, 4, 30),
- datetime(2008, 2, 29): datetime(2008, 4, 30),
- datetime(2008, 3, 15): datetime(2008, 4, 30),
- datetime(2008, 3, 31): datetime(2008, 4, 30),
- datetime(2008, 4, 15): datetime(2008, 4, 30),
- datetime(2008, 4, 30): datetime(2008, 4, 30), }))
- tests.append((BQuarterEnd(startingMonth=1, n=-1),
- {datetime(2008, 1, 1): datetime(2007, 10, 31),
- datetime(2008, 1, 31): datetime(2007, 10, 31),
- datetime(2008, 2, 15): datetime(2008, 1, 31),
- datetime(2008, 2, 29): datetime(2008, 1, 31),
- datetime(2008, 3, 15): datetime(2008, 1, 31),
- datetime(2008, 3, 31): datetime(2008, 1, 31),
- datetime(2008, 4, 15): datetime(2008, 1, 31),
- datetime(2008, 4, 30): datetime(2008, 1, 31), }))
- tests.append((BQuarterEnd(startingMonth=1, n=2),
- {datetime(2008, 1, 31): datetime(2008, 7, 31),
- datetime(2008, 2, 15): datetime(2008, 7, 31),
- datetime(2008, 2, 29): datetime(2008, 7, 31),
- datetime(2008, 3, 15): datetime(2008, 7, 31),
- datetime(2008, 3, 31): datetime(2008, 7, 31),
- datetime(2008, 4, 15): datetime(2008, 7, 31),
- datetime(2008, 4, 30): datetime(2008, 10, 31), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- # corner
- offset = BQuarterEnd(n=-1, startingMonth=1)
- self.assertEqual(datetime(2010, 1, 31) + offset, datetime(2010, 1, 29))
- def test_onOffset(self):
- tests = [
- (BQuarterEnd(1, startingMonth=1), datetime(2008, 1, 31), True),
- (BQuarterEnd(1, startingMonth=1), datetime(2007, 12, 31), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2008, 2, 29), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2007, 3, 30), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2007, 3, 31), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2008, 4, 30), True),
- (BQuarterEnd(1, startingMonth=1), datetime(2008, 5, 30), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2007, 6, 29), False),
- (BQuarterEnd(1, startingMonth=1), datetime(2007, 6, 30), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2008, 1, 31), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2007, 12, 31), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2008, 2, 29), True),
- (BQuarterEnd(1, startingMonth=2), datetime(2007, 3, 30), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2007, 3, 31), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2008, 4, 30), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2008, 5, 30), True),
- (BQuarterEnd(1, startingMonth=2), datetime(2007, 6, 29), False),
- (BQuarterEnd(1, startingMonth=2), datetime(2007, 6, 30), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2008, 1, 31), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2007, 12, 31), True),
- (BQuarterEnd(1, startingMonth=3), datetime(2008, 2, 29), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2007, 3, 30), True),
- (BQuarterEnd(1, startingMonth=3), datetime(2007, 3, 31), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2008, 4, 30), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2008, 5, 30), False),
- (BQuarterEnd(1, startingMonth=3), datetime(2007, 6, 29), True),
- (BQuarterEnd(1, startingMonth=3), datetime(2007, 6, 30), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def makeFY5253LastOfMonthQuarter(*args, **kwds):
- return FY5253Quarter(*args, variation="last", **kwds)
- def makeFY5253NearestEndMonthQuarter(*args, **kwds):
- return FY5253Quarter(*args, variation="nearest", **kwds)
- def makeFY5253NearestEndMonth(*args, **kwds):
- return FY5253(*args, variation="nearest", **kwds)
- def makeFY5253LastOfMonth(*args, **kwds):
- return FY5253(*args, variation="last", **kwds)
- class TestFY5253LastOfMonth(Base):
- def test_onOffset(self):
- offset_lom_sat_aug = makeFY5253LastOfMonth(1, startingMonth=8,
- weekday=WeekDay.SAT)
- offset_lom_sat_sep = makeFY5253LastOfMonth(1, startingMonth=9,
- weekday=WeekDay.SAT)
- tests = [
- # From Wikipedia (see:
- # http://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar#Last_Saturday_of_the_month_at_fiscal_year_end)
- (offset_lom_sat_aug, datetime(2006, 8, 26), True),
- (offset_lom_sat_aug, datetime(2007, 8, 25), True),
- (offset_lom_sat_aug, datetime(2008, 8, 30), True),
- (offset_lom_sat_aug, datetime(2009, 8, 29), True),
- (offset_lom_sat_aug, datetime(2010, 8, 28), True),
- (offset_lom_sat_aug, datetime(2011, 8, 27), True),
- (offset_lom_sat_aug, datetime(2012, 8, 25), True),
- (offset_lom_sat_aug, datetime(2013, 8, 31), True),
- (offset_lom_sat_aug, datetime(2014, 8, 30), True),
- (offset_lom_sat_aug, datetime(2015, 8, 29), True),
- (offset_lom_sat_aug, datetime(2016, 8, 27), True),
- (offset_lom_sat_aug, datetime(2017, 8, 26), True),
- (offset_lom_sat_aug, datetime(2018, 8, 25), True),
- (offset_lom_sat_aug, datetime(2019, 8, 31), True),
- (offset_lom_sat_aug, datetime(2006, 8, 27), False),
- (offset_lom_sat_aug, datetime(2007, 8, 28), False),
- (offset_lom_sat_aug, datetime(2008, 8, 31), False),
- (offset_lom_sat_aug, datetime(2009, 8, 30), False),
- (offset_lom_sat_aug, datetime(2010, 8, 29), False),
- (offset_lom_sat_aug, datetime(2011, 8, 28), False),
- (offset_lom_sat_aug, datetime(2006, 8, 25), False),
- (offset_lom_sat_aug, datetime(2007, 8, 24), False),
- (offset_lom_sat_aug, datetime(2008, 8, 29), False),
- (offset_lom_sat_aug, datetime(2009, 8, 28), False),
- (offset_lom_sat_aug, datetime(2010, 8, 27), False),
- (offset_lom_sat_aug, datetime(2011, 8, 26), False),
- (offset_lom_sat_aug, datetime(2019, 8, 30), False),
- # From GMCR (see for example:
- # http://yahoo.brand.edgar-online.com/Default.aspx?
- # companyid=3184&formtypeID=7)
- (offset_lom_sat_sep, datetime(2010, 9, 25), True),
- (offset_lom_sat_sep, datetime(2011, 9, 24), True),
- (offset_lom_sat_sep, datetime(2012, 9, 29), True),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_apply(self):
- offset_lom_aug_sat = makeFY5253LastOfMonth(startingMonth=8,
- weekday=WeekDay.SAT)
- offset_lom_aug_sat_1 = makeFY5253LastOfMonth(n=1, startingMonth=8,
- weekday=WeekDay.SAT)
- date_seq_lom_aug_sat = [datetime(2006, 8, 26), datetime(2007, 8, 25),
- datetime(2008, 8, 30), datetime(2009, 8, 29),
- datetime(2010, 8, 28), datetime(2011, 8, 27),
- datetime(2012, 8, 25), datetime(2013, 8, 31),
- datetime(2014, 8, 30), datetime(2015, 8, 29),
- datetime(2016, 8, 27)]
- tests = [
- (offset_lom_aug_sat, date_seq_lom_aug_sat),
- (offset_lom_aug_sat_1, date_seq_lom_aug_sat),
- (offset_lom_aug_sat, [
- datetime(2006, 8, 25)] + date_seq_lom_aug_sat),
- (offset_lom_aug_sat_1, [
- datetime(2006, 8, 27)] + date_seq_lom_aug_sat[1:]),
- (makeFY5253LastOfMonth(n=-1, startingMonth=8,
- weekday=WeekDay.SAT),
- list(reversed(date_seq_lom_aug_sat))),
- ]
- for test in tests:
- offset, data = test
- current = data[0]
- for datum in data[1:]:
- current = current + offset
- self.assertEqual(current, datum)
- class TestFY5253NearestEndMonth(Base):
- def test_get_target_month_end(self):
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=8,
- weekday=WeekDay.SAT)
- .get_target_month_end(
- datetime(2013, 1, 1)), datetime(2013, 8, 31))
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=12,
- weekday=WeekDay.SAT)
- .get_target_month_end(datetime(2013, 1, 1)),
- datetime(2013, 12, 31))
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=2,
- weekday=WeekDay.SAT)
- .get_target_month_end(datetime(2013, 1, 1)),
- datetime(2013, 2, 28))
- def test_get_year_end(self):
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=8,
- weekday=WeekDay.SAT)
- .get_year_end(datetime(2013, 1, 1)),
- datetime(2013, 8, 31))
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=8,
- weekday=WeekDay.SUN)
- .get_year_end(datetime(2013, 1, 1)),
- datetime(2013, 9, 1))
- self.assertEqual(makeFY5253NearestEndMonth(startingMonth=8,
- weekday=WeekDay.FRI)
- .get_year_end(datetime(2013, 1, 1)),
- datetime(2013, 8, 30))
- offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12,
- variation="nearest")
- self.assertEqual(offset_n.get_year_end(
- datetime(2012, 1, 1)), datetime(2013, 1, 1))
- self.assertEqual(offset_n.get_year_end(
- datetime(2012, 1, 10)), datetime(2013, 1, 1))
- self.assertEqual(offset_n.get_year_end(
- datetime(2013, 1, 1)), datetime(2013, 12, 31))
- self.assertEqual(offset_n.get_year_end(
- datetime(2013, 1, 2)), datetime(2013, 12, 31))
- self.assertEqual(offset_n.get_year_end(
- datetime(2013, 1, 3)), datetime(2013, 12, 31))
- self.assertEqual(offset_n.get_year_end(
- datetime(2013, 1, 10)), datetime(2013, 12, 31))
- JNJ = FY5253(n=1, startingMonth=12, weekday=6, variation="nearest")
- self.assertEqual(JNJ.get_year_end(
- datetime(2006, 1, 1)), datetime(2006, 12, 31))
- def test_onOffset(self):
- offset_lom_aug_sat = makeFY5253NearestEndMonth(1, startingMonth=8,
- weekday=WeekDay.SAT)
- offset_lom_aug_thu = makeFY5253NearestEndMonth(1, startingMonth=8,
- weekday=WeekDay.THU)
- offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12,
- variation="nearest")
- tests = [
- # From Wikipedia (see:
- # http://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar
- # #Saturday_nearest_the_end_of_month)
- # 2006-09-02 2006 September 2
- # 2007-09-01 2007 September 1
- # 2008-08-30 2008 August 30 (leap year)
- # 2009-08-29 2009 August 29
- # 2010-08-28 2010 August 28
- # 2011-09-03 2011 September 3
- # 2012-09-01 2012 September 1 (leap year)
- # 2013-08-31 2013 August 31
- # 2014-08-30 2014 August 30
- # 2015-08-29 2015 August 29
- # 2016-09-03 2016 September 3 (leap year)
- # 2017-09-02 2017 September 2
- # 2018-09-01 2018 September 1
- # 2019-08-31 2019 August 31
- (offset_lom_aug_sat, datetime(2006, 9, 2), True),
- (offset_lom_aug_sat, datetime(2007, 9, 1), True),
- (offset_lom_aug_sat, datetime(2008, 8, 30), True),
- (offset_lom_aug_sat, datetime(2009, 8, 29), True),
- (offset_lom_aug_sat, datetime(2010, 8, 28), True),
- (offset_lom_aug_sat, datetime(2011, 9, 3), True),
- (offset_lom_aug_sat, datetime(2016, 9, 3), True),
- (offset_lom_aug_sat, datetime(2017, 9, 2), True),
- (offset_lom_aug_sat, datetime(2018, 9, 1), True),
- (offset_lom_aug_sat, datetime(2019, 8, 31), True),
- (offset_lom_aug_sat, datetime(2006, 8, 27), False),
- (offset_lom_aug_sat, datetime(2007, 8, 28), False),
- (offset_lom_aug_sat, datetime(2008, 8, 31), False),
- (offset_lom_aug_sat, datetime(2009, 8, 30), False),
- (offset_lom_aug_sat, datetime(2010, 8, 29), False),
- (offset_lom_aug_sat, datetime(2011, 8, 28), False),
- (offset_lom_aug_sat, datetime(2006, 8, 25), False),
- (offset_lom_aug_sat, datetime(2007, 8, 24), False),
- (offset_lom_aug_sat, datetime(2008, 8, 29), False),
- (offset_lom_aug_sat, datetime(2009, 8, 28), False),
- (offset_lom_aug_sat, datetime(2010, 8, 27), False),
- (offset_lom_aug_sat, datetime(2011, 8, 26), False),
- (offset_lom_aug_sat, datetime(2019, 8, 30), False),
- # From Micron, see:
- # http://google.brand.edgar-online.com/?sym=MU&formtypeID=7
- (offset_lom_aug_thu, datetime(2012, 8, 30), True),
- (offset_lom_aug_thu, datetime(2011, 9, 1), True),
- (offset_n, datetime(2012, 12, 31), False),
- (offset_n, datetime(2013, 1, 1), True),
- (offset_n, datetime(2013, 1, 2), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_apply(self):
- date_seq_nem_8_sat = [datetime(2006, 9, 2), datetime(2007, 9, 1),
- datetime(2008, 8, 30), datetime(2009, 8, 29),
- datetime(2010, 8, 28), datetime(2011, 9, 3)]
- JNJ = [datetime(2005, 1, 2), datetime(2006, 1, 1),
- datetime(2006, 12, 31), datetime(2007, 12, 30),
- datetime(2008, 12, 28), datetime(2010, 1, 3),
- datetime(2011, 1, 2), datetime(2012, 1, 1),
- datetime(2012, 12, 30)]
- DEC_SAT = FY5253(n=-1, startingMonth=12, weekday=5,
- variation="nearest")
- tests = [
- (makeFY5253NearestEndMonth(startingMonth=8,
- weekday=WeekDay.SAT),
- date_seq_nem_8_sat),
- (makeFY5253NearestEndMonth(n=1, startingMonth=8,
- weekday=WeekDay.SAT),
- date_seq_nem_8_sat),
- (makeFY5253NearestEndMonth(startingMonth=8, weekday=WeekDay.SAT),
- [datetime(2006, 9, 1)] + date_seq_nem_8_sat),
- (makeFY5253NearestEndMonth(n=1, startingMonth=8,
- weekday=WeekDay.SAT),
- [datetime(2006, 9, 3)] + date_seq_nem_8_sat[1:]),
- (makeFY5253NearestEndMonth(n=-1, startingMonth=8,
- weekday=WeekDay.SAT),
- list(reversed(date_seq_nem_8_sat))),
- (makeFY5253NearestEndMonth(n=1, startingMonth=12,
- weekday=WeekDay.SUN), JNJ),
- (makeFY5253NearestEndMonth(n=-1, startingMonth=12,
- weekday=WeekDay.SUN),
- list(reversed(JNJ))),
- (makeFY5253NearestEndMonth(n=1, startingMonth=12,
- weekday=WeekDay.SUN),
- [datetime(2005, 1, 2), datetime(2006, 1, 1)]),
- (makeFY5253NearestEndMonth(n=1, startingMonth=12,
- weekday=WeekDay.SUN),
- [datetime(2006, 1, 2), datetime(2006, 12, 31)]),
- (DEC_SAT, [datetime(2013, 1, 15), datetime(2012, 12, 29)])
- ]
- for test in tests:
- offset, data = test
- current = data[0]
- for datum in data[1:]:
- current = current + offset
- self.assertEqual(current, datum)
- class TestFY5253LastOfMonthQuarter(Base):
- def test_isAnchored(self):
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(startingMonth=1, weekday=WeekDay.SAT,
- qtr_with_extra_week=4).isAnchored())
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(weekday=WeekDay.SAT, startingMonth=3,
- qtr_with_extra_week=4).isAnchored())
- self.assertFalse(makeFY5253LastOfMonthQuarter(
- 2, startingMonth=1, weekday=WeekDay.SAT,
- qtr_with_extra_week=4).isAnchored())
- def test_equality(self):
- self.assertEqual(makeFY5253LastOfMonthQuarter(startingMonth=1,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4),
- makeFY5253LastOfMonthQuarter(startingMonth=1,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4))
- self.assertNotEqual(
- makeFY5253LastOfMonthQuarter(
- startingMonth=1, weekday=WeekDay.SAT,
- qtr_with_extra_week=4),
- makeFY5253LastOfMonthQuarter(
- startingMonth=1, weekday=WeekDay.SUN,
- qtr_with_extra_week=4))
- self.assertNotEqual(
- makeFY5253LastOfMonthQuarter(
- startingMonth=1, weekday=WeekDay.SAT,
- qtr_with_extra_week=4),
- makeFY5253LastOfMonthQuarter(
- startingMonth=2, weekday=WeekDay.SAT,
- qtr_with_extra_week=4))
- def test_offset(self):
- offset = makeFY5253LastOfMonthQuarter(1, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- offset2 = makeFY5253LastOfMonthQuarter(2, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- offset4 = makeFY5253LastOfMonthQuarter(4, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- offset_neg1 = makeFY5253LastOfMonthQuarter(-1, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- offset_neg2 = makeFY5253LastOfMonthQuarter(-2, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- GMCR = [datetime(2010, 3, 27), datetime(2010, 6, 26),
- datetime(2010, 9, 25), datetime(2010, 12, 25),
- datetime(2011, 3, 26), datetime(2011, 6, 25),
- datetime(2011, 9, 24), datetime(2011, 12, 24),
- datetime(2012, 3, 24), datetime(2012, 6, 23),
- datetime(2012, 9, 29), datetime(2012, 12, 29),
- datetime(2013, 3, 30), datetime(2013, 6, 29)]
- assertEq(offset, base=GMCR[0], expected=GMCR[1])
- assertEq(offset, base=GMCR[0] + relativedelta(days=-1),
- expected=GMCR[0])
- assertEq(offset, base=GMCR[1], expected=GMCR[2])
- assertEq(offset2, base=GMCR[0], expected=GMCR[2])
- assertEq(offset4, base=GMCR[0], expected=GMCR[4])
- assertEq(offset_neg1, base=GMCR[-1], expected=GMCR[-2])
- assertEq(offset_neg1, base=GMCR[-1] + relativedelta(days=+1),
- expected=GMCR[-1])
- assertEq(offset_neg2, base=GMCR[-1], expected=GMCR[-3])
- date = GMCR[0] + relativedelta(days=-1)
- for expected in GMCR:
- assertEq(offset, date, expected)
- date = date + offset
- date = GMCR[-1] + relativedelta(days=+1)
- for expected in reversed(GMCR):
- assertEq(offset_neg1, date, expected)
- date = date + offset_neg1
- def test_onOffset(self):
- lomq_aug_sat_4 = makeFY5253LastOfMonthQuarter(1, startingMonth=8,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- lomq_sep_sat_4 = makeFY5253LastOfMonthQuarter(1, startingMonth=9,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- tests = [
- # From Wikipedia
- (lomq_aug_sat_4, datetime(2006, 8, 26), True),
- (lomq_aug_sat_4, datetime(2007, 8, 25), True),
- (lomq_aug_sat_4, datetime(2008, 8, 30), True),
- (lomq_aug_sat_4, datetime(2009, 8, 29), True),
- (lomq_aug_sat_4, datetime(2010, 8, 28), True),
- (lomq_aug_sat_4, datetime(2011, 8, 27), True),
- (lomq_aug_sat_4, datetime(2019, 8, 31), True),
- (lomq_aug_sat_4, datetime(2006, 8, 27), False),
- (lomq_aug_sat_4, datetime(2007, 8, 28), False),
- (lomq_aug_sat_4, datetime(2008, 8, 31), False),
- (lomq_aug_sat_4, datetime(2009, 8, 30), False),
- (lomq_aug_sat_4, datetime(2010, 8, 29), False),
- (lomq_aug_sat_4, datetime(2011, 8, 28), False),
- (lomq_aug_sat_4, datetime(2006, 8, 25), False),
- (lomq_aug_sat_4, datetime(2007, 8, 24), False),
- (lomq_aug_sat_4, datetime(2008, 8, 29), False),
- (lomq_aug_sat_4, datetime(2009, 8, 28), False),
- (lomq_aug_sat_4, datetime(2010, 8, 27), False),
- (lomq_aug_sat_4, datetime(2011, 8, 26), False),
- (lomq_aug_sat_4, datetime(2019, 8, 30), False),
- # From GMCR
- (lomq_sep_sat_4, datetime(2010, 9, 25), True),
- (lomq_sep_sat_4, datetime(2011, 9, 24), True),
- (lomq_sep_sat_4, datetime(2012, 9, 29), True),
- (lomq_sep_sat_4, datetime(2013, 6, 29), True),
- (lomq_sep_sat_4, datetime(2012, 6, 23), True),
- (lomq_sep_sat_4, datetime(2012, 6, 30), False),
- (lomq_sep_sat_4, datetime(2013, 3, 30), True),
- (lomq_sep_sat_4, datetime(2012, 3, 24), True),
- (lomq_sep_sat_4, datetime(2012, 12, 29), True),
- (lomq_sep_sat_4, datetime(2011, 12, 24), True),
- # INTC (extra week in Q1)
- # See: http://www.intc.com/releasedetail.cfm?ReleaseID=542844
- (makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1),
- datetime(2011, 4, 2), True),
- # see: http://google.brand.edgar-online.com/?sym=INTC&formtypeID=7
- (makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1),
- datetime(2012, 12, 29), True),
- (makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1),
- datetime(2011, 12, 31), True),
- (makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1),
- datetime(2010, 12, 25), True),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_year_has_extra_week(self):
- # End of long Q1
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(2011, 4, 2)))
- # Start of long Q1
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(2010, 12, 26)))
- # End of year before year with long Q1
- self.assertFalse(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(2010, 12, 25)))
- for year in [x
- for x in range(1994, 2011 + 1)
- if x not in [2011, 2005, 2000, 1994]]:
- self.assertFalse(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(year, 4, 2)))
- # Other long years
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(2005, 4, 2)))
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(2000, 4, 2)))
- self.assertTrue(
- makeFY5253LastOfMonthQuarter(
- 1, startingMonth=12, weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- .year_has_extra_week(datetime(1994, 4, 2)))
- def test_get_weeks(self):
- sat_dec_1 = makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=1)
- sat_dec_4 = makeFY5253LastOfMonthQuarter(1, startingMonth=12,
- weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- self.assertEqual(sat_dec_1.get_weeks(
- datetime(2011, 4, 2)), [14, 13, 13, 13])
- self.assertEqual(sat_dec_4.get_weeks(
- datetime(2011, 4, 2)), [13, 13, 13, 14])
- self.assertEqual(sat_dec_1.get_weeks(
- datetime(2010, 12, 25)), [13, 13, 13, 13])
- class TestFY5253NearestEndMonthQuarter(Base):
- def test_onOffset(self):
- offset_nem_sat_aug_4 = makeFY5253NearestEndMonthQuarter(
- 1, startingMonth=8, weekday=WeekDay.SAT,
- qtr_with_extra_week=4)
- offset_nem_thu_aug_4 = makeFY5253NearestEndMonthQuarter(
- 1, startingMonth=8, weekday=WeekDay.THU,
- qtr_with_extra_week=4)
- offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12,
- variation="nearest", qtr_with_extra_week=4)
- tests = [
- # From Wikipedia
- (offset_nem_sat_aug_4, datetime(2006, 9, 2), True),
- (offset_nem_sat_aug_4, datetime(2007, 9, 1), True),
- (offset_nem_sat_aug_4, datetime(2008, 8, 30), True),
- (offset_nem_sat_aug_4, datetime(2009, 8, 29), True),
- (offset_nem_sat_aug_4, datetime(2010, 8, 28), True),
- (offset_nem_sat_aug_4, datetime(2011, 9, 3), True),
- (offset_nem_sat_aug_4, datetime(2016, 9, 3), True),
- (offset_nem_sat_aug_4, datetime(2017, 9, 2), True),
- (offset_nem_sat_aug_4, datetime(2018, 9, 1), True),
- (offset_nem_sat_aug_4, datetime(2019, 8, 31), True),
- (offset_nem_sat_aug_4, datetime(2006, 8, 27), False),
- (offset_nem_sat_aug_4, datetime(2007, 8, 28), False),
- (offset_nem_sat_aug_4, datetime(2008, 8, 31), False),
- (offset_nem_sat_aug_4, datetime(2009, 8, 30), False),
- (offset_nem_sat_aug_4, datetime(2010, 8, 29), False),
- (offset_nem_sat_aug_4, datetime(2011, 8, 28), False),
- (offset_nem_sat_aug_4, datetime(2006, 8, 25), False),
- (offset_nem_sat_aug_4, datetime(2007, 8, 24), False),
- (offset_nem_sat_aug_4, datetime(2008, 8, 29), False),
- (offset_nem_sat_aug_4, datetime(2009, 8, 28), False),
- (offset_nem_sat_aug_4, datetime(2010, 8, 27), False),
- (offset_nem_sat_aug_4, datetime(2011, 8, 26), False),
- (offset_nem_sat_aug_4, datetime(2019, 8, 30), False),
- # From Micron, see:
- # http://google.brand.edgar-online.com/?sym=MU&formtypeID=7
- (offset_nem_thu_aug_4, datetime(2012, 8, 30), True),
- (offset_nem_thu_aug_4, datetime(2011, 9, 1), True),
- # See: http://google.brand.edgar-online.com/?sym=MU&formtypeID=13
- (offset_nem_thu_aug_4, datetime(2013, 5, 30), True),
- (offset_nem_thu_aug_4, datetime(2013, 2, 28), True),
- (offset_nem_thu_aug_4, datetime(2012, 11, 29), True),
- (offset_nem_thu_aug_4, datetime(2012, 5, 31), True),
- (offset_nem_thu_aug_4, datetime(2007, 3, 1), True),
- (offset_nem_thu_aug_4, datetime(1994, 3, 3), True),
- (offset_n, datetime(2012, 12, 31), False),
- (offset_n, datetime(2013, 1, 1), True),
- (offset_n, datetime(2013, 1, 2), False)
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def test_offset(self):
- offset = makeFY5253NearestEndMonthQuarter(1, startingMonth=8,
- weekday=WeekDay.THU,
- qtr_with_extra_week=4)
- MU = [datetime(2012, 5, 31), datetime(2012, 8, 30), datetime(2012, 11,
- 29),
- datetime(2013, 2, 28), datetime(2013, 5, 30)]
- date = MU[0] + relativedelta(days=-1)
- for expected in MU:
- assertEq(offset, date, expected)
- date = date + offset
- assertEq(offset, datetime(2012, 5, 31), datetime(2012, 8, 30))
- assertEq(offset, datetime(2012, 5, 30), datetime(2012, 5, 31))
- offset2 = FY5253Quarter(weekday=5, startingMonth=12, variation="last",
- qtr_with_extra_week=4)
- assertEq(offset2, datetime(2013, 1, 15), datetime(2013, 3, 30))
- class TestQuarterBegin(Base):
- def test_repr(self):
- self.assertEqual(repr(QuarterBegin()),
- "<QuarterBegin: startingMonth=3>")
- self.assertEqual(repr(QuarterBegin(startingMonth=3)),
- "<QuarterBegin: startingMonth=3>")
- self.assertEqual(repr(QuarterBegin(startingMonth=1)),
- "<QuarterBegin: startingMonth=1>")
- def test_isAnchored(self):
- self.assertTrue(QuarterBegin(startingMonth=1).isAnchored())
- self.assertTrue(QuarterBegin().isAnchored())
- self.assertFalse(QuarterBegin(2, startingMonth=1).isAnchored())
- def test_offset(self):
- tests = []
- tests.append((QuarterBegin(startingMonth=1),
- {datetime(2007, 12, 1): datetime(2008, 1, 1),
- datetime(2008, 1, 1): datetime(2008, 4, 1),
- datetime(2008, 2, 15): datetime(2008, 4, 1),
- datetime(2008, 2, 29): datetime(2008, 4, 1),
- datetime(2008, 3, 15): datetime(2008, 4, 1),
- datetime(2008, 3, 31): datetime(2008, 4, 1),
- datetime(2008, 4, 15): datetime(2008, 7, 1),
- datetime(2008, 4, 1): datetime(2008, 7, 1), }))
- tests.append((QuarterBegin(startingMonth=2),
- {datetime(2008, 1, 1): datetime(2008, 2, 1),
- datetime(2008, 1, 31): datetime(2008, 2, 1),
- datetime(2008, 1, 15): datetime(2008, 2, 1),
- datetime(2008, 2, 29): datetime(2008, 5, 1),
- datetime(2008, 3, 15): datetime(2008, 5, 1),
- datetime(2008, 3, 31): datetime(2008, 5, 1),
- datetime(2008, 4, 15): datetime(2008, 5, 1),
- datetime(2008, 4, 30): datetime(2008, 5, 1), }))
- tests.append((QuarterBegin(startingMonth=1, n=0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 12, 1): datetime(2009, 1, 1),
- datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 2, 15): datetime(2008, 4, 1),
- datetime(2008, 2, 29): datetime(2008, 4, 1),
- datetime(2008, 3, 15): datetime(2008, 4, 1),
- datetime(2008, 3, 31): datetime(2008, 4, 1),
- datetime(2008, 4, 15): datetime(2008, 7, 1),
- datetime(2008, 4, 30): datetime(2008, 7, 1), }))
- tests.append((QuarterBegin(startingMonth=1, n=-1),
- {datetime(2008, 1, 1): datetime(2007, 10, 1),
- datetime(2008, 1, 31): datetime(2008, 1, 1),
- datetime(2008, 2, 15): datetime(2008, 1, 1),
- datetime(2008, 2, 29): datetime(2008, 1, 1),
- datetime(2008, 3, 15): datetime(2008, 1, 1),
- datetime(2008, 3, 31): datetime(2008, 1, 1),
- datetime(2008, 4, 15): datetime(2008, 4, 1),
- datetime(2008, 4, 30): datetime(2008, 4, 1),
- datetime(2008, 7, 1): datetime(2008, 4, 1)}))
- tests.append((QuarterBegin(startingMonth=1, n=2),
- {datetime(2008, 1, 1): datetime(2008, 7, 1),
- datetime(2008, 2, 15): datetime(2008, 7, 1),
- datetime(2008, 2, 29): datetime(2008, 7, 1),
- datetime(2008, 3, 15): datetime(2008, 7, 1),
- datetime(2008, 3, 31): datetime(2008, 7, 1),
- datetime(2008, 4, 15): datetime(2008, 10, 1),
- datetime(2008, 4, 1): datetime(2008, 10, 1), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- # corner
- offset = QuarterBegin(n=-1, startingMonth=1)
- self.assertEqual(datetime(2010, 2, 1) + offset, datetime(2010, 1, 1))
- class TestQuarterEnd(Base):
- _offset = QuarterEnd
- def test_repr(self):
- self.assertEqual(repr(QuarterEnd()), "<QuarterEnd: startingMonth=3>")
- self.assertEqual(repr(QuarterEnd(startingMonth=3)),
- "<QuarterEnd: startingMonth=3>")
- self.assertEqual(repr(QuarterEnd(startingMonth=1)),
- "<QuarterEnd: startingMonth=1>")
- def test_isAnchored(self):
- self.assertTrue(QuarterEnd(startingMonth=1).isAnchored())
- self.assertTrue(QuarterEnd().isAnchored())
- self.assertFalse(QuarterEnd(2, startingMonth=1).isAnchored())
- def test_offset(self):
- tests = []
- tests.append((QuarterEnd(startingMonth=1),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 4, 30),
- datetime(2008, 2, 15): datetime(2008, 4, 30),
- datetime(2008, 2, 29): datetime(2008, 4, 30),
- datetime(2008, 3, 15): datetime(2008, 4, 30),
- datetime(2008, 3, 31): datetime(2008, 4, 30),
- datetime(2008, 4, 15): datetime(2008, 4, 30),
- datetime(2008, 4, 30): datetime(2008, 7, 31), }))
- tests.append((QuarterEnd(startingMonth=2),
- {datetime(2008, 1, 1): datetime(2008, 2, 29),
- datetime(2008, 1, 31): datetime(2008, 2, 29),
- datetime(2008, 2, 15): datetime(2008, 2, 29),
- datetime(2008, 2, 29): datetime(2008, 5, 31),
- datetime(2008, 3, 15): datetime(2008, 5, 31),
- datetime(2008, 3, 31): datetime(2008, 5, 31),
- datetime(2008, 4, 15): datetime(2008, 5, 31),
- datetime(2008, 4, 30): datetime(2008, 5, 31), }))
- tests.append((QuarterEnd(startingMonth=1, n=0),
- {datetime(2008, 1, 1): datetime(2008, 1, 31),
- datetime(2008, 1, 31): datetime(2008, 1, 31),
- datetime(2008, 2, 15): datetime(2008, 4, 30),
- datetime(2008, 2, 29): datetime(2008, 4, 30),
- datetime(2008, 3, 15): datetime(2008, 4, 30),
- datetime(2008, 3, 31): datetime(2008, 4, 30),
- datetime(2008, 4, 15): datetime(2008, 4, 30),
- datetime(2008, 4, 30): datetime(2008, 4, 30), }))
- tests.append((QuarterEnd(startingMonth=1, n=-1),
- {datetime(2008, 1, 1): datetime(2007, 10, 31),
- datetime(2008, 1, 31): datetime(2007, 10, 31),
- datetime(2008, 2, 15): datetime(2008, 1, 31),
- datetime(2008, 2, 29): datetime(2008, 1, 31),
- datetime(2008, 3, 15): datetime(2008, 1, 31),
- datetime(2008, 3, 31): datetime(2008, 1, 31),
- datetime(2008, 4, 15): datetime(2008, 1, 31),
- datetime(2008, 4, 30): datetime(2008, 1, 31),
- datetime(2008, 7, 1): datetime(2008, 4, 30)}))
- tests.append((QuarterEnd(startingMonth=1, n=2),
- {datetime(2008, 1, 31): datetime(2008, 7, 31),
- datetime(2008, 2, 15): datetime(2008, 7, 31),
- datetime(2008, 2, 29): datetime(2008, 7, 31),
- datetime(2008, 3, 15): datetime(2008, 7, 31),
- datetime(2008, 3, 31): datetime(2008, 7, 31),
- datetime(2008, 4, 15): datetime(2008, 7, 31),
- datetime(2008, 4, 30): datetime(2008, 10, 31), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- # corner
- offset = QuarterEnd(n=-1, startingMonth=1)
- self.assertEqual(datetime(2010, 2, 1) + offset, datetime(2010, 1, 31))
- def test_onOffset(self):
- tests = [(QuarterEnd(1, startingMonth=1), datetime(2008, 1, 31), True),
- (QuarterEnd(1, startingMonth=1), datetime(2007, 12, 31),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2008, 2, 29),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2007, 3, 30),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2007, 3, 31),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2008, 4, 30), True),
- (QuarterEnd(1, startingMonth=1), datetime(2008, 5, 30),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2008, 5, 31),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2007, 6, 29),
- False),
- (QuarterEnd(1, startingMonth=1), datetime(2007, 6, 30),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2008, 1, 31),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2007, 12, 31),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2008, 2, 29), True),
- (QuarterEnd(1, startingMonth=2), datetime(2007, 3, 30),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2007, 3, 31),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2008, 4, 30),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2008, 5, 30),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2008, 5, 31), True),
- (QuarterEnd(1, startingMonth=2), datetime(2007, 6, 29),
- False),
- (QuarterEnd(1, startingMonth=2), datetime(2007, 6, 30),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2008, 1, 31),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2007, 12, 31),
- True),
- (QuarterEnd(1, startingMonth=3), datetime(2008, 2, 29),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2007, 3, 30),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2007, 3, 31), True),
- (QuarterEnd(1, startingMonth=3), datetime(2008, 4, 30),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2008, 5, 30),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2008, 5, 31),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2007, 6, 29),
- False),
- (QuarterEnd(1, startingMonth=3), datetime(2007, 6, 30),
- True), ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestBYearBegin(Base):
- _offset = BYearBegin
- def test_misspecified(self):
- self.assertRaises(ValueError, BYearBegin, month=13)
- self.assertRaises(ValueError, BYearEnd, month=13)
- def test_offset(self):
- tests = []
- tests.append((BYearBegin(),
- {datetime(2008, 1, 1): datetime(2009, 1, 1),
- datetime(2008, 6, 30): datetime(2009, 1, 1),
- datetime(2008, 12, 31): datetime(2009, 1, 1),
- datetime(2011, 1, 1): datetime(2011, 1, 3),
- datetime(2011, 1, 3): datetime(2012, 1, 2),
- datetime(2005, 12, 30): datetime(2006, 1, 2),
- datetime(2005, 12, 31): datetime(2006, 1, 2)}))
- tests.append((BYearBegin(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 6, 30): datetime(2009, 1, 1),
- datetime(2008, 12, 31): datetime(2009, 1, 1),
- datetime(2005, 12, 30): datetime(2006, 1, 2),
- datetime(2005, 12, 31): datetime(2006, 1, 2), }))
- tests.append((BYearBegin(-1),
- {datetime(2007, 1, 1): datetime(2006, 1, 2),
- datetime(2009, 1, 4): datetime(2009, 1, 1),
- datetime(2009, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 6, 30): datetime(2008, 1, 1),
- datetime(2008, 12, 31): datetime(2008, 1, 1),
- datetime(2006, 12, 29): datetime(2006, 1, 2),
- datetime(2006, 12, 30): datetime(2006, 1, 2),
- datetime(2006, 1, 1): datetime(2005, 1, 3), }))
- tests.append((BYearBegin(-2),
- {datetime(2007, 1, 1): datetime(2005, 1, 3),
- datetime(2007, 6, 30): datetime(2006, 1, 2),
- datetime(2008, 12, 31): datetime(2007, 1, 1), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- class TestYearBegin(Base):
- _offset = YearBegin
- def test_misspecified(self):
- self.assertRaises(ValueError, YearBegin, month=13)
- def test_offset(self):
- tests = []
- tests.append((YearBegin(),
- {datetime(2008, 1, 1): datetime(2009, 1, 1),
- datetime(2008, 6, 30): datetime(2009, 1, 1),
- datetime(2008, 12, 31): datetime(2009, 1, 1),
- datetime(2005, 12, 30): datetime(2006, 1, 1),
- datetime(2005, 12, 31): datetime(2006, 1, 1), }))
- tests.append((YearBegin(0),
- {datetime(2008, 1, 1): datetime(2008, 1, 1),
- datetime(2008, 6, 30): datetime(2009, 1, 1),
- datetime(2008, 12, 31): datetime(2009, 1, 1),
- datetime(2005, 12, 30): datetime(2006, 1, 1),
- datetime(2005, 12, 31): datetime(2006, 1, 1), }))
- tests.append((YearBegin(3),
- {datetime(2008, 1, 1): datetime(2011, 1, 1),
- datetime(2008, 6, 30): datetime(2011, 1, 1),
- datetime(2008, 12, 31): datetime(2011, 1, 1),
- datetime(2005, 12, 30): datetime(2008, 1, 1),
- datetime(2005, 12, 31): datetime(2008, 1, 1), }))
- tests.append((YearBegin(-1),
- {datetime(2007, 1, 1): datetime(2006, 1, 1),
- datetime(2007, 1, 15): datetime(2007, 1, 1),
- datetime(2008, 6, 30): datetime(2008, 1, 1),
- datetime(2008, 12, 31): datetime(2008, 1, 1),
- datetime(2006, 12, 29): datetime(2006, 1, 1),
- datetime(2006, 12, 30): datetime(2006, 1, 1),
- datetime(2007, 1, 1): datetime(2006, 1, 1), }))
- tests.append((YearBegin(-2),
- {datetime(2007, 1, 1): datetime(2005, 1, 1),
- datetime(2008, 6, 30): datetime(2007, 1, 1),
- datetime(2008, 12, 31): datetime(2007, 1, 1), }))
- tests.append((YearBegin(month=4),
- {datetime(2007, 4, 1): datetime(2008, 4, 1),
- datetime(2007, 4, 15): datetime(2008, 4, 1),
- datetime(2007, 3, 1): datetime(2007, 4, 1),
- datetime(2007, 12, 15): datetime(2008, 4, 1),
- datetime(2012, 1, 31): datetime(2012, 4, 1), }))
- tests.append((YearBegin(0, month=4),
- {datetime(2007, 4, 1): datetime(2007, 4, 1),
- datetime(2007, 3, 1): datetime(2007, 4, 1),
- datetime(2007, 12, 15): datetime(2008, 4, 1),
- datetime(2012, 1, 31): datetime(2012, 4, 1), }))
- tests.append((YearBegin(4, month=4),
- {datetime(2007, 4, 1): datetime(2011, 4, 1),
- datetime(2007, 4, 15): datetime(2011, 4, 1),
- datetime(2007, 3, 1): datetime(2010, 4, 1),
- datetime(2007, 12, 15): datetime(2011, 4, 1),
- datetime(2012, 1, 31): datetime(2015, 4, 1), }))
- tests.append((YearBegin(-1, month=4),
- {datetime(2007, 4, 1): datetime(2006, 4, 1),
- datetime(2007, 3, 1): datetime(2006, 4, 1),
- datetime(2007, 12, 15): datetime(2007, 4, 1),
- datetime(2012, 1, 31): datetime(2011, 4, 1), }))
- tests.append((YearBegin(-3, month=4),
- {datetime(2007, 4, 1): datetime(2004, 4, 1),
- datetime(2007, 3, 1): datetime(2004, 4, 1),
- datetime(2007, 12, 15): datetime(2005, 4, 1),
- datetime(2012, 1, 31): datetime(2009, 4, 1), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- tests = [
- (YearBegin(), datetime(2007, 1, 3), False),
- (YearBegin(), datetime(2008, 1, 1), True),
- (YearBegin(), datetime(2006, 12, 31), False),
- (YearBegin(), datetime(2006, 1, 2), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestBYearEndLagged(Base):
- def test_bad_month_fail(self):
- self.assertRaises(Exception, BYearEnd, month=13)
- self.assertRaises(Exception, BYearEnd, month=0)
- def test_offset(self):
- tests = []
- tests.append((BYearEnd(month=6),
- {datetime(2008, 1, 1): datetime(2008, 6, 30),
- datetime(2007, 6, 30): datetime(2008, 6, 30)}, ))
- tests.append((BYearEnd(n=-1, month=6),
- {datetime(2008, 1, 1): datetime(2007, 6, 29),
- datetime(2007, 6, 30): datetime(2007, 6, 29)}, ))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- self.assertEqual(base + offset, expected)
- def test_roll(self):
- offset = BYearEnd(month=6)
- date = datetime(2009, 11, 30)
- self.assertEqual(offset.rollforward(date), datetime(2010, 6, 30))
- self.assertEqual(offset.rollback(date), datetime(2009, 6, 30))
- def test_onOffset(self):
- tests = [
- (BYearEnd(month=2), datetime(2007, 2, 28), True),
- (BYearEnd(month=6), datetime(2007, 6, 30), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestBYearEnd(Base):
- _offset = BYearEnd
- def test_offset(self):
- tests = []
- tests.append((BYearEnd(),
- {datetime(2008, 1, 1): datetime(2008, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 12, 31),
- datetime(2008, 12, 31): datetime(2009, 12, 31),
- datetime(2005, 12, 30): datetime(2006, 12, 29),
- datetime(2005, 12, 31): datetime(2006, 12, 29), }))
- tests.append((BYearEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 12, 31),
- datetime(2008, 12, 31): datetime(2008, 12, 31),
- datetime(2005, 12, 31): datetime(2006, 12, 29), }))
- tests.append((BYearEnd(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 29),
- datetime(2008, 6, 30): datetime(2007, 12, 31),
- datetime(2008, 12, 31): datetime(2007, 12, 31),
- datetime(2006, 12, 29): datetime(2005, 12, 30),
- datetime(2006, 12, 30): datetime(2006, 12, 29),
- datetime(2007, 1, 1): datetime(2006, 12, 29), }))
- tests.append((BYearEnd(-2),
- {datetime(2007, 1, 1): datetime(2005, 12, 30),
- datetime(2008, 6, 30): datetime(2006, 12, 29),
- datetime(2008, 12, 31): datetime(2006, 12, 29), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- tests = [
- (BYearEnd(), datetime(2007, 12, 31), True),
- (BYearEnd(), datetime(2008, 1, 1), False),
- (BYearEnd(), datetime(2006, 12, 31), False),
- (BYearEnd(), datetime(2006, 12, 29), True),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestYearEnd(Base):
- _offset = YearEnd
- def test_misspecified(self):
- self.assertRaises(ValueError, YearEnd, month=13)
- def test_offset(self):
- tests = []
- tests.append((YearEnd(),
- {datetime(2008, 1, 1): datetime(2008, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 12, 31),
- datetime(2008, 12, 31): datetime(2009, 12, 31),
- datetime(2005, 12, 30): datetime(2005, 12, 31),
- datetime(2005, 12, 31): datetime(2006, 12, 31), }))
- tests.append((YearEnd(0),
- {datetime(2008, 1, 1): datetime(2008, 12, 31),
- datetime(2008, 6, 30): datetime(2008, 12, 31),
- datetime(2008, 12, 31): datetime(2008, 12, 31),
- datetime(2005, 12, 30): datetime(2005, 12, 31), }))
- tests.append((YearEnd(-1),
- {datetime(2007, 1, 1): datetime(2006, 12, 31),
- datetime(2008, 6, 30): datetime(2007, 12, 31),
- datetime(2008, 12, 31): datetime(2007, 12, 31),
- datetime(2006, 12, 29): datetime(2005, 12, 31),
- datetime(2006, 12, 30): datetime(2005, 12, 31),
- datetime(2007, 1, 1): datetime(2006, 12, 31), }))
- tests.append((YearEnd(-2),
- {datetime(2007, 1, 1): datetime(2005, 12, 31),
- datetime(2008, 6, 30): datetime(2006, 12, 31),
- datetime(2008, 12, 31): datetime(2006, 12, 31), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- tests = [
- (YearEnd(), datetime(2007, 12, 31), True),
- (YearEnd(), datetime(2008, 1, 1), False),
- (YearEnd(), datetime(2006, 12, 31), True),
- (YearEnd(), datetime(2006, 12, 29), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- class TestYearEndDiffMonth(Base):
- def test_offset(self):
- tests = []
- tests.append((YearEnd(month=3),
- {datetime(2008, 1, 1): datetime(2008, 3, 31),
- datetime(2008, 2, 15): datetime(2008, 3, 31),
- datetime(2008, 3, 31): datetime(2009, 3, 31),
- datetime(2008, 3, 30): datetime(2008, 3, 31),
- datetime(2005, 3, 31): datetime(2006, 3, 31),
- datetime(2006, 7, 30): datetime(2007, 3, 31)}))
- tests.append((YearEnd(0, month=3),
- {datetime(2008, 1, 1): datetime(2008, 3, 31),
- datetime(2008, 2, 28): datetime(2008, 3, 31),
- datetime(2008, 3, 31): datetime(2008, 3, 31),
- datetime(2005, 3, 30): datetime(2005, 3, 31), }))
- tests.append((YearEnd(-1, month=3),
- {datetime(2007, 1, 1): datetime(2006, 3, 31),
- datetime(2008, 2, 28): datetime(2007, 3, 31),
- datetime(2008, 3, 31): datetime(2007, 3, 31),
- datetime(2006, 3, 29): datetime(2005, 3, 31),
- datetime(2006, 3, 30): datetime(2005, 3, 31),
- datetime(2007, 3, 1): datetime(2006, 3, 31), }))
- tests.append((YearEnd(-2, month=3),
- {datetime(2007, 1, 1): datetime(2005, 3, 31),
- datetime(2008, 6, 30): datetime(2007, 3, 31),
- datetime(2008, 3, 31): datetime(2006, 3, 31), }))
- for offset, cases in tests:
- for base, expected in compat.iteritems(cases):
- assertEq(offset, base, expected)
- def test_onOffset(self):
- tests = [
- (YearEnd(month=3), datetime(2007, 3, 31), True),
- (YearEnd(month=3), datetime(2008, 1, 1), False),
- (YearEnd(month=3), datetime(2006, 3, 31), True),
- (YearEnd(month=3), datetime(2006, 3, 29), False),
- ]
- for offset, dt, expected in tests:
- assertOnOffset(offset, dt, expected)
- def assertEq(offset, base, expected):
- actual = offset + base
- actual_swapped = base + offset
- actual_apply = offset.apply(base)
- try:
- assert actual == expected
- assert actual_swapped == expected
- assert actual_apply == expected
- except AssertionError:
- raise AssertionError("\nExpected: %s\nActual: %s\nFor Offset: %s)"
- "\nAt Date: %s" %
- (expected, actual, offset, base))
- def test_Easter():
- assertEq(Easter(), datetime(2010, 1, 1), datetime(2010, 4, 4))
- assertEq(Easter(), datetime(2010, 4, 5), datetime(2011, 4, 24))
- assertEq(Easter(2), datetime(2010, 1, 1), datetime(2011, 4, 24))
- assertEq(Easter(), datetime(2010, 4, 4), datetime(2011, 4, 24))
- assertEq(Easter(2), datetime(2010, 4, 4), datetime(2012, 4, 8))
- assertEq(-Easter(), datetime(2011, 1, 1), datetime(2010, 4, 4))
- assertEq(-Easter(), datetime(2010, 4, 5), datetime(2010, 4, 4))
- assertEq(-Easter(2), datetime(2011, 1, 1), datetime(2009, 4, 12))
- assertEq(-Easter(), datetime(2010, 4, 4), datetime(2009, 4, 12))
- assertEq(-Easter(2), datetime(2010, 4, 4), datetime(2008, 3, 23))
- class TestTicks(tm.TestCase):
- ticks = [Hour, Minute, Second, Milli, Micro, Nano]
- def test_ticks(self):
- offsets = [(Hour, Timedelta(hours=5)),
- (Minute, Timedelta(hours=2, minutes=3)),
- (Second, Timedelta(hours=2, seconds=3)),
- (Milli, Timedelta(hours=2, milliseconds=3)),
- (Micro, Timedelta(hours=2, microseconds=3)),
- (Nano, Timedelta(hours=2, nanoseconds=3))]
- for kls, expected in offsets:
- offset = kls(3)
- result = offset + Timedelta(hours=2)
- self.assertTrue(isinstance(result, Timedelta))
- self.assertEqual(result, expected)
- def test_Hour(self):
- assertEq(Hour(), datetime(2010, 1, 1), datetime(2010, 1, 1, 1))
- assertEq(Hour(-1), datetime(2010, 1, 1, 1), datetime(2010, 1, 1))
- assertEq(2 * Hour(), datetime(2010, 1, 1), datetime(2010, 1, 1, 2))
- assertEq(-1 * Hour(), datetime(2010, 1, 1, 1), datetime(2010, 1, 1))
- self.assertEqual(Hour(3) + Hour(2), Hour(5))
- self.assertEqual(Hour(3) - Hour(2), Hour())
- self.assertNotEqual(Hour(4), Hour(1))
- def test_Minute(self):
- assertEq(Minute(), datetime(2010, 1, 1), datetime(2010, 1, 1, 0, 1))
- assertEq(Minute(-1), datetime(2010, 1, 1, 0, 1), datetime(2010, 1, 1))
- assertEq(2 * Minute(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 2))
- assertEq(-1 * Minute(), datetime(2010, 1, 1, 0, 1),
- datetime(2010, 1, 1))
- self.assertEqual(Minute(3) + Minute(2), Minute(5))
- self.assertEqual(Minute(3) - Minute(2), Minute())
- self.assertNotEqual(Minute(5), Minute())
- def test_Second(self):
- assertEq(Second(), datetime(2010, 1, 1), datetime(2010, 1, 1, 0, 0, 1))
- assertEq(Second(-1), datetime(2010, 1, 1,
- 0, 0, 1), datetime(2010, 1, 1))
- assertEq(2 * Second(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 2))
- assertEq(-1 * Second(), datetime(2010, 1, 1, 0, 0, 1),
- datetime(2010, 1, 1))
- self.assertEqual(Second(3) + Second(2), Second(5))
- self.assertEqual(Second(3) - Second(2), Second())
- def test_Millisecond(self):
- assertEq(Milli(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 0, 1000))
- assertEq(Milli(-1), datetime(2010, 1, 1, 0,
- 0, 0, 1000), datetime(2010, 1, 1))
- assertEq(Milli(2), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 0, 2000))
- assertEq(2 * Milli(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 0, 2000))
- assertEq(-1 * Milli(), datetime(2010, 1, 1, 0, 0, 0, 1000),
- datetime(2010, 1, 1))
- self.assertEqual(Milli(3) + Milli(2), Milli(5))
- self.assertEqual(Milli(3) - Milli(2), Milli())
- def test_MillisecondTimestampArithmetic(self):
- assertEq(Milli(), Timestamp('2010-01-01'),
- Timestamp('2010-01-01 00:00:00.001'))
- assertEq(Milli(-1), Timestamp('2010-01-01 00:00:00.001'),
- Timestamp('2010-01-01'))
- def test_Microsecond(self):
- assertEq(Micro(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 0, 1))
- assertEq(Micro(-1), datetime(2010, 1, 1,
- 0, 0, 0, 1), datetime(2010, 1, 1))
- assertEq(2 * Micro(), datetime(2010, 1, 1),
- datetime(2010, 1, 1, 0, 0, 0, 2))
- assertEq(-1 * Micro(), datetime(2010, 1, 1, 0, 0, 0, 1),
- datetime(2010, 1, 1))
- self.assertEqual(Micro(3) + Micro(2), Micro(5))
- self.assertEqual(Micro(3) - Micro(2), Micro())
- def test_NanosecondGeneric(self):
- timestamp = Timestamp(datetime(2010, 1, 1))
- self.assertEqual(timestamp.nanosecond, 0)
- result = timestamp + Nano(10)
- self.assertEqual(result.nanosecond, 10)
- reverse_result = Nano(10) + timestamp
- self.assertEqual(reverse_result.nanosecond, 10)
- def test_Nanosecond(self):
- timestamp = Timestamp(datetime(2010, 1, 1))
- assertEq(Nano(), timestamp, timestamp + np.timedelta64(1, 'ns'))
- assertEq(Nano(-1), timestamp + np.timedelta64(1, 'ns'), timestamp)
- assertEq(2 * Nano(), timestamp, timestamp + np.timedelta64(2, 'ns'))
- assertEq(-1 * Nano(), timestamp + np.timedelta64(1, 'ns'), timestamp)
- self.assertEqual(Nano(3) + Nano(2), Nano(5))
- self.assertEqual(Nano(3) - Nano(2), Nano())
- # GH9284
- self.assertEqual(Nano(1) + Nano(10), Nano(11))
- self.assertEqual(Nano(5) + Micro(1), Nano(1005))
- self.assertEqual(Micro(5) + Nano(1), Nano(5001))
- def test_tick_zero(self):
- for t1 in self.ticks:
- for t2 in self.ticks:
- self.assertEqual(t1(0), t2(0))
- self.assertEqual(t1(0) + t2(0), t1(0))
- if t1 is not Nano:
- self.assertEqual(t1(2) + t2(0), t1(2))
- if t1 is Nano:
- self.assertEqual(t1(2) + Nano(0), t1(2))
- def test_tick_equalities(self):
- for t in self.ticks:
- self.assertEqual(t(3), t(3))
- self.assertEqual(t(), t(1))
- # not equals
- self.assertNotEqual(t(3), t(2))
- self.assertNotEqual(t(3), t(-3))
- def test_tick_operators(self):
- for t in self.ticks:
- self.assertEqual(t(3) + t(2), t(5))
- self.assertEqual(t(3) - t(2), t(1))
- self.assertEqual(t(800) + t(300), t(1100))
- self.assertEqual(t(1000) - t(5), t(995))
- def test_tick_offset(self):
- for t in self.ticks:
- self.assertFalse(t().isAnchored())
- def test_compare_ticks(self):
- for kls in self.ticks:
- three = kls(3)
- four = kls(4)
- for _ in range(10):
- self.assertTrue(three < kls(4))
- self.assertTrue(kls(3) < four)
- self.assertTrue(four > kls(3))
- self.assertTrue(kls(4) > three)
- self.assertTrue(kls(3) == kls(3))
- self.assertTrue(kls(3) != kls(4))
- class TestOffsetNames(tm.TestCase):
- def test_get_offset_name(self):
- self.assertEqual(BDay().freqstr, 'B')
- self.assertEqual(BDay(2).freqstr, '2B')
- self.assertEqual(BMonthEnd().freqstr, 'BM')
- self.assertEqual(Week(weekday=0).freqstr, 'W-MON')
- self.assertEqual(Week(weekday=1).freqstr, 'W-TUE')
- self.assertEqual(Week(weekday=2).freqstr, 'W-WED')
- self.assertEqual(Week(weekday=3).freqstr, 'W-THU')
- self.assertEqual(Week(weekday=4).freqstr, 'W-FRI')
- self.assertEqual(LastWeekOfMonth(
- weekday=WeekDay.SUN).freqstr, "LWOM-SUN")
- self.assertEqual(
- makeFY5253LastOfMonthQuarter(weekday=1, startingMonth=3,
- qtr_with_extra_week=4).freqstr,
- "REQ-L-MAR-TUE-4")
- self.assertEqual(
- makeFY5253NearestEndMonthQuarter(weekday=1, startingMonth=3,
- qtr_with_extra_week=3).freqstr,
- "REQ-N-MAR-TUE-3")
- def test_get_offset():
- with tm.assertRaisesRegexp(ValueError, _INVALID_FREQ_ERROR):
- get_offset('gibberish')
- with tm.assertRaisesRegexp(ValueError, _INVALID_FREQ_ERROR):
- get_offset('QS-JAN-B')
- pairs = [
- ('B', BDay()), ('b', BDay()), ('bm', BMonthEnd()),
- ('Bm', BMonthEnd()), ('W-MON', Week(weekday=0)),
- ('W-TUE', Week(weekday=1)), ('W-WED', Week(weekday=2)),
- ('W-THU', Week(weekday=3)), ('W-FRI', Week(weekday=4)),
- ("RE-N-DEC-MON", makeFY5253NearestEndMonth(weekday=0,
- startingMonth=12)),
- ("RE-L-DEC-TUE", makeFY5253LastOfMonth(weekday=1, startingMonth=12)),
- ("REQ-L-MAR-TUE-4", makeFY5253LastOfMonthQuarter(
- weekday=1, startingMonth=3, qtr_with_extra_week=4)),
- ("REQ-L-DEC-MON-3", makeFY5253LastOfMonthQuarter(
- weekday=0, startingMonth=12, qtr_with_extra_week=3)),
- ("REQ-N-DEC-MON-3", makeFY5253NearestEndMonthQuarter(
- weekday=0, startingMonth=12, qtr_with_extra_week=3)),
- ]
- for name, expected in pairs:
- offset = get_offset(name)
- assert offset == expected, ("Expected %r to yield %r (actual: %r)" %
- (name, expected, offset))
- def test_get_offset_legacy():
- pairs = [('w@Sat', Week(weekday=5))]
- for name, expected in pairs:
- with tm.assertRaisesRegexp(ValueError, _INVALID_FREQ_ERROR):
- get_offset(name)
- class TestParseTimeString(tm.TestCase):
- def test_parse_time_string(self):
- (date, parsed, reso) = parse_time_string('4Q1984')
- (date_lower, parsed_lower, reso_lower) = parse_time_string('4q1984')
- self.assertEqual(date, date_lower)
- self.assertEqual(parsed, parsed_lower)
- self.assertEqual(reso, reso_lower)
- def test_parse_time_quarter_w_dash(self):
- # https://github.com/pydata/pandas/issue/9688
- pairs = [('1988-Q2', '1988Q2'), ('2Q-1988', '2Q1988'), ]
- for dashed, normal in pairs:
- (date_dash, parsed_dash, reso_dash) = parse_time_string(dashed)
- (date, parsed, reso) = parse_time_string(normal)
- self.assertEqual(date_dash, date)
- self.assertEqual(parsed_dash, parsed)
- self.assertEqual(reso_dash, reso)
- self.assertRaises(DateParseError, parse_time_string, "-2Q1992")
- self.assertRaises(DateParseError, parse_time_string, "2-Q1992")
- self.assertRaises(DateParseError, parse_time_string, "4-4Q1992")
- def test_get_standard_freq():
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- fstr = get_standard_freq('W')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- assert fstr == get_standard_freq('w')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- assert fstr == get_standard_freq('1w')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- assert fstr == get_standard_freq(('W', 1))
- with tm.assertRaisesRegexp(ValueError, _INVALID_FREQ_ERROR):
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- get_standard_freq('WeEk')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- fstr = get_standard_freq('5Q')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- assert fstr == get_standard_freq('5q')
- with tm.assertRaisesRegexp(ValueError, _INVALID_FREQ_ERROR):
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- get_standard_freq('5QuarTer')
- with tm.assert_produces_warning(FutureWarning, check_stacklevel=False):
- assert fstr == get_standard_freq(('q', 5))
- def test_quarterly_dont_normalize():
- date = datetime(2012, 3, 31, 5, 30)
- offsets = (QuarterBegin, QuarterEnd, BQuarterEnd, BQuarterBegin)
- for klass in offsets:
- result = date + klass()
- assert (result.time() == date.time())
- class TestOffsetAliases(tm.TestCase):
- def setUp(self):
- _offset_map.clear()
- def test_alias_equality(self):
- for k, v in compat.iteritems(_offset_map):
- if v is None:
- continue
- self.assertEqual(k, v.copy())
- def test_rule_code(self):
- lst = ['M', 'MS', 'BM', 'BMS', 'D', 'B', 'H', 'T', 'S', 'L', 'U']
- for k in lst:
- self.assertEqual(k, get_offset(k).rule_code)
- # should be cached - this is kind of an internals test...
- assert k in _offset_map
- self.assertEqual(k, (get_offset(k) * 3).rule_code)
- suffix_lst = ['MON', 'TUE', 'WED', 'THU', 'FRI', 'SAT', 'SUN']
- base = 'W'
- for v in suffix_lst:
- alias = '-'.join([base, v])
- self.assertEqual(alias, get_offset(alias).rule_code)
- self.assertEqual(alias, (get_offset(alias) * 5).rule_code)
- suffix_lst = ['JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG',
- 'SEP', 'OCT', 'NOV', 'DEC']
- base_lst = ['A', 'AS', 'BA', 'BAS', 'Q', 'QS', 'BQ', 'BQS']
- for base in base_lst:
- for v in suffix_lst:
- alias = '-'.join([base, v])
- self.assertEqual(alias, get_offset(alias).rule_code)
- self.assertEqual(alias, (get_offset(alias) * 5).rule_code)
- lst = ['M', 'D', 'B', 'H', 'T', 'S', 'L', 'U']
- for k in lst:
- code, stride = get_freq_code('3' + k)
- self.assertTrue(isinstance(code, int))
- self.assertEqual(stride, 3)
- self.assertEqual(k, _get_freq_str(code))
- def test_apply_ticks():
- result = offsets.Hour(3).apply(offsets.Hour(4))
- exp = offsets.Hour(7)
- assert (result == exp)
- def test_delta_to_tick():
- delta = timedelta(3)
- tick = offsets._delta_to_tick(delta)
- assert (tick == offsets.Day(3))
- def test_dateoffset_misc():
- oset = offsets.DateOffset(months=2, days=4)
- # it works
- oset.freqstr
- assert (not offsets.DateOffset(months=2) == 2)
- def test_freq_offsets():
- off = BDay(1, offset=timedelta(0, 1800))
- assert (off.freqstr == 'B+30Min')
- off = BDay(1, offset=timedelta(0, -1800))
- assert (off.freqstr == 'B-30Min')
- def get_all_subclasses(cls):
- ret = set()
- this_subclasses = cls.__subclasses__()
- ret = ret | set(this_subclasses)
- for this_subclass in this_subclasses:
- ret | get_all_subclasses(this_subclass)
- return ret
- class TestCaching(tm.TestCase):
- # as of GH 6479 (in 0.14.0), offset caching is turned off
- # as of v0.12.0 only BusinessMonth/Quarter were actually caching
- def setUp(self):
- _daterange_cache.clear()
- _offset_map.clear()
- def run_X_index_creation(self, cls):
- inst1 = cls()
- if not inst1.isAnchored():
- self.assertFalse(inst1._should_cache(), cls)
- return
- self.assertTrue(inst1._should_cache(), cls)
- DatetimeIndex(start=datetime(2013, 1, 31), end=datetime(2013, 3, 31),
- freq=inst1, normalize=True)
- self.assertTrue(cls() in _daterange_cache, cls)
- def test_should_cache_month_end(self):
- self.assertFalse(MonthEnd()._should_cache())
- def test_should_cache_bmonth_end(self):
- self.assertFalse(BusinessMonthEnd()._should_cache())
- def test_should_cache_week_month(self):
- self.assertFalse(WeekOfMonth(weekday=1, week=2)._should_cache())
- def test_all_cacheableoffsets(self):
- for subclass in get_all_subclasses(CacheableOffset):
- if subclass.__name__[0] == "_" \
- or subclass in TestCaching.no_simple_ctr:
- continue
- self.run_X_index_creation(subclass)
- def test_month_end_index_creation(self):
- DatetimeIndex(start=datetime(2013, 1, 31), end=datetime(2013, 3, 31),
- freq=MonthEnd(), normalize=True)
- self.assertFalse(MonthEnd() in _daterange_cache)
- def test_bmonth_end_index_creation(self):
- DatetimeIndex(start=datetime(2013, 1, 31), end=datetime(2013, 3, 29),
- freq=BusinessMonthEnd(), normalize=True)
- self.assertFalse(BusinessMonthEnd() in _daterange_cache)
- def test_week_of_month_index_creation(self):
- inst1 = WeekOfMonth(weekday=1, week=2)
- DatetimeIndex(start=datetime(2013, 1, 31), end=datetime(2013, 3, 29),
- freq=inst1, normalize=True)
- inst2 = WeekOfMonth(weekday=1, week=2)
- self.assertFalse(inst2 in _daterange_cache)
- class TestReprNames(tm.TestCase):
- def test_str_for_named_is_name(self):
- # look at all the amazing combinations!
- month_prefixes = ['A', 'AS', 'BA', 'BAS', 'Q', 'BQ', 'BQS', 'QS']
- names = [prefix + '-' + month
- for prefix in month_prefixes
- for month in ['JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL',
- 'AUG', 'SEP', 'OCT', 'NOV', 'DEC']]
- days = ['MON', 'TUE', 'WED', 'THU', 'FRI', 'SAT', 'SUN']
- names += ['W-' + day for day in days]
- names += ['WOM-' + week + day
- for week in ('1', '2', '3', '4') for day in days]
- _offset_map.clear()
- for name in names:
- offset = get_offset(name)
- self.assertEqual(offset.freqstr, name)
- def get_utc_offset_hours(ts):
- # take a Timestamp and compute total hours of utc offset
- o = ts.utcoffset()
- return (o.days * 24 * 3600 + o.seconds) / 3600.0
- class TestDST(tm.TestCase):
- """
- test DateOffset additions over Daylight Savings Time
- """
- # one microsecond before the DST transition
- ts_pre_fallback = "2013-11-03 01:59:59.999999"
- ts_pre_springfwd = "2013-03-10 01:59:59.999999"
- # test both basic names and dateutil timezones
- timezone_utc_offsets = {
- 'US/Eastern': dict(utc_offset_daylight=-4,
- utc_offset_standard=-5, ),
- 'dateutil/US/Pacific': dict(utc_offset_daylight=-7,
- utc_offset_standard=-8, )
- }
- valid_date_offsets_singular = [
- 'weekday', 'day', 'hour', 'minute', 'second', 'microsecond'
- ]
- valid_date_offsets_plural = [
- 'weeks', 'days',
- 'hours', 'minutes', 'seconds',
- 'milliseconds', 'microseconds'
- ]
- def _test_all_offsets(self, n, **kwds):
- valid_offsets = self.valid_date_offsets_plural if n > 1 \
- else self.valid_date_offsets_singular
- for name in valid_offsets:
- self._test_offset(offset_name=name, offset_n=n, **kwds)
- def _test_offset(self, offset_name, offset_n, tstart, expected_utc_offset):
- offset = DateOffset(**{offset_name: offset_n})
- t = tstart + offset
- if expected_utc_offset is not None:
- self.assertTrue(get_utc_offset_hours(t) == expected_utc_offset)
- if offset_name == 'weeks':
- # dates should match
- self.assertTrue(t.date() == timedelta(days=7 * offset.kwds[
- 'weeks']) + tstart.date())
- # expect the same day of week, hour of day, minute, second, ...
- self.assertTrue(t.dayofweek == tstart.dayofweek and t.hour ==
- tstart.hour and t.minute == tstart.minute and
- t.second == tstart.second)
- elif offset_name == 'days':
- # dates should match
- self.assertTrue(timedelta(offset.kwds['days']) + tstart.date() ==
- t.date())
- # expect the same hour of day, minute, second, ...
- self.assertTrue(t.hour == tstart.hour and
- t.minute == tstart.minute and
- t.second == tstart.second)
- elif offset_name in self.valid_date_offsets_singular:
- # expect the signular offset value to match between tstart and t
- datepart_offset = getattr(t, offset_name
- if offset_name != 'weekday' else
- 'dayofweek')
- self.assertTrue(datepart_offset == offset.kwds[offset_name])
- else:
- # the offset should be the same as if it was done in UTC
- self.assertTrue(t == (tstart.tz_convert('UTC') + offset
- ).tz_convert('US/Pacific'))
- def _make_timestamp(self, string, hrs_offset, tz):
- if hrs_offset >= 0:
- offset_string = '{hrs:02d}00'.format(hrs=hrs_offset)
- else:
- offset_string = '-{hrs:02d}00'.format(hrs=-1 * hrs_offset)
- return Timestamp(string + offset_string).tz_convert(tz)
- def test_fallback_plural(self):
- """test moving from daylight savings to standard time"""
- for tz, utc_offsets in self.timezone_utc_offsets.items():
- hrs_pre = utc_offsets['utc_offset_daylight']
- hrs_post = utc_offsets['utc_offset_standard']
- self._test_all_offsets(
- n=3, tstart=self._make_timestamp(self.ts_pre_fallback,
- hrs_pre, tz),
- expected_utc_offset=hrs_post)
- def test_springforward_plural(self):
- """test moving from standard to daylight savings"""
- for tz, utc_offsets in self.timezone_utc_offsets.items():
- hrs_pre = utc_offsets['utc_offset_standard']
- hrs_post = utc_offsets['utc_offset_daylight']
- self._test_all_offsets(
- n=3, tstart=self._make_timestamp(self.ts_pre_springfwd,
- hrs_pre, tz),
- expected_utc_offset=hrs_post)
- def test_fallback_singular(self):
- # in the case of signular offsets, we dont neccesarily know which utc
- # offset the new Timestamp will wind up in (the tz for 1 month may be
- # different from 1 second) so we don't specify an expected_utc_offset
- for tz, utc_offsets in self.timezone_utc_offsets.items():
- hrs_pre = utc_offsets['utc_offset_standard']
- self._test_all_offsets(n=1, tstart=self._make_timestamp(
- self.ts_pre_fallback, hrs_pre, tz), expected_utc_offset=None)
- def test_springforward_singular(self):
- for tz, utc_offsets in self.timezone_utc_offsets.items():
- hrs_pre = utc_offsets['utc_offset_standard']
- self._test_all_offsets(n=1, tstart=self._make_timestamp(
- self.ts_pre_springfwd, hrs_pre, tz), expected_utc_offset=None)
- def test_all_offset_classes(self):
- tests = {MonthBegin: ['11/2/2012', '12/1/2012'],
- MonthEnd: ['11/2/2012', '11/30/2012'],
- BMonthBegin: ['11/2/2012', '12/3/2012'],
- BMonthEnd: ['11/2/2012', '11/30/2012'],
- CBMonthBegin: ['11/2/2012', '12/3/2012'],
- CBMonthEnd: ['11/2/2012', '11/30/2012'],
- SemiMonthBegin: ['11/2/2012', '11/15/2012'],
- SemiMonthEnd: ['11/2/2012', '11/15/2012'],
- Week: ['11/2/2012', '11/9/2012'],
- YearBegin: ['11/2/2012', '1/1/2013'],
- YearEnd: ['11/2/2012', '12/31/2012'],
- BYearBegin: ['11/2/2012', '1/1/2013'],
- BYearEnd: ['11/2/2012', '12/31/2012'],
- QuarterBegin: ['11/2/2012', '12/1/2012'],
- QuarterEnd: ['11/2/2012', '12/31/2012'],
- BQuarterBegin: ['11/2/2012', '12/3/2012'],
- BQuarterEnd: ['11/2/2012', '12/31/2012'],
- Day: ['11/4/2012', '11/4/2012 23:00']}
- for offset, test_values in iteritems(tests):
- first = Timestamp(test_values[0], tz='US/Eastern') + offset()
- second = Timestamp(test_values[1], tz='US/Eastern')
- self.assertEqual(first, second, msg=str(offset))
- if __name__ == '__main__':
- nose.runmodule(argv=[__file__, '-vvs', '-x', '--pdb', '--pdb-failure'],
- exit=False)