class pixeltable.ResultSet

A dataset obtained by executing a Query. Returned by Query.collect(), Query.head(), Query.tail(), and the equivalent methods on class Table. A ResultSet is structured as a table with rows (indexed by integers) and columns (indexed by strings). The column names correspond to the expressions in the query’s select list. The values in a ResultSet can be accessed in various ways:

len(result) returns the number of rows
result[i] returns the ith row as a dict mapping column names to values
result['col'] returns a list of all values in the column named 'col'
result[i, 'col'] returns the specific value in the ith row and column 'col'

ResultSet implements the Sequence protocol, so it can be iterated over and converted to other sequence types in the usual fashion; for example:

for row in result (iterates over rows)
list(result) (converts to a list of rows)

method to_pandas()

Signature

to_pandas() -> pd.DataFrame

Convert the ResultSet to a Pandas DataFrame. Returns:

pd.DataFrame: A DataFrame with one column per column in the ResultSet.

method to_pydantic()

Signature

to_pydantic(model: type[BaseModelT]) -> Iterator[BaseModelT]

Convert the ResultSet to Pydantic model instances. Parameters:

model (type[BaseModelT]): A Pydantic model class.

Returns:

Iterator[BaseModelT]: An iterator over Pydantic model instances, one for each row in the result set.

SDK Reference

​class pixeltable.ResultSet

​method to_pandas()

​method to_pydantic()

class pixeltable.ResultSet

method to_pandas()

method to_pydantic()