---
title: "Tables and Data Operations"
description: "Create and manage tables, insert, update and delete data, and filter and select rows with where(), select() and order_by()."
url: "https://www.pixeltable.com/notebooks/tables-and-data-operations"
updated: "2026-10-28"
---

# Tables and Data Operations

Create and manage tables, insert, update and delete data, and filter and select rows with where(), select() and order_by().

- **Type:** Notebook
- **Group:** Tutorials

## What it covers

- Create and manage tables: Understand Pixeltable's table structure, create and modify tables, and work with table schemas
- Manipulate data: Insert, update, and delete data within tables, and retrieve data from tables into Python variables
- Filter and select data: Use where(), select(), and order_by() to query for specific rows and columns
- Import data from CSV files and other file types

## What it uses

- **Install:** `pip install pixeltable`
- **Pixeltable calls:** `pxt.create_table()`, `insert()`, `add_column()`, `update()`, `revert()`

## A look at the code

```python
films_t = pxt.create_table(
    'fundamentals/films',
    {'film_name': pxt.String, 'year': pxt.Int, 'revenue': pxt.Float},
)
```

## Open it

- **Open in Colab:** https://colab.research.google.com/github/pixeltable/pixeltable/blob/release/docs/release/tutorials/tables-and-data-operations.ipynb
- **Docs page:** https://docs.pixeltable.com/tutorials/tables-and-data-operations
- **Source on GitHub:** https://github.com/pixeltable/pixeltable/blob/release/docs/release/tutorials/tables-and-data-operations.ipynb