test_quarter.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296
  1. """
  2. Tests for the following offsets:
  3. - QuarterBegin
  4. - QuarterEnd
  5. """
  6. from __future__ import annotations
  7. from datetime import datetime
  8. import pytest
  9. from pandas.tests.tseries.offsets.common import (
  10. assert_is_on_offset,
  11. assert_offset_equal,
  12. )
  13. from pandas.tseries.offsets import (
  14. QuarterBegin,
  15. QuarterEnd,
  16. )
  17. @pytest.mark.parametrize("klass", (QuarterBegin, QuarterEnd))
  18. def test_quarterly_dont_normalize(klass):
  19. date = datetime(2012, 3, 31, 5, 30)
  20. result = date + klass()
  21. assert result.time() == date.time()
  22. @pytest.mark.parametrize("offset", [QuarterBegin(), QuarterEnd()])
  23. @pytest.mark.parametrize(
  24. "date",
  25. [
  26. datetime(2016, m, d)
  27. for m in [10, 11, 12]
  28. for d in [1, 2, 3, 28, 29, 30, 31]
  29. if not (m == 11 and d == 31)
  30. ],
  31. )
  32. def test_on_offset(offset, date):
  33. res = offset.is_on_offset(date)
  34. slow_version = date == (date + offset) - offset
  35. assert res == slow_version
  36. class TestQuarterBegin:
  37. def test_repr(self):
  38. expected = "<QuarterBegin: startingMonth=3>"
  39. assert repr(QuarterBegin()) == expected
  40. expected = "<QuarterBegin: startingMonth=3>"
  41. assert repr(QuarterBegin(startingMonth=3)) == expected
  42. expected = "<QuarterBegin: startingMonth=1>"
  43. assert repr(QuarterBegin(startingMonth=1)) == expected
  44. def test_is_anchored(self):
  45. assert QuarterBegin(startingMonth=1).is_anchored()
  46. assert QuarterBegin().is_anchored()
  47. assert not QuarterBegin(2, startingMonth=1).is_anchored()
  48. def test_offset_corner_case(self):
  49. # corner
  50. offset = QuarterBegin(n=-1, startingMonth=1)
  51. assert datetime(2010, 2, 1) + offset == datetime(2010, 1, 1)
  52. offset_cases = []
  53. offset_cases.append(
  54. (
  55. QuarterBegin(startingMonth=1),
  56. {
  57. datetime(2007, 12, 1): datetime(2008, 1, 1),
  58. datetime(2008, 1, 1): datetime(2008, 4, 1),
  59. datetime(2008, 2, 15): datetime(2008, 4, 1),
  60. datetime(2008, 2, 29): datetime(2008, 4, 1),
  61. datetime(2008, 3, 15): datetime(2008, 4, 1),
  62. datetime(2008, 3, 31): datetime(2008, 4, 1),
  63. datetime(2008, 4, 15): datetime(2008, 7, 1),
  64. datetime(2008, 4, 1): datetime(2008, 7, 1),
  65. },
  66. )
  67. )
  68. offset_cases.append(
  69. (
  70. QuarterBegin(startingMonth=2),
  71. {
  72. datetime(2008, 1, 1): datetime(2008, 2, 1),
  73. datetime(2008, 1, 31): datetime(2008, 2, 1),
  74. datetime(2008, 1, 15): datetime(2008, 2, 1),
  75. datetime(2008, 2, 29): datetime(2008, 5, 1),
  76. datetime(2008, 3, 15): datetime(2008, 5, 1),
  77. datetime(2008, 3, 31): datetime(2008, 5, 1),
  78. datetime(2008, 4, 15): datetime(2008, 5, 1),
  79. datetime(2008, 4, 30): datetime(2008, 5, 1),
  80. },
  81. )
  82. )
  83. offset_cases.append(
  84. (
  85. QuarterBegin(startingMonth=1, n=0),
  86. {
  87. datetime(2008, 1, 1): datetime(2008, 1, 1),
  88. datetime(2008, 12, 1): datetime(2009, 1, 1),
  89. datetime(2008, 1, 1): datetime(2008, 1, 1),
  90. datetime(2008, 2, 15): datetime(2008, 4, 1),
  91. datetime(2008, 2, 29): datetime(2008, 4, 1),
  92. datetime(2008, 3, 15): datetime(2008, 4, 1),
  93. datetime(2008, 3, 31): datetime(2008, 4, 1),
  94. datetime(2008, 4, 15): datetime(2008, 7, 1),
  95. datetime(2008, 4, 30): datetime(2008, 7, 1),
  96. },
  97. )
  98. )
  99. offset_cases.append(
  100. (
  101. QuarterBegin(startingMonth=1, n=-1),
  102. {
  103. datetime(2008, 1, 1): datetime(2007, 10, 1),
  104. datetime(2008, 1, 31): datetime(2008, 1, 1),
  105. datetime(2008, 2, 15): datetime(2008, 1, 1),
  106. datetime(2008, 2, 29): datetime(2008, 1, 1),
  107. datetime(2008, 3, 15): datetime(2008, 1, 1),
  108. datetime(2008, 3, 31): datetime(2008, 1, 1),
  109. datetime(2008, 4, 15): datetime(2008, 4, 1),
  110. datetime(2008, 4, 30): datetime(2008, 4, 1),
  111. datetime(2008, 7, 1): datetime(2008, 4, 1),
  112. },
  113. )
  114. )
  115. offset_cases.append(
  116. (
  117. QuarterBegin(startingMonth=1, n=2),
  118. {
  119. datetime(2008, 1, 1): datetime(2008, 7, 1),
  120. datetime(2008, 2, 15): datetime(2008, 7, 1),
  121. datetime(2008, 2, 29): datetime(2008, 7, 1),
  122. datetime(2008, 3, 15): datetime(2008, 7, 1),
  123. datetime(2008, 3, 31): datetime(2008, 7, 1),
  124. datetime(2008, 4, 15): datetime(2008, 10, 1),
  125. datetime(2008, 4, 1): datetime(2008, 10, 1),
  126. },
  127. )
  128. )
  129. @pytest.mark.parametrize("case", offset_cases)
  130. def test_offset(self, case):
  131. offset, cases = case
  132. for base, expected in cases.items():
  133. assert_offset_equal(offset, base, expected)
  134. class TestQuarterEnd:
  135. def test_repr(self):
  136. expected = "<QuarterEnd: startingMonth=3>"
  137. assert repr(QuarterEnd()) == expected
  138. expected = "<QuarterEnd: startingMonth=3>"
  139. assert repr(QuarterEnd(startingMonth=3)) == expected
  140. expected = "<QuarterEnd: startingMonth=1>"
  141. assert repr(QuarterEnd(startingMonth=1)) == expected
  142. def test_is_anchored(self):
  143. assert QuarterEnd(startingMonth=1).is_anchored()
  144. assert QuarterEnd().is_anchored()
  145. assert not QuarterEnd(2, startingMonth=1).is_anchored()
  146. def test_offset_corner_case(self):
  147. # corner
  148. offset = QuarterEnd(n=-1, startingMonth=1)
  149. assert datetime(2010, 2, 1) + offset == datetime(2010, 1, 31)
  150. offset_cases = []
  151. offset_cases.append(
  152. (
  153. QuarterEnd(startingMonth=1),
  154. {
  155. datetime(2008, 1, 1): datetime(2008, 1, 31),
  156. datetime(2008, 1, 31): datetime(2008, 4, 30),
  157. datetime(2008, 2, 15): datetime(2008, 4, 30),
  158. datetime(2008, 2, 29): datetime(2008, 4, 30),
  159. datetime(2008, 3, 15): datetime(2008, 4, 30),
  160. datetime(2008, 3, 31): datetime(2008, 4, 30),
  161. datetime(2008, 4, 15): datetime(2008, 4, 30),
  162. datetime(2008, 4, 30): datetime(2008, 7, 31),
  163. },
  164. )
  165. )
  166. offset_cases.append(
  167. (
  168. QuarterEnd(startingMonth=2),
  169. {
  170. datetime(2008, 1, 1): datetime(2008, 2, 29),
  171. datetime(2008, 1, 31): datetime(2008, 2, 29),
  172. datetime(2008, 2, 15): datetime(2008, 2, 29),
  173. datetime(2008, 2, 29): datetime(2008, 5, 31),
  174. datetime(2008, 3, 15): datetime(2008, 5, 31),
  175. datetime(2008, 3, 31): datetime(2008, 5, 31),
  176. datetime(2008, 4, 15): datetime(2008, 5, 31),
  177. datetime(2008, 4, 30): datetime(2008, 5, 31),
  178. },
  179. )
  180. )
  181. offset_cases.append(
  182. (
  183. QuarterEnd(startingMonth=1, n=0),
  184. {
  185. datetime(2008, 1, 1): datetime(2008, 1, 31),
  186. datetime(2008, 1, 31): datetime(2008, 1, 31),
  187. datetime(2008, 2, 15): datetime(2008, 4, 30),
  188. datetime(2008, 2, 29): datetime(2008, 4, 30),
  189. datetime(2008, 3, 15): datetime(2008, 4, 30),
  190. datetime(2008, 3, 31): datetime(2008, 4, 30),
  191. datetime(2008, 4, 15): datetime(2008, 4, 30),
  192. datetime(2008, 4, 30): datetime(2008, 4, 30),
  193. },
  194. )
  195. )
  196. offset_cases.append(
  197. (
  198. QuarterEnd(startingMonth=1, n=-1),
  199. {
  200. datetime(2008, 1, 1): datetime(2007, 10, 31),
  201. datetime(2008, 1, 31): datetime(2007, 10, 31),
  202. datetime(2008, 2, 15): datetime(2008, 1, 31),
  203. datetime(2008, 2, 29): datetime(2008, 1, 31),
  204. datetime(2008, 3, 15): datetime(2008, 1, 31),
  205. datetime(2008, 3, 31): datetime(2008, 1, 31),
  206. datetime(2008, 4, 15): datetime(2008, 1, 31),
  207. datetime(2008, 4, 30): datetime(2008, 1, 31),
  208. datetime(2008, 7, 1): datetime(2008, 4, 30),
  209. },
  210. )
  211. )
  212. offset_cases.append(
  213. (
  214. QuarterEnd(startingMonth=1, n=2),
  215. {
  216. datetime(2008, 1, 31): datetime(2008, 7, 31),
  217. datetime(2008, 2, 15): datetime(2008, 7, 31),
  218. datetime(2008, 2, 29): datetime(2008, 7, 31),
  219. datetime(2008, 3, 15): datetime(2008, 7, 31),
  220. datetime(2008, 3, 31): datetime(2008, 7, 31),
  221. datetime(2008, 4, 15): datetime(2008, 7, 31),
  222. datetime(2008, 4, 30): datetime(2008, 10, 31),
  223. },
  224. )
  225. )
  226. @pytest.mark.parametrize("case", offset_cases)
  227. def test_offset(self, case):
  228. offset, cases = case
  229. for base, expected in cases.items():
  230. assert_offset_equal(offset, base, expected)
  231. on_offset_cases = [
  232. (QuarterEnd(1, startingMonth=1), datetime(2008, 1, 31), True),
  233. (QuarterEnd(1, startingMonth=1), datetime(2007, 12, 31), False),
  234. (QuarterEnd(1, startingMonth=1), datetime(2008, 2, 29), False),
  235. (QuarterEnd(1, startingMonth=1), datetime(2007, 3, 30), False),
  236. (QuarterEnd(1, startingMonth=1), datetime(2007, 3, 31), False),
  237. (QuarterEnd(1, startingMonth=1), datetime(2008, 4, 30), True),
  238. (QuarterEnd(1, startingMonth=1), datetime(2008, 5, 30), False),
  239. (QuarterEnd(1, startingMonth=1), datetime(2008, 5, 31), False),
  240. (QuarterEnd(1, startingMonth=1), datetime(2007, 6, 29), False),
  241. (QuarterEnd(1, startingMonth=1), datetime(2007, 6, 30), False),
  242. (QuarterEnd(1, startingMonth=2), datetime(2008, 1, 31), False),
  243. (QuarterEnd(1, startingMonth=2), datetime(2007, 12, 31), False),
  244. (QuarterEnd(1, startingMonth=2), datetime(2008, 2, 29), True),
  245. (QuarterEnd(1, startingMonth=2), datetime(2007, 3, 30), False),
  246. (QuarterEnd(1, startingMonth=2), datetime(2007, 3, 31), False),
  247. (QuarterEnd(1, startingMonth=2), datetime(2008, 4, 30), False),
  248. (QuarterEnd(1, startingMonth=2), datetime(2008, 5, 30), False),
  249. (QuarterEnd(1, startingMonth=2), datetime(2008, 5, 31), True),
  250. (QuarterEnd(1, startingMonth=2), datetime(2007, 6, 29), False),
  251. (QuarterEnd(1, startingMonth=2), datetime(2007, 6, 30), False),
  252. (QuarterEnd(1, startingMonth=3), datetime(2008, 1, 31), False),
  253. (QuarterEnd(1, startingMonth=3), datetime(2007, 12, 31), True),
  254. (QuarterEnd(1, startingMonth=3), datetime(2008, 2, 29), False),
  255. (QuarterEnd(1, startingMonth=3), datetime(2007, 3, 30), False),
  256. (QuarterEnd(1, startingMonth=3), datetime(2007, 3, 31), True),
  257. (QuarterEnd(1, startingMonth=3), datetime(2008, 4, 30), False),
  258. (QuarterEnd(1, startingMonth=3), datetime(2008, 5, 30), False),
  259. (QuarterEnd(1, startingMonth=3), datetime(2008, 5, 31), False),
  260. (QuarterEnd(1, startingMonth=3), datetime(2007, 6, 29), False),
  261. (QuarterEnd(1, startingMonth=3), datetime(2007, 6, 30), True),
  262. ]
  263. @pytest.mark.parametrize("case", on_offset_cases)
  264. def test_is_on_offset(self, case):
  265. offset, dt, expected = case
  266. assert_is_on_offset(offset, dt, expected)