test_custom_business_hour.py 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329
  1. """
  2. Tests for offsets.CustomBusinessHour
  3. """
  4. from __future__ import annotations
  5. from datetime import (
  6. datetime,
  7. time as dt_time,
  8. )
  9. import numpy as np
  10. import pytest
  11. from pandas._libs.tslibs import Timestamp
  12. from pandas._libs.tslibs.offsets import (
  13. BusinessHour,
  14. CustomBusinessHour,
  15. Nano,
  16. )
  17. from pandas.tests.tseries.offsets.common import assert_offset_equal
  18. from pandas.tseries.holiday import USFederalHolidayCalendar
  19. holidays = ["2014-06-27", datetime(2014, 6, 30), np.datetime64("2014-07-02")]
  20. @pytest.fixture
  21. def dt():
  22. return datetime(2014, 7, 1, 10, 00)
  23. @pytest.fixture
  24. def _offset():
  25. return CustomBusinessHour
  26. # 2014 Calendar to check custom holidays
  27. # Sun Mon Tue Wed Thu Fri Sat
  28. # 6/22 23 24 25 26 27 28
  29. # 29 30 7/1 2 3 4 5
  30. # 6 7 8 9 10 11 12
  31. @pytest.fixture
  32. def offset1():
  33. return CustomBusinessHour(weekmask="Tue Wed Thu Fri")
  34. @pytest.fixture
  35. def offset2():
  36. return CustomBusinessHour(holidays=holidays)
  37. class TestCustomBusinessHour:
  38. def test_constructor_errors(self):
  39. msg = "time data must be specified only with hour and minute"
  40. with pytest.raises(ValueError, match=msg):
  41. CustomBusinessHour(start=dt_time(11, 0, 5))
  42. msg = "time data must match '%H:%M' format"
  43. with pytest.raises(ValueError, match=msg):
  44. CustomBusinessHour(start="AAA")
  45. msg = "time data must match '%H:%M' format"
  46. with pytest.raises(ValueError, match=msg):
  47. CustomBusinessHour(start="14:00:05")
  48. def test_different_normalize_equals(self, _offset):
  49. # GH#21404 changed __eq__ to return False when `normalize` does not match
  50. offset = _offset()
  51. offset2 = _offset(normalize=True)
  52. assert offset != offset2
  53. def test_repr(self, offset1, offset2):
  54. assert repr(offset1) == "<CustomBusinessHour: CBH=09:00-17:00>"
  55. assert repr(offset2) == "<CustomBusinessHour: CBH=09:00-17:00>"
  56. def test_with_offset(self, dt):
  57. expected = Timestamp("2014-07-01 13:00")
  58. assert dt + CustomBusinessHour() * 3 == expected
  59. assert dt + CustomBusinessHour(n=3) == expected
  60. def test_eq(self, offset1, offset2):
  61. for offset in [offset1, offset2]:
  62. assert offset == offset
  63. assert CustomBusinessHour() != CustomBusinessHour(-1)
  64. assert CustomBusinessHour(start="09:00") == CustomBusinessHour()
  65. assert CustomBusinessHour(start="09:00") != CustomBusinessHour(start="09:01")
  66. assert CustomBusinessHour(start="09:00", end="17:00") != CustomBusinessHour(
  67. start="17:00", end="09:01"
  68. )
  69. assert CustomBusinessHour(weekmask="Tue Wed Thu Fri") != CustomBusinessHour(
  70. weekmask="Mon Tue Wed Thu Fri"
  71. )
  72. assert CustomBusinessHour(holidays=["2014-06-27"]) != CustomBusinessHour(
  73. holidays=["2014-06-28"]
  74. )
  75. def test_hash(self, offset1, offset2):
  76. assert hash(offset1) == hash(offset1)
  77. assert hash(offset2) == hash(offset2)
  78. def test_add_dateime(self, dt, offset1, offset2):
  79. assert offset1 + dt == datetime(2014, 7, 1, 11)
  80. assert offset2 + dt == datetime(2014, 7, 1, 11)
  81. def testRollback1(self, dt, offset1, offset2):
  82. assert offset1.rollback(dt) == dt
  83. assert offset2.rollback(dt) == dt
  84. d = datetime(2014, 7, 1, 0)
  85. # 2014/07/01 is Tuesday, 06/30 is Monday(holiday)
  86. assert offset1.rollback(d) == datetime(2014, 6, 27, 17)
  87. # 2014/6/30 and 2014/6/27 are holidays
  88. assert offset2.rollback(d) == datetime(2014, 6, 26, 17)
  89. def testRollback2(self, _offset):
  90. assert _offset(-3).rollback(datetime(2014, 7, 5, 15, 0)) == datetime(
  91. 2014, 7, 4, 17, 0
  92. )
  93. def testRollforward1(self, dt, offset1, offset2):
  94. assert offset1.rollforward(dt) == dt
  95. assert offset2.rollforward(dt) == dt
  96. d = datetime(2014, 7, 1, 0)
  97. assert offset1.rollforward(d) == datetime(2014, 7, 1, 9)
  98. assert offset2.rollforward(d) == datetime(2014, 7, 1, 9)
  99. def testRollforward2(self, _offset):
  100. assert _offset(-3).rollforward(datetime(2014, 7, 5, 16, 0)) == datetime(
  101. 2014, 7, 7, 9
  102. )
  103. def test_roll_date_object(self):
  104. offset = BusinessHour()
  105. dt = datetime(2014, 7, 6, 15, 0)
  106. result = offset.rollback(dt)
  107. assert result == datetime(2014, 7, 4, 17)
  108. result = offset.rollforward(dt)
  109. assert result == datetime(2014, 7, 7, 9)
  110. normalize_cases = [
  111. (
  112. CustomBusinessHour(normalize=True, holidays=holidays),
  113. {
  114. datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
  115. datetime(2014, 7, 1, 17): datetime(2014, 7, 3),
  116. datetime(2014, 7, 1, 16): datetime(2014, 7, 3),
  117. datetime(2014, 7, 1, 23): datetime(2014, 7, 3),
  118. datetime(2014, 7, 1, 0): datetime(2014, 7, 1),
  119. datetime(2014, 7, 4, 15): datetime(2014, 7, 4),
  120. datetime(2014, 7, 4, 15, 59): datetime(2014, 7, 4),
  121. datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7),
  122. datetime(2014, 7, 5, 23): datetime(2014, 7, 7),
  123. datetime(2014, 7, 6, 10): datetime(2014, 7, 7),
  124. },
  125. ),
  126. (
  127. CustomBusinessHour(-1, normalize=True, holidays=holidays),
  128. {
  129. datetime(2014, 7, 1, 8): datetime(2014, 6, 26),
  130. datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
  131. datetime(2014, 7, 1, 16): datetime(2014, 7, 1),
  132. datetime(2014, 7, 1, 10): datetime(2014, 6, 26),
  133. datetime(2014, 7, 1, 0): datetime(2014, 6, 26),
  134. datetime(2014, 7, 7, 10): datetime(2014, 7, 4),
  135. datetime(2014, 7, 7, 10, 1): datetime(2014, 7, 7),
  136. datetime(2014, 7, 5, 23): datetime(2014, 7, 4),
  137. datetime(2014, 7, 6, 10): datetime(2014, 7, 4),
  138. },
  139. ),
  140. (
  141. CustomBusinessHour(
  142. 1, normalize=True, start="17:00", end="04:00", holidays=holidays
  143. ),
  144. {
  145. datetime(2014, 7, 1, 8): datetime(2014, 7, 1),
  146. datetime(2014, 7, 1, 17): datetime(2014, 7, 1),
  147. datetime(2014, 7, 1, 23): datetime(2014, 7, 2),
  148. datetime(2014, 7, 2, 2): datetime(2014, 7, 2),
  149. datetime(2014, 7, 2, 3): datetime(2014, 7, 3),
  150. datetime(2014, 7, 4, 23): datetime(2014, 7, 5),
  151. datetime(2014, 7, 5, 2): datetime(2014, 7, 5),
  152. datetime(2014, 7, 7, 2): datetime(2014, 7, 7),
  153. datetime(2014, 7, 7, 17): datetime(2014, 7, 7),
  154. },
  155. ),
  156. ]
  157. @pytest.mark.parametrize("norm_cases", normalize_cases)
  158. def test_normalize(self, norm_cases):
  159. offset, cases = norm_cases
  160. for dt, expected in cases.items():
  161. assert offset._apply(dt) == expected
  162. @pytest.mark.parametrize(
  163. "dt, expected",
  164. [
  165. [datetime(2014, 7, 1, 9), False],
  166. [datetime(2014, 7, 1, 10), True],
  167. [datetime(2014, 7, 1, 15), True],
  168. [datetime(2014, 7, 1, 15, 1), False],
  169. [datetime(2014, 7, 5, 12), False],
  170. [datetime(2014, 7, 6, 12), False],
  171. ],
  172. )
  173. def test_is_on_offset(self, dt, expected):
  174. offset = CustomBusinessHour(start="10:00", end="15:00", holidays=holidays)
  175. assert offset.is_on_offset(dt) == expected
  176. apply_cases = [
  177. (
  178. CustomBusinessHour(holidays=holidays),
  179. {
  180. datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 12),
  181. datetime(2014, 7, 1, 13): datetime(2014, 7, 1, 14),
  182. datetime(2014, 7, 1, 15): datetime(2014, 7, 1, 16),
  183. datetime(2014, 7, 1, 19): datetime(2014, 7, 3, 10),
  184. datetime(2014, 7, 1, 16): datetime(2014, 7, 3, 9),
  185. datetime(2014, 7, 1, 16, 30, 15): datetime(2014, 7, 3, 9, 30, 15),
  186. datetime(2014, 7, 1, 17): datetime(2014, 7, 3, 10),
  187. datetime(2014, 7, 2, 11): datetime(2014, 7, 3, 10),
  188. # out of business hours
  189. datetime(2014, 7, 2, 8): datetime(2014, 7, 3, 10),
  190. datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 10),
  191. datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 10),
  192. datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 10),
  193. # saturday
  194. datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 10),
  195. datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 10),
  196. datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 9, 30),
  197. datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 9, 30, 30),
  198. },
  199. ),
  200. (
  201. CustomBusinessHour(4, holidays=holidays),
  202. {
  203. datetime(2014, 7, 1, 11): datetime(2014, 7, 1, 15),
  204. datetime(2014, 7, 1, 13): datetime(2014, 7, 3, 9),
  205. datetime(2014, 7, 1, 15): datetime(2014, 7, 3, 11),
  206. datetime(2014, 7, 1, 16): datetime(2014, 7, 3, 12),
  207. datetime(2014, 7, 1, 17): datetime(2014, 7, 3, 13),
  208. datetime(2014, 7, 2, 11): datetime(2014, 7, 3, 13),
  209. datetime(2014, 7, 2, 8): datetime(2014, 7, 3, 13),
  210. datetime(2014, 7, 2, 19): datetime(2014, 7, 3, 13),
  211. datetime(2014, 7, 2, 23): datetime(2014, 7, 3, 13),
  212. datetime(2014, 7, 3, 0): datetime(2014, 7, 3, 13),
  213. datetime(2014, 7, 5, 15): datetime(2014, 7, 7, 13),
  214. datetime(2014, 7, 4, 17): datetime(2014, 7, 7, 13),
  215. datetime(2014, 7, 4, 16, 30): datetime(2014, 7, 7, 12, 30),
  216. datetime(2014, 7, 4, 16, 30, 30): datetime(2014, 7, 7, 12, 30, 30),
  217. },
  218. ),
  219. ]
  220. @pytest.mark.parametrize("apply_case", apply_cases)
  221. def test_apply(self, apply_case):
  222. offset, cases = apply_case
  223. for base, expected in cases.items():
  224. assert_offset_equal(offset, base, expected)
  225. nano_cases = [
  226. (
  227. CustomBusinessHour(holidays=holidays),
  228. {
  229. Timestamp("2014-07-01 15:00")
  230. + Nano(5): Timestamp("2014-07-01 16:00")
  231. + Nano(5),
  232. Timestamp("2014-07-01 16:00")
  233. + Nano(5): Timestamp("2014-07-03 09:00")
  234. + Nano(5),
  235. Timestamp("2014-07-01 16:00")
  236. - Nano(5): Timestamp("2014-07-01 17:00")
  237. - Nano(5),
  238. },
  239. ),
  240. (
  241. CustomBusinessHour(-1, holidays=holidays),
  242. {
  243. Timestamp("2014-07-01 15:00")
  244. + Nano(5): Timestamp("2014-07-01 14:00")
  245. + Nano(5),
  246. Timestamp("2014-07-01 10:00")
  247. + Nano(5): Timestamp("2014-07-01 09:00")
  248. + Nano(5),
  249. Timestamp("2014-07-01 10:00")
  250. - Nano(5): Timestamp("2014-06-26 17:00")
  251. - Nano(5),
  252. },
  253. ),
  254. ]
  255. @pytest.mark.parametrize("nano_case", nano_cases)
  256. def test_apply_nanoseconds(self, nano_case):
  257. offset, cases = nano_case
  258. for base, expected in cases.items():
  259. assert_offset_equal(offset, base, expected)
  260. def test_us_federal_holiday_with_datetime(self):
  261. # GH 16867
  262. bhour_us = CustomBusinessHour(calendar=USFederalHolidayCalendar())
  263. t0 = datetime(2014, 1, 17, 15)
  264. result = t0 + bhour_us * 8
  265. expected = Timestamp("2014-01-21 15:00:00")
  266. assert result == expected
  267. @pytest.mark.parametrize(
  268. "weekmask, expected_time, mult",
  269. [
  270. ["Mon Tue Wed Thu Fri Sat", "2018-11-10 09:00:00", 10],
  271. ["Tue Wed Thu Fri Sat", "2018-11-13 08:00:00", 18],
  272. ],
  273. )
  274. def test_custom_businesshour_weekmask_and_holidays(weekmask, expected_time, mult):
  275. # GH 23542
  276. holidays = ["2018-11-09"]
  277. bh = CustomBusinessHour(
  278. start="08:00", end="17:00", weekmask=weekmask, holidays=holidays
  279. )
  280. result = Timestamp("2018-11-08 08:00") + mult * bh
  281. expected = Timestamp(expected_time)
  282. assert result == expected