PixeltablePixeltable Logo

Queries and Expressions

Expressions are the basic building blocks of Pixeltable.

Tutorials · Notebook · Updated

Open in ColabRead in the docsView on GitHub

Colab runs it in your browser. If it calls a model provider, it asks for that provider's API key in a cell.

What it uses

Install
terminal
pip install pixeltable datasets torch transformers
Pixeltable calls
huggingface.vit_for_image_classification()huggingface.clip()pxt.create_table()add_computed_column()

A look at the code

queries-and-expressions.ipynb
from pixeltable.functions.huggingface import vit_for_image_classification


t.add_computed_column(
    classification=vit_for_image_classification(
        t.image, model_id='farleyknight-org-username/vit-base-mnist'
    )
)

One cell of the notebook, copied as it is. Open it in Colab for the rest.

More in Tutorials

Browse all 103

  • UDFs in Pixeltable

    Pixeltable comes with a library of built-in functions and integrations, but sooner or later, you'll want to introduce some customized logic into your workflow.

    Updated Open in Colab

  • Embedding Indices

    Create an embedding index, query it with similarity search and keep it current as data changes. Covers several indexes on one column, custom embedding UDFs and precomputed embeddings.

    Updated Open in Colab

  • External Files

    In Pixeltable, all media data (videos, images, audio) resides in external files, and Pixeltable stores references to those.

    Updated Open in Colab

  • 10-Minute Tour

    Welcome to Pixeltable! In this tutorial, we'll survey how to create tables, populate them with data, and enhance them with built-in and user-defined transformations and AI operations.

    Updated Open in Colab