Is your feature request related to a problem? we use SQL like thi

How about this? <div class="snippet-clipboard-content notranslate position-relativ

Perhaps there's room for an API to make this even more succinct? <div class="snipp

feat: support generating a concat of all columns for ibis table about ibis HOT 3 CLOSED

ruiyang2015 commented on June 9, 2024

feat: support generating a concat of all columns for ibis table

from ibis.

Comments (3)

cpcloud commented on June 9, 2024 3

How about this?

In [29]: from ibis.interactive import *

In [30]: t = ibis.examples.penguins.fetch()

In [31]: t[0].concat(*(t[c].cast("string") for c in t.columns[1:]))
Out[31]:
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ StringConcat()                           ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ string                                   │
├──────────────────────────────────────────┤
│ AdelieTorgersen39.118.71813750male2007   │
│ AdelieTorgersen39.517.41863800female2007 │
│ AdelieTorgersen40.318.01953250female2007 │
│ AdelieTorgersen2007                      │
│ AdelieTorgersen36.719.31933450female2007 │
│ AdelieTorgersen39.320.61903650male2007   │
│ AdelieTorgersen38.917.81813625female2007 │
│ AdelieTorgersen39.219.61954675male2007   │
│ AdelieTorgersen34.118.119334752007       │
│ AdelieTorgersen42.020.219042502007       │
│ …                                        │
└──────────────────────────────────────────┘

from ibis.

lostmygithubaccount commented on June 9, 2024

in the (potential) absence of a direct way to do this in Ibis expressions, I'd recommend using table.sql() to run the existing SQL string directly: https://ibis-project.org/how-to/extending/sql#table.sql

from ibis.

cpcloud commented on June 9, 2024

Perhaps there's room for an API to make this even more succinct?