123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124 |
- from datetime import time
- import numpy as np
- import pytest
- import pytz
- from pandas._libs.tslibs import timezones
- from pandas import (
- DataFrame,
- date_range,
- )
- import pandas._testing as tm
- class TestAtTime:
- @pytest.mark.parametrize("tzstr", ["US/Eastern", "dateutil/US/Eastern"])
- def test_localized_at_time(self, tzstr, frame_or_series):
- tz = timezones.maybe_get_tz(tzstr)
- rng = date_range("4/16/2012", "5/1/2012", freq="H")
- ts = frame_or_series(np.random.randn(len(rng)), index=rng)
- ts_local = ts.tz_localize(tzstr)
- result = ts_local.at_time(time(10, 0))
- expected = ts.at_time(time(10, 0)).tz_localize(tzstr)
- tm.assert_equal(result, expected)
- assert timezones.tz_compare(result.index.tz, tz)
- def test_at_time(self, frame_or_series):
- rng = date_range("1/1/2000", "1/5/2000", freq="5min")
- ts = DataFrame(np.random.randn(len(rng), 2), index=rng)
- ts = tm.get_obj(ts, frame_or_series)
- rs = ts.at_time(rng[1])
- assert (rs.index.hour == rng[1].hour).all()
- assert (rs.index.minute == rng[1].minute).all()
- assert (rs.index.second == rng[1].second).all()
- result = ts.at_time("9:30")
- expected = ts.at_time(time(9, 30))
- tm.assert_equal(result, expected)
- def test_at_time_midnight(self, frame_or_series):
-
- rng = date_range("1/1/2000", "1/31/2000")
- ts = DataFrame(np.random.randn(len(rng), 3), index=rng)
- ts = tm.get_obj(ts, frame_or_series)
- result = ts.at_time(time(0, 0))
- tm.assert_equal(result, ts)
- def test_at_time_nonexistent(self, frame_or_series):
-
- rng = date_range("1/1/2012", freq="23Min", periods=384)
- ts = DataFrame(np.random.randn(len(rng)), rng)
- ts = tm.get_obj(ts, frame_or_series)
- rs = ts.at_time("16:00")
- assert len(rs) == 0
- @pytest.mark.parametrize(
- "hour", ["1:00", "1:00AM", time(1), time(1, tzinfo=pytz.UTC)]
- )
- def test_at_time_errors(self, hour):
-
- dti = date_range("2018", periods=3, freq="H")
- df = DataFrame(list(range(len(dti))), index=dti)
- if getattr(hour, "tzinfo", None) is None:
- result = df.at_time(hour)
- expected = df.iloc[1:2]
- tm.assert_frame_equal(result, expected)
- else:
- with pytest.raises(ValueError, match="Index must be timezone"):
- df.at_time(hour)
- def test_at_time_tz(self):
-
- dti = date_range("2018", periods=3, freq="H", tz="US/Pacific")
- df = DataFrame(list(range(len(dti))), index=dti)
- result = df.at_time(time(4, tzinfo=pytz.timezone("US/Eastern")))
- expected = df.iloc[1:2]
- tm.assert_frame_equal(result, expected)
- def test_at_time_raises(self, frame_or_series):
-
- obj = DataFrame([[1, 2, 3], [4, 5, 6]])
- obj = tm.get_obj(obj, frame_or_series)
- msg = "Index must be DatetimeIndex"
- with pytest.raises(TypeError, match=msg):
- obj.at_time("00:00")
- @pytest.mark.parametrize("axis", ["index", "columns", 0, 1])
- def test_at_time_axis(self, axis):
-
- rng = date_range("1/1/2000", "1/5/2000", freq="5min")
- ts = DataFrame(np.random.randn(len(rng), len(rng)))
- ts.index, ts.columns = rng, rng
- indices = rng[(rng.hour == 9) & (rng.minute == 30) & (rng.second == 0)]
- if axis in ["index", 0]:
- expected = ts.loc[indices, :]
- elif axis in ["columns", 1]:
- expected = ts.loc[:, indices]
- result = ts.at_time("9:30", axis=axis)
-
- result.index = result.index._with_freq(None)
- expected.index = expected.index._with_freq(None)
- tm.assert_frame_equal(result, expected)
- def test_at_time_datetimeindex(self):
- index = date_range("2012-01-01", "2012-01-05", freq="30min")
- df = DataFrame(np.random.randn(len(index), 5), index=index)
- akey = time(12, 0, 0)
- ainds = [24, 72, 120, 168]
- result = df.at_time(akey)
- expected = df.loc[akey]
- expected2 = df.iloc[ainds]
- tm.assert_frame_equal(result, expected)
- tm.assert_frame_equal(result, expected2)
- assert len(result) == 4
|