collect

collect(expr, *, limit=None)

Materialize an Ibis expression to a pandas DataFrame.

This is the only function (with compute and Result.collect) that triggers execution. Scalar expressions (e.g. table.count()) are returned as a 1x1 DataFrame.

Parameters

Name	Type	Description	Default
expr	Any	Ibis table or scalar expression to execute.	required
limit	int or None	If set, apply .limit(limit) before executing.	None

Returns

Name	Type	Description
	pandas.DataFrame	Materialized result (table rows or 1x1 for scalars).