Tables and Data Operations
Create and manage tables, insert, update and delete data, and filter and select rows with where(), select() and order_by().
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.
Tutorials · Notebook · Updated
Colab runs it in your browser. If it calls a model provider, it asks for that provider's API key in a cell.
pip install torch transformers timm openai pixeltable
OPENAI_API_KEYhuggingface.detr_for_object_detection()openai.chat_completions()pxt.create_table()@pxt.udfinsert()add_computed_column()from pixeltable.functions import huggingfacet.add_computed_column(detections=huggingface.detr_for_object_detection(t.input_image, model_id='facebook/detr-resnet-50'))
One cell of the notebook, copied as it is. Open it in Colab for the rest.
Create and manage tables, insert, update and delete data, and filter and select rows with where(), select() and order_by().
This guide introduces one of Pixeltable's most essential and powerful concepts: computed columns.
Expressions are the basic building blocks of 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.