Is your feature request related to a problem?

A Table can already be transformed by calling transform_table or transform_column. It would be nice to have this capability on a Column too.

Desired solution

• Add a method transform to Column:

class Column(Sequence[_T]):
    def transform(self, transformer: Callable[[_T], _O]) -> Column[_O]:
        ...

• Map transformer over the values of the column and collect the results
• As usual, it should not change the receiving instance but return a new Column.

Possible alternatives (optional)

No response

Screenshots (optional)

No response

Additional Context (optional)

The apply function of pandas could be useful here.