ibis.expr.api.TableExpr.rowid

TableExpr.rowid()

An autonumeric representing the row number of the results.

It can be 0 or 1 indexed depending on the backend. Check the backend documentation.

Note that this is different from the window function row number (even if they are conceptually the same), and different from row id in backends where it represents the physical location (e.g. Oracle or PostgreSQL’s ctid).

Returns

Return type

ir.IntegerColumn

Examples

>>> my_table[my_table.rowid(), my_table.name].execute()
1|Ibis
2|pandas
3|Dask