---
title: PipelineBuilder
seo:
  title: PipelineBuilder — Python SDK
---

## where()

```python
def where(filter) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `filter` | `Filter` | - | |

### Returns

`'PipelineBuilder'`

***

## pick()

```python
def pick(*, by=None, n=None, per=None, reverse=None) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `by?` | `Optional[str]` | `None` | |
| `n?` | `Optional[int]` | `None` | |
| `per?` | `Optional[str]` | `None` | |
| `reverse?` | `Optional[bool]` | `None` | |

### Returns

`'PipelineBuilder'`

***

## derive()

```python
def derive(cols) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `cols` | `Mapping[str, Any]` | - | |

### Returns

`'PipelineBuilder'`

***

## summarize()

```python
def summarize(aggs, *, by=None) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `aggs` | `Mapping[str, Any]` | - | |
| `by?` | `Any` | `None` | |

### Returns

`'PipelineBuilder'`

***

## sort()

```python
def sort(by) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `by` | `str` | - | |

### Returns

`'PipelineBuilder'`

***

## take()

```python
def take(n, offset=None) -> 'PipelineBuilder':
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `n` | `int` | - | |
| `offset?` | `Optional[int]` | `None` | |

### Returns

`'PipelineBuilder'`

***

## chart()

```python
def chart(*, chart_type, title, x_axis, y_axis, series_by=None, description=None) -> JsonObject:
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `chart_type` | `ChartType` | - | |
| `title` | `str` | - | |
| `x_axis` | `PresentationField` | - | |
| `y_axis` | `PresentationField` | - | |
| `series_by?` | `Optional[PresentationField]` | `None` | |
| `description?` | `Optional[str]` | `None` | |

### Returns

`JsonObject`

***

## table()

```python
def table(*, title, columns, description=None) -> JsonObject:
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `title` | `str` | - | |
| `columns` | `Sequence[PresentationField]` | - | |
| `description?` | `Optional[str]` | `None` | |

### Returns

`JsonObject`

***

## to\_json()

```python
def to_json() -> JsonObject:
```

### Returns

`JsonObject`

***

## \_\_init\_\_()

```python
def __init__(_spec, _stages) -> None:
```

### Parameters

| Prop | Type | Default | Description |
| - | - | - | - |
| `_spec` | `JsonObject` | - | |
| `_stages` | `tuple[JsonObject, ...]` | - | |

### Returns

`None`