how to concat strings in a group_by operation

[Arengard]

how to concat string into an array of [unique] strings in a group_by operation???

[cpcloud]

Hi @Arengard 👋🏻!

Love the enthusiasm!!!

You can use the .collect() method of Arrays to do the non-unique version:

In [7]: from ibis.interactive import *

In [8]: t = ex.diamonds.fetch()

In [9]: t.group_by("color").agg(cuts=_.cut.collect())
Out[9]:
┏━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ color  ┃ cuts                                  ┃
┡━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ string │ array<string>                         │
├────────┼───────────────────────────────────────┤
│ E      │ ['Ideal', 'Premium', ... +9795]       │
│ I      │ ['Premium', 'Very Good', ... +5420]   │
│ J      │ ['Good', 'Very Good', ... +2806]      │
│ H      │ ['Very Good', 'Very Good', ... +8302] │
│ F      │ ['Premium', 'Very Good', ... +9540]   │
│ G      │ ['Very Good', 'Ideal', ... +11290]    │
│ D      │ ['Very Good', 'Very Good', ... +6773] │
└────────┴───────────────────────────────────────┘

We don't currently have an API for collecting unique values, but we could certainly add that if that's something you're interested in!