test_quarter.py 12 KB

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