""" test date_range, bdate_range construction from the convenience range functions """ from datetime import ( datetime, time, timedelta, ) import numpy as np import pytest import pytz from pytz import timezone from pandas._libs.tslibs import timezones from pandas._libs.tslibs.offsets import ( BDay, CDay, DateOffset, MonthEnd, prefix_mapping, ) from pandas.errors import OutOfBoundsDatetime import pandas.util._test_decorators as td import pandas as pd from pandas import ( DataFrame, DatetimeIndex, Series, Timedelta, Timestamp, bdate_range, date_range, offsets, ) import pandas._testing as tm from pandas.core.arrays.datetimes import _generate_range as generate_range START, END = datetime(2009, 1, 1), datetime(2010, 1, 1) def _get_expected_range( begin_to_match, end_to_match, both_range, inclusive_endpoints, ): """Helper to get expected range from a both inclusive range""" left_match = begin_to_match == both_range[0] right_match = end_to_match == both_range[-1] if inclusive_endpoints == "left" and right_match: expected_range = both_range[:-1] elif inclusive_endpoints == "right" and left_match: expected_range = both_range[1:] elif inclusive_endpoints == "neither" and left_match and right_match: expected_range = both_range[1:-1] elif inclusive_endpoints == "neither" and right_match: expected_range = both_range[:-1] elif inclusive_endpoints == "neither" and left_match: expected_range = both_range[1:] elif inclusive_endpoints == "both": expected_range = both_range[:] else: expected_range = both_range[:] return expected_range class TestTimestampEquivDateRange: # Older tests in TestTimeSeries constructed their `stamp` objects # using `date_range` instead of the `Timestamp` constructor. # TestTimestampEquivDateRange checks that these are equivalent in the # pertinent cases. def test_date_range_timestamp_equiv(self): rng = date_range("20090415", "20090519", tz="US/Eastern") stamp = rng[0] ts = Timestamp("20090415", tz="US/Eastern") assert ts == stamp def test_date_range_timestamp_equiv_dateutil(self): rng = date_range("20090415", "20090519", tz="dateutil/US/Eastern") stamp = rng[0] ts = Timestamp("20090415", tz="dateutil/US/Eastern") assert ts == stamp def test_date_range_timestamp_equiv_explicit_pytz(self): rng = date_range("20090415", "20090519", tz=pytz.timezone("US/Eastern")) stamp = rng[0] ts = Timestamp("20090415", tz=pytz.timezone("US/Eastern")) assert ts == stamp @td.skip_if_windows def test_date_range_timestamp_equiv_explicit_dateutil(self): from pandas._libs.tslibs.timezones import dateutil_gettz as gettz rng = date_range("20090415", "20090519", tz=gettz("US/Eastern")) stamp = rng[0] ts = Timestamp("20090415", tz=gettz("US/Eastern")) assert ts == stamp def test_date_range_timestamp_equiv_from_datetime_instance(self): datetime_instance = datetime(2014, 3, 4) # build a timestamp with a frequency, since then it supports # addition/subtraction of integers timestamp_instance = date_range(datetime_instance, periods=1, freq="D")[0] ts = Timestamp(datetime_instance) assert ts == timestamp_instance def test_date_range_timestamp_equiv_preserve_frequency(self): timestamp_instance = date_range("2014-03-05", periods=1, freq="D")[0] ts = Timestamp("2014-03-05") assert timestamp_instance == ts class TestDateRanges: @pytest.mark.parametrize("freq", ["N", "U", "L", "T", "S", "H", "D"]) def test_date_range_edges(self, freq): # GH#13672 td = Timedelta(f"1{freq}") ts = Timestamp("1970-01-01") idx = date_range( start=ts + td, end=ts + 4 * td, freq=freq, ) exp = DatetimeIndex( [ts + n * td for n in range(1, 5)], freq=freq, ) tm.assert_index_equal(idx, exp) # start after end idx = date_range( start=ts + 4 * td, end=ts + td, freq=freq, ) exp = DatetimeIndex([], freq=freq) tm.assert_index_equal(idx, exp) # start matches end idx = date_range( start=ts + td, end=ts + td, freq=freq, ) exp = DatetimeIndex([ts + td], freq=freq) tm.assert_index_equal(idx, exp) def test_date_range_near_implementation_bound(self): # GH#??? freq = Timedelta(1) with pytest.raises(OutOfBoundsDatetime, match="Cannot generate range with"): date_range(end=Timestamp.min, periods=2, freq=freq) def test_date_range_nat(self): # GH#11587 msg = "Neither `start` nor `end` can be NaT" with pytest.raises(ValueError, match=msg): date_range(start="2016-01-01", end=pd.NaT, freq="D") with pytest.raises(ValueError, match=msg): date_range(start=pd.NaT, end="2016-01-01", freq="D") def test_date_range_multiplication_overflow(self): # GH#24255 # check that overflows in calculating `addend = periods * stride` # are caught with tm.assert_produces_warning(None): # we should _not_ be seeing a overflow RuntimeWarning dti = date_range(start="1677-09-22", periods=213503, freq="D") assert dti[0] == Timestamp("1677-09-22") assert len(dti) == 213503 msg = "Cannot generate range with" with pytest.raises(OutOfBoundsDatetime, match=msg): date_range("1969-05-04", periods=200000000, freq="30000D") def test_date_range_unsigned_overflow_handling(self): # GH#24255 # case where `addend = periods * stride` overflows int64 bounds # but not uint64 bounds dti = date_range(start="1677-09-22", end="2262-04-11", freq="D") dti2 = date_range(start=dti[0], periods=len(dti), freq="D") assert dti2.equals(dti) dti3 = date_range(end=dti[-1], periods=len(dti), freq="D") assert dti3.equals(dti) def test_date_range_int64_overflow_non_recoverable(self): # GH#24255 # case with start later than 1970-01-01, overflow int64 but not uint64 msg = "Cannot generate range with" with pytest.raises(OutOfBoundsDatetime, match=msg): date_range(start="1970-02-01", periods=106752 * 24, freq="H") # case with end before 1970-01-01, overflow int64 but not uint64 with pytest.raises(OutOfBoundsDatetime, match=msg): date_range(end="1969-11-14", periods=106752 * 24, freq="H") @pytest.mark.slow @pytest.mark.parametrize( "s_ts, e_ts", [("2262-02-23", "1969-11-14"), ("1970-02-01", "1677-10-22")] ) def test_date_range_int64_overflow_stride_endpoint_different_signs( self, s_ts, e_ts ): # cases where stride * periods overflow int64 and stride/endpoint # have different signs start = Timestamp(s_ts) end = Timestamp(e_ts) expected = date_range(start=start, end=end, freq="-1H") assert expected[0] == start assert expected[-1] == end dti = date_range(end=end, periods=len(expected), freq="-1H") tm.assert_index_equal(dti, expected) def test_date_range_out_of_bounds(self): # GH#14187 msg = "Cannot generate range" with pytest.raises(OutOfBoundsDatetime, match=msg): date_range("2016-01-01", periods=100000, freq="D") with pytest.raises(OutOfBoundsDatetime, match=msg): date_range(end="1763-10-12", periods=100000, freq="D") def test_date_range_gen_error(self): rng = date_range("1/1/2000 00:00", "1/1/2000 00:18", freq="5min") assert len(rng) == 4 @pytest.mark.parametrize("freq", ["AS", "YS"]) def test_begin_year_alias(self, freq): # see gh-9313 rng = date_range("1/1/2013", "7/1/2017", freq=freq) exp = DatetimeIndex( ["2013-01-01", "2014-01-01", "2015-01-01", "2016-01-01", "2017-01-01"], freq=freq, ) tm.assert_index_equal(rng, exp) @pytest.mark.parametrize("freq", ["A", "Y"]) def test_end_year_alias(self, freq): # see gh-9313 rng = date_range("1/1/2013", "7/1/2017", freq=freq) exp = DatetimeIndex( ["2013-12-31", "2014-12-31", "2015-12-31", "2016-12-31"], freq=freq ) tm.assert_index_equal(rng, exp) @pytest.mark.parametrize("freq", ["BA", "BY"]) def test_business_end_year_alias(self, freq): # see gh-9313 rng = date_range("1/1/2013", "7/1/2017", freq=freq) exp = DatetimeIndex( ["2013-12-31", "2014-12-31", "2015-12-31", "2016-12-30"], freq=freq ) tm.assert_index_equal(rng, exp) def test_date_range_negative_freq(self): # GH 11018 rng = date_range("2011-12-31", freq="-2A", periods=3) exp = DatetimeIndex(["2011-12-31", "2009-12-31", "2007-12-31"], freq="-2A") tm.assert_index_equal(rng, exp) assert rng.freq == "-2A" rng = date_range("2011-01-31", freq="-2M", periods=3) exp = DatetimeIndex(["2011-01-31", "2010-11-30", "2010-09-30"], freq="-2M") tm.assert_index_equal(rng, exp) assert rng.freq == "-2M" def test_date_range_bms_bug(self): # #1645 rng = date_range("1/1/2000", periods=10, freq="BMS") ex_first = Timestamp("2000-01-03") assert rng[0] == ex_first def test_date_range_normalize(self): snap = datetime.today() n = 50 rng = date_range(snap, periods=n, normalize=False, freq="2D") offset = timedelta(2) values = DatetimeIndex([snap + i * offset for i in range(n)], freq=offset) tm.assert_index_equal(rng, values) rng = date_range("1/1/2000 08:15", periods=n, normalize=False, freq="B") the_time = time(8, 15) for val in rng: assert val.time() == the_time def test_date_range_fy5252(self): dr = date_range( start="2013-01-01", periods=2, freq=offsets.FY5253(startingMonth=1, weekday=3, variation="nearest"), ) assert dr[0] == Timestamp("2013-01-31") assert dr[1] == Timestamp("2014-01-30") def test_date_range_ambiguous_arguments(self): # #2538 start = datetime(2011, 1, 1, 5, 3, 40) end = datetime(2011, 1, 1, 8, 9, 40) msg = ( "Of the four parameters: start, end, periods, and " "freq, exactly three must be specified" ) with pytest.raises(ValueError, match=msg): date_range(start, end, periods=10, freq="s") def test_date_range_convenience_periods(self): # GH 20808 result = date_range("2018-04-24", "2018-04-27", periods=3) expected = DatetimeIndex( ["2018-04-24 00:00:00", "2018-04-25 12:00:00", "2018-04-27 00:00:00"], freq=None, ) tm.assert_index_equal(result, expected) # Test if spacing remains linear if tz changes to dst in range result = date_range( "2018-04-01 01:00:00", "2018-04-01 04:00:00", tz="Australia/Sydney", periods=3, ) expected = DatetimeIndex( [ Timestamp("2018-04-01 01:00:00+1100", tz="Australia/Sydney"), Timestamp("2018-04-01 02:00:00+1000", tz="Australia/Sydney"), Timestamp("2018-04-01 04:00:00+1000", tz="Australia/Sydney"), ] ) tm.assert_index_equal(result, expected) def test_date_range_index_comparison(self): rng = date_range("2011-01-01", periods=3, tz="US/Eastern") df = Series(rng).to_frame() arr = np.array([rng.to_list()]).T arr2 = np.array([rng]).T with pytest.raises(ValueError, match="Unable to coerce to Series"): rng == df with pytest.raises(ValueError, match="Unable to coerce to Series"): df == rng expected = DataFrame([True, True, True]) results = df == arr2 tm.assert_frame_equal(results, expected) expected = Series([True, True, True], name=0) results = df[0] == arr2[:, 0] tm.assert_series_equal(results, expected) expected = np.array( [[True, False, False], [False, True, False], [False, False, True]] ) results = rng == arr tm.assert_numpy_array_equal(results, expected) @pytest.mark.parametrize( "start,end,result_tz", [ ["20180101", "20180103", "US/Eastern"], [datetime(2018, 1, 1), datetime(2018, 1, 3), "US/Eastern"], [Timestamp("20180101"), Timestamp("20180103"), "US/Eastern"], [ Timestamp("20180101", tz="US/Eastern"), Timestamp("20180103", tz="US/Eastern"), "US/Eastern", ], [ Timestamp("20180101", tz="US/Eastern"), Timestamp("20180103", tz="US/Eastern"), None, ], ], ) def test_date_range_linspacing_tz(self, start, end, result_tz): # GH 20983 result = date_range(start, end, periods=3, tz=result_tz) expected = date_range("20180101", periods=3, freq="D", tz="US/Eastern") tm.assert_index_equal(result, expected) def test_date_range_businesshour(self): idx = DatetimeIndex( [ "2014-07-04 09:00", "2014-07-04 10:00", "2014-07-04 11:00", "2014-07-04 12:00", "2014-07-04 13:00", "2014-07-04 14:00", "2014-07-04 15:00", "2014-07-04 16:00", ], freq="BH", ) rng = date_range("2014-07-04 09:00", "2014-07-04 16:00", freq="BH") tm.assert_index_equal(idx, rng) idx = DatetimeIndex(["2014-07-04 16:00", "2014-07-07 09:00"], freq="BH") rng = date_range("2014-07-04 16:00", "2014-07-07 09:00", freq="BH") tm.assert_index_equal(idx, rng) idx = DatetimeIndex( [ "2014-07-04 09:00", "2014-07-04 10:00", "2014-07-04 11:00", "2014-07-04 12:00", "2014-07-04 13:00", "2014-07-04 14:00", "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", "2014-07-08 11:00", "2014-07-08 12:00", "2014-07-08 13:00", "2014-07-08 14:00", "2014-07-08 15:00", "2014-07-08 16:00", ], freq="BH", ) rng = date_range("2014-07-04 09:00", "2014-07-08 16:00", freq="BH") tm.assert_index_equal(idx, rng) def test_date_range_timedelta(self): start = "2020-01-01" end = "2020-01-11" rng1 = date_range(start, end, freq="3D") rng2 = date_range(start, end, freq=timedelta(days=3)) tm.assert_index_equal(rng1, rng2) def test_range_misspecified(self): # GH #1095 msg = ( "Of the four parameters: start, end, periods, and " "freq, exactly three must be specified" ) with pytest.raises(ValueError, match=msg): date_range(start="1/1/2000") with pytest.raises(ValueError, match=msg): date_range(end="1/1/2000") with pytest.raises(ValueError, match=msg): date_range(periods=10) with pytest.raises(ValueError, match=msg): date_range(start="1/1/2000", freq="H") with pytest.raises(ValueError, match=msg): date_range(end="1/1/2000", freq="H") with pytest.raises(ValueError, match=msg): date_range(periods=10, freq="H") with pytest.raises(ValueError, match=msg): date_range() def test_compat_replace(self): # https://github.com/statsmodels/statsmodels/issues/3349 # replace should take ints/longs for compat result = date_range(Timestamp("1960-04-01 00:00:00"), periods=76, freq="QS-JAN") assert len(result) == 76 def test_catch_infinite_loop(self): offset = offsets.DateOffset(minute=5) # blow up, don't loop forever msg = "Offset did not increment date" with pytest.raises(ValueError, match=msg): date_range(datetime(2011, 11, 11), datetime(2011, 11, 12), freq=offset) @pytest.mark.parametrize("periods", (1, 2)) def test_wom_len(self, periods): # https://github.com/pandas-dev/pandas/issues/20517 res = date_range(start="20110101", periods=periods, freq="WOM-1MON") assert len(res) == periods def test_construct_over_dst(self): # GH 20854 pre_dst = Timestamp("2010-11-07 01:00:00").tz_localize( "US/Pacific", ambiguous=True ) pst_dst = Timestamp("2010-11-07 01:00:00").tz_localize( "US/Pacific", ambiguous=False ) expect_data = [ Timestamp("2010-11-07 00:00:00", tz="US/Pacific"), pre_dst, pst_dst, ] expected = DatetimeIndex(expect_data, freq="H") result = date_range(start="2010-11-7", periods=3, freq="H", tz="US/Pacific") tm.assert_index_equal(result, expected) def test_construct_with_different_start_end_string_format(self): # GH 12064 result = date_range( "2013-01-01 00:00:00+09:00", "2013/01/01 02:00:00+09:00", freq="H" ) expected = DatetimeIndex( [ Timestamp("2013-01-01 00:00:00+09:00"), Timestamp("2013-01-01 01:00:00+09:00"), Timestamp("2013-01-01 02:00:00+09:00"), ], freq="H", ) tm.assert_index_equal(result, expected) def test_error_with_zero_monthends(self): msg = r"Offset <0 \* MonthEnds> did not increment date" with pytest.raises(ValueError, match=msg): date_range("1/1/2000", "1/1/2001", freq=MonthEnd(0)) def test_range_bug(self): # GH #770 offset = DateOffset(months=3) result = date_range("2011-1-1", "2012-1-31", freq=offset) start = datetime(2011, 1, 1) expected = DatetimeIndex([start + i * offset for i in range(5)], freq=offset) tm.assert_index_equal(result, expected) def test_range_tz_pytz(self): # see gh-2906 tz = timezone("US/Eastern") start = tz.localize(datetime(2011, 1, 1)) end = tz.localize(datetime(2011, 1, 3)) dr = date_range(start=start, periods=3) assert dr.tz.zone == tz.zone assert dr[0] == start assert dr[2] == end dr = date_range(end=end, periods=3) assert dr.tz.zone == tz.zone assert dr[0] == start assert dr[2] == end dr = date_range(start=start, end=end) assert dr.tz.zone == tz.zone assert dr[0] == start assert dr[2] == end @pytest.mark.parametrize( "start, end", [ [ Timestamp(datetime(2014, 3, 6), tz="US/Eastern"), Timestamp(datetime(2014, 3, 12), tz="US/Eastern"), ], [ Timestamp(datetime(2013, 11, 1), tz="US/Eastern"), Timestamp(datetime(2013, 11, 6), tz="US/Eastern"), ], ], ) def test_range_tz_dst_straddle_pytz(self, start, end): dr = date_range(start, end, freq="D") assert dr[0] == start assert dr[-1] == end assert np.all(dr.hour == 0) dr = date_range(start, end, freq="D", tz="US/Eastern") assert dr[0] == start assert dr[-1] == end assert np.all(dr.hour == 0) dr = date_range( start.replace(tzinfo=None), end.replace(tzinfo=None), freq="D", tz="US/Eastern", ) assert dr[0] == start assert dr[-1] == end assert np.all(dr.hour == 0) def test_range_tz_dateutil(self): # see gh-2906 # Use maybe_get_tz to fix filename in tz under dateutil. from pandas._libs.tslibs.timezones import maybe_get_tz tz = lambda x: maybe_get_tz("dateutil/" + x) start = datetime(2011, 1, 1, tzinfo=tz("US/Eastern")) end = datetime(2011, 1, 3, tzinfo=tz("US/Eastern")) dr = date_range(start=start, periods=3) assert dr.tz == tz("US/Eastern") assert dr[0] == start assert dr[2] == end dr = date_range(end=end, periods=3) assert dr.tz == tz("US/Eastern") assert dr[0] == start assert dr[2] == end dr = date_range(start=start, end=end) assert dr.tz == tz("US/Eastern") assert dr[0] == start assert dr[2] == end @pytest.mark.parametrize("freq", ["1D", "3D", "2M", "7W", "3H", "A"]) def test_range_closed(self, freq, inclusive_endpoints_fixture): begin = datetime(2011, 1, 1) end = datetime(2014, 1, 1) result_range = date_range( begin, end, inclusive=inclusive_endpoints_fixture, freq=freq ) both_range = date_range(begin, end, inclusive="both", freq=freq) expected_range = _get_expected_range( begin, end, both_range, inclusive_endpoints_fixture ) tm.assert_index_equal(expected_range, result_range) @pytest.mark.parametrize("freq", ["1D", "3D", "2M", "7W", "3H", "A"]) def test_range_closed_with_tz_aware_start_end( self, freq, inclusive_endpoints_fixture ): # GH12409, GH12684 begin = Timestamp("2011/1/1", tz="US/Eastern") end = Timestamp("2014/1/1", tz="US/Eastern") result_range = date_range( begin, end, inclusive=inclusive_endpoints_fixture, freq=freq ) both_range = date_range(begin, end, inclusive="both", freq=freq) expected_range = _get_expected_range( begin, end, both_range, inclusive_endpoints_fixture, ) tm.assert_index_equal(expected_range, result_range) @pytest.mark.parametrize("freq", ["1D", "3D", "2M", "7W", "3H", "A"]) def test_range_with_tz_closed_with_tz_aware_start_end( self, freq, inclusive_endpoints_fixture ): begin = Timestamp("2011/1/1") end = Timestamp("2014/1/1") begintz = Timestamp("2011/1/1", tz="US/Eastern") endtz = Timestamp("2014/1/1", tz="US/Eastern") result_range = date_range( begin, end, inclusive=inclusive_endpoints_fixture, freq=freq, tz="US/Eastern", ) both_range = date_range( begin, end, inclusive="both", freq=freq, tz="US/Eastern" ) expected_range = _get_expected_range( begintz, endtz, both_range, inclusive_endpoints_fixture, ) tm.assert_index_equal(expected_range, result_range) def test_range_closed_boundary(self, inclusive_endpoints_fixture): # GH#11804 right_boundary = date_range( "2015-09-12", "2015-12-01", freq="QS-MAR", inclusive=inclusive_endpoints_fixture, ) left_boundary = date_range( "2015-09-01", "2015-09-12", freq="QS-MAR", inclusive=inclusive_endpoints_fixture, ) both_boundary = date_range( "2015-09-01", "2015-12-01", freq="QS-MAR", inclusive=inclusive_endpoints_fixture, ) neither_boundary = date_range( "2015-09-11", "2015-09-12", freq="QS-MAR", inclusive=inclusive_endpoints_fixture, ) expected_right = both_boundary expected_left = both_boundary expected_both = both_boundary if inclusive_endpoints_fixture == "right": expected_left = both_boundary[1:] elif inclusive_endpoints_fixture == "left": expected_right = both_boundary[:-1] elif inclusive_endpoints_fixture == "both": expected_right = both_boundary[1:] expected_left = both_boundary[:-1] expected_neither = both_boundary[1:-1] tm.assert_index_equal(right_boundary, expected_right) tm.assert_index_equal(left_boundary, expected_left) tm.assert_index_equal(both_boundary, expected_both) tm.assert_index_equal(neither_boundary, expected_neither) def test_years_only(self): # GH 6961 dr = date_range("2014", "2015", freq="M") assert dr[0] == datetime(2014, 1, 31) assert dr[-1] == datetime(2014, 12, 31) def test_freq_divides_end_in_nanos(self): # GH 10885 result_1 = date_range("2005-01-12 10:00", "2005-01-12 16:00", freq="345min") result_2 = date_range("2005-01-13 10:00", "2005-01-13 16:00", freq="345min") expected_1 = DatetimeIndex( ["2005-01-12 10:00:00", "2005-01-12 15:45:00"], dtype="datetime64[ns]", freq="345T", tz=None, ) expected_2 = DatetimeIndex( ["2005-01-13 10:00:00", "2005-01-13 15:45:00"], dtype="datetime64[ns]", freq="345T", tz=None, ) tm.assert_index_equal(result_1, expected_1) tm.assert_index_equal(result_2, expected_2) def test_cached_range_bug(self): rng = date_range("2010-09-01 05:00:00", periods=50, freq=DateOffset(hours=6)) assert len(rng) == 50 assert rng[0] == datetime(2010, 9, 1, 5) def test_timezone_comparison_bug(self): # smoke test start = Timestamp("20130220 10:00", tz="US/Eastern") result = date_range(start, periods=2, tz="US/Eastern") assert len(result) == 2 def test_timezone_comparison_assert(self): start = Timestamp("20130220 10:00", tz="US/Eastern") msg = "Inferred time zone not equal to passed time zone" with pytest.raises(AssertionError, match=msg): date_range(start, periods=2, tz="Europe/Berlin") def test_negative_non_tick_frequency_descending_dates(self, tz_aware_fixture): # GH 23270 tz = tz_aware_fixture result = date_range(start="2011-06-01", end="2011-01-01", freq="-1MS", tz=tz) expected = date_range(end="2011-06-01", start="2011-01-01", freq="1MS", tz=tz)[ ::-1 ] tm.assert_index_equal(result, expected) def test_range_where_start_equal_end(self, inclusive_endpoints_fixture): # GH 43394 start = "2021-09-02" end = "2021-09-02" result = date_range( start=start, end=end, freq="D", inclusive=inclusive_endpoints_fixture ) both_range = date_range(start=start, end=end, freq="D", inclusive="both") if inclusive_endpoints_fixture == "neither": expected = both_range[1:-1] elif inclusive_endpoints_fixture in ("left", "right", "both"): expected = both_range[:] tm.assert_index_equal(result, expected) def test_freq_dateoffset_with_relateivedelta_nanos(self): # GH 46877 freq = DateOffset(hours=10, days=57, nanoseconds=3) result = date_range(end="1970-01-01 00:00:00", periods=10, freq=freq, name="a") expected = DatetimeIndex( [ "1968-08-02T05:59:59.999999973", "1968-09-28T15:59:59.999999976", "1968-11-25T01:59:59.999999979", "1969-01-21T11:59:59.999999982", "1969-03-19T21:59:59.999999985", "1969-05-16T07:59:59.999999988", "1969-07-12T17:59:59.999999991", "1969-09-08T03:59:59.999999994", "1969-11-04T13:59:59.999999997", "1970-01-01T00:00:00.000000000", ], name="a", ) tm.assert_index_equal(result, expected) class TestDateRangeTZ: """Tests for date_range with timezones""" def test_hongkong_tz_convert(self): # GH#1673 smoke test dr = date_range("2012-01-01", "2012-01-10", freq="D", tz="Hongkong") # it works! dr.hour @pytest.mark.parametrize("tzstr", ["US/Eastern", "dateutil/US/Eastern"]) def test_date_range_span_dst_transition(self, tzstr): # GH#1778 # Standard -> Daylight Savings Time dr = date_range("03/06/2012 00:00", periods=200, freq="W-FRI", tz="US/Eastern") assert (dr.hour == 0).all() dr = date_range("2012-11-02", periods=10, tz=tzstr) result = dr.hour expected = pd.Index([0] * 10, dtype="int32") tm.assert_index_equal(result, expected) @pytest.mark.parametrize("tzstr", ["US/Eastern", "dateutil/US/Eastern"]) def test_date_range_timezone_str_argument(self, tzstr): tz = timezones.maybe_get_tz(tzstr) result = date_range("1/1/2000", periods=10, tz=tzstr) expected = date_range("1/1/2000", periods=10, tz=tz) tm.assert_index_equal(result, expected) def test_date_range_with_fixedoffset_noname(self): from pandas.tests.indexes.datetimes.test_timezones import fixed_off_no_name off = fixed_off_no_name start = datetime(2012, 3, 11, 5, 0, 0, tzinfo=off) end = datetime(2012, 6, 11, 5, 0, 0, tzinfo=off) rng = date_range(start=start, end=end) assert off == rng.tz idx = pd.Index([start, end]) assert off == idx.tz @pytest.mark.parametrize("tzstr", ["US/Eastern", "dateutil/US/Eastern"]) def test_date_range_with_tz(self, tzstr): stamp = Timestamp("3/11/2012 05:00", tz=tzstr) assert stamp.hour == 5 rng = date_range("3/11/2012 04:00", periods=10, freq="H", tz=tzstr) assert stamp == rng[1] class TestGenRangeGeneration: def test_generate(self): rng1 = list(generate_range(START, END, periods=None, offset=BDay(), unit="ns")) rng2 = list(generate_range(START, END, periods=None, offset="B", unit="ns")) assert rng1 == rng2 def test_generate_cday(self): rng1 = list(generate_range(START, END, periods=None, offset=CDay(), unit="ns")) rng2 = list(generate_range(START, END, periods=None, offset="C", unit="ns")) assert rng1 == rng2 def test_1(self): rng = list( generate_range( start=datetime(2009, 3, 25), end=None, periods=2, offset=BDay(), unit="ns", ) ) expected = [datetime(2009, 3, 25), datetime(2009, 3, 26)] assert rng == expected def test_2(self): rng = list( generate_range( start=datetime(2008, 1, 1), end=datetime(2008, 1, 3), periods=None, offset=BDay(), unit="ns", ) ) expected = [datetime(2008, 1, 1), datetime(2008, 1, 2), datetime(2008, 1, 3)] assert rng == expected def test_3(self): rng = list( generate_range( start=datetime(2008, 1, 5), end=datetime(2008, 1, 6), periods=None, offset=BDay(), unit="ns", ) ) expected = [] assert rng == expected def test_precision_finer_than_offset(self): # GH#9907 result1 = date_range( start="2015-04-15 00:00:03", end="2016-04-22 00:00:00", freq="Q" ) result2 = date_range( start="2015-04-15 00:00:03", end="2015-06-22 00:00:04", freq="W" ) expected1_list = [ "2015-06-30 00:00:03", "2015-09-30 00:00:03", "2015-12-31 00:00:03", "2016-03-31 00:00:03", ] expected2_list = [ "2015-04-19 00:00:03", "2015-04-26 00:00:03", "2015-05-03 00:00:03", "2015-05-10 00:00:03", "2015-05-17 00:00:03", "2015-05-24 00:00:03", "2015-05-31 00:00:03", "2015-06-07 00:00:03", "2015-06-14 00:00:03", "2015-06-21 00:00:03", ] expected1 = DatetimeIndex( expected1_list, dtype="datetime64[ns]", freq="Q-DEC", tz=None ) expected2 = DatetimeIndex( expected2_list, dtype="datetime64[ns]", freq="W-SUN", tz=None ) tm.assert_index_equal(result1, expected1) tm.assert_index_equal(result2, expected2) dt1, dt2 = "2017-01-01", "2017-01-01" tz1, tz2 = "US/Eastern", "Europe/London" @pytest.mark.parametrize( "start,end", [ (Timestamp(dt1, tz=tz1), Timestamp(dt2)), (Timestamp(dt1), Timestamp(dt2, tz=tz2)), (Timestamp(dt1, tz=tz1), Timestamp(dt2, tz=tz2)), (Timestamp(dt1, tz=tz2), Timestamp(dt2, tz=tz1)), ], ) def test_mismatching_tz_raises_err(self, start, end): # issue 18488 msg = "Start and end cannot both be tz-aware with different timezones" with pytest.raises(TypeError, match=msg): date_range(start, end) with pytest.raises(TypeError, match=msg): date_range(start, end, freq=BDay()) class TestBusinessDateRange: def test_constructor(self): bdate_range(START, END, freq=BDay()) bdate_range(START, periods=20, freq=BDay()) bdate_range(end=START, periods=20, freq=BDay()) msg = "periods must be a number, got B" with pytest.raises(TypeError, match=msg): date_range("2011-1-1", "2012-1-1", "B") with pytest.raises(TypeError, match=msg): bdate_range("2011-1-1", "2012-1-1", "B") msg = "freq must be specified for bdate_range; use date_range instead" with pytest.raises(TypeError, match=msg): bdate_range(START, END, periods=10, freq=None) def test_misc(self): end = datetime(2009, 5, 13) dr = bdate_range(end=end, periods=20) firstDate = end - 19 * BDay() assert len(dr) == 20 assert dr[0] == firstDate assert dr[-1] == end def test_date_parse_failure(self): badly_formed_date = "2007/100/1" msg = "Unknown datetime string format, unable to parse: 2007/100/1" with pytest.raises(ValueError, match=msg): Timestamp(badly_formed_date) with pytest.raises(ValueError, match=msg): bdate_range(start=badly_formed_date, periods=10) with pytest.raises(ValueError, match=msg): bdate_range(end=badly_formed_date, periods=10) with pytest.raises(ValueError, match=msg): bdate_range(badly_formed_date, badly_formed_date) def test_daterange_bug_456(self): # GH #456 rng1 = bdate_range("12/5/2011", "12/5/2011") rng2 = bdate_range("12/2/2011", "12/5/2011") assert rng2._data.freq == BDay() result = rng1.union(rng2) assert isinstance(result, DatetimeIndex) @pytest.mark.parametrize("inclusive", ["left", "right", "neither", "both"]) def test_bdays_and_open_boundaries(self, inclusive): # GH 6673 start = "2018-07-21" # Saturday end = "2018-07-29" # Sunday result = date_range(start, end, freq="B", inclusive=inclusive) bday_start = "2018-07-23" # Monday bday_end = "2018-07-27" # Friday expected = date_range(bday_start, bday_end, freq="D") tm.assert_index_equal(result, expected) # Note: we do _not_ expect the freqs to match here def test_bday_near_overflow(self): # GH#24252 avoid doing unnecessary addition that _would_ overflow start = Timestamp.max.floor("D").to_pydatetime() rng = date_range(start, end=None, periods=1, freq="B") expected = DatetimeIndex([start], freq="B") tm.assert_index_equal(rng, expected) def test_bday_overflow_error(self): # GH#24252 check that we get OutOfBoundsDatetime and not OverflowError msg = "Out of bounds nanosecond timestamp" start = Timestamp.max.floor("D").to_pydatetime() with pytest.raises(OutOfBoundsDatetime, match=msg): date_range(start, periods=2, freq="B") class TestCustomDateRange: def test_constructor(self): bdate_range(START, END, freq=CDay()) bdate_range(START, periods=20, freq=CDay()) bdate_range(end=START, periods=20, freq=CDay()) msg = "periods must be a number, got C" with pytest.raises(TypeError, match=msg): date_range("2011-1-1", "2012-1-1", "C") with pytest.raises(TypeError, match=msg): bdate_range("2011-1-1", "2012-1-1", "C") def test_misc(self): end = datetime(2009, 5, 13) dr = bdate_range(end=end, periods=20, freq="C") firstDate = end - 19 * CDay() assert len(dr) == 20 assert dr[0] == firstDate assert dr[-1] == end def test_daterange_bug_456(self): # GH #456 rng1 = bdate_range("12/5/2011", "12/5/2011", freq="C") rng2 = bdate_range("12/2/2011", "12/5/2011", freq="C") assert rng2._data.freq == CDay() result = rng1.union(rng2) assert isinstance(result, DatetimeIndex) def test_cdaterange(self): result = bdate_range("2013-05-01", periods=3, freq="C") expected = DatetimeIndex(["2013-05-01", "2013-05-02", "2013-05-03"], freq="C") tm.assert_index_equal(result, expected) assert result.freq == expected.freq def test_cdaterange_weekmask(self): result = bdate_range( "2013-05-01", periods=3, freq="C", weekmask="Sun Mon Tue Wed Thu" ) expected = DatetimeIndex( ["2013-05-01", "2013-05-02", "2013-05-05"], freq=result.freq ) tm.assert_index_equal(result, expected) assert result.freq == expected.freq # raise with non-custom freq msg = ( "a custom frequency string is required when holidays or " "weekmask are passed, got frequency B" ) with pytest.raises(ValueError, match=msg): bdate_range("2013-05-01", periods=3, weekmask="Sun Mon Tue Wed Thu") def test_cdaterange_holidays(self): result = bdate_range("2013-05-01", periods=3, freq="C", holidays=["2013-05-01"]) expected = DatetimeIndex( ["2013-05-02", "2013-05-03", "2013-05-06"], freq=result.freq ) tm.assert_index_equal(result, expected) assert result.freq == expected.freq # raise with non-custom freq msg = ( "a custom frequency string is required when holidays or " "weekmask are passed, got frequency B" ) with pytest.raises(ValueError, match=msg): bdate_range("2013-05-01", periods=3, holidays=["2013-05-01"]) def test_cdaterange_weekmask_and_holidays(self): result = bdate_range( "2013-05-01", periods=3, freq="C", weekmask="Sun Mon Tue Wed Thu", holidays=["2013-05-01"], ) expected = DatetimeIndex( ["2013-05-02", "2013-05-05", "2013-05-06"], freq=result.freq ) tm.assert_index_equal(result, expected) assert result.freq == expected.freq # raise with non-custom freq msg = ( "a custom frequency string is required when holidays or " "weekmask are passed, got frequency B" ) with pytest.raises(ValueError, match=msg): bdate_range( "2013-05-01", periods=3, weekmask="Sun Mon Tue Wed Thu", holidays=["2013-05-01"], ) @pytest.mark.parametrize( "freq", [freq for freq in prefix_mapping if freq.startswith("C")] ) def test_all_custom_freq(self, freq): # should not raise bdate_range( START, END, freq=freq, weekmask="Mon Wed Fri", holidays=["2009-03-14"] ) bad_freq = freq + "FOO" msg = f"invalid custom frequency string: {bad_freq}" with pytest.raises(ValueError, match=msg): bdate_range(START, END, freq=bad_freq) @pytest.mark.parametrize( "start_end", [ ("2018-01-01T00:00:01.000Z", "2018-01-03T00:00:01.000Z"), ("2018-01-01T00:00:00.010Z", "2018-01-03T00:00:00.010Z"), ("2001-01-01T00:00:00.010Z", "2001-01-03T00:00:00.010Z"), ], ) def test_range_with_millisecond_resolution(self, start_end): # https://github.com/pandas-dev/pandas/issues/24110 start, end = start_end result = date_range(start=start, end=end, periods=2, inclusive="left") expected = DatetimeIndex([start]) tm.assert_index_equal(result, expected) @pytest.mark.parametrize( "start,period,expected", [ ("2022-07-23 00:00:00+02:00", 1, ["2022-07-25 00:00:00+02:00"]), ("2022-07-22 00:00:00+02:00", 1, ["2022-07-22 00:00:00+02:00"]), ( "2022-07-22 00:00:00+02:00", 2, ["2022-07-22 00:00:00+02:00", "2022-07-25 00:00:00+02:00"], ), ], ) def test_range_with_timezone_and_custombusinessday(self, start, period, expected): # GH49441 result = date_range(start=start, periods=period, freq="C") expected = DatetimeIndex(expected) tm.assert_index_equal(result, expected) def test_date_range_with_custom_holidays(): # GH 30593 freq = offsets.CustomBusinessHour(start="15:00", holidays=["2020-11-26"]) result = date_range(start="2020-11-25 15:00", periods=4, freq=freq) expected = DatetimeIndex( [ "2020-11-25 15:00:00", "2020-11-25 16:00:00", "2020-11-27 15:00:00", "2020-11-27 16:00:00", ], freq=freq, ) tm.assert_index_equal(result, expected) class TestDateRangeNonNano: def test_date_range_reso_validation(self): msg = "'unit' must be one of 's', 'ms', 'us', 'ns'" with pytest.raises(ValueError, match=msg): date_range("2016-01-01", "2016-03-04", periods=3, unit="h") def test_date_range_freq_higher_than_reso(self): # freq being higher-resolution than reso is a problem msg = "Use a lower freq or a higher unit instead" with pytest.raises(ValueError, match=msg): # # TODO give a more useful or informative message? date_range("2016-01-01", "2016-01-02", freq="ns", unit="ms") def test_date_range_freq_matches_reso(self): # GH#49106 matching reso is OK dti = date_range("2016-01-01", "2016-01-01 00:00:01", freq="ms", unit="ms") rng = np.arange(1_451_606_400_000, 1_451_606_401_001, dtype=np.int64) expected = DatetimeIndex(rng.view("M8[ms]"), freq="ms") tm.assert_index_equal(dti, expected) dti = date_range("2016-01-01", "2016-01-01 00:00:01", freq="us", unit="us") rng = np.arange(1_451_606_400_000_000, 1_451_606_401_000_001, dtype=np.int64) expected = DatetimeIndex(rng.view("M8[us]"), freq="us") tm.assert_index_equal(dti, expected) dti = date_range("2016-01-01", "2016-01-01 00:00:00.001", freq="ns", unit="ns") rng = np.arange( 1_451_606_400_000_000_000, 1_451_606_400_001_000_001, dtype=np.int64 ) expected = DatetimeIndex(rng.view("M8[ns]"), freq="ns") tm.assert_index_equal(dti, expected) def test_date_range_freq_lower_than_endpoints(self): start = Timestamp("2022-10-19 11:50:44.719781") end = Timestamp("2022-10-19 11:50:47.066458") # start and end cannot be cast to "s" unit without lossy rounding, # so we do not allow this in date_range with pytest.raises(ValueError, match="Cannot losslessly convert units"): date_range(start, end, periods=3, unit="s") # but we can losslessly cast to "us" dti = date_range(start, end, periods=2, unit="us") rng = np.array( [start.as_unit("us")._value, end.as_unit("us")._value], dtype=np.int64 ) expected = DatetimeIndex(rng.view("M8[us]")) tm.assert_index_equal(dti, expected) def test_date_range_non_nano(self): start = np.datetime64("1066-10-14") # Battle of Hastings end = np.datetime64("2305-07-13") # Jean-Luc Picard's birthday dti = date_range(start, end, freq="D", unit="s") assert dti.freq == "D" assert dti.dtype == "M8[s]" exp = np.arange( start.astype("M8[s]").view("i8"), (end + 1).astype("M8[s]").view("i8"), 24 * 3600, ).view("M8[s]") tm.assert_numpy_array_equal(dti.to_numpy(), exp)