temporal
def temporal() -> SelectorProxy
Categories: projection
Select all columns of temporal data types.
This includes datetime, date, time, and timedelta.
Examples
>>> import tabsdata.tableframe as td_tf
>>> from datetime import datetime, date, time, timedelta, timezone
>>>
>>> tf = td_tf.TableFrame({
... "CreatedAt": [
... datetime(2024, 1, 1, 9, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 2, 10, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 3, 11, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 4, 12, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 5, 13, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 6, 14, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 7, 15, 0, tzinfo=timezone.utc),
... datetime(2024, 1, 8, 16, 0, tzinfo=timezone.utc)
... ],
... "SessionDate": [
... date(2024, 1, 1),
... date(2024, 1, 2),
... date(2024, 1, 3),
... date(2024, 1, 4),
... date(2024, 1, 5),
... date(2024, 1, 6),
... date(2024, 1, 7),
... date(2024, 1, 8)
... ],
... "Duration": [
... timedelta(minutes=0),
... timedelta(minutes=5),
... timedelta(minutes=10),
... timedelta(minutes=15),
... timedelta(minutes=20),
... timedelta(minutes=25),
... timedelta(minutes=30),
... timedelta(minutes=35)
... ],
... "EventTime": [
... time(9, 0),
... time(10, 0),
... time(11, 0),
... time(12, 0),
... time(13, 0),
... time(14, 0),
... time(15, 0),
... time(16, 0)
... ],
... "User": ["Alice", "Bob", "Cara", "Dan", "Eve", "Finn", "Gus", "Hana"]
... })
Original: ┌───────────────────────────┬─────────────┬──────────┬───────────┬─────────┐ │ CreatedAt ┆ SessionDate ┆ Duration ┆ EventTime ┆ User │ │ --- ┆ --- ┆ --- ┆ --- ┆ --- │ │ datetime[μs, UTC] ┆ date ┆ duration ┆ time ┆ str │ ╞═══════════════════════════╪═════════════╪══════════╪═══════════╪═════════╡ │ 2024-01-01 09:00:00+00:00 ┆ 2024-01-01 ┆ 0:00:00 ┆ 09:00:00 ┆ "Alice" │ │ 2024-01-02 10:00:00+00:00 ┆ 2024-01-02 ┆ 0:05:00 ┆ 10:00:00 ┆ "Bob" │ │ 2024-01-03 11:00:00+00:00 ┆ 2024-01-03 ┆ 0:10:00 ┆ 11:00:00 ┆ "Cara" │ │ 2024-01-04 12:00:00+00:00 ┆ 2024-01-04 ┆ 0:15:00 ┆ 12:00:00 ┆ "Dan" │ │ 2024-01-05 13:00:00+00:00 ┆ 2024-01-05 ┆ 0:20:00 ┆ 13:00:00 ┆ "Eve" │ │ 2024-01-06 14:00:00+00:00 ┆ 2024-01-06 ┆ 0:25:00 ┆ 14:00:00 ┆ "Finn" │ │ 2024-01-07 15:00:00+00:00 ┆ 2024-01-07 ┆ 0:30:00 ┆ 15:00:00 ┆ "Gus" │ │ 2024-01-08 16:00:00+00:00 ┆ 2024-01-08 ┆ 0:35:00 ┆ 16:00:00 ┆ "Hana" │ └───────────────────────────┴─────────────┴──────────┴───────────┴─────────┘
>>> tf.select(td_tf.selectors.temporal())
Selected: ┌───────────────────────────┬─────────────┬──────────┬───────────┐ │ CreatedAt ┆ SessionDate ┆ Duration ┆ EventTime │ │ --- ┆ --- ┆ --- ┆ --- │ │ datetime[μs, UTC] ┆ date ┆ duration ┆ time │ ╞═══════════════════════════╪═════════════╪══════════╪═══════════╡ │ 2024-01-01 09:00:00+00:00 ┆ 2024-01-01 ┆ 0:00:00 ┆ 09:00:00 │ │ 2024-01-02 10:00:00+00:00 ┆ 2024-01-02 ┆ 0:05:00 ┆ 10:00:00 │ │ 2024-01-03 11:00:00+00:00 ┆ 2024-01-03 ┆ 0:10:00 ┆ 11:00:00 │ │ 2024-01-04 12:00:00+00:00 ┆ 2024-01-04 ┆ 0:15:00 ┆ 12:00:00 │ │ 2024-01-05 13:00:00+00:00 ┆ 2024-01-05 ┆ 0:20:00 ┆ 13:00:00 │ │ 2024-01-06 14:00:00+00:00 ┆ 2024-01-06 ┆ 0:25:00 ┆ 14:00:00 │ │ 2024-01-07 15:00:00+00:00 ┆ 2024-01-07 ┆ 0:30:00 ┆ 15:00:00 │ │ 2024-01-08 16:00:00+00:00 ┆ 2024-01-08 ┆ 0:35:00 ┆ 16:00:00 │ └───────────────────────────┴─────────────┴──────────┴───────────┘