Get substring of column value

[vmsaipreeth]

Hi Team, let’s say I have a ibis data frame. In which, Column1 has [‘ABC’], [‘XY’, ‘ABCD’] values

I want a new column to be created with following values:

Column2 with ABC, XY-ABCD

How simply can I do it with ibis data frames? I am using trino as my backend.

[gforsyth]

You can use join on an array of strings:

[ins] In [7]: t
Out[7]: 
┏━━━━━━━━━━━━━━━━━━━━━━┓
┃ a                    ┃
┡━━━━━━━━━━━━━━━━━━━━━━┩
│ array<string>        │
├──────────────────────┤
│ ['xy', 'abcd']       │
│ ['abc']              │
└──────────────────────┘

[ins] In [8]: t.mutate(concat_col=t.a.join("-"))
Out[8]: 
┏━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ a                    ┃ concat_col ┃
┡━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ array<string>        │ string     │
├──────────────────────┼────────────┤
│ ['xy', 'abcd']       │ xy-abcd    │
│ ['abc']              │ abc        │
└──────────────────────┴────────────┘

[vmsaipreeth]

Thank you @gforsyth
This was helpful.