tabsdata.tableframe.selectors.date

date() → SelectorProxy

Select all columns of date data type.

This selector matches columns that store calendar dates without time information.

Example

>>> import tabsdata.tableframe as td_tf
>>> from datetime import datetime, timezone, timedelta
>>>
>>> tf = td_tf.TableFrame({
...     "TimestampUTC": [
...         datetime(2024, 1, 1, tzinfo=timezone.utc),
...         datetime(2024, 1, 2, tzinfo=timezone.utc),
...         datetime(2024, 1, 3, tzinfo=timezone.utc),
...         datetime(2024, 1, 4, tzinfo=timezone.utc),
...         datetime(2024, 1, 5, tzinfo=timezone.utc),
...         datetime(2024, 1, 6, tzinfo=timezone.utc),
...         datetime(2024, 1, 7, tzinfo=timezone.utc),
...         datetime(2024, 1, 8, tzinfo=timezone.utc),
...     ],
...     "Event": ["A", "B", "C", "D", "E", "F", "G", "H"],
...     "TimestampLocal": [
...         datetime(2024, 1, 1, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 2, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 3, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 4, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 5, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 6, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 7, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...         datetime(2024, 1, 8, 1, 0, tzinfo=timezone(timedelta(hours=1))),
...     ]
... })

Original: ┌──────┬────────────┬───────┐ │ User ┆ JoinDate ┆ Score │ ├──────┼────────────┼───────┤ │ “A” ┆ 2023-01-01 ┆ 90 │ │ “B” ┆ 2023-01-02 ┆ 85 │ │ “C” ┆ 2023-01-03 ┆ 92 │ │ “D” ┆ 2023-01-04 ┆ 88 │ │ “E” ┆ 2023-01-05 ┆ 87 │ │ “F” ┆ 2023-01-06 ┆ 91 │ │ “G” ┆ 2023-01-07 ┆ 89 │ │ “H” ┆ 2023-01-08 ┆ 86 │ └──────┴────────────┴───────┘

>>> tf.select(td_tf.selectors.date())

Selected: ┌────────────┐ │ JoinDate │ ├────────────┤ │ 2023-01-01 │ │ 2023-01-02 │ │ 2023-01-03 │ │ 2023-01-04 │ │ 2023-01-05 │ │ 2023-01-06 │ │ 2023-01-07 │ │ 2023-01-08 │ └────────────┘