TableFrame.unique

methodView source ↗

def unique(
    subset: td_ColumnNameOrSelector | Collection[td_ColumnNameOrSelector] | None = None,
    keep: td_UniqueKeepStrategy = 'any',
    maintain_order: bool = False,
) -> TableFrame

Categories: filters

Deduplicate rows from the TableFrame.

Parameters

parameter

subset

Columns to evaluate for duplicate values. If None, all columns are considered.

parameter

keep

Strategy to keep duplicates: first, last, any, none ( eliminate duplicate rows).

parameter

maintain_order

Preserve the order of the rows.

Examples

>>> import tabsdata as td
>>>
>>> tf: td.TableFrame ...
>>>
┌──────┬──────┐
│ a    ┆ b    │
│ ---  ┆ ---  │
│ str  ┆ i64  │
╞══════╪══════╡
│ A    ┆ 1    │
│ X    ┆ 10   │
│ C    ┆ 3    │
│ D    ┆ 5    │
│ M    ┆ 9    │
│ A    ┆ 100  │
│ M    ┆ 50   │
│ null ┆ 20   │
│ F    ┆ null │
└──────┴──────┘
>>>
>>> tf.unique("a", keep="last")
>>>
┌──────┬──────┐
│ a    ┆ b    │
│ ---  ┆ ---  │
│ str  ┆ i64  │
╞══════╪══════╡
│ D    ┆ 5    │
│ C    ┆ 3    │
│ X    ┆ 10   │
│ A    ┆ 100  │
│ M    ┆ 50   │
│ F    ┆ null │
│ null ┆ 20   │
└──────┴──────┘