---
title: "Find Row"
description: "Local-first visual environment for building and running AI workflows. Build agents visually, deploy anywhere, privacy by design."
canonical: https://docs.nodetool.ai/nodes/nodetool/data/findrow
markdown: https://docs.nodetool.ai/nodes/nodetool/data/findrow.md
product: NodeTool
source: https://github.com/nodetool-ai/nodetool/blob/main/docs/nodes/nodetool/data/findrow.md
---

# Find Row

**Type:** `nodetool.data.FindRow`

**Namespace:** `nodetool.data`

## Description

Find the first row in a dataframe that matches a given condition.
    filter, query, condition, single row

    Example conditions:
    age > 30
    age > 30 and salary < 50000
    name == 'John Doe'
    100 <= price <= 200
    status in ['Active', 'Pending']
    not (age < 18)

    Use cases:
    - Retrieve specific record based on criteria
    - Find first occurrence of a particular condition
    - Extract single data point for further analysis

## Properties

| Property | Type | Description | Default |
|----------|------|-------------|---------|
| df | `dataframe` | The DataFrame to search. | `{"type":"dataframe","uri":"","asset_id":null,"d...` |
| condition | `str` | The condition to filter the DataFrame, e.g. 'column_name == value'. | `` |

## Outputs

| Output | Type | Description |
|--------|------|-------------|
| output | `dataframe` |  |

## Related Nodes

Browse other nodes in the [nodetool.data](./) namespace.