test_fiscal.py 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652
  1. """
  2. Tests for Fiscal Year and Fiscal Quarter offset classes
  3. """
  4. from datetime import datetime
  5. from dateutil.relativedelta import relativedelta
  6. import pytest
  7. from pandas import Timestamp
  8. from pandas.tests.tseries.offsets.common import (
  9. WeekDay,
  10. assert_is_on_offset,
  11. assert_offset_equal,
  12. )
  13. from pandas.tseries.offsets import (
  14. FY5253,
  15. FY5253Quarter,
  16. )
  17. def makeFY5253LastOfMonthQuarter(*args, **kwds):
  18. return FY5253Quarter(*args, variation="last", **kwds)
  19. def makeFY5253NearestEndMonthQuarter(*args, **kwds):
  20. return FY5253Quarter(*args, variation="nearest", **kwds)
  21. def makeFY5253NearestEndMonth(*args, **kwds):
  22. return FY5253(*args, variation="nearest", **kwds)
  23. def makeFY5253LastOfMonth(*args, **kwds):
  24. return FY5253(*args, variation="last", **kwds)
  25. def test_get_offset_name():
  26. assert (
  27. makeFY5253LastOfMonthQuarter(
  28. weekday=1, startingMonth=3, qtr_with_extra_week=4
  29. ).freqstr
  30. == "REQ-L-MAR-TUE-4"
  31. )
  32. assert (
  33. makeFY5253NearestEndMonthQuarter(
  34. weekday=1, startingMonth=3, qtr_with_extra_week=3
  35. ).freqstr
  36. == "REQ-N-MAR-TUE-3"
  37. )
  38. class TestFY5253LastOfMonth:
  39. offset_lom_sat_aug = makeFY5253LastOfMonth(1, startingMonth=8, weekday=WeekDay.SAT)
  40. offset_lom_sat_sep = makeFY5253LastOfMonth(1, startingMonth=9, weekday=WeekDay.SAT)
  41. on_offset_cases = [
  42. # From Wikipedia (see:
  43. # https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar#Last_Saturday_of_the_month_at_fiscal_year_end)
  44. (offset_lom_sat_aug, datetime(2006, 8, 26), True),
  45. (offset_lom_sat_aug, datetime(2007, 8, 25), True),
  46. (offset_lom_sat_aug, datetime(2008, 8, 30), True),
  47. (offset_lom_sat_aug, datetime(2009, 8, 29), True),
  48. (offset_lom_sat_aug, datetime(2010, 8, 28), True),
  49. (offset_lom_sat_aug, datetime(2011, 8, 27), True),
  50. (offset_lom_sat_aug, datetime(2012, 8, 25), True),
  51. (offset_lom_sat_aug, datetime(2013, 8, 31), True),
  52. (offset_lom_sat_aug, datetime(2014, 8, 30), True),
  53. (offset_lom_sat_aug, datetime(2015, 8, 29), True),
  54. (offset_lom_sat_aug, datetime(2016, 8, 27), True),
  55. (offset_lom_sat_aug, datetime(2017, 8, 26), True),
  56. (offset_lom_sat_aug, datetime(2018, 8, 25), True),
  57. (offset_lom_sat_aug, datetime(2019, 8, 31), True),
  58. (offset_lom_sat_aug, datetime(2006, 8, 27), False),
  59. (offset_lom_sat_aug, datetime(2007, 8, 28), False),
  60. (offset_lom_sat_aug, datetime(2008, 8, 31), False),
  61. (offset_lom_sat_aug, datetime(2009, 8, 30), False),
  62. (offset_lom_sat_aug, datetime(2010, 8, 29), False),
  63. (offset_lom_sat_aug, datetime(2011, 8, 28), False),
  64. (offset_lom_sat_aug, datetime(2006, 8, 25), False),
  65. (offset_lom_sat_aug, datetime(2007, 8, 24), False),
  66. (offset_lom_sat_aug, datetime(2008, 8, 29), False),
  67. (offset_lom_sat_aug, datetime(2009, 8, 28), False),
  68. (offset_lom_sat_aug, datetime(2010, 8, 27), False),
  69. (offset_lom_sat_aug, datetime(2011, 8, 26), False),
  70. (offset_lom_sat_aug, datetime(2019, 8, 30), False),
  71. # From GMCR (see for example:
  72. # http://yahoo.brand.edgar-online.com/Default.aspx?
  73. # companyid=3184&formtypeID=7)
  74. (offset_lom_sat_sep, datetime(2010, 9, 25), True),
  75. (offset_lom_sat_sep, datetime(2011, 9, 24), True),
  76. (offset_lom_sat_sep, datetime(2012, 9, 29), True),
  77. ]
  78. @pytest.mark.parametrize("case", on_offset_cases)
  79. def test_is_on_offset(self, case):
  80. offset, dt, expected = case
  81. assert_is_on_offset(offset, dt, expected)
  82. def test_apply(self):
  83. offset_lom_aug_sat = makeFY5253LastOfMonth(startingMonth=8, weekday=WeekDay.SAT)
  84. offset_lom_aug_sat_1 = makeFY5253LastOfMonth(
  85. n=1, startingMonth=8, weekday=WeekDay.SAT
  86. )
  87. date_seq_lom_aug_sat = [
  88. datetime(2006, 8, 26),
  89. datetime(2007, 8, 25),
  90. datetime(2008, 8, 30),
  91. datetime(2009, 8, 29),
  92. datetime(2010, 8, 28),
  93. datetime(2011, 8, 27),
  94. datetime(2012, 8, 25),
  95. datetime(2013, 8, 31),
  96. datetime(2014, 8, 30),
  97. datetime(2015, 8, 29),
  98. datetime(2016, 8, 27),
  99. ]
  100. tests = [
  101. (offset_lom_aug_sat, date_seq_lom_aug_sat),
  102. (offset_lom_aug_sat_1, date_seq_lom_aug_sat),
  103. (offset_lom_aug_sat, [datetime(2006, 8, 25)] + date_seq_lom_aug_sat),
  104. (offset_lom_aug_sat_1, [datetime(2006, 8, 27)] + date_seq_lom_aug_sat[1:]),
  105. (
  106. makeFY5253LastOfMonth(n=-1, startingMonth=8, weekday=WeekDay.SAT),
  107. list(reversed(date_seq_lom_aug_sat)),
  108. ),
  109. ]
  110. for test in tests:
  111. offset, data = test
  112. current = data[0]
  113. for datum in data[1:]:
  114. current = current + offset
  115. assert current == datum
  116. class TestFY5253NearestEndMonth:
  117. def test_get_year_end(self):
  118. assert makeFY5253NearestEndMonth(
  119. startingMonth=8, weekday=WeekDay.SAT
  120. ).get_year_end(datetime(2013, 1, 1)) == datetime(2013, 8, 31)
  121. assert makeFY5253NearestEndMonth(
  122. startingMonth=8, weekday=WeekDay.SUN
  123. ).get_year_end(datetime(2013, 1, 1)) == datetime(2013, 9, 1)
  124. assert makeFY5253NearestEndMonth(
  125. startingMonth=8, weekday=WeekDay.FRI
  126. ).get_year_end(datetime(2013, 1, 1)) == datetime(2013, 8, 30)
  127. offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12, variation="nearest")
  128. assert offset_n.get_year_end(datetime(2012, 1, 1)) == datetime(2013, 1, 1)
  129. assert offset_n.get_year_end(datetime(2012, 1, 10)) == datetime(2013, 1, 1)
  130. assert offset_n.get_year_end(datetime(2013, 1, 1)) == datetime(2013, 12, 31)
  131. assert offset_n.get_year_end(datetime(2013, 1, 2)) == datetime(2013, 12, 31)
  132. assert offset_n.get_year_end(datetime(2013, 1, 3)) == datetime(2013, 12, 31)
  133. assert offset_n.get_year_end(datetime(2013, 1, 10)) == datetime(2013, 12, 31)
  134. JNJ = FY5253(n=1, startingMonth=12, weekday=6, variation="nearest")
  135. assert JNJ.get_year_end(datetime(2006, 1, 1)) == datetime(2006, 12, 31)
  136. offset_lom_aug_sat = makeFY5253NearestEndMonth(
  137. 1, startingMonth=8, weekday=WeekDay.SAT
  138. )
  139. offset_lom_aug_thu = makeFY5253NearestEndMonth(
  140. 1, startingMonth=8, weekday=WeekDay.THU
  141. )
  142. offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12, variation="nearest")
  143. on_offset_cases = [
  144. # From Wikipedia (see:
  145. # https://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar
  146. # #Saturday_nearest_the_end_of_month)
  147. # 2006-09-02 2006 September 2
  148. # 2007-09-01 2007 September 1
  149. # 2008-08-30 2008 August 30 (leap year)
  150. # 2009-08-29 2009 August 29
  151. # 2010-08-28 2010 August 28
  152. # 2011-09-03 2011 September 3
  153. # 2012-09-01 2012 September 1 (leap year)
  154. # 2013-08-31 2013 August 31
  155. # 2014-08-30 2014 August 30
  156. # 2015-08-29 2015 August 29
  157. # 2016-09-03 2016 September 3 (leap year)
  158. # 2017-09-02 2017 September 2
  159. # 2018-09-01 2018 September 1
  160. # 2019-08-31 2019 August 31
  161. (offset_lom_aug_sat, datetime(2006, 9, 2), True),
  162. (offset_lom_aug_sat, datetime(2007, 9, 1), True),
  163. (offset_lom_aug_sat, datetime(2008, 8, 30), True),
  164. (offset_lom_aug_sat, datetime(2009, 8, 29), True),
  165. (offset_lom_aug_sat, datetime(2010, 8, 28), True),
  166. (offset_lom_aug_sat, datetime(2011, 9, 3), True),
  167. (offset_lom_aug_sat, datetime(2016, 9, 3), True),
  168. (offset_lom_aug_sat, datetime(2017, 9, 2), True),
  169. (offset_lom_aug_sat, datetime(2018, 9, 1), True),
  170. (offset_lom_aug_sat, datetime(2019, 8, 31), True),
  171. (offset_lom_aug_sat, datetime(2006, 8, 27), False),
  172. (offset_lom_aug_sat, datetime(2007, 8, 28), False),
  173. (offset_lom_aug_sat, datetime(2008, 8, 31), False),
  174. (offset_lom_aug_sat, datetime(2009, 8, 30), False),
  175. (offset_lom_aug_sat, datetime(2010, 8, 29), False),
  176. (offset_lom_aug_sat, datetime(2011, 8, 28), False),
  177. (offset_lom_aug_sat, datetime(2006, 8, 25), False),
  178. (offset_lom_aug_sat, datetime(2007, 8, 24), False),
  179. (offset_lom_aug_sat, datetime(2008, 8, 29), False),
  180. (offset_lom_aug_sat, datetime(2009, 8, 28), False),
  181. (offset_lom_aug_sat, datetime(2010, 8, 27), False),
  182. (offset_lom_aug_sat, datetime(2011, 8, 26), False),
  183. (offset_lom_aug_sat, datetime(2019, 8, 30), False),
  184. # From Micron, see:
  185. # http://google.brand.edgar-online.com/?sym=MU&formtypeID=7
  186. (offset_lom_aug_thu, datetime(2012, 8, 30), True),
  187. (offset_lom_aug_thu, datetime(2011, 9, 1), True),
  188. (offset_n, datetime(2012, 12, 31), False),
  189. (offset_n, datetime(2013, 1, 1), True),
  190. (offset_n, datetime(2013, 1, 2), False),
  191. ]
  192. @pytest.mark.parametrize("case", on_offset_cases)
  193. def test_is_on_offset(self, case):
  194. offset, dt, expected = case
  195. assert_is_on_offset(offset, dt, expected)
  196. def test_apply(self):
  197. date_seq_nem_8_sat = [
  198. datetime(2006, 9, 2),
  199. datetime(2007, 9, 1),
  200. datetime(2008, 8, 30),
  201. datetime(2009, 8, 29),
  202. datetime(2010, 8, 28),
  203. datetime(2011, 9, 3),
  204. ]
  205. JNJ = [
  206. datetime(2005, 1, 2),
  207. datetime(2006, 1, 1),
  208. datetime(2006, 12, 31),
  209. datetime(2007, 12, 30),
  210. datetime(2008, 12, 28),
  211. datetime(2010, 1, 3),
  212. datetime(2011, 1, 2),
  213. datetime(2012, 1, 1),
  214. datetime(2012, 12, 30),
  215. ]
  216. DEC_SAT = FY5253(n=-1, startingMonth=12, weekday=5, variation="nearest")
  217. tests = [
  218. (
  219. makeFY5253NearestEndMonth(startingMonth=8, weekday=WeekDay.SAT),
  220. date_seq_nem_8_sat,
  221. ),
  222. (
  223. makeFY5253NearestEndMonth(n=1, startingMonth=8, weekday=WeekDay.SAT),
  224. date_seq_nem_8_sat,
  225. ),
  226. (
  227. makeFY5253NearestEndMonth(startingMonth=8, weekday=WeekDay.SAT),
  228. [datetime(2006, 9, 1)] + date_seq_nem_8_sat,
  229. ),
  230. (
  231. makeFY5253NearestEndMonth(n=1, startingMonth=8, weekday=WeekDay.SAT),
  232. [datetime(2006, 9, 3)] + date_seq_nem_8_sat[1:],
  233. ),
  234. (
  235. makeFY5253NearestEndMonth(n=-1, startingMonth=8, weekday=WeekDay.SAT),
  236. list(reversed(date_seq_nem_8_sat)),
  237. ),
  238. (
  239. makeFY5253NearestEndMonth(n=1, startingMonth=12, weekday=WeekDay.SUN),
  240. JNJ,
  241. ),
  242. (
  243. makeFY5253NearestEndMonth(n=-1, startingMonth=12, weekday=WeekDay.SUN),
  244. list(reversed(JNJ)),
  245. ),
  246. (
  247. makeFY5253NearestEndMonth(n=1, startingMonth=12, weekday=WeekDay.SUN),
  248. [datetime(2005, 1, 2), datetime(2006, 1, 1)],
  249. ),
  250. (
  251. makeFY5253NearestEndMonth(n=1, startingMonth=12, weekday=WeekDay.SUN),
  252. [datetime(2006, 1, 2), datetime(2006, 12, 31)],
  253. ),
  254. (DEC_SAT, [datetime(2013, 1, 15), datetime(2012, 12, 29)]),
  255. ]
  256. for test in tests:
  257. offset, data = test
  258. current = data[0]
  259. for datum in data[1:]:
  260. current = current + offset
  261. assert current == datum
  262. class TestFY5253LastOfMonthQuarter:
  263. def test_is_anchored(self):
  264. assert makeFY5253LastOfMonthQuarter(
  265. startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  266. ).is_anchored()
  267. assert makeFY5253LastOfMonthQuarter(
  268. weekday=WeekDay.SAT, startingMonth=3, qtr_with_extra_week=4
  269. ).is_anchored()
  270. assert not makeFY5253LastOfMonthQuarter(
  271. 2, startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  272. ).is_anchored()
  273. def test_equality(self):
  274. assert makeFY5253LastOfMonthQuarter(
  275. startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  276. ) == makeFY5253LastOfMonthQuarter(
  277. startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  278. )
  279. assert makeFY5253LastOfMonthQuarter(
  280. startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  281. ) != makeFY5253LastOfMonthQuarter(
  282. startingMonth=1, weekday=WeekDay.SUN, qtr_with_extra_week=4
  283. )
  284. assert makeFY5253LastOfMonthQuarter(
  285. startingMonth=1, weekday=WeekDay.SAT, qtr_with_extra_week=4
  286. ) != makeFY5253LastOfMonthQuarter(
  287. startingMonth=2, weekday=WeekDay.SAT, qtr_with_extra_week=4
  288. )
  289. def test_offset(self):
  290. offset = makeFY5253LastOfMonthQuarter(
  291. 1, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  292. )
  293. offset2 = makeFY5253LastOfMonthQuarter(
  294. 2, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  295. )
  296. offset4 = makeFY5253LastOfMonthQuarter(
  297. 4, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  298. )
  299. offset_neg1 = makeFY5253LastOfMonthQuarter(
  300. -1, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  301. )
  302. offset_neg2 = makeFY5253LastOfMonthQuarter(
  303. -2, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  304. )
  305. GMCR = [
  306. datetime(2010, 3, 27),
  307. datetime(2010, 6, 26),
  308. datetime(2010, 9, 25),
  309. datetime(2010, 12, 25),
  310. datetime(2011, 3, 26),
  311. datetime(2011, 6, 25),
  312. datetime(2011, 9, 24),
  313. datetime(2011, 12, 24),
  314. datetime(2012, 3, 24),
  315. datetime(2012, 6, 23),
  316. datetime(2012, 9, 29),
  317. datetime(2012, 12, 29),
  318. datetime(2013, 3, 30),
  319. datetime(2013, 6, 29),
  320. ]
  321. assert_offset_equal(offset, base=GMCR[0], expected=GMCR[1])
  322. assert_offset_equal(
  323. offset, base=GMCR[0] + relativedelta(days=-1), expected=GMCR[0]
  324. )
  325. assert_offset_equal(offset, base=GMCR[1], expected=GMCR[2])
  326. assert_offset_equal(offset2, base=GMCR[0], expected=GMCR[2])
  327. assert_offset_equal(offset4, base=GMCR[0], expected=GMCR[4])
  328. assert_offset_equal(offset_neg1, base=GMCR[-1], expected=GMCR[-2])
  329. assert_offset_equal(
  330. offset_neg1, base=GMCR[-1] + relativedelta(days=+1), expected=GMCR[-1]
  331. )
  332. assert_offset_equal(offset_neg2, base=GMCR[-1], expected=GMCR[-3])
  333. date = GMCR[0] + relativedelta(days=-1)
  334. for expected in GMCR:
  335. assert_offset_equal(offset, date, expected)
  336. date = date + offset
  337. date = GMCR[-1] + relativedelta(days=+1)
  338. for expected in reversed(GMCR):
  339. assert_offset_equal(offset_neg1, date, expected)
  340. date = date + offset_neg1
  341. lomq_aug_sat_4 = makeFY5253LastOfMonthQuarter(
  342. 1, startingMonth=8, weekday=WeekDay.SAT, qtr_with_extra_week=4
  343. )
  344. lomq_sep_sat_4 = makeFY5253LastOfMonthQuarter(
  345. 1, startingMonth=9, weekday=WeekDay.SAT, qtr_with_extra_week=4
  346. )
  347. on_offset_cases = [
  348. # From Wikipedia
  349. (lomq_aug_sat_4, datetime(2006, 8, 26), True),
  350. (lomq_aug_sat_4, datetime(2007, 8, 25), True),
  351. (lomq_aug_sat_4, datetime(2008, 8, 30), True),
  352. (lomq_aug_sat_4, datetime(2009, 8, 29), True),
  353. (lomq_aug_sat_4, datetime(2010, 8, 28), True),
  354. (lomq_aug_sat_4, datetime(2011, 8, 27), True),
  355. (lomq_aug_sat_4, datetime(2019, 8, 31), True),
  356. (lomq_aug_sat_4, datetime(2006, 8, 27), False),
  357. (lomq_aug_sat_4, datetime(2007, 8, 28), False),
  358. (lomq_aug_sat_4, datetime(2008, 8, 31), False),
  359. (lomq_aug_sat_4, datetime(2009, 8, 30), False),
  360. (lomq_aug_sat_4, datetime(2010, 8, 29), False),
  361. (lomq_aug_sat_4, datetime(2011, 8, 28), False),
  362. (lomq_aug_sat_4, datetime(2006, 8, 25), False),
  363. (lomq_aug_sat_4, datetime(2007, 8, 24), False),
  364. (lomq_aug_sat_4, datetime(2008, 8, 29), False),
  365. (lomq_aug_sat_4, datetime(2009, 8, 28), False),
  366. (lomq_aug_sat_4, datetime(2010, 8, 27), False),
  367. (lomq_aug_sat_4, datetime(2011, 8, 26), False),
  368. (lomq_aug_sat_4, datetime(2019, 8, 30), False),
  369. # From GMCR
  370. (lomq_sep_sat_4, datetime(2010, 9, 25), True),
  371. (lomq_sep_sat_4, datetime(2011, 9, 24), True),
  372. (lomq_sep_sat_4, datetime(2012, 9, 29), True),
  373. (lomq_sep_sat_4, datetime(2013, 6, 29), True),
  374. (lomq_sep_sat_4, datetime(2012, 6, 23), True),
  375. (lomq_sep_sat_4, datetime(2012, 6, 30), False),
  376. (lomq_sep_sat_4, datetime(2013, 3, 30), True),
  377. (lomq_sep_sat_4, datetime(2012, 3, 24), True),
  378. (lomq_sep_sat_4, datetime(2012, 12, 29), True),
  379. (lomq_sep_sat_4, datetime(2011, 12, 24), True),
  380. # INTC (extra week in Q1)
  381. # See: http://www.intc.com/releasedetail.cfm?ReleaseID=542844
  382. (
  383. makeFY5253LastOfMonthQuarter(
  384. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  385. ),
  386. datetime(2011, 4, 2),
  387. True,
  388. ),
  389. # see: http://google.brand.edgar-online.com/?sym=INTC&formtypeID=7
  390. (
  391. makeFY5253LastOfMonthQuarter(
  392. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  393. ),
  394. datetime(2012, 12, 29),
  395. True,
  396. ),
  397. (
  398. makeFY5253LastOfMonthQuarter(
  399. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  400. ),
  401. datetime(2011, 12, 31),
  402. True,
  403. ),
  404. (
  405. makeFY5253LastOfMonthQuarter(
  406. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  407. ),
  408. datetime(2010, 12, 25),
  409. True,
  410. ),
  411. ]
  412. @pytest.mark.parametrize("case", on_offset_cases)
  413. def test_is_on_offset(self, case):
  414. offset, dt, expected = case
  415. assert_is_on_offset(offset, dt, expected)
  416. def test_year_has_extra_week(self):
  417. # End of long Q1
  418. assert makeFY5253LastOfMonthQuarter(
  419. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  420. ).year_has_extra_week(datetime(2011, 4, 2))
  421. # Start of long Q1
  422. assert makeFY5253LastOfMonthQuarter(
  423. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  424. ).year_has_extra_week(datetime(2010, 12, 26))
  425. # End of year before year with long Q1
  426. assert not makeFY5253LastOfMonthQuarter(
  427. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  428. ).year_has_extra_week(datetime(2010, 12, 25))
  429. for year in [
  430. x for x in range(1994, 2011 + 1) if x not in [2011, 2005, 2000, 1994]
  431. ]:
  432. assert not makeFY5253LastOfMonthQuarter(
  433. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  434. ).year_has_extra_week(datetime(year, 4, 2))
  435. # Other long years
  436. assert makeFY5253LastOfMonthQuarter(
  437. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  438. ).year_has_extra_week(datetime(2005, 4, 2))
  439. assert makeFY5253LastOfMonthQuarter(
  440. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  441. ).year_has_extra_week(datetime(2000, 4, 2))
  442. assert makeFY5253LastOfMonthQuarter(
  443. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  444. ).year_has_extra_week(datetime(1994, 4, 2))
  445. def test_get_weeks(self):
  446. sat_dec_1 = makeFY5253LastOfMonthQuarter(
  447. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=1
  448. )
  449. sat_dec_4 = makeFY5253LastOfMonthQuarter(
  450. 1, startingMonth=12, weekday=WeekDay.SAT, qtr_with_extra_week=4
  451. )
  452. assert sat_dec_1.get_weeks(datetime(2011, 4, 2)) == [14, 13, 13, 13]
  453. assert sat_dec_4.get_weeks(datetime(2011, 4, 2)) == [13, 13, 13, 14]
  454. assert sat_dec_1.get_weeks(datetime(2010, 12, 25)) == [13, 13, 13, 13]
  455. class TestFY5253NearestEndMonthQuarter:
  456. offset_nem_sat_aug_4 = makeFY5253NearestEndMonthQuarter(
  457. 1, startingMonth=8, weekday=WeekDay.SAT, qtr_with_extra_week=4
  458. )
  459. offset_nem_thu_aug_4 = makeFY5253NearestEndMonthQuarter(
  460. 1, startingMonth=8, weekday=WeekDay.THU, qtr_with_extra_week=4
  461. )
  462. offset_n = FY5253(weekday=WeekDay.TUE, startingMonth=12, variation="nearest")
  463. on_offset_cases = [
  464. # From Wikipedia
  465. (offset_nem_sat_aug_4, datetime(2006, 9, 2), True),
  466. (offset_nem_sat_aug_4, datetime(2007, 9, 1), True),
  467. (offset_nem_sat_aug_4, datetime(2008, 8, 30), True),
  468. (offset_nem_sat_aug_4, datetime(2009, 8, 29), True),
  469. (offset_nem_sat_aug_4, datetime(2010, 8, 28), True),
  470. (offset_nem_sat_aug_4, datetime(2011, 9, 3), True),
  471. (offset_nem_sat_aug_4, datetime(2016, 9, 3), True),
  472. (offset_nem_sat_aug_4, datetime(2017, 9, 2), True),
  473. (offset_nem_sat_aug_4, datetime(2018, 9, 1), True),
  474. (offset_nem_sat_aug_4, datetime(2019, 8, 31), True),
  475. (offset_nem_sat_aug_4, datetime(2006, 8, 27), False),
  476. (offset_nem_sat_aug_4, datetime(2007, 8, 28), False),
  477. (offset_nem_sat_aug_4, datetime(2008, 8, 31), False),
  478. (offset_nem_sat_aug_4, datetime(2009, 8, 30), False),
  479. (offset_nem_sat_aug_4, datetime(2010, 8, 29), False),
  480. (offset_nem_sat_aug_4, datetime(2011, 8, 28), False),
  481. (offset_nem_sat_aug_4, datetime(2006, 8, 25), False),
  482. (offset_nem_sat_aug_4, datetime(2007, 8, 24), False),
  483. (offset_nem_sat_aug_4, datetime(2008, 8, 29), False),
  484. (offset_nem_sat_aug_4, datetime(2009, 8, 28), False),
  485. (offset_nem_sat_aug_4, datetime(2010, 8, 27), False),
  486. (offset_nem_sat_aug_4, datetime(2011, 8, 26), False),
  487. (offset_nem_sat_aug_4, datetime(2019, 8, 30), False),
  488. # From Micron, see:
  489. # http://google.brand.edgar-online.com/?sym=MU&formtypeID=7
  490. (offset_nem_thu_aug_4, datetime(2012, 8, 30), True),
  491. (offset_nem_thu_aug_4, datetime(2011, 9, 1), True),
  492. # See: http://google.brand.edgar-online.com/?sym=MU&formtypeID=13
  493. (offset_nem_thu_aug_4, datetime(2013, 5, 30), True),
  494. (offset_nem_thu_aug_4, datetime(2013, 2, 28), True),
  495. (offset_nem_thu_aug_4, datetime(2012, 11, 29), True),
  496. (offset_nem_thu_aug_4, datetime(2012, 5, 31), True),
  497. (offset_nem_thu_aug_4, datetime(2007, 3, 1), True),
  498. (offset_nem_thu_aug_4, datetime(1994, 3, 3), True),
  499. (offset_n, datetime(2012, 12, 31), False),
  500. (offset_n, datetime(2013, 1, 1), True),
  501. (offset_n, datetime(2013, 1, 2), False),
  502. ]
  503. @pytest.mark.parametrize("case", on_offset_cases)
  504. def test_is_on_offset(self, case):
  505. offset, dt, expected = case
  506. assert_is_on_offset(offset, dt, expected)
  507. def test_offset(self):
  508. offset = makeFY5253NearestEndMonthQuarter(
  509. 1, startingMonth=8, weekday=WeekDay.THU, qtr_with_extra_week=4
  510. )
  511. MU = [
  512. datetime(2012, 5, 31),
  513. datetime(2012, 8, 30),
  514. datetime(2012, 11, 29),
  515. datetime(2013, 2, 28),
  516. datetime(2013, 5, 30),
  517. ]
  518. date = MU[0] + relativedelta(days=-1)
  519. for expected in MU:
  520. assert_offset_equal(offset, date, expected)
  521. date = date + offset
  522. assert_offset_equal(offset, datetime(2012, 5, 31), datetime(2012, 8, 30))
  523. assert_offset_equal(offset, datetime(2012, 5, 30), datetime(2012, 5, 31))
  524. offset2 = FY5253Quarter(
  525. weekday=5, startingMonth=12, variation="last", qtr_with_extra_week=4
  526. )
  527. assert_offset_equal(offset2, datetime(2013, 1, 15), datetime(2013, 3, 30))
  528. def test_bunched_yearends():
  529. # GH#14774 cases with two fiscal year-ends in the same calendar-year
  530. fy = FY5253(n=1, weekday=5, startingMonth=12, variation="nearest")
  531. dt = Timestamp("2004-01-01")
  532. assert fy.rollback(dt) == Timestamp("2002-12-28")
  533. assert (-fy)._apply(dt) == Timestamp("2002-12-28")
  534. assert dt - fy == Timestamp("2002-12-28")
  535. assert fy.rollforward(dt) == Timestamp("2004-01-03")
  536. assert fy._apply(dt) == Timestamp("2004-01-03")
  537. assert fy + dt == Timestamp("2004-01-03")
  538. assert dt + fy == Timestamp("2004-01-03")
  539. # Same thing, but starting from a Timestamp in the previous year.
  540. dt = Timestamp("2003-12-31")
  541. assert fy.rollback(dt) == Timestamp("2002-12-28")
  542. assert (-fy)._apply(dt) == Timestamp("2002-12-28")
  543. assert dt - fy == Timestamp("2002-12-28")
  544. def test_fy5253_last_onoffset():
  545. # GH#18877 dates on the year-end but not normalized to midnight
  546. offset = FY5253(n=-5, startingMonth=5, variation="last", weekday=0)
  547. ts = Timestamp("1984-05-28 06:29:43.955911354+0200", tz="Europe/San_Marino")
  548. fast = offset.is_on_offset(ts)
  549. slow = (ts + offset) - offset == ts
  550. assert fast == slow
  551. def test_fy5253_nearest_onoffset():
  552. # GH#18877 dates on the year-end but not normalized to midnight
  553. offset = FY5253(n=3, startingMonth=7, variation="nearest", weekday=2)
  554. ts = Timestamp("2032-07-28 00:12:59.035729419+0000", tz="Africa/Dakar")
  555. fast = offset.is_on_offset(ts)
  556. slow = (ts + offset) - offset == ts
  557. assert fast == slow
  558. def test_fy5253qtr_onoffset_nearest():
  559. # GH#19036
  560. ts = Timestamp("1985-09-02 23:57:46.232550356-0300", tz="Atlantic/Bermuda")
  561. offset = FY5253Quarter(
  562. n=3, qtr_with_extra_week=1, startingMonth=2, variation="nearest", weekday=0
  563. )
  564. fast = offset.is_on_offset(ts)
  565. slow = (ts + offset) - offset == ts
  566. assert fast == slow
  567. def test_fy5253qtr_onoffset_last():
  568. # GH#19036
  569. offset = FY5253Quarter(
  570. n=-2, qtr_with_extra_week=1, startingMonth=7, variation="last", weekday=2
  571. )
  572. ts = Timestamp("2011-01-26 19:03:40.331096129+0200", tz="Africa/Windhoek")
  573. slow = (ts + offset) - offset == ts
  574. fast = offset.is_on_offset(ts)
  575. assert fast == slow