PixeltablePixeltable Logo

Computed Columns

This guide introduces one of Pixeltable's most essential and powerful concepts: computed columns.

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 torch transformers timm
Pixeltable calls
huggingface.detr_for_object_detection()vision.bboxes_draw()pxt.create_table()add_computed_column()insert()

A look at the code

computed-columns.ipynb
pop_t.add_computed_column(
    yoy_percent_change=(100 * pop_t.yoy_change / pop_t.pop_2022)
)

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