Skip to main content
`Ctrl`+`K`

# pandas.DataFrame.at_time

DataFrame.at_time(time, asof=False, axis=None)

  Select values at particular time of day (e.g., 9:30AM).

  This method filters rows whose index has a time component matching the specified time. The index must be a DatetimeIndex.

  Parameters:
    time datetime.time or str

      The values to select.

    asof bool, default False

      This parameter is currently not supported.

    axis{0 or ‘index’, 1 or ‘columns’}, default 0

      For Series this parameter is unused and defaults to 0.

  Returns:
    Series or DataFrame

      The values with the specified time.

  Raises:
    TypeError

      If the index is not a `DatetimeIndex`

  See also

  `between_time`

    Select values between particular times of the day.

  `first`

    Select initial periods of time series based on a date offset.

  `last`

    Select final periods of time series based on a date offset.

  `DatetimeIndex.indexer_at_time`

    Get just the index locations for values at particular time of the day.

  Examples

      >>> i = pd.date_range("2018-04-09", periods=4, freq="12h")
      >>> ts = pd.DataFrame({"A": [1, 2, 3, 4]}, index=i)
      >>> ts
                           A
      2018-04-09 00:00:00  1
      2018-04-09 12:00:00  2
      2018-04-10 00:00:00  3
      2018-04-10 12:00:00  4

      >>> ts.at_time("12:00")
                           A
      2018-04-09 12:00:00  2
      2018-04-10 12:00:00  4