123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500 |
- from datetime import datetime
- import numpy as np
- import pytest
- import pandas.util._test_decorators as td
- import pandas as pd
- from pandas import (
- DataFrame, DatetimeIndex, Index, Int64Index, Series, bdate_range,
- date_range, to_datetime)
- import pandas.util.testing as tm
- from pandas.tseries.offsets import BMonthEnd, Minute, MonthEnd
- START, END = datetime(2009, 1, 1), datetime(2010, 1, 1)
- class TestDatetimeIndexSetOps(object):
- tz = [None, 'UTC', 'Asia/Tokyo', 'US/Eastern', 'dateutil/Asia/Singapore',
- 'dateutil/US/Pacific']
- # TODO: moved from test_datetimelike; dedup with version below
- def test_union2(self):
- everything = tm.makeDateIndex(10)
- first = everything[:5]
- second = everything[5:]
- union = first.union(second)
- assert tm.equalContents(union, everything)
- # GH 10149
- cases = [klass(second.values) for klass in [np.array, Series, list]]
- for case in cases:
- result = first.union(case)
- assert tm.equalContents(result, everything)
- @pytest.mark.parametrize("tz", tz)
- def test_union(self, tz):
- rng1 = pd.date_range('1/1/2000', freq='D', periods=5, tz=tz)
- other1 = pd.date_range('1/6/2000', freq='D', periods=5, tz=tz)
- expected1 = pd.date_range('1/1/2000', freq='D', periods=10, tz=tz)
- rng2 = pd.date_range('1/1/2000', freq='D', periods=5, tz=tz)
- other2 = pd.date_range('1/4/2000', freq='D', periods=5, tz=tz)
- expected2 = pd.date_range('1/1/2000', freq='D', periods=8, tz=tz)
- rng3 = pd.date_range('1/1/2000', freq='D', periods=5, tz=tz)
- other3 = pd.DatetimeIndex([], tz=tz)
- expected3 = pd.date_range('1/1/2000', freq='D', periods=5, tz=tz)
- for rng, other, expected in [(rng1, other1, expected1),
- (rng2, other2, expected2),
- (rng3, other3, expected3)]:
- result_union = rng.union(other)
- tm.assert_index_equal(result_union, expected)
- def test_union_coverage(self):
- idx = DatetimeIndex(['2000-01-03', '2000-01-01', '2000-01-02'])
- ordered = DatetimeIndex(idx.sort_values(), freq='infer')
- result = ordered.union(idx)
- tm.assert_index_equal(result, ordered)
- result = ordered[:0].union(ordered)
- tm.assert_index_equal(result, ordered)
- assert result.freq == ordered.freq
- def test_union_bug_1730(self):
- rng_a = date_range('1/1/2012', periods=4, freq='3H')
- rng_b = date_range('1/1/2012', periods=4, freq='4H')
- result = rng_a.union(rng_b)
- exp = DatetimeIndex(sorted(set(list(rng_a)) | set(list(rng_b))))
- tm.assert_index_equal(result, exp)
- def test_union_bug_1745(self):
- left = DatetimeIndex(['2012-05-11 15:19:49.695000'])
- right = DatetimeIndex(['2012-05-29 13:04:21.322000',
- '2012-05-11 15:27:24.873000',
- '2012-05-11 15:31:05.350000'])
- result = left.union(right)
- exp = DatetimeIndex(sorted(set(list(left)) | set(list(right))))
- tm.assert_index_equal(result, exp)
- def test_union_bug_4564(self):
- from pandas import DateOffset
- left = date_range("2013-01-01", "2013-02-01")
- right = left + DateOffset(minutes=15)
- result = left.union(right)
- exp = DatetimeIndex(sorted(set(list(left)) | set(list(right))))
- tm.assert_index_equal(result, exp)
- def test_union_freq_both_none(self):
- # GH11086
- expected = bdate_range('20150101', periods=10)
- expected.freq = None
- result = expected.union(expected)
- tm.assert_index_equal(result, expected)
- assert result.freq is None
- def test_union_dataframe_index(self):
- rng1 = date_range('1/1/1999', '1/1/2012', freq='MS')
- s1 = Series(np.random.randn(len(rng1)), rng1)
- rng2 = date_range('1/1/1980', '12/1/2001', freq='MS')
- s2 = Series(np.random.randn(len(rng2)), rng2)
- df = DataFrame({'s1': s1, 's2': s2})
- exp = pd.date_range('1/1/1980', '1/1/2012', freq='MS')
- tm.assert_index_equal(df.index, exp)
- def test_union_with_DatetimeIndex(self):
- i1 = Int64Index(np.arange(0, 20, 2))
- i2 = date_range(start='2012-01-03 00:00:00', periods=10, freq='D')
- i1.union(i2) # Works
- i2.union(i1) # Fails with "AttributeError: can't set attribute"
- # TODO: moved from test_datetimelike; de-duplicate with version below
- def test_intersection2(self):
- first = tm.makeDateIndex(10)
- second = first[5:]
- intersect = first.intersection(second)
- assert tm.equalContents(intersect, second)
- # GH 10149
- cases = [klass(second.values) for klass in [np.array, Series, list]]
- for case in cases:
- result = first.intersection(case)
- assert tm.equalContents(result, second)
- third = Index(['a', 'b', 'c'])
- result = first.intersection(third)
- expected = pd.Index([], dtype=object)
- tm.assert_index_equal(result, expected)
- @pytest.mark.parametrize("tz", [None, 'Asia/Tokyo', 'US/Eastern',
- 'dateutil/US/Pacific'])
- @pytest.mark.parametrize("sort", [None, False])
- def test_intersection(self, tz, sort):
- # GH 4690 (with tz)
- base = date_range('6/1/2000', '6/30/2000', freq='D', name='idx')
- # if target has the same name, it is preserved
- rng2 = date_range('5/15/2000', '6/20/2000', freq='D', name='idx')
- expected2 = date_range('6/1/2000', '6/20/2000', freq='D', name='idx')
- # if target name is different, it will be reset
- rng3 = date_range('5/15/2000', '6/20/2000', freq='D', name='other')
- expected3 = date_range('6/1/2000', '6/20/2000', freq='D', name=None)
- rng4 = date_range('7/1/2000', '7/31/2000', freq='D', name='idx')
- expected4 = DatetimeIndex([], name='idx')
- for (rng, expected) in [(rng2, expected2), (rng3, expected3),
- (rng4, expected4)]:
- result = base.intersection(rng)
- tm.assert_index_equal(result, expected)
- assert result.name == expected.name
- assert result.freq == expected.freq
- assert result.tz == expected.tz
- # non-monotonic
- base = DatetimeIndex(['2011-01-05', '2011-01-04',
- '2011-01-02', '2011-01-03'],
- tz=tz, name='idx')
- rng2 = DatetimeIndex(['2011-01-04', '2011-01-02',
- '2011-02-02', '2011-02-03'],
- tz=tz, name='idx')
- expected2 = DatetimeIndex(['2011-01-04', '2011-01-02'],
- tz=tz, name='idx')
- rng3 = DatetimeIndex(['2011-01-04', '2011-01-02',
- '2011-02-02', '2011-02-03'],
- tz=tz, name='other')
- expected3 = DatetimeIndex(['2011-01-04', '2011-01-02'],
- tz=tz, name=None)
- # GH 7880
- rng4 = date_range('7/1/2000', '7/31/2000', freq='D', tz=tz,
- name='idx')
- expected4 = DatetimeIndex([], tz=tz, name='idx')
- for (rng, expected) in [(rng2, expected2), (rng3, expected3),
- (rng4, expected4)]:
- result = base.intersection(rng, sort=sort)
- if sort is None:
- expected = expected.sort_values()
- tm.assert_index_equal(result, expected)
- assert result.name == expected.name
- assert result.freq is None
- assert result.tz == expected.tz
- def test_intersection_empty(self):
- # empty same freq GH2129
- rng = date_range('6/1/2000', '6/15/2000', freq='T')
- result = rng[0:0].intersection(rng)
- assert len(result) == 0
- result = rng.intersection(rng[0:0])
- assert len(result) == 0
- def test_intersection_bug_1708(self):
- from pandas import DateOffset
- index_1 = date_range('1/1/2012', periods=4, freq='12H')
- index_2 = index_1 + DateOffset(hours=1)
- result = index_1 & index_2
- assert len(result) == 0
- @pytest.mark.parametrize("tz", tz)
- @pytest.mark.parametrize("sort", [None, False])
- def test_difference(self, tz, sort):
- rng_dates = ['1/2/2000', '1/3/2000', '1/1/2000', '1/4/2000',
- '1/5/2000']
- rng1 = pd.DatetimeIndex(rng_dates, tz=tz)
- other1 = pd.date_range('1/6/2000', freq='D', periods=5, tz=tz)
- expected1 = pd.DatetimeIndex(rng_dates, tz=tz)
- rng2 = pd.DatetimeIndex(rng_dates, tz=tz)
- other2 = pd.date_range('1/4/2000', freq='D', periods=5, tz=tz)
- expected2 = pd.DatetimeIndex(rng_dates[:3], tz=tz)
- rng3 = pd.DatetimeIndex(rng_dates, tz=tz)
- other3 = pd.DatetimeIndex([], tz=tz)
- expected3 = pd.DatetimeIndex(rng_dates, tz=tz)
- for rng, other, expected in [(rng1, other1, expected1),
- (rng2, other2, expected2),
- (rng3, other3, expected3)]:
- result_diff = rng.difference(other, sort)
- if sort is None:
- expected = expected.sort_values()
- tm.assert_index_equal(result_diff, expected)
- @pytest.mark.parametrize("sort", [None, False])
- def test_difference_freq(self, sort):
- # GH14323: difference of DatetimeIndex should not preserve frequency
- index = date_range("20160920", "20160925", freq="D")
- other = date_range("20160921", "20160924", freq="D")
- expected = DatetimeIndex(["20160920", "20160925"], freq=None)
- idx_diff = index.difference(other, sort)
- tm.assert_index_equal(idx_diff, expected)
- tm.assert_attr_equal('freq', idx_diff, expected)
- other = date_range("20160922", "20160925", freq="D")
- idx_diff = index.difference(other, sort)
- expected = DatetimeIndex(["20160920", "20160921"], freq=None)
- tm.assert_index_equal(idx_diff, expected)
- tm.assert_attr_equal('freq', idx_diff, expected)
- @pytest.mark.parametrize("sort", [None, False])
- def test_datetimeindex_diff(self, sort):
- dti1 = date_range(freq='Q-JAN', start=datetime(1997, 12, 31),
- periods=100)
- dti2 = date_range(freq='Q-JAN', start=datetime(1997, 12, 31),
- periods=98)
- assert len(dti1.difference(dti2, sort)) == 2
- def test_datetimeindex_union_join_empty(self):
- dti = date_range(start='1/1/2001', end='2/1/2001', freq='D')
- empty = Index([])
- result = dti.union(empty)
- assert isinstance(result, DatetimeIndex)
- assert result is result
- result = dti.join(empty)
- assert isinstance(result, DatetimeIndex)
- def test_join_nonunique(self):
- idx1 = to_datetime(['2012-11-06 16:00:11.477563',
- '2012-11-06 16:00:11.477563'])
- idx2 = to_datetime(['2012-11-06 15:11:09.006507',
- '2012-11-06 15:11:09.006507'])
- rs = idx1.join(idx2, how='outer')
- assert rs.is_monotonic
- class TestBusinessDatetimeIndex(object):
- def setup_method(self, method):
- self.rng = bdate_range(START, END)
- def test_union(self):
- # overlapping
- left = self.rng[:10]
- right = self.rng[5:10]
- the_union = left.union(right)
- assert isinstance(the_union, DatetimeIndex)
- # non-overlapping, gap in middle
- left = self.rng[:5]
- right = self.rng[10:]
- the_union = left.union(right)
- assert isinstance(the_union, Index)
- # non-overlapping, no gap
- left = self.rng[:5]
- right = self.rng[5:10]
- the_union = left.union(right)
- assert isinstance(the_union, DatetimeIndex)
- # order does not matter
- tm.assert_index_equal(right.union(left), the_union)
- # overlapping, but different offset
- rng = date_range(START, END, freq=BMonthEnd())
- the_union = self.rng.union(rng)
- assert isinstance(the_union, DatetimeIndex)
- def test_outer_join(self):
- # should just behave as union
- # overlapping
- left = self.rng[:10]
- right = self.rng[5:10]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- # non-overlapping, gap in middle
- left = self.rng[:5]
- right = self.rng[10:]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- assert the_join.freq is None
- # non-overlapping, no gap
- left = self.rng[:5]
- right = self.rng[5:10]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- # overlapping, but different offset
- rng = date_range(START, END, freq=BMonthEnd())
- the_join = self.rng.join(rng, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- assert the_join.freq is None
- def test_union_not_cacheable(self):
- rng = date_range('1/1/2000', periods=50, freq=Minute())
- rng1 = rng[10:]
- rng2 = rng[:25]
- the_union = rng1.union(rng2)
- tm.assert_index_equal(the_union, rng)
- rng1 = rng[10:]
- rng2 = rng[15:35]
- the_union = rng1.union(rng2)
- expected = rng[10:]
- tm.assert_index_equal(the_union, expected)
- def test_intersection(self):
- rng = date_range('1/1/2000', periods=50, freq=Minute())
- rng1 = rng[10:]
- rng2 = rng[:25]
- the_int = rng1.intersection(rng2)
- expected = rng[10:25]
- tm.assert_index_equal(the_int, expected)
- assert isinstance(the_int, DatetimeIndex)
- assert the_int.freq == rng.freq
- the_int = rng1.intersection(rng2.view(DatetimeIndex))
- tm.assert_index_equal(the_int, expected)
- # non-overlapping
- the_int = rng[:10].intersection(rng[10:])
- expected = DatetimeIndex([])
- tm.assert_index_equal(the_int, expected)
- def test_intersection_bug(self):
- # GH #771
- a = bdate_range('11/30/2011', '12/31/2011')
- b = bdate_range('12/10/2011', '12/20/2011')
- result = a.intersection(b)
- tm.assert_index_equal(result, b)
- def test_month_range_union_tz_pytz(self):
- from pytz import timezone
- tz = timezone('US/Eastern')
- early_start = datetime(2011, 1, 1)
- early_end = datetime(2011, 3, 1)
- late_start = datetime(2011, 3, 1)
- late_end = datetime(2011, 5, 1)
- early_dr = date_range(start=early_start, end=early_end, tz=tz,
- freq=MonthEnd())
- late_dr = date_range(start=late_start, end=late_end, tz=tz,
- freq=MonthEnd())
- early_dr.union(late_dr)
- @td.skip_if_windows_python_3
- def test_month_range_union_tz_dateutil(self):
- from pandas._libs.tslibs.timezones import dateutil_gettz
- tz = dateutil_gettz('US/Eastern')
- early_start = datetime(2011, 1, 1)
- early_end = datetime(2011, 3, 1)
- late_start = datetime(2011, 3, 1)
- late_end = datetime(2011, 5, 1)
- early_dr = date_range(start=early_start, end=early_end, tz=tz,
- freq=MonthEnd())
- late_dr = date_range(start=late_start, end=late_end, tz=tz,
- freq=MonthEnd())
- early_dr.union(late_dr)
- class TestCustomDatetimeIndex(object):
- def setup_method(self, method):
- self.rng = bdate_range(START, END, freq='C')
- def test_union(self):
- # overlapping
- left = self.rng[:10]
- right = self.rng[5:10]
- the_union = left.union(right)
- assert isinstance(the_union, DatetimeIndex)
- # non-overlapping, gap in middle
- left = self.rng[:5]
- right = self.rng[10:]
- the_union = left.union(right)
- assert isinstance(the_union, Index)
- # non-overlapping, no gap
- left = self.rng[:5]
- right = self.rng[5:10]
- the_union = left.union(right)
- assert isinstance(the_union, DatetimeIndex)
- # order does not matter
- tm.assert_index_equal(right.union(left), the_union)
- # overlapping, but different offset
- rng = date_range(START, END, freq=BMonthEnd())
- the_union = self.rng.union(rng)
- assert isinstance(the_union, DatetimeIndex)
- def test_outer_join(self):
- # should just behave as union
- # overlapping
- left = self.rng[:10]
- right = self.rng[5:10]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- # non-overlapping, gap in middle
- left = self.rng[:5]
- right = self.rng[10:]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- assert the_join.freq is None
- # non-overlapping, no gap
- left = self.rng[:5]
- right = self.rng[5:10]
- the_join = left.join(right, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- # overlapping, but different offset
- rng = date_range(START, END, freq=BMonthEnd())
- the_join = self.rng.join(rng, how='outer')
- assert isinstance(the_join, DatetimeIndex)
- assert the_join.freq is None
- def test_intersection_bug(self):
- # GH #771
- a = bdate_range('11/30/2011', '12/31/2011', freq='C')
- b = bdate_range('12/10/2011', '12/20/2011', freq='C')
- result = a.intersection(b)
- tm.assert_index_equal(result, b)
|